[rt-users] HOWTO: installing RT3 on RH9 with PostgreSQL
Mike Panzitta
mpanzitta at peoplematter.com
Thu Jan 8 13:56:33 EST 2004
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".
RedHat 9
- Firewall
- allow incoming WWW, SSH, DHCP, SMTP, 5432:tcp
- Packages (use these as minimum, only add additional necessary
packages)
- X Window System
- XFree86-xdm
- gdm
- redhat-config-xfree86
- Gnome Desktop Environment
[no packages selected]
- Editors
- Graphical Internet
- mozilla
- SQL Database Server
- Development Tools
- doxygen
Make sure that the system has been up2date'ed
Apache2/mod_perl2
Obtain the following RPMs from rpmfind.net or another source:
- apr-0.9.4-2.src.rpm
- apr-util-0.9.4-2.i386.rpm
- apr-util-devel-0.9.4-2.i386.rpm
- db4-4.1.25-12.i386.rpm
- httpd-2.0.47-10.i386.rpm
- httpd-devel-2.0.47-8.i386.rpm
- mod_perl-1.99_09-10.src.rpm
Using the RPMs from above, log in as root and run
[root at moe root]# rpm -i apr-0.9.4-2.src.rpm
[root at moe root]# rpmbuild -bb /usr/src/redhat/SPECS/apr.spec
[root at 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
[root at 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
[root at moe root]# rpm -i mod_perl-1.99_09-10.src.rpm
[root at moe root]# rpmbuild -bb /usr/src/redhat/SPECS/mod_perl.spec
[root at moe root]# rpm -i
/usr/src/redhat/RPMS/i386/mod_perl-1.99_09-10.i386.rpm
Modify /etc/httpd/conf/httpd.conf as needed
Create /etc/httpd/conf.d/rt3.conf similar to this:
ServerName support.corp.peoplematter.com
DocumentRoot /usr/local/rt3/share/html
PerlSetVar MasonArgsMethod CGI
PerlModule Apache2 Apache::compat
RewriteEngine On
RewriteRule ^(.*)/$ $1/index.html
PerlModule Apache::DBI
PerlRequire /usr/local/rt3/bin/webmux.pl
<Location />
SetHandler perl-script
PerlHandler RT::Mason
</Location>
Run
[root at moe root]# chkconfig --level 345 httpd on
PostgreSQL
Run
[root at moe root]# chkconfig --level 345 postgresql on
[root at moe root]# /etc/init.d/postgresql start
Modify /var/lib/pgsql/data/postgresql.conf to allow TCP connections (and
any other mods you require)
Modify /var/lib/pgsql/data/pg_hba.conf to allow local access
Run
[root at moe root]# /etc/init.d/postgresql restart
[root at moe root]# psql -U postgres template1
template1=# alter user postgres with encrypted password '<postgres
password>';
template1=# create user rt_user with encrypted password '<rt_user
password>';
template1=# \q
RT3
Unpack rt-3-0-8.tar.gz in /usr/local
As root, run
[root at moe root]# groupadd rt
[root at moe root]# cd /usr/local/rt-3-0-8
[root at 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=<rt_user password> --with-web-user=apache
--with-web-group=apache
[root at moe rt-3-0-8]# perl -MCPAN -e shell
<answer "yes" to manual configuration>
<hit Return at prompts until "Policy on building prerequisites"
prompt>
follow
<hit Return at prompts until "Select your continent" prompt for
mirrors>
<give appropriate answers for mirrors>
<hit Return at prompts until "cpan> " prompt>
install Bundle::CPAN
<hit Return at prompts until "cpan> " prompt>
reload cpan
<hit Return at prompts until "cpan> " prompt>
install Storable
<hit Return at prompts until "cpan> " prompt>
exit
[root at moe rt-3-0-8]# chmod 755 sbin/*
[root at moe rt-3-0-8]# sbin/rt-test-dependencies --with-postgres
--with-modperl2 --install
<hit Return at remaining prompts>
[root at moe rt-3-0-8]# sbin/rt-test-dependencies --with-postgres
--with-modperl2 --install
<hit Return at remaining prompts>
[root at moe rt-3-0-8]# sbin/rt-test-dependencies --with-postgres
--with-modperl2
<make sure that all dependencies are met>
[root at moe rt-3-0-8]# make install
[root at moe rt-3-0-8]# make initialize-database
Modify /usr/local/rt3/etc/RT_SiteConfig.pm to your needs
Edit /usr/local/rt3/bin/webmux.pl and insert the following line before
line 37 (use lib...):
use Apache::compat;
Run
[root at moe root]# /etc/init.d/httpd start
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.
Thanks,
-Mike
---
Dr. Michael J. Panzitta
VP, Technology
PeopleMatter, Inc.
www.peoplematter.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040108/f9c9f125/attachment.htm>
More information about the rt-users
mailing list