Re: [rt-users] Organization Change

2010-10-13 Thread Andrew Best
Ive written up how I recovered from this problem. See:

http://ausfestivus.wordpress.com/2010/10/13/recovering-from-a-changed-organization-value-in-request-tracker-mysql/

On 8 October 2010 23:47, Ruslan Zakirov r...@bestpractical.com wrote:

 Organization change influence links and you have to update the table in the
 DB.

 2010 10 8 08:50 пользователь Andrew Best festi...@gmail.com написал:

  Afternoon,
 
  I've just realised that an RT instance that was upgraded and migrated to
 a
  new host had a change of $Organization during the upgrade/migration.
  The list archives mention a wiki article which tells you how to fix this
 but
  I havent been able to find the article. Has anyone got a link handy?


-- 
Never be afraid to try something new. Remember, amateurs built the ark, and
professionals built the Titanic.

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

[rt-users] Update Ticket Subject on Comment/Reply

2010-10-13 Thread Andrew Best
Morning all,

Is it possible to change/update the subject on a ticket when a user comments
or replies?

At the moment the staff need to go into the ticket basics and update the
subject manually. It would save them time if they could change/fix the
subject of a ticket when they are commenting or replying to it.

cheers
Andrew

-- 
Never be afraid to try something new. Remember, amateurs built the ark, and
professionals built the Titanic.

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

[rt-users] Organization Change

2010-10-07 Thread Andrew Best
Afternoon,

I've just realised that an RT instance that was upgraded and migrated to a
new host had a change of $Organization during the upgrade/migration.
The list archives mention a wiki article which tells you how to fix this but
I havent been able to find the article. Has anyone got a link handy?

Regards
Andrew

-- 
Never be afraid to try something new. Remember, amateurs built the ark, and
professionals built the Titanic.

RT Training in Washington DC, USA on Oct 25  26 2010
Last one this year -- Learn how to get the most out of RT!

Re: [rt-users] Upgrade 3.2.2 to 3.8.7

2010-06-10 Thread Andrew Best
Exactly what I did after posting this. In combination with the Wiki entry I
posted I successfully did a test upgrade. I was mightly impressed with the
performance and the ease of the upgrade. Nice work from the people that made
it so painless. Thank you.

The only problem we had at the end was the Owner field displaying ALL
requesters in the DB. Its a privs issue though. Once I revoked all the privs
and set them up again from scratch the problem went away. Is there a method
to reset all privs on an RT instance?

Ive also got a priv I cannot revoke. I have a group with the
AdminCustomFields priviledge. I get a canonicalization error when I try
and revoke it. Sorry I dont have the full error in front of me at the
moment. Anyone got any suggestions?

cheers
Andrew

On 10 June 2010 19:28, Robert Grasso
robert.grasso...@cedrat.comrobert.grasso%2...@cedrat.com
 wrote:

 once you have untarred the RT 3.8.7 transport archive, in the resulting
 rt-3.8.7 directory, you should read the UPGRADING and
 UPGRADING.mysql documents : they contains the answers to all your questions
 (they guided me successfully for my own upgrade)

  -Message d'origine-
  De : rt-users-boun...@lists.bestpractical.com
  [mailto:rt-users-boun...@lists.bestpractical.com] De la part
  de Andrew Best
  Envoyé : 10 juin 2010 03:58
  À : rt-users@lists.bestpractical.com
  Objet : [rt-users] Upgrade 3.2.2 to 3.8.7
 
  Im in the process of preparing to upgrade an ancient RT 3.2.2
  instance to 3.8.7.
 
  The plan is pretty straight forward.
  Run up new Ubuntu 10.04 host, install and configure blank
  3.8.7 instance as per Ubuntu packages.
  Dump database on old 3.2.2 host, import database onto new Ubuntu host.
  Run necessary upgrade scripts.
  Just like http://wiki.bestpractical.com/view/MigrateToNewServer.
 
  What I would like assistance with is determining what order
  of upgrades I need to run to get the database to upgrade successfully.
  I have read about the rt-setup-database which looks like it
  should do what needs to be done automagically.
  Perhaps there's some caveats im missing?
 
  Can anyone share a clue?


-- 
Never be afraid to try something new. Remember, amateurs built the ark, and
professionals built the Titanic.

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Upgrade 3.2.2 to 3.8.7

2010-06-10 Thread Andrew Best
Here is the exact error message.

Invalid right. Couldn't canonicalize right 'AdminCustomFields'

In the list of New rights there is a right called 'AdminCustomField' so
somehow we have this non-existent right in our config.
I'm looking around for fixes now.

As a note, if I revoke this right BEFORE I do the migration it is removed
from the group without a problem.

On 10 June 2010 20:57, Andrew Best festi...@gmail.com wrote:


 Ive also got a priv I cannot revoke. I have a group with the
 AdminCustomFields priviledge. I get a canonicalization error when I try
 and revoke it. Sorry I dont have the full error in front of me at the
 moment. Anyone got any suggestions?


-- 
Never be afraid to try something new. Remember, amateurs built the ark, and
professionals built the Titanic.

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Upgrade 3.2.2 to 3.8.7

2010-06-09 Thread Andrew Best
Im in the process of preparing to upgrade an ancient RT 3.2.2 instance to
3.8.7.

The plan is pretty straight forward.
Run up new Ubuntu 10.04 host, install and configure blank 3.8.7 instance as
per Ubuntu packages.
Dump database on old 3.2.2 host, import database onto new Ubuntu host.
Run necessary upgrade scripts.
Just like http://wiki.bestpractical.com/view/MigrateToNewServer.

What I would like assistance with is determining what order of upgrades I
need to run to get the database to upgrade successfully.
I have read about the rt-setup-database which looks like it should do what
needs to be done automagically.
Perhaps there's some caveats im missing?

Can anyone share a clue?

cheers
Andrew

-- 
Never be afraid to try something new. Remember, amateurs built the ark, and
professionals built the Titanic.

Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Building an older RT instance for testing

2007-08-19 Thread Andrew Best
Morning all,

I have been tasked with performing two changes to an existing RT-3.4.2 instance:
- install RTFM
- upgrade to the latest and greatest RT

To achieve this I would like to replicate the clients current
production environment (yes its old but its what Ive got):
- FC3
- Apache/2.0.53
- mod_perl1.99 (aka bastardised Redsplat v2.0)

So, ive run up my FC3 test box, patched it (insert laugh here) and
ensured that the same RPMs are installed on the test box as are on the
prod box.

The issue I have now is, that after ive run the 'make testdeps' and
'make fixdeps' and installed all the pre-reqs from CPAN, im ending up
with a missing mod_perl2.pm when I start apache.

I suspect that what is happening is that i'm getting newer modules
from CPAN than when the prod environment was built and these newer
modules depend on mod_perl2. I cant figure out how to confirm this
though.

So, my question is really, am I flogging a dead horse here? I need to
replicate the production environment before touching it and I don't
like my chances of doing that reliably.
Can anyone suggest an alternative strategy for getting RTFM installed safely?
After all these problems I suspect that the prospects of upgrading to
the latest and greatest RT are virtually nil.

-- 
There is no gravity the world sucks.
- William Gibson - Pattern Recognition
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com