UbuntuInstallGuide

From Request Tracker Wiki
Jump to navigation Jump to search


Unofficial Installation Guide

This is an unofficial installation guide. It may be outdated or apply only to very specific configurations and versions. The official and maintained installation steps for RT are in the README and UPGRADING documents included in the official .tar.gz packages.




This page 'UbuntuInstallGuide' is tagged as OUTDATED
This page contains out of date and possibly misleading information or instructions such as installation methods or configuration examples that no longer apply. Please consider this warning when reading the page below.
If you have checked or updated this page and found the content to be suitable, please remove this notice by editing the page and remove the Outdated template tag.



Howto Install Request-Tracker 3.4 on Ubuntu Dapper Server 6.06

aka HowTo Install Ubuntu, Request-Tracker, Apache2, PostgreSql, Postfix

http://howtoforums.net/viewtopic.php?t=48

"RT is an enterprise-grade ticketing system which enables a group of people to intelligently and efficiently manage tasks, issues, and requests submitted by a community of users."

http://bestpractical.com/rt/

Overview

This How to 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 theadditional services required for Request-Tracker, such as

  • Apache2 - Web Server
  • Postfix - Email Server (for sending emails)
  • PostgreSql-7.4 - 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.

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 ''#'' from

deb http://us.archive.ubuntu.com/ubuntu/ dapper universe

Update your apt package list

apt-get update

Install the Packages

apt-get install request-tracker3.4 rt3.4-apache2 rt3.4-clients apache2-doc postfix postgresql postgresql-doc-7.4 lynx libdbd-pg-perl

You may see the following warnings during the installation

  • 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'.
  • You will also see this: Configuring postgresql-common
Obsolete major version 7.4

The PostgreSQL version 7.4 is obsolete, but you still have the server and/or client package installed.
Please install the latest packages (postgresql-8.1 and postgresql-client-8.1) and upgrade your existing
clusters with
  pg_upgradecluster (see manpage).

Please be aware that the installation of postgresql..................
The old server and client..................

Do not worry about it, just click OK, as RT3.4 is certified with 7.4.

Configure Rt

  • Backup the RT config file. I like to do this for every conf file I modify
cp -vpr /etc/request-tracker3.4/RT_SiteConfig.pm /etc/request-tracker3.4/RT_SiteConfig.pm.orig
vim /etc/request-tracker3.4/RT_SiteConfig.pm
  • Customize using the directions in the file. Add this to the end of the file before the '''1;'''
Set($DatabaseHost   , 'localhost');
Set($DatabaseRTHost , 'localhost');
  • Create the user for the RT database
su postgres
psql -d template1
CREATE USER rtuser WITH PASSWORD 'wibble' CREATEDB NOCREATEUSER;
\q
exit
  • Customize Postgresql permissions
cp -vpr /etc/postgresql/7.4/main/pg_hba.conf /etc/postgresql/7.4/main/pg_hba.conf.orig
vim /etc/postgresql/7.4/main/pg_hba.conf

In the section labelled ''Put your actual configuration here'', but above section labelled ''DO NOT DISABLE!'', add the following:

host    template1   rtuser    127.0.0.1    255.255.255.255    password
local   template1   rtuser                                   password
host    rtdb        rtuser    127.0.0.1    255.255.255.255   password
local   rtdb        rtuser                                   password

More info on Creating a Database

Databases are created with the query language command CREATE DATABASE:

CREATE DATABASE name

where name follows the usual rules for SQL identifiers. The current user automatically becomes the owner of the new database. It is the privilege of the owner of a database to remove it later on (which also removes all the objects in it, even if they have a different owner).

The creation of databases is a restricted operation. See Section 7.1.1 for how to grant permission.

Bootstrapping: Since you need to be connected to the database server in order to execute the CREATE DATABASE command, the question remains how the first database at any given site can be created. The first database is always created by the initdb command when the data storage area is initialized. (See Section 3.2.) By convention this database is called template1. So to create the first "real" database you can connect to template1.

The name "template1" is no accident: When a new database is created, the template database is essentially cloned. This means that any changes you make in template1 are propagated to all subsequently created databases. This implies that you should not use the template database for real work, but when used judiciously this feature can be convenient. More details appear below.

As an extra convenience, there is also a program that you can execute from the shell to create new databases, createdb.

createdb dbname

Configure Postgres

cp -vpr /etc/postgresql/7.4/main/postgresql.conf /etc/postgresql/7.4/main/postgresql.conf.orig
vim /etc/postgresql/7.4/main/postgresql.conf

Make sure this is enabled

tcpip_socket = true

Restart Database

/etc/init.d/postgresql-7.4 restart

Test the dabase connection:

psql -d template1 -U rtuser -W

Enter password at the prompt, we set it to ''wibble'' in the example above

\q

Create the RT Database

/usr/sbin/rt-setup-database-3.4 --action init --dba rtuser --prompt-for-dba-password

Enter password at the prompt, we set it to wibble in the example above. Your rt database will be created.

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.4/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.

Setup RTFM

Check to make sure that 'wget' is available on the Ubuntu distibution. Code:

apt-get install wget

To setup the Request Tracker FAQ Manager with RT 3.4, download the 2.1.40 release using wget at the command line. Code:

cd ~
mkdir rtfm
cd rtfm
wget http://download.bestpractical.com/pub/rt/devel/RTFM-2.1.40.tar.gz

Extract the archive. Code:

cd rtfm
tar -zxvf RTFM-2.1.40.tar.gz

Add the required modules using MCPAN. Code:

perl -MCPAN -e'install Text::WikiFormat'
perl -MCPAN -e'install HTML::TreeBuilder'
perl -MCPAN -e'install HTML::Format'

NOTE: It may be: perl -MCPAN -e'install Text::Format' instead

Create the Makefile for rtfm. Code:

cd RTFM-2.1.40
perl Makefile.PL

Whem prompted for the path for RT.pm, enter:

/usr/share/request-tracker3.4/lib

Dont worry about the fact that the YAML prerequisite is not found. Now, call the make programm to install the files. Code:

make install

Following this, you have to make some modifications to the file etc/acl.Pg. Code:

cp -vpr etc/acl.Pg etc/acl.Pg.orig
vim etc/acl.Pg

There will be a number of lines under my @tables = wq(. You will need to eliminate all the FM_* lines EXCEPT for the ones below:

FM_Classes_id_seq
FM_Classes
FM_Articles_id_seq
FM_Articles
FM_Topics_id_seq
FM_Topics
FM_ObjectTopics_id_seq
FM_ObjectTopics_id_seq

Save and exit the viewer and then initialize the db. You will need the database password that you used before (default is 'wibble' - or whatever you changed it to). You will have to type the database password twice. Code:

make initdb

A successful database intializtion will end with the text "Done setting up database ACLs". RTFM should now work in RT.

If you need to reset the databases, simply type:

make dropdb

There may be some errors with respect to some sequences not existing, but that's OK.

SSL Mode: https

If you want to have Request-Tracker Secure than you are going to have to configure apache2 to run in ssl mode. Take a look at this HowTo for more information:

https://wiki.ubuntu.com/forum/server/apache2/SSL

I have also included my apache2 configs below.

IMPORTANT:

Remember to change appropriate line in RT_SiteConfig.pm.

Before (Without SSL): Set($WebBaseURL , " http://howtoforums.net");

After (With SSL): Set($WebBaseURL , " https://howtoforums.net:443");

Mail Settings

This part is really network specific, but if you are going to use Request-Tracker as "support" mailbox organizer so to speak, than you need to set up the system to pull email. One method would be using fetchmail which can grab mail from an IMAP/POP3 account and put it in the system. The links below describe this process:

http://wiki.bestpractical.com/index.cgi?POP3Mailgate
http://wiki.bestpractical.com/index.cgi?ManualInstallation

(Search for "Setting Up the Mail Gateway") for the basic email settings

These are the packages if your going for the configuration with fetchmail and postfix as the outgoing smtp server Code:

apt-get install fetchmail fetchmailconf fetchmail-ssl postfix ca-certificates


DON'T Forget: you need to have "CreateTicket" permissions on "Queue General" or any queue that you throw the emails in from the user fetching the mail

Example Confs

Example Request-Tracker Config File


File: /etc/request-tracker3.4/RT_SiteConfig.pm

Code:

# RT_SiteConfig.pm
 #
 # These are the bits you absolutely *must* edit.
 #
 # To find out how, please read
 #   /usr/share/doc/request-tracker3.4/INSTALL.Debian
 
 # THE BASICS:
 
 Set($rtname, ' support.howtoforums.net');
 Set($Organization, 'howtoforums.net');
 
 Set($CorrespondAddress , ' SUPPORT-DO-NOT-REPLY@howtoforums.net ');
 Set($CommentAddress , 'SUPPORT-DO-NOT-REPLY@howtoforums.net');
 
 Set($Timezone , 'Europe/London'); # obviously choose what suits you
 
 # THE DATABASE:
 
 Set($DatabaseType, 'Pg'); # e.g. Pg or mysql
 
 # These are the settings we used above when creating the RT database,
 # you MUST set these to what you chose in the section above.
 
 Set($DatabaseUser , 'rtuser');
 Set($DatabasePassword , 'wibble');
 Set($DatabaseName , 'rtdb');
 
 # THE WEBSERVER:
 
 Set($WebPath , "/rt");
 Set($WebBaseURL , " http://howtoforums.net");
 
 Set($DatabaseHost   , 'localhost');
 Set($DatabaseRTHost , 'localhost');
 
 1;
 
 
 

Example Apache2 Configuration files:


File: /etc/apache2/sites-available/default

Code:

NameVirtualHost *:80
<VirtualHost *:80>
      ServerName support.howtoforums.net
      ServerAdmin support@howtoforums.net

      DocumentRoot /var/www
      <Directory />
              Options FollowSymLinks
              AllowOverride None
      </Directory>
      <Directory /var/www/>
              Options Indexes FollowSymLinks MultiViews
              AllowOverride None
              Order allow,deny
              allow from all
              # Uncomment this directive is you want to see apache2's
              # default start page (in /apache2-default) when you go to /
              #RedirectMatch ^/$ /apache2-default/
      </Directory>

      ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
      <Directory "/usr/lib/cgi-bin">
              AllowOverride None
              Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
              Order allow,deny
              Allow from all
      </Directory>

      ErrorLog /var/log/apache2/error.log

      # Possible values include: debug, info, notice, warn, error, crit,
      # alert, emerg.
      LogLevel warn

      CustomLog /var/log/apache2/access.log combined
      ServerSignature On

  Alias /doc/ "/usr/share/doc/"
  <Directory "/usr/share/doc/">
      Options Indexes MultiViews FollowSymLinks
      AllowOverride None
      Order deny,allow
      Deny from all
      Allow from 127.0.0.0/255.0.0.0 ::1/128
  </Directory>

      #Redirect Request-Tracker to SSL
      RewriteEngine   on
      RewriteCond     %{SERVER_PORT} ^80$
      RewriteRule     ^/rt(.*)$ https://%{SERVER_NAME}/rt$1 [L,R]
      RewriteLog      "/var/log/apache2/rewrite.log"
      RewriteLogLevel 2

      #Request-Tracker Uncomment below if you are not redirecting and you want to answer on port 80
      #Include "/etc/request-tracker3.4/apache2-modperl2.conf"

</VirtualHost>


File: /etc/apache2/sites-available/ssl Code:

NameVirtualHost *:443
<VirtualHost *:443>
      ServerName support.howtoforums.net
      ServerAdmin support@howtoforums.net

      SSLEngine On
      SSLCertificateFile /etc/apache2/ssl/apache.pem

      DocumentRoot /var/www
      <Directory />
              Options FollowSymLinks
              AllowOverride None
      </Directory>
      <Directory /var/www/>
              Options Indexes FollowSymLinks MultiViews
              AllowOverride None
              Order allow,deny
              allow from all
              # Uncomment this directive is you want to see apache2's
              # default start page (in /apache2-default) when you go to /
              #RedirectMatch ^/$ /apache2-default/
      </Directory>

      ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
      <Directory "/usr/lib/cgi-bin">
              AllowOverride None
              Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
              Order allow,deny
              Allow from all
      </Directory>

      ErrorLog /var/log/apache2/error.log

      # Possible values include: debug, info, notice, warn, error, crit,
      # alert, emerg.
      LogLevel warn

      CustomLog /var/log/apache2/access.log combined
      ServerSignature On

  Alias /doc/ "/usr/share/doc/"
  <Directory "/usr/share/doc/">
      Options Indexes MultiViews FollowSymLinks
      AllowOverride None
      Order deny,allow
      Deny from all
      Allow from 127.0.0.0/255.0.0.0 ::1/128
  </Directory>

      #Request-Tracker
      Include "/etc/request-tracker3.4/apache2-modperl2.conf"

</VirtualHost>


Enjoy! Jacob

http://howtoforums.net


Notes:

The 'local' directory for the Ubuntu package is in /usr/local/request-tracker3.4. You can place your customized templates, libs, etc. into this directory. See CleanlyCustomizeRT for more details about this directory.



HowTo Install Request-Tracker 3.4 on Ubuntu Breezy 5.10

IMPORTANT: I put a space after every http to by pass the wiki spam detection

http://howtoforums.net/viewtopic.php?p=32

This HowTo will explain how to install request-tracker on a clean Ubuntu Server install. It is tested on Ubuntu Breezy 5.10 and mite work with slight modifications on other versions or Debian based distros. I create a root user as apposed to using sudo, just because i am used to it but you may add sudo in front of the commands if you prefer the sudo security default method of Ubuntu.

To activate the root user:

sudo passwd root


Enable universe in your Sources.list

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

vim /etc/apt/sources.list

  1. comment this:
apt-get update
apt-get install postgresql libcgi-fast-perl apache2-mpm-prefork libapache2-mod-fcgid lynx apache2-doc libapache2-mod-perl2
apt-get install request-tracker3.4



  1. BKUP the RT config file...I like to do this for every conf file I modify
cp -vpr /etc/request-tracker3.4/RT_SiteConfig.pm /etc/request-tracker3.4/RT_SiteConfig.pm.orig



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


Customize and add this...

Set($DatabaseHost   , 'localhost');
Set($DatabaseRTHost , 'localhost');


Create the user for the RT database

su postgres
psql -d template1
CREATE USER rtuser WITH PASSWORD 'wibble' CREATEDB NOCREATEUSER;
\q
exit


Customize Postgresql permissions

vim /etc/postgresql/7.4/main/pg_hba.conf

at the bottom of the file along with the other similar lines - but above existing entries.

host    template1   rtuser    127.0.0.1    255.255.255.255   password
local   template1   rtuser                                   password
host    rtdb        rtuser    127.0.0.1    255.255.255.255    password
local   rtdb        rtuser                                   password

vim /etc/postgresql/7.4/main/postgresql.conf

make sure this is enabled

tcpip_socket = true


Restart Database

/etc/init.d/postgresql-7.4 restart



Test db connection

psql -d template1 -U rtuser -W
  1. enter password at the prompt

Create the RT DataBase

/usr/sbin/rt-setup-database-3.4 --action init --dba rtuser --prompt-for-dba-password



Configure Apache2

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.4/apache2-modperl2.conf"

vim /etc/request-tracker3.4/apache2-modperl2.conf

comment this

#PerlFreshRestart Off
 
 
 

Fix for the error complaining about can't find stuff

ln -s /usr/lib/perl5/Bundle/Apache2.pm /usr/lib/perl5/Apache2.pm
ln -s /usr/lib/perl5/Apache2/compat.pm /usr/lib/perl5/Apache/compat.pm
ln -s /usr/lib/perl5/Apache2/RequestUtil.pm /usr/lib/perl5/Apache/RequestUtil.pm


Restart Apache

/etc/init.d/apache2 force-reload

http://yourdomain.com/rt

using user root and password "password" (without quotation marks of course) change this passwd asap via the Configuration menu

This part is really network specific, but if you are going to use Request-Tracker as "support" mailbox organizer so to speak, than you need to set up the system to pull email. One method would be using fetchmail which can grab mail from an IMAP/POP3 account and put it in the system. The links below describe this process:

http ://wiki.bestpractical.com/index.cgi?POP3Mailgate
http ://wiki.bestpractical.com/index.cgi?ManualInstallation

(Search for "Setting Up the Mail Gateway") for the basic email settings

These are the packages if your going for the configuration with fetchmail and postfix as the outgoing smtp server

apt-get install fetchmail fetchmailconf  fetchmail-ssl postfix ca-certificates

you need to have "CreateTicket" permissions on "Queue General" or any queue that you throw the emails in from the user fetching the mail

Enjoy!

Jacob Baloul

http://howtoforums.net


Ubuntu 5.10 Install

We assume you're starting from a fresh 5.10 (Breezy Badger) install

Prep

Add multiverse and universe to your /etc/apt/sources.list ( https://wiki.ubuntu.com/AddingRepositoriesHowto)

Next, grab the following packages

sudo apt-get install apache2 mysql-server mysql-client
sudo apt-get install libapache2-mod-fastcgi
sudo apt-get install libcgi-fast-perl
sudo apt-get install rt3.4-apache2 request-tracker3.4

Config

Edit /etc/request-tracker3.4/RT_SiteConfig.pm appropriately. Make sure the db type is mysql. Setup the database (we assume you're using the values from RT_SiteConfig.pm)

sudo mysqladmin password foo
sudo mysql -p
mysql>grant all on rtdb.* to rtuser@localhost identified by 'wibble';

This next line might not be necessary. If the rt-setup-database-3.4 command fails, do this.

mysql>drop database rtdb;
mysql>quit

Use rt's binaries to setup the database and populate it.

sudo rt-setup-database-3.4 --action init -dba rtuser --prompt-for-dba-password

Setup fastcgi

sudo a2enmod fastcgi

Setup apache2

sudo ln -s /etc/request-tracker3.4/apache-fastcgi.conf /etc/apache2/conf.d/

Comment out the FastCgiIpcDir line (it's already present in another file) and redirect /rt to /rt/ (so that you are directed to the right place after logging in), like this:

#FastCgiIpcDir /var/run/fastcgi
 RedirectMatch ^/rt$ /rt/
 
 

Make sure your apache2 install owns RT_SiteConfig.pm. Replace www-data with the appropriate.

sudo chown www-data: /etc/request-tracker3.4/RT_SiteConfig.pm

reload apache2.

sudo /etc/init.d/apache2 force-reload


Done =)


Below is a work in progress for installing RT in Feisty. The steps are essentially the above, but I'm attempting to use an Oracle Database XE backend.


Howto Install Request-Tracker 3.6 on Ubuntu Feisty Server 7.04

Overview

This Howto will explain how to install request-tracker on a clean Ubuntu Feisty Server install.

It is tested on Ubuntu Feisty 7.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)
  • PostgreSql-8.2 - Database to Store the RT information.

Prerequisites

You need the universe repository for apt

Update your system

apt-get update
apt-get upgrade
apt-get dist-upgrade (if necessary to get kernel updates).  Reboot if you have a kernel update.

Each of the prerequisites is a job in and of itself. Apache2, Postfix, Postgre are all powerful services in and of themselves. Glazing over their installation, configuration and setup could lead to significant problems later on. Indeed proper Postfix configuration requires an understanding of how internet mail works, and may require DNS changes, or MX records added.

  • hostname and dnsdomainname
  • Proper firewall configuration. Apache2 listens on TCP Port 80. Postfix listens on TCP Port 25 (and maybe 587). Oracle Database XE is on TCP port 8080. Shorewall is a good choice if you need one.
  • Apache2
  • Postfix
  • Oracle Database XE (Express)
  • rt3.6-apache2

hostname and dnsdomainname

If you will be processing real E-mail to and/or from RT, you will need to have your hostname and dnsdomain name correctly configured.

hostname
dnsdomainname

If either of those do not return what you expect, it should be corrected now. If you want a particular dnsdomainname, but it's not set right and you are using DHCP to get your public IP address, check out /etc/dhcp3/dhclient.conf. Uncomment and the supercede domain-name entry. Then fix the entry in /etc/hosts.

Now might be a good time to verify what DNS servers your system is using, especially if you are going to process "real" e-mail.

cat /etc/resolv.conf

If that's not what you expect, again check /etc/dhcp3/dhclient.conf and add a supercede domain-name-servers x.x.x.x; Correct your /etc/resolv.conf and/or reboot (the idea is to cycle dhclient, which can be done with an ifdown/ifup, but if you are working remotely, the ifdown will break your connection.)

Apache 2

You should spend some time understanding how Apache works, the role and function of httpd.conf (Ubuntu calls it apache2.conf). A single instance of Apache2 can be setup to do alot more than just RT. http://ubuntuguide.org/wiki/Ubuntu:Feisty#Apache_HTTP_Server

sudo apt-get install apache2 apache2-doc
cd /etc/apache2/mods-enabled/
sudo ln -s ../mods-available/rewrite.load .
sudo nano /etc/default/apache2  # change NO_START=1 to NO_START=0
sudo /etc/init.d/apache2 start

Use a webbrowser to hit your machine. This could be http://localhost/ if your browser is on the same machine. Check /var/log/apache2/error.log for errors and monitor /var/log/apache2/access.log for accesses.

Postfix

Postfix is responsible for E-mail for your entire system. It is important that it is is configured properly. As of this writing the default installation does not leave Postfix as an Open Relay (a very bad thing). This can be tricky if your ISP is blocking outbound SMTP (tcp port 25) connections. http://www.howtoforge.com/perfect_setup_ubuntu704_p5

sudo apt-get install postfix
during the installation you will be prompted for some configuration options.  One thing that is assumed, is that your hostname and dnsdomainname are correctly configured (see above).

In my situation, my ISP was blocking outbound tcp port 25 connections, so I had to use a smart host. First I chose the "Internet Connection with SmartHost" and configured my relay host as "mail.myisp.com:587" the 587 is important. 587 is ESTMP which is like SMTP but requires authentication.

After Postfix was installed, to enable esmtp:

sudo postconf -e 'smtp_sasl_auth_enable = yes'
sudo postconf -e 'smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd'
sudo postconf -e 'smtp_sasl_security_options ='
sudo echo "smtp.ispsmarthost.com   myispaccount:mypassword' > /etc/postfix/sasl_passwd
sudo chown root:root /etc/postfix/sasl_passwd
sudo chmod 600 /etc/postfix/sasl_passwd
sudo postmap /etc/postfix/sasl_passwd
/etc/init.d/postfix restart

Then I tried to send some mail:

sendmail myaddress@mydomain.com
Hello there
.
tail /var/log/mail.log

I didn't see any errors and I received my E-mail. It had a FROM: address of localaccount@hostname.dnsdomain which was interesting. I couldn't reply to it.

I have a hosted domain, so I added a DNS A record for my hostname.dnsdomain (not an MX record) and I was able to send a reply back. I couldn't read it untill I installed nail with a sudo apt-get install nail. Nail is a simple command line mail reader.

I also ran a http://www.abuse.net/relay.html to test my Postfix configuration for being an open relay. It was not.

Oracle Database XE

Oracle Database Express has some significant limitations (4gb database size for one), but in a corporation already using an Oracle database, these XE instructions might transfer to running the RT database on it. http://www.oracle.com/technology/tech/linux/install/xe-on-kubuntu.html

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle  -O- | sudo apt-key add -

Add this line to the bottom of your /etc/apt/sources.list

deb http://oss.oracle.com/debian unstable main non-free >>

sudo apt-get install oracle-xe

221MB later, and oracle is installed.

rt3.6-apache2

This package satisfies the apache requirements for RT. If you were to go straight to installing RT, then Apache (1) would get installed along side Apache2

sudo apt-get install rt3.6-apache2

Installing Request Tracker 3.6

With all the prerequisites satisfied, we can install the main Request Tracker package, and it's perl dependancies.

sudo apt-get install request-tracker3.6

Suggested Packages:

libsort-versions-perl ttf-dustin libgd-tools libhtml-mason-perl-doc speedy-cgi-perl

Recommended Packages:

libdatetime-perl libio-socket-ssl-perl

Backup the default SiteConfig:

cp -vpr /etc/request-tracker3.4/RT_SiteConfig.pm /etc/request-tracker3.4/RT_SiteConfig.pm.orig

... Work in progress. See the beginning of this document for what to do next.