Unable to create subscription/domain, configure Mail Server: IP address does not exist

Refers to:

  • Plesk

Created:

2016-11-16 13:03:37 UTC

Modified:

2016-12-21 19:51:52 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create subscription/domain, configure Mail Server: IP address does not exist

Symptoms

  1. An attempt to create a subscription / domain fails with the following error:

    Error: Unable to find service node for ip address with id=2

    Error: Failed domain creation: Unable to update domain data: IP address with ID '2' does not exist
  2. It is not possible to manage Web Hosting Access . An attempt fails with the following error:

    Error: Unable to find service node for ip address with id=2
  3. It is not possible to manage Mail Server Settings , An attempt to choose Send from domain IP addresses and use domain names in SMTP greeting fails with the following error:

    Error: PleskException IP address with ID '2' does not exist

Cause

Database inconsistency.

Resolution

  1. Create a backup of the psa database:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa  > /root/psa.sql
  2. Check if the IP_Addresses table has record(s) with an IP address that does not exist in the ip_pool and dom_param tables:

    mysql> select * from ip_pool where ip_address_id not in (select id from IP_Addresses);
    +----+---------------+--------+
    | id | ip_address_id | type |
    +----+---------------+--------+
    | 1 | 2 | shared |
    +----+---------------+--------+
    1 row in set (0.00 sec)

    mysql> select * from dom_param where param='ip_addr_id' and val not in (select id from IP_Addresses);

    +--------+------------+------+
    | dom_id | param | val |
    +--------+------------+------+
    | 6 | ip_addr_id | 2 |
    +--------+------------+------+
    1 row in set (0.00 sec)

    mysql> select * from IP_Addresses where id =2;
    Empty set (0.00 sec)

    mysql> select id, serviceNodeId, ip_address from IP_Addresses;
    +----+---------------+--------------+
    | id | serviceNodeId | ip_address |
    +----+---------------+--------------+
    | 1 | 1 | x.x.x.x |
    +----+---------------+--------------+
    1 rows in set (0.00 sec)

    As can be seen in this example, the ip_pool and dom_param tables include an entry regarding a nonexistent IP address ( ip_address_id = 2 );

  3. Delete this record from the ip_pool table:

    mysql> delete from ip_pool where ip_address_id=2;
    Query OK, 1 row affected (0.00 sec)
  4. Update the dom_param table with an appropriate value

Have more questions? Submit a request
Please sign in to leave a comment.