[rt-users] rt 3.4.5 : apache load sometimes climbs to 100%

2006-12-06 Thread Robert Grasso
Hello, I installed RT v3.4.5 on CentOS 4.4 with yum. Opening a ticket takes 1 or 2 seconds. But after having performed a search, opening the first ticket makes Apache load the cpu to 100% for roughly 30 seconds ! Then the ticket displays normally. Further tickets opened from the same page take

[rt-users] RT 3.6 error and IE6

2006-12-06 Thread Tomas Olaj
Hello, We are entering production phase next week on 3.6.1, but we noticed a problem among Internet Explorer version 6 users (yes, there are some of these at our university), ;), where they are getting an Error on page error-message in browser trying to _open_ a ticket in RT 3.6.1. This

Re: [rt-users] performance question

2006-12-06 Thread Filip RembiaƂkowski
Ruslan Zakirov napisaƂ(a): Could you spend some time and write instructions about how to create such report? :) sure. 1) login to rt (probably ou want to login as root, to see all queues) 2) enable logging of all SQL queries. - for postgresql you can do it by putting these lines in your

[rt-users] Permission denied Problem

2006-12-06 Thread Tobias Heinz
Dear All, I am running an rt installation (3.4 on Debian, with seperate postgres backend) for about a year now. Currently I have around 50 call centre agents working on tickets submitted by a community of around 100.000 clients. I have set-up the system to allow creation of tickets for everyone

Re: [rt-users] Calendar view of tickets?

2006-12-06 Thread Jim Brandt
Torsten, I used the following modules that you'll need to install from CPAN: * HTML::CalendarMonth (I think this has some dependencies like HTML::Element, etc. Just follow them and install all dependencies.) * Date::Calc Also, I should mention I got this working on 3.6.1. I think it could

Re: [rt-users] Calendar view of tickets?

2006-12-06 Thread Torsten Brumm
Argh, no.. 2006/12/6, Jim Brandt [EMAIL PROTECTED]: When I run it, for the month I pick, it shows links with the ticket subject in the day indicated by the due date on the ticket. Do your tickets have due dates? Torsten Brumm wrote: Hi Jim, OK, now it works. But it renders only a

Re: [rt-users] What kind of hardware setup are you using?

2006-12-06 Thread Vivek Khera
On Dec 5, 2006, at 5:24 PM, John Arends wrote: How do you all handle backups/DR? Is anyone else running RT in a virtual machine? We use a live replication system to keep the DB up-to-the-second on another DB server. If the main DB dies, we just failover and point RT at the backup. We

[rt-users] Removing garbage from mail replies

2006-12-06 Thread [Mailclub] - Laurent Bauer
Hello, I searched the wiki and mailing list archives, but couldn't find a solution to do that : - when RT sends an e-mail, add a line like [Reply below this line] - when a user replies to the mail, only log the text added below That way, the recipient keeps getting a normal e-mail

Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

2006-12-06 Thread Jesse Vincent
On Dec 6, 2006, at 2:18 AM, Torsten Brumm wrote: Hi Jesse, i've checked the permissions twice, apache is running as user/group apache and has more permission in that directory as needed. I played around a bit and came now to the point, that it works with fucking IE7 but not in NS7, NS8

RE: [rt-users] Calendar view of tickets?

2006-12-06 Thread Jared Hanks
I had the same problem, it was only displaying tickets with that have a Due date. I changed Calendar and SelectCalendar.html to search for Created, not Due, and it display the tickets the way I wanted. Date: Wed, 6 Dec 2006 17:12:30 +0100From: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Re:

[rt-users] including custom fields in a template

2006-12-06 Thread Dan Parsons
I want to include the value of 3 custom fields in the template used for emailing admins when a ticket is created. The custom fields are named Linux computer name, Impact and Deadline ... What exactly is the syntax for this? Especially for a field with spaces in its name? Dan Parsons Sr.

Re: [rt-users] Calendar view of tickets?

