Attachments to rt

Hi,

My rt system is truncating attachments sent to it. I have set siteconfig
to have:

Set($MaxAttachmentSize , 50000000);
Set($TruncateLongAttachments , 0);
Set($DropLongAttachments , 0);

The attachments are ok - if I cc someone the attachment gets to them fine.

Does anyone know of any other issues to check for?

Thanks,

  • Chris

Chris Hall wrote:

Hi,

My rt system is truncating attachments sent to it. I have set siteconfig
to have:

Set($MaxAttachmentSize , 50000000);
Set($TruncateLongAttachments , 0);
Set($DropLongAttachments , 0);

The attachments are ok - if I cc someone the attachment gets to them fine.

Does anyone know of any other issues to check for?
MySQL? See FAQ on the wiki.

Does it truncate to some constant size or random?

Is it truncation or garbage?

Ruslan U. Zakirov wrote:

Chris Hall wrote:

Hi,

My rt system is truncating attachments sent to it. I have set siteconfig
to have:

Set($MaxAttachmentSize , 50000000);
Set($TruncateLongAttachments , 0);
Set($DropLongAttachments , 0);

The attachments are ok - if I cc someone the attachment gets to them fine.

Does anyone know of any other issues to check for?

MySQL? See FAQ on the wiki.

Does it truncate to some constant size or random?

Is it truncation or garbage?

Its truncation, and random sizes. I dont think its mysql as I can add
attachments ok from the web interface. Heres a few attempts to add
something - the top one was added via the web, and is correct.

Wed Jul 06 11:57:33 2005 (49.4k) by chris

Wed Jul 06 11:37:57 2005 (4.2k) by chris

Wed Jul 06 11:35:30 2005 (4k) by chris

Wed Jul 06 11:22:08 2005 (4k) by chris

Wed Jul 06 11:17:00 2005 (3.6k) by chris

Wed Jul 06 11:02:55 2005 (6k) by chris

Thanks,

  • Chris

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

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Chris Hall
FilmLight Ltd
38 Bedford Square
London WC1B 3EL
+44 (0)20 7631 4905

Chris Hall wrote:

Ruslan U. Zakirov wrote:

Chris Hall wrote:

Hi,

My rt system is truncating attachments sent to it. I have set siteconfig
to have:

Set($MaxAttachmentSize , 50000000);
Set($TruncateLongAttachments , 0);
Set($DropLongAttachments , 0);

The attachments are ok - if I cc someone the attachment gets to them
fine.

Does anyone know of any other issues to check for?

MySQL? See FAQ on the wiki.

Does it truncate to some constant size or random?

Is it truncation or garbage?

Its truncation, and random sizes. I dont think its mysql as I can add
attachments ok from the web interface. Heres a few attempts to add
something - the top one was added via the web, and is correct.

Wed Jul 06 11:57:33 2005 (49.4k) by chris

Wed Jul 06 11:37:57 2005 (4.2k) by chris

Wed Jul 06 11:35:30 2005 (4k) by chris

Wed Jul 06 11:22:08 2005 (4k) by chris

Wed Jul 06 11:17:00 2005 (3.6k) by chris

Wed Jul 06 11:02:55 2005 (6k) by chris

Hmm. Very strange. I don’t know reason of the problem.
Please report back software versions and may be someone else could help you.

Thanks for looking Ruslan.

Heres some more system info.

rt-3.4.2
perl 5.8.0
apache 2.0.40
mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)

Im using qmail to capture emails, with this rt-mailgate command:

|preline /usr/local/rt3/bin/rt-mailgate --queue Myqueue --action
correspond --url http://rt.Myhost.com:81/

And heres the info from rt’s system configuration. Any ideas welcome!

Loaded perl modules

