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

2015-01-19 Thread 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] RT-Extension-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed.

2015-01-19 Thread 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-TicketLocking-0.12 and RT 4.2.9 - probs showing user lock - fixed.

2015-01-19 Thread Alex Vandiver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Sun, 18 Jan 2015 12:07:42 + Daniel Schwager
daniel.schwa...@dtnet.de 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-


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

2015-01-19 Thread Alex Vandiver
On Mon, 19 Jan 2015 22:50:07 +0100 Vladimir Nikolic
vladimir.niko...@amis.net 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 defaults 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


[rt-users] Duplicate ticket detection at OnCreate

2015-01-19 Thread 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


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

2015-01-19 Thread 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 a...@peters.net a...@peters.net
 *Inviato:* Mon Jan 19 2015 08:48:45 GMT+0100 (CET)
 *A:* rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com
 rt-users@lists.bestpractical.com
 *Cc:* Guadagnino Cristiano guadagnino.cristi...@creval.it
 guadagnino.cristi...@creval.it
 *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 a...@peters.net a...@peters.net
 *Inviato:* Sat Jan 17 2015 01:09:38 GMT+0100 (CET)
 *A:* k...@rice.edu k...@rice.edu k...@rice.edu, vinz
 vinzenz.sinap...@tracetronic.de vinzenz.sinap...@tracetronic.de
 *Cc:* rt-users@lists.bestpractical.com
 rt-users@lists.bestpractical.com
 *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

2015-01-19 Thread 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]/user/SendEmail.jtp?type=nodenode=59357i=0
Inviato: Mon Jan 19 2015 08:48:45 GMT+0100 (CET)
A: [hidden email]/user/SendEmail.jtp?type=nodenode=59357i=1 [hidden 
email]/user/SendEmail.jtp?type=nodenode=59357i=2
Cc: Guadagnino Cristiano [hidden 
email]/user/SendEmail.jtp?type=nodenode=59357i=3
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]/user/SendEmail.jtp?type=nodenode=59357i=4 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]/user/SendEmail.jtp?type=nodenode=59357i=5
Inviato: Sat Jan 17 2015 01:09:38 GMT+0100 (CET)
A: [hidden email]/user/SendEmail.jtp?type=nodenode=59357i=6 [hidden 
email]/user/SendEmail.jtp?type=nodenode=59357i=7, vinz [hidden 
email]/user/SendEmail.jtp?type=nodenode=59357i=8
Cc: [hidden email]/user/SendEmail.jtp?type=nodenode=59357i=9
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 
herehttp://requesttracker.8502.n7.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=59339code=dmluemVuei5zaW5hcGl1c0B0cmFjZXRyb25pYy5kZXw1OTMzOXw3NDExMDkzNDk=.
NAMLhttp://requesttracker.8502.n7.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.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

2015-01-19 Thread 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 a...@peters.netmailto:a...@peters.net
Inviato: Mon Jan 19 2015 08:48:45 GMT+0100 (CET)
A: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com 
rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
Cc: Guadagnino Cristiano 
guadagnino.cristi...@creval.itmailto:guadagnino.cristi...@creval.it
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.itmailto: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 a...@peters.netmailto:a...@peters.net
Inviato: Sat Jan 17 2015 01:09:38 GMT+0100 (CET)
A: k...@rice.edumailto:k...@rice.edu k...@rice.edumailto:k...@rice.edu, 
vinz vinzenz.sinap...@tracetronic.demailto:vinzenz.sinap...@tracetronic.de
Cc: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
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] MoreAboutRequestorTicketList is ignored

2015-01-19 Thread 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.

2015-01-19 Thread 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
 daniel.schwa...@dtnet.de 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 hangs with 'SELECT GET_LOCK' slow query log entries

2015-01-19 Thread 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.comhttp://www.eckoh.com

[cid:image001.png@01D033E7.7F643540]http://www.linkedin.com/company/eckoh-plc[cid:image002.png@01D033E7.7F643540]http://twitter.com/Eckoh

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-Extension-QueueDeactivatedScrips for RT 4.2 ?

2015-01-19 Thread Wallace Reis
On Jan 19, 2015, at 1:19 PM, Guadagnino Cristiano 
guadagnino.cristi...@creval.it 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 ?

2015-01-19 Thread 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 guadagnino.cristi...@creval.it
Inviato: Fri Jan 16 2015 15:23:44 GMT+0100 (CET)
A: rt-users@lists.bestpractical.com 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-Extension-QueueDeactivatedScrips for RT 4.2 ?

2015-01-19 Thread 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.


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

2015-01-19 Thread 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]http://www.linkedin.com/company/eckoh-plc
 [cid:image597fe6.PNG@4d915fd5.478baf49] http://twitter.com/Eckoh

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 hangs with 'SELECT GET_LOCK' slow query log entries

2015-01-19 Thread 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.comhttp://www.eckoh.com

[cid:image001.png@01D033E8.B1EDB800]http://www.linkedin.com/company/eckoh-plc[cid:image002.png@01D033E8.B1EDB800]http://twitter.com/Eckoh

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

2015-01-19 Thread 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.commailto: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.comhttp://www.eckoh.com

[cid:image001.png@01D033DB.F32643D0]http://www.linkedin.com/company/eckoh-plc[cid:image002.png@01D033DB.F32643D0]http://twitter.com/Eckoh

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-Extension-QueueDeactivatedScrips for RT 4.2 ?

2015-01-19 Thread Guadagnino Cristiano
Wallace,
thank you very much, this is exactly the information I was looking for!!

Bye
Cris


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

 On Jan 19, 2015, at 2:05 PM, Guadagnino Cristiano 
 guadagnino.cristi...@creval.it 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