Hello all I see that table dns_rr in ispconfig main databases is updated each time cron /usr/local/ispconfig/server/cron.php is started. But we don't want that cron to run and yet I want that table dns_rr is regulary updated. Is that possible? How would I proceed with that?
No, that's not the case. The server cronjob does not update anything in dns_rr. The exact opposite is the case, when a config transaction in sys_datalog get's added, then the server cronjob picks that up and does the nescessary configuration in the system.
So if we have a script that is doing manual changes in that table, for those changes to be visible in /etc/bind/pri.nameofthewebsite we should just restart bind? Or is there something more needed?
Do not alter data in that table manually, such changes will net get applied and not read by bind as they do not belong to a valid config transaction. Use the ISPConfig remote API instead to alter DNS records from a script. If you have done a mass change in the database like altering all IP addresses, then you can also use Tools > Resync in ISPConfig to trigger an update of all zones.
Hello again. We managed to get api working. But now I have new issue. First let me mention that both ISPconfig cron's that run every minute are disabled. In order for zone to be resynced with table dns_rr is starting cron only way? If we use Tools > Resync in panel it is just stuck in jobque until I start cron manually. Is there any way to resync bind files with database without using crons? Even a simple command for command line would help us. Anything but starting those ispconfig cronjobs. Thank you.
ISPConfig will not work then. The cron's must be enabled, otherwise ISPConfig will not write any changes to config files. If you want to do it manually, then run the command of the cronjob (server.sh) manually as root user.
