HowToInstallRequest-Tracker3.8OnUbunto9.10 - Revision history

Admin: 9 revisions imported

2016-04-06T20:11:23Z

9 revisions imported

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

173.166.169.133: /* Create database */

2013-03-01T19:13:39Z

Create database

New page

{{UnofficialInstallGuide}}

= HowTo Install Request-Tracker 3.8 on ubuntu 9.10 and MySQL =

This Howto will explain how to install request-tracker on a clean Ubuntu 9.10 Server install. It is tested on Ubuntu 9.10 and might work with slight modifications on other versions or Debian based distributions.

*Process works on RT3.8 and Ubuntu11.4. (6/27/2011)*

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

Logon as a user with the right to use the sudo command.

Make sure you have the latest software

sudo apt-get update
sudo apt-get upgrade

== Install MySql with perl interface ==

sudo apt-get install mysql-server libdbd-mysql-perl libapache-dbi-perl

Answer Y

Type password for root in mysql

Repeat password for root in mysql

== Install the Web server with specific files for request-tracker3.8 ==

sudo apt-get install rt3.8-apache2 rt3.8-db-mysql

Answer Y

<nowiki>*In install request-tracker3.8(I found Ubuntu server 9.10's packet don't include rt3.8-db-mysql),if don't install it,create the mysql Database will create sqlite3's database,don't create mysql's.)*
</nowiki>

== Install mail server (SMTP Server) ==

sudo apt-get install postfix

Choose "Internet Site" in the install dialogue.

Write the name of the local server

== Install Request Tracker 3.8 server and client ==

sudo apt-get install request-tracker3.8 rt3.8-clients

Answer Y

Write rt.domainname

Answer "Yes" to Handle [[RT SiteConfig|RT_SiteConfig]].pm permissions?

Answer “Yes” to Configure database for request-tracker3.8 with dbconfig-common?

<nowiki>* RT default install DIR is /usr/share/request-tracker3.8/html *
</nowiki>

=== Configure Request Tracker 3.8 ===

==== Make backup of configuration file. ====

sudo cp /etc/request-tracker3.8/RT_SiteConfig.pm /etc/request-tracker3.8/RT_SiteConfig.pm.orig

==== Edit Request Tracker configuration file. ====

<nowiki>sudo vim /etc/request-tracker3.8/RT_SiteConfig.pm

#---your file should look something like this ----------------
# vim /etc/request-tracker3.8/RT_SiteConfig.pm
#TIMEZONE – takes the timezone from linux installation.
my $zone = "UTC";
$zone='/bin/cat /etc/timezone'
if -f "/etc/timezone";
chomp $zone;
Set($Timezone, $zone);
# THE BASICS:
Set($rtname, 'RT3.example.com');
Set($Organization, 'example.com');
Set($CorrespondAddress , 'rt@example.com');
Set($CommentAddress , 'rt-comment@example.com');
# THE WEBSERVER:
Set($WebPath , "/rt");
Set($WebBaseURL , "http://RT3.example.com");
# THE DATABASE:
Set($DatabaseType, 'mysql');
Set($DatabaseHost, 'localhost');
Set($DatabasePort, '');
Set($DatabaseUser , 'rtuser');
Set($DatabasePassword , 'wibble');
Set($DatabaseName, 'rtdb');
#--------------------------------------------------------------------------------
</nowiki>

=== Create database ===

sudo /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password

This should be the result:

Working with:

Type: mysql

Host: localhost

Name: rtdb

User: rtuser

DBA: root

Now creating a mysql database rtdb for RT.

Done.

Now populating database schema.

Done.

Now inserting database [[ACLs]]

Granting access to rtuser@'localhost' on rtdb.

Done.

Now inserting RT core system objects

Done.

Now inserting data

Done inserting data

Done.

NOTE : If you receive a message stating that the database is already created, drop the table and then initialize the table. Like this:

/usr/sbin/rt-setup-database-4 --action drop --dba root --prompt-for-dba-password

After the table is dropped you can run the original command in this step to initialize your table.

