Re: [rt-users] RT related Postgres question

2007-11-30 Thread Jesse Vincent
- Seq Scan on tickets main (cost=0.00..17539.97 rows=1485 width=168) (actual time=0.040..846.740 rows=298633 loops=1) Filter: status)::text = 'open'::text) OR ((status)::text = 'new'::text) OR ((status)::text = 'stalled'::text) OR ((status)::text = 'resolved'::text)) AND

Re: [rt-users] Error with ACL?

2007-11-30 Thread Max Clark
Why would it be considered a bug? Wouldn't the person making changes be a person of interest? Wouldn't any person of interest want to know what is going on about a ticket? What has that have to do with the rights to ReplyToTicket? I am not talking about Watcher, AdminCC, or CC privileges here.

RE: [rt-users] Mason error, agentmsg does not exist every second!

2007-11-30 Thread Jay Vlavianos
Yep, sorry for firing off the email so soon. Further investigation shows that its every computer in the network here hitting this machine (which is only an RT machine) so someone on the network side must have misconfigured one of their settings for a software package with our IP address. Thanks!

Re: [rt-users] Mason error, agentmsg does not exist every second!

2007-11-30 Thread Jesse Vincent
On Fri, Nov 30, 2007 at 02:15:19PM -0800, Jay Vlavianos wrote: This showed up about a month ago and I didn't notice it until today when we had an unrelated LDAP login issue. What is this and why is it banging all the time?? It means that someone is trying to visit /agentmsg on the server,

[rt-users] Single user for domains

2007-11-30 Thread Mark Fuller
Is there a way to create a single user for a domain where all email addresses from @foo.com are considered a single user? And they can see all the tickets for their domain? Mark Fuller BandTel Customer Care 603-528-6538 Option 2 603-528-6937 FAX

Re: [rt-users] Code that attaches Signatures to Emails

2007-11-30 Thread Edward Kovarski
Max, Take a look at the following wiki entry, http://wiki.bestpractical.com/view/CannedReplies This should give you an idea on how to modify MessageBox. Ed On 30-Nov-07, at 3:41 PM, Max Clark wrote: Hello, Can someone point me in a direction to the function that attaches a user signature

Re: [rt-users] Change Default Sort of Top Ten Tickets

2007-11-30 Thread Mathew
Under Preferences-RT at a glance are the settings for the widgets which show ticket lists. You can edit the display and sort order for each one under this view. Keep up with my goings on at http://theillien.blogspot.com Max Clark wrote: Hello, The order of the ticket history can be

RE: [rt-users] allowing non rt users to create tickets

2007-11-30 Thread Lamers, Dan
Shawn, RT should work the way you want without modification. You just need to assign the global group rights CreateTicket and ReplyToTicket to the Everyone system group -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Wilson Sent: Friday,

[rt-users] Code that attaches Signatures to Emails

2007-11-30 Thread Max Clark
Hello, Can someone point me in a direction to the function that attaches a user signature to a correspondence? Specifically I'm curious if I can include template variables in the signature. Thanks, Max ___

Re: [rt-users] Error with ACL?

2007-11-30 Thread Kenneth Crocker
Thank you. That's what I was referring to. Kenn LBNL On 11/30/2007 12:17 PM, Todd Chapman wrote: I doubt your patch would be accepted by Jesse. Chances are this isn't a result of some mistake. I'm willing to be that in his view Comment and Reply both modify the ticket so the ability to do

Re: [rt-users] Error with ACL?

2007-11-30 Thread Todd Chapman
I doubt your patch would be accepted by Jesse. Chances are this isn't a result of some mistake. I'm willing to be that in his view Comment and Reply both modify the ticket so the ability to do those things is implied by the ModifyTicket right. I would recommend doing an _Local overlay to

Re: [rt-users] allowing non rt users to create tickets

2007-11-30 Thread Kenneth Marshall
Shawn, The other piece that you need is a very good spam filter before you pass the message to RT, preferably with a quarantine function so that you can release valid mail to RT automatically. We use DSPAM and are very happy with it. Ken On Fri, Nov 30, 2007 at 03:05:58PM -0500, Todd Chapman

Re: [rt-users] Error with ACL?

2007-11-30 Thread Kenneth Crocker
Nope, sorry, DeleteTicket is NOT inherited with the ModifyTicket right. Kenn LBNL On 11/30/2007 11:50 AM, Kenneth Crocker wrote: Max, Well, good news for you, ModifyTicket also inherits CommentOnTicket and I think even DeleteTicket. Kenn LBNL On 11/30/2007 11:14 AM, Max Clark wrote:

[rt-users] allowing non rt users to create tickets

2007-11-30 Thread Shawn Wilson
The way i want this to work - any user on our domain can send an email to an email account and a ticket gets added for them and rt sends them a confirmation email of ticket creation. The tickets may go into a general catagory and we can manually move them into different catagories. Where i'm at -

