[rt-users] MoreAboutRequestorTicketList is ignored

[darthPaal]

Hello, I am running RT 4.2.9 and want to view all tickets in the 'More about
the requestors' section. I have added the following line in my
RT_SiteConfig.pm file:

Set($MoreAboutRequestorTicketList, "All");

but the setting is ignored, its stil only active tickets that are listed.
Any thoughts?



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/MoreAboutRequestorTicketList-is-ignored-tp59380.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed.

[Daniel Schwager]

Hi Alex,

thanks for this fix. Works fine now.

regards
Danny


> -Original Message-
> From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
> Alex Vandiver
> Sent: Tuesday, January 20, 2015 2:30 AM
> To: rt-users@lists.bestpractical.com
> Subject: Re: [rt-users] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs 
> showing user lock - fixed.
> 
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> On Sun, 18 Jan 2015 12:07:42 + Daniel Schwager
>  wrote:
> > Just a small not for other admins: If you lock a ticket with
> > RT-Extension-TicketLocking-0.12, the lock show like (1) for other
> > users.
> 
> I've released version 1.00 of RT::Extension::TicketLocking which
> addresses this.
>  - Alex
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v2.0.22 (GNU/Linux)
> 
> iEYEARECAAYFAlS9r6QACgkQMflWJZZAbqCz/ACeLtj/pcI4zeumYrYu9ZRCS1w6
> k4QAoLISsFabVLTHIru9D2v2hBpqKh8O
> =+OpU
> -END PGP SIGNATURE-


smime.p7s
Description: S/MIME cryptographic signature

Re: [rt-users] RT 4.2.9 Simple Search, Subject LIKE instead of Id =

[Alex Vandiver]

On Mon, 19 Jan 2015 22:50:07 +0100 Vladimir Nikolic
 wrote:
> Hello,
> 
> after upgrade to 4.2.9 (from 4.2.2), we noticed that Simple Search by 
> Ticket id doesn't work.
> If I enter 783509 in Search box, Edit Search shows sql query:
> 
> ( Subject LIKE 783502 ) AND (  Status = 'new' OR Status = 'open' OR 
> Status = 'resolved' OR Status = 'stalled' OR Status = 'rejected' OR 
> Status = 'deleted' )

This does not occur on a stock RT 4.2.9.

> /usr/local/lib/perl5/site_perl/RT/Search/Simple.pm has lines:
> 
>  # Assume that numbers were actually "default"s if we have other
>  # limits
>  if ($limits->{id} and keys %{$limits} > 1) {
>  my $values = delete $limits->{id};
>  for my $value (@{$values}) {
>  $value =~ /(\d+)/ or next;
>  my ($key, @tsql) = $self->HandleDefault($1);
>  push @{$limits->{$key}}, @tsql;
>  }
>  }
> 
> which rewrites 'Id =' to 'Subject LIKE'.

It only does so _if_ there are other limits -- as the comment
describes.  This is so, in a stock RT, entering «rt 4» into the search
box does not attempt to load ticket #4.


Double-check that you do not have any customizations in this area.  For
the following command, a stock RT 4.2.9 should return only the ID
clause:

perl -I/opt/rt4/lib -MRT=-init -MRT::Search::Simple \
 -le 'print RT::Search::Simple->new(TicketsObj =>
RT::Tickets->new(RT->SystemUser))->QueryToSQL("783502")'


 - Alex

Re: [rt-users] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed.

[Alex Vandiver]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Sun, 18 Jan 2015 12:07:42 + Daniel Schwager
 wrote:
> Just a small not for other admins: If you lock a ticket with
> RT-Extension-TicketLocking-0.12, the lock show like (1) for other
> users.

I've released version 1.00 of RT::Extension::TicketLocking which
addresses this.
 - Alex
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.22 (GNU/Linux)

iEYEARECAAYFAlS9r6QACgkQMflWJZZAbqCz/ACeLtj/pcI4zeumYrYu9ZRCS1w6
k4QAoLISsFabVLTHIru9D2v2hBpqKh8O
=+OpU
-END PGP SIGNATURE-

[rt-users] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed.

[Daniel Schwager]

Hi,



Just a small not for other admins: If you lock a ticket with 
RT-Extension-TicketLocking-0.12, the lock show like (1) for other users.



You can fix this by copy ShowLock to your local area

mkdir -p /opt/rt4/local/html/Elements

cp -local/plugins/RT-Extension-TicketLocking/html/Elements/ShowLock 
/opt/rt4/local/html/Elements



and change it like



  /opt/rt4/local/html/Elements/ShowLock:45

  - <&|/l, $TicketLabel, $u_str, $ago &>[_1] has been locked by 
[_2] for [_3].

  + <%$TicketLabel%> has been locked by <%$u_str |n%> for <%$ago%>.



regards

Danny





(1) Lock for other users



[cid:image001.png@01D0331E.A2BFD220]




smime.p7s
Description: S/MIME cryptographic signature

Re: [rt-users] RT-Extension-RepeatTicket - find all tickets with "Recurrence" enabled?

[Daniel Schwager]

Hi all,

> Is there a way to create a search-query to find all the enabled recurring 
> tickets?

