RT becoming unstable / unable to add attachments (requires apache restart to fix?)

Do you suggest mod_perl 1.0 or 2.0 ?

Personally, I like FastCGI, mod_perl1 and mod_perl 2.0, in that order.
Note also that mod_perl 2.0 isn’t out yet. Please do try to cc rt-devel
when replying, rather than sending mail directly to someone on the list
helping you out. That way, everything ends up in the archives.

Best,
Jesse

We’re having a strange problem where by a ticket(s) will accept image
attachments fine for awhile, then suddenly, any attachments made to it
no longer get stored corrected, a red X / box is displayed (broken link)
and even trying to save the attachment off results in a corrupted file.

The only way to fix this issue is to restart Apache, after doing so -
the tickets accept attachments normally again. However, any attachments
made before the start are obviously still corrupted data.

Has anyone else had this issue of Apache needing to be restarted in
order to allow attachments to process correctly again?

Rodney Caston
Match.com

The Details

Linux da0mirt001 2.4.21-4.ELsmp #1 SMP # uname -a
3.2.2 # cat /opt/rt3/lib/RT.pm | grep VERSION
5.8.6 # perl -v
5.008 # echo “<% $] %>” >/opt/rt3/local/html/test.html
1.19 # perl -MDBIx::SearchBuilder -e 'print
$DBIx::SearchBuilder::VERSION;'
2.0.46 # httpd -v
NO OUTPUT # cat error_log | grep mod_perl | grep notice | tail -n
1
3.23.58 # mysql -V

begin httpd.conf

<VirtualHost 10.223.206.69>
ServerName rt.match.corp
DocumentRoot /usr/local/rt3/share/html
AddDefaultCharset UTF-8
Alias /NoAuth/images/ /usr/local/rt3/share/html/NoAuth/images/

# these four lines apply to Apache2+mod_perl2 only: {{{
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>
use Apache::DB (); Apache::DB->init; >

<IfDefine !PerlSmallProf>
PerlModule Apache::DProf

Change it to Apache2 if use mod_perl 2

PerlModule Apache2

PerlModule Apache::Status PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache PerlModule Apache::DBI

AddDefaultCharset UTF-8

PerlRequire /usr/local/rt3/bin/webmux.pl

Options None SetHandler perl-script PerlHandler RT::Mason PerlFixupHandler Apache::SmallProf

<Location /NoAuth/images>
SetHandler default-handler

SetHandler perl-script PerlHandler Apache::Status PerlSetVar StatusOptionsAll On PerlSetVar StatusTerse On PerlSetVar StatusTerseSize On PerlSetVar StatusTerseSizeMainSummary On PerlSetVar StatusLexInfo On ### end httpd conf ###

We’re having a strange problem where by a ticket(s) will accept image
attachments fine for awhile, then suddenly, any attachments made to it
no longer get stored corrected, a red X / box is displayed (broken link)
and even trying to save the attachment off results in a corrupted file.

The only way to fix this issue is to restart Apache, after doing so -
the tickets accept attachments normally again. However, any attachments
made before the start are obviously still corrupted data.

Has anyone else had this issue of Apache needing to be restarted in
order to allow attachments to process correctly again?

  1. It looks like your mod_perl isn’t built against 5.8.6. It’s built
    against 5.8.0, which we know breaks attachments like this.
  2. It looks like you’re using an old (known-unusable) version of mysql.

Rodney Caston
Match.com

The Details

(For the future, there’s a page that displays all this and more in the
admin menu)