UpgradingFrom344to386 SLES10

Notes on Upgrading from 3.4.4 to 3.8.6 on SLES 10

This is based on some of the README,UPGRADING,UPGRADING.mysql documentation put in what I hope to be a more clear format. I had the issue of doing some of these steps in the wrong order, which caused each user's RT-at-a-Glance page to be blank, so I again restored from backup and reran the upgrade process in the right order for this to work.

Created a new folder /opt/rt38 and new mysql database rt38, granting permissions to the appropriate user.

Restored RT 3.4.4 mysql backup into mysql database rt38.

mysql -u rtdb_user -p rt3 < rt3backup.sql

Configure and make: The Readme says, if doing an upgrade, "Follow instructions in README file up to step 7, but only up to version 3.7.87." Which means:

./configure, make testdeps, make fixdeps, sudo make install

Update config file: etc/RT_SiteConfig.pm to point to the current database, user, other settings. This file was quite different than the previous version, so it took some editing rather than just duplicating the previous version's config file. Copy RT_Config.pm over and edit as needed. Some examples:

Set($DatabaseUser , 'rt3db_user');
Set($DatabasePassword , 'xxxxxx');
Set($DatabaseName , 'rt38');
Set($WebDomain, 'rthost.org');

Run make upgrade:

sudo make upgrade

Apply RT 3.8 schema upgrades. /etc/upgrade/upgrade-mysql-schema.pl will generate queries to do the upgrade.

perl etc/upgrade/upgrade-mysql-schema.pl db user pass > sql.queries
mysql -u root -p rt38 < sql.queries

If no warnings, proceed to step 7 of README and apply other upgrades. Test binary attachments (doc,pdf).

Run the rt-setup-database upgrade: do this in the installer directory rt-3.8.x (or it won't find .etc/upgrade/*). It will prompt you to enter the version you are upgrading from. Then it should list a group of required updates from the current version (3.4.4) all the way up to the newest version, and it should "populate the database" and insert data for you.

/opt/rt38/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade

Clear mason cache dir:

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

Note on the order of doing the upgrade: from post on gossamer-threads.com:

"Your upgrade procedure is like what I did, which is wrong. If you use mysql, you should run the mysql upgrade script first, then run the RT upgrade script. or you will get an empty "RT at glance" page."

Finally:

• Configure e-mail and web gateways.
• Be sure to change root's web password from the default.
• Set up automated recurring tasks in cron to generate email digest messages