Upgrading from RT 3.6.5

RT Users
1

Hello, I’m a fairly new Request Tracker user and a novice in the Linux world, but I’ve inherited this system after a co-worker left. We are in the process of getting more departments to use this product and I want to get it upgraded before we move forward. I have read a lot of the documentation on the Wiki but I’m still not 100% confident on what I’m doing. First, I want to have some type of backup of the current system in case I screw something up. Most of the documentation I see refers to /opt/rt3 but this does not exist on my system. Can someone point me in the right direction of backup up the current system and then upgrading to the newest? Below is the information that I have been able to collect about the system:

OS: Ubuntu 8.04.0
MySQL 5.0.51
PostFix Mail 2.54
Apache 2.28
Request Racker: 3.6.5

Thanks.

Brandon Patton, BS
Systems Administrator
ASPIRE Indiana
brandon.patton@ASPIREIndiana.org
765-641-8283

2

Ungh, Ubuntu as a server.

Leaving that aside, simply use the package manager (something like
Synaptic in the GUI) to check where the files for the rt package are
installed.
Back those up if you have concerns about possible customizations done
to core instead of local code. Backup your database. Then:

A) Update your system to something more modern, and install the
corresponding rt package
B) Download the source tarball from Best Practical, and follow the
enclosed directions

P.S. /opt/rt3 is the default path, for some reason several
distributions like Ubuntu like to shove stuff under
/usr/local/packageName and give users longer pathnames to deal with.

3

I’m in the process of trying to upgrade now and I’ve gotten to the part of updating the database and I get the following error. Can anyone help me?

root@nethealth:/opt/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 localhost 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: localhost
Name: rtdb
User: rtuser
DBA: root
Couldn’t finish ‘upgrade’ step.

ERROR: Couldn’t read dir ‘./etc/upgrade’ with upgrade data

The upgrade directory is there, not sure why it can’t read it. Of course, I’m not an expert on permissions either.

root@nethealth:/opt/rt3/etc# ls -l
total 196
-r-------- 1 root www 90 2010-06-28 15:53 acl.Informix
-r-------- 1 root www 859 2010-06-28 15:53 acl.mysql
-r-------- 1 root www 27 2010-06-28 15:53 acl.Oracle
-r-------- 1 root www 1912 2010-06-28 15:53 acl.Pg
-r-------- 1 root www 232 2010-06-28 15:53 acl.Sybase
-r-------- 1 root www 22776 2010-06-28 15:53 initialdata
-r–r----- 1 root www 46335 2010-06-28 15:53 RT_Config.pm
-rw-r----- 1 root www 1027 2010-06-28 16:11 RT_SiteConfig.pm
-r-------- 1 root www 10518 2010-06-28 15:53 schema.Informix
-r-------- 1 root www 13236 2010-06-28 15:53 schema.mysql-4.0
-r-------- 1 root www 14164 2010-06-28 15:53 schema.mysql-4.1
-r-------- 1 root www 11776 2010-06-28 15:53 schema.Oracle
-r-------- 1 root www 13904 2010-06-28 15:53 schema.Pg
-r-------- 1 root www 10769 2010-06-28 15:53 schema.SQLite
-r-------- 1 root www 11550 2010-06-28 15:53 schema.Sybase
drwxr-xr-x 25 administrator administrator 4096 2010-06-28 15:52 upgrade-----Original Message-----
From: Jerrad Pierce [mailto:jpierce@cambridgeenergyalliance.org]
Sent: Friday, June 25, 2010 2:14 PM
To: Patton, Brandon
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgrading from RT 3.6.5

Ungh, Ubuntu as a server.

Leaving that aside, simply use the package manager (something like
Synaptic in the GUI) to check where the files for the rt package are
installed.
Back those up if you have concerns about possible customizations done
to core instead of local code. Backup your database. Then:

A) Update your system to something more modern, and install the
corresponding rt package
B) Download the source tarball from Best Practical, and follow the
enclosed directions

P.S. /opt/rt3 is the default path, for some reason several
distributions like Ubuntu like to shove stuff under
/usr/local/packageName and give users longer pathnames to deal with.

4

I’m in the process of trying to upgrade now and I’ve gotten to the part of updating the database and I get the following error. Can anyone help me?

