Symptoms
-
When accessing Tools & Settings > Outgoing Mail Control page the following error appears:
Error: Unable to execute mailmng-outgoing: no such table: OutgoingMessages at execute console command --get-outgoing-messages-domains-stat(vconsoleapp::start line 100) at execute %plesk_dir%adminbinmailmng.exe --get-outgoing-messages-domains-stat "--stat-time=2016-07-25 08:00"(vconsoleapp::run line 117) (Error code 1)
-
Cannot create a new mail account under a subscription; the account is created, but without a mailbox:
Error: mailmng-outgoing failed: ERROR:outgoing:mails.domain_id may not be NULL
-
Outgoing mail does not work for one or several domains: PHP scripts may not work, Roundcube webmail returns the following error:
SMTP Error (250): Authentication failed
Cause
The outgoing mail database is corrupted.
Resolution
For Linux
-
Connect to the server via SSH;
-
Rename the database:
# mv /var/lib/plesk/mail/outgoing/data.db{,.bak}
-
Rebuild it:
-
For RHEL/CentOS/CloudLinux:
# /usr/lib64/plesk-9.0/remote_mail_restore/mail_outgoing_restore
-
For Debian/Ubuntu:
# /usr/lib/plesk-9.0/remote_mail_restore/mail_outgoing_restore
-
-
If the domain was created in Plesk in the initial attempt, delete it at Domains > select the domain example.com > Remove
-
Add the domain again
For Windows:
-
Connect to the server via RDP
-
Delete or rename the file
%plesk_dir%admindbOutgoingMessages.db -
Run the command to rebuild it:
"%plesk_dir%adminbinmailmng.exe" --init-outgoing-messages-storage