-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I have a REALLY strange problem going on.
There are a few tickets in the database that cant be located with Query
Builder and don't show up on the quick search results page for the
queue. It also doesn't show up if I do a Query Builder search on
id=<ticketnumber>.
I can enter the ticket number in the Simple Search box and the ticket
will display but if I enter the ticket subject I get nothing.
I have checked the contents in the tickets table and nothing looks out
of place.
Here is a quick rundown of the system...
RT-3.6.1 on FreeBSD 6.1 under apache, fastcgi talking to postgres 7.4.13
on remote machine.
I am attaching the contents of the system configuration page.
Any suggestions would be appreciated.
J.D. Meek
Sr. Systems Administrator
Edgenet Inc.
[EMAIL PROTECTED]
Office: 615.237.3820
Cell: 615.438.9551
Fax: 615.371.3023
IBM eServer Certified Specialist
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (MingW32)
iQCVAwUBRT5bvc5LTlS7P9VGAQJlyQP/ZMzCVOsm/eDhzCOK+jj4BEnnMQ11/jnI
7MlvV8i5a5je5FHVc4/AB2T0ygwUYnlH1PY6xBk7yqSJ0L1Nv+9u4pkufrEav9FN
pYFib5sIwLIL9VjilkZrQUxs9aSnhsm2rt+4RebO/wNY6utRgSHGKFqI8rwxNdmt
tNYRxXxZUWM=
=rYFD
-----END PGP SIGNATURE-----
NOTICE: This email and any attached files are confidential and intended solely
for the use of the addressee. If you have received this email in error, please
notify the sender and delete it immediately, without disclosing or using its
contents for any purpose. Edgenet Inc. accepts no liability for any damage
caused by any virus transmitted by this email.
Loaded perl modules
Perl v5.8.8 under freebsd
Apache::Session v1.81;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::Null v1.01;
Apache::Session::Postgres v1.01;
Apache::Session::Serialize::Base64 v1.00;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::Postgres v1.03;
AutoLoader v5.60;
base v2.07;
Benchmark v1.07;
bytes v1.02;
Cache::Simple::TimedExpiry v0.26;
capitalization v0.03;
Carp v1.04;
CGI v3.25;
CGI::Cookie v1.27;
CGI::Fast v1.07;
CGI::Util v1.5;
Class::Container v0.12;
Class::Data::Inheritable v0.06;
Class::ReturnValue v0.53;
Clone v0.20;
constant v1.05;
Cwd v3.21;
Data::Dumper v2.121_08;
DBD::Pg v1.49;
DBD::Sponge v11.10;
DBI v1.52;
DBIx::SearchBuilder v1.43;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.13;
Devel::StackTraceFrame v0.6;
Devel::Symdump v2.0603;
Digest::base v1.00;
Digest::MD5 v2.36;
DynaLoader v1.05;
Encode v2.18;
Encode::Alias v2.06;
Encode::Config v2.03;
Encode::Encoding v2.04;
Errno v1.0901;
Exception::Class v1.23;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
FCGI v0.67;
Fcntl v1.05;
File::Basename v2.74;
File::Glob v1.05;
File::Path v1.08;
File::Spec v3.21;
File::Spec::Unix v1.5;
File::Temp v0.16;
FileHandle v2.01;
HTML::Element v3.21;
HTML::Entities v1.35;
HTML::Formatter v2.04;
HTML::FormatText v2.04;
HTML::Mason v1.33;
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.55;
HTML::Scrubber v0.08;
HTML::Tagset v3.10;
HTML::TreeBuilder v3.21;
HTTP::Date v1.47;
I18N::LangTags v0.35;
I18N::LangTags::Detect v1.03;
integer v1.00;
IO v1.22;
IO::File v1.13;
IO::Handle v1.25;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::Scalar v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.1;
IO::Wrap v2.110;
IO::WrapTie v2.110;
IPC::Open2 v1.02;
IPC::Open3 v1.02;
lib v0.5565;
List::Util v1.18;
Locale::Maketext v1.10;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.62;
Locale::Maketext::Lexicon::Gettext v0.15;
Log::Dispatch v2.13;
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.74;
Mail::Field v1.74;
Mail::Field::AddrList v1.74;
Mail::Header v1.74;
Mail::Internet v1.74;
MIME::Base64 v3.07;
MIME::Body v5.420;
MIME::Decoder v5.420;
MIME::Decoder::NBit v5.420;
MIME::Entity v5.420;
MIME::Field::ContDisp v5.420;
MIME::Field::ConTraEnc v5.420;
MIME::Field::ContType v5.420;
MIME::Field::ParamVal v5.420;
MIME::Head v5.420;
MIME::Parser v5.420;
MIME::QuotedPrint v3.07;
MIME::Tools v5.420;
MIME::Words v5.420;
Module::Versions::Report v1.02;
overload v1.04;
Params::Validate v0.86;
POSIX v1.09;
re v0.05;
Regexp::Common v2.120;
Regexp::Common::delimited v2.104;
RT v3.6.1;
RT::Interface::Email v2;
Scalar::Util v1.18;
SelectSaver v1.01;
Socket v1.78;
Storable v2.15;
strict v1.03;
Symbol v1.06;
Sys::Syslog v0.13;
Text::Autoformat v1.13;
Text::Quoted v1.8;
Text::Reform v1.11;
Text::Tabs v2005.0824;
Text::Template v1.44;
Text::Wrapper v1.000;
Time::HiRes v1.91;
Time::JulianDay v2003.1125;
Time::Local v1.11;
Time::ParseDate v2006.0814;
Time::Timezone v2006.0814;
Tree::Simple v1.16;
UNIVERSAL v1.01;
UNIVERSAL::require v0.10;
URI v1.35;
URI::Escape v3.28;
URI::URL v5.03;
URI::WithBase v2.19;
utf8 v1.06;
vars v1.01;
Want v0.12;
warnings v1.05;
warnings::register v1.01;
XSLoader v0.06;
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::CommentAddress [EMAIL PROTECTED]
RT::CorrespondAddress [EMAIL PROTECTED]
RT::DatabaseHost rtdb.edgenet.com
RT::DatabaseName rt3
RT::DatabasePassword Password not printed
RT::DatabaseRTHost ntp.edgenet.com
RT::DatabaseType Pg
RT::DatabaseUser rt3
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::DefaultSummaryRows 10
RT::EmailOutputEncoding utf-8
RT::EtcPath /usr/local/rt3/etc
RT::FriendlyFromLineFormat "%s via RT" <%s>
RT::FriendlyToLineFormat "%s of edgenet.com 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/rt3/var/log
RT::LogToFile info
RT::LogToFileNamed /var/log/rt3.log
RT::LogToScreen error
RT::LogToSyslog debug
RT::LogoURL /NoAuth/images/bplogo.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 13456
RT::MessageBoxWidth 72
RT::MessageBoxWrap HARD
RT::MinimumPasswordLength 5
RT::OldestTransactionsFirst 1
RT::Organization edgenet.com
RT::OwnerEmail [EMAIL PROTECTED]
RT::RTAddressRegexp [EMAIL PROTECTED]
RT::RecordOutgoingEmail 1
RT::RedistributeAutoGeneratedMessages privileged
RT::SITE_CONFIG_FILE /usr/local/rt3/etc/RT_SiteConfig.pm
RT::SendmailArguments -oi -t
RT::SendmailBounceArguments -f "<>"
RT::SendmailPath /usr/sbin/sendmail
RT::ShowTransactionImages 1
RT::StrictLinkACL 1
RT::Timezone US/Central
RT::UseFriendlyFromLine 1
RT::VERSION 3.6.1
RT::VarPath /usr/local/rt3/var
RT::WebBaseURL http://rt.edgenet.com
RT::WebDefaultStylesheet 3.5-default
RT::WebFlushDbCacheEveryRequest 1
RT::WebImagesURL /NoAuth/images/
RT::WebPort 80
RT::WebURL http://rt.edgenet.com/
RT::rtname edgenet.com
Perl configuration
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
Platform:
osname=freebsd, osvers=6.1-release, archname=i386-freebsd-64int
uname='freebsd giles.intranet.edgenet.com 6.1-release freebsd 6.1-release
#0: thu may 11 08:21:11 cdt 2006 [EMAIL PROTECTED]:usrobjusrsrcsysedgenet i386 '
config_args='-sde -Dprefix=/usr/local
-Darchlib=/usr/local/lib/perl5/5.8.8/mach -Dprivlib=/usr/local/lib/perl5/5.8.8
-Dman3dir=/usr/local/lib/perl5/5.8.8/perl/man/man3
-Dman1dir=/usr/local/man/man1
-Dsitearch=/usr/local/lib/perl5/site_perl/5.8.8/mach
-Dsitelib=/usr/local/lib/perl5/site_perl/5.8.8 -Dscriptdir=/usr/local/bin
-Dsiteman3dir=/usr/local/lib/perl5/5.8.8/man/man3
-Dsiteman1dir=/usr/local/man/man1 -Ui_malloc -Ui_iconv -Uinstallusrbinperl
-Dcc=cc -Duseshrplib
-Dccflags=-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.8/BSDPAN" -Doptimize=-O2
-fno-strict-aliasing -pipe -march=pentiumpro -Ud_dosuid -Di_gdbm -Dusethreads=n
-Dusemymalloc=y -Duse64bitint'
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=define use64bitall=undef uselongdouble=undef
usemymalloc=y, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.8/BSDPAN"
-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe
-Wdeclaration-after-statement -I/usr/local/include',
optimize='-O2 -fno-strict-aliasing -pipe -march=pentiumpro',
cppflags='-DAPPLLIB_EXP="/usr/local/lib/perl5/5.8.8/BSDPAN" -DHAS_FPSETMASK
-DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -Wdeclaration-after-statement
-I/usr/local/include'
ccversion='', gccversion='3.4.4 [FreeBSD] 20050518', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -Wl,-E -L/usr/local/lib'
libpth=/usr/lib /usr/local/lib
libs=-lgdbm -lm -lcrypt -lutil
perllibs=-lm -lcrypt -lutil
libc=, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version=''
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='
-Wl,-R/usr/local/lib/perl5/5.8.8/mach/CORE'
cccdlflags='-DPIC -fPIC', lddlflags='-shared -L/usr/local/lib
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com