https://rt-wiki.bestpractical.com/index.php?title=UpgradingFrom344to386_SLES10&feed=atom&action=historyUpgradingFrom344to386 SLES10 - Revision history2024-03-29T13:48:22ZRevision history for this page on the wikiMediaWiki 1.37.2https://rt-wiki.bestpractical.com/index.php?title=UpgradingFrom344to386_SLES10&diff=4080&oldid=prevAdmin: 2 revisions imported2016-04-06T20:39:38Z<p>2 revisions imported</p>
<p><b>New page</b></p><div>= Notes on Upgrading from 3.4.4 to 3.8.6 on SLES 10 =<br />
<br />
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.<br />
<br />
'''Created a new folder''' /opt/rt38 and new mysql database rt38, granting permissions to the appropriate user.<br />
<br />
'''Restored RT 3.4.4 mysql backup''' into mysql database rt38.<br />
<br />
mysql -u rtdb_user -p rt3 &lt; rt3backup.sql<br />
<br />
<br />
'''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:<br />
<br />
./configure, make testdeps, make fixdeps, sudo make install<br />
<br />
<br />
'''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:<br />
<br />
Set($DatabaseUser , 'rt3db_user');<br />
Set($DatabasePassword , 'xxxxxx');<br />
Set($DatabaseName , 'rt38');<br />
Set($WebDomain, 'rthost.org');<br />
<br />
<br />
'''Run make upgrade:'''<br />
<br />
sudo make upgrade<br />
<br />
<br />
'''Apply RT 3.8 schema upgrades.''' /etc/upgrade/upgrade-mysql-schema.pl will generate queries to do the upgrade.<br />
<br />
perl etc/upgrade/upgrade-mysql-schema.pl db user pass &gt; sql.queries<br />
mysql -u root -p rt38 &lt; sql.queries<br />
<br />
<br />
If no warnings, proceed to step 7 of README and apply other upgrades. Test binary attachments (doc,pdf).<br />
<br />
'''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.<br />
<br />
/opt/rt38/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade<br />
<br />
<br />
'''Clear mason cache dir:'''<br />
<br />
rm -fr /opt/rt3/var/mason_data/obj<br />
<br />
<br />
'''Note on the order of doing the upgrade:''' from post on gossamer-threads.com:<br />
<br />
"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."<br />
<br />
Finally:<br />
<br />
* Configure e-mail and web gateways.<br />
* Be sure to change root's web password from the default.<br />
* Set up automated recurring tasks in cron to generate email digest messages</div>Admin