Unable to modify hosting settings of subscripion : "The IP address is available only as none"

Created:

2016-11-16 13:10:13 UTC

Modified:

2017-08-16 16:41:37 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to modify hosting settings of subscripion : "The IP address is available only as none"

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.x for Windows
  • Plesk 11.x for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

The following error occurs when you go to: Websites&Domains > Hosting Settings > OK :

The IP address 1.2.3.4 is available only as none

Also this error could occur in different operations related to IP addresses modifications on server.

Cause

Plesk primary IP address 1.2.3.4 was configured as exclusive but it was assigned to two different customers.

Transition to the new business model failed after the successful upgrade.

Resolution

In database we need to change IP address type to shared, or assign it to single client.

  1. Backup Plesk database .

  2. Find id of IP address from error: 1.2.3.4:

    mysql> select * from psa.IP_Addresses where IP_Addresses.ip_address = '1.2.3.4';
    +----+---------------+---------------+--------+--------------------+-------------------+-------+------+--------+---------------+-------------------+
    | id | ip_address | mask | iface | ssl_certificate_id | default_domain_id | ftps | main | status | serviceNodeId | public_ip_address |
    +----+---------------+---------------+--------+--------------------+-------------------+-------+------+--------+---------------+-------------------+
    | 1 | 1.2.3.4 | 255.255.248.0 | venet0 | 52 | 1705 | false | true | 0 | 1 | NULL |
    +----+---------------+---------------+--------+--------------------+-------------------+-------+------+--------+---------------+-------------------+
    1 row in set (0.00 sec)
  3. Check in which IP pools, this address is used:

    mysql> select * from psa.ip_pool where ip_pool.ip_address_id = 1;
    +----+---------------+-----------+
    | id | ip_address_id | type |
    +----+---------------+-----------+
    | 1 | 1 | exclusive |
    | 52 | 1 | exclusive |
    +----+---------------+-----------+
    2 rows in set (0.00 sec)
  4. Change type to shared:

    mysql> update psa.ip_pool set type = 'shared' where ip_address_id = 1;
    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 2 Changed: 2 Warnings: 0
Have more questions? Submit a request
Please sign in to leave a comment.