Hi, > On 08 May 2015, at 02:07, Jordan Rieger <[email protected]> wrote: > > What do you guys think would be the best approach for comparing two PowerDNS > MYSQL databases that are supposed to hold the same domains and records? I > want to produce a list of discrepancies between the two databases, e.g. > domains missing from one but not the other, records missing from one but not > the other, etc. [..] > Do you know of a tool or API command that would make this easier? (Other than > a generic database data comparison tool.)
Using the API this is basically "a small matter of programming". You can find a small script (which can happily serve as a demonstration of the API, too), here: https://github.com/Deduktiva/pdnsutil/blob/master/zonediff Example output: ./zonediff changeme http://127.0.0.1:8081 http://172.16.190.53:8081 I: server1: URL: http://127.0.0.1:8081, Name: local I: server2: URL: http://172.16.190.53:8081, Name: dns01 W: Zones missing from dns01: test-24231446052119.org diff zone example.org on server local to server dns01 --- local/example.org +++ dns01/example.org @@ -16,5 +16,5 @@ fred.example.org A 86400 192.168.0.4 bill.example.org A 86400 192.168.0.3 ftp.example.org CNAME 86400 www.example.org -test.example.org A 86400 1.1.1.4 +test.example.org TXT 86400 1.1.1.4 www.example.org A 86400 192.168.0.2 diff zone 8.b.d.0.1.0.0.2.ip6.arpa on server local to server dns01 --- local/8.b.d.0.1.0.0.2.ip6.arpa +++ dns01/8.b.d.0.1.0.0.2.ip6.arpa @@ -10,5 +10,4 @@ ; soa_edit_api = 8.b.d.0.1.0.0.2.ip6.arpa SOA 3600 a.misconfigured.powerdns.server hostmaster.8.b.d.0.1.0.0.2.ip6.arpa 0 10800 3600 604800 3600 8.b.d.0.1.0.0.2.ip6.arpa NS 3600 ns1.example.com -8.b.d.0.1.0.0.2.ip6.arpa NS 3600 ns2.example.com a.a.0.0.b.b.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.8.b.d.0.1.0.0.2.ip6.arpa PTR 3600 test-24231246750228.org diff zone example1.org on server local to server dns01 --- local/example1.org +++ dns01/example1.org @@ -11,4 +11,4 @@ example1.org SOA 3600 a.misconfigured.powerdns.server hostmaster.example1.org 0 10800 3600 604800 3600 example1.org NS 3600 ns1.example.org example1.org NS 3600 ns2.example.org -www.example1.org A 3600 4.3.2.1 +www.example1.org A 3600 2.3.31.4 --- I: 39 zones, 3 different, 36 identical, plus 0 errors Best, -- Christian Hofstaedtler / Deduktiva GmbH (FN 418592 b, HG Wien) www.deduktiva.com / +43 1 353 1707 _______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
