[Pdns-users] master slave replication not working, sqlite backend

[Hubert Krause]

Hello to all...

Ive got a Problem with to servers with powerdns, one is the master, one the 
slave both use a sqlite backend. Master Slave is not working. If I do for 
example on the slave: 
dig @master axfr my.domin.com
I will get:

; <<>> DiG 9.3.4-P1 <<>> @master axfr my.domain.com
; (1 server found)
;; global options:  printcmd
my.domain.com.         86400   IN      SOA     master.domain.com. 
hostmaster.other-domain.com. 0 10800 3600 604800 3600
;; Query time: 4 msec
;; SERVER: 192.168.123.45#53(192.168.123.45)
;; WHEN: Mon Oct  5 17:16:36 2009
;; XFR size: 1 records (messages 1)

But no A records and other stuff I would expect from axfr. There are always 
two different erromessages, if I do the command above the following appears 
in the logfile:

Oct  5 17:36:56 master pdns[5909]: AXFR of domain 'my.domain.com' initiated by 
192.168.123.113
Oct  5 17:36:56 master pdns[5909]: TCP server is without backend connections 
in doAXFR, launching
Oct  5 17:36:56 master pdns[5909]: gsqlite3: connection 
to '/var/db/pdns/pdns.sqlite3' succesful
Oct  5 17:36:56 master pdns[5909]: gsqlite3: connection 
to '/var/db/pdns/pdns.sqlite3' succesful
Oct  5 17:36:56 master pdns[5909]: AXFR of domain 'my.domain.com' to 
192.168.123.113 finished
Oct  5 17:36:56 master pdns[5909]: TCP nameserver had error, cycling backend: 
Reading data: Connection reset by peer

or:

Oct  5 17:37:21 master pdns[5909]: AXFR of domain 'my.domain.com' initiated by 
192.168.123.113
Oct  5 17:37:21 master pdns[5909]: TCP server is without backend connections 
in doAXFR, launching
Oct  5 17:37:21 master pdns[5909]: gsqlite3: connection 
to '/var/db/pdns/pdns.sqlite3' succesful
Oct  5 17:37:21 master pdns[5909]: gsqlite3: connection 
to '/var/db/pdns/pdns.sqlite3' succesful
Oct  5 17:37:21 master pdns[5909]: AXFR of domain 'my.domain.com' to 
192.168.123.113 finished
Oct  5 17:37:21 master pdns[5909]: Received question from socket which had no 
remote address, dropping (Transport endpoint is not connected)

The configuration of the master is:

allow-axfr-ips=192.168.12.0/24,192.168.123.0/24,10.0.0.0/24
allow-recursion=192.168.12.0/24,192.168.123.0/24,10.0.0.0/24
allow-recursion-override=yes
disable-axfr=no
launch=gsqlite3
gsqlite3-database=/var/db/pdns/pdns.sqlite3
local-address=192.168.123.112,192.168.12.112,10.0.0.112
log-dns-details=yes
log-failed-updates=yes
master=yes
recursor=172.16.51.19
setgid=pdns
setuid=pdns
slave=no

The configuration of the slave is:

allow-recursion=192.168.12.0/24,192.168.123.0/24,10.0.0.0/24
allow-recursion-override=yes
launch=gsqlite3
gsqlite3-database=/var/db/pdns/pdns.sqlite3
local-address=192.168.123.113,192.168.12.113
recursor=172.16.51.19
setgid=pdns
setuid=pdns
slave=yes

the database has read write permissons by pdns user and group. Name 
resolutions works very well. A typical entry into the domain-table looks 
like:

2|my.domain.com|master.domain.com||MASTER||foobar

and an example for an SOA record is:

115|2|my.domain.com|SOA|master.domain.com hostmaster at other-domain.com 0 10800 
3600 604800 3600|86400||20091002

Any hints, any ideas?

Best regards,

Hubert

-- 
Hubert Krause
Risk & Fraud Division
INFORM GmbH, Pascalstraße 23, 52076 Aachen, Germany
Phone: +49 24 08 - 94 56 188
E-Mail: hubert.krause at inform-ac.com, Web: http://www.inform-ac.com
INFORM Institut fuer Operations Research und Management GmbH
Registered AmtsG Aachen HRB1144 Gfhr. Adrian Weiler