Upgrading from RT 3.6.1 to 3.6.4

RT Users
1

I have an existing RT 3.6.1 installation that I want to migrate to a new
webserver (Ubuntu 7.10 Gutsy Gibbon), which has 3.6.4 in the repository
… Is there a clean way to do this???

I’m figuring, if I just point a new instance at the old database, that
won’t work, but I’m not sure which upgrade scripts (I hope there are
scripts) I can run manually against the database to bring it up to speed
so the new install will talk to it.

I looked through the recent rt-users traffic but didn’t see anything
that would immediately apply to my situation.

Any ideas or recommendations where to start?

–Sam

2

Samuel,

We just upgraded to 3.6.4 from 3.4.4 and there were NO DataBase changes

(we are on Oracle). I think all you need to do is set the
RT_SiteConfig.pm DataBase parameters to refer to the DataBase you want
to use and supply the password and you should be OK. Hope this helps.

Kenn
LBNLOn 2/25/2008 5:29 PM, Samuel P. Howard wrote:

I have an existing RT 3.6.1 installation that I want to migrate to a new
webserver (Ubuntu 7.10 Gutsy Gibbon), which has 3.6.4 in the repository
… Is there a clean way to do this???

I’m figuring, if I just point a new instance at the old database, that
won’t work, but I’m not sure which upgrade scripts (I hope there are
scripts) I can run manually against the database to bring it up to speed
so the new install will talk to it.

I looked through the recent rt-users traffic but didn’t see anything
that would immediately apply to my situation.

Any ideas or recommendations where to start?

–Sam

The rt-users Archives

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

Wow, I’m surprise there weren’t any database updates from 3.4 to 3.6 …
you’d think that’d be almost a guarantee … hrmmm

I should pull down the source tarballs for 3.6.1 -> 3.6.4 and take a
look I guess … maybe it will be that easy! (I’ll point to a COPY of
my production database, of course, tho)

Thanks!
Sam

Kenneth Crocker wrote:

4

At Tuesday 2/26/2008 12:29 PM, Kenneth Crocker wrote:

Samuel,

    We just upgraded to 3.6.4 from 3.4.4 and there were NO

DataBase changes
(we are on Oracle).

Kenn
LBNL

That’s not strictly true - there were no schema changes, but there
are some necessary new rows inserted into the database as part of the
3.6 install. (see etc/upgrade/3.5.1/content in the install package).

Steve

5

Hi;

There is one database change from 3.5.1 to 3.6.x which is content
changes (not a schema change though )…
You can identify what changes are needed from the rt source, look in
the etc/upgrade/ … and for every directory > than your current version
there will be changes to be made.
The rt installation / README explains how to do these db changes … yes
its via scripts

Roy

Samuel P. Howard wrote:

6

Samuel,

Don't forget any changes needed for the SESSIONS table. There have been

a few people with problems on that end, but I didn’t know if you were
using that table for sessions or not.

Kenn
LBNLOn 2/26/2008 9:39 AM, Samuel P. Howard wrote:

Wow, I’m surprise there weren’t any database updates from 3.4 to 3.6 …
you’d think that’d be almost a guarantee … hrmmm

I should pull down the source tarballs for 3.6.1 → 3.6.4 and take a
look I guess … maybe it will be that easy! (I’ll point to a COPY of
my production database, of course, tho)

Thanks!
Sam

Kenneth Crocker wrote:

Samuel,

We just upgraded to 3.6.4 from 3.4.4 and there were NO DataBase

changes (we are on Oracle). I think all you need to do is set the
RT_SiteConfig.pm DataBase parameters to refer to the DataBase you want
to use and supply the password and you should be OK. Hope this helps.

Kenn
LBNL

On 2/25/2008 5:29 PM, Samuel P. Howard wrote:

I have an existing RT 3.6.1 installation that I want to migrate to a
new webserver (Ubuntu 7.10 Gutsy Gibbon), which has 3.6.4 in the
repository … Is there a clean way to do this???

I’m figuring, if I just point a new instance at the old database,
that won’t work, but I’m not sure which upgrade scripts (I hope there
are scripts) I can run manually against the database to bring it up
to speed so the new install will talk to it.

I looked through the recent rt-users traffic but didn’t see anything
that would immediately apply to my situation.

Any ideas or recommendations where to start?

–Sam

The rt-users Archives

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

7

Stephen,

Well, in that case I'd sure like to know what they were or what they

affected. I know that “Reminders” were added, but they are a link and
didn’t exist before so going to the upgraded version still would not
require any DB changes. What kinda rows? What table? Thanks.

Kenn
LBNLOn 2/26/2008 9:39 AM, Stephen Turner wrote:

At Tuesday 2/26/2008 12:29 PM, Kenneth Crocker wrote:

Samuel,

    We just upgraded to 3.6.4 from 3.4.4 and there were NO

DataBase changes
(we are on Oracle).

Kenn
LBNL

That’s not strictly true - there were no schema changes, but there are
some necessary new rows inserted into the database as part of the 3.6
install. (see etc/upgrade/3.5.1/content in the install package).

Steve