Re: [rt-users] List of privileged users

2012-06-18 Thread Tim Cutts

On 15 Jun 2012, at 17:29, Asif Iqbal wrote:

 how do I run this code with a script account which has no account on RT?
 
 Is it possible to feed a valid account/password in a .rtrc file or something 
 similar 
 that the script account will use to connect to RT and generate the report?

Your script is already running without using an account in RT, since you 
created the RT::Tickets object using $RT::SystemUser.

Tim



--
 The Wellcome Trust Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.


Re: [rt-users] Multiple queues on one email address

2012-06-18 Thread Jeff Konnen
Ok, problem solved, it was not RT-related, it was a problem in the mail
configuration.
everything works as hoped.
thanks
jeff

On Sat, Jun 16, 2012 at 2:21 AM, Kevin Falcone falc...@bestpractical.comwrote:

 On Fri, Jun 15, 2012 at 11:26:00PM +0200, Jeff Konnen wrote:
 I am using 1 email address for 3 queues.

 This is fine.

 in fetchmailrc i can only specifiy one queue for that adress. so
 tickets are created in that
 queue, that's OK.
 When I create a ticket in another queue, the user gets the message
 but when he replies (with
 the correct subject-tag and ID), I don't get the answer into RT, I
 only get a
 socalled [1]POSTMASTER-AUTO-FW of the incoming mail.

 Unfortunately, I cannot load the link you've provided.  Please provide
 the error message and the RT and fetchmail logs.

 -kevin




-- 
Jeff Konnen


[rt-users] Merging 2 RT systems

2012-06-18 Thread Joe Harris
I have 2 instances of RT running at my location.  As of last week they
are both running 4.0.5 (Postgres 8.4.11) and we would like to merge
them into one system within the next quarter.  Just to give you a
little background on the systems:

System A:  Has been running for about 9 years and has approximately
30,000 tickets

System B:  Has been running for about 1.5 years and has approximately
4,000 tickets
Also there are some specific custom fields which are heavily used.

My main question is:

What is the best method to merge the 2 systems.  I have a couple of
thoughts on what I can do to accomplish it and would like some advice.

Method 1:  Migrate System A into System B
At the time of migration, delete all tickets in System A up to the
current ticket number in System B.  This way all references within the
tickets would remain intact, the custom fields would function normally
and after manipulating the sequence numbers to start at the next id.

Method 2:  Migrate System A into System B
And add a field to the tickets table that could be searchable within
RT to cross reference old ticket number to new ticket number.  The
more I say that the more I don't like the idea.  It would definitely
make for tedious upgrades in the future.

Method 3:  There may be a method someone else has used or a written
procedure for accomplishing this that I do not know about.  I am wide
open for discussions, ideas, thoughts, etc.

Any insight would be greatly appreciated.