=== Add rt perl module to apache ===

==== Backup apache configuration file ====

sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/default.orig

==== ====
==== Edit the /etc/request-tracker3.8/apache2-modperl2.conf ====

sudo vi /etc/request-tracker3.8/apache2-modperl2.conf
# Limit mail gateway access to localhost by default<br /><Location /rt/REST/1.0/NoAuth><br />Order Allow,Deny<br />Allow from ALL #127.0.0.1 turned into all<br /></Location>

==== Edit the configuration file ====

sudo vi /etc/apache2/sites-available/default

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 virtualhost tag

Include /etc/request-tracker3.8/apache2-modperl2.conf
RedirectMatch ^/$ /rt

*In the step,you need add [[VirtualHost]] config code in the 'default' file. *The [[VirtualHost]] like the /var/www/,but in </[[VirtualHost]]> front add up two line.

==== Add the module ====

sudo a2enmod rewrite

==== Restart webserver ====

sudo /etc/init.d/apache2 restart

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

183.129.143.162: /* Edit the configuration file */

2012-03-08T07:05:49Z

Edit the configuration file

← Older revision		Revision as of 03:05, 8 March 2012
Line 145:		Line 145:
	sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/default.orig		sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/default.orig

			==== ====
			==== ====

			Edit the /etc/request-tracker3.8/apache2-modperl2.conf

			sudo vi /etc/request-tracker3.8/apache2-modperl2.conf
			# Limit mail gateway access to localhost by default<br /><Location /rt/REST/1.0/NoAuth><br />Order Allow,Deny<br />Allow from ALL #127.0.0.1 turned into all<br /></Location>
	==== Edit the configuration file ====		==== Edit the configuration file ====

Line 151:		Line 158:
	Add the following line to the [[VirtualHost]] section of Apache from which you wish to serve RT		Add the following line to the [[VirtualHost]] section of Apache from which you wish to serve RT

	~~Edit the /etc/request-tracker3.8/apache2-modperl2.conf~~

	~~sudo vi /etc/request-tracker3.8/apache2-modperl2.conf~~
	~~# Limit mail gateway access to localhost by default<br /><Location /rt/REST/1.0/NoAuth><br />Order Allow,Deny<br />Allow from ALL #127.0.0.1 turned into all<br /></Location>~~

	Paste at the end of the file just before the closing virtualhost tag		Paste at the end of the file just before the closing virtualhost tag

183.129.143.162: /* Edit the configuration file */

2012-03-08T07:04:22Z

Edit the configuration file

← Older revision		Revision as of 03:04, 8 March 2012
Line 150:		Line 150:

	Add the following line to the [[VirtualHost]] section of Apache from which you wish to serve RT		Add the following line to the [[VirtualHost]] section of Apache from which you wish to serve RT

			Edit the /etc/request-tracker3.8/apache2-modperl2.conf

			sudo vi /etc/request-tracker3.8/apache2-modperl2.conf
			# Limit mail gateway access to localhost by default<br /><Location /rt/REST/1.0/NoAuth><br />Order Allow,Deny<br />Allow from ALL #127.0.0.1 turned into all<br /></Location>

	Paste at the end of the file just before the closing virtualhost tag		Paste at the end of the file just before the closing virtualhost tag

128.229.4.2: Process works on RT3.8 and Ubuntu11.4. (6/27/2011)

2011-06-27T17:06:29Z

*Process works on RT3.8 and Ubuntu11.4. (6/27/2011)*

← Older revision		Revision as of 13:06, 27 June 2011
Line 2:		Line 2:

	This Howto will explain how to install request-tracker on a clean Ubuntu 9.10 Server install. It is tested on Ubuntu 9.10 and might work with slight modifications on other versions or Debian based distributions.		This Howto will explain how to install request-tracker on a clean Ubuntu 9.10 Server install. It is tested on Ubuntu 9.10 and might work with slight modifications on other versions or Debian based distributions.

			Process works on RT3.8 and Ubuntu11.4. (6/27/2011)

	It also installs the additional services required for Request-Tracker:		It also installs the additional services required for Request-Tracker:
