[rt-users] RT 3.6.5 transactions created in wrong timezone....

[Jesse Vincent]

> 
> Since we upgraded to 3.6.5 the times records on each transaction are 10 
> hours behind. This is annoying because it muddies up the figures as to 
> when transactions were done.
> my server has timezome set correctly and syncs to an ntp server.


In the UI or in the database? RT stores all timestamps in GMT in the
database.

> 
> Even though i set /opt/rt3/etc/RT_SiteConfig.pm up with a correct 
> timezone...
> 
> Set($Timezone , 'Australia/Sydney');
> 
> it still shows wrong. I have read some posts on the list, some say its 
> InnoDB thats doing the GMT time and not looking at the variable in 
> RT_SiteConfig.pm. However nobody has a real solution.
> 
> This is from the list....
> 
> "As of 3.6.5 you have to edit lib/RT.pm to modify the function
> "InitLogging" which uses gmtime(time)."
> 
> ....can anyone shed some light on exactly what needs to be changed? i'm no perl expert.
> 
> 
> TIA
> 
> Regards,
> 
> Les
> 
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 

--