Perl v5.8.0 under linux
Apache::Access v0.01;
Apache::Connection v0.01;
Apache::Const v0.01;
Apache::Log v0.01;
Apache::RequestIO v0.01;
Apache::RequestRec v0.01;
Apache::RequestUtil v0.01;
Apache::Response v0.01;
Apache::Server v0.01;
Apache::ServerUtil v0.01;
Apache::Session v1.6;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::lock::MySQL v1.00;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
Apache::SubRequest v0.01;
Apache::URI v0.01;
Apache::Util v0.01;
APR::Date v0.01;
APR::Pool v0.01;
APR::Table v0.01;
APR::URI v0.01;
APR::Util v0.01;
AutoLoader v5.60;
base v1.03;
Benchmark v1.0501;
bytes v1.00;
Cache::Simple::TimedExpiry v0.23;
Carp v1.01;
CGI v3.10;
CGI::Cookie v1.25;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.02;
Class::ReturnValue v0.52;
constant v1.04;
Cwd v3.07;
Data::Dumper v2.12;
DBD::mysql v2.1021;
DBI v1.48;
DBIx::SearchBuilder v1.27;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.11;
Devel::StackTraceFrame v0.6;
Digest::base v1.00;
Digest::MD5 v2.33;
DynaLoader v1.04;
Encode v1.83;
Encode::Alias v1.34;
Encode::Config v1.06;
Encode::Encoding v1.30;
Errno v1.09;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.567;
Exporter::Heavy v5.567;
Fcntl v1.04;
fields v1.02;
File::Basename v2.71;
File::Glob v1.01;
File::Path v1.05;
File::Spec v3.07;
File::Spec::Unix v1.5;
File::Temp v0.13;
FileHandle v2.01;
HTML::Entities v1.23;
HTML::Mason v1.28;
HTML::Mason::ApacheHandler v1.69;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.26;
HTML::Scrubber v0.08;
I18N::LangTags v0.35;
integer v1.00;
IO v1.20;
IO::File v1.09;
IO::Handle v1.21;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.08;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.01;
IPC::Open3 v1.0104;
lib v0.5564;
List::Util v1.15;
locale v1.00;
Locale::Maketext v1.09;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.49;
Locale::Maketext::Lexicon::Gettext v0.14;
Log::Dispatch v2.10;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.67;
Mail::Field v1.67;
Mail::Field::AddrList v1.67;
Mail::Field::Date v1.67;
Mail::Header v1.67;
Mail::Internet v1.67;
MIME::Base64 v3.05;
MIME::Body v5.417;
MIME::Decoder v5.417;
MIME::Entity v5.417;
MIME::Field::ContDisp v5.417;
MIME::Field::ConTraEnc v5.417;
MIME::Field::ContType v5.417;
MIME::Field::ParamVal v5.417;
MIME::Head v5.417;
MIME::Parser v5.417;
MIME::QuotedPrint v3.03;
MIME::Tools v5.417;
MIME::Words v5.417;
mod_perl v1.9907;
ModPerl::Const v0.01;
Module::Versions::Report v1.02;
overload v1.00;
Params::Validate v0.77;
POSIX v1.05;
re v0.03;
Regexp::Common v2.120;
Regexp::Common::delimited v2.104;
RT v3.4.2;
RT::Interface::Email v1.02;
Scalar::Util v1.15;
SelectSaver v1.00;
Socket v1.75;
Storable v2.14;
strict v1.02;
Symbol v1.04;
Sys::Hostname v1.1;
Sys::Syslog v0.03;
Text::Autoformat v1.13;
Text::Quoted v1.8;
Text::Reform v1.11;
Text::Tabs v98.112801;
Text::Template v1.44;
Text::Wrapper v1.000;
Time::HiRes v1.38;
Time::JulianDay v2003.1125;
Time::Local v1.04;
Time::ParseDate v2003.1126;
Time::Timezone v2003.0211;
Time::Zone v2.21;
utf8 v1.00;
vars v1.01;
warnings v1.00;
warnings::register v1.00;
XSLoader v0.01;