Line 33:		Line 35:

	<nowiki>In install request-tracker3.8(I found Ubuntu server 9.10's packet don't include rt3.8-db-mysql),if don't install it,create the mysql Database will create sqlite3's database,don't create mysql's.)		<nowiki>In install request-tracker3.8(I found Ubuntu server 9.10's packet don't include rt3.8-db-mysql),if don't install it,create the mysql Database will create sqlite3's database,don't create mysql's.)
	</nowiki>		</nowiki>

	== Install mail server (SMTP Server) ==		== Install mail server (SMTP Server) ==
Line 56:		Line 58:

	<nowiki>* RT default install DIR is /usr/share/request-tracker3.8/html *		<nowiki>* RT default install DIR is /usr/share/request-tracker3.8/html *
	</nowiki>		</nowiki>

	=== Configure Request Tracker 3.8 ===		=== Configure Request Tracker 3.8 ===
Line 67:		Line 69:

	<nowiki>sudo vim /etc/request-tracker3.8/RT_SiteConfig.pm		<nowiki>sudo vim /etc/request-tracker3.8/RT_SiteConfig.pm


	#---your file should look something like this ----------------		#---your file should look something like this ----------------
	# vim /etc/request-tracker3.8/RT_SiteConfig.pm		# vim /etc/request-tracker3.8/RT_SiteConfig.pm
	#TIMEZONE – takes the timezone from linux installation.		#TIMEZONE – takes the timezone from linux installation.
	my $zone = "UTC";		my $zone = "UTC";
	$zone='/bin/cat /etc/timezone'		$zone='/bin/cat /etc/timezone'
	if -f "/etc/timezone";		if -f "/etc/timezone";
	chomp $zone;		chomp $zone;
	Set($Timezone, $zone);		Set($Timezone, $zone);
	# THE BASICS:		# THE BASICS:
	Set($rtname, 'RT3.example.com');		Set($rtname, 'RT3.example.com');
	Set($Organization, 'example.com');		Set($Organization, 'example.com');
	Set($CorrespondAddress , 'rt@example.com');		Set($CorrespondAddress , 'rt@example.com');
	Set($CommentAddress , 'rt-comment@example.com');		Set($CommentAddress , 'rt-comment@example.com');
	# THE WEBSERVER:		# THE WEBSERVER:
	Set($WebPath , "/rt");		Set($WebPath , "/rt");
	Set($WebBaseURL , "http://RT3.example.com");		Set($WebBaseURL , "http://RT3.example.com");
	# THE DATABASE:		# THE DATABASE:
	Set($DatabaseType, 'mysql');		Set($DatabaseType, 'mysql');
	Set($DatabaseHost, 'localhost');		Set($DatabaseHost, 'localhost');
	Set($DatabasePort, '');		Set($DatabasePort, '');
	Set($DatabaseUser , 'rtuser');		Set($DatabaseUser , 'rtuser');
	Set($DatabasePassword , 'wibble');		Set($DatabasePassword , 'wibble');
	Set($DatabaseName, 'rtdb');		Set($DatabaseName, 'rtdb');
	#--------------------------------------------------------------------------------		#--------------------------------------------------------------------------------
	</nowiki>		</nowiki>

	=== Create database ===		=== Create database ===

122.166.127.74: /* Install MySql with perl interface */

2011-01-11T05:37:03Z

Install MySql with perl interface

New page

= HowTo Install Request-Tracker 3.8 on ubuntu 9.10 and MySQL =

This Howto will explain how to install request-tracker on a clean Ubuntu 9.10 Server install. It is tested on Ubuntu 9.10 and might work with slight modifications on other versions or Debian based distributions.

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

Logon as a user with the right to use the sudo command.

Make sure you have the latest software

sudo apt-get update
sudo apt-get upgrade

== Install MySql with perl interface ==

sudo apt-get install mysql-server libdbd-mysql-perl libapache-dbi-perl

Answer Y

Type password for root in mysql

