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

Thu Apr 21 22:50:38 EDT 2011

Hello,

Look into logs for additional info about blank page.

You have several options:

* switch over fcgi
* figure out why modperl handler doesn't work
* find/write patch for RT that uses Env::C in Date.pm

On Fri, Apr 22, 2011 at 4:27 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 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
>
>
>
>
>

-- 
Best regards, Ruslan.