Symptoms
Unable to create a mail account for an existing domain or plesk repair mail utility fails with one of the following errors:
Error: mailmng-outgoing failed: ERROR:outgoing:mails.domain_id may not be NULL
Error: mailmng-outgoing failed: ERROR:outgoing:domains.subscription_id may not be NULL
Error: mailmng-outgoing failed: ERROR:outgoing:mail_aliases.mail_id may not be NULL
Cause
Inconsistency in the Plesk database and/or the external SQLite database controlling outgoing mail limits.
Resolution
Note: The solution described in this article requires root access, if it's not available please contact the hosting service provider
Connect to the server via SSH
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}
# plesk db dump psa apsc > psa_apsc_backup.sql
Repair any Plesk database inconsistency:
# plesk repair db -y
Repair any mail inconsistencies:
# plesk repair mail -y
If the issue persists, back up the outgoing mail limits database:
# mv /var/lib/plesk/mail/outgoing/data.db{,_bk}
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
