[Pdns-users] DNS UPDATE failing (Failed PreReqqisites check)

[MRob]

On 2019-02-04 10:21, Ruben d'Arco wrote:
> Hi MRob,
> 
> The DNS Update specification (RFC2136) has a section that allows a DNS
> update to do check (pre-requisites) before applying the update.
> PDNS performs these checks, and it seems that the current records of
> your domain do not comply with those pre-requisites.
> 
> Can you show us the records from your domain and the dns update that
> you're sending?

Thank you for responding. I will try first to upgrade pdns version as 
Remi said. If I need send dns update command for inspection is the best 
way to capture it using tcpdump? I'll send current domain records also, 
but it's nothing, just the SOA. Do I need a SOA for reverse DNS too?



> On Mon, Feb 04, 2019 at 10:11:39AM +0000, MRob wrote:
>> Trying to use DNS updates but seeing the error in our logs "Failed
>> PreReqqisites check, returning 6". Could someone explain what 
>> "prerequisites
>> check" is and what can cause it to fail? What things should I check?
>> 
>> Here is pdns log from one instance
>> Feb  3 03:20:17 test pdns[20989]: Query: begin
>> Feb  3 03:20:17 test pdns[20989]: Query: SELECT
>> content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
>> disabled=0 and name=?
>> Feb  3 03:20:17 test pdns[20989]: UPDATE (50855) from 10.10.1.254 for 
>> lan.:
>> Failed PreRequisites check, returning 6
>> Feb  3 03:20:17 test pdns[20989]: Query: rollback
>> 
>> Here is sql log from same time, seems normal:
>> 2019-02-03T08:20:17.424815Z   16 Reset stmt
>> 2019-02-03T08:20:17.424946Z   16 Execute        SELECT id FROM domains 
>> WHERE
>> id = -1 OR name = 'lan'
>> 2019-02-03T08:20:17.425130Z   16 Reset stmt
>> 2019-02-03T08:20:17.425226Z   16 Execute        select
>> id,name,master,last_check,notified_serial,type,account from domains 
>> where
>> name='lan'
>> 2019-02-03T08:20:17.425418Z   16 Reset stmt
>> 2019-02-03T08:20:17.425540Z   16 Execute        SELECT
>> content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
>> disabled=0 and type='SOA' and name='lan'
>> 2019-02-03T08:20:17.425853Z   16 Reset stmt
>> 2019-02-03T08:20:17.425987Z   16 Query  begin
>> 2019-02-03T08:20:17.426196Z   16 Execute        SELECT
>> content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
>> disabled=0 and name='wrkstn12.lan'
>> 2019-02-03T08:20:17.426370Z   16 Reset stmt
>> 2019-02-03T08:20:17.426411Z   16 Query  rollback
>> 
>> Version is 4.0.0-alpha2 from repo where nothing newer available. Would 
>> it be
>> productive to use repo supplied by powerdns.com, I mean is it possible 
>> a bug
>> is in this version and has been fixed. Or is pdns innocent and problem 
>> with
>> the DDNSUPDATE client?
>> _______________________________________________
>> Pdns-users mailing list
>> Pdns-users at mailman.powerdns.com
>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users