Plesk integration with external database server shown as failed

Nelson Leiva

Updated November 03, 2020 20:33

Plesk kb: how-to ABT: Group B

Applicable to:

Plesk server is integrated with external database server;
The connection to the database in Plesk > Tools & Settings > Database Servers is shown as failed;
Another database server with a new IP address is already added connected with Plesk and has several new databases;

The external database server changed its IP address and lost integration with Plesk.

Change integration information from old databases to the new database server

In case the database server with new IP address does not exist in Plesk, create it

Log into Plesk
Navigate to Tools & Settings > Database Servers
Click on Add Database Server, specify the server's type, access details and click on Ok

Modify the Plesk database to use the proper IP address

Connect to the server via SSH or RDP
Create Plesk database backup:

C:\> plesk db dump > psa_backup.sql
Access Plesk database:

C:\> plesk db
Find the required server ID:

MYSQL_WIN: SELECT id,host,type FROM psa.DatabaseServers;
+----+------------------+-------+
| id | host | type |
+----+------------------+-------+
| 1 | localhost | mysql |
| 3 | 203.0.113.2,1433 | mssql |
| 5 | 203.0.113.3,1433 | mssql |
+----+------------------+-------+
3 rows in set (0.00 sec)

Note: In this example, databases and users hosted on the database server with ID 3 will be moved to ID 5.
Use these IDs to change current databases reference:

MYSQL_WIN: UPDATE psa.db_users SET db_server_id = 5 WHERE db_server_id = 3;

MYSQL_WIN: UPDATE psa.data_bases SET db_server_id = 5 WHERE db_server_id = 3;
Verify the connection and database count: Log in to Plesk > Tools & Settings > Database Servers and remove unnecessary connection by selecting it and clicking on Remove.