Unable to Activate reseller/customer. Database 'database_name' does not exist

Refers to:

  • Plesk

Created:

2016-11-16 12:45:08 UTC

Modified:

2016-12-21 19:07:53 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to Activate reseller/customer. Database 'database_name' does not exist

Symptoms

Unable to Activate reseller/customer, it got failed with error:

Disable database user failed: Database 'database_name' does not exist. Make sure that the name is entered correctly

Cause

Database 'database_name' does not exist on the server, however it is registered in Plesk:

mysql> select * from data_bases where name="database_name";
+------+-------------------+-------+--------+--------------+-----------------+
| id | name | type | dom_id | db_server_id | default_user_id |
+------+-------------------+-------+--------+--------------+-----------------+
| 2063 | database_name | mssql | 2670 | 2 | 2068 |
+------+-------------------+-------+--------+--------------+-----------------+
1 row in set (0.02 sec)

mysql> select * from db_users where id=2068;
+------+--------+------------+-------+--------+
| id | login | account_id | db_id | status |
+------+--------+------------+-------+--------+
| 2068 |db_user | 15169 | 2063 | normal |
+------+--------+------------+-------+--------+
1 row in set (0.03 sec)

Resolution

To resolve the issue follow the steps bellow:

  1. Backup psa database by instructions in KB #213904125

  2. Access plesk database and delete the records about missing database and it's default user from Plesk database:

    mysql> delete from data_bases where name="database_name";
    Query OK, 1 row affected (0.05 sec)

    mysql> delete from db_users where id=2068;
    Query OK, 1 row affected (0.00 sec)
  3. Activate reseller through Plesk GUI or via command line utility:

###For Windows:

    "%plesk_bin%"\\reseller.exe --on reseller_login

###For Linux:

    #/usr/local/psa/bin/reseller --on reseller_login
Have more questions? Submit a request
Please sign in to leave a comment.