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

Created:

2016-11-16 13:16:01 UTC

Modified:

2017-05-15 18:49:47 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 11.0 for Linux

Automatic import from KB #114376

Symptoms

The Parallels Plesk Panel (PP) Service Team has prepared a script to upgrade phpMyAdmin to version 3.4.10.2 with all of the security updates. This script can be used on servers where Parallels Plesk Panel for Linux version 8.6.0-9.5.4 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 6da14c7943be7fe05dc4d436014417a5 for file phpmyadmin_3_4_10.tar.gz) and the installation script (md5sum 35fcdaf46e14d1ff589eb619a6adee8c for file pma_install.sh):

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

    # chmod +x pma_install.sh
    # ./pma_install.sh
    Trying to start service mysql... /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486
    Copyright (C) 2000-2006 MySQL AB
    This software comes with ABSOLUTELY NO WARRANTY. This is free software,
    and you are welcome to modify and redistribute it under the GPL license

    Server version 5.0.51a-24+lenny5
    Protocol version 10
    Connection Localhost via UNIX socket
    UNIX socket /var/run/mysqld/mysqld.sock
    Uptime: 1 hour 50 min 29 sec

    Threads: 1 Questions: 19642 Slow queries: 0 Opens: 1942 Flush tables: 2 Open tables: 64 Queries per second avg: 2.963.
    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

Additional information

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

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

Older Parallels Plesk Panel Versions - Upgrade phpMyAdmin to version 3.4.10.2 on Parallels Plesk Panel for Linux 10.1.x

Older Parallels Plesk Panel Versions - Upgrade phpMyAdmin to version 3.4.10.2 on Parallels Plesk Panel for Linux 10.2/10.3.x/10.4.x

Attachments:

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