[rt-users] 'strange' performance bottlenecks

2006-04-10 Thread Luke Vanderfluit
Hi. We have a large RT system, consisting of nearly 40 tickets. Our set up is as follows: We have 2 machines: ticket1 (sun solaris 9) === apache 1.3.27 rt345 mysql4 client ticket2 (sun X4100 solaris 10) === mysql5 The RT instance on ticket1 is talking successfully to ticket2 and

[rt-users] RT Customizations for charity!

2006-04-10 Thread Todd Chapman
Fellow RT users, I'm trying to raise money for the Leukemia and Lymphoma Society. One idea I have for raising money is to do RT cusomtizations for donations to the cause. Here's how it would work: 1. Send me your customization idea and how much you would be willing to donate. 2. I'll evaluate

Re: [rt-users] Tools for auditing user/group permissions? (3.4.5)

2006-04-10 Thread Todd Chapman
Someone mentioned RTx::RightsMatrix, which I wrote, but it only gives you the permissions for one user, group, or role at a time. I guess it could be extended to do what you want, but depending on the number of users, groups, queues, and custom fields, this could be a very expensive (in terms of CP

RE: [rt-users] Tools for auditing user/group permissions? (3.4.5)

2006-04-10 Thread Schultz, Eric
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of JB Segal > Sent: Monday, April 10, 2006 3:04 PM > To: rt-users@lists.bestpractical.com > Subject: [rt-users] Tools for auditing user/group permissions? (3.4.5) > > Is there any good way - a built

[rt-users] Tools for auditing user/group permissions? (3.4.5)

2006-04-10 Thread JB Segal
Is there any good way - a built-in that I'm not aware of, a nice external add-on, whatever - to get a readable report on all my users and what permissions they have? I've got someone noting > > Ok, got it. But I still argue that either: > > > > 1. I should be able to see any comment I have posted

Re: Using Asterisk voicemail to generate tkt (was Re: [rt-users] RT SOAP SERVER)

2006-04-10 Thread Asif Iqbal
On Mon, Apr 10, 2006 at 03:08:37PM, Greg Talbot wrote: > Asterisk is a PBX framework, so the sky is the limit. > You could have IVR prompts that allow for validation, etc. then call a > voice to text application for the forms. Depends on how complcated it I played with Festival which does text-to

Re: [rt-users] RT in one company sending to RT in another

2006-04-10 Thread Jesse Vincent
On Mon, Apr 10, 2006 at 03:21:55PM -0400, Barry L. Kline wrote: > I have an interesting problem. > > One of my vendors uses RT, as do I. When I send a request to the > vendor, I do so through my instance of RT, putting myself (or whatever > employee made the verbal request to me) as the requ

Re: [rt-users] Searching for the To: field within RT?

2006-04-10 Thread Travis Campbell
In that case, you would have to do a SQL query: SELECT Headers FROM Attachments WHERE Headers LIKE '%To: <[EMAIL PROTECTED]>%'; If you only want this for when a new ticket was created via email (rather than for responses to those tickets), add: AND Headers NOT LIKE '%Thread-Topic: [%' Or w

RE: Using Asterisk voicemail to generate tkt (was Re: [rt-users] RT SOAPSERVER)

2006-04-10 Thread Kris Boutilier
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Asif Iqbal > Sent: Monday, April 10, 2006 1:38 PM > To: rt-users@lists.bestpractical.com > Subject: Using Asterisk voicemail to generate tkt (was Re: > [rt-users] RT SOAPSERVER) > > On Mon, Apr 10,

RE: [rt-users] Searching for the To: field within RT?

2006-04-10 Thread Schultz, Eric
> -Original Message- > From: Travis Campbell [mailto:[EMAIL PROTECTED] > Sent: Monday, April 10, 2006 1:18 PM > To: Schultz, Eric > Cc: rt-users@lists.bestpractical.com > Subject: Re: [rt-users] Searching for the To: field within RT? > > Schultz, Eric wrote: > >> Why not have sendmail/pos

[rt-users] Spontaneous Logouts and Mason Errors

2006-04-10 Thread Davin Flatten
I am getting the following errors in my Apache log accompanied by spontaneous logouts forcing users to log back in after they have already authenticated: [Mon Apr 10 15:26:45 2006] [error] [client xxx.xxx.xxx.xxx] FastCGI: server "/www/webapps/rt3/bin/mason_handler.fcgi" stderr: \tHTML::Mason

Using Asterisk voicemail to generate tkt (was Re: [rt-users] RT SOAP SERVER)

2006-04-10 Thread Asif Iqbal
On Mon, Apr 10, 2006 at 12:52:28PM, Mustafa Badawi wrote: > Hello all > > I have used asterisk voice mail to create tickets in rt but have not been Care to share on the steps to have voicemail/voice to create a ticket? I am in the process of tetsing out asterisk so even if it is just for asterisk

[rt-users] RT in one company sending to RT in another

2006-04-10 Thread Barry L. Kline
I have an interesting problem. One of my vendors uses RT, as do I. When I send a request to the vendor, I do so through my instance of RT, putting myself (or whatever employee made the verbal request to me) as the requester and the vendor's mailgate address as a CC:. The vendor gets a ticke

Re: [rt-users] Searching for the To: field within RT?

2006-04-10 Thread Travis Campbell
Schultz, Eric wrote: Why not have sendmail/postfix log which mails come to those address? Or have a scrip that changes the subject, sets a custom field, moves it to a "legacy" queue, or emails you when you get an email sent to such an address? Because I'm just looking for the tickets. This

RE: [rt-users] Searching for the To: field within RT?

2006-04-10 Thread Schultz, Eric
> Why not have sendmail/postfix log which mails come to those address? > > > Travis Campbell wrote: > > Hello, > > > > Is there an easy way to search for an email address that has a > > specific To: > > address? > > > > Here's why I want to do this: > > > > I have RT set up so that isRTAddress()

Re: [rt-users] Searching for the To: field within RT?

2006-04-10 Thread Drew Barnes
Why not have sendmail/postfix log which mails come to those address? Travis Campbell wrote: Hello, Is there an easy way to search for an email address that has a specific To: address? Here's why I want to do this: I have RT set up so that isRTAddress() recognizes some of our legacy suppor

[rt-users] Searching for the To: field within RT?

2006-04-10 Thread Travis Campbell
Hello, Is there an easy way to search for an email address that has a specific To: address? Here's why I want to do this: I have RT set up so that isRTAddress() recognizes some of our legacy support addresses that we've been required to keep for non-technical reasons. I'm trying to find out wh

Re: [rt-users] Earliest Postgres Support

2006-04-10 Thread Vivek Khera
On Apr 8, 2006, at 9:32 PM, Mathew Snyder wrote: We are currently using v3.0.9 with a Postgres database. Someone around here said that the two had to be "shoehorned" together because v3.0.9 doesn't support Postgres. Is this correct? Take that shoehorn and hit the guy upside the head with

Re: [rt-users] On Owner Change not working

2006-04-10 Thread Keith Edmunds
At the risk of being boring or irritating, can anyone suggest any steps I can take to try to isolate the problem detailed below? I've removed all customisation; I've tried reassigning from various users to various other users; I've even tried setting NotifyActor to 1 (although it shouldn't be nece

[rt-users] Problems Installing RTx-Shredder

2006-04-10 Thread Michael Erana
Ok... This isn't as cut and dried as the title suggests... First of the environmental information: Perl v5.8.7 under linux RT v3.4.4; Running under Debian Stable Apache2 Fastcgi Also it is running in a multi-instance mode. I've created a directory called /usr/loca/rtinst/<> that contain what wo

[rt-users] RT - Test performance (I) (fwd)

2006-04-10 Thread Tomas Olaj
This test performance was done by our Postgres DBA Rafael Martinez. I am translating this so You can agree or disagree if this makes sense or not. Adding indexes can for sure improve performance. -- Tomas A. P. Olaj, ema

Re: [rt-users] Performance problem with SG-clusteren and postgres 8.0.7

2006-04-10 Thread Jesse Vincent
On Mon, Apr 10, 2006 at 02:37:45PM +0200, Tomas Olaj wrote: > On the marvelous Mon, 10 Apr 2006, Ruslan Zakirov wrote kindly to me ... > > http://archives.postgresql.org/pgsql-performance/2006-02/msg00089.php > > A proposal from the PostgreSQL developers how this SQL can be improved. I believ

Re: [rt-users] Performance problem with SG-clusteren and postgres 8.0.7

2006-04-10 Thread Tomas Olaj
On the marvelous Mon, 10 Apr 2006, Ruslan Zakirov wrote kindly to me ... This is one of the most problematic query in RT. I only can confirm that the first plan (on Pg 7.x) is almost optimal one (there is still way to optimize it with planner) and this is plan we wanted to achive when were chang

Re: [rt-users] Performance problem with SG-clusteren and postgres 8.0.7

2006-04-10 Thread Tomas Olaj
On the marvelous Mon, 10 Apr 2006, Ruslan Zakirov wrote kindly to me ... This is one of the most problematic query in RT. I only can confirm that the first plan (on Pg 7.x) is almost optimal one (there is still way to optimize it with planner) and this is plan we wanted to achive when were chang

Re: [rt-users] Performance problem with SG-clusteren and postgres 8.0.7

2006-04-10 Thread Ruslan Zakirov
This is one of the most problematic query in RT. I only can confirm that the first plan (on Pg 7.x) is almost optimal one (there is still way to optimize it with planner) and this is plan we wanted to achive when were changing this query in RT-3.4.5. I hope Pg 8.1.4 would be available soon and we

[rt-users] Performance problem with SG-clusteren and postgres 8.0.7

2006-04-10 Thread Tomas Olaj
Just translating a message from our DBA Rafael Martinez, --> We have a huge problem ahead of us which may delay our Service Guard Cluster project. Our last performance test with our new cluster and RT shows that we have a SQL statement that 'planner" in Postgres 8.0.7 doesn't manage to find

[rt-users] RT SOAP SERVER

2006-04-10 Thread Mustafa Badawi
Hello all I have used asterisk voice mail to create tickets in rt but have not been able to use rt soap server for my rt instance to communicate with my asterisk. I am using what seems to be a very old version of the soap server. Is there any similar software out there which provides the same funct