after investigating the original rt-repeat-ticket perl script, I "developed" my 
own list implementation (1).

best regards
  Danny


(1) rt-repeat-ticket

#!/opt/perl-5.18.4/bin/perl 

 
use strict;
use warnings;

BEGIN {
use lib qw(/opt/rt4/local/lib /opt/rt4/lib);
use RT;
RT::LoadConfig;
RT::Init;
}

use RT::Attributes;
use RT::Ticket;
use RT::User;

__PACKAGE__->run(@ARGV) unless caller;

sub run{

my $attrs = RT::Attributes->new( RT->SystemUser );
$attrs->Limit( FIELD => 'Name', VALUE => 'RepeatTicketSettings' );

my $ticket =  RT::Ticket->new( RT->SystemUser );

while ( my $attr = $attrs->Next ) {
next unless $attr->Content->{'repeat-enabled'};
next unless $attr->Content->{'repeat-type'};
next unless $attr->ObjectType eq "RT::Ticket";

if (!defined $ticket->Load($attr->ObjectId)) {
$RT::Logger->error("Can't load ticket ". $attr->ObjectId);
next;
}

print '#' . $attr->ObjectId . ' '  . $ticket->Subject
. ' (' . $ticket->OwnerObj->FriendlyName . '): '
. $attr->Content->{'repeat-type'} . "\n";
}
return;
}
1;

__END__


smime.p7s
Description: S/MIME cryptographic signature

[rt-users] Duplicate ticket detection at OnCreate

[Chris Herrmann]

Hi all,

we have many systems that generate emails on conditions (success, fail,
warn etc), and many of these will quite vocally notify you when something
goes wrong. So if you have 100 systems all emailing you every 5 minutes
about the same underlying problem... the queue rapidly gets out of control.

Are there any extensions / plugins / scrips etc that can be used to look
for duplicate tickets on creation? I know there's a Nagios plugin - but
these aren't Nagios tickets so you don't have a system changing state. In
this case the emails all have identical subject tags (like SUBJECT: Warning
backup failure on host(x)); occur within a short time interval but because
they're generated from a remote system none of them have an RT tag like
[myrtsystem #12345].

We currently manage it when it occurs by running the following:

rt list "queue = 'myqueue' and status = 'new' and subject='My Broken
Ticket Subject'" -i | rt edit - set status='deleted'

which works well (much faster than the webgui) but it would be nice if we
could simply delete them on incoming or merge them or something like that.

Thanks!

Chris

[rt-users] RT 4.2.9 Simple Search, Subject LIKE instead of Id =

[Vladimir Nikolic]

Hello,

after upgrade to 4.2.9 (from 4.2.2), we noticed that Simple Search by 
Ticket id doesn't work.

If I enter 783509 in Search box, Edit Search shows sql query:

( Subject LIKE 783502 ) AND (  Status = 'new' OR Status = 'open' OR 
Status = 'resolved' OR Status = 'stalled' OR Status = 'rejected' OR 
Status = 'deleted' )


/usr/local/lib/perl5/site_perl/RT/Search/Simple.pm has lines:

# Assume that numbers were actually "default"s if we have other limits
if ($limits->{id} and keys %{$limits} > 1) {
my $values = delete $limits->{id};
for my $value (@{$values}) {
$value =~ /(\d+)/ or next;
my ($key, @tsql) = $self->HandleDefault($1);
push @{$limits->{$key}}, @tsql;
}
}

which rewrites 'Id =' to 'Subject LIKE'.

sub HandleDefault   {
my $fts = RT->Config->Get('FullTextSearch');
if ($fts->{Enable} and $fts->{Indexed}) {
return default => "(Subject LIKE '$_[1]' OR Content LIKE '$_[1]')";
} else {
return default => "Subject LIKE '$_[1]'";
}
}

Regards,
Vladimir

Re: [rt-users] RT-Extension-QueueDeactivatedScrips for RT 4.2 ?

[Guadagnino Cristiano]

Wallace,
thank you very much, this is exactly the information I was looking for!!

Bye
Cris


-Messaggio originale-
Da: Wallace Reis 
Inviato: Mon Jan 19 2015 17:27:35 GMT+0100 (CET)
A: 
Oggetto: Re: [rt-users] RT-Extension-QueueDeactivatedScrips for RT 4.2 ?

> On Jan 19, 2015, at 2:05 PM, Guadagnino Cristiano 
>  wrote:
>> Unfortunately, that's not what I'm seeing: I see the checkboxes only for
>> those scrips that are *NOT* global. The globally applied scrips does not
>> have the checkbox, and so they cannot be deactivated (see attached
>> snapshot).
>
> Sorry, this is actually the other way around.
>
> Select the menu item “Admin” -> “Global” -> “Scrips”, then click on the scrip 
> you want to change which queues it applies to. On the scrip page, select the 
> submenu “Applies to”, then you should see a page either with “Applies to all 
> objects” message — which then you click on the checkbox and submit in order 
> to remove that from all queues making you able to selectively choose the 
> queue you want it applied — or a page showing a list of queues it applies 
> (Selected objects) and those not (Unselected objects).
>
> --
> Wallace Reis/wreis
> Software Engineer
>

Re: [rt-users] RT-Extension-QueueDeactivatedScrips for RT 4.2 ?

[Wallace Reis]

On Jan 19, 2015, at 2:05 PM, Guadagnino Cristiano 
 wrote:
> Unfortunately, that's not what I'm seeing: I see the checkboxes only for
> those scrips that are *NOT* global. The globally applied scrips does not
> have the checkbox, and so they cannot be deactivated (see attached
> snapshot).

Sorry, this is actually the other way around.

Select the menu item “Admin” -> “Global” -> “Scrips”, then click on the scrip 
you want to change which queues it applies to. On the scrip page, select the 
submenu “Applies to”, then you should see a page either with “Applies to all 
objects” message — which then you click on the checkbox and submit in order to 
remove that from all queues making you able to selectively choose the queue you 
want it applied — or a page showing a list of queues it applies (Selected 
objects) and those not (Unselected objects).

--
Wallace Reis/wreis
Software Engineer

Re: [rt-users] RT-Extension-QueueDeactivatedScrips for RT 4.2 ?

[Moose]

Just edit the relevant global scrip to do something like this: (Replace
"QueueName01 and QueueName02)

Description:  On Correspond; Open Tickets
Condition: User Defined
Action: Open Tickets
Template: Global Template: Blank
Stage: TransactionCreate


# CUSTOM CONDITION:
if ($self->TicketObj->QueueObj->Name !~ /^(QueueName01|QueueName02)$/ ) {
   if ($self->TransactionObj->Type eq 'Correspond') {
 return 1;
  }
}



--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/RT-Extension-QueueDeactivatedScrips-for-RT-4-2-tp59341p59370.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] RT-Extension-QueueDeactivatedScrips for RT 4.2 ?

[Wallace Reis]

On Jan 19, 2015, at 1:19 PM, Guadagnino Cristiano 
 wrote:
> Could someone point me in the right direction?

Go to the queue display page (in menu item “Admin” -> “Queue” -> “Select”, then 
click on the queue you want to), then choose the submenu item “Scrips” on that 
page and you will be given a list of applied scrips which you can click on the 
checkboxes and deactivate — which will make them to appear in the "Not applied 
scrips” listing.

Cheers,

--
Wallace Reis/wreis
Software Engineer

Re: [rt-users] RT-Extension-QueueDeactivatedScrips for RT 4.2 ?

[Guadagnino Cristiano]

Hi had someone replying me privately, telling me that this type of 
functionality is already integrated in RT 4.2.x.

I haven't been able to find documentation about this, and I also haven't 
been able to deduce it from RT's administration interface.

Could someone point me in the right direction?

Thank you in advance

Bye
Cris


-Messaggio originale-
Da: Guadagnino Cristiano 
Inviato: Fri Jan 16 2015 15:23:44 GMT+0100 (CET)
A: rt-users@lists.bestpractical.com 
Oggetto: [rt-users] RT-Extension-QueueDeactivatedScrips for RT 4.2 ?

> Hi all,
> is there an extension like RT-Extension-QueueDeactivatedScrips but
> working with RT 4.2?
>
> What the extension does is allowing an administrator to selectively
> deactivate global scrips for a queue.
>
> thank you in advance.
>
> Bye
> Cris
>

Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Atif Mehboob]

