APSC database is empty after failed Plesk installation

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:05:36 UTC

Modified:

2016-12-21 19:56:17 UTC

0

Was this article helpful?


Have more questions?

Submit a request

APSC database is empty after failed Plesk installation

Symptoms

APSC database is empty after failed Plesk installation.

Cause

Failed Plesk upgrade or installation.

Resolution

  1. Create dumps of psa and apsc databases:

    mysqldump -uadmin -p` cat /etc/psa/.psa.shadow ` apsc > /tmp/apsc.`date +%F`
    mysqldump -uadmin -p` cat /etc/psa/.psa.shadow ` psa > /tmp/psa.`date +%F`
  2. Create apsc database:

    mysql -uadmin -p` cat /etc/psa/.psa.shadow ` apsc < /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/db/apsc_mysql_db.sql
  3. Register apsc database in Plesk:

    #  /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/scripts/register_apsc_database.php --register -host localhost -port 3306 -database apsc -login apsc -password "********"

where " * *" is some complicated password.

  1. Update password for 'apsc' user in mysql database:
    mysql -uadmin -p` cat /etc/psa/.psa.shadow ` mysql
    mysql> update mysql.user set password=password("*******") where user='apsc';
    Query OK, 0 rows affected (0.00 sec)

Password should be the same as on previous step.

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