Request Tracker Installation On Ubuntu

Hi All...

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

Overview

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

Enter

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 http://us.archive.ubuntu.com/ubuntu/ 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/main.cf (and others) as needed. To view Postfix configuration
values, see postconf(1).

After modifying main.cf, 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/RT_SiteConfig.pm /etc/request-tracker3.6/RT_SiteConfig.pm.orig

vim /etc/request-tracker3.6/RT_SiteConfig.pm

* 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

GRANT ALL PRIVILEGES ON rtdb.* TO 'rtuser'@'localhost' IDENTIFIED BY 'p4ssw0rd'; FLUSH PRIVILEGES; QUIT

* 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

Test

You can now login to:

http://yourdomain.com/rt

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


Best Source : http://www.bestpractical.com/rt