Mail accounts errors - account exist or not in server?

[MiguelK]

Hello,

I am trying to manage an mail account for a client in Plesk GUI.
Since the mail account don't appear in the list, I have tryed to create it.
But when I try, the server tells me that the mail account already exists. (but dont't appear on the list)

So, I go to SSH (PuTTY) and do this:
"server:/usr/local/psa/bin # ./mail --create user@domain.com -passwd xXxXxXxXx -mbox_quota 100M
An error occured during mailname creation: Mail account user@domain.com already exists in this domain.
turbineseusite:/usr/local/psa/bin # ./mail --remove user@domain.com
Object not found: Mail account user"

How is that happening?
What is this problem?

And more important: how to solve it?

Thank you in advance,

Miguel Koscianski Vidal

 

[Andrey Kucherov]

Hello,

You can login to the database and perform the following queries in order to troubleshoot the issue:

===

mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

# * Get duplicate mailnames - i.e. mailnames on different domains that have the same login AND password.

SELECT m.mail_name, a.password, COUNT(*) AS num FROM mail m, accounts a WHERE m.account_id=a.id AND a.type='plain' AND a.password != "" GROUP BY m.mail_name, a.password having num > 1;

# * Get all mailnames with their passwords that belong to domain.tld:

SELECT d.name, m.mail_name, a.password FROM domains d, accounts a, mail m WHERE d.id=m.dom_id AND m.account_id=a.id AND d.name='domain.tld';

===

 

[Nataliya Zagr]

Hello,

Please, log into the Parallels Plesk Panel (PP) database, and check if the mail name exists in it:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

mysql> select m.mail_name,d.name as domain_name from mail m,domains d where m.dom_id=d.id and m.mail_name like 'test' and d.name like 'test.com';
+-----------+-------------+
| mail_name | domain_name |
+-----------+-------------+
| test | test.com |
+-----------+-------------+
1 row in set (0.00 sec)

Please, put the required mail name to the mail_name, and the d.name as the domain name for the mail account.

Thank you

 

[danilaprepeleac]

Hello,

I faced the same problem,

found this post and later found this solution:

at Plesk mail click "Show Aliases" and found that "user@domain.com" is an alias for "user2@domain.com".