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:
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.
Please contact us with any comments or corrections.
Unless explicitly stated otherwise, all material is copyright The University of Edinburgh