Article ID: 123047, created on Oct 2, 2014, last review on Aug 31, 2016

  • Applies to:
  • Plesk 12.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows


Plesk creates only one domain from the system in the /var/spool/postfix/plesk/passwd.db when viewed with /usr/local/psa/admin/bin/mail_auth_view.

Only users from the domain have access to emails. The rest of users do not have access due to invalid username/password authentication. There is no problem in adding new email accounts to the working domain. When adding the new email accounts to the problematic domains, the following error message appears:

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


Database inconsistency: psa.DomainServices in the database contains NULL ipCollectionId fields

mysql> select * from DomainServices where ipCollectionId is NULL;
| id | dom_id | type      | status | parameters_id | ipCollectionId |
|  3 |      3 | mail      |      0 |             3 |           NULL |
|  6 |      6 | mail      |      0 |             6 |           NULL |


  1. Get existing domains list with IP addresses currently assigned to the web hosting and put it into a temporary table:

    mysql> CREATE TEMPORARY TABLE dom_ip as (SELECT as dom_id, as dom_name, ia.ipAddressId as ip_ipAddressId, iad.ip_address as ip_ip_address FROM domains dom LEFT JOIN DomainServices d ON ( = d.dom_id AND d.type = 'web') LEFT JOIN IpAddressesCollections ia ON ia.ipCollectionId = d.ipCollectionId LEFT JOIN IP_Addresses iad ON = ia.ipAddressId);
    | dom_id | dom_name   | ip_ipAddressId | ip_ip_address   |
    |  3     | |              2 | |
    |  6     ||              9 | |
  2. Merge DomainServices with dom_ip:

    mysql> CREATE TEMPORARY TABLE ds_ip as (select di.*, ds.type as ds_type, ds.ipCollectionId as ds_ipCollectionId, ds.dom_id as ds_dom_id from DomainServices ds, dom_ip di where ds.dom_id=di.dom_id and ds.ipCollectionId is NULL);
  3. For every entry in IpAddressesCollections and IpCollections a new record should be created:

    mysql> select @i:=max(ipCollectionId)+1 from IpAddressesCollections; insert into IpCollections values(@i);  insert into IpAddressesCollections values (@i,2);
    | @i:=max(ipCollectionId)+1 |
    |                        72 |
    1 row in set (0.00 sec)
  4. Update table with the relevant data for mail or for web types:

    mysql> begin;
    mysql> update DomainServices, ds_ip set DomainServices.ipCollectionId=ds_ip.ds_ipCollectionId where DomainServices.type='mail' and DomainServices.dom_id=ds_ip.ds_dom_id and DomainServices.ipCollectionId is NULL;
    mysql> commit;
  5. Activate and deactivate Mail Service for the domain to recreate the mail configuration.

Search Words

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

ip addresse not added to containers

проблема с Create Email Address на сервере

login fails

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7 ed7be2b984f9c27de1d2dc349dc19c6d 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8

Email subscription for changes to this article
Save as PDF