Outgoing mail control does not work in Plesk: Unable to execute mailmng-outgoing: no such table

Benjamin Wessel

Updated May 20, 2021 08:46

Plesk for Windows Plesk for Linux kb: technical ABT: Group B

Applicable to:

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%\admin\bin\mailmng.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
Plesk displays one of the errors below when trying to add a new domain or adding a mail forwarding address:

Error: mailmng-outgoing failed: ERROR:outgoing:database disk image is malformed

Error: mailmng-outgoing failed: ERROR:outgoing:PRIMARY KEY must be unique

mailmng-outgoing failed: ERROR:__main__:no such table: mails

The size of the outgoing messages database is 0:
- on Windows based servers at %plesk_dir%\admin\db\OutgoingMessages.db
- on Linux based servers at /var/lib/plesk/mail/outgoing/data.db

The outgoing mail database is corrupted.

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%admin\db\OutgoingMessages.db
Run the command to rebuild it:

"%plesk_dir%\admin\bin\mailmng.exe" --init-outgoing-messages-storage