APSC database is empty after failed Plesk installation

Created:

2016-11-16 13:05:36 UTC

Modified:

2017-04-24 11:58:00 UTC

0

Was this article helpful?


Have more questions?

Submit a request

APSC database is empty after failed Plesk installation

Applicable to:

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

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.