Unable to delete Plesk object: a Client/Domain/Database deleting: "dbUser::delete() : unable to delete account"

Refers to:

  • Plesk 11.5 for Windows

Created:

2016-11-16 13:18:16 UTC

Modified:

2017-02-08 15:00:05 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to delete Plesk object: a Client/Domain/Database deleting: "dbUser::delete() : unable to delete account"

Symptoms

Unable to delete a database, domain or client:

dbUser::delete():unable to delete account
0: /usr/local/psa/admin/plib/DatabaseManager.php:92
DatabaseManager->deleteDatabase(object of type Database)
1: /usr/local/psa/admin/plib/class.PhDomain.php:386
PhDomain->reset(integer '0', boolean true, boolean false)
2: /usr/local/psa/admin/plib/class.BsDomain.php:297
BsDomain->reset(integer '0')
3: /usr/local/psa/admin/plib/class.BsDomain.php:291
BsDomain->delete(integer '0')
4: /usr/local/psa/admin/plib/class.BsDomain.php:530
mdeleteDomains(array)
5: /usr/local/psa/admin/plib/class.Manager.php:353
Manager->removeDomains(array)
6: /usr/local/psa/admin/htdocs/domains/domains.php3:209

Cause

Missing entry in accounts table related to entry in db_users.

Resolution

Locate database users without password:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e 'select dom.name, db.name, d.account_id, d.login, a.password from accounts a right join db_users d on a.id=d.account_id, domains dom, data_bases db where d.db_id=db.id and db.dom_id=dom.id order by password'
+-------------------------+-------------+---------+----------+
| name | name | account_id | login | password |
+-------------------------+-------------+---------+----------+
| domain1.tld | db_name1 | 146 | user1 | NULL |
| domain2.tld | db_name2 | 169 | user2 | pass |
..........

Update the password for those domains with NULL password: Domains > domain1.tld > Databases > db_name1 and set the new password for the Mysql database user (user1).

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