I am gettign the below after doing a dns resync for every domain 10.04.2017-10:03 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = REPLACE INTO `dns_rr` (`id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`zone`,`name`,`type`,`data`,`aux`,`ttl`,`active`,`stamp`,`serial`) VALUES ('1862','123','122','riud','riud','','3','127','icravefreebies.com.','MX','mx2.dido.ca.','20','300','Y','0000-00-00 00:00:00','2017041001') -> 1292 (Incorrect datetime value: '0000-00-00 00:00:00' for column 'stamp' at row 1)
So zone files are not transferring anymore and i see this in syslog Apr 10 10:01:58 miffy named[20102]: zone 'icravefreebies.com' allows updates by IP address, which is insecure
That's probably a problem with the MySQL version or a MySQL setting that denies the 0000-00... date value now. Which MySQL version do you have on the master and which on the slave and which ISPConfig versions?
Mysql 5.7 on all servers, and latest ispconfig, 3.1.2, i think, I'm not in front of it at the moment. Thanks
Ok, so the problem is MySQL 5.7 here, it does not understand all values from the old MySQL version anymore. What you can try is this on the master: UPDATE dns_rr SET stamp = null WHERE stamp = ''0000-00-00 00:00:00'; and you will have to set the updated column in the server table for the affected server to the current (max) value of the sys_datalog_id from sys_datalog table, this makes the slave to ignore all pending changes which might contain the unsupported date values. Do a backup of the dbispconfig database with phpmyadmin before you start.
