phpmyadmin.sh Addon

The Centmin Mod Addon for phpmyadmin auto installation, phpmyadmin.sh has been in beta status for a while now with instructions at Addon phpmyadmin.sh - CentminMod.com LEMP Nginx web stack for CentOS.

This thread is for feedback for this phpmyadmin installer.

Background:

There are many ways to configure and install phpmyadmin from phpmyadmin.net documentation with Nginx. Some not as secure as other methods. It's one of reason I have yet to include it in Centmin Mod.

To be able to include phpmyadmin.sh auto installer as a Centmin Mod official Add On, it will have to be locked down tight:

1. behind SSL and only accesible via https://
2. password protected directory
3. randomised directory install path unique to each Centmin Mod installation
4. separate php-fpm pool with different user
5. deny all access with only 127.0.0.1 and your ISP ip address allowed access
6. auto updatable phpmyadmin

phpmyadmin.sh 0.1.6 Update March 14, 2019

You can check your existing /usr/local/src/centminmod/addons/phpmyadmin.sh version via command

Code (Text):

grep -w VER /usr/local/src/centminmod/addons/phpmyadmin.sh

example

Code (Text):

grep -w VER /usr/local/src/centminmod/addons/phpmyadmin.sh
VER='0.1.2'

phpmyadmin.sh addon installs phpmyadmin via git so it can do update updates via git pull. However, phpmyadmin git stable branch is now 4.7.0. phpyadmin 4.7.0 requires composer so the updated phpmyadmin.sh 0.1.0 script does a local composer.phar install to phpmyadmin git cloned directory for the required composer updates to missing files like "./vendor/autoload.php missing" as seen at PHPMYADMIN File ./vendor/autoload.php missing or not readable.

Auto Fix

Easiest way to update is uninstall your existing phpmyadmin install using uninstall script listed at Addon phpmyadmin.sh - CentminMod.com LEMP Nginx web stack for CentOS and then download latest phpmyadmin.sh addon script

Code (Text):

cd /usr/local/src/centminmod/addons
rm -rf phpmyadmin.sh
wget --no-check-certificate https://github.com/centminmod/phpmyadmin/raw/master/phpmyadmin.sh

and then reinstall phpmyadmin.sh as per instructions at Addon phpmyadmin.sh - CentminMod.com LEMP Nginx web stack for CentOS

Manual Fix

If you don't want to uninstall, you can manually update your phpmyadmin install to the new requirements. Using below steps.

Step 1. If your phpmyadmin install is at say /usr/local/nginx/html/2040_mysqladmin14941 go into that directory and type these commands

Code (Text):

cd /usr/local/nginx/html/2040_mysqladmin14941
git pull
rm -rf composer.phar
wget -cnv https://getcomposer.org/composer.phar -O composer.phar
php composer.phar update --no-dev

Step 2. Edit the phpmyadmin_update.sh script at /root/tools/phpmyadmin_update.sh, edit /root/tools/phpmyadmin_update.sh and add after the git pull line, these 3 additional lines

Code (Text):

git pull
rm -rf composer.phar
wget -cnv https://getcomposer.org/composer.phar -O composer.phar
php composer.phar update --no-dev

Then restart nginx and php services

Code (Text):

nprestart

---

phpmyadmin 4.7.0 release notes

/tmp/phpfpm_myadmin.sock Errors Fix

If you get errrors due to unix:/tmp/phpfpm_myadmin.sock with phpmyadmin installed via phpmyadmin.sh like

Code (Text):

connect() to unix:/tmp/phpfpm_myadmin.sock failed (2: No such file or directory) while connecting to upstream

Then it's due to 123.09beta01 updated php-fpm default config so phpmyadmin's php-fpm pool needs to switch over to using TCP instead of unix sockets.

The fix is to:

1. uninstall existing phpmyadmin install made via phpmyadmin.sh by running uninstaller

Code (Text):

/root/tools/phpmyadmin_uninstall.sh

2. download updated phpmyadmin.sh as per Addon phpmyadmin.sh - CentminMod.com LEMP Nginx web stack for CentOS

Code (Text):

cd /usr/local/src/centminmod/addons
wget --no-check-certificate https://github.com/centminmod/phpmyadmin/raw/master/phpmyadmin.sh -O phpmyadmin.sh

3. install phpmyadmin again - the location of install will change as it's randomly generated and unique to each install run

Code (Text):

cd /usr/local/src/centminmod/addons/
./phpmyadmin.sh install

Using Letsencrypt Trusted SSL Certificates and/or Handling HSTS

Read the notes at https://community.centminmod.com/threads/phpmyadmin-sh-addon.27/page-21#post-97403 to understand why using Letsencrypt Trusted SSL certificates may not be a good idea of phpmyadmin's main hostname and if you have HSTS issues.

 

FYI, phpmyadmin.sh addon has it's on Github repo at https://github.com/centminmod/phpmyadmin

 

yeah the Github repo will always have latest version

It did work fine on previous .07 betas, haven't tested specifially for .07 beta 21 but you're welcome to try and provide feedback here

 

Nice read on how to change the default character set before creating databases https://community.centminmod.com/th...db-mysql-default-character-set-collation.398/

 

well you could edit vhost with allow/deny and restart nginx server

Code:

 location ^~ /22531_mysqladmin23762/ {
        include /usr/local/nginx/conf/php_22531_mysqladmin23762.conf;

        auth_basic      "Private Access";
        auth_basic_user_file  /usr/local/nginx/conf/htpassphpmyadmin;
        allow 127.0.0.1;
        deny all;
}

and to re-enable access comment it out and restart nginx

Code:

        #allow 127.0.0.1;
        #deny all;

 

yeah should work for all PHP versions

 

Great to hear

 

yup normal as Vultr leaves setting the initial hostname up to end user Vultr - How to install Centmin Mod on Vultr.com Guide | Centmin Mod Community

so you need to set your hostname for your CentOS server yourself CentOS - Hostname Change

 

you'd need to change your virtual.conf default hostname Nginx vhost as per step 1 at Getting Started with Centmin Mod

 

try uninstalling phpmyadmin.sh Centmin Mod Addon then re-install