Older Plesk Versions - Upgrading phpMyAdmin to version 3.4.10.2 on Parallels Plesk Panel for Linux 10.0.x

Created:

2016-11-16 13:03:47 UTC

Modified:

2017-08-16 16:43:53 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Older Plesk Versions - Upgrading phpMyAdmin to version 3.4.10.2 on Parallels Plesk Panel for Linux 10.0.x

Applicable to:

  • Plesk 11.x for Linux

Symptoms

The Parallels Plesk Panel (PP) Service Team has prepared a script for a phpMyAdmin upgrade to the 3.4.10.2 version with all security updates. This script can be used on servers where PP for Linux version 10.0.x is installed.

Note: If you perform a PP upgrade to a version below 11.0.9, the old phpMyAdmin version will be installed again. Therefore, we recommend upgrading to the latest available PP version or performing the phpMyAdmin upgrade again as it is described below.

Requirements

MySQL 5.0.15 or a later version is required for phpMyAdmin 3.4.10.2.

Resolution

  1. Create a backup of the current phpMyAdmin version:

     # DUMP_D=`cat /etc/psa/psa.conf | grep DUMP_D| head -1 | awk {'print $2'}

    # mkdir $DUMP_D/Old_phpMyAdmin
    # PRODUCT_ROOT_D=`cat /etc/psa/psa.conf | grep PRODUCT_ROOT_D | head -1 | awk {'print $2'}`
    # cp -r $PRODUCT_ROOT_D/admin/htdocs/domains/databases/phpMyAdmin $PRODUCT_ROOT_D/admin/htdocs/domains/databases/db_edit.php3 $PRODUCT_ROOT_D/admin/htdocs/server/db_server_databases.php $PRODUCT_ROOT_D/admin/htdocs/server/db_servers.php $DUMP_D/Old_phpMyAdmin/
    # PHPMYADMINDB=` MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -uadmin -e 'show databases like "phpmyadmin%"' | tail -1`
    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin $PHPMYADMINDB > $DUMP_D/Old_phpMyAdmin/phpmyadmin_db.dump`
  2. Download the archive with the new version of phpMyAdmin (md5sum e8f440d6a59d697b4a8bc66c2bd15c0c for file phpmyadmin_3_4_10.tar.gz) and the installation script (md5sum a0fe1bdf6fb9e837ccc9b9425a556022for file pma101_install.sh):

    # cd /usr/local/psa/var/
    # wget https://support.plesk.com/hc/article_attachments/115004544629/phpmyadmin_3_4_10.tar.gz
    # wget https://support.plesk.com/hc/article_attachments/115004544649/pma101_install.sh
  3. Run the installation script for phpMyAdmin 3.4.10.2:

    # chmod u+x pma101_install.sh
    # ./pma101_install.sh
    Trying to start service mysql... Rather than invoking init scripts through /etc/init.d, use the service(8)
    utility, e.g. service mysql status

    Since the script you are attempting to invoke has been converted to an
    Upstart job, you may also use the status(8) utility, e.g. status mysql
    mysql start/running, process 13925
    done
     Trying to establish test connection... connected
    done
     Trying to remove old phpmyadmin directory... done
     Trying to unpack new phpmyadmin version... done
     Trying to set permissions... done
     Trying to create pmadb... done
    Restarting SWsoft control panels server... stale pidfile. ok

Additional information

For other PP versions, phpMyAdmin can be upgraded with the help of thefollowing articles:

Older PP Versions - Upgrading phpMyAdmin to version 3.4.10.2 on PP for Linux 8.6/9.x

Older PP Versions - Upgrading phpMyAdmin to version 3.4.10.2 on PP for Linux 10.1.x

Older PP Versions - Upgrading phpMyAdmin to version 3.4.10.2 on PP for Linux 10.2/10.3.x/10.4.x

Attachments:

Have more questions? Submit a request
Please sign in to leave a comment.