Plesk 12 Email Domains disapearing after running mchk command

[Chayanun_Somanassang]

We found an issue after running plesk mchk command to restore all the mail server settings with SpamAssiassin settings enabled for all email accounts on the Plesk Server.
After running the mchk command, we found many warning messages in the psa maillog as following "authpsa : No such user [Email account] in mail authorization database".
We checked the mysql database for records on the Email Account that the error is referring to but found that the Domain Email Database was deleted (email address, password, email data).

Has anyone seen this issue before or is this something normal that the plesk mchk command does?

Plesk 12.0.18 Update #37

 

[IgorG]

I can't reproduce this issue on my test Plesk server:

[root@ppu12-0 ~]# /usr/local/psa/admin/sbin/mail_auth_view
Authentication database contents:
+--------------------------------------+-----+--------------------------------------+
| address |flags| password |
+--------------------------------------+-----+--------------------------------------+
| [email protected]12-0.demo.pp.plesk.ru | | pvvuf19RHO |
| [email protected] | | setup |
| [email protected]12-0.demo.pp.plesk.ru | | qdzrmxlcpf |
+--------------------------------------+-----+--------------------------------------+
Flags
A - account disabled
D - domain disabled
E - password encrypted

[root@ppu12-0 ~]# /usr/local/psa/admin/sbin/mchk --with-spam
==> Checking for: mailsrv_conf_init... ok
==> Checking for: mail_handlers_init... ok
==> Checking for: mailsrv_entities_dump... ok
==> Checking for: mail_admin_aliases... ok
==> Checking for: mail_auth_dump... ok
==> Checking for: mailman_lists_dump... ok
==> Checking for: mail_kav8_restore... ok
==> Checking for: mail_responder_restore... ok
==> Checking for: mail_imap_restore... ok
==> Checking for: mail_spam_restore... ok
==> Checking for: mail_grey_restore... ok
==> Checking for: mail_mailbox_restore... ok
==> Checking for: mail_spf_restore... ok
==> Checking for: mail_dk_restore... ok
==> Checking for: mail_drweb_restore... ok
==> Checking for: mail_outgoing_restore... ok
==> Checking for: mail_transport_restore... ok

[root@ppu12-0 ~]# /usr/local/psa/admin/sbin/mail_auth_view
Authentication database contents:
+--------------------------------------+-----+--------------------------------------+
| address |flags| password |
+--------------------------------------+-----+--------------------------------------+
| [email protected]12-0.demo.pp.plesk.ru | | pvvuf19RHO |
| [email protected] | | setup |
| [email protected]12-0.demo.pp.plesk.ru | | qdzrmxlcpf |
+--------------------------------------+-----+--------------------------------------+
Flags
A - account disabled
D - domain disabled
E - password encrypted
[root@ppu12-0 ~]#

You can try to restore mailboxes with

# /usr/lib/plesk-9.0/mail_mailbox_restore

 

[SpcnetD]

Same problem here.

After update to Plesk 12, it seems the command /usr/lib64/plesk-9.0/remote_mail_restore/mail_auth_dump (part of mchk) not working properly. Only small part of psa mail accounts are updated to the Authentication database /var/spool/postfix/plesk/password.db .

We recovered password.db and password_db_key from backups, but it mchk command its launched the problema appears again.

Any suggestions?

 

[Gertjan H.]

Same problem here. After running into "No such user '<name>@<domain.tld>' in mail authorization database" we tried to repair the configuration with mchk and mail_auth_dump and that destroyed
the entire database. We restored a backup, but this is a serious issue.

 

[Tozz]

We see the same issue on Plesk 12.5 (latest with all updates) as well, but not on every Plesk installation we have. It would be great if Odin (or whoever currently owns Plesk) would take a second look at this, or contact us to reproduce the issue.

 

[dash]

Hi,
Most probably such behaviour requires investigation on the server. I would like to recommend to contact Plesk Support at http://www.odin.com/support/plesk-suite/plesk/