[Pdns-users] Increment SOA programmatically?

[MRob]

On 2018-11-05 16:49, Nico CARTRON wrote:
> Hi MRob,
> 
> On 05-nov-2018 17:34 CET, <mrobti at insiberia.net> 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 ZONE    Increases 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 contact at example.org 0'
> 
> could you paste the content of the SOA record for this zone?

Same as showed above-
ns.example.org contact at 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 <zone> 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.