PowerDNS problems

William

Anyone seen this before? I'm lost :(

I'm following this guide: http://www.howtoforge.com/installing-powerdns-with-mysql-backend-and-poweradmin-on-debian-squeeze-p2

And get this in Syslog: Sep 14 06:07:54 anycast pdns[18777]: Guardian is launching an instance Sep 14 06:07:54 anycast pdns[18777]: Reading random entropy from '/dev/urandom' Sep 14 06:07:54 anycast pdns[18777]: This is module gmysqlbackend.so reporting Sep 14 06:07:54 anycast pdns[18777]: Fatal error: Trying to launch unknown backend 'gmysql;' Sep 14 06:07:55 anycast pdns[18771]: Our pdns instance exited with code 1 Sep 14 06:07:55 anycast pdns[18771]: Respawning

rds100

Be a man, use bind and rsync :)

gbshouse

@William Step 1 apt-get install pdns-server pdns-backend-mysql

Step 2 in /etc/powerdns/pdns.conf

launch=gmysql gmysql-socket=/var/run/mysqld/mysqld.sock gmysql-user=username gmysql-dbname=dbname

Step 3 to diagnose instead of /etc/init.d/pdns start type /etc/init.d/pdns monitor

NanoG6

have you installed pdns-backend-mysql?

root@it:~# cat /etc/powerdns/pdns.d/pdns.local 
# Here come the local changes the user made, like configuration of 
# the several backends that exist.
gmysql-host=127.0.0.1
gmysql-user=poweradmin
gmysql-password=powerpass
gmysql-dbname=powerdns

gbshouse

If you can consider moving from Debian to Ubuntu 12.04 then you can use our custom build from https://launchpad.net/~gbshouse/+archive/pdns version 3.1-4ubuntu1ppa12

William

dang, i am dumb - had "launch=gmysql;" in it as i'm used to from Nginx and PHP config files, it now works... :)

gbshouse

@William - Debian uses PowerDNS version 2.X which is not best choice, consider version 3.X from Ubuntu

William

well what are the major differences? i only run like 50 zones anyway.. (anyone got a bind zonefile -> powerdns mysql importer?)

NanoG6

@William said: had "launch=gmysql;"

Oh the semicolon ;)

gbshouse

@William - 2.X -> 3.0 http://doc.powerdns.com/upgrades.html#from2.9to3.0 3.0 -> 3.1 http://doc.powerdns.com/from3.0to3.1.html

@William said: anyone got a bind zonefile -> powerdns mysql importer?

http://doc.powerdns.com/migration.html#zone2sql

William

@gbshouse said: http://doc.powerdns.com/upgrades.html#from2.9to3.0

Hm interesting:

With similar settings, version 3.0 will most likely use a lot more memory than 2.9.

I am quite limited by my ram.. and will Poweradmin still work with that?

Chief

@William said: I am quite limited by my ram.. and will Poweradmin still work with that?

If it's only 50 zones why not just SSH in and use an SQL manager? If they're limited on RAM this may save you needing to run the poweradmin interface.

Optionally, couldn't you just put the poweradmin interface on a larger LEB and just keep the slaves as minimal?

gbshouse

@William - it should work maybe except some DNSSEC stuff

William

Hm, i stay with 2.X for now but thatnks for the links and the importer @gbshouse (and no, don't worry - this wont be a service like yours, only my personal DNS) :)

Also, set up MySQL replication, installed the powerdns "slaves" as normal install (same settings as the master, did not install Poweradmin obviously) and only granted the mysql users for them the SELECT privilege so they can't write to the DB or modify anything. Seems to work fine for now.

Anything else to do? Keep in mind that i run Master-Master-Master-Master as all DNS servers use the same IPs (anycast) and i dont need to specify them as "slaves"

@Chief said: Optionally, couldn't you just put the poweradmin interface on a larger LEB and just keep the slaves as minimal?

I did not follow this guide entirely, i don't use Apache - I use Nginx and PHP-FPM which has much less overhead so the Poweradmin does not need much ram (and the Master has 512MB anyway instead of 256MB RAM as vr.org has no 256MB instance sin Hongkong)

William

if someone wants to test:

dig test.kz @176.124.70.5 ("NS1") dig test.kz @176.124.70.10 ("NS2")

Nodes currently: NYC, NY, US (Working) AMS, Netherlands (Working) Chennai, India (Not whitelisted yet) Hongkong, Hongkong (Not whitelisted yet)

Added soon: LA, CA, US London, UK Milan, Italy (if i get my BGP session from Sal :P)

gbshouse

@William - one issue: according to RFC (I don't remember which one) NS1 and NS2 should be from two different class C IP spaces - but it's just theory. From my experience: change the version-string in pdns.conf to your own custom like "My DNS server 1.2.3". In case of nmap-ing or something for holes it can help

prometeus

@William said: Milan, Italy (if i get my BGP session from Sal :P)

next week you will have it :-)

gbshouse

@William - few issues in https://www.centralnic.com/support/doctor?op=diagnose&_PRINTABLE=&domain=test.kz

William

@gbshouse: This errors are normal, i don't own this domain, i just added it for testing to my DNS ;)

Wintereise

@Chief What client is that? It looks nice.