APSC database is empty after failed Plesk installation

[jominj]

Some times we will get into a scenario like this, APSC database is empty after failed Plesk installation.

1. Create dumps of psa and apsc databases:

Code: [Select]

mysqldump -uadmin -p` cat /etc/psa/.psa.shadow ` apsc > /tmp/apsc.sql
mysqldump -uadmin -p` cat /etc/psa/.psa.shadow ` psa > /tmp/psa.sql
2. Create apsc database:

Code: [Select]

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:

Code: [Select]

#  /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 "********"password should be complicated.
4. Update password for 'apsc' user in mysql database:

Code: [Select]

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 must be same as on the previous step.