----Original Message---- From: [email protected] [mailto:[email protected]] On Behalf Of Eli Guzman Sent: Wednesday, April 20, 2011 9:10 PM To: Ruslan Zakirov Cc: [email protected] Subject: Re: [rt-users] Is a time zone user preference available?
> ----Original Message---- > From: [email protected] [mailto:[email protected]] On > Behalf Of Ruslan Zakirov Sent: Wednesday, April 20, 2011 7:43 PM To: > Eli Guzman > Cc: [email protected] > 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 >> <[email protected]> wrote: >>> ----Original Message---- >>> From: [email protected] >>> [mailto:[email protected]] On Behalf Of Kevin >>> Falcone Sent: Wednesday, April 20, 2011 2:01 PM To: >>> [email protected] 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@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@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