You are a star ☺ Thank you Torsten

From: Brumm, Torsten / Kuehne + Nagel / Ham GI-ID 
[mailto:torsten.br...@kuehne-nagel.com]
Sent: 19 January 2015 12:07
To: Atif Mehboob; rt-users@lists.bestpractical.com
Subject: AW: RT hangs with 'SELECT GET_LOCK' slow query log entries

And again,
try out this: 
http://search.cpan.org/~chorny/Apache-Session-1.93/lib/Apache/Session/MySQL/NoLock.pm

Think it is the better solution.

Torsten

Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von 
Atif Mehboob
Gesendet: Montag, 19. Januar 2015 10:38
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

Hi All,

RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please?

Cheers,
Atif

--

Atif Mehboob
Linux Administrator

Eckoh UK Limited
Telford House, Corner Hall
Hemel Hempstead, Hertfordshire HP3 9HN

T 01442 458336
M n/a
W www.eckoh.com

[cid:image001.png@01D033E1.83DCACC0][cid:image002.png@01D033E1.83DCACC0]

US Headquarters:
Eckoh, Inc.
11811 N. Tatum Blvd., Suite 3031
Phoenix, AZ  85028


This communication contains information, which is confidential and may also be 
privileged. It is for the exclusive use of the intended recipient(s) only. If 
you are not the intended recipient(s) please note that any form of 
distribution, copying or use of this communication or the information in it is 
strictly prohibited and may be unlawful. If you have received this 
communication in error please return it to the sender and then delete it. 
Opinions expressed in this message are those of the author, and are not binding 
on the company.
Registered in England and Wales, No. 2796531
Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire 
HP3 9HN
A member of the Eckoh Plc group of companies.

