Version 3.8.1 upgrade - UPGRADING.mysql file clarification

Hello.

I’m still in the planning stages of an upgrade from 3.6.0, with MySQL
5.0.22, to 3.8.1, and I’m a bit confused by contents of the
UPGRADING.mysql file.

The file includes the line:

If you’re upgrading RT from versions prior to 3.8.0 then you MUST follow
instructions below.

but those instructions all seem to speak to an upgrade of MySQL from 4.0
to 4.1, and I’m already running MySQL 5.0.22:

  1. Backup RT database. It’s really good to test that you can restore from
    this backup.

  2. Follow instructions in the README file to the step 7).

  3. Apply changes described in the seven step, but only up to version 3.8.0.

  4. Apply mysql 4.0->4.1 schema changes. RT tarball has script
    etc/upgrade/schema.mysql-4.0-4.1.pl that generates SQL queries to
    upgrade schema
    of
    the DB. Run it:

    perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries

  5. Check sanity of sql queries yourself or consult with your DBA

  6. Apply queries. Note that this step can take a while. May require
    additional
    space on your hard drive comparable with size of your tables.

    mysql -u root -p rt3 < sql.queries

So, my question is, do I have to follow the instructions in the
UPGRADING.mysql file, given that I’m already running MySQL 5.0.22?

Todd Herr

Yup.

Todd Herr wrote:

Hello.

I’m still in the planning stages of an upgrade from 3.6.0, with MySQL
5.0.22, to 3.8.1, and I’m a bit confused by contents of the
UPGRADING.mysql file.

The file includes the line:

If you’re upgrading RT from versions prior to 3.8.0 then you MUST follow
instructions below.

but those instructions all seem to speak to an upgrade of MySQL from 4.0
to 4.1, and I’m already running MySQL 5.0.22:

  1. Backup RT database. It’s really good to test that you can restore from
    this backup.

  2. Follow instructions in the README file to the step 7).

  3. Apply changes described in the seven step, but only up to version 3.8.0.

  4. Apply mysql 4.0->4.1 schema changes. RT tarball has script
    etc/upgrade/schema.mysql-4.0-4.1.pl that generates SQL queries to
    upgrade schema
    of
    the DB. Run it:

    perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries

  5. Check sanity of sql queries yourself or consult with your DBA

  6. Apply queries. Note that this step can take a while. May require
    additional
    space on your hard drive comparable with size of your tables.

    mysql -u root -p rt3 < sql.queries

So, my question is, do I have to follow the instructions in the
UPGRADING.mysql file, given that I’m already running MySQL 5.0.22?

Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati

I’ll confess to still not quite being able to parse steps 2 and 3 in the
UPGRADING.mysql file; “Follow instructions in the README file to the
step 7); Apply changes described in the seven step, but only up to
version 3.8.0.”

Here’s step 7 from README:

  As a user with permission to install RT in your chosen installation
  directory, type:

    make upgrade

  This will install new binaries, config files and libraries without
  overwriting your RT database.

  Update etc/RT_SiteConfig.pm in your RT installation directory.
  You'll need to add any new values you need to change from the 

defaults
in etc/RT_Config.pm

  You may also need to update RT's database.  You can do this with
  the rt-setup-database tool.  Replace root with the name of the dba
  user on your database (root is the default for MySQL).

  You will be prompted for your previous version of RT (such as 3.6.4)
  so that we can calculate which database updates to apply

  You should back up your database before running this command.

    /opt/rt3/sbin/rt-setup-database --dba root 

–prompt-for-dba-password --action upgrade

  Clear mason cache dir:

    rm -fr /opt/rt3/var/mason_data/obj

  Stop and start web-server.

So, to clarify then…

untar distro
./configure -blahblahblah
make testdeps
make fixdeps
(lather, rinse, repeat as necessary)
backup database
make upgrade
perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries
mysql -u root -p rt3 < sql.queries
/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
–action upgrade

Is that the right sequence of steps, or does make upgrade come after the
schema upgrades?

Drew Barnes wrote:

Yup.

Todd Herr wrote:

Hello.

I’m still in the planning stages of an upgrade from 3.6.0, with MySQL
5.0.22, to 3.8.1, and I’m a bit confused by contents of the
UPGRADING.mysql file.

The file includes the line:

If you’re upgrading RT from versions prior to 3.8.0 then you MUST follow
instructions below.

but those instructions all seem to speak to an upgrade of MySQL from
4.0 to 4.1, and I’m already running MySQL 5.0.22:

  1. Backup RT database. It’s really good to test that you can restore from
    this backup.

  2. Follow instructions in the README file to the step 7).

  3. Apply changes described in the seven step, but only up to version
    3.8.0.

  4. Apply mysql 4.0->4.1 schema changes. RT tarball has script
    etc/upgrade/schema.mysql-4.0-4.1.pl that generates SQL queries to
    upgrade schema
    of
    the DB. Run it:

    perl etc/upgrade/schema.mysql-4.0-4.1.pl db user pass > sql.queries

  5. Check sanity of sql queries yourself or consult with your DBA

  6. Apply queries. Note that this step can take a while. May require
    additional
    space on your hard drive comparable with size of your tables.

    mysql -u root -p rt3 < sql.queries

So, my question is, do I have to follow the instructions in the
UPGRADING.mysql file, given that I’m already running MySQL 5.0.22?

Todd Herr
703.220.4153