Unable to sync DNS zones with Slave servers: received notify for zone not authoritative

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

1. Connect to the Master DNS server via SSH.

2. Create Plesk database backup:

   # MYSQL_PWD=cat /etc/psa/.psa.shadow mysqldump -u admin psa > psadate +%F_%H.%M.sql

3. Log into Plesk database:

   # plesk db

4. 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’);