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

[MRob]

On 2019-02-04 10:40, MRob wrote:
> 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.

Is there a set of things I should check for the records or the dns 
update?




>> 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
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users