Kühne + Nagel (AG & Co.) KG
Rechtsform: Kommanditgesellschaft, Bremen HRA 21928, USt-IdNr.: DE 812773878.
Geschäftsleitung Kühne + Nagel (AG & Co.) KG: Reiner Heiken (Vors.), Dirk 
Blesius, Martin Brinkmann, Holger Ketz, Jan-Hendrik Köstergarten, Christian 
Solf, Lars Wedel, Jens Wollesen.
Persönlich haftende Gesellschafterin: Kühne & Nagel A.G., Rechtsform: 
Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 18745, 
Geschäftsführendes Verwaltungsratsmitglied: Karl Gernandt.
Geschäftsleitung Region Westeuropa: Yngve Ruud (Vors.), Hans-Georg Brinkmann 
(Stellv.), Richard Huhn, Björn Johansson, Bruno Mang, Stefan Paul, Tim 
Scharwath, Dominic Edmonds.

Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen 
Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen 
insbesondere auf die vom Gesetz abweichenden Haftungsbeschränkungen von Ziffer 
23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf 
Anfrage und können Sie auch unter http://www.kuehne-nagel.com einsehen. 
Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler 
Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von 
Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) 
wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen 
Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne 
der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an 
Bord oder Mängel des Schiffes haften.

Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Brumm, Torsten / Kuehne + Nagel / Ham GI-ID]

And again,
try out this: 
http://search.cpan.org/~chorny/Apache-Session-1.93/lib/Apache/Session/MySQL/NoLock.pm

Think it is the better solution.

Torsten

Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von 
Atif Mehboob
Gesendet: Montag, 19. Januar 2015 10:38
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

Hi All,

RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please?

Cheers,
Atif

--

Atif Mehboob
Linux Administrator

Eckoh UK Limited
Telford House, Corner Hall
Hemel Hempstead, Hertfordshire HP3 9HN

T 01442 458336
M n/a
W www.eckoh.com

[cid:image001.png@01D033E8.B1EDB800][cid:image002.png@01D033E8.B1EDB800]

US Headquarters:
Eckoh, Inc.
11811 N. Tatum Blvd., Suite 3031
Phoenix, AZ  85028


This communication contains information, which is confidential and may also be 
privileged. It is for the exclusive use of the intended recipient(s) only. If 
you are not the intended recipient(s) please note that any form of 
distribution, copying or use of this communication or the information in it is 
strictly prohibited and may be unlawful. If you have received this 
communication in error please return it to the sender and then delete it. 
Opinions expressed in this message are those of the author, and are not binding 
on the company.
Registered in England and Wales, No. 2796531
Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire 
HP3 9HN
A member of the Eckoh Plc group of companies.

Kühne + Nagel (AG & Co.) KG
Rechtsform: Kommanditgesellschaft, Bremen HRA 21928, USt-IdNr.: DE 812773878.
Geschäftsleitung Kühne + Nagel (AG & Co.) KG: Reiner Heiken (Vors.), Dirk 
Blesius, Martin Brinkmann, Holger Ketz, Jan-Hendrik Köstergarten, Christian 
Solf, Lars Wedel, Jens Wollesen.
Persönlich haftende Gesellschafterin: Kühne & Nagel A.G., Rechtsform: 
Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 18745, 
Geschäftsführendes Verwaltungsratsmitglied: Karl Gernandt.
Geschäftsleitung Region Westeuropa: Yngve Ruud (Vors.), Hans-Georg Brinkmann 
(Stellv.), Richard Huhn, Björn Johansson, Bruno Mang, Stefan Paul, Tim 
Scharwath, Dominic Edmonds.

Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen 
Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen 
insbesondere auf die vom Gesetz abweichenden Haftungsbeschränkungen von Ziffer 
23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf 
Anfrage und können Sie auch unter http://www.kuehne-nagel.com einsehen. 
Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler 
Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von 
Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) 
wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen 
Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne 
der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an 
Bord oder Mängel des Schiffes haften.

Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Brumm, Torsten / Kuehne + Nagel / Ham GI-ID]

OK, try out this file:

Apache::Session Lock/MySQL.pm

Search for line:

   #MySQL requires a timeout on the lock operation.  There is no option
#to simply wait forever.  So we'll wait for a hour.

my $sth = $self->{dbh}->prepare_cached(q{SELECT GET_LOCK(?, 3600)}, {}, 1);

We have changed it to 0 or 1 I think and not 3600sec.

Try it out

Torsten

Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von 
Atif Mehboob
Gesendet: Montag, 19. Januar 2015 10:38
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

Hi All,

RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please?

Cheers,
Atif

--

Atif Mehboob
Linux Administrator

Eckoh UK Limited
Telford House, Corner Hall
Hemel Hempstead, Hertfordshire HP3 9HN

T 01442 458336
M n/a
W www.eckoh.com

[cid:image001.png@01D033E7.7F643540][cid:image002.png@01D033E7.7F643540]

US Headquarters:
Eckoh, Inc.
11811 N. Tatum Blvd., Suite 3031
Phoenix, AZ  85028


This communication contains information, which is confidential and may also be 
privileged. It is for the exclusive use of the intended recipient(s) only. If 
you are not the intended recipient(s) please note that any form of 
distribution, copying or use of this communication or the information in it is 
strictly prohibited and may be unlawful. If you have received this 
communication in error please return it to the sender and then delete it. 
Opinions expressed in this message are those of the author, and are not binding 
on the company.
Registered in England and Wales, No. 2796531
Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire 
HP3 9HN
A member of the Eckoh Plc group of companies.

