Unable to delete IP address


2016-11-16 13:00:58 UTC


2017-08-16 17:04:37 UTC


Was this article helpful?

Have more questions?

Submit a request

Unable to delete IP address

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


Unable to delete IP address(es) because they are assigned to the hosting


Broken IP references in dns_recs table


  1. Check the IP reference in domain zone files and you will get a list of such domains

    mysql> select d.name from domains d, dns_recs dns where d.dns_zone_id=dns.dns_zone_id and dns.val='xx.xx.xx.xx';

    | name |
    | domain.tld |
  2. Go to Subscriptions > Click on subscription from the above list > Websites & Domains > DNS settings

    remove the entry containing IP which you wish to delete

If it still does not help

  1. Create a backup of the current psa database:
    Windows: "%plesk_dir%\\MySQL\\bin\\mysqldump.exe" -uadmin -P8306 -p<PleskPasswordHere> psa > c:\\psadump.sql 
    Linux: mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /tmp/psa.`date +%F_%H.%M`.sql
  2. Delete the IP address:
    # plesk db;
    select * from IP_Addresses; delete from IP_Addresses where ip_address=''; delete from ip_pool where ip_address_id=1; <<<<<change the ip to the id value from IP_Addresses table
Have more questions? Submit a request
Please sign in to leave a comment.