RT Variables
RT::AmbiguousDayInPast 1
RT::BasePath /usr/local/rt3
RT::BinPath /usr/local/rt3/bin
RT::CORE_CONFIG_FILE /usr/local/rt3/etc/RT_Config.pm
RT::CanonicalizeEmailAddressMatch rt.Myhost.ltd.uk$
RT::CanonicalizeEmailAddressReplace Myhost.ltd.uk
RT::CommentAddress rt-comment@Myhost.ltd.uk
RT::CorrespondAddress RT::CorrespondAddress.not.set
RT::DatabaseHost localhost
RT::DatabaseName rt3
RT::DatabaseRTHost localhost
RT::DatabaseType mysql
RT::DatabaseUser root
RT::DateDayBeforeMonth 1
RT::DefaultSearchResultFormat ‘id/TITLE:#’, ‘Subject/TITLE:Subject’,
Status, QueueName, OwnerName, Priority, ‘NEWLINE’, ‘’,
Requestors’, ‘CreatedRelative’,
ToldRelative’,
LastUpdatedRelative’, 'TimeLeft
RT::EmailOutputEncoding utf-8
RT::EtcPath /usr/local/rt3/etc
RT::FriendlyFromLineFormat “%s via RT” <%s>
RT::FriendlyToLineFormat “%s of Myhost support Ticket #%s”:;
RT::LocalEtcPath /usr/local/rt3/local/etc
RT::LocalLexiconPath /usr/local/rt3/local/po
RT::LocalPath /usr/local/rt3/local
RT::LogDir /usr/local/rt/var/log
RT::LogToFileNamed rt.log
RT::LogToScreen error
RT::LogToSyslog debug
RT::LogoURL /NoAuth/images/Myhost-logo.gif
RT::LoopsToRTOwner 1
RT::MailCommand sendmailpipe
RT::MasonComponentRoot /usr/local/rt3/share/html
RT::MasonDataDir /usr/local/rt3/var/mason_data
RT::MasonLocalComponentRoot /usr/local/rt3/local/html
RT::MasonSessionDir /usr/local/rt3/var/session_data
RT::MaxAttachmentSize 50000000
RT::MaxInlineBody 134560
RT::MessageBoxWidth 72
RT::MessageBoxWrap HARD
RT::MyRequestsLength 10
RT::MyTicketsLength 10
RT::Organization Myhost.ltd.uk
RT::OwnerEmail chris@Myhost.ltd.uk
RT::ParseNewMessageForTicketCcs 1
RT::RTAddressRegexp ^Myhost-support@Myhost.ltd.uk$
RT::RecordOutgoingEmail 1
RT::RedistributeAutoGeneratedMessages 1
RT::SITE_CONFIG_FILE /usr/local/rt3/etc/RT_SiteConfig.pm
RT::SendmailArguments -oi -t
RT::SendmailPath /usr/sbin/sendmail
RT::Timezone US/Eastern
RT::TruncateLongAttachments 1
RT::TrustHTMLAttachments 1
RT::UseFriendlyFromLine 1
RT::VERSION 3.4.2
RT::VarPath /usr/local/rt3/var
RT::WebBaseURL http://rt.Myhost.ltd.uk:81
RT::WebFlushDbCacheEveryRequest 1
RT::WebImagesURL /NoAuth/images/
RT::WebURL /
RT::rtname Myhost support
Perl configuration

Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
Platform:
osname=linux, osvers=2.4.20-2.48smp, archname=i386-linux-thread-multi
uname=‘linux stripples.devel.redhat.com 2.4.20-2.48smp #1 smp thu
feb 13 11:44:55 est 2003 i686 i686 i386 gnulinux ‘
config_args=’-des -Doptimize=-O2 -march=i386 -mcpu=i686 -g
-Dmyhostname=localhost -Dperladmin=root@localhost -Dcc=gcc -Dcf_by=Red
Hat, Inc. -Dinstallprefix=/usr -Dprefix=/usr -Darchname=i386-linux
-Dvendorprefix=/usr -Dsiteprefix=/usr
-Dotherlibdirs=/usr/lib/perl5/5.8.0 -Duseshrplib -Dusethreads
-Duseithreads -Duselargefiles -Dd_dosuid -Dd_semctl_semun -Di_db
-Ui_ndbm -Di_gdbm -Di_shadow -Di_syslog -Dman3ext=3pm -Duseperlio
-Dinstallusrbinperl -Ubincompat5005 -Uversiononly -Dpager=/usr/bin/less
-isr’
hint=recommended, useposix=true, d_sigaction=define
usethreads=define use5005threads=undef useithreads=define
usemultiplicity=define
useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
use64bitint=undef use64bitall=undef uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc=‘gcc’, ccflags =’-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBUGGING -fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm’,
optimize=’-O2 -march=i386 -mcpu=i686 -g’,
cppflags=’-D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS
-DDEBUGGING -fno-strict-aliasing -I/usr/local/include -I/usr/include/gdbm’
ccversion=’’, gccversion=‘3.2.2 20030213 (Red Hat Linux 8.0
3.2.2-1)’, gccosandvers=’‘
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype=‘long’, ivsize=4, nvtype=‘double’, nvsize=8, Off_t=‘off_t’,
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld=‘gcc’, ldflags =’ -L/usr/local/lib’
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lgdbm -ldb -ldl -lm -lpthread -lc -lcrypt -lutil
perllibs=-lnsl -ldl -lm -lpthread -lc -lcrypt -lutil
libc=/lib/libc-2.3.1.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=‘2.3.1’
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=’-rdynamic
-Wl,-rpath,/usr/lib/perl5/5.8.0/i386-linux-thread-multi/CORE’
cccdlflags=’-fPIC’, lddlflags=’-shared -L/usr/local/lib’

Ruslan U. Zakirov wrote:

Chris Hall wrote:

Ruslan U. Zakirov wrote:

Chris Hall wrote:

Hi,

My rt system is truncating attachments sent to it. I have set siteconfig
to have:

Set($MaxAttachmentSize , 50000000);
Set($TruncateLongAttachments , 0);
Set($DropLongAttachments , 0);

The attachments are ok - if I cc someone the attachment gets to them
fine.

Does anyone know of any other issues to check for?

MySQL? See FAQ on the wiki.

Does it truncate to some constant size or random?

Is it truncation or garbage?

Its truncation, and random sizes. I dont think its mysql as I can add
attachments ok from the web interface. Heres a few attempts to add
something - the top one was added via the web, and is correct.

Wed Jul 06 11:57:33 2005 (49.4k) by chris

Wed Jul 06 11:37:57 2005 (4.2k) by chris

Wed Jul 06 11:35:30 2005 (4k) by chris

Wed Jul 06 11:22:08 2005 (4k) by chris

Wed Jul 06 11:17:00 2005 (3.6k) by chris

Wed Jul 06 11:02:55 2005 (6k) by chris

Hmm. Very strange. I don’t know reason of the problem.
Please report back software versions and may be someone else could help you.

Thanks,

  • Chris

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

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Chris Hall
FilmLight Ltd
38 Bedford Square
London WC1B 3EL
+44 (0)20 7631 4905

Chris Hall wrote:

Thanks for looking Ruslan.

Heres some more system info.

rt-3.4.2
perl 5.8.0
perl 5.8.0 is not SUPPORTED!

I know you said you though it wasn’t mysql in later posts, but have you
checked your my.cnf for a line like:

[jpriddy@rt jpriddy]$ cat /etc/my.cnf
[mysqld]
set-variable = max_allowed_packet=16M

I use RHEL3 and rt was exhibiting similar symptoms until I upgraded
mysql and added that file.-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Chris
Hall
Sent: Wednesday, July 06, 2005 6:46 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] attachments to rt

Hi,

My rt system is truncating attachments sent to it. I have set siteconfig

to have:

Set($MaxAttachmentSize , 50000000);
Set($TruncateLongAttachments , 0);
Set($DropLongAttachments , 0);

The attachments are ok - if I cc someone the attachment gets to them
fine.

Does anyone know of any other issues to check for?

Thanks,

Be sure to check out the RT Wiki at http://wiki.bestpractical.com