- Plesk for Windows
- Plesk for Linux
An attempt to delete an old IP address from Plesk fails with the following error:
Error: The IP address `<ip_address>` is already used for hosting.
One of the following symptoms may take place in Tools & Settings > IP Addresses
- no sites are shown to use the old IP address;
- after switching the domains to the new IP, some of them are still shown as assigned to the old address.
This is caused by Plesk database inconsistency. The
table was not correctly updated when IP addresses were changed for domains.
1. Login to Plesk via SSH.
2. Back up Plesk database.
3. Login to MySQL server.
4. Find out which "
id" is assigned to the IP address in question, and find any (sub)domains that have this IP address assigned:
MYSQL_LIN: mysql> select @ip_id := id from IP_Addresses where ip_address='203.0.113.2';
mysql> SELECT d.name, d.webspace_id, ipac.ipCollectionId,ds.type,ip.ip_address FROM DomainServices ds INNER JOIN IpAddressesCollections ipac ON ds.ipCollectionId = ipac.ipCollectionId INNER JOIN domains d ON d.id = ds.dom_id JOIN IP_Addresses ip on ipac.ipaddressid=ip.id WHERE (ds.type = 'web' OR ds.type = 'mail') and ipac.ipAddressId = @ip_id;
Make sure the 203.0.113.2
5. Find records in the
table that correspond to the IP address in question:
MYSQL_LIN: mysql> select * from IpAddressesCollections where ipaddressid=@ip_id;
6. Find out which
is assigned to the IP address that should be used for the (sub)domains from the previous output, then update the corresponding records of the
table. For example, the 203.0.113.3
MYSQL_LIN: mysql> set @domain_name := 'example.com';
mysql> select @ip_id_new := id from IP_Addresses where ip_address='203.0.113.3';
mysql> update IpAddressesCollections ipac INNER JOIN DomainServices ds ON ds.ipCollectionId = ipac.ipCollectionId INNER JOIN domains d ON d.id = ds.dom_id JOIN IP_Addresses ip on ipac.ipaddressid=ip.id set ipac.ipAddressId=@ip_id_new WHERE (ds.type = 'web' OR ds.type = 'mail') and ipac.ipAddressId = @ip_id and d.name=@domain_name;