[Building Sakai] Incorrect dates in Grade Log

[Matthew Jones]

Not sure if this is relevant, but Java uses GMT by the default if it can't
figure out the timezone and Sakai stores in GMT. Different versions of java
seem to detect this differently depending on OS as well as jvm version.
Recently we had a issue where java 1.5 was detecting correctly, as well as
java 1.6.0_22. But java1.6.0_17 could not. 1.5 and _22 were using
/usr/sysconfig/clock and _17 was looking directly at /etc/localtime. It was
really a *unpredictable* situation.

I'd written about this for a user running Windows server a few months ago.
http://collab.sakaiproject.org/pipermail/sakai-dev/2010-January/005374.html

You can strace with this class to find out what timezone file it's trying to
if you want to spend a lot of time investigating OR much easier (and what we
just did) just set your time zone as a JAVA_OPT at the tomcat startup.

For instance:

-Duser.timezone=Asia/Hong_Kong

or


-Duser.timezone=America/Los_Angeles

Or whatever your timezone is. Whatever the sample .java app on that
link returns, tomcat will also be set to by default.

On Wed, Dec 22, 2010 at 12:13 PM, Bryan Bakotich <bakotibj at plu.edu> wrote:

Matt,
>
> We are on the west coast in Washington state so we are in the Pacific time
> zone. I checked to make sure both our database and application server are in
> sync and on the correct time since we recently had some issues resulting
> from a fire in our server room.
>
> Does Sakai use GMT by default and is there a property somewhere to set our
> timezone? I was under the impression that it used the timezone from the
> server by default. All our servers are running linux.
>
> -Bryan
>
>
> On Wed, Dec 22, 2010 at 8:05 AM, <mizematr at notes.udayton.edu> wrote:
>
>> Bryan,
>>
>> I notice that all of the dates are with about four hours of Midnight and
>> was wondering what your time zone is.  Is it possible that dates are stored
>> in Greenwich Mean Time but are displayed in your local time zone?
>>
>> ---------------------------------------------------------------------------
>> Matt Mize, Systems Administrator
>> - Pay no attention to the man in the back office....
>> Matt.Mize at notes.udayton.edu
>> (937) 229-1024
>>
>> UDit Department, University of Dayton
>> 300 College Park, Dayton, OH, 45469-1302
>>
>>
>>
>> From:        Bryan Bakotich <bakotibj at plu.edu>
>> To:        sakai-dev at collab.sakaiproject.org
>> Date:        12/21/2010 06:19 PM
>> Subject:        [Building Sakai] Incorrect dates in Grade Log
>> Sent by:        sakai-dev-bounces at collab.sakaiproject.org
>> ------------------------------
>>
>>
>>
>> Hi all,
>>
>> It has been brought to my attention that sometimes the dates displayed in
>> the Grade Log are incorrect. Here is a concrete example of what I'm looking
>> at:
>>
>> The DATE_GRADED value for 3 entries in the GB_GRADING_EVENT_T are:
>> 2010-12-14 22:56:01
>> 2010-12-16 17:13:02
>> 2010-12-18 21:50:18
>>
>> The dates that get displayed to the user in the Grade Log are:
>> 12/15/10
>> 12/17/10
>> 12/19/10
>>
>> Does anyone know why the dates displayed are all 1 day off from the dates
>> that are stored in the database? Thanks for any help!
>>
>> We are using MySQL 5.1 and Sakai 2.6.x revision 69729
>>
>> -Bryan
>>
>> --
>> Bryan Bakotich
>> Open Source Implementation Specialist
>> Digital Media Center, Information & Technology Services
>> Pacific Lutheran University
>> Tacoma, WA 98447-0013
>> Phone: 253-536-5021_______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
>
> --
> Bryan Bakotich
> Open Source Implementation Specialist
> Digital Media Center, Information & Technology Services
> Pacific Lutheran University
> Tacoma, WA 98447-0013
> Phone: 253-536-5021
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101222/c6640f45/attachment.html