Upgrading RT to version 3.6.1

1. Swap out the 2 current support forms (DICE and non-DICE users) and replace them with a page that gives details of support office locations and phone numbers. The forms are found at:

https://www.inf.ed.ac.uk/systems/support/form/index.html

https://www.inf.ed.ac.uk/systems/support/nodice/index.html

2. On nutty, as the rt user, rename Incoming.copy in ~rt/Mail as Incoming.copy.date.

3. Stop apache on rt3.inf.ed.ac.uk

4. Take a dump of the rt database.

/usr/bin/mysqldump -p --user=root --opt rt3 > /disk/sannox/dumps/RT-dump.sql

5. Move /opt/rt out the way by renaming it /opt/rt-3.0.8. Will need the nag scripts from /opt/rt-3.0.8/bin and the dump script from /opt/rt-3.0.8/dumps later.

6. Change sannox's profile to reflect the new rpms and run updaterpms. Temporarily stop the rt cron jobs.

7. Move the update directory from /tmp on sannox to /opt/rt/etc. The upgrade directory isn't part of the rt rpm installation (or if you do it manually) but is included in the original rt source file. I put it in /tmp in advance of the upgrade.

8. Run the scripts to update the database.

For each directory in /opt/rt/etc/upgrade:

drwxr-xr-x 2 alisond people 4096 Aug  8  2006 3.1.0
drwxr-xr-x 2 alisond people 4096 Aug  8  2006 3.1.15
drwxr-xr-x 2 alisond people 4096 Aug  8  2006 3.1.17
drwxr-xr-x 2 alisond people 4096 Aug  8  2006 3.3.0
drwxr-xr-x 2 alisond people 4096 Aug  8  2006 3.3.11
drwxr-xr-x 2 alisond people 4096 Aug  8  2006 3.5.1

run, from /opt/rt:

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

9. Ensure that /opt/rt/var/log/rt.log can be written to and that /opt/rt/bin/rt-mailgate is executable.

10. Do a dump of the rt database again but this time create the file RT-dump306.sql.

11. Start apache.

12. Send an e-mail to rt+newticketplease to confirming that the mailgate is working OK.

13. Put the support forms back in place.

14.Put the cron jobs and nag scripts back in place.

 : Units : User_support 

Please contact us with any comments or corrections. Unless explicitly stated otherwise, all material is copyright The University of Edinburgh