Re: [Pdns-users] DNS UPDATE failing (Failed PreReqqisites check)
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 +, 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 ExecuteSELECT 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 Executeselect 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 ExecuteSELECT 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 ExecuteSELECT 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@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] DNS UPDATE failing (Failed PreReqqisites check)
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 +, 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 ExecuteSELECT 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 Executeselect 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 ExecuteSELECT 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 ExecuteSELECT 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@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] DNS UPDATE failing (Failed PreReqqisites check)
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 +, 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 ExecuteSELECT 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 Executeselect > 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 ExecuteSELECT > 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 ExecuteSELECT > 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@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] DNS UPDATE failing (Failed PreReqqisites check)
Hi, On 2/4/19 11:11 AM, MRob wrote: > 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. Please start by upgrading to 4.1.6, yes. The alpha release shipped by Ubuntu is broken in many ways and should not be used by anyone. Best regards, -- Remi Gacogne PowerDNS.COM BV - https://www.powerdns.com/ signature.asc Description: OpenPGP digital signature ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
[Pdns-users] DNS UPDATE failing (Failed PreReqqisites check)
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 ExecuteSELECT 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 Executeselect 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 ExecuteSELECT 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 ExecuteSELECT 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@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users