[rt-users] RT becoming unstable / unable to add attachments (requires apache restart to fix?)

[Jesse Vincent]

On Fri, Jan 28, 2005 at 11:59:03AM -0600, Rodney Caston wrote:
> 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)


> 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>
> </VirtualHost>
> 
> <IfDefine PerlDProf>
>   <Perl>
>     use Apache::DB ();
>     Apache::DB->init;
>   </Perl>>
> 
>   <IfDefine !PerlSmallProf>
>     PerlModule Apache::DProf
>   </IfDefine>
> </IfDefine>
> 
> # Change it to Apache2 if use mod_perl 2
> PerlModule Apache2
> 
> <IfDefine PerlStatus>
>   PerlModule Apache::Status
> </IfDefine>
> 
> <IfDefine PerlDBIProf>
>   PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache
> </IfDefine>
> PerlModule Apache::DBI
> 
> AddDefaultCharset UTF-8
> 
> PerlRequire /usr/local/rt3/bin/webmux.pl
> 
> <Location />
>   Options None
>   SetHandler perl-script
>   PerlHandler RT::Mason
>   <IfDefine PerlDProf>
>     <IfDefine PerlSmallProf>
>       PerlFixupHandler Apache::SmallProf
>     </IfDefine>
>   </IfDefine>
> </Location>
> 
> <Location /NoAuth/images>
>   SetHandler default-handler
> </Location>
> 
> <IfDefine PerlStatus>
>   <Location /perl-status>
>     SetHandler perl-script
>     PerlHandler Apache::Status
>     PerlSetVar StatusOptionsAll On
>     PerlSetVar StatusTerse On
>     PerlSetVar StatusTerseSize On
>     PerlSetVar StatusTerseSizeMainSummary On
>     PerlSetVar StatusLexInfo On
>   </Location>
> </IfDefine>
> ### end httpd conf ###
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Administrator and Developer training is coming to your town soon! (Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com for details.
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 

--