Article ID: 121595, created on May 16, 2014, last review on May 16, 2014

  • Applies to:
  • Plesk 11.5 for Linux


Unable to login to Customer & Business Manager Panel, only while page is shown.

The following error can be observed in the /usr/local/psa/admin/logs/panel.log

[15-May-2014 18:57:01 America/Los_Angeles] PHP Warning:  mysql_pconnect(): Access denied for user 'billing'@'localhost' (using password: YES) in /opt/plesk
-billing/lib/lib-db/core/drivers/ on line 372
[15-May-2014 18:57:01 America/Los_Angeles] PHP Fatal error:  Uncaught exception 'Exception' with message 'Failed to connect to database. Check database con
figuration.' in /opt/plesk-billing/lib/billing-libs/Billing/Manager/DatabaseManager.php:39
Stack trace:
#0 /opt/plesk-billing/lib/lib-tk/include/common.php(179): Billing\Manager\DatabaseManager->getADOConnection()
#1 /opt/plesk-billing/htdocs/admin/index.php(8): require_once('/opt/plesk-bill...')
#2 {main}
  thrown in /opt/plesk-billing/lib/billing-libs/Billing/Manager/DatabaseManager.php on line 39


An access to the Customer & Business Manager Panel billing database for billing user is denied.


  1. Back up databases:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /tmp/psa.`date +%F_%H.%M`.sql
    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` mysql > /tmp/mysql.`date +%F_%H.%M`.sql
    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` billing > /tmp/billing.`date +%F_%H.%M`.sql
  2. Update password:

    2.1. Run the following commands first, replacing the <password> with desired password:

    # export BILLING_DB_PASSWORD=<password>
    # /usr/share/plesk-billing/billing-db --set --host localhost --name billing --user billing --with-password

    2.2. Update password for billing user in mysql.user table, replacing the <password> with the password used in the previous step:

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow ` mysql
    mysql> SET PASSWORD FOR 'billing'@'localhost' = PASSWORD('<password>');
    mysql> flush privileges;
  3. Repair integration:

    # /usr/share/plesk-billing/integration --command repair-all

Search Words

whilte page

unable to login to billing

unable to login to CBM


Access denied for user 'billing'@'localhost'

Failed to connect to database

Access denied for user 'billing'@'localhost' (using password: YES)

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF