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

[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

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

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 =

[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

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

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]

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] 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?

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]

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

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

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?

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

[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

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:

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

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]