#1  
Old 13th August 2009, 22:47
Franz Franz is offline
Senior Member
 
Join Date: Jul 2009
Location: Cakovec
Posts: 117
Thanks: 7
Thanked 24 Times in 18 Posts
Send a message via Skype™ to Franz
Unhappy jobqueue on master

On my master ISPconfig jobqueue for slave server is not deleting. On second my server all jobs are proceed. I create 3 jobs, and 1 job after 10 min. When server.sh script is executeed every minute, second server execute all 4 jobs.
And all is working except that all jobs are executing.

I do some mysql logging and find that query is always on maseter server databse:

Code:
SELECT * FROM sys_datalog WHERE datalog_id > 0 AND (server_id = 4 OR server_id = 0) ORDER BY datalog_id
but when I create jobs for master, datalog_id is increasing for server_di=1


is this a BUG or I did some mistake when configuring ISPconfig
I use last beta relase.

On prodaction server I have separated ISPconfig installations and the work great.
Reply With Quote
Sponsored Links
  #2  
Old 14th August 2009, 14:17
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,177
Thanks: 829
Thanked 5,414 Times in 4,257 Posts
Default

There is no such bug in ispconfig, master slave setups are working fine in general. Most likely your slave server has no permission to connect to the master database. Enable debugging on the slave to check this:

http://www.faqforge.com/linux/contro...n-ispconfig-3/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 15th August 2009, 01:29
Franz Franz is offline
Senior Member
 
Join Date: Jul 2009
Location: Cakovec
Posts: 117
Thanks: 7
Thanked 24 Times in 18 Posts
Send a message via Skype™ to Franz
 
Default

here is my log form slave: /var/log/ispconfig/ispconfig.log
this log entry is repeating every minute.

15.08.2009-01:24 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
15.08.2009-01:24 - DEBUG - Found 3 changes, starting update process.
15.08.2009-01:24 - DEBUG - Replicated from master: REPLACE INTO web_domain (`domain_id`,`sys_userid`,`sys_groupid`,`sys_perm_ user`,`sys_perm_group`,`sys_perm_other`,`server_id `,`ip_address`,`domain`,`type`,`parent_domain_id`, `vhost_type`,`document_root`,`system_user`,`system _group`,`hd_quota`,`traffic_quota`,`cgi`,`ssi`,`su exec`,`errordocs`,`is_subdomainwww`,`subdomain`,`p hp`,`redirect_type`,`redirect_path`,`ssl`,`ssl_sta te`,`ssl_locality`,`ssl_organisation`,`ssl_organis ation_unit`,`ssl_country`,`ssl_request`,`ssl_cert` ,`ssl_bundle`,`ssl_action`,`stats_password`,`apach e_directives`,`active`) VALUES ('5','1','0','riud','ru','','4','*','ddd.ddd.dddd' ,'vhost','0','name','/var/www/clients/client0/web5','web5','client0','-1','0','n','n','n','1','1','none','no','','','n',' ','','','','','','','','','','','y')
15.08.2009-01:24 - DEBUG - Call function 'ssl' in plugin 'apache2_plugin' raised by event 'web_domain_insert'.
15.08.2009-01:24 - DEBUG - Call function 'insert' in plugin 'apache2_plugin' raised by event 'web_domain_insert'.
15.08.2009-01:24 - DEBUG - Disable SSL for: ddd.ddd.dddd
15.08.2009-01:24 - DEBUG - Writing the vhost file: /etc/apache2/sites-available/ddd.ddd.dddd.vhost
15.08.2009-01:24 - DEBUG - Processed datalog_id 18
15.08.2009-01:24 - DEBUG - Replicated from master: REPLACE INTO firewall (`firewall_id`,`sys_userid`,`sys_groupid`,`sys_per m_user`,`sys_perm_group`,`sys_perm_other`,`server_ id`,`tcp_port`,`udp_port`,`active`) VALUES ('1','1','1','riud','riud','','4','20,21,22,25,53, 80,110,143,443,3306,8080,10000','53,3306','y')
15.08.2009-01:24 - DEBUG - Call function 'insert' in plugin 'firewall_plugin' raised by event 'firewall_insert'.
15.08.2009-01:24 - DEBUG - Writing firewall configuration /etc/Bastille/bastille-firewall.cfg
15.08.2009-01:24 - DEBUG - Restarting the firewall
15.08.2009-01:24 - DEBUG - Processed datalog_id 19
15.08.2009-01:24 - DEBUG - Replicated from master: DELETE FROM firewall WHERE firewall_id = 1
15.08.2009-01:24 - DEBUG - Call function 'delete' in plugin 'firewall_plugin' raised by event 'firewall_delete'.
15.08.2009-01:24 - DEBUG - Stopping the firewall
15.08.2009-01:24 - DEBUG - Processed datalog_id 20
15.08.2009-01:24 - DEBUG - Call function 'restartHttpd' in module 'web_module'.
15.08.2009-01:24 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
__________________
my PAGE
VoIP
my IT help blog
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
Master master Mysql replication with ignore table wxman HOWTO-Related Questions 2 5th May 2009 22:25
Master Master replication questions and problems marchost HOWTO-Related Questions 5 4th October 2008 13:50
named.conf.master ISPconfig duplication hypertec_hope Installation/Configuration 0 18th July 2008 18:23
ISPConfig unsual behavior! cybereatl Installation/Configuration 25 28th February 2007 13:48
BIND broke adamluz Installation/Configuration 4 2nd June 2006 21:31


All times are GMT +2. The time now is 00:09.


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