Unable to switch domain to a dedicated IP address

Created:

2016-11-16 12:58:55 UTC

Modified:

2017-06-18 00:03:26 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to switch domain to a dedicated IP address

Symptoms

After migration domain that had a dedicated IP address switched to a shared IP address.

Now it is not possible to assign the dedicated IP address do the domain back.

Cause

Issue is caused by a database inconsistency which occurred after an unsuccessful migration.

Resolution

  1. Execute the following query to find out what IP address and IP pool ID are assigned to the domain:

    mysql> SELECT ip.ip_address, ip_pool.id AS 'ip_pool.id', ip_pool.ip_address_id AS 'ip_pool.ip_address_id', ip_pool.type AS 'ip_pool.type' FROM ip_pool, IP_Addresses ip, clients c, domains d WHERE d.cl_id=c.id AND c.pool_id=ip_pool.id AND ip_pool.ip_address_id=ip.id AND d.name='example.com'\G
    *************************** 1. row ***************************
    ip_address: 5.6.7.8
    ip_pool.id: 8
    ip_pool.ip_address_id: 10
    ip_pool.type: shared
    1 row in set (0.00 sec)
  2. Make a required IP address available to the domain:

    mysql> select id, ip_address from IP_Addresses;
    +----+----------------+
    | id | ip_address |
    +----+----------------+
    | 2 | 10.0.0.10 |
    | 1 | 5.6.7.8 |
    | 10 | 1.2.3.4 |
    +----+----------------+
    6 rows in set (0.00 sec)

    mysql> insert into ip_pool (id,ip_address_id,type) values (8,1,'exclusive');
    • Where 8 is the ip_pool.id (from the Step 1) and 1 is the IP address id.

  3. Assign the dedicated IP address to the domain at Plesk > Subscriptions > domain.tld > Web Hosting Access
Have more questions? Submit a request
Please sign in to leave a comment.