Applicable to:
- Plesk 12.5 for Linux
- Plesk for Linux
Symptoms
-
Email does not get delivered to
john.doe@example.com
, the following errors appear in/var/log/maillog
:CONFIG_TEXT: dovecot_authdb_plesk[1377]: No such user 'john.doe@example.com' in mail authorization database
dovecot: auth: plesk(john.doe@example.com): Mail account information for user='john.doe@example.com' was not found
dovecot: auth: Debug: userdb out: NOTFOUND#0111
dovecot: service=lda, user=john.doe@example.com, ip=[]. Debug: auth input:
postfix/pipe[14513]: E141A88AA5: to=<john.doe@example.com, relay=plesk_virtual, delay=2, delays=2/0/0/0.06, dsn=4.2.1, status=deferred (Message can not be delivered at this time ) -
The same errors may appear after switching from Courier to Dovecot if messages are forwarded internally.
-
The list of affected accounts might be received as below:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -Ne "select concat(m.mail_name,'@',d.name) as mailbox, a.type, a.password from domains d, mail m, accounts a where m.dom_id=d.id and m.account_id=a.id and m.postbox='true' and a.password =''"
Cause
The mail account (recipient) has an empty password in Plesk database.
Resolution
-
Connect to the server via SSH
-
List all accounts affected by the issue and save them in a text file:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -Ne "select concat(m.mail_name,'@',d.name) as mailbox from domains d, mail m, accounts a where m.dom_id=d.id and m.account_id=a.id and m.postbox='true' and a.password =''" > /root/select.txt
-
Make a mass password set:
# while read i; do /usr/local/psa/bin/mail -u $i -passwd 'PASSWORD'; done < /root/select.txt
Comments
0 comments
Please sign in to leave a comment.