[Pdns-users] Increment SOA programmatically?

[Nico CARTRON]

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?

> > 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.
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users

-- 
Nico