Shared IP changes to dedicated automatically

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 10.4 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 12:59:04 UTC

Modified:

2016-12-21 19:41:29 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Shared IP changes to dedicated automatically

Symptoms

Shared IP changes to dedicated automatically.

Cause

Plesk database inconsistency.

Resolution

  1. Create a backup of ' psa ' database:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa.sql
  2. Log in to ' psa ' database:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
  3. Check type of IP_Address in ip_pool table:

    mysql> select * from ip_pool;

    +-----+---------------+-----------+
    | id | ip_address_id | type |
    +-----+---------------+-----------+
    | 639 | 14 | shared |
    | 802 | 15 | exclusive |
    | 306 | 14 | exclusive |
    +-----+---------------+-----------+

The same IP Address (with id=14) has ' exclusive ' and ' shared ' type at the same time.

  1. Change type to correct one:
    mysql> update ip_pool set type='shared' where ip_address_id=14;
Have more questions? Submit a request
Please sign in to leave a comment.