Kühne + Nagel (AG & Co.) KG
Rechtsform: Kommanditgesellschaft, Bremen HRA 21928, USt-IdNr.: DE 812773878.
Geschäftsleitung Kühne + Nagel (AG & Co.) KG: Reiner Heiken (Vors.), Dirk 
Blesius, Martin Brinkmann, Holger Ketz, Jan-Hendrik Köstergarten, Christian 
Solf, Lars Wedel, Jens Wollesen.
Persönlich haftende Gesellschafterin: Kühne & Nagel A.G., Rechtsform: 
Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 18745, 
Geschäftsführendes Verwaltungsratsmitglied: Karl Gernandt.
Geschäftsleitung Region Westeuropa: Yngve Ruud (Vors.), Hans-Georg Brinkmann 
(Stellv.), Richard Huhn, Björn Johansson, Bruno Mang, Stefan Paul, Tim 
Scharwath, Dominic Edmonds.

Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen 
Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen 
insbesondere auf die vom Gesetz abweichenden Haftungsbeschränkungen von Ziffer 
23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf 
Anfrage und können Sie auch unter http://www.kuehne-nagel.com einsehen. 
Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler 
Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von 
Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) 
wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen 
Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne 
der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an 
Bord oder Mängel des Schiffes haften.

Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Atif Mehboob]

Thank you Torsten,

I already changed Set($WebSessionClass, "Apache::Session::File"); and its fixed 
the issue. I am not sure what will be the impact for a longer run.

Cheers,
Atif

From: Brumm, Torsten / Kuehne + Nagel / Ham GI-ID 
[mailto:torsten.br...@kuehne-nagel.com]
Sent: 19 January 2015 11:29
To: Atif Mehboob; rt-users@lists.bestpractical.com
Subject: AW: RT hangs with 'SELECT GET_LOCK' slow query log entries

Hi Atif,
i remember this problem some years ago with RT 3.6.5 we fixed it (fast 
solution) to change the:

Set($WebSessionClass, "Apache::Session::File"); to File.

I remember (not 100% sure) that we later changed a File from Apache:Session 
(think MySQL.pm) and disabled locking there, then it was fine.

Hope someone can help more in detail

torsten

Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von 
Atif Mehboob
Gesendet: Montag, 19. Januar 2015 10:38
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

Hi All,

RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please?

Cheers,
Atif

--

Atif Mehboob
Linux Administrator

Eckoh UK Limited
Telford House, Corner Hall
Hemel Hempstead, Hertfordshire HP3 9HN

T 01442 458336
M n/a
W www.eckoh.com

[cid:image001.png@01D033DB.F32643D0][cid:image002.png@01D033DB.F32643D0]

US Headquarters:
Eckoh, Inc.
11811 N. Tatum Blvd., Suite 3031
Phoenix, AZ  85028


This communication contains information, which is confidential and may also be 
privileged. It is for the exclusive use of the intended recipient(s) only. If 
you are not the intended recipient(s) please note that any form of 
distribution, copying or use of this communication or the information in it is 
strictly prohibited and may be unlawful. If you have received this 
communication in error please return it to the sender and then delete it. 
Opinions expressed in this message are those of the author, and are not binding 
on the company.
Registered in England and Wales, No. 2796531
Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire 
HP3 9HN
A member of the Eckoh Plc group of companies.

Kühne + Nagel (AG & Co.) KG
Rechtsform: Kommanditgesellschaft, Bremen HRA 21928, USt-IdNr.: DE 812773878.
Geschäftsleitung Kühne + Nagel (AG & Co.) KG: Reiner Heiken (Vors.), Dirk 
Blesius, Martin Brinkmann, Holger Ketz, Jan-Hendrik Köstergarten, Christian 
Solf, Lars Wedel, Jens Wollesen.
Persönlich haftende Gesellschafterin: Kühne & Nagel A.G., Rechtsform: 
Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 18745, 
Geschäftsführendes Verwaltungsratsmitglied: Karl Gernandt.
Geschäftsleitung Region Westeuropa: Yngve Ruud (Vors.), Hans-Georg Brinkmann 
(Stellv.), Richard Huhn, Björn Johansson, Bruno Mang, Stefan Paul, Tim 
Scharwath, Dominic Edmonds.

Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen 
Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen 
insbesondere auf die vom Gesetz abweichenden Haftungsbeschränkungen von Ziffer 
23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf 
Anfrage und können Sie auch unter http://www.kuehne-nagel.com einsehen. 
Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler 
Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von 
Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) 
wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen 
Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne 
der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an 
Bord oder Mängel des Schiffes haften.

Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Brumm, Torsten / Kuehne + Nagel / Ham GI-ID]

Hi Atif,
i remember this problem some years ago with RT 3.6.5 we fixed it (fast 
solution) to change the:

Set($WebSessionClass, "Apache::Session::File"); to File.

I remember (not 100% sure) that we later changed a File from Apache:Session 
(think MySQL.pm) and disabled locking there, then it was fine.

Hope someone can help more in detail

torsten