Repeat password for root in mysql

== Install the Web server with specific files for request-tracker3.8 ==

sudo apt-get install rt3.8-apache2 rt3.8-db-mysql

Answer Y

<nowiki>*In install request-tracker3.8(I found Ubuntu server 9.10's packet don't include rt3.8-db-mysql),if don't install it,create the mysql Database will create sqlite3's database,don't create mysql's.)*
</nowiki>

== Install mail server (SMTP Server) ==

sudo apt-get install postfix

Choose "Internet Site" in the install dialogue.

Write the name of the local server

== Install Request Tracker 3.8 server and client ==

sudo apt-get install request-tracker3.8 rt3.8-clients

Answer Y

Write rt.domainname

Answer "Yes" to Handle [[RT SiteConfig|RT_SiteConfig]].pm permissions?

Answer “Yes” to Configure database for request-tracker3.8 with dbconfig-common?

<nowiki>* RT default install DIR is /usr/share/request-tracker3.8/html *
</nowiki>

=== Configure Request Tracker 3.8 ===

==== Make backup of configuration file. ====

sudo cp /etc/request-tracker3.8/RT_SiteConfig.pm /etc/request-tracker3.8/RT_SiteConfig.pm.orig

==== Edit Request Tracker configuration file. ====

<nowiki>sudo vim /etc/request-tracker3.8/RT_SiteConfig.pm

#---your file should look something like this ----------------
# vim /etc/request-tracker3.8/RT_SiteConfig.pm
#TIMEZONE – takes the timezone from linux installation.
my $zone = "UTC";
$zone='/bin/cat /etc/timezone'
if -f "/etc/timezone";
chomp $zone;
Set($Timezone, $zone);
# THE BASICS:
Set($rtname, 'RT3.example.com');
Set($Organization, 'example.com');
Set($CorrespondAddress , 'rt@example.com');
Set($CommentAddress , 'rt-comment@example.com');
# THE WEBSERVER:
Set($WebPath , "/rt");
Set($WebBaseURL , "http://RT3.example.com");
# THE DATABASE:
Set($DatabaseType, 'mysql');
Set($DatabaseHost, 'localhost');
Set($DatabasePort, '');
Set($DatabaseUser , 'rtuser');
Set($DatabasePassword , 'wibble');
Set($DatabaseName, 'rtdb');
#--------------------------------------------------------------------------------
</nowiki>

=== Create database ===

sudo /usr/sbin/rt-setup-database --action init --dba root --prompt-for-dba-password

This should be the result:

Working with:

Type: mysql

Host: localhost

Name: rtdb

User: rtuser

DBA: root

Now creating a mysql database rtdb for RT.

Done.

Now populating database schema.

Done.

Now inserting database [[ACLs]]

Granting access to rtuser@'localhost' on rtdb.

Done.

Now inserting RT core system objects

Done.

Now inserting data

Done inserting data

Done.

=== Add rt perl module to apache ===

==== Backup apache configuration file ====

sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/default.orig

==== Edit the configuration file ====

sudo vi /etc/apache2/sites-available/default

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 virtualhost tag

Include /etc/request-tracker3.8/apache2-modperl2.conf
RedirectMatch ^/$ /rt

*In the step,you need add [[VirtualHost]] config code in the 'default' file. *The [[VirtualHost]] like the /var/www/,but in </[[VirtualHost]]> front add up two line.

==== Add the module ====

sudo a2enmod rewrite

==== Restart webserver ====

sudo /etc/init.d/apache2 restart

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

HowToInstallRequest-Tracker3.8OnUbunto9.10 - Revision history

Admin: 9 revisions imported

173.166.169.133: /* Create database */

183.129.143.162: /* Edit the configuration file */

183.129.143.162: /* Edit the configuration file */

128.229.4.2: *Process works on RT3.8 and Ubuntu11.4. (6/27/2011)*

122.166.127.74: /* Install MySql with perl interface */

128.229.4.2: Process works on RT3.8 and Ubuntu11.4. (6/27/2011)