Unable to access subscrition: There is no IP address in the pool

Created:

2016-11-16 13:06:53 UTC

Modified:

2017-04-24 11:05:21 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Unable to access subscrition: There is no IP address in the pool

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux

Symptoms

The following error is thrown upon attempt to access a subscription or a domain:

There is no IP address 203.0.113.2 in the pool.

Cause

Database inconsistency. There is no IP pool with the requested ID.

Resolution

  1. Check that correct IP pool and IP address are assigned to the client:

    mysql> SELECT c.login, ipool.id AS 'Pool ID', ipool.ip_address_id, ip.ip_address FROM ip_pool ipool RIGHT JOIN clients c ON ipool.id=c.pool_id LEFT JOIN IP_Addresses ip ON ipool.ip_address_id=ip.id WHERE c.login LIKE '%Example%';
    +----------+---------+---------------+------------+
    | login | Pool ID | ip_address_id | ip_address |
    +----------+---------+---------------+------------+
    | Example1 | NULL | NULL | NULL |
    +----------+---------+---------------+------------+
    1 row in set (0.00 sec)
  2. To fix the issue, execute the following:

    # plesk repair db
    ....
    Inconsistency in the table 'clients' for the column pool_id: There
    is no IP pool with ID 0 ........................................... [ERROR]
    Create an IP pool? [Y/n] Y
    Creating an IP pool ............................................. [FIXED]
    ....
Have more questions? Submit a request
Please sign in to leave a comment.