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

MRob mrobti at insiberia.net
Mon Feb 4 10:11:39 UTC 2019


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?


More information about the Pdns-users mailing list