[Pdns-users] anual AXFR works, automatic does not (txt-version)

[LikeFiction]

Ok, I think I found the problem.  It's quite simple too.

My zones are not changing very often. So, after my re-setup of NS2, and 
restart master-powerdns, the "notified-serial" and the first digit 
serial of "SOA" where the same. If notified-serial is smaller than SOA, 
only then PowerDNS will do an AXFR.

So, indeed, after setting up a new/extra nameserver, to start the 
transfer, one should just run SQL:

UPDATE domains set notified_serial=0

and make sure that every SOA record is NOT 0. Then, PowerDNS will start 
notifying slaves.

I think it might be a good idea for future versions of PowerDNS, to 
"force" updating all slaves when PowerDNS is started.


With kind regards / Met vriendelijke groet,


Pierre van den Oord

LikeFiction
Kleyn Proffijtlaan 49
2343 DB Oegstgeest
The Netherlands

T +31 (0)85 7850699 (Mo-Fr 10-17, GMT +1)
T +31 (0)6 12469791 (Mobile)
M info at LikeFiction.com
W www.LikeFiction.com
---------------------------------------------------
Please include the original message when you reply!
---------------------------------------------------

Op 6-8-2010 16:45, LikeFiction schreef:
>  > While i can not find anything that looks obviously wrong to me, you
> might try the following:
>  > - setting domains.notified_serial to 0 or 1.
>  > - providing a full set of ttls in the SOA record such as
> "ns1.sologigabit.com. info.sologigabit.com. 2010080500 10800 3600 604800
> 3600"
>
> After stopping Pdns, setting notified serial to 0, and starting powerdns
> in monitor mode, I immediately see an AXFR for this domain come up, and
> it gets transferred indeed.
>
> Other solution I found:
> Lower the first digit of the SOA field, then start Powerdns. I changed
> it from 2010080500 to 1010080500. Now also a transfer took place.
>
> Adding the 10800 3600 604800 3600 expire values does not seem to do
> anything (except after also lowering the first number). Or do I have to
> wait (long) for that? That would not be right, if it was the case.
> However, why does PowerDNS notifies my slave if I lower either the first
> SOA number, or set the notified serial to 0?
>
>
> Daemon.log shows:
> Aug 6 16:37:21 webserver pdns[29052]: Listening on controlsocket in
> '/var/run/pdns.controlsocket'
> Aug 6 16:37:21 webserver pdns[29054]: Guardian is launching an instance
> Aug 6 16:37:21 webserver pdns[29054]: This is module gmysqlbackend.so
> reporting
> Aug 6 16:37:21 webserver pdns[29054]: This is a guarded instance of pdns
> Aug 6 16:37:21 webserver pdns[29054]: UDP server bound to 95.215.63.212:53
> Aug 6 16:37:21 webserver pdns[29054]: TCP server bound to 95.215.63.212:53
> Aug 6 16:37:21 webserver pdns[29054]: PowerDNS 2.9.21.2 (C) 2001-2008
> PowerDNS.COM BV (Nov 25 2008, 22:40:57, gcc 4.3.2) starting up
> Aug 6 16:37:21 webserver pdns[29054]: PowerDNS comes with ABSOLUTELY NO
> WARRANTY. This is free software, and you are welcome to redistribute it
> according t$
> Aug 6 16:37:21 webserver pdns[29054]: Creating backend connection for TCP
> Aug 6 16:37:21 webserver pdns[29054]: Master/slave communicator launching
> Aug 6 16:37:21 webserver pdns[29054]: gmysql Connection succesful
> Aug 6 16:37:21 webserver pdns[29054]: All slave domains are fresh
> Aug 6 16:37:21 webserver pdns[29054]: gmysql Connection succesful
> Aug 6 16:37:21 webserver pdns[29054]: About to create 3 backend threads
> for UDP
> Aug 6 16:37:21 webserver pdns[29054]: gmysql Connection succesful
> Aug 6 16:37:21 webserver pdns[29054]: No master domains need notifications
> Aug 6 16:37:21 webserver pdns[29054]: gmysql Connection succesful
> Aug 6 16:37:21 webserver pdns[29054]: gmysql Connection succesful
>
>
>
> With kind regards / Met vriendelijke groet,
>
>
> Pierre van den Oord
>
> LikeFiction
> Kleyn Proffijtlaan 49
> 2343 DB Oegstgeest
> The Netherlands
>
> T +31 (0)85 7850699 (Mo-Fr 10-17, GMT +1)
> T +31 (0)6 12469791 (Mobile)
> M info at LikeFiction.com
> W www.LikeFiction.com
> ---------------------------------------------------
> Please include the original message when you reply!
> ---------------------------------------------------
>
> Op 6-8-2010 16:11, Stefan Schmidt schreef:
>>
>> On Aug 6, 2010, at 15:52 , LikeFiction wrote:
>>
>>> Stefan: As there is no sensitive information inside the tables, I
>>> have opened up http://ns1.sologigabit.com/phpmyadmin with user "help"
>>> and password "help". You can browse all PDNS tables easily that way.
>>> For the mailing list archive, I also present the data for one domain
>>> here:
>>
>> While i can not find anything that looks obviously wrong to me, you
>> might try the following:
>> - setting domains.notified_serial to 0 or 1.
>> - providing a full set of ttls in the SOA record such as
>> "ns1.sologigabit.com. info.sologigabit.com. 2010080500 10800 3600
>> 604800 3600"
>>
>> Also what does your daemon.log - or wherever pdns logs to - say about
>> this?
>>
>> Stefan
>>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users