Von: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] Im Auftrag von 
Atif Mehboob
Gesendet: Montag, 19. Januar 2015 10:38
An: rt-users@lists.bestpractical.com
Betreff: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

Hi All,

RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please?

Cheers,
Atif

--

Atif Mehboob
Linux Administrator

Eckoh UK Limited
Telford House, Corner Hall
Hemel Hempstead, Hertfordshire HP3 9HN

T 01442 458336
M n/a
W www.eckoh.com

[cid:image001.png@01D033E3.8A83CA70][cid:image002.png@01D033E3.8A83CA70]

US Headquarters:
Eckoh, Inc.
11811 N. Tatum Blvd., Suite 3031
Phoenix, AZ  85028


This communication contains information, which is confidential and may also be 
privileged. It is for the exclusive use of the intended recipient(s) only. If 
you are not the intended recipient(s) please note that any form of 
distribution, copying or use of this communication or the information in it is 
strictly prohibited and may be unlawful. If you have received this 
communication in error please return it to the sender and then delete it. 
Opinions expressed in this message are those of the author, and are not binding 
on the company.
Registered in England and Wales, No. 2796531
Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire 
HP3 9HN
A member of the Eckoh Plc group of companies.

Kühne + Nagel (AG & Co.) KG
Rechtsform: Kommanditgesellschaft, Bremen HRA 21928, USt-IdNr.: DE 812773878.
Geschäftsleitung Kühne + Nagel (AG & Co.) KG: Reiner Heiken (Vors.), Dirk 
Blesius, Martin Brinkmann, Holger Ketz, Jan-Hendrik Köstergarten, Christian 
Solf, Lars Wedel, Jens Wollesen.
Persönlich haftende Gesellschafterin: Kühne & Nagel A.G., Rechtsform: 
Aktiengesellschaft nach luxemburgischem Recht, HR-Nr.: B 18745, 
Geschäftsführendes Verwaltungsratsmitglied: Karl Gernandt.
Geschäftsleitung Region Westeuropa: Yngve Ruud (Vors.), Hans-Georg Brinkmann 
(Stellv.), Richard Huhn, Björn Johansson, Bruno Mang, Stefan Paul, Tim 
Scharwath, Dominic Edmonds.

Wir arbeiten ausschließlich auf Grundlage der Allgemeinen Deutschen 
Spediteursbedingungen (ADSp), jeweils neuester Fassung. Wir verweisen 
insbesondere auf die vom Gesetz abweichenden Haftungsbeschränkungen von Ziffer 
23 und 24 ADSp. Den vollständigen Text der ADSp übersenden wir Ihnen gerne auf 
Anfrage und können Sie auch unter http://www.kuehne-nagel.com einsehen. 
Ergänzend wird vereinbart, dass (1) Ziffer 27 ADSp im Rahmen internationaler 
Übereinkommen weder unsere Haftung noch die Zurechnung des Verschuldens von 
Leuten und sonstigen Dritten zu Gunsten des Auftraggebers erweitert, und (2) 
wir in den im deutschen Seehandelsrecht aufgeführten Fällen des nautischen 
Verschuldens oder Feuer an Bord nur für eigenes Verschulden und (3) im Sinne 
der CMNI genannten Voraussetzungen nicht für nautisches Verschulden, Feuer an 
Bord oder Mängel des Schiffes haften.

Re: [rt-users] RT eats table-tags in html-emails

[Guadagnino Cristiano]

Alex,
you were right: HTML::Gumbo installation failed on my box, but I did not notice 
it initially.

Trying to reinstall HTML::Gumbo now, I noticed that 'libtoolize' was missing, 
so I installed it.
Unfortunately it fails again because it wants autoconf >= v2.65, and there is 
only v2.63 in CentOS repository.

I'll have to wait until CentOS updates the repos.

Thank you!

Bye
Cris


Da: Alex Peters 
Inviato: Mon Jan 19 2015 09:06:29 GMT+0100 (CET)
A: Guadagnino Cristiano 

Cc: "rt-users@lists.bestpractical.com" 

Oggetto: Re: [rt-users] RT eats table-tags in html-emails
HTML tables are mostly displaying as expected on my installation (ignoring 
missing images and CSS).  I'm running v4.2.7 though; I guess it's possible that 
a regression has occurred in a later version.

There are no other relevant settings in my RT_SiteConfig.pm file, and I'm 90% 
sure that I didn't add any special flags when I ran the "configure" script.

Looking at the code, HTML::Gumbo would be ignored if it failed to install 
properly for some reason.  Are you seeing anything interesting in RT's debug 
logs?  I remember having to grab a very fresh HTML::Gumbo version because of 
some installation issue I encountered with an older (but still somewhat recent) 
one.

Lastly, you've probably already done this, but for the sake of documentation, 
RT would need to be restarted after the installation of this module.


Cristiano Guadagnino

Servizio Sistemi Dipartimentali, Periferici e DB
___
Bankadati Servizi Informatici Soc.Cons.P.A.
Gruppo bancario Credito Valtellinese
VIA TRENTO, 22 - 23100 SONDRIO
tel +39 0342522172  - fax +39 0342522997
guadagnino.cristi...@creval.it
www.creval.it

