WARNING: TimeTrex maintenance jobs have not run

millersvillegray · Post by **millersvillegray** » Thu May 08, 2008 7:34 pm

we have just installed TimeTrex on a mac os 10.4 server we have everything running and working except we keep getting the following error message.

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

I have placed the necessary command in crontab, and I have even tried to run it from the command line with full permissions. but the bloody error will not go away. I have tried to find another thread with a similar background though it appears most people having this problem are running windows computers. Please help.

2. Clearly state the EXACT steps you took before the issue occurred, or steps to reproduce the issue. Providing screenshots can help greatly if it is possible.

Added the the fallowing line to crontab as well as attempted to run the command as "administrator" as well as "system"

3. What version of TimeTrex you are running, specifically. (stating "the latest version" is not specific enough)

version 2.2.8

4. What version of PHP you are using.

php version 4.4.8

5. What operating system you are running.

MAc osX 10.4.11

6. What web server you are using.

mac osx web server, it is a version of apachie though I am not sure which one.

7. Have you configured PHP to log errors to a file, and what errors are showing up in this file?
("error_log = <filename>" in PHP.INI)

8. In your TimeTrex.ini.php file, set the following under the [debug] section:
enable = TRUE
enable_display = TRUE
buffer_output = TRUE
enable_log = TRUE
verbosity = 11
Reproduce the issue and include any relevent information from the TimeTrex log file in your post.

Debug Buffer
============================================================================
Memory Usage: 8490576
----------------------------------------------------------------------------
DEBUG [259]: [Function](): URI: /timetrex/interface/index.php
DEBUG [261]: [Function](): Version: 2.2.8 Edition: 10 Production: 1 Demo Mode: 0
DEBUG [107]: TTDate::setTimeZone(): Setting TimeZone: America/New_York
DEBUG [497]: Authentication::Check(): Session Name: SessionID
DEBUG [503]: Authentication::Check(): Session ID: 04b1d5cb0003c592b26181e08fad60f8
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:04b1d5cb0003c592b26181e08fad60f8
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:04b1d5cb0003c592b26181e08fad60f8
DEBUG [69]: [Function](): User Authenticated: eric Created Date: 1210291665
DEBUG [1961]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [102]: TTDate::setTimeZone(): TimeZone already set to: America/New_York
DEBUG [135]: TTDate::setDateFormat(): Setting Default Date Format: d-M-y
DEBUG [149]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [163]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [101]: [Function](): Locale Cookie: en_US
DEBUG [287]: TTi18n::getLanguageFromLocale(): Locale: en_US
DEBUG [109]: [Function](): User Preference Language matches cookie!
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale:
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en_US,en_US.UTF-8,en,en.UTF-8
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 0 Current Locale:
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US
DEBUG [1961]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [1138]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [138]: [Function](): Station ID Cookie found! b8230b74367e1441b04902b7c91ecbb7
DEBUG [241]: [Function](): UnRead Messages: 0
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: Home URL: /timetrex/interface/index.php
DEBUG [147]: [Function](): Request Hierarchy ID: 1
DEBUG [171] Array: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Nodes at the same level

Array
(
[0] => 3
)

DEBUG [178]: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Root User ID: 3 Shared: 0
DEBUG [151] Array: [Function](): Request Levels

Array
(
)

DEBUG [314]: HierarchyListFactory::getByHierarchyControlIdAndUserIdAndLevel(): User ID: 3 Level: 0
DEBUG [171] Array: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Nodes at the same level

Array
(
[0] => 3
)

DEBUG [178]: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Root User ID: 3 Shared: 0
DEBUG [317] Array: HierarchyListFactory::getByHierarchyControlIdAndUserIdAndLevel(): Nodes at the same level

Array
(
[0] => 3
)

DEBUG [1517]: CompanyFactory::getLogoFileName(): Logo File Name: /var/timetrex/storage//company_logo/1/logo.jpg
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 78.7549 ms (7.96 %) Authentication::Check()
1 58.3341 ms (5.90 %) Interface.inc - Check for Exceptions
1 42.1329 ms (4.26 %) Interface.inc - Check for UNREAD messages...
3 10.6122 ms (1.07 %) getEmptyRecordSet()
1 57.3220 ms (5.80 %) setLocale()
1 472.0409 ms (47.73 %) unprofiled

269.7670 ms (27.28 %) Missed
============================================================================
988.9641 ms (100.00 %) OVERALL TIME
============================================================================

Post by **shaunw** » Thu May 08, 2008 8:30 pm

