UbuntuInstallGuide - Revision history

Admin: 8 revisions imported

2016-04-06T20:39:35Z

8 revisions imported

← Older revision		Revision as of 16:39, 6 April 2016
(No difference)

202.90.158.7: /* Overview */

2013-04-22T03:33:06Z

Overview

← Older revision		Revision as of 23:33, 21 April 2013
Line 14:		Line 14:
	== Overview ==		== 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.		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 ~~the walang mangingielam~~ required for Request-Tracker, such as		It also installs theadditional services required for Request-Tracker, such as

	* Apache2 - Web Server		* Apache2 - Web Server

202.90.158.7: /* Overview */

2013-04-22T03:32:28Z

Overview

← Older revision		Revision as of 23:32, 21 April 2013
Line 16:		Line 16:
	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.		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		It also installs the walang mangingielam required for Request-Tracker, such as

	* Apache2 - Web Server		* Apache2 - Web Server

196.24.44.6: /* Configure Apache2 */

2013-04-16T12:08:41Z

Configure Apache2

New page

{{OutdatedInstallGuide}}

= 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 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)
* [[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 ===

<nowiki> Enable universe in your apt ''sources.list'' </nowiki>

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

<nowiki> Uncomment universe sources, by removing the ''#'' from </nowiki>

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

* <nowiki>Customize using the directions in the file. Add this to the end of the file before the '''1;''' </nowiki>

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

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

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

<nowiki> Enter password at the prompt, we set it to ''wibble'' in the example above </nowiki>

\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 ====

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

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|RT_SiteConfig]].pm.

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

After (With SSL): Set($[[WebBaseURL]] , " [https://howtoforums.net:443 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|RT_SiteConfig]].pm

Code:

<nowiki># 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;

</nowiki>

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

#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

# 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

#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

<nowiki>#PerlFreshRestart Off

</nowiki>

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|RT_SiteConfig]].pm appropriately. Make sure the db type is mysql. Setup the database (we assume you're using the values from [[RT SiteConfig|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:

<nowiki>#FastCgiIpcDir /var/run/fastcgi
RedirectMatch ^/rt$ /rt/

</nowiki>

Make sure your apache2 install owns [[RT SiteConfig|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

* http://ubuntuguide.org/wiki/Ubuntu:Feisty#General_Notes
* http://ubuntuguide.org/wiki/Ubuntu:Feisty#How_to_add_extra_repositories

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 [mailto:localaccount@hostname.dnsdomain 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.

125.22.193.50: /* Install the Packages */

2012-02-09T11:26:44Z

Install the Packages

New page

{{OutdatedInstallGuide}}

= 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 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)
* [[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 ===

<nowiki> Enable universe in your apt ''sources.list'' </nowiki>

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

<nowiki> Uncomment universe sources, by removing the ''#'' from </nowiki>

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

Update your apt package list

apt-get update

=== desedInstall 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

* <nowiki>Customize using the directions in the file. Add this to the end of the file before the '''1;''' </nowiki>

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

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

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

<nowiki> Enter password at the prompt, we set it to ''wibble'' in the example above </nowiki>

\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 ====

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

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|RT_SiteConfig]].pm.

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

After (With SSL): Set($[[WebBaseURL]] , " [https://howtoforums.net:443 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|RT_SiteConfig]].pm

Code:

<nowiki># 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;

</nowiki>

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

#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

# 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

#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

<nowiki>#PerlFreshRestart Off

</nowiki>

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|RT_SiteConfig]].pm appropriately. Make sure the db type is mysql. Setup the database (we assume you're using the values from [[RT SiteConfig|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:

<nowiki>#FastCgiIpcDir /var/run/fastcgi
RedirectMatch ^/rt$ /rt/

</nowiki>

Make sure your apache2 install owns [[RT SiteConfig|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

* http://ubuntuguide.org/wiki/Ubuntu:Feisty#General_Notes
* http://ubuntuguide.org/wiki/Ubuntu:Feisty#How_to_add_extra_repositories

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 [mailto:localaccount@hostname.dnsdomain 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.