Hello there,
I'm using latest PDNS server authoritative with MySQL backend and I want
to autoadd 2 records (autodiscover/autoconfig CNAMEs) for each zone
available in my db (that has not those records already set), to make it
more clear:
Example.
*zone1.tld*
autodiscover.zone1.tld CNAME autodiscover.outlook.com 3600
autoconfig.zones1.tld CNAME autoconfig.outlook.com 3600
*zone2.tld*
none
*zone3.tld*
none
*zone4.tld*
autodiscover.zone4.tld CNAME autodiscover.outlook.com 3600
autoconfig.zones4.tld CNAME autoconfig.outlook.com 3600
*zone5.tld*
autodiscover.zone5.tld CNAME autodiscover.outlook.com 3600
autoconfig.zones5.tld CNAME autoconfig.outlook.com 3600
Using powerdns db in a mysql shell I can prompt this command
insert into records(domain_id,name,type,content,ttl) VALUES
("*2*","autoconfig.*zonename.tld*","CNAME","/*<my autoconfig
zone>*/","3600");
insert into records(domain_id,name,type,content,ttl) VALUES
("*2*","autodiscover.*zonename.tld*","CNAME","/*<my autodiscover
zone>*/","3600");
but I need to extract all my zones within a script, than use a script to
extract only null zone IDs, than push values inside db: not so practical.
Is there any way to avoid this and push those values inside not
overwriting existing values (where already set)?
After this I'll schedule a "pdnsutil increase-serial" loop to increase
SOA serials and propagate those differences to slaves with AXFR.
Any help is more than welcome!
Thanks all.
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
