Re: [rt-users] perlbrew/cpanm installation on centos 6
On Sat, Jun 9, 2012 at 8:17 AM, Natxo Asenjo wrote: > > With FastCgiIpcDir *and* the dir with permissions 777, it works blocking > some images: > > [Sat Jun 09 08:15:28 2012] [error] [client 192.168.0.160] FastCGI: invalid > (dynamic) server "/opt/rt4/share/html/NoAuth/images/bpslogo.png": access > for server (uid -1, gid -1) not allowed: execute not allowed, referer: > http://rt.ipa.asenjo.nx/ > [Sat Jun 09 08:15:28 2012] [error] [client 192.168.0.160] FastCGI: invalid > (dynamic) server "/opt/rt4/share/html/NoAuth/images/bpslogo.png": access > for server (uid -1, gid -1) not allowed: execute not allowed, referer: > http://rt.ipa.asenjo.nx/ > > If the FastCgiIpcDir has perms 770 for apache:apache , it does not work. > by the way, the permissions for those images are: ls -l /opt/rt4/share/html/NoAuth/images/ total 40 -rw-r--r--. 1 root bin 334 Jun 8 21:11 autohandler -rw-r--r--. 1 root bin 3929 Jun 8 21:11 bpslogo.png drwxr-xr-x. 2 root bin 4096 Jun 8 21:11 css -rw-r--r--. 1 root bin 914 Jun 8 21:11 empty_star.gif drwxr-xr-x. 2 root bin 4096 Jun 8 21:11 farbtastic -rw-r--r--. 1 root bin 335 Jun 8 21:11 favicon.png drwxr-xr-x. 2 root bin 4096 Jun 8 21:11 jquery_ui -rw-r--r--. 1 root bin 161 Jun 8 21:11 star.gif drwxr-xr-x. 2 root bin 4096 Jun 8 21:11 tablesorter -rw-r--r--. 1 root bin 81 Jun 8 21:11 test.png So they are world readable and still being blocked. Perhaps they should be owned by apache?
Re: [rt-users] perlbrew/cpanm installation on centos 6
On Sat, Jun 9, 2012 at 12:57 AM, Kevin Falcone wrote: > On Fri, Jun 08, 2012 at 10:07:16PM +0200, Natxo Asenjo wrote: > > On Fri, Jun 8, 2012 at 5:34 PM, Thomas Sibley > wrote: > > > > My rt.conf apache virtual host config: > > > > FastCgiServer /opt/rt4/sbin/rt-server -processes 5 -idle-timeout 300 > > > > > > ServerName rt.domain.tld > > ### Optional apache logs for RT > > # Ensure that your log rotation scripts know about these files > > ErrorLog /opt/rt4/var/log/apache2.error > > TransferLog /opt/rt4/var/log/apache2.access > > LogLevel debug > > > > AddDefaultCharset UTF-8 > > > > Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/ > > ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/ > > > > DocumentRoot "/opt/rt4/share/html" > > > > Order allow,deny > > Allow from all > > > > Options +ExecCGI > > AddHandler fastcgi-script fcgi > > > > > > > > Your FastCgiServer line looks different from the one in > docs/web_deployment.pod. > > you are right, I had bee trying stuff and forgotten to set it back: FastCgiIpcDir /var/www/html/fastcgi-rt/ FastCgiServer /opt/rt4/sbin/rt-server.fcgi -processes 5 -idle-timeout 300 SetHandler fastcgi-script ServerName rt.ipa.asenjo.nx ### Optional apache logs for RT # Ensure that your log rotation scripts know about these files ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access LogLevel debug AddDefaultCharset UTF-8 Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/ ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/ DocumentRoot "/opt/rt4/share/html" Order allow,deny Allow from all Options +ExecCGI AddHandler fastcgi-script fcgi If I do not set the FastCgiIpcDir directive it does not work at all. Without FastCgiIpcDir: /opt/rt4/var/log/apache2.error: [Sat Jun 09 08:12:34 2012] [error] [client 192.168.0.160] (13)Permission denied: FastCGI: failed to connect to server "/opt/rt4/sbin/rt-server.fcgi": connect() failed [Sat Jun 09 08:12:34 2012] [error] [client 192.168.0.160] FastCGI: incomplete headers (0 bytes) received from server "/opt/rt4/sbin/rt-server.fcgi" /var/log/httpd/error.log [Sat Jun 09 08:13:29 2012] [crit] (13)Permission denied: FastCGI: can't create server "/opt/rt4/sbin/rt-server.fcgi": bind() failed [/etc/httpd/logs/fastcgi/f758b05f8779532382e3166ad1890013] [Sat Jun 09 08:13:30 2012] [crit] (13)Permission denied: FastCGI: can't create server "/opt/rt4/sbin/rt-server.fcgi": bind() failed [/etc/httpd/logs/fastcgi/f758b05f8779532382e3166ad1890013] With FastCgiIpcDir *and* the dir with permissions 777, it works blocking some images: [Sat Jun 09 08:15:28 2012] [error] [client 192.168.0.160] FastCGI: invalid (dynamic) server "/opt/rt4/share/html/NoAuth/images/bpslogo.png": access for server (uid -1, gid -1) not allowed: execute not allowed, referer: http://rt.ipa.asenjo.nx/ [Sat Jun 09 08:15:28 2012] [error] [client 192.168.0.160] FastCGI: invalid (dynamic) server "/opt/rt4/share/html/NoAuth/images/bpslogo.png": access for server (uid -1, gid -1) not allowed: execute not allowed, referer: http://rt.ipa.asenjo.nx/ If the FastCgiIpcDir has perms 770 for apache:apache , it does not work. Is this normal behaviour? Thanks for your help. -- natxo -kevin >
Re: [rt-users] Some questions, a few oddities, and some must-haves...
On Fri, Jun 08, 2012 at 10:57:50AM -0400, Glenn E. Sieb wrote: > On 06/07/2012 07:40 PM, Kevin Falcone wrote: > >I'm asking for a replication recipe. I want to know the steps to > >replicate your bug. -kevin > > LMAO! :-D Gotcha.. when *I* hear "replication" I hear "MySQL" or > "HA".. obviously not what you meant! :-) Sorry, a replication recipe for a bug is "Go to this URL, click like this, enter this value, you'll see the following". The sort of thing you'd stick in a bug if you were writing something for http://bestpractical.com/rt/issues.html I assume a bug like missing menus isn't tied to your configuration or build process, so they're not relevant in a first pass. If people can't replicate the bug using your instructions, then we might have to move into build specifics. -kevin pgpkITmaQStco.pgp Description: PGP signature
Re: [rt-users] perlbrew/cpanm installation on centos 6
On Fri, Jun 08, 2012 at 10:07:16PM +0200, Natxo Asenjo wrote: > On Fri, Jun 8, 2012 at 5:34 PM, Thomas Sibley wrote: > > My rt.conf apache virtual host config: > > FastCgiServer /opt/rt4/sbin/rt-server -processes 5 -idle-timeout 300 > > > ServerName rt.domain.tld > ### Optional apache logs for RT > # Ensure that your log rotation scripts know about these files > ErrorLog /opt/rt4/var/log/apache2.error > TransferLog /opt/rt4/var/log/apache2.access > LogLevel debug > > AddDefaultCharset UTF-8 > > Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/ > ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/ > > DocumentRoot "/opt/rt4/share/html" > > Order allow,deny > Allow from all > > Options +ExecCGI > AddHandler fastcgi-script fcgi > > > Your FastCgiServer line looks different from the one in docs/web_deployment.pod. -kevin pgp8crFtZbcBG.pgp Description: PGP signature
Re: [rt-users] perlbrew/cpanm installation on centos 6
On Fri, Jun 8, 2012 at 10:07 PM, Natxo Asenjo wrote: > Fri Jun 08 21:58:29 2012] [alert] [client 192.168.0.21] (13)Permission > denied: FastCGI: failed to connect to (dynamic) server > "/opt/rt4/sbin/rt-server.fcgi": something is seriously wrong, any chance > the socket/named_pipe directory was removed?, see the FastCgiIpcDir > directive > [Fri Jun 08 21:58:29 2012] [error] [client 192.168.0.21] FastCGI: > incomplete headers (0 bytes) received from server > "/opt/rt4/sbin/rt-server.fcgi" > If I define the FastCgiDir directive and chmod -R 777 that directory, then it works: FastCgiIpcDir /var/www/html/fastcgi-rt/ If this directory is apache:apache 770, it doesn't work. It bloks th best practical logo too: [Fri Jun 08 22:33:14 2012] [error] [client 192.168.0.160] FastCGI: invalid (dynamic) server "/opt/rt4/share/html/NoAuth/images/jquery_ui/ui-bg_flat_75_ff_40x100.png": access for server (uid 48, gid 48) not allowed: execute not allowed, referer: http://rt.ipa.asenjo.nx/ [Fri Jun 08 22:34:34 2012] [error] [client 192.168.0.21] FastCGI: invalid (dynamic) server "/opt/rt4/share/html/NoAuth/images/bpslogo.png": access for server (uid 48, gid 48) not allowed: execute not allowed, referer: http://rt.ipa.asenjo.nx/ Quite weird. -- natxo
Re: [rt-users] perlbrew/cpanm installation on centos 6
On Fri, Jun 8, 2012 at 5:34 PM, Thomas Sibley wrote: > > On 06/08/2012 10:20 AM, Natxo Asenjo wrote: > > If I try mod_fastcgi with the configuration on the web_deployment.pod I > > get errors (selinux is disabled): > > > > (13)Permission denied: FastCGI: failed to connect to server > > "/opt/rt4/sbin/rt-server.fcgi": > > So, did you try to fix the permissions? I suspect it's as simple as the > user apache is running as can't read/execute rt-server.fcgi and the > whole directory tree above it. You may need to change the group on files. > > To do that easily, re-run ./configure from the source tarball with the > appropriate --with-web-user and/or --with-web-group options and then run > make install again. You can find your original configure options at the > top of /opt/rt4/etc/RT_Config.pm. > these are the permissions in /opt/rt4/sbin: ls -l /opt/rt4/sbin/ total 216 -rwxr-xr-x. 1 root apache 3690 Jun 8 21:11 rt-attributes-viewer -rwxr-xr-x. 1 root apache 5511 Jun 8 21:11 rt-clean-sessions -rwxr-xr-x. 1 root apache 7816 Jun 8 21:11 rt-dump-metadata -rwxr-xr-x. 1 root apache 4966 Jun 8 21:11 rt-email-dashboards -rwxr-xr-x. 1 root apache 11886 Jun 8 21:11 rt-email-digest -rwxr-xr-x. 1 root apache 13054 Jun 8 21:11 rt-email-group-admin -rwxr-xr-x. 1 root apache 11797 Jun 8 21:11 rt-fulltext-indexer -rwxr-xr-x. 1 root apache 4664 Jun 8 21:11 rt-preferences-viewer -rwxr-xr-x. 1 root apache 8032 Jun 8 21:11 rt-server -rwxr-xr-x. 1 root apache 8032 Jun 8 21:11 rt-server.fcgi -rwxr-xr-x. 1 root apache 3684 Jun 8 21:11 rt-session-viewer -rwxr-xr-x. 1 root apache 17612 Jun 8 21:11 rt-setup-database -rwxr-xr-x. 1 root apache 20761 Jun 8 21:11 rt-setup-fulltext-index -rwxr-xr-x. 1 root apache 8439 Jun 8 21:11 rt-shredder -rwxr-xr-x. 1 root apache 15790 Jun 8 21:11 rt-test-dependencies -rwxr-xr-x. 1 root apache 38439 Jun 8 21:11 rt-validator -rwxr-xr-x. 1 root apache 8032 Jun 8 21:11 standalone_httpd This is my ./configure incantation: # $ ./configure --with-db-type=Pg --with-db-host=host.domain.tld --with-db-rt-pass=password --with-web-user=apache --with-web-group=apache --with-apachectl=/usr/sbin/apachectl --with-web-handler=fastcgi My rt.conf apache virtual host config: FastCgiServer /opt/rt4/sbin/rt-server -processes 5 -idle-timeout 300 ServerName rt.domain.tld ### Optional apache logs for RT # Ensure that your log rotation scripts know about these files ErrorLog /opt/rt4/var/log/apache2.error TransferLog /opt/rt4/var/log/apache2.access LogLevel debug AddDefaultCharset UTF-8 Alias /NoAuth/images/ /opt/rt4/share/html/NoAuth/images/ ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/ DocumentRoot "/opt/rt4/share/html" Order allow,deny Allow from all Options +ExecCGI AddHandler fastcgi-script fcgi In the apache error log I get plenty of these: Fri Jun 08 22:01:02 2012] [crit] (13)Permission denied: FastCGI: can't create server "/opt/rt4/sbin/rt-server": bind() failed [/etc/httpd/logs/fastcgi/5ca4b3adecea1bd2fa8ffd8f7584ca93] [Fri Jun 08 22:01:03 2012] [crit] (13)Permission denied: FastCGI: can't create server "/opt/rt4/sbin/rt-server": bind() failed [/etc/httpd/logs/fastcgi/5ca4b3adecea1bd2fa8ffd8f7584ca93] in the /opt/rt4/var/log/apache2.error Fri Jun 08 21:58:29 2012] [alert] [client 192.168.0.21] (13)Permission denied: FastCGI: failed to connect to (dynamic) server "/opt/rt4/sbin/rt-server.fcgi": something is seriously wrong, any chance the socket/named_pipe directory was removed?, see the FastCgiIpcDir directive [Fri Jun 08 21:58:29 2012] [error] [client 192.168.0.21] FastCGI: incomplete headers (0 bytes) received from server "/opt/rt4/sbin/rt-server.fcgi" I am afraid my fastcgi fu is close to zero. Learning as I go. If any one can shed light on this, that would be great. TIA. -- groet, natxo
Re: [rt-users] Permissions in RT 4.0.6
On Fri, Jun 8, 2012 at 7:51 PM, Max McGrath wrote: > Hi All - > > Looking at the new permissions (rights) screen in 4.0.6 and it looks really > good! Although it has me a little confused. It looks like on any rights > page i see "General Rights", "Rights for Staff", and "Rights for > Administrators". What deems someone "staff" and/or "administrators" and who > does "General rights" get applies to? These are just grouping of the rights into groups. Rights usually granted to Staff, to administrators and rights general enough to be granted to anybody. > Thanks! > -- > Max McGrath > Network Administrator > Carthage College > 262-552-5512 > mmcgr...@carthage.edu -- Best regards, Ruslan.
[rt-users] Permissions in RT 4.0.6
Hi All - Looking at the new permissions (rights) screen in 4.0.6 and it looks really good! Although it has me a little confused. It looks like on any rights page i see "General Rights", "Rights for Staff", and "Rights for Administrators". What deems someone "staff" and/or "administrators" and who does "General rights" get applies to? Thanks! -- Max McGrath Network Administrator Carthage College 262-552-5512 mmcgr...@carthage.edu
Re: [rt-users] perlbrew/cpanm installation on centos 6
On 06/08/2012 10:20 AM, Natxo Asenjo wrote: > In a test environment I have installed rt 4.0.6 with a local Perl > (5.14.2) from perlbrew. Installing the dependencies with cpanm was a > breeze, I must say, impressive. Yep, I wish more folks used this setup. It's never resulted in dependency hell for me. > If I try mod_fastcgi with the configuration on the web_deployment.pod I > get errors (selinux is disabled): > > (13)Permission denied: FastCGI: failed to connect to server > "/opt/rt4/sbin/rt-server.fcgi": So, did you try to fix the permissions? I suspect it's as simple as the user apache is running as can't read/execute rt-server.fcgi and the whole directory tree above it. You may need to change the group on files. To do that easily, re-run ./configure from the source tarball with the appropriate --with-web-user and/or --with-web-group options and then run make install again. You can find your original configure options at the top of /opt/rt4/etc/RT_Config.pm. SELinux makes things slightly harder and more frustrating, though still possible of course, but it's disabled, so you don't have to worry about that. > The mod_proxy way looks promissing, but is it a correct way? Is anyone > else running rt from a non system Perl and apache2 in rhel/centos? Reverse proxying is certainly an option, but apache + fastcgi is a very very common setup that works solidly. Thomas
Re: [rt-users] Some questions, a few oddities, and some must-haves...
On 06/07/2012 07:40 PM, Kevin Falcone wrote: I'm asking for a replication recipe. I want to know the steps to replicate your bug. -kevin LMAO! :-D Gotcha.. when *I* hear "replication" I hear "MySQL" or "HA".. obviously not what you meant! :-) Well on $WORK's server (CentOS 6.2), I did a bunch of "yum whatprovides" to install the packages for RT, and installed them using "yum install." Ran the usual configure/make testdeps (and anything missing, again, installed via yum)/make install bits. Here is the list of perl's packages RT shows in the configuration page (minus the paths): Apache::Session 1.86 Apache::Session::Generate::MD5 2.1 Apache::Session::Lock::MySQL 1.01 Apache::Session::MySQL 1.01 Apache::Session::Serialize::Storable 1.01 Apache::Session::Store::DBI 1.02 Apache::Session::Store::MySQL 1.04 AutoLoader 5.60 B 1.09_01 base 2.07 bytes 1.02 Cache::Simple::TimedExpiry 0.27 capitalization 0.03 Carp 1.04 CGI 3.59 CGI::Cookie 1.30 CGI::Emulate::PSGI 0.14 CGI::PSGI 0.15 CGI::Util 3.53 Class::Accessor 0.34 Class::Accessor::Fast 0.34 Class::Container 0.12 Class::Data::Inheritable 0.06 Class::Inspector 1.17 Class::ReturnValue 0.55 Clone 0.27 constant 1.05 Convert::ASN1 0.22 CSS::Squish 0.07 Cwd 3.33 Data::Dumper 2.131 Data::OptList 0.107 Date::Format 2.22 Date::Parse 2.27 DateTime 0.41 DateTime::Locale 0.45 DateTime::Set 0.31 DateTime::TimeZone 0.67 DateTime::TimeZone::Floating 0.01 DateTime::TimeZone::Local 0.01 DateTime::TimeZone::OffsetOnly 0.02 DateTime::TimeZone::UTC 0.01 DBD::mysql 3.0007 DBI 1.52 DBIx::SearchBuilder 1.62 DBIx::SearchBuilder::Union 0 DBIx::SearchBuilder::Unique 0.01 Devel::GlobalDestruction 0.04 Devel::StackTrace 1.27 Devel::StackTrace::Frame 1.27 Devel::Symdump 2.08 Digest::base 1.00 Digest::MD5 2.36 Digest::SHA 5.71 DynaLoader 1.05 Email::Address 1.888 Encode 2.44 Encode::Alias 2.15 Encode::Byte 2.04 Encode::Config 2.05 Encode::Encoding 2.05 Encode::Guess 2.05 Encode::Unicode 2.07 Errno 1.0901 Exception::Class 1.23 Exception::Class::Base 1.2 Exporter 5.58 Exporter::Heavy 5.58 FCGI 0.67 Fcntl 1.05 File::Basename 2.74 File::Glob 1.05 File::Path 2.08 File::ShareDir 1.00 File::Spec 3.33 File::Spec::Unix 3.33 File::Temp 0.22 FileHandle 2.01 GD 2.35 GD::Image 2.27 Getopt::Long 2.35 GraphViz 2.02 Hash::MultiValue 0.12 HTML::Element 3.23 HTML::Entities 1.35 HTML::Formatter 2.04 HTML::FormatText 2.04 HTML::Mason 1.48 HTML::Mason::CGIHandler 1.00 HTML::Mason::Exception 1.1 HTML::Mason::Exception::Abort 1.1 HTML::Mason::Exception::Compilation 1.1 HTML::Mason::Exception::Compilation::IncompatibleCompiler 1.1 HTML::Mason::Exception::Compiler 1.1 HTML::Mason::Exception::Decline 1.1 HTML::Mason::Exception::Params 1.1 HTML::Mason::Exception::Syntax 1.1 HTML::Mason::Exception::System 1.1 HTML::Mason::Exception::TopLevelNotFound 1.1 HTML::Mason::Exception::VirtualMethod 1.1 HTML::Mason::Exceptions 1.43 HTML::Mason::PSGIHandler 0.52 HTML::Mason::PSGIHandler::Streamy 0.52 HTML::Mason::Request::PSGI 0.52 HTML::Parser 3.55 HTML::Scrubber 0.08 HTML::Tagset 3.10 HTML::TreeBuilder 3.23 HTTP::Body 1.15 HTTP::Body::MultiPart 1.15 HTTP::Body::OctetStream 1.15 HTTP::Body::UrlEncoded 1.15 HTTP::Body::XForms 1.15 HTTP::Body::XFormsMultipart 1.15 HTTP::Date 6.02 HTTP::Headers 6.00 HTTP::Message 6.03 HTTP::Request 6.00 HTTP::Response 6.03 HTTP::Status 6.03 I18N::LangTags 0.35 I18N::LangTags::Detect 1.03 integer 1.00 IO 1.25 IO::File 1.14 IO::Handle 1.28 IO::Seekable 1.1 IO::Select 1.17 IO::Socket 1.31 IO::Socket::INET 1.31 IO::Socket::UNIX 1.23 IPC::Open2 1.02 IPC::Open3 1.02 IPC::Run 0.80 JSON 2.17 JSON::PP 2.27200 JSON::PP::IncrParser 1.01 List::MoreUtils 0.22 List::Util 1.21 Locale::Maketext 1.09 Locale::Maketext::Fuzzy 0.10 Locale::Maketext::Lexicon 0.62 Locale::Maketext::Lexicon::Gettext 0.15 Log::Any 0.14 Log::Any::Adapter::Null 0.14 Log::Dispatch 2.29 Log::Dispatch::Base 2.29 Log::Dispatch::Output 2.29 Log::Dispatch::Screen 2.29 Log::Dispatch::Syslog 2.29 LWP 6.04 LWP::Protocol 6.00 LWP::UserAgent 6.04 Mail::Address 1.77 Mail::Field 1.77 Mail::Field::AddrList 1.77 Mail::Field::Date 1.77 Mail::Header 1.77 Mail::Internet 1.77 Mail::Mailer 1.77 Math::BigInt 1.997 Math::BigInt::Calc 1.997 MIME::Base64 3.07 MIME::Body 5.502 MIME::Decoder 5.502 MIME::Decoder::Binary 5.502 MIME::Decoder::NBit 5.502 MIME::Decoder::QuotedPrint 5.502 MIME::Ent
[rt-users] perlbrew/cpanm installation on centos 6
hi, In a test environment I have installed rt 4.0.6 with a local Perl (5.14.2) from perlbrew. Installing the dependencies with cpanm was a breeze, I must say, impressive. My problem is how to get this rt which starts perfectly from /opt/rt4/sbin/rt-server running with apache2 on centos6. If I install mod_perl, rt4 will not start because it tries to use the system Perl, and that will not work because of all the missing dependencies. If I try mod_fastcgi with the configuration on the web_deployment.pod I get errors (selinux is disabled): (13)Permission denied: FastCGI: failed to connect to server "/opt/rt4/sbin/rt-server.fcgi": Right now I got it working from a reverse proxy with mod_proxy starting the webserver on port 8000 with Starman. I get warnings: [Fri Jun 8 14:10:59 2012] [warning]: The actual HTTP_HOST (127.0.0.1) does NOT match the configured WebDomain (host.domain.tld). Perhaps you should Set($WebDomain, '127.0.0.1'); in RT_SiteConfig.pm, otherwise your internal links may be broken. (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:1098) The mod_proxy way looks promissing, but is it a correct way? Is anyone else running rt from a non system Perl and apache2 in rhel/centos? -- Groeten, natxo
Re: [rt-users] Disable REST API public access ?
Yeah, I thought about it this night ... A simple htaccess will do the trick. Thanks. Guillaume Hilt Le 07/06/2012 22:47, Kevin Falcone a écrit : On Thu, Jun 07, 2012 at 02:25:37PM +0200, Guillaume Hilt wrote: Using RT 3.8.7, I'd like to disable the rest api public access so noone external can use it. Is it possible ? Sounds like a trivial Apache Location Allow / Deny configuration. Deny access to the REST endpoint from outside a netblock. -kevin
[rt-users] Modify AutoOpen script
Hello, I want to modify the On Correspond Open Tickets acript not to change ticket status when it is set to my custom status "in progress" How can I do that? I've tried to edit /usr/share/request-tracker4/lib/RT/Action/AutoOpen.pm but faild. Any hints? -- Kamil Gmyrek New Vision
Re: [rt-users] TicketSQL Date parse weird..
> > > > > > Using either 'user' or 'server' as the timezone I get the same result > but I'm probably missing something here for the fixed-date (I can accept > that the date might be being modified elsewhere I'm yet to find), but the > 'tomrorow 10am' shouldn't be a full day off. So the adding of the > timezone offset before Time::ParsEdate::parsedate then removing it again > appears to be causing the issue here; pushing today past the end of the > day boundary. > > > > I can believe it's wrong. Time::ParseDate can do timezones, but > timezones support is very limited, so we do our timezones after > parsing in UTC. Understandably 'tomorrow 10am' in london while you're > somewhere else is completely different thing. > > We do some compensation in NOW argument and in theory it should work. > Are you on the latest version of the module? > > Never noticed before that ZONE argument can take whatever TZ > environment variable can take. May be attached patch will just work. > Have not tested it. Applies cleanly to 3.8 and 4.0. > > > I'll try this routine tomorrow morning (before 10am) to see if it shows > the right thing, then try to figure out a way to get it to return the same > result for the two RT::Date outputs. Ruslan, I’m using RT 3.8.8 at the moment. did some tests this morning (before the 10-hour's from UTC) and all the times aligned. With your patch, the worded time was off by TZ: # # BEFORE 10AM # # # Before patch # [bekar@psg-apps tmp]$ ./test.pl current time() output: 1339111474 fixed-date Time::ParseDate: 133920 tomorrow 10am Time::ParseDate: 133920 fixed-date RT::Date output: 133920 tomorrow 10am RT::Date output: 133920 timezone according to RT::Date: 36000 timezone according to RT::Date: 36000 # # After patch # [bekar@psg-apps tmp]$ ./test.pl current time() output: 1339111434 fixed-date Time::ParseDate: 133920 tomorrow 10am Time::ParseDate: 133920 fixed-date RT::Date output: 133920 tomorrow 10am RT::Date output: 1339236000 timezone according to RT::Date: 36000 timezone according to RT::Date: 36000 This was fine all the way until there was TZ seconds until the end of the day (after 14:00 for me). Results from that period: # # After 14:00 # # # Before Patch # [bekar@psg-apps tmp]$ ./test.pl current time() output: 1339128542 fixed-date Time::ParseDate: 133920 tomorrow 10am Time::ParseDate: 133920 fixed-date RT::Date output: 133920 tomorrow 10am RT::Date output: 1339286400 timezone according to RT::Date: 36000 timezone according to RT::Date: 36000 # # After Patch # [bekar@psg-apps tmp]$ ./test.pl current time() output: 1339128507 fixed-date Time::ParseDate: 133920 tomorrow 10am Time::ParseDate: 133920 fixed-date RT::Date output: 133920 tomorrow 10am RT::Date output: 1339236000 timezone according to RT::Date: 36000 timezone according to RT::Date: 36000 So the un-patched is definitely wrong. The patched is more consistent but sadly still wrong. Perhaps putting the removal of TZ back in to get the expected result more consistently: # # Additional line # [bekar@psg-apps tmp]$ ./test.pl current time() output: 1339139429 fixed-date Time::ParseDate: 133920 tomorrow 10am Time::ParseDate: 133920 fixed-date RT::Date output: 133920 tomorrow 10am RT::Date output: 133920 timezone according to RT::Date: 36000 timezone according to RT::Date: 36000 Coming up to a public holiday here so I won't be in a position to do any testing until Tue/Wed next week. I'll try it again before 10-am to see if I get a consistent result. Stuart alternate-date.patch Description: alternate-date.patch