Unable to send emails or create a mailbox: Error: mailmng-outgoing failed: ERROR:outgoing:mails.domain_id may not be NULL

Symptoms

• Unable to create a mail account for example.com or repair mail service for a domain. One of the following errors is displayed in Plesk interface:

  PLESK_ERROR: Error: mailmng-outgoing failed: ERROR:outgoing:mails.domain_id may not be NULL

  PLESK_ERROR: Error: mailmng-outgoing failed: ERROR:outgoing:domains.subscription_id may not be NULL

  PLESK_ERROR: Error: mailmng-outgoing failed: ERROR:outgoing:mail_aliases.mail_id may not be NULL

• Outgoing mail control is enabled

• Unable to send emails, the following error might be found in the log file /var/log/maillog:

  There was an error sending your message: Server is not accepting SMTP connections. Error in mail clients can appear during sending emails: 554 5.7.0 The message could not be sent. You are not allowed to use sendmail utility. Errors can appear when emails are sent to one of the mailboxes of domain example.com: "550 5.1.1 [email protected]: Recipient address rejected: User unknown in virtual mailbox table"

• Unable to send emails with PHP mail even though sendmail is enabled in Plesk, the following error is shown in the log file /var/log/maillog:

  plesk sendmail[7372]: handlers_stderr: ERROR:__main__:Rejecting message: system user uid='11088' is not allowed to send mail
   plesk sendmail[7372]: handlers_stderr: DATA REPLY:554:5.7.0 Your message could not be sent. The user sysuser is not allowed to send email.#012REJECT
   plesk sendmail[7372]: REJECT during call 'limit-out' handler

Cause

There is an inconsistency in the internal database used for outgoing mail limits.

Resolution

Note: If root access to Plesk via SSH is not available, contact the service provider

1. Connect to the server via SSH

2. In case there is any customization in the Mail Server configuration files, back them up:

   For Postfix:

   # cp -rp /etc/postfix{,.old}

   For Qmail:

   # cp -rp /var/qmail/control{,.old}

3. Run the following command:

   # plesk repair mail

4. If the issue persists, back up the outgoing mail limits database:

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

5. Repair outgoing limits configuration:

   On RHEL/CentOS based systems:

   # /usr/lib64/plesk-9.0/remote_mail_restore/mail_outgoing_restore

   On Debian/Ubuntu based systems:

   # /usr/lib/plesk-9.0/remote_mail_restore/mail_outgoing_restore