Re: [rt-users] RT related Postgres question

2007-11-30 Thread Kenneth Marshall
Mark, Here is a list of indexes that we use here. Check your schema to see if you are missing any. You should not be getting a sequential scan. Ken -INDEXes from rt schema-- CREATE INDEX acl1 ON acl USING btree (rightname, objecttype, objectid, principaltype,

[rt-users] Change Default Sort of Top Ten Tickets

2007-11-30 Thread Max Clark
Hello, The order of the ticket history can be changed with $OldestTransactionsFirst, is there a configuration setting that will invert the top tickets display on the homepage or is this a code change? Thanks, Max ___

Re: [rt-users] Error with ACL?

2007-11-30 Thread Max Clark
Isn't this a bug? Or is it really intended for ModifyTicket to have ReplyToTicket rights? -Max (Patch attached) On Nov 30, 2007 5:41 AM, Todd Chapman [EMAIL PROTECTED] wrote: Max, I just reviewed the relevant RT code: sub Correspond { my $self = shift; my %args = ( CcMessageTo

Re: [rt-users] Is lib/RT/Queues_Overlay.pm AddRecord a bug?

2007-11-30 Thread Kenneth Crocker
Jan, My understanding of the SeeQueue and CreateTicket rights are that they are related/coupled when creating ticket via WebUI. It's the same thing as granting CreateTicket globally but also needing the email/correspondence address of any queue you want to create a ticket in using

[rt-users] Autoassign User based on Email Address

2007-11-30 Thread Max Clark
Hello, I am looking for a way to autoassign a user based on the email address. So the queue would still be support but emails sent to [EMAIL PROTECTED] would be opened in the support queue assigned to user. Can this be done with mailgate? Thanks, Max

Re: AW: Re: [rt-users] clean up user table

2007-11-30 Thread Ruslan Zakirov
On Nov 27, 2007 9:25 PM, Kenneth Marshall [EMAIL PROTECTED] wrote: On Tue, Nov 27, 2007 at 09:49:45AM -0800, Gordon Messmer wrote: Kenneth Marshall wrote: The time to open and display a ticket varies based on the number of transactions involved, but typically takes on the order of 1-3s.

[rt-users] Mason error, agentmsg does not exist every second!

2007-11-30 Thread Jay Vlavianos
This showed up about a month ago and I didn't notice it until today when we had an unrelated LDAP login issue. What is this and why is it banging all the time?? [Fri Nov 30 12:58:41 2007] [error] [Mason] File does not exist: /usr/local/rt3/share/html/agentmsg [Fri Nov 30 12:58:44 2007] [error]

Re: [rt-users] Code that attaches Signatures to Emails

2007-11-30 Thread Max Clark
Thanks On Nov 30, 2007 1:09 PM, Edward Kovarski [EMAIL PROTECTED] wrote: Max, Take a look at the following wiki entry, http://wiki.bestpractical.com/view/CannedReplies This should give you an idea on how to modify MessageBox. Ed On 30-Nov-07, at 3:41 PM, Max Clark wrote: Hello,

[rt-users] [RT 3.6.5RC1] Uninformative 'Permission denied' in log mail

2007-11-30 Thread Boris Lytochkin
Today I faced problem with mail delivery into RT: [Thu Nov 29 19:39:14 2007] [debug]: Found a ticket ID. It's 105503 (/usr/local/rt3/lib/RT/Interface/Email.pm:477) [Thu Nov 29 19:39:14 2007] [debug]: SpamHeader: Accepting non-spam message. From: was bla-bla.

Re: [rt-users] How to Configure RT with MS Exchange 2007

2007-11-30 Thread Gordon Messmer
tariq.doukkali wrote: In the file /etc/postfix/maincf: replayhost=IP-Adress of Courier-mail server ... Now we changed our mail server form courier to exchange 2007. I configured the IP adress of exchange server in the /etc/postfix/maincf as replayhost. This configuration dont works!!!

Re: [rt-users] allowing non rt users to create tickets

2007-11-30 Thread Todd Chapman
I would give Unprivileged users the right CreateTicket and then modify RT code to refuse to create users with email not matching some pattern. Better yet, store the pattern in the config file. -Todd On 11/30/07, Shawn Wilson [EMAIL PROTECTED] wrote: The way i want this to work - any user on our

Re: [rt-users] Error with ACL?

2007-11-30 Thread Max Clark
:) Fantastic! So I guess this means that I get to learn alot about the internals of RT as I prepare a large patch. On Nov 30, 2007 11:50 AM, Kenneth Crocker [EMAIL PROTECTED] wrote: Max, Well, good news for you, ModifyTicket also inherits CommentOnTicket and I think even

Re: [rt-users] Warnings when replying to a ticket

