[rt-users] Question about the RT Mail Loop detection
Good day, on a local RT 4.0.7 installation (Debian Stable Packages) we have intermittent problems of RT detecting Mails as bounces (in general plausible). Unfortunately (Thanks to Exchange ;-)) we are having a bit of a problem in tracking it down. RT sends a simple RT thinks this message may be a bounce with a simple text attachment with the mail content. It is indeed plausible, that it is a bounce, as it is a mail sent by RT during ticket creation, which immediately (1 minute later via cron) gets back to RT. My problem here is that I am having great difficulty to narrow down, what exactly is happening here. Is there a way to get RT to give me the details of the bounced mail instead of only the content. Especially I would be interested in the full E-Mail Headers of the mail that came in and was detected as bounce. That would give me the chance to look into the question where it actually came from. Any help would be greatly appreciated. Best regards Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de/ CANCOM GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Rudolf Hotter (Vorsitzender), Ralf Binder, Jacques Diaz, Frank Richter Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! RT Training in New York, October 8th and 9th: http://bestpractical.com/training
Re: [rt-users] RT intermittently fails to send mails after recent Debian Update
Hi there, the various questions in order: Did any perl modules get updated as part of the upgrade? from dpkg.log: 2012-07-27 15:11:55 upgrade libplack-perl 0.9980-1~bpo60+2 0.9986-1~bpo60+1 What version of Email::Address is installed? That would be 1.889 (using the Debian package 1.889-2). Please send your Apache config for RT. Directives exceeding Apache Standard: # RT Include file /etc/request-tracker4/apache-modperl2.conf PerlSetEnv RT_SITE_CONFIG /etc/request-tracker4/RT_SiteConfig.pm Location / SetHandler modperl PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /usr/share/request-tracker4/libexec/rt-server /Location Location /REST/1.0/NoAuth Order Allow,Deny Allow from 127.0.0.1 /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/usr/share/request-tracker4/libexec/rt-server); /Perl Header add X-UA-Compatible IE=edge # Some CGI Scripts accessing RT directly ScriptAlias /cgi-bin/ /usr/local/lib/cgi-bin-rt.cancom.de/ Directory /usr/local/lib/cgi-bin-rt.cancom.de AllowOverride None Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch Order allow,deny Allow from all /Directory Location /cgi-bin/ SetHandler perl-script PerlResponseHandler ModPerl::Registry /Location Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee!
Re: [rt-users] RT intermittently fails to send mails after recent Debian Update
Hi, I have made a few more experiments here: First, I tried to forward a failed message. It failed again, but differently. rt.log says: [Wed Aug 1 14:05:40 2012] [error]: : `/usr/sbin/sendmail -oi -t` exited with code 75 (/usr/share/request-tracker4/lib/RT/Interface/Email.pm:465) [Wed Aug 1 14:05:40 2012] [crit]: : Could not send mail with command `/usr/sbin/sendmail -oi -t`: : `/usr/sbin/sendmail -oi -t` exited with code 75 at /usr/share/request-tracker4/lib/RT/Interface/Email.pm line 466. Stack: [/usr/share/request-tracker4/lib/RT/Interface/Email.pm:466] [/usr/share/request-tracker4/lib/RT/Interface/Email.pm:767] [/usr/share/request-tracker4/lib/RT/Interface/Email.pm:626] [/usr/share/request-tracker4/html/Ticket/Forward.html:98] [/usr/share/request-tracker4/html/Ticket/autohandler:19] [/usr/share/request-tracker4/lib/RT/Interface/Web.pm:568] [/usr/share/request-tracker4/lib/RT/Interface/Web.pm:318] [/usr/share/request-tracker4/html/autohandler:53] (/usr/share/request-tracker4/lib/RT/Interface/Email.pm:470) [Wed Aug 1 14:05:40 2012] [debug]: Encode::Guess guessed encoding: ascii (/usr/share/request-tracker4/lib/RT/I18N.pm:474) [Wed Aug 1 14:05:40 2012] [debug]: Encode::Guess guessed encoding: ascii (/usr/share/request-tracker4/lib/RT/I18N.pm:474) [Wed Aug 1 14:05:40 2012] [debug]: Converting 'ascii' to 'utf-8' for text/plain - Subjectless message (/usr/share/request-tracker4/lib/RT/I18N.pm:240) Postfix says at the same time: Aug 1 16:05:40 jetws003 postfix/sendmail[1741]: fatal: www-data(33): internal protocol error However, this is not reproducible with other failed messages. I am starting to believe that I have two different errors here. What I can reproduce, is a mail triggered by an CGI script which fails all the time. The CGI Script looks like this: http://pastebin.com/qX0SCkW8 When called with testdata, it creates the ticket, returns OK but the mail doesn't get sent, again with the No Recipient error message of Postfix. According to the logs, the mail did have an receiver: [Wed Aug 1 14:11:12 2012] [debug]: Subject: [Leasing #53426] Automatische Antwort: ccd' - test - test - test From: Leasing Hotline via RT l.h@domain Reply-To: l.h@domain In-Reply-To: References: RT-Ticket-53426@CANCOM Message-ID: rt-4.0.5-1953-1343830271-576.53426-3-0@domain Precedence: bulk X-RT-Loop-Prevention: CANCOM Tickets RT-Ticket: CANCOM Tickets #53426 Managed-by: RT 4.0.5 (http://www.bestpractical.com/rt/) Auto-Submitted: auto-replied To: t.n@domain MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 X-RT-Original-Encoding: utf-8 (/usr/share/request-tracker4/lib/RT/Action/SendEmail.pm:667) [Wed Aug 1 14:11:12 2012] [debug]: Removing deferred recipients from Bcc: line (/usr/share/request-tracker4/lib/RT/Action/SendEmail.pm:690) [Wed Aug 1 14:11:12 2012] [debug]: Setting deferred recipients for attribute creation (/usr/share/request-tracker4/lib/RT/Action/SendEmail.pm:699) [Wed Aug 1 14:11:12 2012] [debug]: No recipients found for deferred delivery on transaction #966607 (/usr/share/request-tracker4/lib/RT/Action/SendEmail.pm:712) [Wed Aug 1 14:11:12 2012] [info]: rt-4.0.5-1953-1343830271-576.53426-3-0@CANCOM #53426/966607 - Scrip 3 Auto-Reply beim Erstellen an Klient (/usr/share/request-tracker4/lib/RT/Action/SendEmail.pm:301) [Wed Aug 1 14:11:12 2012] [error]: rt-4.0.5-1953-1343830271-576.53426-3-0@CANCOM: `/usr/sbin/sendmail -oi -t` exited with code 75 (/usr/share/request-tracker4/lib/RT/Interface/Email.pm:465) [Wed Aug 1 14:11:12 2012] [crit]: rt-4.0.5-1953-1343830271-576.53426-3-0@CANCOM: Could not send mail with command `/usr/sbin/sendmail -oi -t`: rt-4.0.5-1953-1343830271-576.53426-3-0@CANCOM: `/usr/sbin/sendmail -oi -t` exited with code 75 at /usr/shar [Wed Aug 1 14:11:12 2012] [warning]: No EmailInputEncodings set, fallback to iso-8859-1 (/usr/share/request-tracker4/lib/RT/I18N.pm:431) [Wed Aug 1 14:11:12 2012] [warning]: No EmailInputEncodings set, fallback to iso-8859-1 (/usr/share/request-tracker4/lib/RT/I18N.pm:431) However, forwarding that message to me does work. Please note, that both RTs configuration and the code of that CGI script has been unchanged for weeks (perhaps even months) now and it did work last week before the update. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee!
[rt-users] RT intermittently fails to send mails after recent Debian Update
-tracker4/lib/RT/Action/SendEmail.pm:712) [Tue Jul 31 08:47:07 2012] [info]: rt-4.0.5-31511-1343724427-334.53293-4-0@CANCOM #53293/964235 - Scrip 4 AdminCC beim Erstellen benachrichtigen (/usr/share/request-tracker4/lib/RT/Action/SendEmail.pm:301) [Tue Jul 31 08:47:07 2012] [error]: rt-4.0.5-31511-1343724427-334.53293-4-0@CANCOM: `/usr/sbin/sendmail -oi -t` exited with code 75 (/usr/share/request-tracker4/lib/RT/Interface/Email.pm:465) [Tue Jul 31 08:47:07 2012] [crit]: rt-4.0.5-31511-1343724427-334.53293-4-0@CANCOM: Could not send mail with command `/usr/sbin/sendmail -oi -t`: rt-4.0.5-31511-1343724427-334.53293-4-0@CANCOM: `/usr/sbin/sendmail -oi -t` exited with code 75 at /usr/share/request-tracker4/lib/RT/Interface/Email.pm line 466. (/usr/share/request-tracker4/lib/RT/Interface/Email.pm:470) [Tue Jul 31 08:47:07 2012] [warning]: No EmailInputEncodings set, fallback to iso-8859-1 (/usr/share/request-tracker4/lib/RT/I18N.pm:431) [Tue Jul 31 08:47:07 2012] [warning]: No EmailInputEncodings set, fallback to iso-8859-1 (/usr/share/request-tracker4/lib/RT/I18N.pm:431) [Tue Jul 31 08:47:07 2012] [debug]: Converting 'iso-8859-1' to 'utf-8' for text/plain - Subjectless message (/usr/share/request-tracker4/lib/RT/I18N.pm:240) I'd appreciate any help to get to the bottom of this. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de/ CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee!
Re: [rt-users] Lifecycles: Prevent automatic transition to open between active states
Good morning, thanks for the quick answer. Actually, deactivating this Scrip entirely is not what I want. What I'd like ist that any correspondence (re?)opens a ticket if it is in an inactive state (like stalled). If, on the other hand, the ticket is in any active state (perhaps except new if this is possible) it should retain its state. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! -Ursprüngliche Nachricht- Von: Christian Loos [mailto:cl...@netcologne.de] Gesendet: Freitag, 10. Februar 2012 12:00 An: Nehmer Torben Cc: rt-users@lists.bestpractical.com Betreff: Re: Lifecycles: Prevent automatic transition to open between active states Hi Torben, by default there is an global scrip called Open Tickets which set the status to open on correspondence. If you deactivate this scrip the ticket should keep it's status. -Chris Am 10.02.2012 10:32, schrieb Nehmer Torben: Good day, I have a question regarding custom lifecycles. First of all, the full lifecycle configuration can be seen here on Pastebin in case you need more information than what I have shown here. http://pastebin.com/6SBPwVbB I have set a number of active states in the ticket: initial = [ 'new' ], active = [ 'open', 'inprogress', 'fixed', 'deployed' ], inactive= [ 'resolved', 'rejected', 'deleted' ], You can change states without much restriction, effectively: transitions = { '' = [qw(new open resolved)], new= [qw(open inprogress fixed deployed resolved rejected deleted)], open = [qw(new inprogress fixed deployed resolved rejected deleted)], inprogress = [qw(new open fixed deployed resolved rejected deleted)], fixed = [qw(new open inprogress deployed resolved rejected deleted)], deployed = [qw(new open inprogress fixed resolved rejected deleted)], resolved = [qw(new open inprogress fixed deployed rejected deleted)], rejected = [qw(new open inprogress fixed deployed resolved deleted)], deleted= [qw(new open inprogress fixed deployed rejected resolved)], }, So, now if I have a ticket in the inprogress state and generate a Response using the web interface. I leave the Status field at the default (inprogress (unchanged)). RT then changes the status of the ticket back to open. How can I prevent this - in other words: Where is the bug in my configuration? Best regards, Torben Nehmer RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
[rt-users] Lifecycles: Prevent automatic transition to open between active states
Good day, I have a question regarding custom lifecycles. First of all, the full lifecycle configuration can be seen here on Pastebin in case you need more information than what I have shown here. http://pastebin.com/6SBPwVbB I have set a number of active states in the ticket: initial = [ 'new' ], active = [ 'open', 'inprogress', 'fixed', 'deployed' ], inactive= [ 'resolved', 'rejected', 'deleted' ], You can change states without much restriction, effectively: transitions = { '' = [qw(new open resolved)], new= [qw(open inprogress fixed deployed resolved rejected deleted)], open = [qw(new inprogress fixed deployed resolved rejected deleted)], inprogress = [qw(new open fixed deployed resolved rejected deleted)], fixed = [qw(new open inprogress deployed resolved rejected deleted)], deployed = [qw(new open inprogress fixed resolved rejected deleted)], resolved = [qw(new open inprogress fixed deployed rejected deleted)], rejected = [qw(new open inprogress fixed deployed resolved deleted)], deleted= [qw(new open inprogress fixed deployed rejected resolved)], }, So, now if I have a ticket in the inprogress state and generate a Response using the web interface. I leave the Status field at the default (inprogress (unchanged)). RT then changes the status of the ticket back to open. How can I prevent this - in other words: Where is the bug in my configuration? Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de/ CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 6, 2012
Re: [rt-users] CLI Scripting Question
Hi, It wouldn't work. Most times it's easier to use $tickets-FromSQL(Queue = 'x' AND (Status ...)) instead of Limit* calls. LIKE adding % around arguments is historical thing. Use MATCHES. Using OPERATOR = 'MATCHES' produces an error: [Wed Nov 30 08:15:28 2011] [error]: RestrictionsToClauses: Invalid operator MATCHES for Subject (STRING) at /usr/share/request-tracker4/lib/RT/Tickets.pm line 3363. (/usr/share/request-tracker4/lib/RT/Tickets.pm:3416) MATCHES in FromSQL does effectively break the entire query, LIKE in FromSQL has the same bahvoir as LimitSubject. Besides, I find it much more error prone to build SQL queries by hand. So I am still where I started. It can't be that hard to do a query the subject for a string on the beginning without patching the Perl SearchBuilder modules itself, can it? Best regards, Torben RT Training Sessions (http://bestpractical.com/services/training.html) * Boston TBA
[rt-users] CLI Scripting Question
Good morning, I am currently writing a few scripts for internal usage to faciliate some Scrum like pattern within RT. One script does create timeLeft Sums on all tickets of a given sprint (which is a parent ticket). While all and all this works great, I have a little question regarding RT::Ticket: The main loop of the script should look for all tickets starting with the text Sprint, doing about this: my $tickets = RT::Tickets-new(RT-SystemUser); $tickets-LimitQueue( VALUE = $queueName ); $tickets-LimitStatus( VALUE = 'new' ); $tickets-LimitStatus( VALUE = 'open' ); $tickets-LimitSubject( VALUE = Sprint %, OPERATOR = 'LIKE' ); $tickets-OrderBy( FIELD = 'Id', ORDER = 'ASC' ); Unfortunalety, the LIKE operation seems to enclose the search pattern into wildcards as well, thus finding all tickets which contain the string Sprint anywhere in the ticket, not just in the subject. The operator STARTSWITH is not accepted, although specifying STARTSWITH in an extended query in RT does yield the expected result. Any hints how I can solve this? Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de/ CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! RT Training Sessions (http://bestpractical.com/services/training.html) * Boston TBA
Re: [rt-users] Lifecycle Question
Hi there, thanks for the hints, worked like a breeze. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Kevin Falcone Gesendet: Donnerstag, 3. November 2011 18:27 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Lifecycle Question On Thu, Nov 03, 2011 at 04:53:40PM +0100, Nehmer Torben wrote: Is it possible to adjust the default lifecycle without having to overwrite it completely? What I simply want to have are a few changed actions (basically we want responses on Resolve, not Comments). Now I don't want to overwrite the entire Lifecycle to keep things simple. Is this possible? You can copy just default = { } and leave approvals in RT_Config.pm, but you do need to copy all of default in order to modify it. You can also add a new lifecycle without copying default from RT_Config.pm into RT_SiteConfig.pm To summarize, there's a very simple merge algorithm, but it only happens at the top level. -kevin RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
Hi Kevin, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Were you actually using gpg, or did you just have the perl modules installed and that was enough to cause segfaults? I have installed RT out of the box using Debian Packages which as far as I can see pulls all necessary dependencies into the system. RTs GPG configuration was on the defaults in RT_Config.pm, no changes are made by the deb. Once I disabled GPG as outlined in the docs (Enable = undef), the problem disappeared. Best regards, Torben Nehmer RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
[rt-users] Lifecycle Question
Hi there, I have a question about lifecycles (which are the next best thing to sliced bread in my opinion): Is it possible to adjust the default lifecycle without having to overwrite it completely? What I simply want to have are a few changed actions (basically we want responses on Resolve, not Comments). Now I don't want to overwrite the entire Lifecycle to keep things simple. Is this possible? Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de/ CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
Hi Dominic, agreed, it sounds very much like what I experience here. Schöne Grüße, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Dominic Hargreaves Gesendet: Donnerstag, 3. November 2011 16:46 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] RT4 - mod_perl problem with apache2 On Thu, Nov 03, 2011 at 10:55:45AM -0400, Kevin Falcone wrote: On Thu, Nov 03, 2011 at 09:47:38AM +0100, Nehmer Torben wrote: we had the same problem here, disabling the GPG Stuff made the segfaults go away. Were you actually using gpg, or did you just have the perl modules installed and that was enough to cause segfaults? I have installed RT out of the box using Debian Packages which as far as I can see pulls all necessary dependencies into the system. RTs GPG configuration was on the defaults in RT_Config.pm, no changes are made by the deb. Once I disabled GPG as outlined in the docs (Enable = undef), the problem disappeared. So, is this a problem with the Debian packages, or do folks have source installs of 4.0.2 on Debian that are having segfaults? Haven't delved through this thread in detail yet, but this sounds quite similar to http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=632129. If anyone has anything to add to that bug report, that'd be helpful. Cheers, Dominic. -- Dominic Hargreaves, Systems Development and Support Team Computing Services, University of Oxford RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] RT4 - mod_perl problem with apache2
Good morning, we had the same problem here, disabling the GPG Stuff made the segfaults go away. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Carlos Ramos Gesendet: Montag, 31. Oktober 2011 05:25 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] RT4 - mod_perl problem with apache2 On Tue, May 31, 2011 at 9:00 AM, Kevin Falcone falc...@bestpractical.com wrote: On Mon, May 30, 2011 at 12:09:11PM +0200, Robert Wysocki wrote: Hi guys, I've googled it, some people also have this problem, but no solutions were provided by anyone. The problem is: testrt:/opt/rt4/etc# apache2ctl restart /usr/sbin/apache2ctl: line 107: 11712 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t 2 /dev/null Syntax OK /usr/sbin/apache2ctl: line 107: 11715 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t Action 'restart' failed. The Apache error log may have more information. testrt:/opt/rt4/etc# /etc/init.d/apache2 reload Syntax OK /usr/sbin/apache2ctl: line 107: 11729 Segmentation fault $HTTPD ${APACHE_ARGUMENTS} -t Action 'configtest' failed. The Apache error log may have more information. failed! The way of restarting apache which doesn't cause error to be thrown is just: /etc/init.d/apache2 stop; /etc/init.d/apache2 start but it's, well, inelegant. The issue is probably related to Plack. Unfortunately, it's difficult to try replicating without a perl/apache/mod_perl2/plack version list -kevin Hello, I'm having a VERY similar problem here. Using rt-4.0.2 and debian squeeze 6.0.3, which comes with apache 2.2.16-6+squeeze4, mod_perl 2.0.4-7, perl 5.10.1-17squeeze2 and from what i can tell Plack 0.9984 which i just installed from CPAN. This is my rt config in apache: Location /rt Order allow,deny Allow from all SetHandler perl-script PerlResponseHandler Plack::Handler::Apache2 PerlSetVar psgi_app /opt/rt4/sbin/rt-server /Location Perl use Plack::Handler::Apache2; Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server); /Perl If I don't comment this Plack::Handler::Apache2-preload(/opt/rt4/sbin/rt-server);, I can't do the following without getting a segmentation fault, even if apache is not running: root@blazar:~# export APACHE_RUN_USER=www-data root@blazar:~# export APACHE_RUN_GROUP=www-data root@blazar:~# export APACHE_PID_FILE=/var/run/apache2.pid root@blazar:~# export APACHE_RUN_DIR=/var/run/apache2 root@blazar:~# export APACHE_LOCK_DIR=/var/lock/apache2 root@blazar:~# export APACHE_LOG_DIR=/var/log/apache2 root@blazar:~# root@blazar:~# root@blazar:~# apache2 -t Syntax OK Segmentation fault That last sequence of commands is something that apache2ctl do almost every time you run it, and at least in Debian apache2ctl is used in a lot of places, from startup to shutdown to log rotation. RT4 works correctly from what i can tell as long as i don't comment the preload line, but then again apache2ctl breaks down and with it, other things follow. The only error i can see in my syslog every time i run 'apache -t' is the following: Oct 30 21:44:22 blazar kernel: [4016030.401140] apache2[17570]: segfault at 7fa814baa640 ip 7fa814baa640 sp 7d346fc8 error 14 in libnss_files-2.11.2.so[7fa817aaf000+b000] As a side note, I do have a working RT4 installation in debian squeeze, but this was installed some time ago and it was the rt-4.0.0 tarball and I guess some of the CPAN modules are older too. Any help would be really appreciated. Thanks a lot. RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011 RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 29, 2011
Re: [rt-users] New install of RT4 crashes Internet Explorer 8
Hello together, I too just ran into the problem described in this thread. Complex layouts tend to lock up Internet Explorer for quite some time, however, I have not tried to trace it down to a specific UI element. As with Christopher, disabling the behavoir line in msie-pie.css hides the problem without affecting functionality so far as I can see it. It does look blockier, as some effects are not applied. Have you any plan how to handle this problem? Of course, I can keep the line in question commented out, but this makes upgrading a pain. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Christopher Lasater Gesendet: Freitag, 8. Juli 2011 16:02 An: Christopher Lasater; rt-users@lists.bestpractical.com Betreff: Re: [rt-users] New install of RT4 crashes Internet Explorer 8 Also, if you check out the known issues page (http://css3pie.com/documentation/known-issues/ ) there is a comment about CSS not working properly in the Body element. I removed div#Body from the msie-pie.css file and it seems to work, unfortunately I have no clue what this impacts. It seems to go slower and when you zoom in a bit it chops off some words in drop down boxes. I just went back to commenting out the whole line instead. -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Christopher Lasater Sent: Friday, July 08, 2011 9:38 AM To: Henry Angeles; rt-users@lists.bestpractical.com Subject: Re: [rt-users] New install of RT4 crashes Internet Explorer 8 I never really used IE much, more of a Firefox person, but it looks good. I think a couple things might be blockier, but much better then maxing out a CPU and locking up. I believe the PIE file only affects IE so Firefox users should not be impacted. -Original Message- From: Henry Angeles [mailto:hange...@barenecessities.com] Sent: Friday, July 08, 2011 9:02 AM To: Christopher Lasater; rt-users@lists.bestpractical.com Subject: RE: [rt-users] New install of RT4 crashes Internet Explorer 8 Chris, Did the 'fix' have any detrimental effects ? -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Christopher Lasater Sent: Thursday, July 07, 2011 5:40 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] New install of RT4 crashes Internet Explorer 8 I believe me and a coworker have found the problem, if we comment out the line in the following file the problem goes away. I assume it has to do with the PIE.htc which is at version 1.0beta2 current version is beta4, which I tried and did not help :/ /*behavior: url(/NoAuth/css/images/PIE.htc); */ http://server.net/NoAuth/css/aileron/msie-pie.css The following site does mention an issue with things not being loaded correctly outside of 100% zoom, but it does not mention CPU going to 100%. http://css3pie.com/documentation/known-issues/ -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Tuesday, July 05, 2011 1:33 PM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] New install of RT4 crashes Internet Explorer 8 On Tue, Jul 05, 2011 at 12:56:16PM -0400, Christopher Lasater wrote: Unfortunately I experience the problem with my local RT4.0.1 but not the issues.bestpractical.com. So its more than just what version of IE you have. When changing the zoom level I can even get it to lock up before logging in. Do you have any config changes on the apache side for issues.bestpractical.com? mod_perl or fastcgi? We're running a very vanilla mod_fastcgi setup, based on the documentation we ship with RT. IE Version 8.0.7600.16385 both 32 and 64bit version Windows 7 x64 I'm on an older IE8 release, but with WinXP for my IE8 machine. Unfortunately, my Win7 machines are already running IE9 for testing. -kevin -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kevin Falcone Sent: Tuesday, July 05, 2011 9:24 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] New install
Re: [rt-users] Users Handbook
Hi Ken, Same here too, it would be greate if I could have a copy too. Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Paul O'Rorke Gesendet: Mittwoch, 20. April 2011 06:06 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Users Handbook Hi Ken, I'd love both the User and Admin if that's a possibility? Paul On 11-04-19 07:27 PM, Rocel M. Lacida wrote: Hello Ken, Good Day! Can I have a copy also. I really need to know more about RT. Thanks in Advance Rocel On 4/20/2011 6:29 AM, Kenneth Crocker wrote: 20/20, Sure. Kenn Crocker On Tue, Apr 19, 2011 at 2:47 PM, 20/20 Lab l...@pacbell.netmailto:l...@pacbell.net wrote: Hate to feel like I'm jumping on a bandwagon; but I would appreciate a copy as well. -Matt On 04/19/2011 2:39 PM, Kenneth Crocker wrote: Asif, Sure. Kenn On Tue, Apr 19, 2011 at 2:21 PM, Asif Iqbal vad...@gmail.commailto:vad...@gmail.com wrote: I like to get a copy to if that is possible. On Tue, Apr 19, 2011 at 5:09 PM, Kenneth Crocker kfcroc...@lbl.govmailto:kfcroc...@lbl.gov wrote: Jason, Miachael, Yan, Kevin, Raed, Tyler Drew, I will certainly mail each of you a copy of both the User's Guide as well as the Queue Admin Guide. You must keep in mind that this documentation is tailored towards the way we do things here at LBNL. We have over 100 Queues that are used to support Application Projects/Systems/Support. In most cases, we have a WorkFlow process that includes Review Approval of requests before being moved to the support Queue as well as QA procedures that allow for separate approval of QA test results (by another team or the requestors, etc) before migration to production Resolution. That means I the documentation will be referring to Ticket Status values we added, Custom Fields Scrips created for these processes. As long as you guys plan to rip out what you don't need, it can be useful as a baseline of instruction on understanding terminology, privileges, notification scrips, searching reporting (including dashboards), and on. I hope it will be useful for you. I'll be sending them out in a couple of hours. Kenn LBNL On Tue, Apr 19, 2011 at 1:40 PM, Jason Ledford jledf...@biltmore.commailto:jledf...@biltmore.com wrote: Can I get a copy? From: rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker Sent: Tuesday, April 19, 2011 3:15 PM To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com Subject: Re: [rt-users] Users Handbook Raed Kevin, I'll have to send these to your individual email address as the User's list will stop it cause the attachments are so large. Kenn LBNL On Tue, Apr 19, 2011 at 9:48 AM, Kenneth Crocker kfcroc...@lbl.govmailto:kfcroc...@lbl.gov wrote: Raed, Absolutely! Right now I'm prepping it to remove any company info that shouldn't go out. Both Guides should be ready by EOD. BTW, the guides are based on 3.8.7, including screen shots, etc. Kenn LBNL On Tue, Apr 19, 2011 at 9:33 AM, Raed El-Hames raed.el-ha...@daisygroupplc.commailto:raed.el-ha...@daisygroupplc.com wrote: Hello Kenn: Ist possible you can share your Users Guide , I've been planning to make one for my users in here for a while, but other work keep cropping up, and any help starting this will be useful. Regards; Roy From: rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker Sent: 19 April 2011 00:12 To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com Subject: Re: [rt-users] Users Handbook Yan, I developed some guides for our user's. It has a Glossary of terms and references tp Privileges (the Admin guide). However, it refers to workflow functions and scrip that we developed that might not be in sync with what you do. This is what the TOC for the User's Guide looks like: 1: Introduction. - 1 - 2: Administration. - 5 - 3: Logging In. - 7 - 4: Home Page. - 8 - 5: Tickets
[rt-users] Mandatory Custom Fields
Good morning, I have a question about custom fields: In one of our queues we have a CF which has to be filled out by the people maintaining the queue (not the ones submitting the ticket). The CF is of type Select one value. What we'd like to have is the ability to enforce the users maintaining the queue to fill out the value ideally when opening the ticket, at the latest when closing it. We have tried setting the CF validation to Mandatory (?#Mandatory)., but it did not work as expected. Especially, you can still resolve the ticket when writing an answer to the ticket leaving the CF empty. Ideally, RT should reject any status change to an inactive status whatsoever as long as the CF is empty. What would be the best way to do this? Mit freundlichen Grüßen, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Customization / Callback Question for Ticket/Elements/Tabs.
Good morning, I am currently trying to customize RTs Action Listing in the top of the Ticket Display (Comment, Correspond, Forward, Resolve). I am using callbacks, but they do not invoke as expected. As a basic idea I have been using the example of Dirk Pape, specifically http://page.mi.fu-berlin.de/dirkpape/rt3/Callbacks/MI/Ticket/Elements/Tabs/Default The code I am actually using looks like this: %INIT if ($Ticket) { # overwrite the default Action for Resolve to Correspond if ( $Ticket-CurrentUserHasRight('ModifyTicket') ( $Ticket-Status ne 'resolved' ) ) { $actions-{'G'}-{'path'} = Ticket/Update.html?Action=RespondDefaultStatus=resolvedid=.$Ticket-id; } # Set To Test if ( $Ticket-CurrentUserHasRight('ModifyTicket') ( $Ticket-Status ne 'test' ) ) { $actions-{'T'} = { title = 'Test', path = Ticket/Update.html?Action=RespondDefaultStatus=testid= . $Ticket-id }; } # Add as Watcher if ( $Ticket-CurrentUserHasRight('Watch') ) { $actions-{'W'} = { title = loc('Watch'), path = 'Ticket/ModifyPeople.html?Ticket-AddWatcher-Principal-' . $Ticket-CurrentUser-id . '=Ccid='.$Ticket-id }; } } # $actions-{'ZZ2'} = { title = 'test2', path = 'test2' }; /%INIT %ARGS $Ticket = undef $actions = undef /%ARGS The callback actually gets called, if I uncomment the ZZ2 entry, it gets shown as expected. Unfortunately, the $Ticket object is undefined and thus breaks the entire idea. I am using RT 3.8.8 installed from Debian packages, the callback has been placed into /usr/local/share/request-tracker3.8/html/Callbacks/Ticket/Elements/Tabs/Default. I would appreciate any hints, why this does not work. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Martin Mayr, Tobias Hörmann Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Recommendation / Feature Request for Table Layouts
Hi, I would very much appreciate a way of avoiding line breaks in certain Columns in a RT Search result. Specifically columns like Created Relative often break like 17 hours ago ... or in German ... vor 17 Stunden This looks like this: http://www.nehmer.net/~torben/rt-users/2010-07-01-09.00.44.png I have tried adding a nowrap option in the search definition, but RT strips it out. The thing here is, that a nowrap here would often actually save space. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Searching with no case sensitivity?
Good morning, Is there an easy way to turn off case sensitivity for the search feature in RT 3.8.x? I am using MySql as the database and tried a few suggestions I found by googling the problem but none of them work. I'm pretty sure it's just a matter of the collation setting for your database. Would you mind giving me some additional pointers, I'm having the same trouble with a Postgres Database and I am no Postgres Expert. Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Bug: File Upload with Postgres and Special Characters in Filename
', 'HASH(0x51fcb78)', 'Actions', 'ARRAY(0x520ac88)', 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)') called at /usr/local/share/request-tracker3.8/html/Ticket/Display.html line 145 HTML::Mason::Commands::__ANON__('TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5212f48)', 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', ...) called at /usr/share/request-tracker3.8/html/Ticket/Update.html line 261 HTML::Mason::Commands::__ANON__('UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', 'UpdateBcc', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5054f68)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1302 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', ...) called at /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 320 RT::Interface::Web::ShowRequestedPage('HASH(0x4f3a358)') called at /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 224 RT::Interface::Web::HandleRequest('HASH(0x4f3a358)') called at /usr/share/request-tracker3.8/html/autohandler line 53 HTML::Mason::Commands::__ANON__('UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', 'UpdateBcc', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x4f3a7f0)', 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 1297 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292 HTML::Mason::Request::comp(undef, undef, undef, 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 481 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 481 eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 433 HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x575a4d0)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165 HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x575a4d0)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x4cc17f8)', 'Apache2::RequestRec=SCALAR(0x5772ad8)') called at /usr/share/request-tracker3.8/libexec/webmux.pl line 166 eval {...} called at /usr/share/request-tracker3.8/libexec/webmux.pl line 166 RT::Mason::handler('Apache2::RequestRec=SCALAR(0x5772ad8)') called at -e line 0 eval {...} called at -e line 0 (/usr/share/perl/5.10/Carp.pm:47) [Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed: FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369 HINT: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche durch »client_encoding« bestimmt wird. (/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm:191) [Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed: FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369 HINT: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche durch »client_encoding« bestimmt wird. (/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm:164) Mit freundlichen Grüßen, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt
Re: [rt-users] Bug: Special Characters in Ticket Subject
Hello Kevin, we are running RT 3.8.7 (from Debian Packages) together with PostgreSQL 8.4.1 in a German environment. There are some patches in 3.8-trunk (the merge of the another_utf8_rework branch) that should resolve this issue. Thanks for the quick answer. Out of curiosity, when can we expect the next 3.8 release which would then include this fix (I presume)? Best regards, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! -Ursprüngliche Nachricht- Von: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von Kevin Falcone Gesendet: Donnerstag, 28. Januar 2010 18:25 An: rt-users@lists.bestpractical.com Betreff: Re: [rt-users] Bug: Special Characters in Ticket Subject On Thu, Jan 28, 2010 at 11:55:40AM +0100, Nehmer Torben wrote: -kevin ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com 2010 RT Training Sessions! San Francisco, CA, USA - Feb 22 23 Dublin, Ireland - Mar 15 16 Boston, MA, USA - April 5 6 Washington DC, USA - Oct 25 26 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Bug: Special Characters in Ticket Subject
Hello, we are running RT 3.8.7 (from Debian Packages) together with PostgreSQL 8.4.1 in a German environment. Unfortunalety, we cannot create tickets from the Web Interface (both Quick Create an Full Create) when the subject contains one of our German Special Characters like ö and the Content is emtpy: [cid:image001.png@01CAA00F.F00EB610] As soon as I add something into the content area, things work as expected. The same behavior can be observed in the regular Ticket screen. The RT Log shows this, the text in curly Brackets {} are the translations of the error messages from Postgres into English. Note, that the F6 Character code ö in ISO-8859-1 and consorts, which is the single-byte encoding in use here when Unicode is not used. [Thu Jan 28 10:49:24 2010] [warning]: DBD::Pg::st execute failed: FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xf6f6f60a {ERROR: Invalid Byte-Sequence for Encoding UTF-8} HINT: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet, welche durch »client_encoding« bestimmt wird. at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:509) {This error can also occur if the Byte-Sequence does not match with the encoding expected by the server, set through client_encoding} [Thu Jan 28 10:49:24 2010] [warning]: RT::Handle=HASH(0x4cc00e8) couldn't execute the query 'INSERT INTO Attachments (ContentType, Parent, Subject, Headers, Creator, MessageId, Created, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x4cc00e8)', 'INSERT INTO Attachments (ContentType, Parent, Subject, Header...', 'text/plain', 0, 'Test F6F6F6', 'MIME-Version: 1.0\x{a}X-Mailer: MIME-tools 5.427 (Entity 5.427)\x{a}S...', 22, '', '2010-01-28 10:49:24', ...) called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 357 DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x4cc00e8)', 'Attachments', 'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test F6F6F6', 'Headers', ...) called at /usr/share/perl5/DBIx/SearchBuilder/Handle/Pg.pm line 66 DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0x4cc00e8)', 'Attachments', 'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test F6F6F6', 'Headers', ...) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 1293 DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x2c16a10)', 'ContentType', 'text/plain', 'Parent', 0, 'Subject', 'Test F6F6F6', 'Headers', 'MIME-Version: 1.0\x{a}X-Mailer: MIME-tools 5.427 (Entity 5.427)\x{a}S...', ...) called at /usr/share/request-tracker3.8/lib/RT/Record.pm line 289 RT::Record::Create('RT::Attachment=HASH(0x2c16a10)', 'TransactionId', 188101, 'Parent', 0, 'ContentType', 'text/plain', 'Headers', 'MIME-Version: 1.0\x{a}X-Mailer: MIME-tools 5.427 (Entity 5.427)\x{a}S...', ...) called at /usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 143 RT::Attachment::Create('RT::Attachment=HASH(0x2c16a10)', 'TransactionId', 188101, 'Attachment', 'MIME::Entity=HASH(0x592b468)') called at /usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 514 RT::Transaction::_Attach('RT::Transaction=HASH(0x2c10e30)', 'MIME::Entity=HASH(0x592b468)') called at /usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 154 RT::Transaction::Create('RT::Transaction=HASH(0x2c10e30)', 'ObjectId', 10150, 'ObjectType', 'RT::Ticket', 'TimeTaken', '', 'Type', 'Create', ...) called at /usr/share/request-tracker3.8/lib/RT/Record.pm line 1457 RT::Record::_NewTransaction('RT::Ticket=HASH(0x5929540)', 'Type', 'Create', 'TimeTaken', '', 'MIMEObj', 'MIME::Entity=HASH(0x592b468)', 'CommitScrips', 1, ...) called at /usr/share/request-tracker3.8/lib/RT/Ticket_Overlay.pm line 656 RT::Ticket::Create('RT::Ticket=HASH(0x5929540)', 'TimeEstimated', '', 'Status', 'new', 'Queue', 'RequestTracker', 'AdminCc', '', ...) called at /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 982 HTML::Mason::Commands::CreateTicket('Attachments', undef, 'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue', ...) called at /usr/local/share/request-tracker3.8/html/Ticket/Display.html line 117 If you need any more information, please let me know. Thanks in advance, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und
[rt-users] Migrating from RT MySQL to PostgreSQL
Hello together, has anybody ever migrated RT from MySQL to PostgreSQL? Are there any scripts available to accomplish this? Greetings, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.demailto:torben.neh...@cancom.de www.cancom.dehttp://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Autocreated / LDAP user merge (same problem here)
Hello together, What's the cleanest way to get this to work? Users here have gotten a lot of new stuff to deal with lately, and more systems to log in to. I *really* want them just to be able to use their AD login info for RT, whether or not they've mailed in a request before. I have the same problem, which is quite annoying. Is there any solution on the horizon or - at least - some hints on how and where to patch this in? Anyone? Yours sincerely, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de mailto:torben.neh...@cancom.de www.cancom.de http://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Questions about 3.8.1 MakeClicky (doesn't work here)
Hello together, I am currently trying to get MakeClicky running but with no success. Originally, I planned to use a callback to allow for some linking (SVN Revisions and such). To start with, I used the example Callback along with the standard HTTPURL tool: /opt/rt3/etc/RT_SiteConfig.pm: Set(@Active_MakeClicky, qw('httpurl', 'ticket_link') ); /opt/rt3/local/html/Callbacks/Elements/MakeClicky/Default %ARGS $types = [] $actions = {} /%ARGS %INIT my $web_path = RT-Config-Get('WebPath'); # Action takes TicketId as Argument and returns Ticket Link: $a ctions-{'link_ticket'} = sub { my %args = @_; my $id = $args{'all_matches'}[1]; return qq{a href=$web_path/Ticket/Display.html?id=$id$args{value}/a}; }; # add the Action to the list push @$types, { name = 'ticket_link', regex = qr{#(\d+)}i, action = 'link_ticket' }; Now I have created a ticket with the following text: http://www.nehmer.net/ https://www.nehmer.net #1234 Apache 2 (using mod_perl) has been restarted. Unfortunalety, when looking at the ticket in question, there is no link whatsoever. By the way: Does the callback has to be named Default or can I make multiple freely named files (e.g. ticket_link and subversion_link) in the same location? Also, can I introduce configuration options in some way for my callback, for example a subversion repository base URL to be used in the linking? Thanks in advance for any help! Yours sincerely, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 torben.neh...@cancom.de mailto:torben.neh...@cancom.de www.cancom.de http://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.0 -- IE7 / WYSIWYG editordata corruption issues?
Hello together, I am encountering the Data Corruption mentioned below here with 3.8.1 and IE 7. I have followed UPGRADING.mysql precicly. The installation I am using has been upgraded from 3.8.0. Mit freundlichen Grüßen, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.cancom.de http://www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Carlos A. Alvarez Gesendet: Donnerstag, 11. September 2008 23:45 An: [EMAIL PROTECTED] Cc: Thomas Sibley; rt-users@lists.bestpractical.com; Roedel, Mark Betreff: Re: [rt-users] RT 3.8.0 -- IE7 / WYSIWYG editordata corruption issues? I had the same issue with 3.8.0, this fixed on 3.8.1. Make sure you follow the UPGRADING.mysql instructions. Adam Engel wrote: On 7/17/2008 5:36 PM, Thomas Sibley wrote: Roedel, Mark wrote: Is anybody else seeing messages get corrupted (weird line wrapping, spaces inserted, whole chunks of text missing) if they're edited in the wysiwyg editor using IE7? We're not seeing any similar issues with Firefox or Safari... Yes, we've noticed this a few days ago, but have not looked into the cause yet. Hopefully it should get fixed for 3.8.1 (which we hope to have out relatively quickly) Has there been a resolution to this issue? Was it fixed with 3.8.1? My users are experiencing this problem as well. -Adam ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com -- Thanks, Carlos A. Alvarez Network Engineer CommX Inc. 3550 Buschwood Park Drive Suite 320 Tampa, FL 33618 A good Engineer can do just about anything - George Phelps PPE - NASA ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] RT 3.8.x Translation - Question for German Users
Hi there, Dashboard, Queue and Ticket. Should it be translated or should it be like it is? My experience is that it makes it easier not to translate Queue and Ticket. I myself find it very confusing to explain anything to my RT-Users about Stapel and not Queue. So, at least stay with Queue and Ticket. Since I don't know what the Dashboard in RT is, just leave it... What I would find *most* useful in the translation is keeping the Rights in their original English value. It is an administrative nightmare trying to manipulate rights in the German translation. For example, Take Ticket and Steal Ticket are indistinguishable in the German translation (both Ticket übernehmen) and the sorting of the right fields is based on the English locale. As for things like Queue or Dashboard I would find a *sensible* translation quite useful. The general 3.6 translation is not bad in that part, except that it has still a few errors. [time] left is translated as the direction left (as in move to the left) instead of its original temporal meaning. But these are a few minor concerns. As for Dashboard I'd recommend something like Arbeitsplätze or Übersichten (note the plural). The literal translation (Armaturenbrett / Instrumententafel) of dashboard is not ideal. The words are only used in the context of real dashboards (as in a car or an airplane). In total I find a sensible translation very helpful to the non-English speakers I am working here. The important part is that it needs to be sensible, and not just passing everything through an translation. The original translator definitely did not check his translation in the web site. Naturally, any translation will both increase the bulk of the UI and introduce a bit of ambiguity. One cannot avoid this when translating, you can just try to minimize it. The problem mentioned here is true for the technically adept. Those people (like myself, to be true) who prefer the original compact English UI. But this holds true only for the real IT power users. They can always keep the English UI active. The more average people you have, the less their English skills are, the more problems you introduce by keeping the UI partly English. It is very important for them to have a clear translated UI. Only very domain specific phrases should be kept in English. Something like Queue with its real IT meaning isn't well known. Most people, when reading it, will rather think of a Billard Queue. The same holds true for Dashboard. Go out and ask a couple of Users what they would expect of a menu item called like that in a ticket system. Then ask then what they would expect from Arbeitsplätze or Übersichten instead. Unfortunalety, I have no idea how to update the translations. Also I don't know if the German translation is still maintained. If not, I might actually volunteer to help a bit here, if I can get some advise how the string tables are updated. Yours, Torben Nehmer --- Torben Nehmer Diplom Informatiker (FH) Business System Developer CANCOM Deutschland GmbH Messerschmittstr. 20 89343 Scheppach Germany Tel.: +49 8225 - 996-1118 Fax: +49 8225 - 996-41118 [EMAIL PROTECTED] www.cancom.de CANCOM Deutschland GmbH Sitz der Gesellschaft: Jettingen-Scheppach HRB 10653 Memmingen Geschäftsführer: Paul Holdschik, Christian Linder Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch durch den Empfänger bestimmt! This e-mail and any files transmitted with it are confidential intended solely for the use of the addressee! ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com