Symptoms
An attempt to remove IP address in Tools & Settings > IP Addresses fails:
The IP address 203.0.113.2 is already used for hosting
DNS service is not installed or disabled on the server:
# plesk bin server_dns --info
The DNS service is not installed.
Cause
Plesk bug PPPM-11183 that is planned to be fixed in one of the next Plesk updates.
Plesk doesn't update the records in its database in case the DNS service is disabled/not installed.:
# plesk db "SELECT d.name,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 = 'mail' and ipac.ipAddressId = (select id from IP_Addresses where ip_address='203.0.113.2') GROUP BY d.name ASC;"
+-------------+----------------+
| name | ip_address |
+-------------+----------------+
| example.com | 203.0.113.2 |
+-------------+----------------+
Resolution
Until the bug is fixed, use the following workaround to switch mail to another IP address and to be able to remove the IP address:
Plesk for Linux
Connect to the server using SSH.
Find the domains using the IP address to be removed:
# plesk db "SELECT d.name,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 = 'mail' and ipac.ipAddressId = (select id from IP_Addresses where ip_address='203.0.113.2') GROUP BY d.name ASC;"
+-------------+----------------+
| name | ip_address |
+-------------+----------------+
| example.com | 203.0.113.2 |
+-------------+----------------+Find the IP address used for web hosting on this domain:
# plesk bin domain --info example.com | grep -i "IP address"
IP address: 203.0.113.3Select the option Send from domain IP addresses in Tools & Settings > Mail Server Settings > Outgoing mail mode and click OK at the bottom of the page to apply the change.
Update the domain to use the same IP for web and mail hosting:
for one domain:
# plesk bin domain -u example.com -mail-service-ip 203.0.113.3
for all affected domains:
# for i in $(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 = 'mail' and ipac.ipAddressId = (select id from IP_Addresses where ip_address='203.0.113.2') GROUP BY d.name ASC;"); do plesk bin domain -u $i -mail-service-ip 203.0.113.3; done
Note: Replace the IP address 203.0.113.2 in the above command with the one to be removed, and 203.0.113.3 with the one to be used instead for mail hosting.
Roll back to the previous setting in Tools & Settings > Mail Server Settings > Outgoing mail mode and click OK at the bottom of the page to apply the change.
Plesk for Windows
Connect to the server using RDP.
Create a file with the list of affected domains where…
