PowerDNS
Prerequisites
Database setup
See http://downloads.powerdns.com/documentation/html/generic-mypgsql-backends.html#AEN5226
I’m using Poweradmin as fronted now; as i do not really trust the implementation i put it behind http auth and gave only trusted users access :)
Somehow their upgrade process sucks – they didn’t update the sql commands to create the needed tables, so i had to create them manually after an update.
pdns.local.gpgsql:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
# PostgreSQL Configuration
#
gpgsql-host=
gpgsql-port=
gpgsql-dbname=system
gpgsql-user=pdns
gpgsql-password=
# the other tables are just views from the tables managed by poweradmin; for this 4 queries i needed direct access
gpgsql-update-serial-query=update dnsadmin.domains set notified_serial=%d where id=%d
gpgsql-insert-record-query=insert into dnsadmin.records (content,ttl,prio,type,domain_id,name) values ('%s',%d,%d,'%s',%d,'%s')
gpgsql-delete-zone-query=delete from dnsadmin.records where domain_id=%d
gpgsql-update-lastcheck-query=update dnsadmin.domains set notified_serial=%d where id=%d
|
pdns.local:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
launch=gpgsql
disable-axfr=no
allow-axfr-ips=comma-separated ip list of slaves
local-address=yourlocalip
# local-ipv6=your-ipv6 # you have to know yourself whether you need this line :)
master=yes
slave=yes
# enable wildcard dns names
wildcards=yes
distributor-threads=1
|