Attachments truncation

RT Users
1

Hi,

I have the defaults for attachment size and truncation set (no trunc

and 10 mb file maxs) but when someone emails a 1mb file it is trunced to
7.8k ?? Where do I start??

TIA
John

<>< Proverbs 3:5-6 “Trust in the Lord with all your heart and lean not on
your own understanding;
in all your ways acknowledge him, and he
will make your paths straight.”

2

You have a look at the datatype you’re using for RT’s
Attachments.Content. For all supported database this is a blob or text
type that can support multi-gigabyte attachments. Either your
database’s type for this is somehow different or maybe you have a
broken redhat build of modperl that truncates things.

jesseOn Tue, Aug 12, 2003 at 04:01:25PM -0700, John Gedeon wrote:

Hi,

I have the defaults for attachment size and truncation set (no trunc
and 10 mb file maxs) but when someone emails a 1mb file it is trunced to
7.8k ?? Where do I start??

TIA
John

–
<>< Proverbs 3:5-6 “Trust in the Lord with all your heart and lean not on
your own understanding;
in all your ways acknowledge him, and he
will make your paths straight.”

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

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

3

Our db (Oracle 8.1.7) type is CLOB i am pretty sure it can handle the large
files. But since you mention mod_perl I did have trouble installing
mod_perl. (mainly in getting it to talk to the apache server I installed)
Maybe that is the problem? (I am running rt’s web interface via fastcgi.
but both uploading via web and attaching via email truncates it. Zipping it
doesn’t help)

John
At 06:43 PM 8/12/2003, Jesse Vincent wrote:

You have a look at the datatype you’re using for RT’s
Attachments.Content. For all supported database this is a blob or text
type that can support multi-gigabyte attachments. Either your
database’s type for this is somehow different or maybe you have a
broken redhat build of modperl that truncates things.

    jesse

Hi,

I have the defaults for attachment size and truncation set (no trunc
and 10 mb file maxs) but when someone emails a 1mb file it is trunced to
7.8k ?? Where do I start??

TIA
John

–
<>< Proverbs 3:5-6 “Trust in the Lord with all your heart and lean not on
your own understanding;
in all your ways acknowledge him, and he
will make your paths straight.”

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

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

<>< Proverbs 3:5-6 “Trust in the Lord with all your heart and lean not on
your own understanding;
in all your ways acknowledge him, and he
will make your paths straight.”

4

From: John Gedeon jgedeon@qualcomm.com
Subject: Re: [rt-users] Attachments truncation
Cc: rt-users@fsck.com

Our db (Oracle 8.1.7) type is CLOB i am pretty sure it can handle the large
files. But since you mention mod_perl I did have trouble installing
mod_perl. (mainly in getting it to talk to the apache server I installed)
Maybe that is the problem? (I am running rt’s web interface via fastcgi.
but both uploading via web and attaching via email truncates it. Zipping it
doesn’t help)

J
Lookup DBD::Oracle and search for truncate. You need to tell DBD::Oracle
that is should allow longer than 8K attachments.

Joop van de Wege JoopvandeWege@mococo.nl

5

Thanks for the tip That did it.
I found that in Searchbuilder/Handle/Oracle.pm LongTruncOk was set to 1
and LongReadLen was set to 8k

John
At 05:00 AM 8/14/2003, Joop van de Wege wrote:>On Thu, 14 Aug 2003 02:20:09 -0400 rt-users-request@lists.fsck.com wrote:

From: John Gedeon jgedeon@qualcomm.com
Subject: Re: [rt-users] Attachments truncation
Cc: rt-users@fsck.com

Our db (Oracle 8.1.7) type is CLOB i am pretty sure it can handle the
large
files. But since you mention mod_perl I did have trouble installing
mod_perl. (mainly in getting it to talk to the apache server I installed)
Maybe that is the problem? (I am running rt’s web interface via fastcgi.
but both uploading via web and attaching via email truncates it.
Zipping it
doesn’t help)

J
Lookup DBD::Oracle and search for truncate. You need to tell DBD::Oracle
that is should allow longer than 8K attachments.

–
Joop van de Wege JoopvandeWege@mococo.nl

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

<>< Proverbs 3:5-6 “Trust in the Lord with all your heart and lean not on
your own understanding;
in all your ways acknowledge him, and he
will make your paths straight.”