Re: [rt-users] Adding CC's from an email as Watchers on Create Ticket

2010-07-21 Thread Jason A. Smith
On Thu, 2010-07-22 at 12:42 +1000, Alan Deadman wrote: > Hi > > Most of my tickets are created via emails to the RT system. When this > happens, the CC's from the email are not automatically added as > Watchers. > > Is this possible to change? Hi Alan, I wrote a custom scrip to do this many yea

[rt-users] RT 3.8.8 New Installation

2010-07-21 Thread VPN Cluster
Hello, I am performing my first installation of RT 3.8.8 on Redhat 5.0. I`ve looked around and there are multiple resources that kind of confusing reading several of them. I would like if you guys refer me to a possible step by step guide.. I am using Oracle as back end.. Thanks Discover RT's h

[rt-users] Adding CC's from an email as Watchers on Create Ticket

2010-07-21 Thread Alan Deadman
Hi Most of my tickets are created via emails to the RT system. When this happens, the CC's from the email are not automatically added as Watchers. Is this possible to change? Many thanks in advance. Regards Alan Deadman a.dead...@aerocare.com.au Attention: The contents of this email and an

Re: [rt-users] Mysql queries slow

2010-07-21 Thread Foggi, Nicola
with no real mysql tweaking on RT 3.8.8 I get: mysql> select count(id) from Attachments; +---+ | count(id) | +---+ | 41636 | +---+ 1 row in set (0.62 sec) while significantly less that yours, .62 seconds isn't too shabby... -Original Message- From: rt-user

[rt-users] Mysql queries slow

2010-07-21 Thread William Graboyes
Hi List, As an example of what I am talking about the query `select count(id) from Attachments;` The returned result is 174039, but it takes 39.1549 seconds to return that simple query. The Transactions table returns 343259 in .4358 seconds. Does anyone have some optimization tips beyond what

Re: [rt-users] Shred more than 10 per rt-shredder run?

2010-07-21 Thread Peter Murfitt
Looks like "limit,100;" might be your answer? rt-shredder --plugin "Tickets=query,Status = 'Deleted' AND LastUpdated < '30 days ago';limit,100" --sqldump /{somepath}/shredder-restore-tickets.sql Might contain your answer - found that http://wiki.bestpractical.com/view/Shredder Peter On 21 Jul

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread Kenneth Crocker
Jeff, Sounds good to me. Kenn On Wed, Jul 21, 2010 at 11:04 AM, James Berwick wrote: > On 7/21/2010 1:46 PM, Kenneth Crocker wrote: > >> Jeff, >> >> Not if I'm not supposed to. So what if there aren't 10 unowned tickets in >> the list? As a matter of security, I sure wouldn't want someone looki

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread Peter Murfitt
I think this is very similar to what Justin was saying a couple of weeks ago: http://lists.bestpractical.com/pipermail/rt-users/2010-July/065538.html Though it looked like that bug was fixed by 3.8.8 On 21 Jul 2010, at 19:04, James Berwick wrote: > On 7/21/2010 1:46 PM, Kenneth Crocker wrote: >

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread James Berwick
On 7/21/2010 1:46 PM, Kenneth Crocker wrote: Jeff, Not if I'm not supposed to. So what if there aren't 10 unowned tickets in the list? As a matter of security, I sure wouldn't want someone looking at sensitive payroll info on requests in the Payroll Queue if they aren't even allowed to have a

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread Kenneth Crocker
Jeff, Not if I'm not supposed to. So what if there aren't 10 unowned tickets in the list? As a matter of security, I sure wouldn't want someone looking at sensitive payroll info on requests in the Payroll Queue if they aren't even allowed to have access to the payroll Queue. Kenn LBNL On Wed, Ju

[rt-users] Shred more than 10 per rt-shredder run?

2010-07-21 Thread Jeff Blaine
I searched around and couldn't find the answer. How does one override the default 10 object threshold with rt-shredder? Using RT 3.8.7 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread Jeff Voskamp
On 07/21/2010 12:50 PM, Kenneth Crocker wrote: Mark, It's just my opinion, but I like that logic. If I don't want someone to see tickets in a certain Queue, why would I want them to see "unowned" tickets in that same Queue? I wouldn't want that to change. Kenn LBNL No, but you may still wan

Re: [rt-users] Prioritizing Scrips

2010-07-21 Thread Kenneth Crocker
Greg, Hopefully, you remembered to enable "TransactionBatch" and set your stage to that. Kenn LBNL On Tue, Jul 20, 2010 at 2:12 PM, Greg Curiel wrote: > > Hello, > > Does anyone know of a way to prioritize which scrips get run first? I'm > having a problem with a scrip that relies on another

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread Kenneth Crocker
Mark, It's just my opinion, but I like that logic. If I don't want someone to see tickets in a certain Queue, why would I want them to see "unowned" tickets in that same Queue? I wouldn't want that to change. Kenn LBNL On Wed, Jul 21, 2010 at 8:45 AM, Mark Jenks wrote: > I have an issue I am t

Re: [rt-users] 10 newest unowned tickets

2010-07-21 Thread Kenneth Marshall
You will need to enable using SQL for ACLs in RT_SiteConfig.pm. It is beta/testing so buyer beware... Ken On Wed, Jul 21, 2010 at 10:45:48AM -0500, Mark Jenks wrote: > I have an issue I am trying to figure out. > > > > The default search for unowned tickets is: > > Owner = 'Nobody' > > AND

[rt-users] RT 3.8.7 + Kerberos Authentication + LDAP Authorization

2010-07-21 Thread Scott Sears
I've been trying to figure out how to best configure my RT authentication/authorization. We are running RT 3.8.7 and use the RT database (MYSQL) to store RT user information (but not passwords). We have a Kerberos KDC which stores passwords and provides single-sign-on authentication across all

[rt-users] 10 newest unowned tickets

2010-07-21 Thread Mark Jenks
I have an issue I am trying to figure out. The default search for unowned tickets is: Owner = 'Nobody' AND ( Status = 'new' Or Status = 'open') But it doesn't show everything for non system-admins. (i.e. people that can't see all of the queues) If I specify a queue, it works

[rt-users] RT 3.8.8, Apache, and FastCGI memory leak?

2010-07-21 Thread Joshua West
Hey folks, We've currently upgraded to RT 3.8.8 on RHEL 5 64-bit. We've deployed with Apache 2.2.3 (RHEL supplied), mod_fastcgi 2.4.6. Unfortunately, about 1-2x a day, the mason_handler.fcgi processes will progressively grow in memory consumption from running at about 90MB each to 1-3GB each, an

Re: [rt-users] Moving RT Database to remote host

2010-07-21 Thread Andrea Perotti
Il 21/07/2010 10:48, ronald higgins ha scritto: > Once i've imported the RT Data into the new remote DB how would i go > about pointing the current > RT web app to the remote MySQL Instance ? In the same place you configured during the install: RT_SiteConfig Doublecheck the connectivity between y

[rt-users] Moving RT Database to remote host

2010-07-21 Thread ronald higgins
Hi RT Users, I currently have an RT Deployment, the web app and mysql db lives on the same machine. However, because Centos currently does not support a MySQL Server Version that supports partitioning I would like to move the DB to a remote host with MySQL 5.1 installed. Once i've imported the RT

[rt-users] CLI: Server error: Proxy Authorization Required (407)

2010-07-21 Thread Ingo . Itter
Hello, i try to create a new ticket via the CLI but i've got an Error. Here the settings of my .rtrc : server http://10.20.x.xx/ < the lokal adress of the Server user passwd If i do "/opt/rt3/bin/rt create -t ticket" i receive : rt: Server error: Proxy Authorization Required (407)

[rt-users] Customization / Callback Question for "Ticket/Elements/Tabs".

2010-07-21 Thread Nehmer Torben
Good morning, I am currently trying to customize RTs Action Listing in the top of the Ticket Display (Comment, Correspond, Forward, Resolve). I am using callbacks, but they do not invoke as expected. As a basic idea I have been using the example of Dirk Pape, specifically http://page.mi.fu-ber

Re: [rt-users] Requiring a Subject on new ticket?

2010-07-21 Thread G.Booth
On Tue, 20 Jul 2010 14:44:16 -0400 Juan Mas wrote: When someone submits a new ticket through e-mail is there a way force them to add a subject or the ticket won't be created? We're running RT 3.8.7 Hi Juan This extension seems to work ok: http://search.cpan.org/dist/RT-Extension-Mandatory