Please post the exact command that you are running in cron, and the output when you run that command manually.

millersvillegray · Post by **millersvillegray** » Mon May 12, 2008 5:11 am

Sorry for the delay, I was not able to get back to this on friday. The command we are using is this:

su admin -c "php /Library/WebServer/Documents/TimeTrex/classes/modules/core/../../../maint/cron.php > /dev/null 2>&1"

I have also tried running this manually as root on the system. And there is never any output after the command is run.

Thanks

Post by **shaunw** » Mon May 12, 2008 2:20 pm

What happens if run just this command?

Code: Select all

php /Library/WebServer/Documents/TimeTrex/classes/modules/core/../../../maint/cron.php

millersvillegray · Post by **millersvillegray** » Tue May 13, 2008 5:27 am

Nothing happens. The system thinks for a fraction of a second and then returns to the command prompt.

Post by **shaunw** » Tue May 13, 2008 10:23 am

Are your debug settings all enabled still? If not, enable them and run the command again.

As well, check your log file after you ran the command and see what the last 50-100 lines are.

8. In your TimeTrex.ini.php file, set the following under the [debug] section:
enable = TRUE
enable_display = TRUE
buffer_output = TRUE
enable_log = TRUE
verbosity = 11
Reproduce the issue and include any relevent information from the TimeTrex log file in your post.

millersvillegray · Post by **millersvillegray** » Tue May 13, 2008 12:46 pm

---------------[ Tue, 13 May 2008 15:39:04 -0400 (PID: 364) ]---------------
DEBUG [259]: [Function](): URI: /timetrex/interface/index.php 
DEBUG [261]: [Function](): Version: 2.2.8 Edition: 10 Production: 1 Demo Mode: 0 
DEBUG [107]: TTDate::setTimeZone(): Setting TimeZone: America/New_York 
DEBUG [497]: Authentication::Check(): Session Name: SessionID 
DEBUG [503]: Authentication::Check(): Session ID: 472745b60c863aa01a969edfadadd6f6 
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:472745b60c863aa01a969edfadadd6f6 
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400 
DEBUG [399]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:472745b60c863aa01a969edfadadd6f6 
DEBUG [69]: [Function](): User Authenticated: admin Created Date: 1210707190 
DEBUG [1961]: UserFactory::isInformationComplete(): User Information is Complete: 
DEBUG [102]: TTDate::setTimeZone(): TimeZone already set to: America/New_York 
DEBUG [135]: TTDate::setDateFormat(): Setting Default Date Format: m-d-Y 
DEBUG [149]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A 
DEBUG [163]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10 
DEBUG [101]: [Function](): Locale Cookie: en_US 
DEBUG [287]: TTi18n::getLanguageFromLocale(): Locale: en_US 
DEBUG [109]: [Function](): User Preference Language matches cookie! 
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale: 
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en_US,en_US.UTF-8,en,en.UTF-8 
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US 
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 0 Current Locale: 
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US 
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US 
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US 
DEBUG [1961]: UserFactory::isInformationComplete(): User Information is Complete: 
DEBUG [1138]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete: 
DEBUG [138]: [Function](): Station ID Cookie found! 3944c4602e8904968a3db00fb8939420 
DEBUG [241]: [Function](): UnRead Messages: 0 
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: Home URL: /timetrex/interface/index.php 
DEBUG [147]: [Function](): Request Hierarchy ID: 1 
DEBUG [171] Array: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Nodes at the same level
<pre>
Array
(
[0] => 1
)
</pre> 
DEBUG [178]: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Root User ID: 1 Shared: 0 
DEBUG [151] Array: [Function](): Request Levels
<pre>
Array
(
[0] => 1
)
</pre> 
DEBUG [314]: HierarchyListFactory::getByHierarchyControlIdAndUserIdAndLevel(): User ID: 1 Level: 0 
DEBUG [171] Array: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Nodes at the same level
<pre>
Array
(
[0] => 1
)
</pre> 
DEBUG [178]: HierarchyListFactory::getCurrentLevelIdArrayByHierarchyControlIdAndUserId(): Root User ID: 1 Shared: 0 
DEBUG [317] Array: HierarchyListFactory::getByHierarchyControlIdAndUserIdAndLevel(): Nodes at the same level
<pre>
Array
(
[0] => 1
)
</pre> 
DEBUG [1517]: CompanyFactory::getLogoFileName(): Logo File Name: /var/timetrex/storage//company_logo/1/logo.jpg 
---------------[ Tue, 13 May 2008 15:39:04 -0400 (PID: 364) ]---------------

