Upgrade from 3.0.2 -> 3.6.3, easy as 3.14159?

RT Users
1

Tomorrow I’m going to be upgrading our RT server, and at the same time
will finally upgrade RT itself (we’ve been dealing with the “truncated
attachments” issue long enough, and I finally have more than just that
as a reason to upgrade :> )

Since 3.6.3 is in Fedora Extras, I’ll just install the RPM for that, but
I’m curious about the database. Downloading the source for 3.6.3 and
reading the UPGRADING file, it looks as though there’s no change to the
schema? Am I correct that simply restoring the DB on the new machine
and pointing the new RT to it will be sufficient?

Thanks!

Steve Huston - W2SRH - Unix Sysadmin, Dept. of Astrophysical Sciences
Princeton University | ICBM Address: 40.346525 -74.651285
126 Peyton Hall |“On my ship, the Rocinante, wheeling through
Princeton, NJ 08544 | the galaxies; headed for the heart of Cygnus,
(609) 258-7375 | headlong into mystery.” -Rush, ‘Cygnus X-1’

2

Hate replying to my own mail, but I hit send too soon… just read
through the README, and I see the instructions for the schema updates.

So, to rephrase then, is there no difference needed for 3.0.2 -> 3.1.0
(the first instance in etc/upgrade)?

Steve Huston - W2SRH - Unix Sysadmin, Dept. of Astrophysical Sciences
Princeton University | ICBM Address: 40.346525 -74.651285
126 Peyton Hall |“On my ship, the Rocinante, wheeling through
Princeton, NJ 08544 | the galaxies; headed for the heart of Cygnus,
(609) 258-7375 | headlong into mystery.” -Rush, ‘Cygnus X-1’

3

This is why I don’t like using packages put together by any of the
distros. I prefer installing the source package from Best Practical.
If you were to install the RPMs there would be no path to update the
database schema.

Mathew

Steve Huston wrote:

4

This is why I don’t like using packages put together by any of the
distros. I prefer installing the source package from Best Practical.
If you were to install the RPMs there would be no path to update the
database schema.

Not necessarily true. Debian, for example, places all of the database
upgrade files in /etc/request-tracker3.6/upgrade/$version and you just
need to call rt-setup-database with the appropriate options as normal
making upgrade relatively painless.

Andrew

do be do be doh!

5

Since 3.6.3 is in Fedora Extras, I’ll just install the RPM for
that, but
I’m curious about the database. Downloading the source for 3.6.3 and
reading the UPGRADING file, it looks as though there’s no change to
the
schema? Am I correct that simply restoring the DB on the new machine
and pointing the new RT to it will be sufficient?

If you treat your 3.6.3 install as an upgrade rather than a fresh
install onto your restored DB, it should work. I don’t know if the
rpm’s apply the necessary schema updates, but you can run them by
hand as per the UPGRADING file from a source tree if it does not.

smime.p7s (2.47 KB)

6

I don’t know if the rpm’s apply the necessary schema updates, but you
can run them by hand as per the UPGRADING file from a source tree if
it does not.

They didn’t (good, they didn’t know what I was upgrading from anyway)
and I did. And it worked beautifully :>

Thanks!

Steve Huston - W2SRH - Unix Sysadmin, Dept. of Astrophysical Sciences
Princeton University | ICBM Address: 40.346525 -74.651285
126 Peyton Hall |“On my ship, the Rocinante, wheeling through
Princeton, NJ 08544 | the galaxies; headed for the heart of Cygnus,
(609) 258-7375 | headlong into mystery.” -Rush, ‘Cygnus X-1’