Plesk is not available: Unknown database ‘apsc’

Dmitry Bystrov

10 months ago

Symptoms

Plesk shows on of the following errors:

ERR [panel] Exception: ODBC error #HY000: [unixODBC][MySQL][ODBC 5.3(w) Driver]Unknown database 'apsc'
file: /usr/share/aps_php/aps_php.php
line: 11933
code: 0

New files of configuration for Apache web server were not built due to errors in configuration templates:
Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = [unixODBC][MySQL][ODBC 3.51 Driver]Unknown database 'apsc'.
Provisioning subscription from OBAS to Plesk may fail with the following error on OBAS side:

Process provisioning for document; Error occurred while fetching components list and network settings from Plesk node: Failed to get Site Applications from Plesk Node.
Migration may fail with the following error:

An error occurred during importing package: ODBC error #HY000: [unixODBC][MySQL][ODBC 5.1 Driver]Access denied for user 'psaadm'@'localhost' (using password: NO)
Tools & Settings > Diagnose & Repair shows:

Connection to APSC DB is not possible: ODBC error #42S02: [ma-3.0.8][10.1.44-MariaDB-0ubuntu0.18.04.1]Table 'apsc.aps_package' doesn't exist
The backup operations finish with the same error.

APS Controller database apsc does not exist on the server.

There are 3 ways to restore apsc database:

Find the latest apsc database backup and restore it as described in the article here. For example:

Find the latest backup:

# ls -lt /var/lib/psa/dumps/ | grep apsc | head -1
-rw------- 1 root root 4118 Mar 6 02:02 mysql.preupgrade.apsc.17.8.11-17.8.11.20181210-052236.dump.gz
Unpack the archive with the backup:

# gunzip /var/lib/psa/dumps/mysql.preupgrade.apsc.17.8.11-17.8.11.20181210-052236.dump.gz
Restore the database from the backup:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -f -uadmin apsc < /var/lib/psa/dumps/mysql.preupgrade.apsc.17.8.11-17.8.11.20181210-052236.dump

If there are no backups of the database found in /var/lib/psa/dumps/, repair database with bootstrapper.sh script:

# /usr/local/psa/bootstrapper/ppXX.X.XX-bootstrapper/bootstrapper.sh repair

Note: Change XX.X.XX to comply with the current Plesk version installed.

In case the above solution does not work, create an empty apsc database and register it in Plesk using secure password:

Create the database:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin -e"CREATE DATABASE apsc"
Upload the default data from scheme:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin apsc < /usr/local/psa/bootstrapper/ppXX.X.XX-bootstrapper/db/apsc_mysql_db.sql

Note: Change XX.X.XX to comply with the current Plesk version installed.
Register the database:

# /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 "****"

0 Shares