MY SOLUTION: Truncated attachments

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)

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>

Hi Danie,

With Red Hat 9, using the method I wrote down the other day is a lot easier.

However, they’ll both probably work and there’s nothing wrong with
your solution at all I’d reckon (haven’t tried it).

:slight_smile:

The RT website really needs a knowledgebase to put this kind of info.

Would someone be able to suggest it to the right people then give a few
of the regular posters here access to add content?

Regards and best wishes,

Justin Clift

Danie Marais wrote:

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.

Justin,

Indeed, your solution works just fine but doesn’t work with perl-5.8.1 which
I found is important otherwise I get errors with Storable.pm.

Regards,

Hi Danie,

With Red Hat 9, using the method I wrote down the other day is a lot
easier.

Danie Marais wrote:

Justin,

Indeed, your solution works just fine but doesn’t work with perl-5.8.1 which
I found is important otherwise I get errors with Storable.pm.

Regards,

Update to latest Storable fix (perl 5.8.0 + Storable.pm) problem.
Good luck.

Is there a Storable fix (apart from upgrading to perl-5.8.1)?

Danie Marais wrote:

Is there a Storable fix (apart from upgrading to perl-5.8.1)?

Update to latest Storable fix (perl 5.8.0 + Storable.pm) problem.
Good luck.

perl -e ‘install Storable’ -MCPAN

With Red Hat 9, using the method I wrote down the other day is a lot easier.

However, they’ll both probably work and there’s nothing wrong with
your solution at all I’d reckon (haven’t tried it).

:slight_smile:

The RT website really needs a knowledgebase to put this kind of info.

Would someone be able to suggest it to the right people then give a few
of the regular posters here access to add content?

What would be even better would be if you or someone could package
RT and all the needed perl modules as RPMs with dependencies noted
and get the fedora project or at least freshrpms.net to add it
to their apt and yum repositories. Then everyone else running
RedHat can just apt-get or yum install RT and have it come up
working.

Les Mikesell
les@futuresource.com

Les Mikesell wrote:

>>The RT website _really_ needs a knowledgebase to put this kind of info. >> >>Would someone be able to suggest it to the right people then give a few >>of the regular posters here access to add content? > > What would be even better would be if you or someone could package > RT and all the needed perl modules as RPMs with dependencies noted > and get the fedora project or at least freshrpms.net to add it > to their apt and yum repositories. Then everyone else running > RedHat can just apt-get or yum install RT and have it come up > working.

Not a bad thought (you’re welcome to get it happening, I’m not that
keen), but that’s only a “one off” solution. If RT had a community
controlled knowledgebase to work with, now that would be a real bonus.

:wink:

Regards and best wishes,

Justin Clift