[rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Justin Hayes
RT3.8.4 If I use an unprivileged user (or a privileged user with no rights to see queues or tickets) to create a very simple search that looks like this: Requestor.EmailAddress Like 'email address' then the apache process handling the request maxes out CPU and hangs forever. If I create the

Re: [rt-users] RT and Nagios

2010-04-29 Thread Raed El-Hames
I really do not understand why you would need nagios for this? We have very much similar kpis which we monitor with a simple perl script utilising the RT api. Our script run every hour , update the tickets with a warning comment if the warning threshold is reached (Admin Ccs receive an email

Re: [rt-users] RT and Nagios

2010-04-29 Thread Jeff Blaine
On 4/29/2010 5:16 AM, Raed El-Hames wrote: I really do not understand why you would need nagios for this? I highly doubt they installed Nagios *just* for this. Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Kenneth Marshall
On Thu, Apr 29, 2010 at 08:24:22AM +0100, Justin Hayes wrote: RT3.8.4 If I use an unprivileged user (or a privileged user with no rights to see queues or tickets) to create a very simple search that looks like this: Requestor.EmailAddress Like 'email address' then the apache process

Re: [rt-users] Question about using an external SMTP server

2010-04-29 Thread Chris Hall
ok, turns out I am getting bounced messages... snippet below: Delivery to the following recipient has been delayed: r...@rt.#.com r...@rt.imctv.com Message will be retried for 2 more day(s) Technical details of temporary failure: The recipient server did not accept our requests

[rt-users] How to detect a custom field change in a scrip

2010-04-29 Thread lobo+rt
Hiya, we use custom fields and they work well so far. Now I'd like to do something in a scrip if the content of one of my custom fields changes, say, from foo to bar. I know how to check if the field is bar, but I don't know how to find out if it always has been bar before, or if the user just

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Justin Hayes
Hi Kenneth, I'm using MYSQL, How can I tell which query it is? I get no logging and nothing in the MYSQL slow search log, I assume because it never completes? Thanks, Justin - Justin Hayes Orbis Support Manager justin.ha...@orbisuk.com On 29

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Ruslan Zakirov
Hi Justin, First of all use Requestor.EmailAddress = 'email address', so use = instead of LIKE, in the query builder it is is operator. Second, add index on CachedGroupMembers(MemberId, GroupId, Disabled) and on Users(EmailAddress) if these are not there already. On Thu, Apr 29, 2010 at 11:24

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Justin Hayes
Hi Ruslan, I have both of those indexes already, and in SelfService I have no control over the query being run - it's just trying to show the 'My open tickets' panel. Also there is no problem with SelfService with a privileged account that has rights to see queues/tickets, so it seems to be

Re: [rt-users] How to detect a custom field change in a scrip

2010-04-29 Thread Kenneth Crocker
Lobo, Do you REALLY care what the old value was? We use Custom Fields as triggers on a lot of scrips, but we really don't care what it used to be. We only care that it has changed and what it has changed to. It makes the code easier to write and debug. Kenn LBNL On Thu, Apr 29, 2010 at 6:58 AM,

Re: [rt-users] How to detect a custom field change in a scrip

2010-04-29 Thread lobo+rt
Kenn, () Do you REALLY care what the old value was? We use Custom Fields as triggers () on a lot of scrips, but we really don't care what it used to be. We only () care that it has changed and what it has changed to. It makes the code () easier to write and debug. yes, I only care about the new

Re: [rt-users] Requestor email address search hangs apache process

2010-04-29 Thread Ruslan Zakirov
Hello, On Thu, Apr 29, 2010 at 8:35 PM, Justin Hayes justin.ha...@orbisuk.com wrote: Hi Ruslan, I have both of those indexes already, and in SelfService I have no control over the query being run - it's just trying to show the 'My open tickets' panel. My open tickets panel uses user's ID

Re: [rt-users] RT and Nagios

2010-04-29 Thread Hossein Rafighi
There is always more than one way to skin the We monitor all our devices by Nagios and naturally made sense to add RT to it. Not all the solutions are good for all RT users. Cheers, Hossein Raed El-Hames wrote: I really do not understand why you would need nagios for this? We have very

Re: [rt-users] How to detect a custom field change in a scrip

2010-04-29 Thread Kenneth Crocker
OK, I've got some examples for you. First, let's talk about conditions. If your condition is simple, like just a status change, then that's all you need. But the moment you want to combine a status change with some other info, like a CF value, then you need to specify User-Defined for the

[rt-users] Global Config for RT at a glance not taking effect

2010-04-29 Thread Max McGrath
Hi all - Sorry to repost this problem, but I'm hoping with a better subject more people will read it! This problem came about because I wanted to be able to add a new Element (I think that's the proper term) on my RT at a glance page full of helpful links for our desk workers (i.e., blackboard,

Re: [rt-users] RT and Nagios

2010-04-29 Thread Gary Greene
We're in the process of rolling out network and machine monitoring here using Nagios, so I'd be very interested in this, please send the info my way when you've the opportunity. Thanks. On 4/28/10 2:34 PM, Hossein Rafighi hossein.rafi...@triumf.ca wrote: Hi, We have modified rt-crontool to

Re: [rt-users] Global Config for RT at a glance not taking effect

2010-04-29 Thread Kenneth Crocker
Max, Sounds like an interesting conundrum. I'll bite. When you say individuals can change their *preferences* and they *DO* take effect? But the Global defaults don't? *OR* are you saying the Global defaults work but when you make *changes to those defaults* they don't take effect? Also, when

Re: [rt-users] Global Config for RT at a glance not taking effect

2010-04-29 Thread Max McGrath
Thank you Kenn! But I think I just figured it out! Let me try to explain what was going on... I added the line below to my RT_SiteConfig. Set($HomepageComponents, [qw( QuickCreate QuickSearch MyAdminQueues MySupportQueues MyReminders RefreshHomepage Dashboards Links)]); That then gave

Re: [rt-users] Global Config for RT at a glance not taking effect

2010-04-29 Thread Jeff Voskamp
On 04/29/2010 02:43 PM, Max McGrath wrote: Thank you Kenn! But I think I just figured it out! Let me try to explain what was going on... I added the line below to my RT_SiteConfig. Set($HomepageComponents, [qw( QuickCreate QuickSearch MyAdminQueues MySupportQueues MyReminders

Re: [rt-users] Category no longer shows in ticket

2010-04-29 Thread Kenneth Crocker
To list, Any more on this? Is there a patch I can apply that will use the category for a shorter value list? Thanks. Kenn LBNL On Fri, Apr 2, 2010 at 12:04 AM, Joop joopvandew...@mococo.nl wrote: Kenneth Crocker wrote: To list, When we were in 3.6.4, the category for a Custom Field

Re: [rt-users] Global Config for RT at a glance not taking effect

2010-04-29 Thread Max McGrath
Geez Good find Jeff!! Everything is perfect now! Thank you everybody!!! -- Max McGrath Asst. Network Admin/Systems Specialist Carthage College 262-552-5512 mmcgr...@carthage.edu On Thu, Apr 29, 2010 at 1:55 PM, Jeff Voskamp javos...@uwaterloo.ca wrote: On 04/29/2010 02:43 PM, Max

[rt-users] Attachments on disk?

2010-04-29 Thread Thierry Thelliez
For some reasons, I need to give a direct (read) access to the tickets attachments. Browsing the email archive, I found some discussions about storing the attachments 'onDisk'. This was in August 2007. Are there more thoughts on that topic since? Alternatively, before I reinvent the wheel, has

Re: [rt-users] Attachments on disk?

2010-04-29 Thread Torsten Brumm
Hi Thierry, there is a addon bps wrote but it is not available public at the moment. Hopefully Jesse will push it out some day. Torsten 2010/4/29 Thierry Thelliez thierry.thelliez.t...@gmail.com For some reasons, I need to give a direct (read) access to the tickets attachments. Browsing the

Re: [rt-users] RT and Nagios

2010-04-29 Thread Hossein Rafighi
Few people off the list had made the same request and I sent them the relevant info. With apologizes for spamming those of you who are not interested, I am attaching the requested files to this message. Cheers, Hossein Gary Greene wrote: We're in the process of rolling out network and

[rt-users] On Comment Notify AdminCcs as Comment Unless Resolved

2010-04-29 Thread Bill Galeckas
Hello, I've been banging my head on this for days... searched the lists high and low... and I finally give up. Here's what I'm trying to do: I'd like to have the final resolve comment not be sent out. However, I don't want to break the built-in functionality of the On Comment Notify AdminCcs as