[rt-users] attachments to rt

Chris Hall chris at filmlight.ltd.uk
Wed Jul 6 10:02:51 EDT 2005


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;
   Date::Format v2.22;
   Date::Parse v2.23;
   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 at 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 	'<B><A 
HREF="/Ticket/Display.html?id=__id__">__id__</a></B>/TITLE:#', '<B><A 
HREF="/Ticket/Display.html?id=__id__">__Subject__</a></B>/TITLE:Subject', 
Status, QueueName, OwnerName, Priority, '__NEWLINE__', '', 
'<small>__Requestors__</small>', '<small>__CreatedRelative__</small>', 
'<small>__ToldRelative__</small>', 
'<small>__LastUpdatedRelative__</small>', '<small>__TimeLeft__</small>'
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 at 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 at 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



More information about the rt-users mailing list