master slave replication not working, sqlite backend

[Hubert Krause-2]

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@... 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@..., Web: http://www.inform-ac.com
INFORM Institut fuer Operations Research und Management GmbH
Registered AmtsG Aachen HRB1144 Gfhr. Adrian Weiler
_______________________________________________
Pdns-users mailing list
Pdns-users@...
http://mailman.powerdns.com/mailman/listinfo/pdns-users

[Hubert Krause-2]

Hello again...

Am Monday 05 October 2009 18:25:17 schrieb Hubert Krause:
> 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

I've forgotten to mention my pdns version: it is version 2.9.21.1.

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@..., Web: http://www.inform-ac.com
INFORM Institut fuer Operations Research und Management GmbH
Registered AmtsG Aachen HRB1144 Gfhr. Adrian Weiler
_______________________________________________
Pdns-users mailing list
Pdns-users@...
http://mailman.powerdns.com/mailman/listinfo/pdns-users

[thomas morgan-6]

Hubert--

Try with the IP of your master server in the domain record instead of  
the domain name:

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

I recall having trouble with that at one point, although cannot  
remember the exact error I had.

--t


On Oct 5, 2009, at 10:25 AM, Hubert Krause wrote:

> 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@other-
> domain.com 0 10800
> 3600 604800 3600|86400||20091002
>
> Any hints, any ideas?

_______________________________________________
Pdns-users mailing list
Pdns-users@...
http://mailman.powerdns.com/mailman/listinfo/pdns-users