Admin: 3 revisions imported

2016-04-06T20:39:36Z

3 revisions imported

New page

{{OutdatedInstallGuide}}

----

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

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

UbuntuInstallGuide2 - Revision history

Admin: 3 revisions imported