#1  
Old 24th January 2014, 14:29
esezako esezako is offline
Senior Member
 
Join Date: Dec 2008
Posts: 176
Thanks: 16
Thanked 4 Times in 3 Posts
Default Job Queue not work

Linux 2.6.32-24-pve #1 SMP x86_64 GNU/Linux
ISPConfig Version: 3.0.5.3


I have a multiserver setup with 9 servers.

From time ago, changes not make until forze with

Code:
/usr/local/ispconfig/server/server.sh | more
24.01.2014-13:09 - WARNING - DB::query(SELECT * FROM sys_ini WHERE sysini_id = 1) -> mysqli_query SELECT command denied to user 'ispcsrv2'@'*********' for table 's
ys_ini'
24.01.2014-13:09 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
24.01.2014-13:09 - DEBUG - Found 1 changes, starting update process.
24.01.2014-13:09 - DEBUG - Replicated from master: DELETE FROM mail_user  WHERE mailuser_id = 313
24.01.2014-13:09 - DEBUG - Calling function 'user_delete' from plugin 'mail_plugin' raised by event 'mail_user_delete'.
24.01.2014-13:09 - DEBUG - Deleted the Maildir: /var/vmail/****.com/borrame2
24.01.2014-13:09 - DEBUG - Calling function 'delete' from plugin 'maildeliver_plugin' raised by event 'mail_user_delete'.
24.01.2014-13:09 - DEBUG - Processed datalog_id 5610
24.01.2014-13:09 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
finished.

I see that the datalog_ids are no incremented in the severs table

A sugestion?

Thansk in advance.
Reply With Quote
Sponsored Links
  #2  
Old 24th January 2014, 14:35
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,501 Times in 4,330 Posts
Default

Quote:
I see that the datalog_ids are no incremented in the severs table
Wgich database did you check. The id is stored in the server table of the master only, not on the slaves.

If the changes get applied when you run /usr/local/ispconfig/server/server.sh, then ispconfig is ok. you should check then if your cron daemon has stopped, as thats the exact same command that cron should run once a minute.

regarding the sys_ini warning, its uncritical, but you can fix it by applying a patch which is available on ispconfig.org.
__________________
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:
esezako (24th January 2014)
  #3  
Old 24th January 2014, 14:35
esezako esezako is offline
Senior Member
 
Join Date: Dec 2008
Posts: 176
Thanks: 16
Thanked 4 Times in 3 Posts
Default

Test results on Master server:
Code:
##### SERVER #####
IP-address (as per hostname): ***.***.***.***
[WARN] could not determine server's ip address by ifconfig
[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.0.5.3


##### VERSION CHECK #####

[INFO] php (cli) version is 5.3.3-7+squeeze18
[INFO] php-cgi (used for cgi php in default vhost!) is version 5.3.3-7+squeeze18
[WARN] Your php-cgi in /usr/lib/cgi-bin/ seems to be outdated and might contain a known exploit (-7+squeeze18)!

##### PORT CHECK #####

[WARN] Port 143 (IMAP server) seems NOT to be listening
[WARN] Port 993 (IMAP server SSL) seems NOT to be listening
[WARN] Port 110 (POP3 server) seems NOT to be listening
[WARN] Port 995 (POP3 server SSL) seems NOT to be listening
[WARN] Port 465 (SMTP server SSL) seems NOT to be listening

##### MAIL SERVER CHECK #####

[WARN] I found no "submission" entry in your postfix master.cf
[INFO] this is not critical, but if you want to offer port 587 for smtp connections you have to enable this.
[WARN] I found no "smtps" entry in your postfix master.cf
[INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connections you have to enable this.

##### RUNNING SERVER PROCESSES #####

[INFO] I found the following web server(s):
        Apache 2 (PID 1485)
[INFO] I found the following mail server(s):
        Postfix (PID 924)
[WARN] I could not determine which pop3 server is running.
[WARN] I could not determine which imap server is running.
[INFO] I found the following ftp server(s):
        PureFTP (PID 30877)

##### LISTENING PORTS #####
(only           ()
Local           (Address)
[anywhere]:3306         (30654/mysqld)
[anywhere]:111          (349/portmap)
[anywhere]:8080         (1485/apache2)
[anywhere]:80           (1485/apache2)
[anywhere]:8081         (1485/apache2)
[anywhere]:21           (30877/pure-ftpd)
[anywhere]:22           (599/sshd)
***.***.***.***:25              (924/master)
[localhost]:25          (924/master)
[localhost]:6010                (1405/0)
[anywhere]:443          (1485/apache2)
[localhost]:6011                (6836/3)
*:*:*:*::*:21           (30877/pure-ftpd)
*:*:*:*::*:22           (599/sshd)
*:*:*:*::*:6010         (1405/0)
*:*:*:*::*:6011         (6836/3)

##### IPTABLES #####
Chain INPUT (policy ACCEPT)
target     prot opt source               destination         
fail2ban-ssh  tcp  --  [anywhere]/0            [anywhere]/0           multiport dports 22 
fail2ban-pureftpd  tcp  --  [anywhere]/0            [anywhere]/0           multiport dports 21 

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination         

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination         

Chain fail2ban-pureftpd (1 references)
target     prot opt source               destination         
RETURN     all  --  [anywhere]/0            [anywhere]/0           

Chain fail2ban-ssh (1 references)
target     prot opt source               destination         
RETURN     all  --  [anywhere]/0            [anywhere]/0
Reply With Quote
  #4  
Old 24th January 2014, 14:37
esezako esezako is offline
Senior Member
 
Join Date: Dec 2008
Posts: 176
Thanks: 16
Thanked 4 Times in 3 Posts
Default

Test results in one mail slave servers:

Code:
##### SERVER #####
IP-address (as per hostname): ***.***.***.***
[WARN] could not determine server's ip address by ifconfig
[INFO] ISPConfig is installed.

##### ISPCONFIG #####
ISPConfig version is 3.0.5.3


##### VERSION CHECK #####

[INFO] php (cli) version is 5.3.3-7+squeeze18

##### PORT CHECK #####

[WARN] Port 8080 (ISPConfig) seems NOT to be listening
[WARN] Port 8081 (ISPConfig Apps) seems NOT to be listening
[WARN] Port 80 (Webserver) seems NOT to be listening
[WARN] Port 443 (Webserver SSL) seems NOT to be listening
[WARN] Port 21 (FTP server) seems NOT to be listening

##### MAIL SERVER CHECK #####

[WARN] I found no "submission" entry in your postfix master.cf
[INFO] this is not critical, but if you want to offer port 587 for smtp connections you have to enable this.

##### RUNNING SERVER PROCESSES #####

[WARN] I could not determine which web server is running.
[INFO] I found the following mail server(s):
        Postfix (PID 20585)
[INFO] I found the following pop3 server(s):
        Dovecot (PID 21422)
[INFO] I found the following imap server(s):
        Dovecot (PID 21422)
[WARN] I could not determine which ftp server is running.

##### LISTENING PORTS #####
(only           ()
Local           (Address)
[anywhere]:25           (20585/master)
[localhost]:6010                (346/0)
[localhost]:6011                (3854/1)
[anywhere]:993          (21422/dovecot)
[anywhere]:995          (21422/dovecot)
[localhost]:10024               (20678/amavisd)
[localhost]:10025               (20585/master)
[localhost]:3306                (20415/mysqld)
[anywhere]:110          (21422/dovecot)
[anywhere]:143          (21422/dovecot)
[localhost]:783         (692/spamd.pid)
[anywhere]:111          (266/portmap)
[anywhere]:465          (20585/master)
[anywhere]:22           (693/sshd)
*:*:*:*::*:25           (20585/master)
*:*:*:*::*:6010         (346/0)
*:*:*:*::*:6011         (3854/1)
*:*:*:*::*:993          (21422/dovecot)
*:*:*:*::*:995          (21422/dovecot)
[localhost]10           (21422/dovecot)
[localhost]43           (21422/dovecot)
*:*:*:*::*:465          (20585/master)
*:*:*:*::*:22           (693/sshd)




##### IPTABLES #####
Chain INPUT (policy ACCEPT)
target     prot opt source               destination         
fail2ban-ssh  tcp  --  [anywhere]/0            [anywhere]/0           multiport dports 22 
fail2ban-dovecot-pop3imap  tcp  --  [anywhere]/0            [anywhere]/0           multiport dports 110,995,143,993 

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination         

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination         

Chain fail2ban-dovecot-pop3imap (1 references)
target     prot opt source               destination         
RETURN     all  --  [anywhere]/0            [anywhere]/0           

Chain fail2ban-ssh (1 references)
target     prot opt source               destination         
RETURN     all  --  [anywhere]/0            [anywhere]/0
Reply With Quote
  #5  
Old 24th January 2014, 16:18
esezako esezako is offline
Senior Member
 
Join Date: Dec 2008
Posts: 176
Thanks: 16
Thanked 4 Times in 3 Posts
Default

Quote:
Originally Posted by till View Post
Wgich database did you check. The id is stored in the server table of the master only, not on the slaves.
Yes in master.

Quote:
Originally Posted by till View Post
If the changes get applied when you run /usr/local/ispconfig/server/server.sh, then ispconfig is ok. you should check then if your cron daemon has stopped, as thats the exact same command that cron should run once a minute.
How can i comprobate if cron executed correctly?


Quote:
Originally Posted by till View Post
regarding the sys_ini warning, its uncritical, but you can fix it by applying a patch which is available on ispconfig.org.
Yes, ok. I apply the update.php then i missing the fix applies. I redo the fix.
Reply With Quote
  #6  
Old 24th January 2014, 16:24
esezako esezako is offline
Senior Member
 
Join Date: Dec 2008
Posts: 176
Thanks: 16
Thanked 4 Times in 3 Posts
Default

i restart the cron and now its working, thanks!!

Days seeking a solution and i dont think in the cron!
Reply With Quote
  #7  
Old 24th January 2014, 17:06
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,501 Times in 4,330 Posts
 
Default

Thanks for posting the solution.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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 and mail problem viritech General 3 16th October 2012 12:54
problem on job queue after upgrade to the latest version themark General 3 7th March 2012 09:33
Courier issues, new install, cant connect Smitherines Server Operation 9 14th April 2011 16:25
Issues with the Job Queue b00gz Installation/Configuration 6 26th December 2010 19:38
Mail not working epicuniversal General 5 13th June 2009 08:24


All times are GMT +2. The time now is 02:01.


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