DNS mirror error

Discussion in 'General' started by Maile Halatuituia, Apr 7, 2017.

  1. This is an error on ispconfig log on my DNS server when Control Panel try to push changes to it

    ERROR - Replication failed. Error: (dns_rr) in MySQL server: (localhost) Data truncated for column 'type' at row 1 # SQL: 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 ('7575','69','69','riud','riud','','39','219','$origin','','','0','172800','Y','2014-10-03 21:58:10','2016090101')

    can some one have a pointer ....
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Which ISPConfig version on master and slave?
    Which MySQL version on master and slave?
    Did you compare the dns_rr table with PHPMyAdmin to check if there are differences in the settings of the type column between master and slave db?
     
  3. thanks Till how can i check version on master and slave ???
     
  4. i think i got different version on master and slave ....
     
  5. how can i downgrade ispconfig version
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    There is no safe downgrade path (except of restoring a backup, but this can only be done when no changes wre made since upgrade, or all slaves would have to be downgraded too), you can just upgrade.
     
  7. thanks till can you propose possible safest way to upgrade all my other slave and master ///
     

Share This Page