https://rt-wiki.bestpractical.com/index.php?title=FreeBSDupgradeTo3_8_2&feed=atom&action=historyFreeBSDupgradeTo3 8 2 - Revision history2024-03-28T08:11:50ZRevision history for this page on the wikiMediaWiki 1.37.2https://rt-wiki.bestpractical.com/index.php?title=FreeBSDupgradeTo3_8_2&diff=1384&oldid=prevAdmin: 3 revisions imported2016-04-06T20:09:06Z<p>3 revisions imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:09, 6 April 2016</td>
</tr>
<!-- diff cache key bestpractical_mediawiki1459887241:diff::1.12:old-1383:rev-1384 -->
</table>Adminhttps://rt-wiki.bestpractical.com/index.php?title=FreeBSDupgradeTo3_8_2&diff=1383&oldid=prevBillCole: remove spam link2011-01-24T17:45:09Z<p>remove spam link</p>
<p><b>New page</b></p><div>'''WARNING:''' This notes are user experience and don't free you from reading README, UPGRADING and UPGRADING.mysql (if you are on mysql DB) files. You '''MUST''' read them.<br />
<br />
Steffan below skipped upgrading mysql DB and most probably has broken attachments and/or malfunctioning RT.<br />
<br />
----<br />
<br />
My notes on our upgrade of 3.4.2 to 3.8.2. Existing server is running [[FreeBSD]] 5.4 and we used the [[FreeBSDInstallGuide]] to help us get going originally.<br />
<br />
Other pages that helped me: [[ManualInstallation]], [[MultipleInstances]], [[FastCGIConfiguration]]<br />
<br />
Ok... on with the show:<br />
<br />
* Shut down Apache so nobody can get to RT.<br />
* Make DB backup<br />
<br />
home [/usr/homex]# mysqldump -p --opt rt3_4 &gt; RT34_Backup.sql<br />
Enter password: xxxxxxxxx<br />
<br />
* Download new tar file into /usr/local/src/<br />
* Untar it and fire up configure with all needed options. Look at them closely as you'll likely need to adjust:<br />
<br />
./configure '--prefix=/usr/local/rt3' '--enable-layout=RT3' '--with-web-user=nobody' '--with-web-group=nobody' '--with-libs-group=wheel'<br />
'--with-db-host=your.host.here.com' '--with-db-port=' '--with-db-type=mysql' '--with-db-rt-user=rt34' '--with-db-rt-pass=xxxxxxxx '<br />
'--with-db-database=rt_upgrade' '--with-db-dba=root' '--mandir=/usr/local/man' '--infodir=/usr/local/info/' 'CC=cc'<br />
'CFLAGS=-O2' --with-apachectl=/usr/local/apache/bin/apachectl --enable-gd --enable-graphviz<br />
<br />
* Fix the needed dependencies (work through the cpan stuff)<br />
<br />
[usr/local/src/rt-3.8.2]# make fixdeps<br />
<br />
* Had to manual install a few packages:<br />
<br />
[/usr/local/src/rt-3.8.2]# wget http://www.libgd.org/releases/gd-latest.tar.gz<br />
[/usr/local/src/rt-3.8.2]# wget http://www.graphviz.org/pub/graphviz/stable/SOURCES/graphviz-2.20.3.tar.gz<br />
<br />
* Install them by untaring and doing the standard: ./configure; make install<br />
* RT complained later saying it couldn't find the graphviz exe, so I softlinked it:<br />
<br />
[/]# ln -s /usr/local/bin/dot /usr/bin/dot<br />
<br />
* Try again and again till no errors<br />
<br />
[/usr/local/src/rt-3.8.2]# make fixdep<br />
<br />
* Now upgrade your DB:<br />
<br />
[/]# /usr/local/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade<br />
In order to create or update your RT database, this script needs to connect to your mysql instance on your.host.here.com as root<br />
Please specify that user's database password below. If the user has no database<br />
password, just press return.<br />
<br />
Password:<br />
Working with:<br />
Type: mysql<br />
Host: your.host.here.com<br />
Name: rt_upgrade<br />
User: rt34<br />
DBA: root<br />
Enter RT version you're upgrading from: 3.4.2<br />
<br />
Going to apply following upgrades:<br />
3.5.1<br />
3.7.1<br />
... snip ...<br />
3.8.1<br />
3.8.2<br />
<br />
Enter RT version if you want to stop upgrade at some point,<br />
or leave it blank if you want apply above upgrades:<br />
<br />
IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP<br />
<br />
Proceed [y/N]:y<br />
Processing 3.5.1<br />
Now inserting data<br />
Processing 3.7.1<br />
... snip ...<br />
Processing 3.8.2<br />
Now inserting data<br />
[Tue Feb 3 23:29:12 2009] [warning]: Going to add [OLD] prefix to all temlates in approvals queue. If you never used<br />
approvals then you can delete all these templates with [OLD] prefix. Leave new there may be you will want to use approvals<br />
some time. (./etc/upgrade/3.8.2/content:3) [Tue Feb 3 23:29:14 2009] [warning]: IMPORTANT: We're going to delete all<br />
scrips in Approvals queue and save them in 'rt-approvals-scrips-zgcD' file. (./etc/upgrade/3.8.2/content:165)<br />
Done.<br />
[usr/local/src/rt-3.8.2]#<br />
<br />
* If it doesn't error you're golden! If it does, restore your DB and start over.<br />
<br />
* OK. Now we apply the upgraded code:<br />
<br />
[usr/local/src/rt-3.8.2]# make upgrade<br />
<br />
* We had to move all of our old customizations out of the way and then rm the original dirs as they were trashing the new layout<br />
<br />
[usr/local/src/rt-3.8.2]# cd /usr/local/rt3/local/<br />
[/usr/local/rt3/local/]# cp -pR html html.rt34<br />
[/usr/local/rt3/local/]# cp -pR lib lib.rt34<br />
[/usr/local/rt3/local/]# rm -R html/*<br />
[/usr/local/rt3/local/]# rm -R lib/*<br />
<br />
* Time to tweak Apache. We're moving from running RT with /mod_perl/ to /fastcgi/. First we have to install that:<br />
<br />
[/]# cd /usr/ports/www/mod_fastcgi<br />
[/usr/ports/www/mod_fastcgi]# make install<br />
<br />
... snip....<br />
<br />
************************************************************<br />
* Fast-cgi modules was included with your apache *<br />
* configuration file *<br />
* *<br />
* You need to add following lines to your apache *<br />
* configuration file. and restart it ! *<br />
* *<br />
* AddHandler fastcgi-script fcgi fcgi fpl *<br />
* *<br />
************************************************************<br />
===&gt; Registering installation for mod_fastcgi-2.4.2<br />
<br />
* we also need the FCGI perl module now that we have fastcgi built:<br />
<br />
[/usr/local/src/]# wget http://www.cpan.org/modules/by-module/FCGI/FCGI-0.67.tar.gz<br />
[/usr/local/src/]# tar zxvf FCGI-0.67.tar.gz<br />
[/usr/local/src/FCGI-0.67/]# cd FCGI-0.67<br />
[/usr/local/src/FCGI-0.67/]# perl Makefile.PL<br />
[/usr/local/src/FCGI-0.67/]# make install<br />
<br />
* Now tweak the Apache conf file:<br />
<br />
[/usr/local/rt3/local/]# cp /usr/local/apache/conf/httpd.conf /usr/local/apache/conf/httpd.conf.preupgrade<br />
[/usr/local/rt3/local/]# vi /usr/local/apache/conf/httpd.conf<br />
<br />
* Comment out the following lines:<br />
<br />
<nowiki># PerlModule Apache::DBI<br />
# PerlRequire /usr/local/rt3/bin/webmux.pl<br />
# SetHandler perl-script<br />
# PerlHandler RT::Mason<br />
</nowiki><br />
<br />
* Add the following lines:<br />
<br />
LoadModule fastcgi_module libexec/mod_fastcgi.so (in upper section next to other LoadModule's )<br />
FastCgiServer /usr/local/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4 (right under above line)<br />
ScriptAlias / /usr/local/rt3/bin/mason_handler.fcgi/ (right after the DocumentRoot statement)<br />
<br />
* Restart Apache and give it a whirl<br />
* If Apache refuses to start, check the error logs<br />
<br />
Worked for me. Good luck -Steffan</div>BillCole