From: Don S. <do...@se...> - 2002-03-14 21:47:04
|
It appears that the times shown in postings on my slash site are 6 hours behind the times. My time zone is Central (America/Chicago). The date is correctly set on the OS. Does this have anything to do with setting the TZ=GMT in the safe_mysqld script? The install procedure from slash says to do this so I did it. Thoughts? Don. |
From: Jamie M. <ja...@mc...> - 2002-03-15 05:05:04
|
do...@se... (Don Seiler) writes: > It appears that the times shown in postings on my slash site are > 6 hours behind the times. My time zone is Central > (America/Chicago). The date is correctly set on the OS. > > Does this have anything to do with setting the TZ=GMT in the > safe_mysqld script? The install procedure from slash says to do > this so I did it. Are you sure? The symptom you describe is exactly what happens if you don't. Do a SELECT NOW() and it should show you GMT time. If not, look at your safe_mysqld again. -- Jamie McCarthy ja...@mc... |
From: Alessio B. <al...@al...> - 2002-03-15 14:31:39
|
I still believe that the requisite to run Slash and MySql in GMT is very bad. It's also impossible for people (like me) who run other services on the same database engine. Anyway, in my Italian site (www.accordo.it) I don't want to run Slash and MySql as GMT, so I decreased diffs for each timezone of 3600 seconds (Italy is in MET, GMT+1 during winter) and everything seems to work fine. I will have to manually adjust again when daylight saving starts. I will probably write something for Slashcode.com as soon as I am sure there are no side effects. -- Alessio F. Bragadini al...@al... APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 "It is more complicated than you think" -- The Eighth Networking Truth from RFC 1925 |
From: Don S. <do...@se...> - 2002-03-15 15:23:51
|
Hmmm you are right it isn't in the safe_mysqld script. Must have forgotten that after reformat. However, I have another website running off of mysql, which (of course) displays the right times. (select now() showed the right time, as you would assume). If I put the TZ=GMT in the safe_mysqld script, will it be totally off? Don. On Fri, 15 Mar 2002, Jamie McCarthy wrote: > do...@se... (Don Seiler) writes: > > > It appears that the times shown in postings on my slash site are > > 6 hours behind the times. My time zone is Central > > (America/Chicago). The date is correctly set on the OS. > > > > Does this have anything to do with setting the TZ=GMT in the > > safe_mysqld script? The install procedure from slash says to do > > this so I did it. > > Are you sure? The symptom you describe is exactly what happens if > you don't. > > Do a SELECT NOW() and it should show you GMT time. If not, look > at your safe_mysqld again. > -- > Jamie McCarthy > ja...@mc... > > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > |