You're not currently signed in. Sign in.

Howto Install Request-Tracker 3.6 (mysql) on Ubuntu Hardy Server 8.04

Overview

This Howto will explain how to install request-tracker on a clean Ubuntu Dapper Server install. It is tested on Ubuntu Hardy 8.04 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 - Database to Store the RT information.

Install the Request Tracker Packages

Open a Root Login Shell

Enter 

sudo -i

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

Update your apt package list

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

*You can also add the module the 'apache2' way by typing 

a2enmod rewrite

Below i am still working on

Install Apache::Session

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

aptitude install make tar gzip unzip

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

cpan install Apache::Session

(hit no for manual configuration and yes for prepending modules, you will be asked about prepending a few times)

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. You can know tweak and use RT

Install RTFM FAQ Manager for Request Tracker 3.6

aptitude install rt3.6-rtfm