Unable to open mail account: The user account was not found

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Windows
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows

Created:

2016-11-16 12:55:57 UTC

Modified:

2016-12-21 19:33:59 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to open mail account: The user account was not found

Symptoms

Unable to open mail account properties in Plesk interface:

Error: The user account was not found. This could happen if the user account was removed by someone else while you were changing its settings.

Cause

Database inconsistency: user associated with mail account belongs to other customer or reseller that owns subscription (that mail account belongs to)

Resolution

  1. Login into Plesk database:

  2. Find all the users with discrepancy:

    mysql> select domains.cl_id, domains.name, smb_users.login, smb_users.ownerId from domains, smb_users where domains.name = RIGHT(smb_users.login, LENGTH(smb_users.login) - LOCATE('@', smb_users.login)) and domains.cl_id <> smb_users.ownerId and smb_users.login like '%@%' order by cl_id asc;
    +-------+----------------+----------------------+---------+
    | cl_id | name | login | ownerId |
    +-------+----------------+----------------------+---------+
    | 2 | domaintest.tld | test1@domaintest.tld | 1 |
    +-------+----------------+----------------------+---------+
  3. Correct owner information for such users:

    mysql> update smb_users, domains set smb_users.ownerId = domains.cl_id where domains.name = RIGHT(smb_users.login, LENGTH(smb_users.login) - LOCATE('@',smb_users.login)) and domains.cl_id <> smb_users.ownerId and smb_users.login like '%@%';
Have more questions? Submit a request
Please sign in to leave a comment.