[Deploying Sakai] Time zone mismatch on sakai 2.8
Eduardo
eduzav at hotmail.com
Thu Dec 1 10:24:10 PST 2011
Do you know what events or tables are affected by this behavior?, I could
change the GMT constant valuet by GMT-3 constant value? What do you think?
Also Ive just added -Duser.timezone parameter setting Argentina time zone
on java variable but nothing occur
De: jonespm at gmail.com [mailto:jonespm at gmail.com] En nombre de Matthew Jones
Enviado el: Martes, 29 de Noviembre de 2011 12:38 p.m.
Para: Eduardo
CC: production at collab.sakaiproject.org
Asunto: Re: [Deploying Sakai] Time zone mismatch on sakai 2.8
FYI: Sakai Events (and other fields that store the date/time like session)
are stored in GMT. This is because it will be the only time that is ever
constant. It's possibly your data center could relocate, you could have
daylight savings time. GMT never changes with seasons and is always a
constant.
Here's some additional information from a post a few years ago.
http://collab.sakaiproject.org/pipermail/sakai-dev/2009-September/003731.htm
l
-Matthew
On Tue, Nov 29, 2011 at 8:46 AM, Eduardo <eduzav at hotmail.com> wrote:
Hy, were using Sakai 2.8 on Argentina and we have difference time between
application and database ( three hours mismatch)
Example: when a user logs on application at 17hs the sesión_start field on
table is 20hs
The time zone of Argentina is GMT -3.
All servers (backend and frontends) are synchronizing the hour using ntp
protocol ( <http://www.pool.ntp.org/zone/ar> ar.pool.ntp.org) and the time
zone configurated is GMT+3 (the operating systems are OEL 5.5)
On backend were using Oracle 10g release 4 and the time configurated on
instance is OK.
select systimestamp from dual;
29/11/2011 10:32:06,241764 AM -03:00
select current_timestamp from dual;
29/11/2011 10:29:39,827614 AM -03:00
The time on application layout is Ok but the time on oracle table is
incorrect.
The table were monitoring is sakai.session and the fields are SESSION_START
and SESSION_END.
On the other hand catalina evironment is:
CATALINA_OPTS='-server -Xms512m -Xmx3072m -XX:PermSize=128m
-XX:MaxPermSize=512m -XX:NewSize=192m -XX:MaxNewSize=384m
-Djava.awt.headless=true -Dhttp.agent=Sakai
-Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false
-Dsun.lang.ClassLoader.allowArraySyntax=true -Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=33331
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.authenticate=false -Duser.language=es
-Duser.region=ES'
I dont know how can I fix that error, what do you suggest me?
Thanks,
Eduardo Zavala
_______________________________________________
production mailing list
production at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/production
TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org
with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20111201/dec0529a/attachment.html
More information about the production
mailing list