Admin: 11 revisions imported

2016-04-06T20:11:24Z

11 revisions imported

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

86.25.244.212: /* Install RT 3.8 libraries for Apache */

2012-04-30T14:21:53Z

Install RT 3.8 libraries for Apache

New page

{{OutdatedInstallGuide}}
__TOC__

= HowTo Install RT 3.8 with MySQL on Ubuntu 11.04 Server =
'''DRAFT; IN-PROCESS REVISION OF [[HowTo Install Request-Tracker 3.8 on ubuntu 9.10 and MySQL]]'''

This How-To will explain how to install request-tracker on a clean Ubuntu Server 11.04 64-bit install. It is tested on Ubuntu 11.04 with LOCAL and REMOTE MySQL databases. These tests were done using FULLY VIRTUALIZED servers running under VirtualBox4.1.0

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
* Configuration for using a MySQL database on another local server.

= Ubuntu Server =
== Install Ubuntu Server ==
# Boot from ISO or DVD.
# Accept all defaults plus...
# Software Selection:
## OpenSSH server
## LAMP server
## Mail server
# Assign password for MySQL "root" user.
# Repeat password
# Accept remaining defaults and reboot

== Update and Upgrade ==
# Logon via SSH to make cut-and-paste easier
# Make sure you have the latest software
#:<tt>sudo apt-get update</tt>
#:<tt>sudo apt-get upgrade</tt>

= MySQL =
== Install MySql with PERL interface ==
''MySQL Server should already be installed if you selected '''LAMP server''' above. If not...''
#<tt>sudo apt-get install mysql-server</tt>
#<tt>sudo apt-get install libdbd-mysql-perl</tt>

== Install MySQL libraries for RT 3.8 ==
# <tt>sudo apt-get install rt3.8-db-mysql</tt>

= Apache =
== Install PERL libraries for Apache ==
# <tt>sudo apt-get install libapache-dbi-perl </tt>

== Install RT 3.8 libraries for Apache ==
<tt>sudo apt-get install rt3.8-apache2</tt>

= Mail Server =
== Install Postfix mail server (SMTP Server) ==
# <tt>sudo apt-get install postfix</tt>
# Choose "Internet Site" in the install dialogue.
# Accept or correct the name of the mail server
#: ''e.g. <tt>rt.server.yourdomain.com</tt>''

= Request Tracker 3.8 Itself =
== Install RT server and client ==
#<tt>sudo apt-get install request-tracker3.8 rt3.8-clients</tt>
'''NOTE: RT default install DIR is <tt>/usr/share/request-tracker3.8/</tt>'''

== Name Your RT instance ==
'''This is something you won't ever want to change. It will appear in the subject of EVERY piece of mail RT sends out, and most of the mail your users will send in as well. It will be shown on every RT screen in the title "RT for {rt_name}". Pick carefully!'''
# Enter something like <tt>mydomain.com</tt> or <tt>rt.mydomain</tt>

== Baseline Configuration of Your RT Instance ==
# Answer "Yes" to "Handle [[RT SiteConfig|RT_SiteConfig]].pm permissions?"
# Answer “No” to "Configure database for request-tracker3.8 with dbconfig-common?"

== Additional Configuration of Your RT Instance ==
'''NOTE:''' Many of the install guides specify direct modification of <tt>RT_SiteConfig.pm</tt>. '''This is no longer the correct method for configuration updates!''' Instead you should use the following method for all RT configuration updates:
# Go to the RT_SiteConfig.d '''directory'''
#:<tt>cd /etc/request-tracker3.8/RT_SiteConfig.d</tt>
# Modify one or more of the configuration files in that directory, e.g.:
#:<tt>sudo vim 40-timezone</tt> '''or''' <tt>sudo nano 40-timezone</tt>
#:<tt>sudo vim 50-debconf</tt>
#:<tt>sudo vim 51-dbconfig-common</tt>
#:<tt>sudo vim 90-local</tt> '''''Put your own special configuration elements in this file.'''''
# Backup the RT_SiteConfig.pm file
#:<tt>cd ..</tt>
#:<tt>sudo cp RT_SiteConfig.pm RT_SiteConfig.pm.orig </tt>
# <tt>Re-generate the RT_SiteConfig.pm file </tt>
#:<tt>sudo update-rt-siteconfig-3.8</tt>

== Check/Modify Basic Configuration ==
# Enter the configuration directory
#:<tt>cd /etc/request-tracker3.8/RT_SiteConfig.d</tt>
# Look at the basic configuration file (press "q" to exit)
#:<tt>sudo less 50-debconf </tt>
# Modify if needed
#:<tt>sudo cp 50-debconf 50-debconf.orig </tt>
#:<tt>sudo vim 50-debconf</tt>
To eliminate an extra (for me) "/rt" in the URL, I change the WebPath as follows:
FROM: Set($WebPath , "/rt");
TO: Set($WebPath , "");
So my '''<tt>50-debconf</tt>''' file looks like this:
<pre>
# THE BASICS:

