Re: [Pdns-users] Increment SOA programmatically?
On 2018-11-21 03:49, MRob wrote: On 2018-11-06 08:39, Daniel Miller via Pdns-users wrote: On 11/5/2018 9:15 AM, MRob wrote: still, it didn't work with auto-serial configuration: > pdnsutil increase-serial example.org Error: Parsing record content (try 'pdnsutil check-zone'): missing field at the end of record content 'ns.example.org cont...@example.org 0' could you paste the content of the SOA record for this zone? Same as showed above- ns.example.org cont...@example.org 0 That looks like the problem - SOA records are supposed to have more info. Try: ns.example.org cont...@example.org 2018110601 86400 7200 604800 300 Instead of a simple 0 - suggest using a datestamp and starting with today's config. But the other parameters aren't optional (though you should adjust for your needs). Adding the other SOA fields fixed the problem. Because you told me not to use 0 I could only take to understand your advice not relevant for autoserial use case. I may suggest pdnsutil manpage to update for showing increase-serial command. I use pdns source repo but it's not in my manpage. Also to suggest pdnsutil check-zone to give error on SOA without all fields. It gaves no error so I could think it was correct but it was not. Still one problem though. After pdnsutil increase-serial the serial did increase but in database backend, its still troublesome. Field notified_serial changed from 0 to 1 but last_check is yet as always NULL. How will pdns retain the current SOA serial if rebooted? I think it will reset? Is this bug? well i see now field "notified_serial" is increment every time SOA get increment so I guessing this is ok? I feel confusion because user manual said this for auto-serial: ''The serial in SOA responses is set to what’s provided by zone-lastchange-query. By default, this is the highest value of the change_date field in the “records” table).'' But 'change_date' in records table is also staying NULL, why does that happen? i have no custom queries set. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
On 2018-11-06 08:39, Daniel Miller via Pdns-users wrote: On 11/5/2018 9:15 AM, MRob wrote: still, it didn't work with auto-serial configuration: > pdnsutil increase-serial example.org Error: Parsing record content (try 'pdnsutil check-zone'): missing field at the end of record content 'ns.example.org cont...@example.org 0' could you paste the content of the SOA record for this zone? Same as showed above- ns.example.org cont...@example.org 0 That looks like the problem - SOA records are supposed to have more info. Try: ns.example.org cont...@example.org 2018110601 86400 7200 604800 300 Instead of a simple 0 - suggest using a datestamp and starting with today's config. But the other parameters aren't optional (though you should adjust for your needs). Adding the other SOA fields fixed the problem. Because you told me not to use 0 I could only take to understand your advice not relevant for autoserial use case. I may suggest pdnsutil manpage to update for showing increase-serial command. I use pdns source repo but it's not in my manpage. Also to suggest pdnsutil check-zone to give error on SOA without all fields. It gaves no error so I could think it was correct but it was not. Still one problem though. After pdnsutil increase-serial the serial did increase but in database backend, its still troublesome. Field notified_serial changed from 0 to 1 but last_check is yet as always NULL. How will pdns retain the current SOA serial if rebooted? I think it will reset? Is this bug? ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
MRob writes: > So... any to help on this below keeping in mind I use autoserial? Yeah, Daniel Miller already told you what's wrong and how to fix it. >>> pdnsutil increase-serial example.org >> Error: Parsing record content (try 'pdnsutil check-zone'): missing >> field at the end of record content 'ns.example.org cont...@example.org >> 0' The "missing field at the end" means it's looking for more fields than you've put there. Daniel suggested: > ns.example.org cont...@example.org 2018110601 86400 7200 604800 300 > > Instead of a simple 0 - suggest using a datestamp and starting with > today's config. But the other parameters aren't optional (though you > should adjust for your needs). If you want to use autoserial, you set the serial number itself to 0, as you say, so then you get something like: ns.example.org cont...@example.org 0 86400 7200 604800 300 As Daniel said, the other parameters aren't optional (and the above values for them are just (reasonable) suggestions). -tih -- Most people who graduate with CS degrees don't understand the significance of Lisp. Lisp is the most important idea in computer science. --Alan Kay ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
So... any to help on this below keeping in mind I use autoserial? I use mysql backend and SOA serial set to 0 in datebase for auto-serial features. But sometime come occasion we must update one record in database directly, not using DNSUPDATE. In this case how to tell pdns please update SOA serial? I cant find pdns_control, pdnsutil command for this. Hi, if you execute pdnsutil w/o any options it lists all available commands. There you can find: "increase-serial ZONEIncreases the SOA-serial by 1. Uses SOA-EDIT" oh Thanks! The manpage is out of date :) still, it didn't work with auto-serial configuration: pdnsutil increase-serial example.org Error: Parsing record content (try 'pdnsutil check-zone'): missing field at the end of record content 'ns.example.org cont...@example.org 0' pdnsutil check-zone example.org Checked 21 records of 'example.org', 0 errors, 0 warnings. Related, where is serial stored in auto-serial case? I find "change_date" field NULL on all records and "notified_serial" NULL on this domain (but its 0 on the other domains, not sure why). In this situation what happens if server reboot, SOA has to be reclaimed from somewhere?? As far as I know this can be found in the table "records", column "content", for every entry of the type "SOA". It corresponds to the provided serial number you get with "dig SOA" (if no DNSSEC is active). Well for auto-serial you must set that value as 0 so my question being where the serial is kept in this special case and carried across reboot situation. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
On 2018-11-06 08:39, Daniel Miller via Pdns-users wrote: On 11/5/2018 9:15 AM, MRob wrote: still, it didn't work with auto-serial configuration: > pdnsutil increase-serial example.org Error: Parsing record content (try 'pdnsutil check-zone'): missing field at the end of record content 'ns.example.org cont...@example.org 0' could you paste the content of the SOA record for this zone? Same as showed above- ns.example.org cont...@example.org 0 That looks like the problem - SOA records are supposed to have more info. Try: ns.example.org cont...@example.org 2018110601 86400 7200 604800 300 Instead of a simple 0 - suggest using a datestamp and starting with today's config. But the other parameters aren't optional (though you should adjust for your needs). No, it's autoserial feature https://doc.powerdns.com/authoritative/backends/generic-sql.html#autoserial SOA records are served normal ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
On 11/5/2018 9:15 AM, MRob wrote: still, it didn't work with auto-serial configuration: > pdnsutil increase-serial example.org Error: Parsing record content (try 'pdnsutil check-zone'): missing field at the end of record content 'ns.example.org cont...@example.org 0' could you paste the content of the SOA record for this zone? Same as showed above- ns.example.org cont...@example.org 0 That looks like the problem - SOA records are supposed to have more info. Try: ns.example.org cont...@example.org 2018110601 86400 7200 604800 300 Instead of a simple 0 - suggest using a datestamp and starting with today's config. But the other parameters aren't optional (though you should adjust for your needs). -- Daniel ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
On 2018-11-05 16:49, Nico CARTRON wrote: Hi MRob, On 05-nov-2018 17:34 CET, wrote: On 2018-11-05 10:57, Torsten Hantzsche wrote: > On Sun, 4 Nov 2018, MRob wrote: > > > > I use mysql backend and SOA serial set to 0 in datebase for > > auto-serial features. But sometime come occasion we must update one > > record in database directly, not using DNSUPDATE. In this case how > > to tell pdns please update SOA serial? I cant find pdns_control, > > pdnsutil command for this. > > > > Hi, > > if you execute pdnsutil w/o any options it lists all available commands. > There you can find: > > "increase-serial ZONEIncreases the SOA-serial by 1. Uses SOA-EDIT" oh Thanks! The manpage is out of date :) still, it didn't work with auto-serial configuration: > pdnsutil increase-serial example.org Error: Parsing record content (try 'pdnsutil check-zone'): missing field at the end of record content 'ns.example.org cont...@example.org 0' could you paste the content of the SOA record for this zone? Same as showed above- ns.example.org cont...@example.org 0 > pdnsutil check-zone example.org Checked 21 records of 'example.org', 0 errors, 0 warnings. > > Related, where is serial stored in auto-serial case? I find > > "change_date" field NULL on all records and "notified_serial" NULL on > > this domain (but its 0 on the other domains, not sure why). In this > > situation what happens if server reboot, SOA has to be reclaimed from > > somewhere?? > > > As far as I know this can be found in the table "records", column > "content", > for every entry of the type "SOA". It corresponds to the provided serial > number > you get with "dig SOA" (if no DNSSEC is active). Well for auto-serial you must set that value as 0 so my question being where the serial is kept in this special case and carried across reboot situation. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
Hi MRob, On 05-nov-2018 17:34 CET, wrote: > On 2018-11-05 10:57, Torsten Hantzsche wrote: > > On Sun, 4 Nov 2018, MRob wrote: > > > > > > > I use mysql backend and SOA serial set to 0 in datebase for > > > auto-serial features. But sometime come occasion we must update one > > > record in database directly, not using DNSUPDATE. In this case how > > > to tell pdns please update SOA serial? I cant find pdns_control, > > > pdnsutil command for this. > > > > > > > Hi, > > > > if you execute pdnsutil w/o any options it lists all available commands. > > There you can find: > > > > "increase-serial ZONEIncreases the SOA-serial by 1. Uses SOA-EDIT" > > oh Thanks! The manpage is out of date :) > still, it didn't work with auto-serial configuration: > > > pdnsutil increase-serial example.org > Error: Parsing record content (try 'pdnsutil check-zone'): missing field at > the end of record content 'ns.example.org cont...@example.org 0' could you paste the content of the SOA record for this zone? > > pdnsutil check-zone example.org > Checked 21 records of 'example.org', 0 errors, 0 warnings. > > > > > Related, where is serial stored in auto-serial case? I find > > > "change_date" field NULL on all records and "notified_serial" NULL on > > > this domain (but its 0 on the other domains, not sure why). In this > > > situation what happens if server reboot, SOA has to be reclaimed from > > > somewhere?? > > > > > > As far as I know this can be found in the table "records", column > > "content", > > for every entry of the type "SOA". It corresponds to the provided serial > > number > > you get with "dig SOA" (if no DNSSEC is active). > > Well for auto-serial you must set that value as 0 so my question being where > the serial is kept in this special case and carried across reboot situation. > ___ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users -- Nico ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
On 2018-11-05 10:57, Torsten Hantzsche wrote: On Sun, 4 Nov 2018, MRob wrote: I use mysql backend and SOA serial set to 0 in datebase for auto-serial features. But sometime come occasion we must update one record in database directly, not using DNSUPDATE. In this case how to tell pdns please update SOA serial? I cant find pdns_control, pdnsutil command for this. Hi, if you execute pdnsutil w/o any options it lists all available commands. There you can find: "increase-serial ZONEIncreases the SOA-serial by 1. Uses SOA-EDIT" oh Thanks! The manpage is out of date :) still, it didn't work with auto-serial configuration: pdnsutil increase-serial example.org Error: Parsing record content (try 'pdnsutil check-zone'): missing field at the end of record content 'ns.example.org cont...@example.org 0' pdnsutil check-zone example.org Checked 21 records of 'example.org', 0 errors, 0 warnings. Related, where is serial stored in auto-serial case? I find "change_date" field NULL on all records and "notified_serial" NULL on this domain (but its 0 on the other domains, not sure why). In this situation what happens if server reboot, SOA has to be reclaimed from somewhere?? As far as I know this can be found in the table "records", column "content", for every entry of the type "SOA". It corresponds to the provided serial number you get with "dig SOA" (if no DNSSEC is active). Well for auto-serial you must set that value as 0 so my question being where the serial is kept in this special case and carried across reboot situation. ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Increment SOA programmatically?
On Sun, 4 Nov 2018, MRob wrote: I use mysql backend and SOA serial set to 0 in datebase for auto-serial features. But sometime come occasion we must update one record in database directly, not using DNSUPDATE. In this case how to tell pdns please update SOA serial? I cant find pdns_control, pdnsutil command for this. Hi, if you execute pdnsutil w/o any options it lists all available commands. There you can find: "increase-serial ZONEIncreases the SOA-serial by 1. Uses SOA-EDIT" Related, where is serial stored in auto-serial case? I find "change_date" field NULL on all records and "notified_serial" NULL on this domain (but its 0 on the other domains, not sure why). In this situation what happens if server reboot, SOA has to be reclaimed from somewhere?? As far as I know this can be found in the table "records", column "content", for every entry of the type "SOA". It corresponds to the provided serial number you get with "dig SOA" (if no DNSSEC is active). Torsten ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users