IP address cannot be deleted through IP addresses management because check-box is grayed-out

APPLIES TO:

  • Parallels Plesk Panel 9.x for Linux/Unix

Symptoms

An IP address that is not used by any client or domain cannot be deleted through the IP addresses management page in Parallels Plesk Panel (PP):

Home -> Server -> IP addresses management

The check-box near the IP address is grayed-out and cannot be selected. Why is this?

Cause

The IP address 123.123.123.123 is grayed-out on the IP addresses management page because it is the default address for Parallels Plesk Panel or is being used in the DNS zone of some PP domain.

Resolution

1. The IP address is grayed-out because it is the default address for Parallels Plesk Panel. Run the following command to get the default IP address for Parallels Plesk Panel:

mysql> select IP_Addresses.ip_address from IP_Addresses, misc where misc.val=IP_Addresses.id and misc.param='def_ip_id';
------------------+
| ip_address      |
+-----------------+
| 123.123.123.123 |
+-----------------+
1 row in set (0.00 sec)mysql>

The default IP address is set during initial configuration. Reconfigure Parallels Plesk Panel to change the default IP address.

If Parallels Plesk Panel is configured, the parameter psa_configured is set to “true” in the psa.misc table:

mysql> select * from misc where param='psa_configured';
+----------------+------+
| param          | val  |
+----------------+------+
| psa_configured | true |
+----------------+------+
1 row in set (0.00 sec)mysql>

To perform initial configuration, change the psa_configured parameter to “false”:

mysql> update misc set val='false' where param='psa_configured';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0mysql>

Then log out and log back in to PP. The initial configuration page is opened just after logging in:

Warning: Fill the requested information into the appropriate fields. This information is required for Plesk to work.

Preferences ————————
Default IP Address —————–
Shared IP addresses —————-
Administrator’s Preferences ——–

Select another IP address in the drop-down menu near the Default IP Address, fill in the other required information, and click “OK” to finish the configuration.

After the reconfiguration, the IP address 123.123.123.123 is no longer the default, and the check-box near it is enabled.

2. Using the query below, you may find the domain that uses the IP address 123.123.123.123.

mysql> select d.name from domains d, dns_recs dns where d.dns_zone_id=dns.dns_zone_id and dns.val='123.123.123.123';
+------------+
| name       |
+------------+
| domain.tld |
+------------+
1 row in set (0.00 sec)mysql>

After the domain is found, remove or change the IP address in its DNS zone:

Domains -> domain.tld -> Web Site -> DNS Settings

This should make the check-box near the IP address enabled on the IP addresses management page.

Additional information

You may connect to the PP database using the following command:

~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10895
Server version: 5.0.45-log Source distributionType ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql>

Kaynak : http://kb.parallels.com/en/5967