Il presente messaggio non è di natura personale ma inviato per esigenze 
lavorative; l’eventuale messaggio di risposta potrà essere conosciuto anche da 
altri soggetti diversi dall’originatore di questo messaggio per dette esigenze 
o per controllo aziendale. Questo messaggio, corredato dei relativi allegati, 
contiene informazioni da considerarsi strettamente riservate, ed è destinato 
esclusivamente al destinatario sopra indicato, il quale è l'unico autorizzato 
ad usarlo, copiarlo e, sotto la propria responsabilità, diffonderlo. Chiunque 
ricevesse questo messaggio per errore o comunque lo leggesse senza esserne 
legittimato è avvertito che trattenerlo, copiarlo, divulgarlo, distribuirlo a 
persone diverse dal destinatario è severamente proibito, ed è pregato di 
rinviarlo immediatamente al mittente distruggendone l'originale.

On 19 January 2015 at 18:56, Guadagnino Cristiano 
mailto:guadagnino.cristi...@creval.it>> wrote:
I have both already set. Is it working in your system?
Did you need to add something to the config command line?



Da: Alex Peters 
Inviato: Mon Jan 19 2015 08:48:45 GMT+0100 (CET)
A: rt-users@lists.bestpractical.com 

Cc: Guadagnino Cristiano 

Oggetto: Re: [rt-users] RT eats table-tags in html-emails
Looking at the RT_Config documentation, I think you might need to enable the 
$TrustHTMLAttachments setting.  I know I've enabled that in my local 
installation.

You might also need to increase the $MaxInlineBody setting from its default of 
12,000 bytes (or set it to 0 to disable size limiting altogether), since things 
with HTML tables in my experience tend to frequently exceed that limit.

On 19 January 2015 at 18:41, Guadagnino Cristiano 
mailto:guadagnino.cristi...@creval.it>> wrote:
I did this while upgrading to 4.2.9 but nothing changed in the dispplay of html 
tables.
Is there something more that needs to be done?
IIRC this is not very well documented... just a note among the release notes.

T.I.A.

Cris



Da: Alex Peters 
Inviato: Sat Jan 17 2015 01:09:38 GMT+0100 (CET)
A: k...@rice.edu , 
vinz 
Cc: 
Oggetto: Re: [rt-users] RT eats table-tags in html-emails

Another solution in recent versions of RT is to install the HTML::Gumbo module 
from CPAN, which should automatically enable correct display of all HTML in 
tickets without any coding.






--

[rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

[Atif Mehboob]

Hi All,

RT 4.2.1 hangs with 'SELECT GET_LOCK' slow query log entries. Any help please?

Cheers,
Atif

--

Atif Mehboob
Linux Administrator

Eckoh UK Limited
Telford House, Corner Hall
Hemel Hempstead, Hertfordshire HP3 9HN

T 01442 458336
M n/a
W www.eckoh.com

[cid:imagee8b468.PNG@edf863b6.47b0bc12]
 [cid:image597fe6.PNG@4d915fd5.478baf49] 

US Headquarters:
Eckoh, Inc.
11811 N. Tatum Blvd., Suite 3031
Phoenix, AZ  85028


This communication contains information, which is confidential and may also be 
privileged. It is for the exclusive use of the intended recipient(s) only. If 
you are not the intended recipient(s) please note that any form of 
distribution, copying or use of this communication or the information in it is 
strictly prohibited and may be unlawful. If you have received this 
communication in error please return it to the sender and then delete it. 
Opinions expressed in this message are those of the author, and are not binding 
on the company.
Registered in England and Wales, No. 2796531
Registered office: Telford House, Corner Hall, Hemel Hempstead, Hertfordshire 
HP3 9HN
A member of the Eckoh Plc group of companies.

Re: [rt-users] RT eats table-tags in html-emails

[vinz]

Thank you all for your replies.
I used the solution from Ken. I enabled HTML-Attachments and created a 
\local\lib\RT\Interface\Web_Local.pm
Maybe I'll try the "HTML::Gumbo"-Solution to.

Regards,
Vinz

Von: Guadagnino Cristiano [via RequestTracker] 
[mailto:ml-node+s8502n5935...@n7.nabble.com]
Gesendet: Montag, 19. Januar 2015 08:58
An: Sinapius, Vinzenz
Betreff: Re: RT eats table-tags in html-emails

I have both already set. Is it working in your system?
Did you need to add something to the config command line?


Da: Alex Peters [hidden email]
Inviato: Mon Jan 19 2015 08:48:45 GMT+0100 (CET)
A: [hidden email] [hidden 
email]
Cc: Guadagnino Cristiano [hidden 
email]
Oggetto: Re: [rt-users] RT eats table-tags in html-emails
Looking at the RT_Config documentation, I think you might need to enable the 
$TrustHTMLAttachments setting.  I know I've enabled that in my local 
installation.

You might also need to increase the $MaxInlineBody setting from its default of 
12,000 bytes (or set it to 0 to disable size limiting altogether), since things 
with HTML tables in my experience tend to frequently exceed that limit.

On 19 January 2015 at 18:41, Guadagnino Cristiano <[hidden 
email]> wrote:
I did this while upgrading to 4.2.9 but nothing changed in the dispplay of html 
tables.
Is there something more that needs to be done?
IIRC this is not very well documented... just a note among the release notes.

T.I.A.

Cris


Da: Alex Peters [hidden email]
Inviato: Sat Jan 17 2015 01:09:38 GMT+0100 (CET)
A: [hidden email] [hidden 
email], vinz [hidden 
email]
Cc: [hidden email]
Oggetto: Re: [rt-users] RT eats table-tags in html-emails

Another solution in recent versions of RT is to install the HTML::Gumbo module 
from CPAN, which should automatically enable correct display of all HTML in 
tickets without any coding.






If you reply to this email, your message will be added to the discussion below:
http://requesttracker.8502.n7.nabble.com/RT-eats-table-tags-in-html-emails-tp59339p59357.html
To unsubscribe from RT eats table-tags in html-emails, click 
here.
NAML




--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/RT-eats-table-tags-in-html-emails-tp59339p59359.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

Re: [rt-users] RT eats table-tags in html-emails

[Alex Peters]

HTML tables are mostly displaying as expected on my installation (ignoring
missing images and CSS).  I'm running v4.2.7 though; I guess it's possible
that a regression has occurred in a later version.

There are no other relevant settings in my RT_SiteConfig.pm file, and I'm
90% sure that I didn't add any special flags when I ran the "configure"
script.

Looking at the code, HTML::Gumbo would be ignored if it failed to install
properly for some reason.  Are you seeing anything interesting in RT's
debug logs?  I remember having to grab a very fresh HTML::Gumbo version
because of some installation issue I encountered with an older (but still
somewhat recent) one.

Lastly, you've probably already done this, but for the sake of
documentation, RT would need to be restarted after the installation of this
module.

On 19 January 2015 at 18:56, Guadagnino Cristiano <
guadagnino.cristi...@creval.it> wrote:

>  I have both already set. Is it working in your system?
> Did you need to add something to the config command line?
>
>
> --
> *Da:* Alex Peters  
> *Inviato:* Mon Jan 19 2015 08:48:45 GMT+0100 (CET)
> *A:* rt-users@lists.bestpractical.com 
> 
> *Cc:* Guadagnino Cristiano 
> 
> *Oggetto:* Re: [rt-users] RT eats table-tags in html-emails
>
>  Looking at the RT_Config documentation, I think you might need to enable
> the $TrustHTMLAttachments setting.  I know I've enabled that in my local
> installation.
>
>  You might also need to increase the $MaxInlineBody setting from its
> default of 12,000 bytes (or set it to 0 to disable size limiting
> altogether), since things with HTML tables in my experience tend to
> frequently exceed that limit.
>
> On 19 January 2015 at 18:41, Guadagnino Cristiano <
> guadagnino.cristi...@creval.it> wrote:
>
>> I did this while upgrading to 4.2.9 but nothing changed in the dispplay
>> of html tables.
>> Is there something more that needs to be done?
>> IIRC this is not very well documented... just a note among the release
>> notes.
>>
>> T.I.A.
>>
>> Cris
>>
>>
>> --
>> *Da:* Alex Peters  
>> *Inviato:* Sat Jan 17 2015 01:09:38 GMT+0100 (CET)
>> *A:* k...@rice.edu  , vinz
>>  
>> *Cc:* 
>> 
>> *Oggetto:* Re: [rt-users] RT eats table-tags in html-emails
>>
>> Another solution in recent versions of RT is to install the HTML::Gumbo
>> module from CPAN, which should automatically enable correct display of all
>> HTML in tickets without any coding.
>>
>>
>>
>
>

Re: [rt-users] RT eats table-tags in html-emails

[Guadagnino Cristiano]

I have both already set. Is it working in your system?
Did you need to add something to the config command line?



Da: Alex Peters 
Inviato: Mon Jan 19 2015 08:48:45 GMT+0100 (CET)
A: rt-users@lists.bestpractical.com 

Cc: Guadagnino Cristiano 

Oggetto: Re: [rt-users] RT eats table-tags in html-emails
Looking at the RT_Config documentation, I think you might need to enable the 
$TrustHTMLAttachments setting.  I know I've enabled that in my local 
installation.

You might also need to increase the $MaxInlineBody setting from its default of 
12,000 bytes (or set it to 0 to disable size limiting altogether), since things 
with HTML tables in my experience tend to frequently exceed that limit.

On 19 January 2015 at 18:41, Guadagnino Cristiano 
mailto:guadagnino.cristi...@creval.it>> wrote:
I did this while upgrading to 4.2.9 but nothing changed in the dispplay of html 
tables.
Is there something more that needs to be done?
IIRC this is not very well documented... just a note among the release notes.

T.I.A.

Cris



Da: Alex Peters 
Inviato: Sat Jan 17 2015 01:09:38 GMT+0100 (CET)
A: k...@rice.edu , 
vinz 
Cc: 
Oggetto: Re: [rt-users] RT eats table-tags in html-emails

Another solution in recent versions of RT is to install the HTML::Gumbo module 
from CPAN, which should automatically enable correct display of all HTML in 
tickets without any coding.