root@nethealth:/opt/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 localhost 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: localhost
Name: rtdb
User: rtuser
DBA: root
Couldn’t finish ‘upgrade’ step.

ERROR: Couldn’t read dir ‘./etc/upgrade’ with upgrade data

The error message is telling you that there is no /opt/rt3/sbin/etc/upgrade directory
You need to run the command from a higher directory, or optionally you
could explicity pass --datadir.
Usually you run this from the unpacked tarball that you ran make
upgrade from.

-kevin

5

Ok, I’m getting closer and closer to getting this to work but having a problem with the Apache setup. I have created the config for Apache as shown by numerous examples but no matter which example I follow, I get the following error trying to start Apache:

Can’t load Perl file: /opt/rt3/bin/webmux.pl

If I uncomment the “PerlRequire” line apache will start and I get the website with the “Your Almost There!” message.

Here is the config info I’m using for Apache

<VirtualHost *>
ServerName nethealth
DocumentRoot /opt/rt3/share/html
AddDefaultCharset UTF-8
PerlModule Apache2 Apache::compat
PerlModule Apache::DBI
PerlRequire /opt/rt3/bin/webmux.pl
ErrorLog /opt/rt3/var/log/apache2.error

SetHandler perl-script PerlHandler RT::Mason

OS: Ubuntu 8.04.0
MySQL 5.0.51
PostFix Mail 2.54
Apache 2.28
Request Tacker: 3.8.8-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Patton, Brandon
Sent: Tuesday, June 29, 2010 10:43 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgrading from RT 3.6.5

I’m in the process of trying to upgrade now and I’ve gotten to the part of updating the database and I get the following error. Can anyone help me?

root@nethealth:/opt/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 localhost 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: localhost
Name: rtdb
User: rtuser
DBA: root
Couldn’t finish ‘upgrade’ step.

ERROR: Couldn’t read dir ‘./etc/upgrade’ with upgrade data

The upgrade directory is there, not sure why it can’t read it. Of course, I’m not an expert on permissions either.

root@nethealth:/opt/rt3/etc# ls -l
total 196
-r-------- 1 root www 90 2010-06-28 15:53 acl.Informix
-r-------- 1 root www 859 2010-06-28 15:53 acl.mysql
-r-------- 1 root www 27 2010-06-28 15:53 acl.Oracle
-r-------- 1 root www 1912 2010-06-28 15:53 acl.Pg
-r-------- 1 root www 232 2010-06-28 15:53 acl.Sybase
-r-------- 1 root www 22776 2010-06-28 15:53 initialdata
-r–r----- 1 root www 46335 2010-06-28 15:53 RT_Config.pm
-rw-r----- 1 root www 1027 2010-06-28 16:11 RT_SiteConfig.pm
-r-------- 1 root www 10518 2010-06-28 15:53 schema.Informix
-r-------- 1 root www 13236 2010-06-28 15:53 schema.mysql-4.0
-r-------- 1 root www 14164 2010-06-28 15:53 schema.mysql-4.1
-r-------- 1 root www 11776 2010-06-28 15:53 schema.Oracle
-r-------- 1 root www 13904 2010-06-28 15:53 schema.Pg
-r-------- 1 root www 10769 2010-06-28 15:53 schema.SQLite
-r-------- 1 root www 11550 2010-06-28 15:53 schema.Sybase
drwxr-xr-x 25 administrator administrator 4096 2010-06-28 15:52 upgrade

-----Original Message-----
From: Jerrad Pierce [mailto:jpierce@cambridgeenergyalliance.org]
Sent: Friday, June 25, 2010 2:14 PM
To: Patton, Brandon
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Upgrading from RT 3.6.5

Ungh, Ubuntu as a server.

Leaving that aside, simply use the package manager (something like
Synaptic in the GUI) to check where the files for the rt package are
installed.
Back those up if you have concerns about possible customizations done
to core instead of local code. Backup your database. Then:

A) Update your system to something more modern, and install the
corresponding rt package
B) Download the source tarball from Best Practical, and follow the
enclosed directions

P.S. /opt/rt3 is the default path, for some reason several
distributions like Ubuntu like to shove stuff under
/usr/local/packageName and give users longer pathnames to deal with.

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com