Article ID: 120519, created on Mar 13, 2014, last review on May 9, 2014

  • Applies to:
  • Plesk for Linux/Unix


I am running Plesk 11.5 on the Centos 6. PHPMyAdmin is not available:

The error is:

grep vzcp_proxy /usr/local/psa/admin/logs/panel.log
[12-Mar-2014 03:20:31 Asia/Calcutta] PHP Fatal error:  Call to undefined function in_vzcp_proxy() in /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php on line 40


'psa-phpmyadmin' package has some missing files:

# rpm -V psa-phpmyadmin | grep missing | wc -l

For some reason it was not installed properly.


1.Reinstall the package from Plesk repository:

    # rpm -Uvh --force

NOTE! For the earlier Plesk versions PHPMyAdmin is included to plesk-core package. To repair PHPMyAdmin you will need to reinstall 'plesk-core' package:

rpm -qf /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php

rpm -ivh --force

2.Set the new phpmyadmin database credentials in the configuration file:

2.1. Save the original config.php file:

cp /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php.old

2.2. Find out the new phpmyadmin database name:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "show databases;" | grep phpmyad
phpmyadmin_I79HRgbP8pOw  < ==== new database
phpmyadmin_Wr9ral67zOV4  < ==== old database

2.3. Modify the 'pmadb', 'controluser' and 'controlpass' values in the /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.php

$cfg['Servers'][$i]['pmadb'] = $GLOBALS['db_host'] != 'localhost' ? '' : 'phpmyadmin_I79HRgbP8pOw';
$cfg['Servers'][$i]['controluser'] = $GLOBALS['db_host'] != 'localhost' ? '' : 'pma_I79HRgbP8pOw';
$cfg['Servers'][$i]['controlpass'] = '**************';

2.4. Reset the mysql password for the new 'pma_*' user:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql

mysql> SET PASSWORD FOR 'pma_I79HRgbP8pOw'@localhost = PASSWORD('**************');
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 29d1e90fd304f01e6420fbe60f66f838

Email subscription for changes to this article
Save as PDF