2007-11-30 Thread Jesse Vincent
Thanks! Applied. On Thu, Nov 29, 2007 at 08:09:14AM +0100, Dirk Pape wrote: Hello, --Am 29. November 2007 00:41:12 -0500 schrieb Jesse Vincent [EMAIL PROTECTED]: Nope. They're cases where perl has gotten smarter and stricter about possibly sloppy coding. Until relatively recently, a

[rt-users] RT related Postgres question

2007-11-30 Thread Mark Chappell
This is possibly slightly OT, if so I apologize. I'm most of the way through getting RT to behave under postgres, however I seem to be hitting a problem with the query optimizer. When RT tries to pull out the ticket history for a user it runs the following query SELECT DISTINCT main.* FROM

[rt-users] attachments on reply

2007-11-30 Thread Holger Haase
Hi all, Is there any way forwarding attachments when replying in addition to store them in the ticket? I use RT3.4.6 Thanks in advance, ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users SAVE THOUSANDS OF DOLLARS ON RT SUPPORT: If

Re: [rt-users] Searching by Custom Fields

2007-11-30 Thread Kevin Squire
On Thu, 29 Nov 2007 16:46:05 -0500 Jen Scales [EMAIL PROTECTED] wrote: I apologize in advance if this question has already been asked as I have not found a quick way to search the archives Since someone already answered your main question, I figured I would answer this one. I like to use

Re: [rt-users] Is lib/RT/Queues_Overlay.pm AddRecord a bug?

2007-11-30 Thread Todd Chapman
In more versions of RT 3.6.x (all?) you can customizer per-user what queues show up under Quick Search. This would be much better than trying to monkey with rights. On 11/30/07, Jan Grant [EMAIL PROTECTED] wrote: Looking for an appropriate way to get the following behaviour, being stymied by

Re: [rt-users] Error with ACL?

2007-11-30 Thread Todd Chapman
Max, I just reviewed the relevant RT code: sub Correspond { my $self = shift; my %args = ( CcMessageTo = undef, BccMessageTo = undef, MIMEObj = undef, Content = undef, TimeTaken= 0, @_ );

[rt-users] Missing Links in 10 highest priority tickets I own

2007-11-30 Thread Christian Gueder
Dear friends, We are using RequestTracker in our IT environment now for over a year and it really rocks! Unfortunately, to enhance the usability of RT, i modified the saved search named [_1] highest priority tickets I own as follows: Owner = '__CurrentUser__' AND (Status = 'new' OR Status =

[rt-users] Is lib/RT/Queues_Overlay.pm AddRecord a bug?

2007-11-30 Thread Jan Grant
Looking for an appropriate way to get the following behaviour, being stymied by the return unless $Queue-CurrentUserHasRight('SeeQueue'); line. Basically: we have teams here. We're using RT predominantly internally to manage inter-team requests (to stop them getting dropped on the floor).

[rt-users] HasRight called with no valid object

2007-11-30 Thread Emmanuel Lacour
Ehlo, I have this curious message when running the follwing script on rt 3.6.3/RH4/Oracle9/DBIx::SearchBuilder 1.49 (with patch groupclause): [crit]: HasRight called with no valid object (/pkg/rt/rt/lib/RT/Principal_Overlay.pm:321) It happen many times for SetPrivileged(0), but at the end, the

Re: [rt-users] Error with ACL?

2007-11-30 Thread Kenneth Crocker
Max, Well, good news for you, ModifyTicket also inherits CommentOnTicket and I think even DeleteTicket. Kenn LBNL On 11/30/2007 11:14 AM, Max Clark wrote: Why would it be considered a bug? Wouldn't the person making changes be a person of interest? Wouldn't any person of interest want to

Re: [rt-users] Error with ACL?

2007-11-30 Thread Kenneth Crocker
Max, Why would it be considered a bug? Wouldn't the person making changes be a person of interest? Wouldn't any person of interest want to know what is going on about a ticket? Kenn LBNL On 11/30/2007 10:26 AM, Max Clark wrote: Isn't this a bug? Or is it really intended for ModifyTicket

Re: [rt-users] What is WebNoAuthRegex ?

2007-11-30 Thread Nicolas Chuche
Okay, I'm not sure whether I need to use it or not, but I'd like to find out what WebNoAuthRegex does and/or how it would be used. If an URL matches $WebNoAuthRegex, it doesn't require authentication The default is fixed in RT_Config.pm : # WebNoAuthRegex - What portion of RT's URLspace

Re: [rt-users] Change Default Sort of Top Ten Tickets

2007-11-30 Thread Max Clark
Thank you - giving the user rights to see their preferences helped. On Nov 30, 2007 12:56 PM, Mathew [EMAIL PROTECTED] wrote: Under Preferences-RT at a glance are the settings for the widgets which show ticket lists. You can edit the display and sort order for each one under this view.