Request Tracker Wiki - User contributions [en]

CentOS7Install

2018-04-12T16:08:38Z

Skuervers: Added final RT customization and made minor corrections to the document.

== RT 4.4.2 installation on CentOS 7.4.1708 ==

NOTE: Original Document was for CentOS 7.2 and RT 4.4.1 with MySQL. Updated for CentOS 7.4, RT 4.4.2 with PostgreSQL.

This document provides a quick methodology for installing RT 4.4.2 on CentOS/RHEL 7.4 for an internet-connected server. There is a separate CentOS 6.9 install at https://rt-wiki.bestpractical.com/wiki/CentOS6Install.

# Assumptions
* Access to the internet and CentOS OS and update repositories is available.
* Installation testing was completed using CentOS 7.4.1708 minimal boot ISO.
* httpd (Apache) 2.4 and mod_fcgid Apache modules were used as the host environment.
* Testing was conducted in both KVM and vSphere environments.
* Note that the EPEL repository is not required for installation on CentOS 7.

# OS Installation and Initial Configuration
* (!) It is possible to automate the majority of this section using kickstart files.
## Install OS.
* Install the OS from ISO or PXE boot using your normal methodology.
## Install prerequisites for RT from OS repository.
<pre>yum install expat gd graphviz openssl expat-devel gd-devel graphviz-devel openssl-devel perl perl-CPAN wget screen mod_fcgid postgresql-server postgresql-devel
yum groupinstall "Development Tools" "Web Server"</pre>
* NOTE: We use PostgreSQL as the DB which allows us to enable full text search. (This is a change from the previous version of the document which used MySQL/MariaDB.)
## Patch OS
<pre>yum update</pre>
## Disable selinux, by editing /etc/sysconfig/selinux:
<code>SELINUX=disabled</code>
* reboot the OS
## Initialize the database:
<pre>postgresql-setup initdb</pre>
## Adjust local services:
<pre>systemctl enable postgresql.service
systemctl enable httpd.service
systemctl start postgresql.service
systemctl stop httpd.service</pre>
* NOTE: httpd service needs to be stopped to allow RT web based configuration later.
# Configure Supporting Software
## Configure postgres user password for postgresql, where 'xxx' is the 'password':
<pre>sudo -u postgres psql
ALTER USER postgres PASSWORD 'xxx';
\q</pre>
* NOTE: This step configures the internal DB postgres password for the local instance of postgresql
## Reconfigure postgres local user access
Configure PostgreSQL to use md5 passwords (needed for RT). Edit /var/lib/pgsql/data/pg_hba.conf and modify the following line from peer to md5:
<pre># "local" is for Unix domain socket connections only
#local all all ident
local all all md5</pre>
## Install CPAN minus.
<pre>curl -L http://cpanmin.us | perl - --sudo App::cpanminus</pre>
# RT Dependencies and Installation
## Get RT
<pre>mkdir rt
cd rt
wget https://download.bestpractical.com/pub/rt/release/rt-4.4.2.tar.gz
wget https://download.bestpractical.com/pub/rt/release/rt-4.4.2.tar.gz.asc</pre>
## Verify downloads
* NOTE: Release notes are found at https://bestpractical.com/release-notes/rt/4.4.2
* extract the sha256sums from the release notes online and add them to a new sha256sum.txt file.
<pre>b2e366e18c8cb1dfd5bc6c46c116fd28cfa690a368b13fbf3131b21a0b9bbe68 rt-4.4.2.tar.gz
2185c2be31b352ad0a7605f9a4e4720b2c3607df75aae1c0cbace9eb9e6fcef8 rt-4.4.2.tar.gz.asc</pre>
* confirm the files:
<pre>sha256sum -c sha256sum.txt</pre>
* Confirm the GPG key signatures
<pre>gpg rt-4.4.2.tar.gz.asc
gpg --keyserver pgpkeys.mit.edu --recv-key XXX
gpg rt-4.4.2.tar.gz.asc</pre>
* NOTE: identify the RSA key ID from the first and replace XXX with the key (RSA key ID 31440520 as of 12 Apr 18)
## Extract the files
<pre>tar xvzf rt-4.4.2.tar.gz -C /tmp
cd /tmp/rt-4.4.2</pre>
## Configure RT:
<pre>./configure --enable-graphviz --enable-gd --with-web-user=apache --with-web-group=apache --with-db-type=Pg</pre>
## Configure RT to use cpanm for fixdeps:
<pre>export RT_FIX_DEPS_CMD=/usr/local/bin/cpanm</pre>
## Test the dependencies:
<pre>make testdeps</pre>
## Install the dependencies:
<pre>make fixdeps</pre>
* NOTE: You may need to run the command more than once.
## Confirm dependencies:
<pre>make testdeps</pre>
## Install RT (default install is to the /opt/rt4 directory):
<pre> make install</pre>
# RT Configuration using Web Interface
* (!) It is possible to complete this step by editing the RT files directly, and creating the database. Refer to the RT documentation for manual steps.
## Configure firewalld to open port 80
<pre>firewall-cmd --zone=public --add-port=80/tcp --permanent
firewall-cmd --reload</pre>
* Note: This is an example only, which provides full access to the http port.. Configure your firewall as per site policies.
## Start the first run installation instance:
<pre>/opt/rt4/sbin/rt-server</pre>
## Configure using the web interface.
* Access the server using a web browser to access the http port.
* Configure the RT instance using the web interface. Refer to the RT documentation.
## Shutdown the rt-server instance.
* When completed Ctrl-C the rt-server instance started above.
# Configure web server
## Modify /etc/httpd/conf.d/fcgid.conf. Add:
<code>FcgidMaxRequestLen 1073741824</code>
## Create /etc/httpd/conf.d/rt.conf:
<pre># RT4 configuration for Apache
#
# With minor changes, this configuration is based on the original documentation:
# https://docs.bestpractical.com/rt/4.4.2/web_deployment.html
#
### Optional apache logs for RT
# Ensure that your log rotation scripts know about these files
# ErrorLog /opt/rt4/var/log/apache2.error
# TransferLog /opt/rt4/var/log/apache2.access
# LogLevel debug

