Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 2nd February 2013, 16:56
MaddinXx MaddinXx is offline
Senior Member
 
Join Date: Jul 2011
Location: Switzerland
Posts: 197
Thanks: 25
Thanked 62 Times in 46 Posts
Default fix broken replication

I get the following error on all slaves, preventing them from updating:

Code:
02.02.2013-15:53 - ERROR - Replication failed. Error: (nginx_reverse_proxy_plugin) in MySQL server: (localhost) Table 'dbispconfig.nginx_reverse_proxy_plugin' doesn't exist # SQL: REPLACE INTO nginx_reverse_proxy_plugin (`setting_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`vhost_config_dir`,`vhost_config_dir_enabled`,`port`) VALUES ('1','1','1','riud','riud','','/etc/nginx/sites-available','/etc/nginx/sites-enabled','/etc/nginx/sites-enabled')
02.02.2013-15:53 - ERROR - Error in Replication, changes were not processed.
I created a module but deleted it afterwards, manually deleting the table in the ISPConfig DB. Is their a way to resolve this?

Thanks!
__________________
Rackster Internet Services's presences:
Official | Open Source | Github | Facebook | Twitter
Reply With Quote
Sponsored Links
  #2  
Old 4th February 2013, 11:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,386 Times in 4,231 Posts
Default

1) ensure that you removed the table in the master and slave database.
2) Edit the server record of this slave in the server table on the master server and set the value in the updated column to a sys_datalog_id value from sys_datalog table that is higher then the one that you want to skip. If you dont know which record to skip, then use the max value of the sys_datalog_id column.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.

Last edited by till; 4th February 2013 at 12:28.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
MaddinXx (4th February 2013)
  #3  
Old 4th February 2013, 12:26
MaddinXx MaddinXx is offline
Senior Member
 
Join Date: Jul 2011
Location: Switzerland
Posts: 197
Thanks: 25
Thanked 62 Times in 46 Posts
 
Default

Puh thanks Till, that worked!

I better leave my fingers from the DB from now on
__________________
Rackster Internet Services's presences:
Official | Open Source | Github | Facebook | Twitter
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Database Replication With SSL Encryption pebkac General 7 10th November 2012 19:12
My SQL Replication issue ? jithinkcs Server Operation 5 10th September 2010 16:47
MYsql replication questions. scottrill2 Server Operation 7 3rd September 2010 17:53
Master Master replication questions and problems marchost HOWTO-Related Questions 5 4th October 2008 13:50
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59


All times are GMT +2. The time now is 06:24.


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