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

[Ruben d'Arco]

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?

Regards,
       Ruben


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