Database server id is undefined

Refers to:

  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • MG:727ef9224fb19791b8ce589d103245e2
  • MT:cac39a1c20a102ac74b1a8e797300e1f
  • MG:6fbbcfe0f9b3deef686ba228b4adcc59
  • MT:0710c431aaf796ba3ab4a68658854274

Created:

2016-11-16 13:06:17 UTC

Modified:

2017-02-13 06:36:11 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Database server id is undefined

Symptoms

Database server id is undefined

Cause

Plesk database inconsistency

Resolution

Ensure that required domain database is refer to the appropriate database server in psa.DatabaseServers

mysql> select * from psa.data_bases db  left join psa.DatabaseServers ds on ds.id=db.db_server_id where ds.id is null;
+----+--------+-------+--------+--------------+-----------------+------+------+------+------+-------------+----------------+------------+----------------+---------------+
| id | name | type | dom_id | db_server_id | default_user_id | id | host | port | type | admin_login | admin_password | last_error | server_version | parameters_id |
+----+--------+-------+--------+--------------+-----------------+------+------+------+------+-------------+----------------+------------+----------------+---------------+
| 3 | testdb | mysql | 999 | 99 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+----+--------+-------+--------+--------------+-----------------+------+------+------+------+-------------+----------------+------------+----------------+---------------+
1 row in set (0.00 sec)

As you can see there is no entries in psa.DatabaseServers defined for the domain with id=999 .

You need either register a new database server in Plesk GUI or update db_server_id with proper DatabaseServers.id value.

Have more questions? Submit a request
Please sign in to leave a comment.