[Pdns-users] pdnsutil increase-serial not working for mysql with autoserial

[Nico CARTRON]

Hi,

Somebody pointed out that you’re missing some fields in your SOA records. 
Please correct it using what has been suggested and try again.  

-- 
Nico

> On 7 Nov 2018, at 21:40, MRob <mrobti at insiberia.net> wrote:
> 
> in fact after reboot looks like old serial is lost for all domains.
> 
> why is change_date not kept up to date?  all domains have it to be NULL, I think its where the serial is derived from when using autoserial
> 
> 
>> On 2018-11-07 20:18, MRob wrote:
>> Please some help for this? Looks like pdnsutil increase-serial not
>> made to work for mysql backend with autoserial, so how to
>> programmatically request increase serial?
>>> 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'
>>> 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