Cronjob Handler

Are you new to the eduTrac SIS online user's manual? If so, click here for a starting point. If you are looking for technical documentation, then check out the Wiki.

 

Cronjobs are very important in the running and maintenance of eduTrac SIS (etSIS). When you first setup etSIS, you need to setup cronjob handlers (Screens > Administrative > Cronjob Handler). On the Cronjob Handler settings screen (Cronjob Handler > Settings) you must enter a password and the time in seconds that the cronjob should run before timing out.

Setting Up New Handlers

new-cronjob-handler

  1. Handler Name – Name of the handler to run.
  2. Cronjob URL – Url of the handler to run.
  3. Each / Time – Set the time for when the cronjob should run (i.e. every 2 minutes, every 5 minutes, or every Day at 07:00).
  4. Set the handler to Active or Inactive.

Once you’ve setup your cronjob handlers, you will need to create a cronjob on your server either through your hosting control panel or by using these instructions. The master cronjob should run every minute and should be setup like so:

* * * * * http://replace_url/cron/master/

Below is the a list of handlers that need to be setup in the system. You will need to replace the replace_url with the url of your installation.

NameScript PathSuggested Time Interval
Purge Activity Loghttp://replace_url/cron/purgeActivityLog/Every Hour
Update Student Termshttp://replace_url/cron/updateSTTR/Every 7 days
Update Student Academic Levelshttp://replace_url/cron/updateSTAL/Every 7 days
Run Email Queuehttp://replace_url/cron/runEmailQueue/Every 5 Minutes
Run Bounce Handlerhttp://replace_url/cron/runBounceHandler/Every day
Run Graduationhttp://replace_url/cron/runGraduation/Every hour
Purge Error Loghttp://replace_url/cron/purgeErrorLog/Every 30 minutes
Purge Saved Querieshttp://replace_url/cron/purgeSavedQuery/Every 30 days
Check Student Balancehttp://replace_url/cron/checkStuBalance/Every 5 minutes
Run NodeQhttp://replace_url/cron/runNodeQ/Every 5 minutes
Backup Databasehttp://replace_url/cron/runDBBackup/Default: every day, but feel free to change it to how often you want to backup your database.
Backup Systemhttp://replace_url/cron/runSiteBackup/Default: every day, but feel free to change it to how often you want to backup your system. This does not backup system session savepath files set in config.php
Academic Level Standinghttp://replace_url/cron/runALST/Every 7 days

Last Modified: Aug 17, 2017 @ 4:34 PM

Was this article helpful?

Related Articles

  • Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    Do you have two versions of the plugin installed by chance?

    Michael Williams
    Member
    • Topics: 2
    • Replies: 38
    • Total Posts: 40

    See attached

    Attachments:
    You must be logged in to view attached files.
    Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    If this is a production site, can you post a private reply and give me FTP details for server and super admin account details for eduTrac SIS?

    Michael Williams
    Member
    • Topics: 2
    • Replies: 38
    • Total Posts: 40
    This reply has been marked as private.
    Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    @Michael Williams, I need the FTP details to where eduTrac SIS is installed.

    Michael Williams
    Member
    • Topics: 2
    • Replies: 38
    • Total Posts: 40
    This reply has been marked as private.
    Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    Do you have two installations of eduTrac SIS installed? Are they trying to use the same database?

    Michael Williams
    Member
    • Topics: 2
    • Replies: 38
    • Total Posts: 40
    This reply has been marked as private.
    Teja Majety
    Moderator
    • Topics: 12
    • Replies: 204
    • Total Posts: 216

    Hi,

    Recently i created all the cron handlers listed except some of them like backup and purge crons which i don’t want. The problem here is after creating the cron handlers, i keep receving error logs.

    [18-Oct-2016 14:00:01 Europe/Dublin] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty' in /var/www/html/Liten/Orm.php:247
    Stack trace:
    #0 /var/www/html/Liten/Orm.php(247): PDOStatement->execute(Array)
    #1 /var/www/html/app/routers/cron.router.php(612): Liten\Orm->query(NULL)
    #2 [internal function]: {closure}()
    #3 /var/www/html/Liten/Liten.php(506): call_user_func_array(Object(Closure), Array)
    #4 /var/www/html/Liten/Liten.php(448): Liten\Liten->handle(Array, true)
    #5 /var/www/html/config.php(161): Liten\Liten->run()
    #6 /var/www/html/index.php(27): include('/var/www/html/c...')
    #7 {main}
    thrown in /var/www/html/Liten/Orm.php on line 247

    This error is generating for every 30 minutes, and the only crons i have for 30 minutes are “Process Email Hold” and “Process Email Queue”.

    Are these handlers related to communication management? where they manage emails and templates etc. I don’t have anything in my communication management, I mean didn’t create any template or mail yet.

    So, is this error normal until I have something in communication management?

    Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    A query that is returning null is being called too early. For the runEmailHold route in cron.router.php, move the following lines:

    $query = $r['savedQuery'];
    $hold1 = $app->db->query($query);

    After this line:

    if (count($q2) <= 0) {

     

    Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    It backs up the database and save it in /tmp/, but you should really do your own backups instead of relying on the system to do backups for you. So, you can continue to ignore that cronjob handler.

    Teja Majety
    Moderator
    • Topics: 12
    • Replies: 204
    • Total Posts: 216

    Thanks, Parker <span style=”background-color: #f5f6f5;”>I think</span> that solved the issue , I just checked the error log and it didn’t have any recent logs generated. Is this generally a bug or did I just miss the updated files during update/installation?

    Even just before this, I found issue with SQL interface, I couldn’t view the SQL interface screen as before happened with staff screen. Though it has been solved as you have suggested in the previous forum. Am I missing all these updated files or these are just bugs?

    Joshua Parker
    Keymaster
    • Topics: 4
    • Replies: 638
    • Total Posts: 642

    Bugs.

    Ahmed Samir
    Participant
    • Topics: 0
    • Replies: 1
    • Total Posts: 1

    i install 6.3.4 version

    and config SMTP to Enable Cornjobs to send EMAIL

    crontab on my server add only this command

    * * * * * /usr/bin/curl -s http://10.40.40.200/eduTrac-SIS/cron/cronjob?password=XXX

    and config all cronjob handlers in edutrac system edit the url

    but not send email

    log cron tab is :

    Running: http://10.40.40.200/eduTrac-SIS/cron/runEmailQueue/

    Connecting to cronjob

Viewing 14 posts - 16 through 29 (of 29 total)

You must be logged in to reply to this topic.