[rt-users] Is a time zone user preference available?

[Eli Guzman]

----Original Message----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Eli
Guzman Sent: Wednesday, April 20, 2011 9:10 PM To: Ruslan Zakirov
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Is a time zone user preference available?

> ----Original Message----
> From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On
> Behalf Of Ruslan Zakirov Sent: Wednesday, April 20, 2011 7:43 PM To:
> Eli Guzman 
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] Is a time zone user preference available?
> 
>> Hello,
>> 
>> Do you use mod_perl? Try "SetHandler modperl" instead of "SetHandler
>> perl-script" in apache's config. Don't forget to stop/start the
>> server. 
>> 
>> On Thu, Apr 21, 2011 at 12:14 AM, Eli Guzman
>> <eguzman at cvimellesgriot.com> wrote:
>>> ----Original Message----
>>> From: rt-users-bounces at lists.bestpractical.com
>>> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Kevin
>>> Falcone Sent: Wednesday, April 20, 2011 2:01 PM To:
>>> rt-users at lists.bestpractical.com Subject: Re: [rt-users] Is a time
>>> zone user preference available?
>>> 
>>>> On Wed, Apr 20, 2011 at 01:25:41PM -0600, Eli Guzman wrote:
>>>>>>> There's no need for elaborate schemes. Timezone, along with
>>>>>>> language, is on the user About Me page.
>>>>>>> 
>>>>>>> Thomas
>>>>>> 
>>>>>> Hey Thomas,
>>>>>> 
>>>>>> Thanks a bunch, somehow I missed that ;).
>>>>>> 
>>>>>> Eli
>>>>> 
>>>>> Not sure how common this issue is, but I have changed the 'About
>>>>> Me' timezone preferences, however the change isn't reflected on
>>>>> the interface. See images below: 
>>>>> 
>>>>> http://min.us/mDnN4uxnfqIBg#1
>>>> 
>>>> You've neglected to say:
>>>> 
>>>> What you set it to in About Me.
>>>> What time you expect to see.
>>>> 
>>>> I see something roughly 2 hours behind the current time, so assume
>>>> it is showing in Mountain time
>>>> 
>>>> -kevin
>>>> 
>>>>> I had the $Timezone variable in RT_SiteConfig.pm set to the
>>>>> following: Set($Timezone , 'US/Mountain'); but I commented this
>>>>> out (restarted httpd services)to see if there was any change to
>>>>> the interface, but nothing so far. Time is being synched via
>>>>> NTPD/system clock is not currently set to UTC/and system TZ is set
>>>>> to Denver TZ (-0700 GMT). Could I be missing something obvious
>>>>> here? 
>>>>> 
>>>>> Thanks for any insights!
>>>>> 
>>>>> Regards,
>>>>> Eli
>>> 
>>> Hey Kevin,
>>> 
>>> Yes you are correct, it is showing that it is currently set Mountain
>>> TZ (which was what the RT_SiteConfig was set to), and I went ahead
>>> and changed the preference under the about me section to
>>> 'Europe/London +0100', but for some reason the change has not taken
>>> effect. 
>>> 
>>> Just not sure as to why, could this perhaps be related to the
>>> database itself? Currently MySQL should be getting TZ data from the
>>> OS itself, but I believe I can hard-set it in the my.ini file, not
>>> sure if this is the preferred method for RT/or to be honest if it
>>> should matter if the DB should be set to a specific TZ.
>>> 
>>> Regards,
>>> Eli
> 
> Hey Ruslan,
> 
> I can give that a try and let you know if it fixes the issue; thanks
> for the input. 
> 
> Regards,
> Eli

Hey Ruslan,

I have mod_perl installed on the system:

[root at xxx ~]# yum list mod_perl
Loaded plugins: rhnplugin, security
Installed Packages
mod_perl.x86_64                             2.0.4-6.el5
installed

However I was not using it directly with RT3, here is my
/etc/httpd/conf.d/rt3.conf:

Alias /ticket "/opt/rt3/share/html"

PerlRequire /opt/rt3/bin/webmux.pl

<Directory "/opt/rt3/share/html">
  AllowOverride All
  Options ExecCGI FollowSymLinks

  RewriteEngine On
  RedirectMatch permanent (.*)/$ $1/index.html
  AddDefaultCharset UTF-8
  SetHandler perl-script
  #SetHandler modperl <-- Interface did not load -- just a blank screen
  PerlHandler RT::Mason

At first I tried reloading apache with the 'SetHandler modperl' line but
this caused RT3 not to load (just a blank screen) so as you can see I
commented out the line, and reloaded httpd services, the RT app was
returned to normal at that point.

So I am guessing that the RPM version I have installed of mod_perl is
not compatible with RT3, so this leaves me with being able to use
perl-script handler. 

I did change the system time to just use UTC:

[root at xxx ~]# date
Fri Apr 22 00:10:12 UTC 2011

I reloaded MySQL services and this forced the database to use UTC
instead of MDT:

mysql> select distinct @@system_time_zone from user;
+--------------------+
| @@system_time_zone |
+--------------------+
| UTC                |
+--------------------+
1 row in set (0.00 sec)

Now the database shows the time as UTC, and so do tickets on the RT
interface as well. However, I am still unable to change to different
timezones for any user. 

Could this be an inconsistency of using "SetHandler perl-script" rather
than 'mod_perl' in my RT3 specific Apache configuration? And if this is
the case, since I am unable to use the RPM version of mod_perl; should I
just build mod_perl from source and see if this corrects the problem?
Could something be missing from my main Apache configuration (meaning
/etc/httpd/conf/httpd.conf)? At the moment I am still somewhat stumped
on this one, if anyone has any other input I would appreciate it.

Best Regards,
Eli