Article ID: 120142, created on Feb 14, 2014, last review on Jan 23, 2016

  • Applies to:
  • Plesk Automation 11.5

Symptoms

After creating a subscription, "Create the webspace in the Hosting Panel" task failed with the error below:

    Unable to create hosting. Ip address does not exist in client's pool

Cause

  1. Default PPA IP address is marked as Dedicated, but it should have Shared type.
  2. Client's IP pool has nonexistent IP address.

Resolution

  1. Open Plesk backend using direct link:

    https://PPA_MN_IP:8443/admin/ip-address/list/
    

    1.1. Select Management Node main IP address and change its type to shared.

    1.2. Go to Operations > Tasks and rerun failed tasks.

  2. Make sure that Client IP Pool does not contain orphaned IP addresses:

    [root@manage ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
    mysql> select pool_id from clients where login='<cuctomer_login>';
    +---------+
    | pool_id |
    +---------+
    |       9 |
    +---------+
    1 row in set (0.00 sec)
    

2.1. Check all IP addresses, that belong to IP Pool with id=9;

    mysql>  select * from ip_pool  where id=9;
    +----+---------------+-----------+
    | id | ip_address_id | type      |
    +----+---------------+-----------+
    |  9 |             1 | shared    |
    |  9 |             2 | shared    |
    |  9 |             3 | shared    |
    |  9 |            21 | exclusive |

2.2. Make sure that all these IP addresses persist in "IP_Address" table:

    mysql> select id,serviceNodeId,ip_address from IP_Addresses where id in (1,2,3,21);
    +----+---------------+---------------+
    | id | serviceNodeId | ip_address    |
    +----+---------------+---------------+
    |  1 |             1 | 1.1.1.1       |
    |  2 |             2 | 2.2.2.2       |
    |  3 |             3 | 3.3.3.3       |
    +----+---------------+---------------+
    3 rows in set (0.00 sec)

The other way to check it is to use the following query:

    mysql> select ip_pool.id,ip_pool.ip_address_id,IP_Addresses.id from ip_pool left join IP_Addresses on ip_pool.ip_address_id=IP_Addresses.id where IP_Addresses.id is NULL;
    +----+---------------+------+
    | id | ip_address_id | id   |
    +----+---------------+------+
    |  9 |            21 | NULL |
    +----+---------------+------+
    1 row in set (0.00 sec)

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

2.3. As you can see above, there is no such IP address, so create backup of psa database with "mysqldump" command and delete orphaned IP addresses from the client's IP Pool:

    mysql> delete from ip_pool where ip_address_id=21;
    Query OK, 1 row affected (0.07 sec)

Search Words

error create subspription

Unable to create subscription for domain

Unable to create hosting. Ip address does not exist in client's pool

ip conflict

error: Failed to create webspace in PPA. Exception: [2005] Resource 'IP addresses' overusage attempt

IP conflict in pbas

33a70544d00d562bbc5b17762c4ed2b3 e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF