1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Cannot Remove old IP's

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by Cameron_W, Aug 17, 2012.

  1. Cameron_W

    Cameron_W New Pleskian

    13
    60%
    Joined:
    Mar 15, 2012
    Messages:
    15
    Likes Received:
    0
    Hi,

    A few months ago we recieved a new range of IP addresses and have succesfully changed over my IP addresses . Everything is running ok.

    Today, we went to add some new IP addresses and then clicked on "Reread IP" then, the old IP range reappeared.

    Now, when we remove those IP's we get the following error message:
    Error: IP address 61.8.xxx.xxx cannot be removed because it is used by DNS zone of one or more domains.

    Now on investigations of the psa database we found that the IP addresses are linked to a domain which does not exist in the control panel anymore.

    Is their a way to remove these records?
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,244
    Location:
    Novosibirsk, Russia
    According to your description it is caused by database inconsistency. Therefore I see only one way - manual fixing psa database and then removing extra IPs with ifmng CLI utility.
     
  3. Cameron_W

    Cameron_W New Pleskian

    13
    60%
    Joined:
    Mar 15, 2012
    Messages:
    15
    Likes Received:
    0
    Thanks IgorG.

    Here are the steps I took:
    1) Backed up the PSA mySQL Table
    2) Go into the dns_recs table
    Filtered the OLD IPs in the val column
    3) Removed these rows
    4) Go back and reread the IP's
    5) Removed the old IPs.

    and that has removed the old IPs.
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,244
    Location:
    Novosibirsk, Russia
    You can also create full dump of psa database and try to find these IPs in this dump. Most probably that IPs can be used in other tables too.
     
  5. Cameron_W

    Cameron_W New Pleskian

    13
    60%
    Joined:
    Mar 15, 2012
    Messages:
    15
    Likes Received:
    0
    Yes but, I can only see it in the following tables:

    dns_recs - this is where I removed the old IP's
    IP_Addresses
    log_components
    DashboardPresetConfig and;
    exp_event
     
Loading...