Unable to remove IP address from Plesk: Error The IP address 203.0.113.2 is already used for hosting.

Leonid Gukhman

Updated May 17, 2023 15:29

Plesk for Windows Plesk for Linux kb: technical ABT: Group A

Applicable to:

Unable to remove a specific IP address under Tools & Settings > IP Addresses, the following error is displayed.

PLESK_ERROR: Error: The IP address 203.0.113.2 is already used for hosting.

One or several domains have the IP address 203.0.113.2 assigned.

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"
Log in to Plesk.
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"
Log in to Plesk.
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.