AddDefaultCharset UTF-8

ScriptAlias / /opt/rt4/sbin/rt-server.fcgi/

DocumentRoot "/opt/rt4/share/html"

<Location />
# For Centos7/Apache 2.4 use this line:
Require all granted

# For Centos6/Apache 2.2 use these two lines:
# Order allow,deny
# Allow from all

Options +ExecCGI
AddHandler fcgid-script fcgi
</Location></pre>
## Start apache:
<pre>systemctl start httpd.service</pre>
# Further RT Customization
* These steps are not mandatory, and can be skipped if not desired.
## Enable Full Text Indexing
* This command modifies the database to enable full text indexing
* Run:
<pre>/opt/rt4/sbin/rt-setup-fulltext-index --no-attachments --dba-password XXX</pre>
* NOTE: XXX is the postgres DB user password
* DB Table: AttachmentsIndex
* Column Name: ContentIndex
* Index: GIN
* As the last command will leave the postgres DB password in the command history, clear the relevant history record:
<pre>history
history -d <number></pre>
* NOTE: <number> reflects the line number with the --dba-password statement
## Prepare for Offline Attachments
* This enables the migration of embedded attachments from the database to a local filesystem
* Create the directory to store attached files
<pre>mkdir /opt/rt4-atts</pre>
## Modify Site Configuration for fulltext indexing and offline attachments
* Modify <code>/opt/rt4/etc/RT_SiteConfig.pm</code>, inserting the following above the final <code>1;</code> line.
<pre># enable FullTextSearch
Set( %FullTextSearch,
Enable => 1,
Indexed => 1,
Column => 'ContentIndex',
Table => 'AttachmentsIndex',
);
# enable external file storage
Set(%ExternalStorage,
Type => 'Disk',
Path => '/opt/rt4-atts',
);</pre>
## Create RT crontab entry
*
* Create <code>/etc/cron.d/rt</code> file:
<pre># Request Tracker cron.d/rt file

# For details see man 3 crontabs

# Example of job definition:
# .---------------- minute (0 - 59)
# | .------------- hour (0 - 23)
# | | .---------- day of month (1 - 31)
# | | | .------- month (1 - 12) OR jan,feb,mar,apr ...
# | | | | .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# | | | | |
# * * * * * user-name command to be executed

