[TriLUG] mysql and timezones

[gregbrown at mindspring.com]

I tried to send this last night, but it appears to have 
vanished into the ether.  Oh well.

Here it goes again.  Is anyone on the list using tutos 
(the CRM application)?  I have reinstalled and have 
been thwarted thus far in setting the timezone to be 
anything other than GMT.  I have googled, read the 
tutos documentation, etc.  I believe my issues is my 
mysql database seems to be set to GMT and I can't 
get the database on America/New_York despite my 
google efforts.

What google, and mysql documentation, says (or 
seems to have said) should work was editing the 
my.cnf file and putting the line
timezone = America/New_York in and restarting 
mysql.  That hasn't worked.  

I thought the problem might be PHP but it does 
not seem to be the case.  A quick test of PHP to 
print out the time shows that PHP things the time 
is America/New_York.  This leaves the mysql time 
as the likely culprit (according to Tutos help docs).

Any suggestions on how to set the mysql database 
timezone?

Thanks.

Greg