[rt-users] MY SOLUTION: Truncated attachments

[Danie Marais]

Attachments being truncatedI finally got a relatively easy and painless way
of getting around the truncated attachment problem after playing around with
all the suggestions in the list regarding this issue.  It works just fine
for me and only minor compilations are neccesary if you have the right
RPM's.  Some folks discourage the use of modperl2 but I did the whole
apache1 and modperl1 thing (compiled from source) and I still had my
attachments truncated. However, this seem to work. Use at own risk blah
blah.

You basically need mod_perl-1.99-10 (the 1.99-07 that comes with RH9 is
buggy) and perl-5.8.1 (perl-5.8.0 gives me an intermittent problem with
Storable.pm) and for these two you will need httpd-2.0.47.  You also need
the SOURCE rpm's for apr and apr-util because the i386 rpm's I found do not
work properly.

I found all the RPM's at my local rawhide mirror:
ftp://ftp.is.co.za/mirror/ftp.redhat.com/linux/rawhide/i386/RedHat/RPMS/
or just search on rpm.pbone.net

Here are the files to get:
db4-4.1.25-9.i386.rpm
httpd-2.0.47-8.i386.rpm
mod_perl-1.99_09-10.i386.rpm
perl-5.8.1-91.i386.rpm
mod_ssl-2.0.47-8.i386.rpm (if you want ssl)

mysql files:
mysql-3.23.54a-11.i386.rpm
mysql-server-3.23.54a-11.i386.rpm
perl-DBD-MySQL-2.9002-1.i386.rpm
perl-DBI-1.32-5.i386.rpm

apr source rpms:
apr-0.9.4-2.src.rpm
apr-util-0.9.4-2.src.rpm

Start with a standard RH9 installation including the standard perl and
apache versions

Upgrade perl:
# rpm -i db4-4.1.25-9.i386.rpm
# rpm -U perl-5.8.1-91.i386.rpm

Install MySQL
# rpm -i perl-DBD-MySQL-2.9002-1.i386.rpm perl-DBI-1.32-5.i386.rpm
# rpm -i mysql-3.23.54a-11.i386.rpm mysql-server-3.23.54a-11.i386.rpm

remove old stuff (needed by httpd-2.0.40 - can be installed again later)
# rpm -e mod_perl
# rpm -e mod_ssl
# rpm -e php-imap
# rpm -e php-ldap
# rpm -e php
# rpm -e mod_python

build and install apr (thanks to Justin Clift for these instructions)
# rpm -i apr-0.9.4-2.src.rpm apr-util-0.9.4-2.src.rpm
# cd /usr/src/redhat/SPECS
# rpmbuild -bb apr.spec
# rpm -Uvh ../RPMS/i386/apr*rpm
# rpmbuild -bb apr-util.spec
# rpm -Uvh ../RPMS/i386/apr-util*

Upgrade httpd-2.0.40 to 2.0.47 and install httpd-devel
# rpm -U httpd-2.0.47-6.i386.rpm

Install the ssl module (if needed)
# rpm -i mod_ssl-2.0.47-8.i386.rpm

Install mod_perl
# rpm -i mod_perl-1.99_09-10.i386.rpm

Setup CPAN
# perl -MCPAN -eshell
cpan> quit

Run rt-test-dependencies
# export LC_ALL="C"
# perl sbin/rt-test-dependencies --with-mysql --with-modperl2 --install

Then force install the modules that won't install by themselves
# perl -MCPAN -eshell
cpan> force install Log::Dispatch
cpan> force install WWW::Mechanize
cpan> force install HTML::Mason
cpan> quit

Setup in httpd.conf (from readme in rt-3.0.6.tar.gz)
<VirtualHost your.ip.address>
    ServerName your.rt.server.hostname
    DocumentRoot /opt/rt3/share/html
    AddDefaultCharset UTF-8

    # these four lines applies to Apache2+mod_perl2 only: {{{
    PerlSetVar MasonArgsMethod CGI
    PerlModule Apache2 Apache::compat
    RewriteEngine On
    RewriteRule ^(.*)/$ $1/index.html
    # }}}

    PerlModule Apache::DBI
    PerlRequire /opt/rt3/bin/webmux.pl

    <Location />
        SetHandler perl-script
        PerlHandler RT::Mason
    </Location>
</VirtualHost>