Is this what you are looking for?

Post by **shaunw** » Tue May 13, 2008 3:36 pm

That is what we are looking for, but that debug output is from your Index.php page, not the result of running the cron.php file.

So you need to run the cron.php file with logging enabled, and then read the log file that is created (in your TimeTrex log directory) to know for sure if the cron.php file is actually doing anything.

Normally it outputs text to the screen to tell you, but depending on your settings this may be disabled somehow.

millersvillegray · Post by **millersvillegray** » Wed May 14, 2008 6:49 am

carbon:/var/mysql root# php /Library/WebServer/Documents/TimeTrex/classes/modules/core/../../../maint/cron.php

Parse error: parse error, expecting `T_OLD_FUNCTION' or `T_FUNCTION' or `T_VAR' or `'}'' in /Library/WebServer/Documents/TimeTrex/classes/modules/core/Environment.class.php on line 30

I have no idea what is going on now, there is nothing showing in the log file, but this is now showing up on the command line.

Post by **shaunw** » Wed May 14, 2008 2:07 pm

You are using the wrong version of PHP. You need to be running PHP v5.0 or greater, preferably v5.2.

linuxgnuru · Post by **linuxgnuru** » Sun May 25, 2008 2:51 pm

TimeTrex version: 2.2.8
Apache / PHP version information: Apache/2.2.8 (Unix) mod_ssl/2.2.8 OpenSSL/0.9.7l DAV/2 PHP/5.2.5
MySQL version: 5.0.51b
OS: Mac OS X 10.5.2

After manually running the

php /Library/WebServer/Documents/timetrex/classes/modules/core/../../../maint/cron.php

this is the result:

dyld: NSLinkModule() error
dyld: Symbol not found: _php_sig_gif
Referenced from: /usr/lib/php/extensions/no-debug-non-zts-20060613/gd.so
Expected in: flat namespace

Trace/BPT trap

but phpinfo() give me this:

gd

GD Support enabled
GD Version bundled (2.0.34 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.3.5
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XPM Support enabled
XBM Support enabled

Post by **shaunw** » Sun May 25, 2008 4:07 pm

You have something seriously wrong with your PHP installation. I have no idea what, but I would maybe try to re-install it fresh.

Keep in mind that you can have different versions of PHP for Apache and for the command line interface (CLI). This can often cause problems like the ones you are facing.

calastrilla · Post by **calastrilla** » Wed Jul 16, 2008 11:00 pm

Hi, I also get the Maintenance has not run in the last 48 hours.
I've set-up the cron, but to no avail
I've followed the steps in the above posts, but also no avail.
When I run:
calastrilla@LXPDC-TESTSERVER:~/TimeTrex/php/etc$ php /home/calastrilla/TimeTrex/timetrex/classes/modules/core/../../../maint/cron.php

This is what appears:

 
Debug Buffer 
============================================================================ 
Memory Usage: 2054228 
---------------------------------------------------------------------------- 
DEBUG [264]: [Function](): URI: /home/calastrilla/TimeTrex/timetrex/classes/modules/core/../../../maint/cron.php 
DEBUG [266]: [Function](): Version: 2.2.11 Edition: 10 Production: 1 Demo Mode: 0 
DEBUG [76]: [Function](): Error connecting to the database! 
DEBUG [39]: DBError::__construct(): postgres7 error: [-1: Missing extension for postgres] in CONNECT(localhost:5433, 'timetrex', '****', timetrex)
 
============================================================================ 

Is this right, there is an error connecting to postgres? But I can access TimeTrex without a problem (reporting, employee admin, etc.)

Post by **shaunw** » Thu Jul 17, 2008 10:01 am

This is a fairly common issue, because running PHP from the command line is completely 100% different from access PHP web pages. They use two different PHP.INI files, and you can have an extension enabled for PHP web pages, but not enabled for PHP command line interface (CLI).

This is what your problem is:

postgres7 error: [-1: Missing extension for postgres]

Your PostgreSQL extension is not enabled for PHP CLI. Which usually means your PHP.INI that your PHP CLI is using isn't correct. You can usually start by copying your PHP.INI that Apache is using overtop of the PHP.INI that PHP CLI is using.

TimeTrex Time and Attendance

WARNING: TimeTrex maintenance jobs have not run

WARNING: TimeTrex maintenance jobs have not run

Different error

Maintenance not running

Time and Attendance