HowTo Install Request-Tracker 3.8(MySQL) on ubuntu 9.10

This Howto will explain how to install request-tracker on a clean Ubuntu 9.10 Server install. It is tested on Ubuntu 9.10 and might work with slight modifications on other versions or Debian based distributions.

It also installs the additional services required for Request-Tracker:

• Mysql - Database to Store the RT information.

• Postfix - Email Server (for sending emails)

• Apache2 - Web Server

Logon as a user with the right to use the sudo command.

Make sure you have the latest software

sudo apt-get update

sudo apt-get upgrade

Install MySql with perl interface

sudo apt-get install mysql-server libdbd-mysql-perl

Answer Y

Type password for root in mysql

Repeat password for root in mysql

Install the Web server with specific files for request-tracker3.8

sudo apt-get install rt3.8-apache2

Answer Y

Install mail server (SMTP Server)

sudo apt-get install postfix

Choose "Internet Site" in the install dialogue.

Write the name of the local server

Install Request Tracker 3.8 server and client

sudo apt-get install request-tracker3.8 rt3.8-clients

Answer Y

Write rt.domainname

Answer "Yes" to Handle RT_SiteConfig.pm permissions?

Answer “Yes” to Configure database for request-tracker3.8 with dbconfig-common?

Configure Request Tracker 3.8

Make backup of configuration file.

sudo cp /etc/request-tracker3.8/RT_SiteConfig.pm /etc/request-tracker3.8/RT_SiteConfig.pm.orig

Edit Request Tracker configuration file.

sudo vim /etc/request-tracker3.8/RT_SiteConfig.pm

#---your file should look something like this ----------------

# vim /etc/request-tracker3.8/RT_SiteConfig.pm

#TIMEZONE – takes the timezone from linux installation.

my $zone = "UTC";

$zone=`/bin/cat /etc/timezone`

if -f "/etc/timezone";

chomp $zone;

Set($Timezone, $zone);

# THE BASICS:

Set($rtname, 'RT3.example.com');

Set($Organization, 'example.com');

Set($CorrespondAddress , 'rt@example.com');

Set($CommentAddress , 'rt-comment@example.com');

# THE WEBSERVER:

Set($WebPath , "/rt");

Set($WebBaseURL , "http://RT3.example.com");

# THE DATABASE:

Set($DatabaseType, ’mysql’);

Set($DatabaseHost, 'localhost');

Set($DatabasePort, '');

Set($DatabaseUser , 'rtuser');

Set($DatabasePassword , 'wibble');

Set($DatabaseName, ’rtdb’);

#--------------------------------------------------------------------------------

Create database

sudo /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password

This should be the result:

Working with:

Type: mysql

Host: localhost

Name: rtdb

User: rtuser

DBA: root

Now creating a mysql database rtdb for RT.

Done.

Now populating database schema.

Done.

Now inserting database ACLs

Granting access to rtuser@'localhost' on rtdb.

Done.

Now inserting RT core system objects

Done.

Now inserting data

Done inserting data

Done.

Add rt perl module to apache

Backup apache configuration file

sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/default.orig

Edit the configuration file

sudo vi /etc/apache2/sites-available/default

Add the following line to the VirtualHost section of Apache from which you wish to serve RT

Paste at the end of the file just before the closing virtualhost tag

Include /etc/request-tracker3.8/apache2-modperl2.conf
RedirectMatch ^/$ /rt

save and exit the file

Add the module

sudo a2enmod rewrite

Restart webserver

sudo /etc/init.d/apache2 restart

Start using Request Tracker

Now you are ready to logon to Request Tracker on ‘http://yourdomain.com/rt’ using

User: root

Password: password

And you are on your way, have fun J