logo_kerberos.gif

RT server configuration

From K5Wiki
(Difference between revisions)
Jump to: navigation, search
(Packages)
Line 5: Line 5:
 
RT has the following perl dependencies, along with the corresponding Ubuntu packages they reside in:
 
RT has the following perl dependencies, along with the corresponding Ubuntu packages they reside in:
   
Digest::MD5 perl
+
Digest::MD5 perl
Storable perl
+
Storable perl
DBI 1.18 libdbi-perl
+
DBI 1.18 libdbi-perl
DBIx::DataSource 0.02 libdbix-datasource-perl
+
DBIx::DataSource 0.02 libdbix-datasource-perl
DBIx::SearchBuilder 0.48 libdbix-searchbuilder-perl
+
DBIx::SearchBuilder 0.48 libdbix-searchbuilder-perl
HTML::Entities libhtml-parser-perl
+
HTML::Entities libhtml-parser-perl
MLDBM libmldbm-perl
+
MLDBM libmldbm-perl
Net::Domain perl-modules
+
Net::Domain perl-modules
Net::SMTP perl-modules
+
Net::SMTP perl-modules
Params::Validate 0.02 libparams-validate-perl
+
Params::Validate 0.02 libparams-validate-perl
HTML::Mason 1.02 libhtml-mason-perl
+
HTML::Mason 1.02 libhtml-mason-perl
CGI::Cookie 1.20 perl-modules
+
CGI::Cookie 1.20 perl-modules
Apache::Cookie libapache2-request-perl
+
Apache::Cookie libapache2-request-perl
Apache::Session 1.53 libapache-session-perl
+
Apache::Session 1.53 libapache-session-perl
Date::Parse libtimedate-perl
+
Date::Parse libtimedate-perl
Date::Format libtimedate-perl
+
Date::Format libtimedate-perl
MIME::Entity 5.108 libmime-tools-perl
+
MIME::Entity 5.108 libmime-tools-perl
Mail::Mailer 1.20 libmailtools-perl
+
Mail::Mailer 1.20 libmailtools-perl
Getopt::Long 2.24 perl-base
+
Getopt::Long 2.24 perl-base
Tie::IxHash libtie-ixhash-perl
+
Tie::IxHash libtie-ixhash-perl
Text::Wrapper libtext-wrapper-perl
+
Text::Wrapper libtext-wrapper-perl
Text::Template libtext-template-perl
+
Text::Template libtext-template-perl
File::Spec 0.8 perl-base
+
File::Spec 0.8 perl-base
Errno perl-base
+
Errno perl-base
FreezeThaw libfreezethaw-perl
+
FreezeThaw libfreezethaw-perl
File::Temp perl-modules
+
File::Temp perl-modules
Log::Dispatch 1.6 liblog-dispatch-perl
+
Log::Dispatch 1.6 liblog-dispatch-perl
   
 
The data in RT is stored in a PostgreSQL database. The postgresql Ubuntu package will install the recommended version of PostgreSQL for the current Ubuntu version.
 
The data in RT is stored in a PostgreSQL database. The postgresql Ubuntu package will install the recommended version of PostgreSQL for the current Ubuntu version.
Line 98: Line 98:
   
 
Run "pg_dump -Upostgres -Fc rt2 > /path/to/dumpfile" on the old server, transfer the file to the new server, and run "pg_restore -Upostgres -d rt2 /path/to/dumpfile" on the new server to restore the database. As a simple verification, run "psql -Upostgres -c 'SELECT * FROM keywords;' rt2" on both servers and verify that the tables have the same number of rows.
 
Run "pg_dump -Upostgres -Fc rt2 > /path/to/dumpfile" on the old server, transfer the file to the new server, and run "pg_restore -Upostgres -d rt2 /path/to/dumpfile" on the new server to restore the database. As a simple verification, run "psql -Upostgres -c 'SELECT * FROM keywords;' rt2" on both servers and verify that the tables have the same number of rows.
  +
  +
==Postfix configuration==
  +
  +
In /etc/postfix/main.cf:
  +
  +
* Set myhostname = krbdev.mit.edu
  +
* Set mydestination = krbdev.mit.edu, krbdev-prod-app-1.mit.edu, localhost.mit.edu, localhost
  +
* Add the following to the end:
  +
  +
# Suppress some headers to avoid leaking internal addresses to spammers.
  +
prepend_delivered_header =
  +
enable_original_recipient = no
  +
  +
# RT header milter
  +
smtpd_milters = unix:private/milter
  +
  +
  +
In root's crontab file ("crontab -e root"):
  +
  +
@reboot /var/rt2/bin/rtmilter.pl /var/spool/postfix/private/milter

Revision as of 12:13, 31 October 2017

Our installation of Request Tracker is a modified version 2.0.13. Most of the modifications were tracked in CVS; the repository is on drugstore at /cvs/krbdev in the tracking subdirectory. drugstore no longer serves CVS, so the repository must be copied out and checked out locally. A few changes have been made on the running server without version control.

Contents

Packages

RT has the following perl dependencies, along with the corresponding Ubuntu packages they reside in:

 Digest::MD5                           perl
 Storable                              perl
 DBI 1.18                              libdbi-perl
 DBIx::DataSource 0.02                 libdbix-datasource-perl
 DBIx::SearchBuilder 0.48              libdbix-searchbuilder-perl
 HTML::Entities                        libhtml-parser-perl
 MLDBM                                 libmldbm-perl
 Net::Domain                           perl-modules
 Net::SMTP                             perl-modules
 Params::Validate 0.02                 libparams-validate-perl
 HTML::Mason 1.02                      libhtml-mason-perl
 CGI::Cookie 1.20                      perl-modules
 Apache::Cookie                        libapache2-request-perl
 Apache::Session 1.53                  libapache-session-perl
 Date::Parse                           libtimedate-perl
 Date::Format                          libtimedate-perl
 MIME::Entity 5.108                    libmime-tools-perl
 Mail::Mailer 1.20                     libmailtools-perl
 Getopt::Long 2.24                     perl-base
 Tie::IxHash                           libtie-ixhash-perl
 Text::Wrapper                         libtext-wrapper-perl
 Text::Template                        libtext-template-perl
 File::Spec 0.8                        perl-base
 Errno                                 perl-base
 FreezeThaw                            libfreezethaw-perl
 File::Temp                            perl-modules
 Log::Dispatch 1.6                     liblog-dispatch-perl

The data in RT is stored in a PostgreSQL database. The postgresql Ubuntu package will install the recommended version of PostgreSQL for the current Ubuntu version.

The mail interface to RT is handled by Postfix, so the postfix package is required. The libmail-milter-perl package is required for the custom milter script.

In sum, the following packages must be installed on the RT server:

 libapache-session-perl
 libapache2-request-perl
 libdbi-perl
 libdbix-datasource-perl
 libdbix-searchbuilder-perl
 libfreezethaw-perl
 libhtml-mason-perl
 libhtml-parser-perl
 liblog-dispatch-perl
 libmailtools-perl
 libmail-milter-perl
 libmime-tools-perl
 libmldbm-perl
 libparams-validate-perl
 libtext-template-perl
 libtext-wrapper-perl
 libtie-ixhash-perl
 libtimedate-perl
 perl
 perl-base
 perl-modules
 postfix
 postgresql

User accounts

The postgresql package will create a postgres user account.

The following user accounts and group entries must be created manually:

  • group rt
  • user rt: primary group rt, homedir /var/rt2, shell /bin/false
  • user rtcvs: primary group rt, homedir /var/rt2, shell /bin/sh

/var/rt2 should contain an empty .k5login file.

PostgreSQL configuration

Many PostgreSQL files live in directories specific to the PostgreSQL major and minor version, such as /etc/postgresql/8.3 for PostgreSQL 8.3.

The Ubuntu postgresql package will create a "main" cluster with a configuration directory in /etc/postgresql/<version>/main.

In /etc/postgresql/<version>/main/pg_ident.conf, add:

 local		root		root
 local		root		postgres
 local		root		rt_user
 local		rt		rt_user
 local		rtcvs		rt_user
 local		postfix		rt_user
 local		nobody		rt_user

In /etc/postgresql/<version>/main/pg_hba.conf, find the line that reads "local all all peer" and add "map=local" to the end, so it reads "local all all peer map=local". Comment out the line that reads "local all postgres peer", despite the warning not to disable it. Run "service postgresql restart" to reread the affected files. Run "psql -Upostgres --list" to verify that the identity map works.

Run "createuser -Upostgres rt_user" to create the rt_user role.

Run "createdb -ESQL_ASCII -Upostgres -Ttemplate0 rt2" to create the database. This database can be removed with "dropdb -Upostgres rt2" if it becomes necessary to recreate it.

Run "pg_dump -Upostgres -Fc rt2 > /path/to/dumpfile" on the old server, transfer the file to the new server, and run "pg_restore -Upostgres -d rt2 /path/to/dumpfile" on the new server to restore the database. As a simple verification, run "psql -Upostgres -c 'SELECT * FROM keywords;' rt2" on both servers and verify that the tables have the same number of rows.

Postfix configuration

In /etc/postfix/main.cf:

  • Set myhostname = krbdev.mit.edu
  • Set mydestination = krbdev.mit.edu, krbdev-prod-app-1.mit.edu, localhost.mit.edu, localhost
  • Add the following to the end:
 # Suppress some headers to avoid leaking internal addresses to spammers.
 prepend_delivered_header =
 enable_original_recipient = no
 
 # RT header milter
 smtpd_milters = unix:private/milter


In root's crontab file ("crontab -e root"):

 @reboot /var/rt2/bin/rtmilter.pl /var/spool/postfix/private/milter
Personal tools