RE: [rt-users] Attachments getting mangled

[dyoung-rtusers]

All,

> Hello, Chris.
> Could you backup your DB, and run next to SQL queries?
> ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;
> 
> Then check if you could binary attachments without problems and report
> back.
> This query is safe but anyway I would suggest you to backup data.

Running this fixed my attachment corruption problem, thanks!

I think the Gentoo Installation Guide mentions changing some aspects of the
RT database in the comments section near the end of the document.  This may
be why both Jeremy and I had this problem (we're both running on GenToo).  I
followed the threads listed in that Guide to finally get it working, but I
honestly don't remember everything that was tweaked along the way.

Perhaps someone more knowledgeable could change the GentooInstallGuide to
reflect the above fix for future users?

Thanks again,

Donovan

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roy El-Hames
Sent: Wednesday, September 13, 2006 12:52 PM
To: Peake, Jeremy
Cc: Schultz, Eric; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Attachments getting mangled

Jeremy;
Have a look at :
http://lists.fsck.com/pipermail/rt-users/2006-July/040843.html
it maybe related.
Roy

Peake, Jeremy wrote:
>> $MaxAttachmentSize (make sure it's big enough) $TruncateLongAttachments
>> 
> (make sure it's undef) $DropLongAttachments (make sure it's undef)
>
>
> I checked that out, $MaxAttachSize is 10 megs and truncate and drop are
> both undef.
>
> Also saw an earlier post of same issue, and tried reinstalling Perl
> (5.8.8) but the probem remains.
> ___
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: [EMAIL PROTECTED]
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>   


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Any resolution on apache2/mod_perl2 "Out of Memory!" error on GenToo?

[dyoung-rtusers]

Please accept my apologies if this particular dead horse has been
sufficiently beaten, but I'm new to this list and I've already searched
through Google as well as the mailing list archives to no avail.

I'm running:

  rt-3.4.5
  apache-2.0.55-r1
  mod_perl-2.0.1-r2
gentoo-sources-2.6.15-r1
mysql-5.0.19-r1 (was using mysql-4, but found something during my
searches that suggested upgrading mysql.  No apparent effect)

   (I'm not sure what other info would be helpful, please let me know
and I'll be happy to supply)

I was wondering (read: hoping) if this list had already discovered a fix or
workaround to the "Out of Memory!  Callback called exit" error seen in the
Apache2 error_log when attempting to perform a Ticket Search from within the
RT website.  If so, could someone point me in the proper direction (URL,
email, carrier pigeon)?

Thanks in advance!

Donovan
dyoung  rtusers  techsafari  com

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html