Nevermind. Apparently there is no way to set timezones in mysql. I'm still wrapping my head around around why that is, but so be it.
My issue with the application was there is an obscure setting to set the user timezone login (not mentioned in the documentation for some reason).
Anyway, all is well.
Greg
On Tuesday, Aug 24, 2004, at 13:44 US/Eastern, [EMAIL PROTECTED] wrote:
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
--
TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
TriLUG Organizational FAQ : http://trilug.org/faq/
TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
-- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/ TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
