Saturday, January 17, 2009

Request Tracker Installation On Ubuntu

Hi All...

Howto Install Request-Tracker 3.6 (mysql) on Ubuntu Dapper Server 6.06


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

It also installs the additional services required for Request-Tracker, such as

* Apache2 - Web Server
* Postfix - Email Server (for sending emails)
* Mysqld 5.0.22-- Database to Store the RT information.

Install the Request Tracker Packages
Open a Root Login Shell


sudo -s

as member of the admin group to get a root-login shell.
Enable Universe

Enable universe in your apt ''sources.list''

cp -vpr /etc/apt/sources.list /etc/apt/sources.list.orig
vim /etc/apt/sources.list

Uncomment universe sources, by removing the ''#''.

deb dapper universe

Update your apt package list

apt-get update

Install the Packages

apt-get install rt3.6-apache2 (this will also take care of some prerequisites)

apt-get install request-tracker3.6 rt3.6-clients apache2-doc postfix mysql-server lynx libdbd-pg-perl

* In the "Postfix Configuration" - I choose "Internet Site", just because I prefer to have the system send emails without being dependent on a different mail server. The logic behind that is because if the email server goes down, the ticket server should NOT follow.
* You should see this message after the install is done...

Postfix is now set up with a default configuration. If you need to make
changes, edit
/etc/postfix/ (and others) as needed. To view Postfix configuration
values, see postconf(1).

After modifying, be sure to run '/etc/init.d/postfix reload'.

Configure Rt

* Backup the RT config file. I like to do this for every conf file I modify

cp -vpr /etc/request-tracker3.6/ /etc/request-tracker3.6/

vim /etc/request-tracker3.6/

* Customize using the directions in the file.

Create the Database

I used the ConfigureMysqlOnGentoo guide as reference and had issues with the script my workaround was to create the database, create the user, drop the database and recreate the database and it worked fine.

* Use script to create database (don’t worry about user error message we will fix this later)

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

* As root, login to MySQL

mysql –p

*Create user CREATE USER rtuser IDENTIFIED BY 'p4ssw0rd';

* Grant access rights to rtuser


* Drop the database

mysqladmin drop rtdb –p

* Recreate the database using the script (it should work this time)

/usr/sbin/rt-setup-database-3.6 --action init --dba root --prompt-for-dba-password
Configure Apache2
Add the Virtual Host Config

cp -vpr /etc/apache2/sites-available/default /etc/apache2/sites-available/default.orig
vim /etc/apache2/sites-available/default

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

Include "/etc/request-tracker3.6/apache2-modperl2.conf"
Enable Apache2 RewriteEngine

cd /etc/apache2/mods-enabled/
ln -s ../mods-available/rewrite.load .

Install Apache::Session

Make sure that you update the 'make', 'tar', 'unzip', and 'gzip' libraries in your distribution prior to installing ''Apache::Session'':

apt-get install make tar gzip unzip

Check that Apache::Session is installed. If necessary, install (as root) with

cpan install Apache::Session

Restart Apache

/etc/init.d/apache2 force-reload


You can now login to:

using user root and password "password" (without quotation marks of course). Change this passwd ASAP via the Configuration menu.

Best Source :

No comments: