Symptoms
-
Unable to sync DNS zones with Slave DNS servers.
-
Slave DNS Manager extension is installed on the Master server or Amazon Route 53 extension is installed. There are no other DNS extensions installed.
-
The following records can be found in
/var/log/messages
on the master server:named[829]: zone example.com/IN: zone serial (2019040204) unchanged. zone may fail to transfer to slaves.
-
The following records can be found in
/var/log/messages
on the slave server:client 203.0.113.2#64201: received notify for zone 'example.com': not authoritative
-
Custom script values are missing in the Plesk database:
# plesk db “select * from ServiceNodeConfiguration where section = ‘dnsConnector'”
+—————+————–+——-+——-+
| serviceNodeId | section | name | value |
+—————+————–+——-+——-+
| 1 | dnsConnector | plesk | true |
+—————+————–+——-+——-+
Cause
Plesk database inconsistency.
Resolution
-
Connect to the Master DNS server via SSH.
-
# MYSQL_PWD=
cat /etc/psa/.psa.shadow
mysqldump -u admin psa > psadate +%F_%H.%M
.sql -
# plesk db
-
Insert the missing records:
MYSQL_LIN: INSERT INTO ServiceNodeConfiguration (serviceNodeId, section, name, value) VALUES (‘1’, ‘dnsConnector’, ‘custom’, ‘true’);
MYSQL_LIN: INSERT INTO ServiceNodeConfiguration (serviceNodeId, section, name, value) VALUES (‘1’, ‘dnsConnector’, ‘custom_script’, ‘”/usr/local/psa/bin/extension” –exec slave-dns-manager slave-dns.php’);