Another WARNING: TimeTrex was unable to set timezone problem

[Sprije]

Hi All,

I have gotten Timetrex up and running and am very impressed with what it has to offer. Unfortunately, I am receiving the WARNING: Timetrex was unable to set your time zone error. I have tried the "mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql -p mysql" fix, to no avail.

I am using FreeBSD 6.2
TimeTrex Standard 1.5.1 on
Apache 1.3.37 with
PHP 5, and
mysql 4.1.

Is there any particular log output or debug info that would also be useful in tracking down the root of the issue? I have been Googling for hours, and found very little on the subject.

Thanks a lot,
Jeremy

[Sprije]

After I posted this I got to reading the requirements and realized that I was still using MySQL 4.1.23 when the req's call for 4.1.3+. I'm upgrading in hopes that this resolves the timezone issue. Will let you know.

[Sprije]

Unfortunately, even after upgrading to mysql 5.0.27 I continue to receive the same error. Any suggestions would be greatly appreciated.

[Sprije]

Here's the debug output for the first page after logging in.

Debug Buffer
============================================================================
Memory Usage: 5910392
----------------------------------------------------------------------------
DEBUG [153]: [Function](): URI: /interface/
DEBUG [155]: [Function](): Production: 1
DEBUG [486]: Authentication::Check(): Session Name: SessionID
DEBUG [492]: Authentication::Check(): Session ID: 24eb51f1147c428c161d63a4b96f1e2c
DEBUG [301]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:24eb51f1147c428c161d63a4b96f1e2c
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [301]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:24eb51f1147c428c161d63a4b96f1e2c
DEBUG [62]: [Function](): User Authenticated: jeremy Created Date: 1175523674
DEBUG [1817]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [92]: TTDate::setTimeZone(): Setting TimeZone: PST
DEBUG [108]: TTDate::setDateFormat(): Setting Default Date Format: m/d/Y
DEBUG [122]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [136]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [1817]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [954]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [104]: [Function](): Station ID Cookie found! 0901a0d0d27a3c8585f2ff21ffe817fb
DEBUG [199]: [Function](): UnRead Messages: 0
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: Home URL: /interface/
DEBUG [49]: [Function](): Last Logged in Date: 04/02/2007 2:21 PM
DEBUG [57]: [Function](): Filter Date: 04/01/2007 2:53 PM
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 1658.3841 ms (16.89 %) Authentication::Check()
1 728.8210 ms (7.42 %) Interface.inc - Check for Exceptions
1 688.8120 ms (7.01 %) Interface.inc - Check for UNREAD messages...
2 322.4759 ms (3.28 %) getEmptyRecordSet()
1 4853.2662 ms (49.42 %) unprofiled

1568.5928 ms (15.97 %) Missed
============================================================================
9820.3521 ms (100.00 %) OVERALL TIME
============================================================================

[shaunw]

What is the output of:

mysql_tzinfo_to_sql /usr/share/zoneinfo/

Most likely the issue is either:

1. Your timezone information isn't being imported into MySQL.
2. The timezone you are trying to use in TimeTrex is not actually in MySQL.

You can do tests by going into your MySQL console and running:

set session time_zone="PST8PDT";

[Sprije]

Thanks for your response.

The output I get is:

Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

I am noticing that the debug info says:

DEBUG [92]: TTDate::setTimeZone(): Setting TimeZone: PST

When I do a set session time_zone="PST"; I get:

ERROR 1298 (HY000): Unknown or incorrect time zone: 'PST'

[shaunw]

You can try downloading the timezone database from:

http://dev.mysql.com/downloads/timezones.html

That might work better for you.

[Sprije]

I don't know what kind of problems this might cause, but I resolved the error by opening the mysql timezone table, and changing the PST8PDT zone to PST. The error disappeared. now I'm taking a stab with the Cron jobs not run in 48 hours error. Making progress though. Thanks for the tips.

[shaunw]

It means your PST timezone will observe daylight saving time, which it normally would not.

My last post about downloading the raw timezone tables is what all windows users and some unix users have to do, so I highly recommend you give it a try. It should provide nearly every timezone you could ever use.

[Sprije]

I've downloaded the timezone database files - do I just copy them into the /var/db/mysql directory and then restart the mysql server?

[shaunw]

Yes, that should work.

[Sprije]

Alright, I got the new timezone files in there, and the issue seems to be resolved. I was only hesistant to try it because the download page clearly states that FreeBSD users should use their own timezone files.

Thanks so much!