Admin-Ahead Community
Linux => Control Panels => Plesk => Topic started by: anju on October 22, 2013, 06:51:56 am
-
This issue is caused by an inconsistency in the Parallels Plesk Panel database. Orphan entries (referred to as IP addresses) remain attached to the Plesk administrator IP pool when the IP addresses are removed from the system.
You can fix the issue by using the following steps.
-----> Access the mysql
-----> Select the psa database
-----> Find the IP addresses using the following query.
mysql> select ip_pool.id,ip_pool.ip_address_id,IP_Addresses.id from ip_pool left join IP_Addresses on ip_pool.ip_address_id=IP_Addresses.id where IP_Addresses.id is NULL;
+----+---------------+------+
| id | ip_address_id | id |
+----+---------------+------+
| 1 | 5 | NULL |
| 1 | 6 | NULL |
| 1 | 7 | NULL |
| 1 | 30 | NULL |
| 1 | 31 | NULL |
| 1 | 33 | NULL |
| 1 | 34 | NULL |
+----+---------------+------+
-----> Remove orphan entries using a query similar to the query below:
mysql> delete from ip_pool where ip_address_id in (5,6,7,30,31,33,34);