HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Repplication error on mail server after upgrading multiserver setup [DEBIAN SQUEEZE] (http://www.howtoforge.com/forums/showthread.php?t=60690)

Nioubee 26th February 2013 12:34

Repplication error on mail server after upgrading multiserver setup [DEBIAN SQUEEZE]
 
Hello,

I just upgraded from 3.0.4.6 to 3.0.5. All slaves server is working except the mail server, on the Monitor it shows the following :

Quote:

Replication failed. Error: (client) in MySQL server: (localhost) Unknown column 'bank_account_owner' in 'field list' # SQL: REPLACE INTO client (`client_id`,`sys_userid`,`sys_groupid`,`sys_perm_ user`,`sys_perm_group`,`sys_perm_other`,`company_n ame`,`company_id`,`contact_name`,`customer_no`,`va t_id`,`street`,`zip`,`city`,`state`,`country`,`tel ephone`,`mobile`,`fax`,`email`,`internet`,`icq`,`n otes`,`bank_account_owner`,`bank_account_number`,` bank_code`,`bank_name`,`bank_account_iban`,`bank_a ccount_swift`,`paypal_email`,`default_mailserver`, `limit_maildomain`,`limit_mailbox`,`limit_mailalia s`,`limit_mailaliasdomain`,`limit_mailforward`,`li mit_mailcatchall`,`limit_mailrouting`,`limit_mailf ilter`,`limit_fetchmail`,`limit_mailquota`,`limit_ spamfilter_wblist`,`limit_spamfilter_user`,`limit_ spamfilter_policy`,`default_webserver`,`limit_web_ ip`,`limit_web_domain`,`limit_web_quota`,`web_php_ options`,`limit_cgi`,`limit_ssi`,`limit_perl`,`lim it_ruby`,`limit_python`,`force_suexec`,`limit_hter ror`,`limit_wildcard`,`limit_ssl`,`limit_web_subdo main`,`limit_web_aliasdomain`,`limit_ftp_user`,`li mit_shell_user`,`ssh_chroot`,`limit_webdav_user`,` limit_aps`,`default_dnsserver`,`limit_dns_zone`,`l imit_dns_slave_zone`,`limit_dns_record`,`default_d bserver`,`limit_database`,`limit_cron`,`limit_cron _type`,`limit_cron_frequency`,`limit_traffic_quota `,`limit_client`,`limit_mailmailinglist`,`limit_op envz_vm`,`limit_openvz_vm_template_id`,`parent_cli ent_id`,`username`,`password`,`language`,`userthem e`,`template_master`,`template_additional`,`create d_at`,`id_rsa`,`ssh_rsa`) VALUES ('3','1','1','riud','riud','','OverSpeed301','','L uca Torvalds','','','','','Toulouse','','FR','','','', '','http://www.overspeed301.fr/','','','','','','','','','','6','-1','-1','-1','-1','-1','-1','0','-1','-1','-1','0','0','0','1','','-1','-1','no,fast-cgi,cgi,mod,suphp','n','n','n','n','n','y','n','n' ,'n','-1','-1','-1','0','no,jailkit,ssh-chroot','0','0','2','-1','-1','-1','1','-1','0','url','5','-1','0','-1','0','0','0','overspeed301','$1$R+yJox1F$rO1Jegu SUV371.oRJMme3.','fr','default','0','','1360829407 ','-----BEGIN RSA PRIVATE KEY-----***=n-----END RSA PRIVATE KEY-----n','ssh-rsa *** overspeed301-rsa-key-1360829406n')

till 26th February 2013 14:07

Moste likely this slave server was not updated to 3.0.5 while this data has been inserted. Ensure that it is updated to 3.0.5 now so the error will not occur again. If the error has a delete icon on the right side of the error message, then press delete to confirm it so that replication starts again.

Nioubee 26th February 2013 19:11

Hello Till,

That fixed the issue ! Except, i am using Opera Browser, and the theme of ISPConfig 3.0.5 is not completely supported, the delete icon don't appear. (resolution 1920x1080)

I used Google Chrome instead and it worked (i can see the delete icon)

Thank-you !


All times are GMT +2. The time now is 16:28.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.