Re: [rt-users] Queue change transactions

2007-07-11 Thread Forrest Blount
In transactions, when Field=Queue, the OldValue will capture the Queue number of the old queue (where the NewValue captures the new Queue number). Is that enough for you to write a scrip that grabs the old Queue value? Stephen Turner wrote: I have a customer (queue administrator) who would

Re: [rt-users] track number of tickets by a user or email address

2007-07-11 Thread Gene LeDuc
Hi Akila, This would probably be pretty easy to do with a cron script (sending a report or triggering an action once a day). Using RT's API and perl, you could just query for all tickets in a specific queue, then sort the results by creator, then use those results to match your 10 criteria.

Re: [rt-users] Problem customising RT at a glance global config

2007-07-11 Thread Jesse Vincent
On Jul 11, 2007, at 4:34 AM, Andrew Lewis wrote: Ok well as it turned out 3.6.4 is in Blastwave testing already so I installed that. Error message generated looks very similar (txt file attached). May be pertinent to mention that the data is from a 3.2.1 system which has been upgraded

Re: [rt-users] Queue change transactions

2007-07-11 Thread Gene LeDuc
I'd vote for a global scrip and trigger on the transaction Type and OldValue. At 07:59 AM 7/11/2007, Stephen Turner wrote: At Wednesday 7/11/2007 10:52 AM, Forrest Blount wrote: In transactions, when Field=Queue, the OldValue will capture the Queue number of the old queue (where the NewValue

[rt-users] Cron Issues....

2007-07-11 Thread Jeff Stark
Hello everyone... RT 3.6.3, RHEL, Oracle DB. I have a cron job I created in cron.hourly...its pretty simplistic and the command works great when I run it directly. Being very new to Linux, I was hoping one of you may notice something simple that I am missing here. #!/bin/sh

Re: [rt-users] Cron Issues....

2007-07-11 Thread Stephen Turner
At Wednesday 7/11/2007 12:06 PM, Jeff Stark wrote: Hello everyone... RT 3.6.3, RHEL, Oracle DB. I have a cron job I created in cron.hourly...its pretty simplistic and the command works great when I run it directly. Being very new to Linux, I was hoping one of you may notice something

[rt-users] RT 3.4.x and RT 3.6.x on same backend DB?

2007-07-11 Thread Kenneth Marshall
Hi RT community, In order to facilitate the testing, development and migration from our current RT 3.4.5pre1 to the RT 3.6.4 release, I would like to run both versions against the same database backend. The additional attributes that are added to the database by the etc/upgrade/3.5.1 script do

RE: [rt-users] Cron Issues....