# Request Tracker crontab entries
# attachments - daily moving of large attachments from DB to file system
0 0 * * * root /opt/rt4/sbin/rt-externalize-attachments
# indexer - daily indexing of db for fulltext search
0 0 * * * root /opt/rt4/sbin/rt-fulltext-indexer --quiet
# email digests - RT4 email digest processes
0 0 * * * root /opt/rt4/sbin/rt-email-digest -m daily
0 0 * * 0 root /opt/rt4/sbin/rt-email-digest -m weekly
0 * * * * root /opt/rt4/sbin/rt-email-dashboards
# clean sessions - once a day blow away any open sessions
0 0 * * * root /opt/rt4/sbin/rt-clean-sessions 6H</pre>
# Installation Complete
## Reboot server to confirm service restart
* It is recommended that you reboot the server to confirm all services restart and provide RT.
## Access RT
* Connect to RT using your web browser and start your site customization.

2016-10-11T21:17:38Z

Skuervers: Original Draft of page from notes created on google drive.

- RT 4.4.1 installation on CentOS 7.2.1511 -

Assumptions:
1. Access to the internet and CentOS OS and update repositories is available.
1. Installation testing was completed using CentOS 7.2.1511 minimal boot ISO.

Installation Steps:
1. Install OS. Install the OS from ISO or PXE boot using your normal methodology.
* Install prerequisites for RT from OS repository.
* yum install expat gd graphviz mariadb-server openssl expat-devel gd-devel graphviz-devel mariadb-devel openssl-devel perl perl-CPAN wget screen mod_fcgid
* yum groupinstall "Development Tools" "Web Server"

1. Patch OS
* yum update
* reboot (unless you are doing step 4 immediately)

1. Disable selinux, by editing /etc/sysconfig/selinux:
* SELINUX=disabled
* reboot

1. Adjust local services:
* systemctl enable mariadb.service
* systemctl enable httpd.service
* systemctl start mariadb.service
* systemctl stop httpd.service

* NOTE: httpd service needs to be stopped to allow RT web based configuration later in process.

1. Configure root password for mariadb:
* mysqladmin -u root password
* NOTE: configure the internal DB password for the local instance of mysqld or mariadb

1. Install CPAN minus.
* curl -L http://cpanmin.us | perl - --sudo App::cpanminus

1. Get RT and extract to /tmp.
* wget https://download.bestpractical.com/pub/rt/release/rt-4.4.1.tar.gz
* tar xvzf rt-4.4.1.tar.gz -C /tmp
* cd /tmp/rt-4.4.1

1. Configure RT:
* ./configure --enable-graphviz --enable-gd --with-web-user=apache --with-web-group=apache

1. Configure RT to use cpanm for fixdeps:
* export RT_FIX_DEPS_CMD=/usr/local/bin/cpanm

1. Test the dependencies:
* make testdeps

1. Fix the dependencies:
* make fixdeps

* NOTE: You may need to run the command more than once. On RHEL 6.8, you may need to manually force the addition of the GD perl module via “cpanm GD --force”

1. Confirm the dependencies are complete:
* make testdeps

1. Install RT (default install is to the /opt/rt4 directory):
* make install

1. Modify /etc/httpd/conf.d/fcgid.conf. Add:
* FcgidMaxRequestLen 1073741824

1. Create /etc/httpd/conf.d/rt.conf:
# RT4 configuration for Apache

### Optional apache logs for RT
# Ensure that your log rotation scripts know about these files
# ErrorLog /opt/rt4/var/log/apache2.error
# TransferLog /opt/rt4/var/log/apache2.access
# LogLevel debug

AddDefaultCharset UTF-8

Alias /rt/NoAuth/images /opt/rt4/share/html/NoAuth/images/

ScriptAlias /rt /opt/rt4/sbin/rt-server.fcgi/

DocumentRoot "/opt/rt4/share/html"

<Location /rt>
# For Centos7/Apache 2.4 this line:
Require all granted
# For Centos6/Apache 2.2 these two lines:
# Order allow,deny
# Allow from all
Options +ExecCGI
AddHandler fcgid-script fcgi
</Location>

1. Run the first run installation instance:
* /opt/rt4/sbin/rt-server
* Access the server using a web browser on the http 80 port.

1. Configure the rt instance (fill this section in).

1. When completed Ctrl-C the rt-server instance started above.

1. Modify /opt/rt4/etc/RT_SiteConfig.pm. Add the following line:
* Set( $WebPath, '/rt' );

