Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-22 Thread scott.dalzell
Thanks for pointing that out. i think ill try to do the API route as i cant afford to corrupt the database. Can the RT API be used to modify a database that is not being used by RT Just that my final goal is to modify a field in our Bugzilla database (also MYsql) when an RT CF is given a bug

[rt-users] Help with open ticket with email.

2013-07-22 Thread Juanjo
Hello. My system, 4.0.10 with postgreSQL on Centos 6.4 Works for all exitents users, not for new ones. Im trying to open a new ticket on RT, with a new user. The user is created and his email adress is fine. The user is a privileged users, with rights to create new tickets. The tiket is not

[rt-users] Help with

2013-07-22 Thread Juanjo
Hello. My system, 4.0.10 with postgreSQL on Centos 6.4 Im trying to open a new ticket on RT, with a new user. The user is created and his email adress is fine. The user is a privileged users, with rights to create new tickets. The tiket is not created, and the admin of rt get and email, but

[rt-users] Help Assigning Ownershp and Queue for tickets

2013-07-22 Thread Bryon Baker
I am looking for a scrip to assign a ticket to a queue and change the owner of the ticket to the owner of the queue. This will be based on two criteria One: Who is logged into the system Two: How many open tickets are open in the owners queue. Or just place the

[rt-users] Quick search for ticket # in RTIR vs. how it works in RT

2013-07-22 Thread Landon
Hello, Quick question here... In RT you can type/paste a ticket number into the little search box on the upper right beside the ticket creation dropdown and find a ticket by ticket #. In RTIR this yields no results. Is there a reason for this or can it be fixed so ticket id is included in the

Re: [rt-users] Quick search for ticket # in RTIR vs. how it works in RT

2013-07-22 Thread Kevin Falcone
On Mon, Jul 22, 2013 at 11:54:46AM -0700, Landon wrote: In RT you can type/paste a ticket number into the little search box on the upper right beside the ticket creation dropdown and find a ticket by ticket #. In RTIR this yields no results. Is there a reason for this or can it be

[rt-users] RSS feed customization

2013-07-22 Thread S P
Hi, Is there a way to include the queue name in the RSS feed of a saved search (or add it to the title or subject)? The directions at http://requesttracker.wikia.com/wiki/RssFeed reference adding strings to the dc hash, but the Results.rdf file distributed with 4.0.8 doesn't contain a dc hash

Re: [rt-users] SOS:: many mysql processes are killing RAM, why?

2013-07-22 Thread Craig Ringer
On 07/19/2013 11:42 PM, Alex Decalli wrote: I have RT 3.8 on mysql 5.1 on ubuntu 11.04. Why do I have many mysql processes they are bringing down RAM. Quite likely you have too many Apache workers with mod_perl, or too many fcgi workers if you're using fcgi. You will need to limit the number

Re: [rt-users] Custom script to set custom field value

2013-07-22 Thread Craig Ringer
On 07/20/2013 06:58 AM, m...@es-msat.org wrote: Hello! I need to create two scripts that will set a custom field value for tickets that contain New Hire: or Termination: in the subject line. I only need it for one queue and I want it to trigger when a ticket is created or moved into that

Re: [rt-users] Help with open ticket with email.

2013-07-22 Thread Craig Ringer
On 07/22/2013 10:44 PM, Juanjo wrote: Im trying to open a new ticket on RT, with a new user. The user is created and his email adress is fine. The logs say otherwise; RT is not finding this user's email in the database. Try enabling debug logging. See if you can tell why the email isn't

Re: [rt-users] RT migration to different OS

2013-07-22 Thread Craig Ringer
On 07/21/2013 01:25 PM, Asif Iqbal wrote: Hi All, I am in the process to migrate our RT from solaris 10 to ubuntu precise lts 64bit. Ubuntu precise only offers 5.5.x (http://packages.ubuntu.com/search?keywords=mysql) I am planning to migrate from RT 3.8.2 with mysql 5.0.75 to the

[rt-users] Emailing dashboards every 'n' minutes

2013-07-22 Thread Craig Ringer
Hi folks I'm considering patching RT to support emailing dashboards every 'n' minutes when they produce a non-empty result. Has anyone here already implemented anything along those lines? Would others be interested in this if I add it, or an equivalent option to email a single saved search? If