Attachments being truncated

I’ve seen several references to this in the archives, but I’m still quite
confused.

Right now all of the attachments are being truncated in RT at ~3k. They are
stored this way in the database. This is on a redhat 9.1 machine.

My maximum attachment size (RT_SiteConfig.pm) is set to 10 megs.

Does anyone have any idea what is going on here? This happens regardless of
the type of attachment (binary of text).

I appreciate any help that you guys can give me on this one, as I’m
completely stumped.

Thanks,

Nick

My maximum attachment size (RT_SiteConfig.pm) is set to 10 megs.

What about your max_allowed_packet in your /etc/my.cnf file?

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

I had a problem where all my attachements appeared to be truncated to 7.8k
no matter what kind they were. As it turned out a variable in the DBI
package limited downloading of attachments to 8k. After setting it to 8M
all the files could be retrieved correctly. You may need to check that. I
found it set in DBIx::SearchBuilder::Handle::Oracle.pm (You will have to
look at mysql.pm if you are using mysql etc)

$self->dbh->{LongReadLen}=8000000;

John
At 12:42 PM 10/22/2003, Nick Pleis wrote:

That sounds like the problem some folks have had with RedHat shipping a
buggy build fo a beta of mod_perl2.On Wed, Oct 22, 2003 at 02:42:41PM -0500, Nick Pleis wrote:

I’ve seen several references to this in the archives, but I’m still quite
confused.

Right now all of the attachments are being truncated in RT at ~3k. They are
stored this way in the database. This is on a redhat 9.1 machine.

My maximum attachment size (RT_SiteConfig.pm) is set to 10 megs.

Does anyone have any idea what is going on here? This happens regardless of
the type of attachment (binary of text).

I appreciate any help that you guys can give me on this one, as I’m
completely stumped.

Thanks,

Nick

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

I have no such option…

My.cnf:

[mysqld]
datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I should have also noted that attachments attached via the web interface
work fine.

Nick-----Original Message-----
From: Michael S. Liebman [mailto:m-liebman@northwestern.edu]
Sent: Wednesday, October 22, 2003 2:57 PM
To: Nick Pleis
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Attachments being truncated

On Wed, Oct 22, 2003 at 02:42:41PM -0500, Nick Pleis wrote:

My maximum attachment size (RT_SiteConfig.pm) is set to 10 megs.

What about your max_allowed_packet in your /etc/my.cnf file?

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

The mod_perl is 1.99_07-5 (standard with redhat 9.1).

If this truly is the problem, was there a sane fix? I can’t find any Redhat
RPMs of later mod perl versions, was building the source version good enough
to fix it?

NickFrom: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Wednesday, October 22, 2003 3:01 PM
To: Nick Pleis
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Attachments being truncated

That sounds like the problem some folks have had with RedHat shipping a
buggy build fo a beta of mod_perl2.

It is definitely a buggy mod_perl2 in RHL.
I had to rebuild it, but I did it with Apache 1.3.28 and mod_perl1 and went
fine.From: Nick Pleis [mailto:NickP@cesinc.com]
Sent: Miércoles, 22 de Octubre de 2003 05:15 p.m.
To: ‘Jesse Vincent’; Nick Pleis
Cc: rt-users@lists.fsck.com
Subject: RE: [rt-users] Attachments being truncated

The mod_perl is 1.99_07-5 (standard with redhat 9.1).

If this truly is the problem, was there a sane fix? I can’t find any Redhat
RPMs of later mod perl versions, was building the source version good enough
to fix it?

Nick

From: Jesse Vincent [ mailto:jesse@bestpractical.com
mailto:jesse@bestpractical.com ]
Sent: Wednesday, October 22, 2003 3:01 PM
To: Nick Pleis
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Attachments being truncated

That sounds like the problem some folks have had with RedHat shipping a
buggy build fo a beta of mod_perl2.

I found sending plain text or rich text e-mails with attachments seem to
work as html emails don’t. My mysql db is setup for 16m and RT set to
10m and html e-mails with attachments don’t make it. Shrugs. I’ve kinda
given up since I got a workaround

Michael-----Original Message-----
From: Nick Pleis [mailto:NickP@cesinc.com]
Posted At: Wednesday, October 22, 2003 3:43 PM
Posted To: RT
Conversation: [rt-users] Attachments being truncated
Subject: [rt-users] Attachments being truncated

I’ve seen several references to this in the archives, but I’m still
quite confused.
Right now all of the attachments are being truncated in RT at ~3k. They
are stored this way in the database. This is on a redhat 9.1 machine.
My maximum attachment size (RT_SiteConfig.pm) is set to 10 megs.
Does anyone have any idea what is going on here? This happens regardless
of the type of attachment (binary of text).
I appreciate any help that you guys can give me on this one, as I’m
completely stumped.
Thanks,
Nick

The mod_perl is 1.99_07-5 (standard with redhat 9.1).

If this truly is the problem, was there a sane fix? I can’t find any Redhat
RPMs of later mod perl versions, was building the source version good enough
to fix it?

There was a message just the other day about this very problem.

The solution is to grab mod_perl source RPM from Rawhide repository, as
well as its prerequisites (apr-src.rpm). Build and install apr RPMs,
then modify the mod_perl spec file to disable the exact version
requirement for httpd (by default it requires httpd 2.0.45, the one that
is in rawhide). Then build and install the updated mod_perl RPM, and you
are all set.

For detailed instructions, see archives -- the subject was

‘SOLUTION FOUND: For the truncation of RTFM article contents’.

-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Wednesday, October 22, 2003 3:01 PM
To: Nick Pleis
Cc: rt-users@lists.fsck.com
Subject: Re: [rt-users] Attachments being truncated

That sounds like the problem some folks have had with RedHat shipping a
buggy build fo a beta of mod_perl2.

I’ve seen several references to this in the archives, but I’m still
quite confused.

Right now all of the attachments are being truncated in RT at ~3k.
They are stored this way in the database. This is on a redhat 9.1
machine.

My maximum attachment size (RT_SiteConfig.pm) is set to 10 megs.

Does anyone have any idea what is going on here? This happens
regardless of the type of attachment (binary of text).

I appreciate any help that you guys can give me on this one, as I’m
completely stumped.

Thanks,

Nick

| Victor Danilchenko | When in danger or in doubt, |
| danilche@cs.umass.edu | run in circles, scream, and shout. |
| CSCF | 5-4231 | Robert Heinlein |