DNS changes for spamassassin.org - May 2017 DNS for SpamAssassin.org is using a hidden master on sa-vm1.apache.org running PowerDNS. - PowerDNS config file is /etc/powerdns/pdns.d/pdns.local/conf. - See sa-vm1.apache.org:/usr/local/bin/powerDNS.sh for examples on using the PowerDNS API which automatically increments the serial. A NOTIFY by the PowerDNS API will immediately push out the changes to the public slaves. NOTE: Using the PowerDNS API will automatically increment the serial but will not automatically NOTIFY. - The PowerDNS backend is SQLite3: root@sa-vm1:~# sqlite3 /var/lib/powerdns/pdns.sqlite3 sqlite> select * from domains; id name master last_check type notified_serial account ---------- ---------------- ---------- ---------- ---------- --------------- ---------- 1 spamassassin.org MASTER 2017051201 sqlite> select id,domain_id,name,type,content,ttl from records where domain_id = 1 and type = 'NS'; id domain_id name type content ttl ---------- ---------- ---------------- ---------- ------------ ---------- 186 1 spamassassin.org NS ns2.pccc.com 86400 188 1 spamassassin.org NS a.auth-ns.so 86400 189 1 spamassassin.org NS b.auth-ns.so 86400 190 1 spamassassin.org NS c.auth-ns.so 86400 201 1 spamassassin.org NS ns2.ena.com 86400 sqlite> select name,type,content from records where domain_id = 1 and type = 'SOA'; name type content ---------------- ---------- ------------------------------------------------------------------------- spamassassin.org SOA ns2.pccc.com pmc.spamassassin.apache.org 2017051201 7200 3600 604800 3600 - To manually update the serial making sure it has the current date and is larger than the existing serial: sqlite> update records set content = 'ns2.pccc.com pmc.spamassassin.apache.org YYYYMMDDXX 7200 3600 604800 3600' where id = 198; - Then use pdns_control to send out the NOTIFY: root@sa-vm1:~# pdns_control notify spamassassin.org Added to queue - To dump out the zone from the database for updating SVN and loading back into the database in the event of a fresh start of the PowerDNS database: root@sa-vm1:~# pdnsutil list-zone spamassassin.org > spamassassin.org -Dave Jones