Forum OpenACS Q&A: ACS sysdate lag!

Collapse
1: ACS sysdate lag!
Posted by Samer Abukhait on 06/27/02 01:41 PM
am having a strange problem, my database is giving me a correct
sysdate when quering it from the database directly, While the TCL
pages are giving me sysdate - 3 hours always for sysdate.
is that problem in the driver?? or whats the case exactly?
Collapse
2: Response to ACS sysdate lag! (response to 1)
Posted by Pascal Scheffers on 06/27/02 03:33 PM
could it be that you do not have your time zones setup correctly? Or just that one of them reports the date in UTC and the other in local time?
Collapse
3: Response to ACS sysdate lag! (response to 1)
Posted by Samer Abukhait on 06/27/02 03:53 PM
if it is, how may i get sure? or fix it??

am even getting the same problem using
[clock format [clock seconds] -format "%Y-%m-%d %H:%M:%S" -gmt f]
in the tclsh it gives me the correct time, in tcl pages it gives me earlier time!

Collapse
4: Response to ACS sysdate lag! (response to 1)
Posted by Michael Hinds on 06/27/02 04:01 PM
I'm not sure if this would cause the symptoms you've described, but I've seen strange things happening when my Linux clock and hardware clock were out of sync.

hwclock --systohc will set the hardware clock to the same as Linux.

If you're using Oracle, be aware that it will die horribly if you change the time while it's up!

Collapse
5: Response to ACS sysdate lag! (response to 1)
Posted by Samer Abukhait on 06/27/02 04:15 PM
hwclock --show <br>
is giving me the correct time that 'date' is giving.<br>
that devilish earlier time has nothing to do with hwclock. am going crazy with this !!
Collapse
6: Response to ACS sysdate lag! (response to 1)
Posted by Andrei Popov on 06/27/02 11:03 PM
Maybe you want to explicitly set TZ environemnt var for nsadmin (assuming that is the user your AOLServer is running as). Something like this in .profile could probably help: 
TZ=CET
export TZ
(this assumes you need to set your time zone to Central European Time)
Collapse
7: Response to ACS sysdate lag! (response to 1)
Posted by Samer Abukhait on 06/27/02 11:07 PM
I tried that.. and nothing changed!