Not all zones have fixed references after upgrading Parallels Plesk Panel from version 10.4.4 to 11.0

Created:

2016-11-16 13:06:14 UTC

Modified:

2017-04-24 11:57:43 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Not all zones have fixed references after upgrading Parallels Plesk Panel from version 10.4.4 to 11.0

Applicable to:

  • Plesk 10.x and below for Linux

Symptoms

Plesk 10.4.4 has a problem with DNS zone synchronization with the DNS template when extra records from the DNS template are added to the DNS zone. The problem has been fixed in PP 11.0.9. But for some DNS zones which were manually or automatically switched to "unsynchronized" with the DNS template state, this fix is not applicable. Therefore, if you start forced synchronization of such zones after upgrading to Plesk 11.0.9 (during the upgrade procedure, all zones have an unsynchronized state), extra DNS records will be added to these zones.

Resolution

Before upgrading, it is recommended to switch unsynchronized zones to a synchronized state with the following SQL query:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e "update dns_zone set syncSoa='true', syncRecords='true' where id not in (select val from misc where param='default_dns_zone_id')"``

It is an absolutely safe procedure because after the upgrade, all zones will be switched to an unsynchronized state.

To fix the references of records from the DNS template to records of the DNS zones after upgrading to Plesk 11.0.9, you can use the following commands (for all zones):

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa > psa_dump.sql
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e "delete from dns_refs"
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e "update dns_zone set syncSoa='true', syncRecords='true' where id not in (select val from misc where param='default_dns_zone_id')"
# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/scripts/upgrade_dns_1011.php``

To fix the references of records from the DNS template to records of the DNS zones after upgrading to PP 11.0.9, use the following commands (for zones with dns_zone_id 2,5,8, for example):

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa > psa_dump.sql 
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e "delete from dns_refs where zoneId in (2,5,8)"
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e "update dns_zone set syncSoa='true', syncRecords='true' where id in (2,5,8)"
# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/psa/admin/plib/scripts/upgrade_dns_1011.php 2 5 8

The list of zones where references have not been created during the upgrade procedure can be found in the pre-upgrade checker log file /root/parallels/PSA_11.0.9/examiners/plesk10_preupgrade_checker.log

Have more questions? Submit a request
Please sign in to leave a comment.