Knowledge Base

Domain or mail account creation error: mailmng-outgoing failed, domain_id may not be NULL

Symptoms

One of the following symptoms may apply:

Unable to create a domain or a mail account under a subscription:
PLESK_ERROR: Error: mailmng-outgoing failed: ERROR:outgoing:domains.subscription_id may not be NULL
Error: mailmng-outgoing failed: ERROR:outgoing:mails.domain_id may not be NULL
Error: mailmng-outgoing failed: ERROR:outgoing:NOT NULL constraint failed: mails.domain_id
Mail tab is missing for a domain and mail service cannot be enabled:
# plesk bin subscription -u example.com -mail_service true
ERR [util_exec] proc_close() failed [‘/usr/local/psa/admin/bin/mailmng-outgoing’ ‘–add-subscription’ ‘–main-domain-name=example.com’ ‘–out-limit=100’] with exit code [1]
mailmng-outgoing failed: ERROR:outgoing:column name is not unique
Unable to connect with a mail client such as Outlook, thunderbird. The authorization fails with the following error shown in /var/log/maillog:
```
authpsa[260371]: No such user '[email protected]' in mail authorization database
```

Mail restore fails:
# plesk repair mail example.com
….
Restoring outgoing limits for [email protected]
NOT NULL constraint failed: mails.domain_id

# plesk repair mail example.com
….
Restoring outgoing limits for [email protected]
mails.domain_id may not be NULL

# plesk repair mail example.com
…
Fatal error: plesk::SystemError(You should specify at least one
non-empty ip adress: No such file or directory)
Passwords for mailboxes may be changed frequently for unknown reason

The record for ipAddressId is missing in IpAddressesCollections table for one or several domains:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Nse “SELECT d.name FROM domains d JOIN DomainServices ds on d.id=ds.dom_id LEFT JOIN IpAddressesCollections ipc on (ds.ipCollectionId = ipc.ipCollectionId ) WHERE ds.type=’mail’ AND ipc.ipCollectionId is NULL”
+———————————-+————-+
| name | ipAddressId |
+———————————-+————-+
| example.com | NULL |
| example2.com | NULL |

Cause

Product issue:

#PPPM-12375 “Setting “Outgoing mail mode” to “Send from the specified IP addresses” and then to “Send from domain IP addresses” or “Send from domain IP addresses and use domain names in SMTP greeting” in “Tools & Settings” > “Mail Server Settings” no longer results in multiple issues with mail in Plesk due to the Plesk database getting corrupted.”

Fixed in:
- Plesk Obsidian 27 October 2020 (Linux)

Resolution

Please consider updating your server:

How to install Plesk updates

Workaround

If update is not possible for some reason you may try the following

workaround

Apply the following workaround until the bug is fixed:

Note: if you don’t have root-level SSH access to Plesk server, contact your hosting company to resolve the issue.

For Plesk Obsidian 18.0.29 and later:

Log in to the server via SSH.
Back up Plesk database
Execute the following command to automatically repair missing entries:
# plesk repair db

For Plesk Obsidian 18.0.28 and earlier:

Log in to the server via SSH.
Back up Plesk database
Generate the list of domains affected by the issue:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Nse “SELECT d.name FROM domains d JOIN DomainServices ds on d.id=ds.dom_id LEFT JOIN IpAddressesCollections ipc…