[rt-users] RT3 on Interbase / Firebird?

Wed Jan 5 02:56:20 EST 2005

For future reference:
My InnoDB Index was full . I just had to add another file and restart 
the MYSql...

Leon wrote:

> I would like to know if there is anyone out there that has tried to get 
> RT3 to work on Interbase or firebird.
> 
> I ran into a Table Full on my MySQL attachments table and now I am 
> stuck. I have no idea how to increase the size of my DB or to remove old 
> attachments.
> 
> I am running RT 3.2.1.
> I have attached my Config file, if there is someone that might be able 
> to help me...
> 
> Leon
> 
> 
> ------------------------------------------------------------------------
> 
> Perl v5.8.4 under linux   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;  AutoLoader v5.60;  base v2.05;  Benchmark v1.06;  bytes v1.01;  Carp v1.02;  CGI v3.04;  CGI::Cookie v1.24;  CGI::Fast v1.05;  CGI::Util v1.4;  Class::Container v0.11;  Class::Data::Inheritable v0.02;  Class::ReturnValue v0.52;  constant v1.04;  Cwd v2.17;  Data::Dumper v2.121;  DBD::mysql v2.9002;  DBI v1.38;  DBIx::SearchBuilder v1.01;  Devel::StackTrace v1.11;  Devel::StackTraceFrame v0.6;  Digest::base v1.00;  Digest::MD5 v2.33;  DynaLoader v1.05;  Encode v1.99_01;  Encode::Alias v1.38;  Encode::Config v1.07;  Encode::Encoding v1.33;  Errno v1.09;  Exception::Class v1.19;  Exception::Class::Base v1.2;  Exporter v5.58;  Exporter::Heavy v5.58;  FCGI v0.67;  Fcntl v1.05;  fields v2.03;  File::Basename v
2.72;  File::Glob v1.02;  File::Path v1.06;  File::Spec v0.87;  File::Spec::Unix v1.5;  File::Temp v0.14;  FileHandle v2.01;  HTML::Entities v1.27;  HTML::Mason v1.26;  HTML::Mason::CGIHandler v1.00;  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.33;  HTML::Scrubber v0.08;  I18N::LangTags v0.29;  integer v1.00;  IO v1.21;  IO::File v1.10;  IO::Handle v1.24;  IO::InnerFile v2.102 ;  IO::Lines v2.103 ;  IO::Scalar v2.105 ;  IO::ScalarArray v2.103 ;  IO::Seekable v1.09;  IO::Wrap v2.102 ;  IO::WrapTie v2.102 ;  IPC::Open2 v1
.01;  IPC::Open3 v1.0106;  lib v0.5565;  List::Util v1.13;  locale v1.00;  Locale::Maketext v1.08;  Locale::Maketext::Fuzzy v0.02;  Locale::Maketext::Lexicon v0.38;  Locale::Maketext::Lexicon::Gettext v0.11;  Log::Dispatch v2.10;  Log::Dispatch::Base v1.09;  Log::Dispatch::File v1.22;  Log::Dispatch::Output v1.26;  Log::Dispatch::Screen v1.17;  Log::Dispatch::Syslog v1.18;  Mail::Address v1.62;  Mail::Field v1.62;  Mail::Field::AddrList v1.62;  Mail::Header v1.62;  Mail::Internet v1.62;  MIME::Base64 v3.01;  MIME::Body v5.403 ;  MIME::Decoder v5.403 ;  MIME::Decoder::NBit v5.403 ;  MIME::Entity v5.404 ;  MIME::Field::ContDisp v5.403 ;  MIME::Field::ConTraEnc v5.403 ;  MIME::Field::ContType v5.403 ;  MIME::Field::ParamVal v5.403 ;  MIME::Head v5.403 ;  MIME::Parser v5.406 ;  MIME::QuotedPrint v3.01;  MIME::Tools v5.411 ;  MIME::Words v5.404 ;  Module::Versions::Report v1.02;  overload v1.01;  Params::Validate v0.67;  POSIX v1.08;  re v0.04;  Regexp::Common v2.117;  Regexp::Com
mon::delimited v2.103;  RT v3.2.1;  Scalar::Util v1.13;  SelectSaver v1.00;  Socket v1.77;  Storable v2.12;  strict v1.03;  Symbol v1.05;  Sys::Hostname v1.11;  Sys::Syslog v0.05;  Text::Autoformat v1.12;  Text::Quoted v1.8;  Text::Reform v1.11;  Text::Tabs v98.112801;  Text::Template v1.44;  Text::Wrapper v1.000;  Time::HiRes v1.59;  Time::JulianDay v2003.1125;  Time::Local v1.07;  Time::ParseDate v2003.1126;  Time::Timezone v2003.0211;  URI v1.31;  URI::Escape v3.26;  URI::URL v5.03;  URI::WithBase v2.19;  utf8 v1.03;  vars v1.01;  warnings v1.03;  warnings::register v1.00;  XSLoader v0.02;
> 
> 
> 
> RT Variables
> RT::AmbiguousDayInPast 1  
> RT::BasePath /opt/rt3  
> RT::CORE_CONFIG_FILE /opt/rt3/etc/RT_Config.pm  
> RT::CanonicalizeEmailAddressMatch rt.datatex.co.za$  
> RT::CanonicalizeEmailAddressReplace datatex.co.za  
> RT::CommentAddress tracker at datatex.co.za  
> RT::CorrespondAddress support at datatex.co.za  
> RT::DatabaseName rt3  
> RT::DatabasePassword Password not printed  
> RT::DatabaseRTHost rt.datatex.co.za  
> RT::DatabaseType mysql  
> RT::DatabaseUser rt_user  
> 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 /opt/rt3/etc  
> RT::FriendlyFromLineFormat "%s via RT" <%s>  
> RT::FriendlyToLineFormat "%s of datatex.co.za Ticket #%s":;  
> RT::LocalEtcPath /opt/rt3/local/etc  
> RT::LocalLexiconPath /opt/rt3/local/po  
> RT::LocalPath /opt/rt3/local  
> RT::LogDir /opt/rt3/var/log  
> RT::LogToFile debug  
> RT::LogToFileNamed rt.log  
> RT::LogToScreen error  
> RT::LogToSyslog debug  
> RT::LogoURL http://rt.datatex.co.za:80/NoAuth/images/rt.jpg  
> RT::LoopsToRTOwner 1  
> RT::MailCommand sendmailpipe  
> RT::MasonComponentRoot /opt/rt3/share/html  
> RT::MasonDataDir /opt/rt3/var/mason_data  
> RT::MasonLocalComponentRoot /opt/rt3/local/html  
> RT::MasonSessionDir /opt/rt3/var/session_data  
> RT::MaxAttachmentSize 6000000  
> RT::MaxInlineBody 13456  
> RT::MessageBoxWidth 72  
> RT::MessageBoxWrap HARD  
> RT::MinimumPasswordLength Password not printed  
> RT::MyRequestsLength 10  
> RT::MyTicketsLength 10  
> RT::Organization datatex.co.za  
> RT::OwnerEmail rt-admin  
> RT::RTAddressRegexp ^support\@datatex.co.za$  
> RT::RecordOutgoingEmail 1  
> RT::SITE_CONFIG_FILE /opt/rt3/etc/RT_SiteConfig.pm  
> RT::SendmailArguments -oi -t -ODeliveryMode=b -OErrorMode=m  
> RT::SendmailPath /usr/sbin/sendmail  
> RT::Timezone Africa/Johannesburg  
> RT::UseFriendlyFromLine 1  
> RT::VERSION 3.2.1  
> RT::VarPath /opt/rt3/var  
> RT::WebBaseURL http://rt.datatex.co.za:80  
> RT::WebImagesURL http://rt.datatex.co.za:80/NoAuth/images/  
> RT::WebURL http://rt.datatex.co.za:80/  
> RT::rtname datatex.co.za  
> 
> Perl configuration
> Summary of my perl5 (revision 5 version 8 subversion 4) configuration:
>   Platform:
>     osname=linux, osvers=2.4.18-64gb-smp, archname=i686-linux
>     uname='linux gem 2.4.18-64gb-smp #1 smp wed mar 27 13:58:12 utc 2002 i686 unknown '
>     config_args=''
>     hint=recommended, useposix=true, d_sigaction=define
>     usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
>     useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
>     use64bitint=undef use64bitall=undef uselongdouble=undef
>     usemymalloc=n, bincompat5005=undef
>   Compiler:
>     cc='cc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
>     optimize='-O2',
>     cppflags='-fno-strict-aliasing -I/usr/local/include'
>     ccversion='', gccversion='2.95.3 20010315 (SuSE)', 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='cc', ldflags =' -L/usr/local/lib'
>     libpth=/usr/local/lib /lib /usr/lib
>     libs=-lnsl -ldb -ldl -lm -lcrypt -lutil -lc
>     perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
>     libc=, so=so, useshrplib=false, libperl=libperl.a
>     gnulibc_version='2.2.5'
>   Dynamic Linking:
>     dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
>     cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com