Unable to access subscription: Database server does not exist

Created:

2016-11-16 13:21:28 UTC

Modified:

2017-04-24 11:38:12 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to access subscription: Database server does not exist

Applicable to:

  • Plesk for Windows
  • Plesk 12.5 for Windows

Symptoms

Unable to access subscription in Plesk. The following error is shown:

ERR_TOO_MANY_REDIRECTS

This error message can be also found in Plesk interface or in php_error.log :

Database server does not exist

Cause

Incorrect mappings between DatabaseServers.id and db_users.db_server_id & data_bases.db_server_id

Resolution

  1. Create database backup according to KB881

  2. Check the ids of present database servers:

    mysql> select id,host,type from databaseservers;
    +----+-------------------+-------+
    | id | host | type |
    +----+-------------------+-------+
    | 2 | .\\MSSQLSERVER2012 | mssql |
    | 7 | localhost | mysql |
    +----+-------------------+-------+
    2 rows in set (0.00 sec)
  3. Make sure that the same ids are listed in db_users.db_server_id & data_bases.db_server_id tables:

    mysql> select id,name, dom_id,db_server_id, type from data_bases;
    +-----+------------------------+--------+--------------+-------+
    | id | name | dom_id | db_server_id | type |
    +-----+------------------------+--------+--------------+-------+
    | 14 | wordpress_11 | 48 | 2 | mssql |
    | 81 | sistema | 47 | 2 | mssql |
    | 101 | joomla_33 | 38 | 7 | mysql |
    | 102 | wordpress_51 | 75 | 6 | mysql | <---- non-existent id
    | 103 | website_db1 | 41 | 7 | mysql |
    +-----+------------------------+--------+--------------+-------+

    mysql> select id,db_server_id from db_users;
    +----+--------------+
    | id | db_server_id |
    +----+--------------+
    | 71 | 2 |
    | 11 | 2 |
    | 82 | 7 |
    | 85 | 6 | <---- non-existent id
    | 86 | 7 |
    +----+--------------+
  4. Make sure that this database exists on MySQL server and update the values:

    mysql> update data_bases set db_server_id=7 where id=102;
    mysql> update db_users set db_server_id=7 where id=85;
Have more questions? Submit a request
Please sign in to leave a comment.