Cron not creating files at cron.d

Discussion in 'ISPConfig 3 Priority Support' started by Abel Vieira, Feb 12, 2018.

  1. Abel Vieira

    Abel Vieira New Member

    Hi,

    My server start failing creating the cronjob files.

    Example:

    Change something in a cron (that already fail in file creation), data from sys_datalog (id=4673):
    Code:
    Array
    (
        [old] => Array
            (
                [id] => 298
                [sys_userid] => 1
                [sys_groupid] => 272
                [sys_perm_user] => riud
                [sys_perm_group] => riud
                [sys_perm_other] => 
                [server_id] => 5
                [parent_domain_id] => 468
                [type] => full
                [command] => php -q [web_root]/cron.php
                [run_min] => */5
                [run_hour] => *
                [run_mday] => *
                [run_month] => *
                [run_wday] => *
                [log] => n
                [active] => y
            )
    
        [new] => Array
            (
                [id] => 298
                [sys_userid] => 1
                [sys_groupid] => 272
                [sys_perm_user] => riud
                [sys_perm_group] => riud
                [sys_perm_other] => 
                [server_id] => 5
                [parent_domain_id] => 468
                [type] => full
                [command] => php -q [web_root]/cron.php
                [run_min] => */5
                [run_hour] => 5
                [run_mday] => *
                [run_month] => *
                [run_wday] => *
                [log] => n
                [active] => y
            )
    )
    
    Wait some minute, and the log show this:
    Code:
    12.02.2018-16:52 - DEBUG - Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'.
    12.02.2018-16:52 - DEBUG - Found 1 changes, starting update process.
    12.02.2018-16:52 - DEBUG - Replicated from master: REPLACE INTO `cron` (`id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`parent_domain_id`,`type`,`command`,`run_min`,`run_hour`,`run_mday`,`run_month`,`run_wday`,`log`,`active`) VALUES ('298','1','272','riud','riud','','5','468','full','php -q [web_root]/cron.php','*/5','5','*','*','*','n','y')
    12.02.2018-16:52 - DEBUG - Calling function 'update' from plugin 'cron_jailkit_plugin' raised by event 'cron_update'.
    12.02.2018-16:52 - WARNING - Parent domain not found
    12.02.2018-16:52 - DEBUG - Calling function 'update' from plugin 'cron_plugin' raised by event 'cron_update'.
    12.02.2018-16:52 - WARNING - Parent domain not found
    12.02.2018-16:52 - DEBUG - Processed datalog_id 4673
    12.02.2018-16:52 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    
    Can help please?

    Regards,
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Seems as if the website data in the database is missing on that server node. Try to edit the website where this cron belongs to, change a value e.g. quota and press save. Then wait until this change is on the slave server and then edit the cronjob, change something and save it.
     
  3. Abel Vieira

    Abel Vieira New Member

    After save the website changes, i get this error at node:
    Code:
    13.02.2018-09:44 - WARNING - Falsche Anfrage / Wrong QuerySQL-Query = REPLACE INTO `web_domain` (`domain_id`,............) -> 1054 (Unknown column 'ssl_letsencrypt_exclude' in 'field list')
    I update all nodes to the last ISPConfig version (3.1.11), change the website again e it's ok. After that i use the "Resync Tool" and everything seems to be ok now.
     

Share This Page