[Pdns-users] cpanel only - virtualizor - pdns setup comments?

2015-05-08 Thread Steve Young
Hey all... I guess since I signed up for the list for a previous question I thought I might ask if others are running this setup I'm playing with ;-). I've been getting up to speed with Virtualizor from the Softaculous guys and initially I started out using their package of pdns. But after evaluat

Re: [Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

2015-05-08 Thread Jordan Rieger
Very nice! Did you write that just for me?? Or was it floating around your company and you just posted it today? The GitHub archive says only 1 commit :) -Original Message- From: Christian Hofstaedtler [mailto:christian.hofstaedt...@deduktiva.com] Sent: Friday, May 08, 2015 4:27 PM To: J

Re: [Pdns-users] Issue with mydns backend?

2015-05-08 Thread Steve Young
Ahh that was it... my init script was still referencing the package install in /usr instead of the one I built in /usr/local. Switched and now it's calling the right version. Thanks for the heads up ;-). -Steve * *Steven L. Young* Sly Media Networks, LLC *

Re: [Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

2015-05-08 Thread Christian Hofstaedtler
Hi, > On 08 May 2015, at 02:07, Jordan Rieger 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

Re: [Pdns-users] Issue with mydns backend?

2015-05-08 Thread Christian Hofstaedtler
> On 08 May 2015, at 23:18, Steve Young wrote: [..] > May 8 17:15:25 ns1 pdns[9289]: Unable to load module > '/usr/lib64/pdns/libmydnsbackend.so': /usr/lib64/pdns/libmydnsbackend.so: > undefined symbol: _ZN10DNSBackend7getAuthEP9DNSPacketP7SOADataRKSsi > May 8 17:15:25 ns1 pdns[9289]: dnsba

Re: [Pdns-users] Issue with mydns backend?

2015-05-08 Thread Steve Young
Thanks Bert... Sorry I did have the quotes around them to begin with.. I just copied the line from config.log which has the quotes omitted ;-). The modules are built: root@ns1 [~/pdns]# ls -l /usr/lib64/pdns total 4424 drwxr-xr-x 2 root root4096 May 3 03:12 ./ dr-xr-xr-x 44 root root 32

Re: [Pdns-users] Issue with mydns backend?

2015-05-08 Thread bert hubert
On Fri, May 08, 2015 at 05:18:06PM -0400, Steve Young wrote: > Hi, >I've built pdns with the following options: > > ./configure --with-modules=bind gmysql mydns --without-lua Try: ./configure --with-modules="bind gmysql mydns" --without-lua With the quotes. Good luck! Bert > > a

[Pdns-users] Issue with mydns backend?

2015-05-08 Thread Steve Young
Hi, I've built pdns with the following options: ./configure --with-modules=bind gmysql mydns --without-lua and the libraries are there but I get this message in the logs over and over again: May 8 17:15:24 ns1 pdns[6839]: Respawning May 8 17:15:25 ns1 pdns[9289]: Guardian is launching an i

Re: [Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

2015-05-08 Thread Jordan Rieger
I think we actually had a license for a different version of TOAD at one point. I'll check it out. Thanks John. From: John Miller [mailto:johnm...@brandeis.edu] Sent: Friday, May 08, 2015 12:11 PM To: Jordan Rieger Cc: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] Easiest way t

Re: [Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

2015-05-08 Thread John Miller
Hi Jordan, In the past, I've used a Windows-based tool called TOAD ( http://software.dell.com/products/toad-for-mysql/). It allows you to do a direct comparison between two different databases: just log into your MySQL server from TOAD and you should be on your way. If you're worried about dupli

Re: [Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

2015-05-08 Thread Jim Richardson
If it helps, I have a script I wrote to do dns comparisons between resolvers, you can find it in my github repo for misc monitoring scripts. https://github.com/weaselkeeper/misc_monitoring_scripts the script in question is dnscompare.py It will compare zones as well as host records. If that helps

Re: [Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

2015-05-08 Thread Pavel Ondřej
Hi, the easist way is this software: https://www.devart.com/dbforge/mysql/datacompare/ Pavel 2015-05-08 19:31 GMT+02:00 Jan-Piet Mens : > > 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?

Re: [Pdns-users] Easiest way to compare two PowerDNS MYSQL zones (or whole databases)

2015-05-08 Thread Jan-Piet Mens
> 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? Instead of mucking about with SQL what I would probably do is configure both servers as masters; then, on each, AXFR each of the zones, and use