[rt-users] Concatenation of two strings in Query Builder

2009-06-16 Thread Vincent Beau
Hello, my RT config needs a dedicated queue for some users. Each of these queues is named as the following 4 (ex: for me it would be "4Vincent") I need to make a general search query giving the message list in the user's dedicated queue. Where I'm stuck is about the syntax in itself. Qu

Re: [rt-users] Organization Name Change Caused New Ticket Instead of Adding Correspondence

2009-06-16 Thread Robert Gabriel
Thank you very much, this is what I was hoping for. 2009/6/15 Ruslan Zakirov : > http://wiki.bestpractical.com/view/RenameInstance > > On Thu, Jun 11, 2009 at 7:32 PM, Robert Gabriel wrote: >> Hi all, >> >> Very new with RT and already in trouble. >> >> I upgraded from 3.4.4 to 3.8.2. Things look

[rt-users] R: R: Scrip does not send email

2009-06-16 Thread Guadagnino Cristiano
Hi, I want to let everybody know that I solved my problem: I had to change the action from "Notify requestors" to "Autoreply to requestors". Don't ask me why, but this is working wonderfully now. I'll add this to the wiki just in case someone wants to follow the same route (rejecting mail-genera

[rt-users] text/plain attachments instead of mail body

2009-06-16 Thread Guadagnino Cristiano
Hi all, I am seeing a strange behaviour of RT (3.8.4, but I'm seeing this since out first installation which was 3.8.2). I found other reports of this behaviour, but all were very old threads. Here it is: when someone sends a mail with a text/plain attachment, I see it correctly in RT; but then

[rt-users] StrictACL or StrictLinkACL?

2009-06-16 Thread Guadagnino Cristiano
Some time ago I reported a problem when merging two ticket, one of which was unowned. I got a reply from Jesse, telling me to use StrictACL=0 in SiteConfig, which indeed worked. Now I see that StrictACL is NOT documented in RT_Config.pm, while StrictLinkACL is. However, both seem to be non-funct

Re: [rt-users] Scripted modifications to RT's Database or LDAP Group Synchronization?

2009-06-16 Thread Johnathan Bell
Thanks, that works. On May 16, 2009, at 1:31 PM, Kevin Falcone wrote: > > On May 16, 2009, at 8:11 AM, Johnathan Bell wrote: > >> Ah, I was afraid that would be the answer. I suppose using the API is >> more future-ready anyway. Thanks for the clear and concise answer. It >> looks like the Perl A

[rt-users] rt-mailgate undefined server error for only one user

2009-06-16 Thread Jon Baker
I'm having a sudden problem with rt-mailgate that is extremely puzzling to me, and I'm hoping I can get some guidance as to where to look to solve this problem. I have mailgate set up on our local network so that rtq+programming-...@elmer.wgm , for example, is configured to send the incoming

Re: [rt-users] Custom SQl - RT Handle

2009-06-16 Thread Simon Lane
Does anyone know how to use the $RT->DatabaseHandle for the example below ? I really have no clue and am not sure where to look. Thanks. _ From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Simon Lane Sent: June 15, 2009 11:54

[rt-users] Announce mode - simular to MaintenanceMode

2009-06-16 Thread Elton S. Fenner
Hi folks First i would like to say thanks to the developers of RT. That said I would like to use some more knowledge of you experts. What i'm looking for is something similar to Maintenance Mode (http://wiki.bestpractical.com/view/MaintenanceMode) but *not* lock the access to the RT SelfServic

[rt-users] How ACL/E info needed and question about accessing a queue in Perl API?

2009-06-16 Thread Johnathan Bell
I'm trying to modify some ACL's from a script. In particular, the user- created group access rights for queues. Looking at the database, and docs, it seems that ACE's only reference PrincipalID's. My first question is, is what I just said true? Second, does the Id() function of many (all?) ob

Re: [rt-users] How ACL/E info needed and question about accessing a queue in Perl API?

2009-06-16 Thread Ruslan Zakirov
On Tue, Jun 16, 2009 at 7:14 PM, Johnathan Bell wrote: > I'm trying to modify some ACL's from a script. In particular, the user- > created group access rights for queues. Looking at the database, and > docs, it seems that ACE's only reference PrincipalID's. Example of adding ACL you can find in li

Re: [rt-users] Large attachments - how to warn user before dropped

2009-06-16 Thread samir marhoum
Hi, Can anyone answer my request ? please. > > I need the changes made to Create.html to notify users that the attachment > has not been added because it exceeds the Max size. > > Thanks in advance. > > For the Update.html, I used the code from Eric Shultz and it works fine. > > My RT version is 3

[rt-users] Set QueueId on Owner Change if new owner in other Queue

2009-06-16 Thread Ken Crocker
To List, I'm thinking of writing a scrip that would automatically change the QueueID of a ticket if it was taken/stolen by a user of a different queue. Has anyone ever done anything like this? Does anyone have any ideas? Thanks. Kenn LBNL ___ http:

[rt-users] rt-mailgate undefined server error for only one user

2009-06-16 Thread Jon Baker
I've narrowed it down to the Create Ticket command in Email.pm: my ( $id, $Transaction, $ErrStr ) = $Ticket->Create( Queue => $SystemQueueObj->Id, Subject => $Subject, Requestor => \...@requestors, Cc=> \...@cc,

Re: [rt-users] StrictACL or StrictLinkACL?

2009-06-16 Thread Kevin Falcone
On Jun 16, 2009, at 9:12 AM, Guadagnino Cristiano wrote: > Some time ago I reported a problem when merging two ticket, one of > which was unowned. > I got a reply from Jesse, telling me to use StrictACL=0 in > SiteConfig, which indeed worked. > Now I see that StrictACL is NOT documented in RT_

Re: [rt-users] Requestor eMail

2009-06-16 Thread Kevin Falcone
On Jun 15, 2009, at 12:17 PM, rmp dmd wrote: > Is there a way to ignore (do not create ticket, do not send auto- > reply) request from mailer_dae...@domain.com? Filter it before it gets to rt-mailgate, otherwise once you get to Scrips, the ticket has already been created. I believe someone e

Re: [rt-users] Concatenation of two strings in Query Builder

2009-06-16 Thread Kevin Falcone
On Jun 16, 2009, at 6:51 AM, Vincent Beau wrote: > my RT config needs a dedicated queue for some users. > > Each of these queues is named as the following 4 (ex: for me > it would be "4Vincent") > > I need to make a general search query giving the message list in the > user's dedicated queue. > >

Re: [rt-users] Question re: RT-Extension-CommandByMail

2009-06-16 Thread Kevin Falcone
On Jun 12, 2009, at 1:51 PM, GravyFace wrote: > Looks like using CommandByEmail is going to be extremely useful > (especially for setting ownership of tickets), but I have a couple of > questions: > > 1. is it stable under 3.8.2? Yes. Just make sure you have the latest version so it installs pr

Re: [rt-users] enable ability to forward tickets

2009-06-16 Thread Kevin Falcone
On Jun 12, 2009, at 4:57 AM, Bashir Jahed wrote: > I am trying to enable the forward option on tickets, it is available > on one of our rt systems but not the other. It appears with the > reply / comment options above the ticket body. Have you granted the ForwardMessage right? -kevin _

Re: [rt-users] It is posible to see custom fields in SelfService area for unprivileged users?

2009-06-16 Thread Kevin Falcone
On Jun 11, 2009, at 10:50 AM, Julio Kalizsky (Defensoría General de la Nación) wrote: > Hi All, > > It is posible to see custom fields in SelfService area for > unprivileged users? > If yes How? Yes, many installations are doing it. > I was looking on the wiki and google but I could don't

Re: [rt-users] rt-mailgate undefined server error for only one user

2009-06-16 Thread Kevin Falcone
On Jun 16, 2009, at 4:24 PM, Jon Baker wrote: > I've narrowed it down to the Create Ticket command in Email.pm: > > my ( $id, $Transaction, $ErrStr ) = $Ticket->Create( > Queue => $SystemQueueObj->Id, > Subject => $Subject, > Requestor => \...@req

[rt-users] Arguments to callbacks?

2009-06-16 Thread ravi
Hello all, any documentation on what is passed into a Callback? I am mostly Googling the Callbacks I am interested in to figure out, using examples others have provided, what the arguments may be, but that only works so far. I also have the RT Essentials book, but that has no mention of C

Re: [rt-users] Arguments to callbacks?

2009-06-16 Thread Kevin Falcone
On Jun 16, 2009, at 5:19 PM, ravi wrote: > any documentation on what is passed into a Callback? I am mostly > Googling the Callbacks I am interested in to figure out, using > examples others have provided, what the arguments may be, but that > only works so far. I also have the RT Essentials book,

[rt-users] Outgoing SMTP - e-mails not received

2009-06-16 Thread Elias K
Hi All! Rt 3.8.2. on Solaris10 (x86). I have configured (as I thought) RT to use an SMTP server for all outgoing e-mail correspondence. Set($MailCommand, 'smtp'); Set($SMTPServer, 'mailhost'); Set($SMTPDebug, 'true'); Set($SMTPFrom, 'x...@xx.com'); The mailhost (Linux on x86) is reachable

Re: [rt-users] rt-mailgate undefined server error for only

2009-06-16 Thread Jon Baker
Thanks, Kevin - I did run the make testdeps and have the following missing dependencies: SOME DEPENDENCIES WERE MISSING. FASTCGI missing dependencies: CGI::Fast...MISSING FCGI...MISSING SQLITE missing dependencies: DBD::SQLite >= 1.00...MISSING I'm not using Fast CGI or S

[rt-users] Question on custom scrip condition

2009-06-16 Thread Kevin Gagel
My users don't want to use priorities so they've had me create 4 levels for urgency. They only want to be notified by email on an item that has the highest urgency level set. So I want to setup a custom condition that tests for that level and then sends an email to the user if that specific leve

Re: [rt-users] Arguments to callbacks?

2009-06-16 Thread ravi
On Jun 16, 2009, at 5:33 PM, Kevin Falcone wrote: > On Jun 16, 2009, at 5:19 PM, ravi wrote: > >> any documentation on what is passed into a Callback? I am mostly >> Googling the Callbacks I am interested in to figure out, using >> examples others have provided, what the arguments may be, but that

[rt-users] Slow querys - can I speed this up?

2009-06-16 Thread Jon Baker
RT frequently acts sluggish (this may or may not be related to my other thread about mailgate timing out) so I've turned on the slow query log in mySQL, and am getting this error quite frequently: # Query_time: 160.388061 Lock_time: 0.000103 Rows_sent: 1 Rows_examined: 930035 SET timestamp

Re: [rt-users] Question on custom scrip condition

2009-06-16 Thread Ken Crocker
Kevin, Here's one we use for when the development step of a ticket (CF "Work-State") is changed to "Review Approved": # condition execution on CF Review Process my $trans = $self->TransactionObj; my $ticket = $self->TicketObj; if ($trans->Type eq 'CustomField') {my $cf = new RT::CustomF

Re: [rt-users] Question re: RT-Extension-CommandByMail

2009-06-16 Thread GravyFace
On Tue, Jun 16, 2009 at 5:00 PM, Kevin Falcone wrote: > No, it works by parsing comments/replies for action commands that > are documented in the README. Ok, it sounds like the comment or correspondence is saved with the ticket as normal. Is this correct? If so, are the commands stripped out af