Symptoms
-
When clicking on Mail Settings under a domain for a specific subscription the following message appears:
Warning: Permission Denied
-
The mail tab is missing in the subscription menu at Plesk > Subscriptions > example.com.
-
The mail service is disabled in Domains > example.com > Mail Settings > Activate mail service on this domain.
-
Enabling mail service fails with one of the errors below:
mailmng-outgoing failed: ERROR:outgoing:UNIQUE constraint failed: domains.
mailmng-outgoing failed: ERROR:__main__:column guid is not unique
mailmng-outgoing failed: **ERROR:outgoing:column name is not unique **
mailmng-outgoing failed: ERROR _main_:UNIQUE constraint failed: vhost_ids.guid
-
Unable to create a domain alias with the error message in Plesk:
PLESK_ERROR: mailmng-outgoing failed: Error: mailmng-outgoing failed: ERROR:outgoing:UNIQUE constraint failed: domain_aliases.name”
Cause
The outgoing mail control database already contains records about the subscription with the same name.
Resolution
Download and execute the following script which will add the affected domain to the outgoing mail control database and also enable the mail service for the domain.
-
Connect to the server via SSH
-
Download the script:
# wget https://plesk.zendesk.com/hc/article_attachments/360017841100/script.sh
-
Apply necessary permissions for execution:
# chmod +x script.sh
-
Run the script by specifying the affected domain:
# ./script.sh example.com