1. Start apache:
systemctl start httpd.service

1. Modify firewalld configuration to suite your local requirements.
* NOTE: Depending on install method, firewalld may not be installed. You can also stop it for testing with the "systemctl stop firewalld" command.

InstallationGuides

2016-10-11T21:07:59Z

Skuervers:

{{OutdatedInstallGuide}}

= Introduction =

= The best/easiest distribution for RT =

There is no the best or the easiest. People run RT on Arch Linux, Debian, FreeBSD, NetBSD, RH7/8/9, RHEL, CentOS, Fedora, Solaris, SuSE, Gentoo, OpenBSD.

Just look at the list of guides below. Pick a distro you're familiar with, check if it has packages for the latest stable RT or install from source.

= Generic Installation Guides =

* [[ManualRequirements]] - software and knowledge you need to install RT.
* [[ManualInstallation]] - general overview of installation process and first time configuring.
* [[DevelopmentInstallation]] - HOWTO setup RT to run from a development directory
* [http://www.sgsosu.net/nmetro/docs.html Installation and Administration Guides] - Request Tracker, Reporting and Asset Tracker

= Platform-Specific Installation Guides =

* Arch Linux
** [https://wiki.archlinux.org/index.php/Request_Tracker Request Tracker (Arch Wiki)]
* CentOS:
** [[CentOS5InstallPlusSome]] (CentOS 5.4 + Active Directory 2003 + Exchange 2007 + Postfix + RT 3.8.7)
** [http://howtoconfigure.blogspot.pt/2013/05/how-to-install-request-tracker-40x-in.html CentOS 5.x and 6.x (RT 4.0.5)] (CentOS 5.x / 6.x + RT 4.0.5)
** [http://harbot.wordpress.com/2012/05/22/how-to-install-request-tracker-4-0-5-in-centos6/ CentOS 6.2 (RT 4.0.5)] (An unofficial installation guide)
** [http://gregorbinder.blogspot.it/2012/04/how-to-install-request-tracker-4-on.html CentOS 6.2 (RT 4.0.5)] (A slightly different unofficial installation guide compared to the one above)
** [http://binarynature.blogspot.pt/2013/05/install-request-tracker-4.html CentOS 6.4 (RT 4.2)] (CentOS-6.4 - x86_64 Minimal Install + RT 4.2)
** [[CentOS7Install]] (CentOS 7.2.1511 install using Perl RPMs and CPANminus to source CPAN dependencies)
* Cygwin
** [[CygwinInstallGuide]]
* Debian GNU/Linux:
** [[DebianSqueezeInstallGuide]] (RT 4, via apt)
** [[DebianLennyInstallGuide]] (RT 3.81, mysql 5, postifx)
** [[DebianLennySourceInstallGuide]]
** [[DebianEtchSourceInstallGuide]]
** [[DebianStableInstallGuide|DebianSargeeInstallGuide]]
** [http://binarynature.blogspot.com/2013/10/install-request-tracker-4-on-ubuntu-server.html Debian 7.2 (RT 4.2)] (Ubuntu guide with Debian-specific notes; Apache, MySQL)
** [[DebianJessieInstallGuide]] (RT 4.2, via apt, nginx/apache)
* Fedora:
** [[FedoraCore1InstallGuide]]
** [[FedoraCore2InstallGuide]]
** [[FedoraCore4InstallGuide]]
** Fedore Core 5 and greater have packages, see below
* MacOSX:
** [[MacOSXServerInstallGuide]]
** [[MacOSX SnowLeopard ClientInstallGuide|MacOSX_SnowLeopard_ClientInstallGuide]]
** [[Mac_OSX_10.6.8_Snow_Leopard_Server_Install]]
* OpenBSD:
** [[OpenBSD38InstallGuide]]
** [[OpenBSD40InstallGuide]]
* openSUSE
** [[OpenSUSE123InstallGuide|openSUSE 12.3]]
** [[OpenSUSE122InstallGuide|openSUSE 12.2]]
** [http://wiki.bestpractical.com/view/OpenSuSE113InstallPlus OpenSuSE 11.3 InstallGuide + MySQL + RTFM and more]
* RedHat EL:
** [[RHEL4InstallGuide]]
** [[Rhel5InstallGuide|RHEL5InstallGuide]]
* Slackware
** [[SlackwareInstallGuide]]
* Solaris
** [[SolarisInstallGuide]]
* [[SuSE|SUSE Linux Enterprise (SLE):]]
** [[SLES11InstallGuide]]
** [[SuSE10InstallGuide]]
** [[SuSE93InstallGuide]]
** [[SuSEOracleInstall]]
* Ubuntu
** [http://wiki.bestpractical.com/view/Ubuntu_8.04.1 Ubuntu 8.04.1 + RT 3.8.1 + MySQL]
** [http://catcon.wordpress.com/2009/05/20/installing-request-tracker-3-8-2-on-ubuntu-server-9-04/ Ubuntu 9.04 + RT 3.8.2 + MySQL]
** [http://catcon.wordpress.com/2009/06/09/upgrading-to-request-tracker-3-8-3/ Upgrade from 3.8.2 to 3.8.3]
** [http://wiki.bestpractical.com/view/HowToInstallRequest-Tracker3.8OnUbunto9.10 Ubuntu 9.10 + RT 3.8.4 + MySQL]
** [[WithEmailFacility|Ubuntu 10.04 with inbound/outbound email facility]]
** [[Ubuntu 12.10 Install Guide]] (RT4, nginx, Fast-CGI, Postfix)
** [http://requesttracker.wikia.com/wiki/Ubuntu_13.04_Server_and_Request_Tracker Ubuntu 13.04 With RT4.0 ]
** [http://binarynature.blogspot.com/2013/10/install-request-tracker-4-on-ubuntu-server.html Ubuntu 13.10 (RT 4.2, Apache, MySQL)]

==== Packaged Installs ====

* [[Rhel5InstallGuide]]
* [[CentOS5InstallGuide]]
* [[RHELorCentOSusingEPEL]]
* [[DebianInstallGuide]]
** Portuguese translation: [[GuiaInstalacaoDebian]]
* Fedora:
** [[FedoraCore5InstallGuide]]
** [[FedoraCore6InstallGuide]]
** [[FedoraCore7InstallGuide]]
** [[FedoraCore9InstallGuide]]
* [[FreeBSDInstallGuide]]
* [http://requesttracker.wikia.com/wiki/FreeBSDInstallGuide_-_RT4.2 FreeBSDInstallGuide_-_RT4.2]
* [[GentooInstallGuide]]
* [[MandrivaInstallGuide]]
* [[RPMInstall]]
** (RHEL/CentOS/WBEL, updated for v3.4.5. Includes how to get mod_perl2 running)
* [[SolarisBlastwaveInstallGuide]]
* [[SuSE]]:
** [[OpenSUSE123InstallGuide]]
** [[OpenSUSE122InstallGuide]]
* Ubuntu:
** [[UbuntuInstallGuide]]
** [[UbuntuInstallGuide2]] (Ubuntu 6.06 / RT 3.6 / mysql)
** [[UbuntuHardyInstallGuide]] (Ubuntu 8.04 / RT 3.6 / mysql)
* Vmware:
** [[VmwareInstall]]
* Virtual Appliances:
** [[Proxmox VE RT Appliance|Proxmox_VE_RT_Appliance]] (RT 3.8.x)

==== Perl Module Repositories for RHEL/CentOS ====

* [[RHEL5RepoArchive]]

= Database Specific Notes =

* [[OracleSetup]]
* RT with [[OracleText]]
* RT with [[PostgreSQLFullText]]
* RT with [[PostgreSQLFullTextTrgm]]

= Web Server Specific Notes =

* [[LighttpdFastCGIGuide]]

= Upgrading =

* [[MigrateToNewServer]]
* [[UpgradingFrom3011To344OnSolaris9]]
* [[Upgrade_RT_3.6.7_to_3.8.8_-_Debian_5.0(lenny)_to_6.0(squeeze)]]

= Other =

* [[CompilingPerl]]
* [[ManualApache]]
* [[InstallMailgateOnly]]

= Deployment guides =

Documents which explain why and which way, rather than how.

* [[ItsFinallyInstalledNowWhat]]
* The [http://web.mit.edu/tooltime/ MITProjectNotebook], especially the [http://web.mit.edu/tooltime/notebook/reference/documentation.html Documentation page], which includes a [http://web.mit.edu/tooltime/notebook/reference/rtbasics.pdf 15 page PDF] User's Manual.