cron task failure

StAugIT · Post by **StAugIT** » Wed Dec 13, 2006 9:48 am

Hello, I'm having troubles running the maintainer script.

I have put the entry in my cron tab, and have also

"su www-data" (so I'm logged into the prompt)

and I run

"php cron.php"

When I run it, I don't get any errors, it just happily executes whatever is in that page. I've looked in logs and things and haven't found any entries.

while in the directory and the error still displays for all users:

WARNING: TimeTrex maintenance jobs have not run in the last 48hours. Please contact your TimeTrex administrator immediately.

This is my cron entry:

* * * * * su www-data -c "php /var/www/php/timetrex/classes/modules/core/../../../maint/cron.php" > /dev/null 2>&1

If you think that this could be because I did the search and replace fix for the TimeDate class, if you can think of something that needs to change in cron.php because of that please let me know. Any suggestions would be great and once again thanks for your time!

Post by **shaunw** » Wed Dec 13, 2006 11:40 am

Have a look at this thread, if you can provide me with the same information that was asked for there, that would help:

http://forums.timetrex.com/viewtopic.php?t=101

StAugIT · Post by **StAugIT** » Wed Dec 13, 2006 12:14 pm

-----
(mysqlt): SET SESSION sql_mode='ansi'
-----
-----
(mysqlt):
select *
from cron
WHERE deleted = 0 LIMIT 2147483647
-----
 
Debug Buffer 
============================================================================ 
Memory Usage: 3404252 
---------------------------------------------------------------------------- 
DEBUG [138]: [Function](): Production: 1 
DEBUG [92]: TTDate::setTimeZone(): Setting TimeZone: PST8PDT 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: AddPayPeriod 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 0 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 0 
DEBUG [438]: CronJobFactory::isScheduledToRun(): Hour DOES NOT Match: 11 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: AddUserDate 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 0 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 0 
DEBUG [438]: CronJobFactory::isScheduledToRun(): Hour DOES NOT Match: 11 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: calcExceptions 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 0 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 0 
DEBUG [438]: CronJobFactory::isScheduledToRun(): Hour DOES NOT Match: 11 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: AddRecurringPayStubAmendment 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 0 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 0 
DEBUG [438]: CronJobFactory::isScheduledToRun(): Hour DOES NOT Match: 11 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: AddRecurringHoliday 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 0 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 0 
DEBUG [438]: CronJobFactory::isScheduledToRun(): Hour DOES NOT Match: 11 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: UserCount 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 1 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 1 
DEBUG [438]: CronJobFactory::isScheduledToRun(): Hour DOES NOT Match: 11 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: AddRecurringScheduleShift 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [418]: CronJobFactory::isScheduledToRun(): Hour Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 2 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 20 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 20 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 50 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 50 
DEBUG [434]: CronJobFactory::isScheduledToRun(): Minute DOES NOT Match: 8 
DEBUG [389]: CronJobFactory::isScheduledToRun(): Checking if Cron Job is scheduled to run: CheckForUpdate 
DEBUG [397]: CronJobFactory::isScheduledToRun(): Epoch: 1166036880 - 13-Dec-06 11:08 AM PST 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [403]: CronJobFactory::isScheduledToRun(): Day Of Week Matches: 3 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [408]: CronJobFactory::isScheduledToRun(): Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: * 
DEBUG [374]: CronJobFactory::parseScheduleString(): Found Full Range!: * 
DEBUG [413]: CronJobFactory::isScheduledToRun(): Day Of Month Matches: 12 
DEBUG [345]: CronJobFactory::parseScheduleString(): Schedule String has multiple commas: 1 
DEBUG [371]: CronJobFactory::parseScheduleString(): Schedule atom does not have range: 5 
DEBUG [377]: CronJobFactory::parseScheduleString(): Singleton: 5 
DEBUG [438]: CronJobFactory::isScheduledToRun(): Hour DOES NOT Match: 11 
============================================================================ 

System info can be found here:

http://forums.timetrex.com/viewtopic.php?t=79

Post by **shaunw** » Wed Dec 13, 2006 1:02 pm

Okay, the cron.php script is working.

Is you're cron daemon actually running cron.php when it should?

What is the exact command you have in your crontab file?

Check your cron log to see if there are entries where your cron daemon ran the cron.php file each minute?

StAugIT · Post by **StAugIT** » Wed Dec 13, 2006 2:39 pm

I have looked through my logs but I don't see one that pertains particularly to cron actions, I looked at the syslog and saw a couple things from the cron daemon but it didn't look like it was in response to this script. I have also run "php cron.php" as www-data, it executed, but the error message still shows up on users interfaces. If you have another idea or some more debug output that I could show you I would be happy to assist in any way. If you can also give any insight as to where the cron would place its log entries, I will look more closely. Thanks again for the help!

Post by **shaunw** » Wed Dec 13, 2006 5:42 pm

StAugIT wrote:I have looked through my logs but I don't see one that pertains particularly to cron actions, I looked at the syslog and saw a couple things from the cron daemon but it didn't look like it was in response to this script. I have also run "php cron.php" as www-data, it executed, but the error message still shows up on users interfaces. If you have another idea or some more debug output that I could show you I would be happy to assist in any way. If you can also give any insight as to where the cron would place its log entries, I will look more closely. Thanks again for the help!

You'll need to answer all the questions in my last post for me to help you further.

StAugIT · Post by **StAugIT** » Thu Dec 14, 2006 9:48 am

If you run the command manually, does it output anything to the screen?

No

What does the windows task scheduler say for the last time the task was run? When was the scheduled task created?

I'm running debian not windows, if you have some output that I can show you I can pastebin my syslog or something if you want.

Enable debug mode as per:

http://forums.timetrex.com/viewtopic.php?t=89

Then edit includes/CLI.inc.php and delete the four debug lines from that file. Run cron.php again manually and paste the output here. There should be a good 50-80 lines of text.

Done this in my previous post.

Something looks broken. Try:

php-win.exe -v

I don't use windows

Checking your php error log might give a clue to what is wrong.

I have no errors in php from the php.ini logs

Let me know if there are more questions I can answer. Also, since it seems to be running fine, if there is a way to just stop this error from displaying by modifying some code, if you could let me know how to do that it would be awesome. Thanks again for your time.

Post by **shaunw** » Thu Dec 14, 2006 12:38 pm

What is the exact command you have in your crontab file?

You also need to find where your cron daemon is logging to so you can search for other cron entries. If your cron daemon is saying that it is running other crontab entires but not TimeTrex's cron.php, you know there is a problem with cron.

StAugIT · Post by **StAugIT** » Tue Dec 19, 2006 2:16 pm

Cron file entry:

* * * * * su www-data -c "php /var/www/php/timetrex/classes/modules/core/../../../maint/cron.php" > /dev/null 2>&1

I'm not seeing anything in my syslog about failure of a cron task or anything like that. I have also run the php script as "www-data" with no errors which should (correct me if I am wrong) make the error message disappear. If there is a way to modify the code (since in a previous post you said that it was working correctly) to just disabe the message from showing, I would appreciate it. Thankyou.

Post by **shaunw** » Tue Dec 19, 2006 5:08 pm

StAugIT wrote:Cron file entry:

* * * * * su www-data -c "php /var/www/php/timetrex/classes/modules/core/../../../maint/cron.php" > /dev/null 2>&1

I'm not seeing anything in my syslog about failure of a cron task or anything like that. I have also run the php script as "www-data" with no errors which should (correct me if I am wrong) make the error message disappear. If there is a way to modify the code (since in a previous post you said that it was working correctly) to just disabe the message from showing, I would appreciate it. Thankyou.

Your cron daemon should add a line to its log everytime it does run a command. If your not seeing that, I would assume that it isn't being run properly.

Running cron.php once or twice manually won't get rid of the message because cron.php has to be run at the exact minute a job is scheduled until every job has been run at least once before that message will disappear.

Mike suggested to me that you try adding this code to your cron.php right above the second last line: Debug::Display();

Code: Select all

//Save file to /tmp/ with the last executed date, so we know if cron is actually calling us.
file_put_contents('/tmp/timetrex_cron_last_executed.txt', TTDate::getDate('DATE+TIME', time() )."\n" );

This will cause a file to be written with the date cron.php was run inside it, so you'll know right away if your cron daemon is calling it or not.

Simply run:

cat /tmp/timetrex_cron_last_executed.txt

If the date in that file isn't being changed every minute then your cron daemon isn't doing its job. If you run cron.php manually, you should see the date change each time.

StAugIT · Post by **StAugIT** » Wed Dec 27, 2006 12:14 pm

This has been resolved, did not enter the cron entries in the right files, it was misleading in debian.

Cron entries for anyone interested are in /var/spool/cron/* for debian
and should only be edited with the:
# crontab -e
command run as root or your web user (www-data) and should then omit the 'su www-data' part of the cron tab. Sorry for my stupidity in this matter and thankyou for working with me.

TimeTrex Time and Attendance

cron task failure

cron task failure

Time and Attendance