• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Mail accounts errors - account exist or not in server?

M

MiguelK

Guest
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 [email protected] -passwd xXxXxXxXx -mbox_quota 100M
An error occured during mailname creation: Mail account [email protected] already exists in this domain.
turbineseusite:/usr/local/psa/bin # ./mail --remove [email protected]
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
 
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';

===
 
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
 
Back
Top