Symptoms
Unable to remove a specific IP address under Tools & Settings > IP Addresses, the following error is displayed.
Error: The IP address 203.0.113.2 is already used for hosting.
Cause
One or several domains have the IP address 203.0.113.2 assigned.
Resolution
For a Windows server
-
Connect to the server via RDP and open a command prompt.
-
Display the list of domains which have the IP address 203.0.113.2 assigned:
C:> plesk db -Nse "SELECT d.name 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 = (select id from IP_Addresses where ip_address='203.0.113.2') GROUP BY d.name ASC"
-
Change the domain IP address under Domains > example.com > Web Hosting Access > IPv4 address for every domain listed in the output of the command in step 2. Click Apply to apply the change.
-
Remove the IP address under Tools & Settings > IP Addresses > Select the IP address > Remove.
For a Linux server
-
Connect to the server via SSH.
-
Display the list of domains which have the IP address 203.0.113.2 assigned:
# plesk db -Nse "SELECT d.name 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 = (select id from IP_Addresses where ip_address='203.0.113.2') GROUP BY d.name ASC"
-
Change the domain IP address under Domains > example.com > Web Hosting Access > IPv4 address for each domain listed in the output of the command in step 2.
-
Once done, remove the IP address under Tools & Settings > IP Addresses > Select the IP address > Remove.