FreeBSDupgradeTo3 8 2

From Request Tracker Wiki
Jump to navigation Jump to search

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.

Steffan below skipped upgrading mysql DB and most probably has broken attachments and/or malfunctioning RT.


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.

Other pages that helped me: ManualInstallation, MultipleInstances, FastCGIConfiguration

Ok... on with the show:

  • Shut down Apache so nobody can get to RT.
  • Make DB backup home [/usr/homex]# mysqldump -p --opt rt3_4 > RT34_Backup.sql Enter password: xxxxxxxxx
  • Download new tar file into /usr/local/src/
  • Untar it and fire up configure with all needed options. Look at them closely as you'll likely need to adjust: ./configure '--prefix=/usr/local/rt3' '--enable-layout=RT3' '--with-web-user=nobody' '--with-web-group=nobody' '--with-libs-group=wheel' '--with-db-host=your.host.here.com' '--with-db-port=' '--with-db-type=mysql' '--with-db-rt-user=rt34' '--with-db-rt-pass=xxxxxxxx ' '--with-db-database=rt_upgrade' '--with-db-dba=root' '--mandir=/usr/local/man' '--infodir=/usr/local/info/' 'CC=cc' 'CFLAGS=-O2' --with-apachectl=/usr/local/apache/bin/apachectl --enable-gd --enable-graphviz
  • Fix the needed dependencies (work through the cpan stuff) [usr/local/src/rt-3.8.2]# make fixdeps
  • Had to manual install a few packages: [/usr/local/src/rt-3.8.2]# wget http://www.libgd.org/releases/gd-latest.tar.gz [/usr/local/src/rt-3.8.2]# wget http://www.graphviz.org/pub/graphviz/stable/SOURCES/graphviz-2.20.3.tar.gz
  • Install them by untaring and doing the standard: ./configure; make install
  • RT complained later saying it couldn't find the graphviz exe, so I softlinked it: [/]# ln -s /usr/local/bin/dot /usr/bin/dot
  • Try again and again till no errors [/usr/local/src/rt-3.8.2]# make fixdep
  • Now upgrade your DB: [/]# /usr/local/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade 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 Please specify that user's database password below. If the user has no database password, just press return. Password: Working with: Type: mysql Host: your.host.here.com Name: rt_upgrade User: rt34 DBA: root Enter RT version you're upgrading from: 3.4.2 Going to apply following upgrades: 3.5.1 3.7.1 ... snip ... 3.8.1 3.8.2 Enter RT version if you want to stop upgrade at some point, or leave it blank if you want apply above upgrades: IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP Proceed [y/N]:y Processing 3.5.1 Now inserting data Processing 3.7.1 ... snip ... Processing 3.8.2 Now inserting data [Tue Feb 3 23:29:12 2009] [warning]: Going to add [OLD] prefix to all temlates in approvals queue. If you never used approvals then you can delete all these templates with [OLD] prefix. Leave new there may be you will want to use approvals some time. (./etc/upgrade/3.8.2/content:3) [Tue Feb 3 23:29:14 2009] [warning]: IMPORTANT: We're going to delete all scrips in Approvals queue and save them in 'rt-approvals-scrips-zgcD' file. (./etc/upgrade/3.8.2/content:165) Done. [usr/local/src/rt-3.8.2]#
  • If it doesn't error you're golden! If it does, restore your DB and start over.
  • OK. Now we apply the upgraded code: [usr/local/src/rt-3.8.2]# make upgrade
  • 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 [usr/local/src/rt-3.8.2]# cd /usr/local/rt3/local/ [/usr/local/rt3/local/]# cp -pR html html.rt34 [/usr/local/rt3/local/]# cp -pR lib lib.rt34 [/usr/local/rt3/local/]# rm -R html/* [/usr/local/rt3/local/]# rm -R lib/*
  • Time to tweak Apache. We're moving from running RT with /mod_perl/ to /fastcgi/. First we have to install that: [/]# cd /usr/ports/www/mod_fastcgi [/usr/ports/www/mod_fastcgi]# make install ... snip....

  • Fast-cgi modules was included with your apache *
  • configuration file *
  • *
  • You need to add following lines to your apache *
  • configuration file. and restart it ! *
  • *
  • AddHandler fastcgi-script fcgi fcgi fpl *
  • *

===> Registering installation for mod_fastcgi-2.4.2

  • we also need the FCGI perl module now that we have fastcgi built: [/usr/local/src/]# wget http://www.cpan.org/modules/by-module/FCGI/FCGI-0.67.tar.gz [/usr/local/src/]# tar zxvf FCGI-0.67.tar.gz [/usr/local/src/FCGI-0.67/]# cd FCGI-0.67 [/usr/local/src/FCGI-0.67/]# perl Makefile.PL [/usr/local/src/FCGI-0.67/]# make install
  • Now tweak the Apache conf file: [/usr/local/rt3/local/]# cp /usr/local/apache/conf/httpd.conf /usr/local/apache/conf/httpd.conf.preupgrade [/usr/local/rt3/local/]# vi /usr/local/apache/conf/httpd.conf
  • Comment out the following lines: # PerlModule Apache::DBI <h1>PerlRequire /usr/local/rt3/bin/webmux.pl</h1> <h1>SetHandler perl-script</h1> <h1>PerlHandler RT::Mason</h1>
  • Add the following lines: LoadModule fastcgi_module libexec/mod_fastcgi.so (in upper section next to other LoadModule's ) FastCgiServer /usr/local/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4 (right under above line) ScriptAlias / /usr/local/rt3/bin/mason_handler.fcgi/ (right after the DocumentRoot statement)
  • Restart Apache and give it a whirl
  • If Apache refuses to start, check the error logs

Worked for me. Good luck -Steffan