<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>I know there has
been considerable traffic on this in the past, and I have struggled with it
myself to get RT3 running on RedHat 9 using PostgreSQL, Apache 2, and mod_perl2
(1.99). I've gotten the installation to a point where it is repeatable, and here
it is. Note that in the prompts, the name of the machine I am installing to is
"moe".</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>RedHat
9</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004><SPAN
class=377513518-08012004>- Firewall<BR> - allow incoming WWW, SSH, DHCP,
SMTP, 5432:tcp<BR></SPAN></SPAN></FONT><FONT face=Arial><FONT size=2><SPAN
class=377513518-08012004>- </SPAN>Packages (use these as minimum, only add
additional necessary packages)<BR><SPAN class=377513518-08012004> </SPAN>-
X Window System<BR><SPAN class=377513518-08012004> </SPAN> -
XFree86-xdm<BR><SPAN class=377513518-08012004> </SPAN> -
gdm<BR><SPAN class=377513518-08012004> </SPAN> -
redhat-config-xfree86<BR><SPAN class=377513518-08012004> </SPAN>- Gnome
Desktop Environment<BR><SPAN class=377513518-08012004> </SPAN> [no
packages selected]<BR><SPAN class=377513518-08012004> </SPAN>-
Editors<BR><SPAN class=377513518-08012004> </SPAN>- Graphical
Internet<BR> <SPAN class=377513518-08012004> </SPAN> -
mozilla<BR></FONT></FONT><FONT face=Arial size=2><SPAN
class=377513518-08012004> - SQL Database Server<BR> - Development
Tools<BR> - doxygen<BR>Make sure that the system has been
up2date'ed<BR></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004>Apache2/mod_perl2</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>Obtain the following
RPMs from rpmfind.net or another source:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>-
apr-0.9.4-2.src.rpm</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>-
apr-util-0.9.4-2.i386.rpm</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>-
apr-util-devel-0.9.4-2.i386.rpm</SPAN></FONT></DIV>-
db4-4.1.25-12.i386.rpm</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004>- httpd-2.0.47-10.i386.rpm</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=377513518-08012004>- httpd-devel-2.0.47-8.i386.rpm</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>-
mod_perl-1.99_09-10.src.rpm</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>Using the RPMs from
above, log in as root and run<BR> [root@moe root]# rpm -i
apr-0.9.4-2.src.rpm<BR> [root@moe root]# rpmbuild -bb
/usr/src/redhat/SPECS/apr.spec<BR> [root@moe root]# rpm -i
/usr/src/redhat/RPMS/i386/apr-0.9.4-2.i386.rpm apr-util-0.9.4-2.i386.rpm
db4-4.1.25-12.i386.rpm httpd-2.0.47-10.i386.rpm<BR> [root@moe root]# rpm
-i /usr/src/redhat/RPMS/i386/apr-devel-0.9.4-2.i386.rpm
apr-util-devel-0.9.4-2.i386.rpm httpd-devel-2.0.47-8.i386.rpm<BR>
[root@moe root]# rpm -i mod_perl-1.99_09-10.src.rpm<BR> [root@moe root]#
rpmbuild -bb /usr/src/redhat/SPECS/mod_perl.spec<BR> [root@moe root]# rpm
-i /usr/src/redhat/RPMS/i386/mod_perl-1.99_09-10.i386.rpm<BR>Modify
/etc/httpd/conf/httpd.conf as needed<BR>Create /etc/httpd/conf.d/rt3.conf
similar to this:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>
ServerName support.corp.peoplematter.com<BR> DocumentRoot
/usr/local/rt3/share/html</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>
PerlSetVar MasonArgsMethod CGI<BR> PerlModule Apache2
Apache::compat<BR> RewriteEngine On<BR>
RewriteRule ^(.*)/$ $1/index.html<BR> PerlModule
Apache::DBI<BR> PerlRequire
/usr/local/rt3/bin/webmux.pl</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=377513518-08012004>
<Location /><BR> SetHandler perl-script<BR>
PerlHandler RT::Mason<BR>
</Location><BR>Run<BR> [root@moe root]# chkconfig --level 345 httpd
on<BR></DIV></SPAN></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>PostgreSQL<BR><BR>Run<BR> [root@moe root]#
chkconfig --level 345 postgresql on<BR> [root@moe root]#
/etc/init.d/postgresql start<BR><SPAN
class=377513518-08012004>Modify</SPAN> /var/lib/pgsql/data/postgresql.conf <SPAN
class=377513518-08012004>to allow TCP connections (and any other mods you
require)</SPAN><BR><SPAN class=377513518-08012004>Modify
</SPAN>/var/lib/pgsql/data/pg_hba.conf <SPAN class=377513518-08012004>to
allow local access</SPAN><BR>Run<BR> [root@moe root]#
/etc/init.d/postgresql restart<BR> [root@moe root]# psql -U postgres
template1<BR> template1=# alter user postgres with encrypted password
'<<SPAN class=377513518-08012004>postgres </SPAN>password>';<BR>
template1=# create user rt_user with encrypted password <SPAN
class=377513518-08012004>'<rt_user password>'</SPAN>;<BR>
template1=# \q<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT size=+0><SPAN class=377513518-08012004><FONT face=Arial
size=2>RT3</FONT></SPAN></DIV></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Unpack rt-3-0-8.tar.gz in /usr/local<BR>As root,
run<BR> [root@moe root]# groupadd rt<BR> [root@moe root]# cd
/usr/local/rt-3-0-8<BR> [root@moe rt-3-0-8]# ./configure
--prefix=/usr/local/rt3 --with-db-type=Pg --with-db-port=5432
--with-db-dba=postgres --with-db-rt-pass=<SPAN
class=377513518-08012004><rt_user
password></SPAN> --with-web-user=apache
--with-web-group=apache<BR> [root@moe rt-3-0-8]# perl -MCPAN -e
shell<BR> <answer "yes" to
manual configuration><BR>
<hit Return at prompts until "Policy on building prerequisites"
prompt><BR>
follow<BR> <hit Return at
prompts until "Select your continent" prompt for
mirrors><BR> <give
appropriate answers for
mirrors><BR> <hit Return
at prompts until "cpan> " prompt><BR>
install Bundle::CPAN<BR> <hit
Return at prompts until "cpan> "
prompt><BR> reload
cpan<BR> <hit Return at
prompts until "cpan> " prompt><BR>
install Storable<BR> <hit
Return at prompts until "cpan> "
prompt><BR> exit<BR> [root@moe
rt-3-0-8]# chmod 755 sbin/*<BR> [root@moe rt-3-0-8]#
sbin/rt-test-dependencies --with-postgres --with-modperl2
--install<BR> <hit Return at remaining
prompts><BR> [root@moe rt-3-0-8]# sbin/rt-test-dependencies
--with-postgres --with-modperl2
--install<BR> <hit Return at remaining
prompts><BR> [root@moe rt-3-0-8]# sbin/rt-test-dependencies
--with-postgres --with-modperl2<BR> <make
sure that all dependencies are met><BR> [root@moe rt-3-0-8]# make
install<BR> [root@moe rt-3-0-8]# make initialize-database</FONT></DIV>
<DIV><FONT size=+0><FONT face=Arial><FONT size=2><SPAN
class=377513518-08012004>Modify
</SPAN>/usr/local/rt3/etc/RT_SiteConfig.pm <SPAN
class=377513518-08012004>to your needs</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT size=+0><FONT face=Arial><FONT size=2><SPAN
class=377513518-08012004></SPAN>Edit /usr/local/rt3/bin/webmux.pl and insert the
following line before line 37 (use lib...):<BR> use
Apache::compat;</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial size=2>Run<BR> [root@moe root]# /etc/init.d/httpd
start<BR></DIV></FONT>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=377513518-08012004><FONT face=Arial size=2>You can now install
RTFM, add aliases/procmail for rt-mailgate, etc. I hope this helps some RT users
outthere; I know I have taken a lot from this list, and this is my opportunity
to give back to the community.</FONT></SPAN></DIV>
<DIV><SPAN class=377513518-08012004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=377513518-08012004><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=377513518-08012004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=377513518-08012004><FONT face=Arial
size=2>-Mike</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>---</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Dr. Michael J. Panzitta</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>VP, Technology</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>PeopleMatter, Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="http://www.peoplematter.com">www.peoplematter.com</A></FONT></DIV>
<DIV> </DIV></BODY></HTML>