[Building Sakai] Is there any risk involved while changing database timezone

[Jehan Badshah]

Dear  Bryan

Thanks for reply, I set JAVA_OPTS parameter to my local timezone as
 -Duser.timezone='Asia/Karachi'

then restarted tomcat,

now sakai/tomcat log showing GMT+0 time, but I am on GMT+5
(e.g., Asia/Karachi)


when I am running following query
select DBTIMEZONE,to_char(current_timestamp, 'dd Mon yy hh24:mi:ss TZD')
from dual;
it showing following time, which is different from my country time.
-07:00 28 Mar 12 05:50:22

same time also showing in some places, like time of cron job, and turnitin.

we want to sych time zone and time of all machines and database of our
deployment.











On Wed, Mar 28, 2012 at 6:01 PM, Bryan Holladay <holladay at longsight.com>wrote:

> You should probably be running 2.8.1 since there have been a ton of
> bug fixes with issues reported in 2.8.0 (some about timezones like
> https://jira.sakaiproject.org/browse/SAK-21111).  Also, the
> announcements tool had lots of resolved issues in 2.8.1.
>
> > We want to change database timezone,
>
> Not sure if you need to change it in the DB when you can just set it
> in the JavaOpts like:
>
> JAVA_OPTS="-Dhttp.agent=Sakai  -Duser.timezone=America/Los_Angeles ...."
>
>
> > what tools can effect?.
>
> Calendar is the big one.  Every tool that uses a timestamp
> (assignments, GB, T&Q, Forums.....) all will (and should) use the
> Timezone.
>
>
> >Is there any risk involved while changing database timezone.
>
> Sakai handles timezones rather well...  We have several clients that
> run in different time zones from the same datacenter.
>
>
> Thanks,
> Bryan
>
> On Wed, Mar 28, 2012 at 4:20 AM, Jehan Badshah <jehan.badshah at nu.edu.pk>
> wrote:
> > Dear All
> >
> > we are using sakai 2.8.0 and Oracle 9i.
> >
> > We want to change database timezone,
> >
> > what tools can effect?.
> >
> > Is there any risk involved while changing database timezone.
> >
> >
> > Regards
> > ----------------------------------------------------
> > Jehan Badshah | Sr. Software Engineer
> > FAST - National University of Computer and Emerging Sciences
> > A.K. Brohi Road, H-11/4, Islamabad
> > UAN: +92 (0)51 - 111 128 128 ext 344
> >
> >
> >
> > _______________________________________________
> > 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"
>



-- 

Regards
----------------------------------------------------
Jehan Badshah | Sr. Software Engineer
FAST - National University of Computer and Emerging Sciences
A.K. Brohi Road, H-11/4, Islamabad
UAN: +92 (0)51 - 111 128 128 ext 344
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120328/42fcde59/attachment.html