Upgrade From 3.4.0 to 3.6.6

RT Users
1

All,

I’m looking to upgrade from RT version 3.4.0 (RH 7.2/MySQL 4.0.20/Apache
1.3.33) to 3.6.6 (CentOS 4.6/MySQL 5.0.22/Apache 2.x). I checked out a
guide on the wiki
(MigrateToNewServer - Request Tracker Wiki) but I would like
to know if there are any DB schema changes that would prevent me from
just installing 3.6.6 on another server, then simply doing a mysqldump
and migrating the database schema from the old 3.4.0 server.

Thanks!

-Dan

2

Dan,
I did that when I rebuilt my server but I went from one version of
Fedora to another. I haven’t seen any issues … yet.

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia
“Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!”

“Dan Magnuszewski” DMagnuszewski@synacor.com 5/20/2008 12:33 AM

All,

I’m looking to upgrade from RT version 3.4.0 (RH 7.2/MySQL
4.0.20/Apache
1.3.33) to 3.6.6 (CentOS 4.6/MySQL 5.0.22/Apache 2.x). I checked out a
guide on the wiki
(MigrateToNewServer - Request Tracker Wiki) but I would
like
to know if there are any DB schema changes that would prevent me from
just installing 3.6.6 on another server, then simply doing a mysqldump
and migrating the database schema from the old 3.4.0 server.

Thanks!

-Dan
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

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

3

All,

I’m looking to upgrade from RT version 3.4.0 (RH 7.2/MySQL 4.0.20/Apache
1.3.33) to 3.6.6 (CentOS 4.6/MySQL 5.0.22/Apache 2.x). I checked out a
guide on the wiki
(MigrateToNewServer - Request Tracker Wiki) but I would like
to know if there are any DB schema changes that would prevent me from
just installing 3.6.6 on another server, then simply doing a mysqldump
and migrating the database schema from the old 3.4.0 server.

Just follow the procedure in the README file, here is a part of the
Upgrading procedure in this file which will help you answer your
question :wink:

[…]
You may also need to update RT’s database. To find out, type:

   ls etc/upgrade

 For each item in that directory whose name is greater than
 your previously installed RT version, run:

   /opt/rt3/sbin/rt-setup-database --action schema \
       --datadir etc/upgrade/<version>
   /opt/rt3/sbin/rt-setup-database --action acl \
       --datadir etc/upgrade/<version>
   /opt/rt3/sbin/rt-setup-database --action insert \
        --datadir etc/upgrade/<version>

[…]

4

I tried installing RT but when I am running apache service it is
displaying PERL Error.

First, please don’t write only to me, but to
rt-users@lists.bestpractical.com instead, you will get more help :wink:

Second, if you wan’t someone to help you, describe better your problem,
send at least the error displayed …