Articles in this section

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

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

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

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%\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

  • 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

Cause

The outgoing mail database is corrupted.

Resolution

For Linux
  1. Connect to the server via SSH;

  2. Rename the database:

    # mv /var/lib/plesk/mail/outgoing/data.db{,.bak}

  3. 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

  4. If the domain was created in Plesk in the initial attempt, delete it at Domains > select the domain example.com > Remove

  5. Add the domain again

For Windows:
  1. Connect to the server via RDP

  2. Delete or rename the file %plesk_dir%admin\db\OutgoingMessages.db

  3. Run the command to rebuild it:

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

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.