2007-07-11 Thread Jeff Stark
The only item in /var/log/cron is: Jul 11 09:01:01 infrt01 crond[23295]: (root) CMD (run-parts /etc/cron.hourly) Is there somewhere else I should look? Thanks, -Stark -Original Message- From: Stephen Turner [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 12:22 PM To: Jeff

RE: [rt-users] Cron Issues....

2007-07-11 Thread Jeff Stark
Excellent! Had no idea...you are correct, it is Oracle Connectivity that is causing the issue. Any ideas how I solve this? I used the priority escalation script as a template. /etc/cron.hourly/RT-DemotePremier.cron: Unable to load DBIx::SearchBuilder database handle for 'Oracle'. Perhaps

Re: [rt-users] Scrip needed that automaticaly closes tickets with a special subject

2007-07-11 Thread Gene LeDuc
Hi Thomas, You create scrips like this using the RT web GUI. Go into Configuration, select Queues, then the queue that you want this scrip to apply to, then Scrips, then New Scrip. I don't think you really want to do this with perl modules. For condition, select User Defined For action,

RE: [rt-users] Cron Issues....

2007-07-11 Thread Stephen Turner
At Wednesday 7/11/2007 02:15 PM, Jeff Stark wrote: Yes, that is defined. I have tried adding .bash_profile to my script...see if that works It's been a long while since I dealt with this issue, but I used to have a file I called ~/.oracle, which set all the Oracle-related env variables. I

[rt-users] '10 highest priority tickets' no longer has links to tickets

2007-07-11 Thread Greg Petras
This was accidentally posted to rt-devel first. I should have sent it to rt-users. Please excuse my mistake. I've got a working configuration of RT 3.6.3 on Apache 2.0.59, mod_perl 2.0.3, and Perl 5.8.8. I was asked to modify the '10 highest priority tickets' section. I added 'Priority greater

[rt-users] Couldnt open File 'sessions.MYI' in /opt/rt3/var/session_data

2007-07-11 Thread John Schubert
First post didn't get a single reply, so please let me know if I'm not posting correctly. I've read the FAQs and posted on this list before. The system is a 3 year old RT (RT 3.0.4 I believe) that has been running without problems. The /var partition filled up at some point in time and this

RE: RE: [rt-users] Cron Issues....

2007-07-11 Thread Jeff Stark
Thanks, yes, actually I am expecting it to run as root. (I know bad karma to follow) But I am just trying to get it working. I have tried forcing the loading of .bash_profile and have also tried adding the following to the script: export ORACLE_BASE=/u01/app/oracle export

Re: [rt-users] Couldnt open File 'sessions.MYI' in /opt/rt3/var/session_data

2007-07-11 Thread Drew Barnes
.MYI That is the index file for the sessions table? Might it be too big? http://wiki.bestpractical.com/view/CleanupSessions John Schubert wrote: First post didn't get a single reply, so please let me know if I'm not posting correctly. I've read the FAQs and posted on this list before.

Re: [rt-users] Couldnt open File 'sessions.MYI' in /opt/rt3/var/session_data

2007-07-11 Thread John Schubert
Thanks Ole, I checked and with the standard install my database is indeed in /var. I'm playing with myisamchk to see if there's a way to restore. I asked the IT department to back this server up for years, but they've ignored me. This is the only machine I have permissions, otherwise I'd

[rt-users] RT 3.4.5 not showing transactions

2007-07-11 Thread Alex Moura
Hello, After searching the lists history and googling a lot, I turn to your wisdom that maybe can help us solve an infrequent and misterious problem that's generating lots critisicm from our manager towards RT's credibility. We've been using RT since 2001, now running RT 3.4.5 with Apache MySQL

[rt-users] Create Ticket width CustomField value using command line

2007-07-11 Thread Marco Catunda
Hi, I'd trying to create a ticket with custom field value using cli interface, but it hasn't supported yet :(. The other solution is RT API, isn't it? I've developed the following snippet code for create a simple ticket. #!/usr/bin/perl -w use lib (/usr/local/rt3.0/lib); use

Re: [rt-users] Shredder Error

2007-07-11 Thread Ruslan Zakirov
See below, note that some lines are commented. On 6/30/07, Mathew Snyder [EMAIL PROTECTED] wrote: I'm trying to remove users using the methods within Shredder. After gathering all the email addresses I need to remove I call Shredder like such: RTx::Shredder::Init( force = 1 ); my $shredder =

[rt-users] RT 3.6.4 problems

2007-07-11 Thread jmoseley
I am running RT 3.6.3 on two systems: An older Linux system using Apache 2 and Apache's mod_fastcgi module and an FC6 system with Apache 2 and mod_fcgid (an alternative to the Apache mod_fastcgi module). Both installations work just fine. Prior to installing 4.6.4, I upgraded the few Perl

Re: [rt-users] track number of tickets by a user or email address

2007-07-11 Thread Akila Amarathunga
Hi Gene, Thank you for the reply.. yeah I guess crontab is the way to go... guess i have to run it more frequently to monitor the tickets.. But if we can integrate it into RT.. i guess it'll be a very good feature.. Thanks, Akila On Wed, 2007-07-11 at 08:59 -0700, Gene LeDuc wrote: Hi Akila,