[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 '' then the apache process handling the request maxes out CPU and hangs forever. If I create the same search wi

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 o

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 '' > > then the apache process handlin

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 Message will be retried for 2 more day(s) Technical details of temporary failure: The recipient server did not accept our requests to connect. (not

[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

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 = '', 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 AM, Justin Hay

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 som

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 v

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 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 as far as I know and

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 m

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 condit

[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, w

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" wrote: > Hi, > > We have modified rt-crontool to create Nagios alerts.

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 yo

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 Refresh

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 wrote: > Kenneth Crocker wrote: > > To list, > > When we were in 3.6.4, the category for a Custom Field would show in the > "Mo

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 wrote: > On 04/29/2010 02:43 PM, Max McGrath wrote: > >> Thank y

[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 s

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 > For some reasons, I need to give a direct (read) access to the tickets > attachments. > > Browsing the email archive, I found some

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 machine

[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