Unable to delete IP address

Created:

2016-11-16 13:00:58 UTC

Modified:

2017-04-24 11:35:21 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to delete IP address

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

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

Cause

Broken IP references in dns_recs table

Resolution

  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='203.0.113.2'; 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.