#1  
Old 1st January 2012, 23:06
zbuzanic zbuzanic is offline
Member
 
Join Date: Sep 2011
Location: Zagreb
Posts: 76
Thanks: 42
Thanked 18 Times in 11 Posts
Default Second server

Hi, I've finally setup another ispconfig server, and everything is working ok, except that I have this error on first(master) server when viewing server02 status:

Replication failed. Error: (client) in MySQL server: (localhost) Unknown column 'limit_openvz_vm_template' in 'field list' # SQL: REPLACE INTO client

I've upgraded both server with svn version of ispconfig.
__________________
ISPConfig -> the best open source control panel
Reply With Quote
Sponsored Links
  #2  
Old 2nd January 2012, 08:20
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,337 Times in 4,187 Posts
Default

Delete the error in the system log of the ispconfig monitor, you can find a delete button in that row and check if it appears again. If thats the case, then the database scheme on your slave is not up to date.

As a general note, please dont use svn versions on production systems, svn versions contain untested code and might not work at all or break your server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
zbuzanic (2nd January 2012)
  #3  
Old 2nd January 2012, 10:09
zbuzanic zbuzanic is offline
Member
 
Join Date: Sep 2011
Location: Zagreb
Posts: 76
Thanks: 42
Thanked 18 Times in 11 Posts
Default

Ok, I've updated with 3.0.4.1 release but I still have undone tasks (jobqueue) in my master ispconfig that produce errors. How can I delete those tasks?
__________________
ISPConfig -> the best open source control panel
Reply With Quote
  #4  
Old 2nd January 2012, 10:15
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,337 Times in 4,187 Posts
Default

There is nothing wrong with these tasks, the problem is the update state of the slave server as you master and slave have a different database layout at the moment so that the replication can not work anymore. Login to the slave server on the shell and execute the command:

ispconfig_update.sh

as root user on the shell and select "stable" when the updater asks you.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
zbuzanic (2nd January 2012)
  #5  
Old 2nd January 2012, 11:03
zbuzanic zbuzanic is offline
Member
 
Join Date: Sep 2011
Location: Zagreb
Posts: 76
Thanks: 42
Thanked 18 Times in 11 Posts
Default

Unfortunately, it didn't help.

"There are no updates available for ISPConfig 3.0.4.1"

I've looked into master SQL table and even on master there is no "limit_openvz_vm_template" collumn, so I guess it should be limit_openvz_vm_template_id, how to correct it in jobqueue?

ps. fixed it I've renamed table on slave, then renamed it back to original and now it's working as it should.
__________________
ISPConfig -> the best open source control panel

Last edited by zbuzanic; 2nd January 2012 at 13:01.
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
Not working emails (DNS and postfix problem?) shekiman Installation/Configuration 9 1st March 2011 16:25
Getmail problem cante93 Installation/Configuration 6 20th September 2010 14:40
I don't recieve mail. privir Installation/Configuration 2 3rd June 2009 22:08
Rejecting outbound mail tristanlee85 General 11 20th May 2007 17:04
Webmail Relay Error palkat General 17 23rd April 2006 18:12


All times are GMT +2. The time now is 20:35.


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