Unable to access Plesk: Unknown database 'psa'

[mahesh]

Symptoms
Plesk is not accessible with the following error messages in a web-browser:

Code Select Expand

Unknown database 'psa'
Cause
The Plesk system database psa is missing.

Resolution
Restore the psa database from a daily dump:

For Plesk on Linux


1.Connect to the Plesk server via SSH.

2.Switch to the directory with daily dumps:

Code Select Expand

#cd /var/lib/psa/dumps
3.Find the most recent dump that contains the psa database:

Code Select Expand

#zgrep "Current Database:" mysql.daily* | grep psa
mysql.daily.dump.0.gz:-- Current Database: `psa`
mysql.daily.dump.1.gz:-- Current Database: `psa`
mysql.daily.dump.2.gz:-- Current Database: `psa`
mysql.daily.dump.3.gz:-- Current Database: `psa`
...

• where mysql.daily.dump.0.gz is the most recent daily dump.

4.Restore the psa database from the most recent daily dump. In this example, the psa database is restored from mysql.daily.dump.0.gz:

Code Select Expand

#zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin
5.Open Plesk in a web-browser.

For Plesk on Windows Server


1.Connect to the Plesk server via RDP.

2.Start a command prompt as an Administrator.

3.Connect to MySQL:

Note: MySQL admin password is required for this operation. In Plesk Onyx 17.8 and later, retrieve the password with the command plesk sbin psadb --get-admin-password.

Code Select Expand

c:\>"%plesk_dir%\Mysql\bin\mysql.exe" apsc -uadmin -p -P8306
4.Once connected, create a new database with the name psa:

Code Select Expand

mysql> create database psa;
5.Exit MySQL:

Code Select Expand

mysql> quit
6.Switch to the directory with daily dumps:

Code Select Expand

c:\>cd %plesk_dir%Mysql\Backup
7.List a name of a Plesk dump with the psa database:

Code Select Expand

c:\>dir psa*
...
Directory of C:\Program Files (x86)\Plesk\MySQL\Backup

03/27/2019 08:33 PM 468,888 psa-20181018020721.sql
8.Restore the psa database using the dump file name from the previous step:

Note: MySQL admin password is required for this operation.

Code Select Expand

c:\>"%plesk_dir%"\Mysql\bin\mysql.exe -uadmin -p -P8306 psa < psa-20181018020721.sql
9.Open Plesk in a web-browser.