Closed skkelma closed 4 years ago
This query worked for me to bulk update the field.
UPDATE domainmetadata SET content='DEFAULT' WHERE kind='SOA-EDIT-API' AND content='INCEPTION-INCREMENT';
Yes, you surely can convert the DB this way.
But after that, cretaing a new zone with the GUI will still lead to the wrong 'INCEPTION-INCREMENT' value. This had to be changed in DNS UI sources:
./model/zone.php: (627)
$data->soa_edit_api = 'DEFAULT';
./model/zonedirectory.php: (102)
$data->soa_edit_api = 'DEFAULT';
In PowerDNS 4.2 branch support for the SOA-EDIT-API value INCEPTION-INCREMENT is dropped: https://blog.powerdns.com/2019/08/30/powerdns-authoritative-server-4-2-0/ https://blog.powerdns.com/2018/12/07/important-changes-in-powerdns-authoritative-server-4-2-0/ So it would be nice to change the fixed SOA-EDIT-API value to "DEFAULT" in model/zone.php (627) and model/zonedirectory.php (102). From my understanding this works like the wanted autoserial behaviour. https://doc.powerdns.com/authoritative/domainmetadata.html#soa-edit-api https://doc.powerdns.com/authoritative/dnsupdate.html#soa-edit-dnsupdate-settings