2006-12-06 Thread Torsten Brumm
Just an idea, let us try to make it more flexible, just as an option to select all (makes not the most sense) and Starts and Due, also a view for Reminder entries could be great. i'm just playing around to make the queue selection more flexible...hopefully i can sent tomorrow some files. Torsten

Re: [rt-users] RT hangs with 'SELECT GET_LOCK' slow query log entries

2006-12-06 Thread Torsten Brumm
Any chance to figure out more details? I can test a lot and i have played around a lot, this relogin occurs until i pressed the first Time the Tools link, afterwards it is finished and the worst part, i have the same situation under each Firefox and NS Browser Will try more tomorrow...

RE: [rt-users] RT 3.6.1 stops sending out emails

2006-12-06 Thread Les Driggers
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harald Kapper Sent: Wednesday, December 06, 2006 8:58 AM To: rt-users@lists.bestpractical.com Subject: [rt-users] RT 3.6.1 stops sending out emails Hi he've a perfectly working RT 3.6.1 (on

[rt-users] Query Questions

2006-12-06 Thread beilman
I have been asked to see if I can get RT to show the Ticket Content, using the basic Query Builder tool. In the actual query results window, I need to show the initial part of the request. I know I can do this via an outside Perl script, or using the Rt command line, but I am trying to do it

[rt-users] Reply to stalled tickets

2006-12-06 Thread Peer Michael
Greetings I am using rt-3.4.5. My problem is, when i reply to a stalled ticket and i don't want change the status, the rt-system set the status to open. I know, that the reason of this is the autoopen-script. But i don't understand, why rt-2.0.4, the system that i used before, Doesn't do that,

Re: [rt-users] Query Questions

2006-12-06 Thread Todd Chapman
On Wed, Dec 06, 2006 at 03:10:10PM -0500, beilman wrote: I have been asked to see if I can get RT to show the Ticket Content, using the basic Query Builder tool. In the actual query results window, I need to show the initial part of the request. I know I can do this via an outside Perl

Re: [rt-users] Query Questions

2006-12-06 Thread beilman
I think so, inside html/Elements/RT__Ticket/ColumnMap I see references to things like LastUpdated = { attribute = 'LastUpdated', title = 'Last Updated', value = sub { return $_[0]-LastUpdatedObj-AsString } }, So I need to figure out how to reference what I

Re: [rt-users] Query Questions

2006-12-06 Thread Todd Chapman
On Wed, Dec 06, 2006 at 04:26:04PM -0500, beilman wrote: I think so, inside html/Elements/RT__Ticket/ColumnMap I see references to things like LastUpdated = { attribute = 'LastUpdated', title = 'Last Updated', value = sub { return

[rt-users] Can't view newly created ticket

2006-12-06 Thread Winn Johnston
This just started happening, no changes were made to the system. mysql v 4.01 apache2 Is there something i can check in the ACL table? snip from rt.log Wed Dec 6 23:36:03 2006] [info]: [EMAIL PROTECTED] #6421/28782 - Scrip 2 (/opt/rt3/lib/RT/Action/SendEmail.pm:237) [Wed Dec 6 23:36:03

[rt-users] RT/Opera Text alignment problem

2006-12-06 Thread Tim Rosmus
Seems to be a bug in all Opera 9.x (any OS) that causes nested DIVs to be centered. The headers for each history entry are correct, but the actual ticket history content is all centered, making it a pain to read. Has anybody seen this and/or have a fix or is this a problem with Opera, Thanks.

[rt-users] Shredder Users plugin error about invalid characters

2006-12-06 Thread Mathew Snyder
I have a script that gathers up all the newest spam users created over the course of a day and iterates over each one calling rtx-shredder with the Users plugin. It occassionaly spits out an error thusly: Couldn't load plugin Error: Invalid characters in email '[EMAIL PROTECTED]' The email

Re: [rt-users] Pulling CustomFieldValues

2006-12-06 Thread Mathew Snyder
Stephen Turner wrote: -Original Message- From: Mathew Snyder [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 4:29 AM To: [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Pulling CustomFieldValues Steve, This is the code I now