Set($rtname, 'dev.mydomain.com');
Set($Organization, 'rt.mydomain.com');

Set($CorrespondAddress , 'rt@rt.mydomain.com');
Set($CommentAddress , 'rt-comment@rt.mydomain.com');

# THE WEBSERVER:

Set($WebPath , "");
Set($WebBaseURL , "http://rt.mydomain.com");
</pre>

== Check/Modify Database Configuration ==
# Enter the configuration directory
#:<tt>cd /etc/request-tracker3.8/RT_SiteConfig.d</tt>
# Look at the basic configuration file (press "q" to exit)
#:<tt>sudo less 51-dbconfig-common </tt>
# Modify if needed
#:<tt>sudo cp 51-dbconfig-common 51-dbconfig-common.orig</tt>
#:<tt>sudo vim 51-dbconfig-common</tt>
To use MySQL on '''<tt>localhost</tt>''', my '''<tt>51-dbconfig-common</tt>''' file looks like this::
<pre>
# THE DATABASE:
# generated by dbconfig-common
# Updated to use MySQL only

# map from dbconfig-common database types to their names as known by RT
# my %typemap = (
# mysql => 'mysql',
# pgsql => 'Pg',
# sqlite3 => 'SQLite',
# );

# Set($DatabaseType, $typemap{} || "UNKNOWN");
Set($DatabaseType, 'mysql');

# Values for a LOCALHOST database:
Set($DatabaseHost, 'localhost');
Set($DatabasePort, '');

# Values for a REMOTE DATABASE SERVER:
# Set($DatabaseHost, 'dbhostname');
# Set($DatabasePort, '3306');

Set($DatabaseUser , 'rtuser');
Set($DatabasePassword , 'rtdbpasswd');

# SQLite needs a special case, since $DatabaseName must be a full pathname
# my $dbc_dbname = ''; if ( "" eq "sqlite3" ) { Set ($DatabaseName, '' . '/' . $dbc_dbname); } else { Set ($DatabaseName, $dbc_dbname); }

my $dbc_dbname = 'rtdb';
Set ($DatabaseName, $dbc_dbname);
</pre>

== Create New RT_SiteConfig.pm File ==
# Backup the RT_SiteConfig.pm file
#:<tt>cd ..</tt>
#:<tt>sudo cp RT_SiteConfig.pm RT_SiteConfig.pm.orig </tt>
# <tt>Re-generate the RT_SiteConfig.pm file </tt>
#:<tt>sudo update-rt-siteconfig-3.8</tt>

== Create the Database ==
# Use script to create database (don’t worry about user error message we will fix this later)
#: <tt>sudo /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password</tt>
# '''On your database host''', login to [[MySQL]] as '''root'''
#: <tt>mysql -uroot -p</tt>
# Create user properly
#: <tt>CREATE USER rtuser IDENTIFIED BY 'rtdbpasswd';</tt>
# Grant access rights to rtuser
#* If using a remote database host, replace "localhost" (below) with the name of your '''RT host'''.
#: <tt>GRANT ALL PRIVILEGES ON rtdb.* TO 'rtuser'@'localhost' IDENTIFIED BY 'rtdbpasswd';</tt>
#: <tt>FLUSH PRIVILEGES;</tt>
#: <tt>QUIT</tt>
# Drop the database
#: <tt>mysqladmin drop rtdb -p</tt>
# '''Back on the RT host''', recreate the database using the script (it should work this time)
#:<tt>sudo /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password</tt>

= Update Apache Configs (basic) =
'''NOTE:''' These instructions provide basic connectivity via Apache. They do not cover advanced connectivity elements such as SSL, use of conf.d directory, etc.

== Add RT PERL module to Apache ==
# Backup apache configuration file
#:<tt>sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/default.orig</tt>
# Open the Apache default configuration file for editing
#:<tt>sudo vim /etc/apache2/sites-available/default</tt>
# 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 <nowiki></VirtualHost></nowiki> tag.)
#:<tt>Include /etc/request-tracker3.8/apache2-modperl2.conf</tt>
#:<tt>RedirectMatch ^/$ /rt</tt>
# Add the module
#:<tt>sudo a2enmod rewrite</tt>

== Restart Apache ==
# This might work the first time:
#:<tt>sudo service apache2 restart</tt>
# If you get an error, there is a PERL module missing. Install it:
#:<tt>sudo apt-get install libapache-dbi-perl</tt>
# Try again -- it should work now.
#:<tt>sudo /etc/init.d/apache2 restart</tt>

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

HowToInstallRequestTracker3.8OnUbuntu11.04 - Revision history

Admin: 11 revisions imported

86.25.244.212: /* Install RT 3.8 libraries for Apache */