HowToInstallRequest-Tracker3.8OnUbunto9.10

HowTo Install Request-Tracker 3.8 on ubuntu 9.10 and MySQL

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.

• Process works on RT3.8 and Ubuntu11.4. (6/27/2011)*

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 libapache-dbi-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 rt3.8-db-mysql

Answer Y

*In install request-tracker3.8(I found Ubuntu server 9.10's packet don't include rt3.8-db-mysql),if don't install it,create the mysql Database will create sqlite3's database,don't create mysql's.)*
  

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?

* RT default install DIR is /usr/share/request-tracker3.8/html *
  

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 /etc/request-tracker3.8/apache2-modperl2.conf

sudo vi /etc/request-tracker3.8/apache2-modperl2.conf

1. Limit mail gateway access to localhost by default
   
   Order Allow,Deny
   Allow from ALL #127.0.0.1 turned into all
   

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

• In the step,you need add VirtualHost config code in the 'default' file. *The VirtualHost like the /var/www/,but in </VirtualHost> front add up two line.

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 :-).