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 MigrateToNewServer - Request Tracker Wiki.

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.

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)

Robert GRASSO – System engineer

CEDRAT S.A.
15 Chemin de Malacher - Inovallée - 38246 MEYLAN cedex - FRANCE
Phone: +33 (0)4 76 90 50 45 - Fax: +33 (0)4 56 38 08 30
mailto:robert.grasso@cedrat.com - http://www.cedrat.com

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
AndrewOn 10 June 2010 19:28, Robert Grasso <robert.grasso+nv@cedrat.comrobert.grasso%2Bnv@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-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@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 MigrateToNewServer - Request Tracker Wiki.

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.

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 festivus@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.