Installing PowerDNS with OpenDBX (MySQL backend) on CentOS 5 x64

When switching to PowerDNS for our master zones we needed auto-serial update for an easy way to integrate with our backoffice. This is not possible with the built-in gmysql backend. It is possible with some db adjustments and OpenDBX with PowerDNS 2.9.22 RC1 (no stable release yet when I’m writing this).

Download & build OpenDBX 1.2.6 (

LDFLAGS="-L/usr/lib64/mysql" CPPFLAGS="-I/usr/include/mysql" ./configure --prefix=/usr --with-backends="mysql"
make && make install

Download and build PDNS 2.9.22 rc1 (pdns-2.9.22-rc1.20081118.1302.tar.gz)

First download Boost and just untar it (boost_1_37_0.tar.gz)

Make sure you have zlib (x64);

yum install zlib-devel.x86_64

Compile PDNS with OpenDBX (point to the untarred Boost);

CXXFLAGS="-I/usr/src/boost_1_37_0" ./configure --prefix=/usr --with-modules="" --with-dynmodules="opendbx"
make && make install

Modify your PDNS db as described here: http://www.linuxnetworks.de/doc/index.php/PowerDNS_OpenDBX_Backend/Migration

Change your config as described here: http://www.linuxnetworks.de/doc/index.php/PowerDNS_OpenDBX_Backend/Configuration/Basic

Add to /usr/etc/pdns.conf: module-dir=/usr/lib