Job Queue not work

Discussion in 'General' started by esezako, Jan 24, 2014.

  1. esezako

    esezako Member

    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.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. esezako

    esezako Member

    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           
    
    
    
    
     
  4. esezako

    esezako Member

    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           
    
    
    
    
    
     
  5. esezako

    esezako Member

    Yes in master.

    How can i comprobate if cron executed correctly?


    Yes, ok. I apply the update.php then i missing the fix applies. I redo the fix.
     
  6. esezako

    esezako Member

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

    Days seeking a solution and i dont think in the cron!
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    Thanks for posting the solution.
     

Share This Page