Re: [rt-users] Trying top upgrade rt3 3.6.5 database to rt4 4.0.5 database.

2012-03-16 Thread Juanjo
Any help? El 15 de marzo de 2012 09:39, Juanjo juanji...@gmail.com escribió: Hello Again. I´m trying to upgrade the old database to my new server database. And i have problems with the 1b point. 1b) Configure the new MySQL to use Latin1 as the default character set everywhere,

Re: [rt-users] MySQL Scaling for a large instance

2012-03-16 Thread David Moreau Simard
Hi ! Do you know of any successful MySQL proxy implentations with RT ? It is indeed one of the solutions we had been thinking of but it does not have a release deemed stable at this time, still in beta. Thanks, -- *David Moreau Simard* /Spécialiste TI // IT Specialist/ http://iweb.com

[rt-users] Queue change scrip not working

2012-03-16 Thread Jean-Christophe Boggio
Hello, I've created a global OnQueueChange scrip but I'd like to tell, in the message, the name of the queue the ticket was transferred to. All I have is {$Transaction-NewValue} which is numeric. How can I do the lookup ? Thanks for your help, JC

Re: [rt-users] Queue change scrip not working

2012-03-16 Thread Gerard FENELON
Hi In my template, I use my $action = Queue changed to . $Ticket-QueueObj-Name ; $Ticket-QueueObj-Name gives you the name of the NEW queue. You could also use $Transaction-Description which does all the work for you, This gives something like Queue changed from AAA to BBB by XXX

Re: [rt-users] Searching for all tickets updated yesterday by a particular user

2012-03-16 Thread 20/20 Lab
On 03/16/2012 9:35 AM, Thomas Smith wrote: Hi, I would like to search for all tickets updated yesterday by a particular user--I see the option to search Last updated by, but this will only show if a given user was the last to touch a ticket. Is there a way to search for all tickets that were

Re: [rt-users] Searching for all tickets updated yesterday by a particular user

2012-03-16 Thread Joe Harris
I wrote a bash script to accomplish this exact task. The search queries within rt only support queries against the tickets table while transactions hold all relevant info on daily updates by a particular user. When I get a chance, I'll log into my office network, sanitize the script and post

Re: [rt-users] MySQL Scaling for a large instance

2012-03-16 Thread reg.bestpractical
David, Do you know of any successful MySQL proxy implentations with RT ? You should not really use any MySQL replication-based solution for database load distribution unless application was designed with that in mind or at least adjusted to work in such architecture. This is even more true

Re: [rt-users] ExternalAuth problem

2012-03-16 Thread Kevin Falcone
On Thu, Mar 15, 2012 at 04:24:03PM -0700, Sandra Wittenbrock wrote: About 6 months ago, I set up External Auth to use the ExternalAuth, with our ldap authentication server. Recently, it stopped working. I checked the syslog, and turned up the log level, but still did not get any useful

Re: [rt-users] Database Cleaning

2012-03-16 Thread Kevin Falcone
On Fri, Mar 16, 2012 at 10:45:57PM +0100, Wiktor Cetera wrote: Is there any way to clean all database (tickets in ticket box) without using any extensions? The rt-shredder command has been core since 3.8.0, so you can use that to delete tickets. If you want to recreate the database, RT

Re: [rt-users] Searching for all tickets updated yesterday by a particular user

2012-03-16 Thread Joe Harris
Here is my script to capture yesterdays ticket updates. It can be changed as needed to meet your needs. The main thing was to get the query to capture transactions for tickets and the query is below for that.This is 2 files, the script and the email header. Script is at the top and header at