Hi, Is it possible to update MANY DNS records in using mysql, and then run the server.sh script so the zone fils will be updated too ? I have a lot of domains witch have a wrong TTL record. And it will take to long time to update them manuel. So im looking for a way to do it with a script. I have all ready tryed with changeing it in mysql, and then run the server.sh script, but zone files is nerver updated with TTL. Im running multiserver ISPConfig v.3.0.5.4p8 Any suggestions are welcome Best regards
one way could be to use the API to check the TTL in the db, and then submit altered TTL through the API. or what florian030 said. Edit: meant the resync thingy
I DID NOT said: run nstaller/update script just update the fields in the masterdatabase and let ispconfig resync the dns-settings
Thanks for your help. I have a multiserver environment, and im not sure witch one have the the masterdatabase. All the servers have there own dbispconfig db, but witch one is master? Is there any way to check this ? Best regards
Okay, I just think I have all ready tried this, but ill give it a go again. Thanks. So I just need to update master db, and then wait for db to resync, or can I call a command to start the resync ? Im currently using server.sh, is this wrong ?
1) Update the records in the database. 2) Login to ispconfig, go to tools > resync, select dns and start the resync.
Damn, I feel stupid. I did not see this resync function under tools before now. :-( Thanks all for your help. Sorry for the trouble I have made. Best regards
Hi again, I only need to make changes to the TTL record. But do I need to change stamp & serial too before it will update using the resync button ? Best regards
You have to change the serial as well. the resync will just do a force write of the config files based on the database data.
Okay, thanks till, I have another question ill hope you can explain to me. I cant seem to find any cname records in the dns_rr database table, is this correct ? The cname records are working just fine, but where can I find them?
If you added cname records in ISPConfig then they are in this table and ISPConfig will not add any cnames to a dns zone that dont exist in this table.
