Bug on chart ? on RT3.8 postrgresql 8.3

jul · March 12, 2009, 12:43am

Hello everyone,

New to the list, (should lurk before post, I know)

after having installed rt3.8 from
deb http://debian.etc.gen.nz etch rt
with a postgresql 8.3
with a rt 3.8 version I have when trying to graph data based on time the
following error in my log

Mar 11 18:29:03 XXXXXXX RT: RT::Handle=HASH(0x3204970) couldn’t execute
the query ‘SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS
lastupdateddaily FROM Tickets main WHERE (main.Status != ‘deleted’) AND
(main.id > ‘0’) AND (main.Type = ‘ticket’) AND (main.EffectiveId =
main.id) GROUP BY SUBSTR(LastUpdated,1,10) ’ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
^IDBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x3204970)’,
‘SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS last…’) called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 238
^IDBIx::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0x5811660)’)
called at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 164
^IRT::Report::_DoSearch(‘RT::Report::Tickets=HASH(0x5811660)’)
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 498
^IDBIx::SearchBuilder::Next(‘RT::Report::Tickets=HASH(0x5811660)’) called
at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 228
^IRT::Report::Next(’

So I opened pgsql to find that

SELECT count(main.id) AS id, substr( CAST ( LastUpdated AS TEXT ) , 1 ,10
) AS lastupdateddaily FROM Tickets main WHERE (main.Status != ‘deleted’)
AND (main.id > ‘0’) AND (main.Type = ‘ticket’) AND (main.EffectiveId =
main.id) GROUP BY substr( CAST ( LastUpdated AS TEXT ) , 1 ,10 )

Worked better.

Is this an old bug or a current one ? How can I patch my rt so that the
cast is included ?

Here come sys config from RT page :

Perl v5.10.0 under linux
Apache::Session v1.86;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Null v1.01;
Apache::Session::Postgres v1.01;
Apache::Session::Serialize::Base64 v1.01;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::Postgres v1.03;
AutoLoader v5.63;
base v2.13;
bytes v1.03;
Cache::Simple::TimedExpiry v0.27;
Carp v1.08;
CGI v3.29;
CGI::Cookie v1.28;
CGI::Util v1.5_01;
Class::Container v0.12;
Class::Data::Inheritable v0.08;
Class::Inspector v1.23;
Class::ReturnValue v0.55;
Clone v0.28;
constant v1.13;
Cwd v3.2701;
Data::Dumper v2.121_14;
DateTime v0.42;
DateTime::Locale v0.35;
DateTime::Set v0.25;
DateTime::TimeZone v0.7701;
DateTime::TimeZone::Floating v0.01;
DateTime::TimeZone::Local v0.01;
DateTime::TimeZone::OffsetOnly v0.02;
DateTime::TimeZone::UTC v0.01;
DBD::Pg v2.8.2;
DBI v1.605;
DBIx::SearchBuilder v1.53;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.1901;
Devel::StackTraceFrame v1.1901;
Digest::base v1.00;
Digest::MD5 v2.36_01;
DynaLoader v1.08;
Email::Address v1.889;
Encode v2.23;
Encode::Alias v2.07;
Encode::Config v2.04;
Encode::Encoding v2.05;
Errno v1.1;
Exception::Class v1.24;
Exception::Class::Base v1.2;
Exporter v5.62;
Exporter::Heavy v5.62;
Fcntl v1.06;
File::Basename v2.76;
File::Glob v1.06;
File::Path v2.04;
File::ShareDir v0.05;
File::Spec v3.2701;
File::Spec::Unix v3.2701;
File::Temp v0.18;
FileHandle v2.01;
GD v2.39;
GD::Graph v1.44;
GD::Graph::colour v1.10;
GD::Graph::Data v1.22;
GD::Graph::Error v1.8;
GD::Graph::pie v1.21;
GD::Graph::utils v1.7;
GD::Image v2.27;
GD::Text v0.86;
GD::Text::Align v1.18;
GraphViz v2.03;
HTML::Element v3.23;
HTML::Entities v1.35;
HTML::Formatter v2.04;
HTML::FormatText v2.04;
HTML::Mason v1.36;
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.56;
HTML::Scrubber v0.08;
HTML::Tagset v3.20;
HTML::TreeBuilder v3.23;
I18N::LangTags v0.35;
integer v1.00;
IO v1.23_01;
IO::File v1.14;
IO::Handle v1.27;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.1;
IO::WrapTie v2.110;
IPC::Open2 v1.02;
IPC::Open3 v1.02;
IPC::Run v0.80;
List::Util v1.19;
Locale::Maketext v1.12;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.66;
Locale::Maketext::Lexicon::Gettext v0.16;
Log::Dispatch v2.18;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v2.03;
Mail::Field v2.03;
Mail::Field::AddrList v2.03;
Mail::Field::Date v2.03;
Mail::Field::Generic v2.03;
Mail::Header v2.03;
Mail::Internet v2.03;
Mail::Mailer v2.03;
Mail::Util v2.03;
MIME::Base64 v3.07_01;
MIME::Body v5.426;
MIME::Decoder v5.426;
MIME::Entity v5.426;
MIME::Field::ContDisp v5.426;
MIME::Field::ConTraEnc v5.426;
MIME::Field::ContType v5.426;
MIME::Field::ParamVal v5.426;
MIME::Head v5.426;
MIME::Parser v5.426;
MIME::QuotedPrint v3.07;
MIME::Tools v5.426;
MIME::Words v5.426;
Module::Versions::Report v1.05;
overload v1.06;
Params::Util v0.30;
Params::Validate v0.91;
POSIX v1.13;
re v0.08;
Regexp::Common v2.122;
Regexp::Common::delimited v2.106;
RT v3.8.1;
RT::Extension::Timeline v0.03;
RT::Interface::Email v2;
RT::Interface::Web::Request v0.30;
RTx::Calendar v0.06;
RTx::EmailCompletion v0.05;
Scalar::Util v1.19;
SelectSaver v1.01;
Set::Infinite v0.61;
Socket v1.80;
Storable v2.18;
strict v1.04;
Symbol v1.06;
Sys::Syslog v0.22;
Text::Template v1.44;
Text::Wrapper v1.02;
Tie::Hash v1.02;
Time::HiRes v1.9711;
Time::JulianDay v2003.1125;
Time::Local v1.18;
Time::ParseDate v2006.0814;
Time::Timezone v2006.0814;
Time::Zone v2.22;
UNIVERSAL v1.04;
UNIVERSAL::require v0.11;
URI v1.35;
URI::Escape v3.28;
utf8 v1.07;
vars v1.01;
version v0.74;
Want v0.18;
warnings v1.06;
warnings::register v1.01;
XSLoader v0.08;

RT Config
ActiveStatus new, open, stalled
Active_MakeClicky
AmbiguousDayInFuture 0
AmbiguousDayInPast 0
AutoLogoff 0
CanonicalizeOnCreate 0
CanonicalizeRedirectURLs 0
CommentAddress rt-comment@ftth-sfr.net
CorrespondAddress rt@ftth-sfr.net
CustomFieldValuesSources
DashboardAddress
DashboardSubject %s Dashboard: %s
DatabaseHost localhost
DatabaseName rt3
DatabasePassword Password not printed
DatabasePort
DatabaseRTHost localhost
DatabaseType Pg
DatabaseUser rt_user
DateDayBeforeMonth 1
DateTimeFormat DefaultFormat
DefaultSearchResultFormat ‘id/TITLE:#’,
‘Subject/TITLE:Subject’,
Status, QueueName, OwnerName, Priority, ‘NEWLINE’, ‘’,
‘Requestors’, ‘CreatedRelative’,
‘ToldRelative’,
‘LastUpdatedRelative’, ‘TimeLeft’
DefaultSummaryRows 10
DevelMode 0
EmailCompletionUnprivileged everybody
EmailFrequency Individual messages
EmailInputEncodings utf-8, iso-8859-1, us-ascii
EmailOutputEncoding utf-8
EnableReminders 1
ExtractSubjectTagMatch Regexp
ExtractSubjectTagNoMatch Regexp
ForwardFromUser 0
FriendlyFromLineFormat “%s via RT” <%s>
FriendlyToLineFormat “%s of rt.ftth-sfr.net Ticket #%s”:;
GnuPG Enable, 0, AllowEncryptDataInDB, 0, OutgoingMessagesFormat, RFC
GnuPGOptions homedir, /var/cache/request-tracker3.8/data/gpg
HomepageComponents QuickCreate, Quicksearch, MyAdminQueues,
MySupportQueues, MyReminders, RefreshHomepage, Dashboards
InactiveStatus resolved, rejected, deleted
LexiconLanguages *
LinkTransactionsRun1Scrip 0
LogDir /var/log/request-tracker3.8
LogStackTraces
LogToFileNamed rt.log
LogToScreen info
LogToSyslog info
LogToSyslogConf
LogoURL /rt/NoAuth/images/sfr.jpg
LoopsToRTOwner 1
MailCommand sendmailpipe
MailParams
MasonParameters
MaxAttachmentSize 10000000
MaxInlineBody 12000
MessageBoxHeight 15
MessageBoxRichText 1
MessageBoxWidth 72
MessageBoxWrap HARD
MinimumPasswordLength 5
NetServerOptions
NotifyActor 0
OldestTransactionsFirst 1
Organization ftth-sfr.net
OwnerEmail root
PlainTextPre 0
Plugins RTx::Calendar, RTx::EmailCompletion, RT::Extension::Timeline
PreviewScripMessages 0
RTAddressRegexp ^rt@example.com$
RecordOutgoingEmail 1
RedistributeAutoGeneratedMessages privileged
SMTPDebug 0
SelfServiceRegex Regexp
SendmailArguments -oi -t
SendmailBounceArguments -f “<>”
SendmailPath /usr/sbin/sendmail
ShowBccHeader 0
ShowTransactionImages 1
ShowUnreadMessageNotifications 1
StandaloneMaxServers 1
StandaloneMaxSpareServers 0
StandaloneMinServers 1
StandaloneMinSpareServers 0
StrictLinkACL 1
Timezone CET
UseFriendlyFromLine 1
UseFriendlyToLine 0
UseTransactionBatch 0
UsernameFormat concise
WebBaseURL http://rt.ftth-sfr.net
WebDefaultStylesheet web2
WebDomain localhost
WebFlushDbCacheEveryRequest 1
WebImagesURL /rt/NoAuth/images/
WebNoAuthRegex Regexp
WebPath /rt
WebPort 80
WebSecureCookies 0
WebURL http://rt.ftth-sfr.net/rt/
WikiImplicitLinks 0
rtname rt.ftth-sfr.net
RT Variables
RT::BasePath /usr/share/request-tracker3.8
RT::BinPath /usr/bin
RT::EtcPath /etc/request-tracker3.8
RT::LocalEtcPath /usr/local/share/request-tracker3.8/etc
RT::LocalLexiconPath /usr/local/share/request-tracker3.8/po
RT::LocalLibPath /usr/local/share/request-tracker3.8/lib
RT::LocalPath /usr/local/share/request-tracker3.8
RT::LocalPluginPath /usr/local/share/request-tracker3.8/plugins
RT::MasonComponentRoot /usr/share/request-tracker3.8/html
RT::MasonDataDir /var/cache/request-tracker3.8/mason_data
RT::MasonLocalComponentRoot /usr/local/share/request-tracker3.8/html
RT::MasonSessionDir /var/cache/request-tracker3.8/session_data
RT::SbinPath /usr/sbin
RT::VERSION 3.8.1
RT::VarPath /var/cache/request-tracker3.8
Perl configuration

Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
Platform:
osname=linux, osvers=2.6.24-16-server,
archname=x86_64-linux-gnu-thread-multi
uname=‘linux yellow 2.6.24-16-server #1 smp thu apr 10 13:15:38 utc
2008 x86_64 gnulinux ’
config_args=’-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
-Dcccdlflags=-fPIC -Darchname=x86_64-linux-gnu -Dprefix=/usr
-Dprivlib=/usr/share/perl/5.10 -Darchlib=/usr/lib/perl/5.10
-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5
-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local
-Dsitelib=/usr/local/share/perl/5.10.0
-Dsitearch=/usr/local/lib/perl/5.10.0 -Dman1dir=/usr/share/man/man1
-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1
-Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl
-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm
-DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib
-Dlibperl=libperl.so.5.10.0 -Dd_dosuid -des’
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=define, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc=‘cc’, ccflags =‘-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64’,
optimize=‘-O2 -g’,
cppflags=‘-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing
-pipe -I/usr/local/include’
ccversion=‘’, gccversion=‘4.3.2’, gccosandvers=‘’
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype=‘long’, ivsize=8, nvtype=‘double’, nvsize=8, Off_t=‘off_t’,
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld=‘cc’, ldflags =’ -L/usr/local/lib’
libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.8.90.so, so=so, useshrplib=true,
libperl=libperl.so.5.10.0
gnulibc_version=‘2.8.90’
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=‘-Wl,-E’
cccdlflags=‘-fPIC’, lddlflags=‘-shared -O2 -g -L/usr/local/lib’

Perl Include Paths (@INC)

/usr/local/share/request-tracker3.8/lib
/usr/share/request-tracker3.8/lib
/etc/perl
/usr/local/lib/perl/5.10.0
/usr/local/share/perl/5.10.0
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.10
/usr/share/perl/5.10
/usr/local/lib/site_perl
.

Julien Tayon // digital craftsman // making things simpler (when possible)

Truth will out this morning. (Which may really mess things up.)

Julien Tayon // digital craftsman // making things simpler (when possible)

Martin was probably ripping them off. That’s some family, isn’t it?
Incest, prostitution, fanaticism, software.
– Charles Willeford, “Miami Blues”

Ruslan_Zakirov · March 12, 2009, 12:05pm

http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=18373On Thu, Mar 12, 2009 at 3:43 AM, jul jul-rt@julbox.net wrote:

Hello everyone,

New to the list, (should lurk before post, I know)

after having installed rt3.8 from
deb http://debian.etc.gen.nz etch rt
with a postgresql 8.3
with a rt 3.8 version I have when trying to graph data based on time the
following error in my log

Mar 11 18:29:03 XXXXXXX RT: RT::Handle=HASH(0x3204970) couldn’t execute
the query ‘SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS
lastupdateddaily FROM Tickets main WHERE (main.Status != ‘deleted’) AND
(main.id > ‘0’) AND (main.Type = ‘ticket’) AND (main.EffectiveId =
main.id) GROUP BY SUBSTR(LastUpdated,1,10) ’ at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
^IDBIx::SearchBuilder::Handle::SimpleQuery(‘RT::Handle=HASH(0x3204970)’,
‘SELECT COUNT(main.id) AS id, SUBSTR(LastUpdated,1,10) AS last…’) called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 238
^IDBIx::SearchBuilder::_DoSearch(‘RT::Report::Tickets=HASH(0x5811660)’)
called at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 164
^IRT::Report::_DoSearch(‘RT::Report::Tickets=HASH(0x5811660)’)
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 498
^IDBIx::SearchBuilder::Next(‘RT::Report::Tickets=HASH(0x5811660)’) called
at /usr/share/request-tracker3.8/lib/RT/Report/Tickets.pm line 228
^IRT::Report::Next(’

So I opened pgsql to find that

SELECT count(main.id) AS id, substr( CAST ( LastUpdated AS TEXT ) , 1 ,10
) AS lastupdateddaily FROM Tickets main WHERE (main.Status != ‘deleted’)
AND (main.id > ‘0’) AND (main.Type = ‘ticket’) AND (main.EffectiveId =
main.id) GROUP BY substr( CAST ( LastUpdated AS TEXT ) , 1 ,10 )

Worked better.

Is this an old bug or a current one ? How can I patch my rt so that the
cast is included ?

Here come sys config from RT page :

Perl v5.10.0 under linux
Apache::Session v1.86;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Null v1.01;
Apache::Session::Postgres v1.01;
Apache::Session::Serialize::Base64 v1.01;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::Postgres v1.03;
AutoLoader v5.63;
base v2.13;
bytes v1.03;
Cache::Simple::TimedExpiry v0.27;
Carp v1.08;
CGI v3.29;
CGI::Cookie v1.28;
CGI::Util v1.5_01;
Class::Container v0.12;
Class::Data::Inheritable v0.08;
Class::Inspector v1.23;
Class::ReturnValue v0.55;
Clone v0.28;
constant v1.13;
Cwd v3.2701;
Data::Dumper v2.121_14;
Date::Format v2.22;
Date::Parse v2.27;
DateTime v0.42;
DateTime::Locale v0.35;
DateTime::Set v0.25;
DateTime::TimeZone v0.7701;
DateTime::TimeZone::Floating v0.01;
DateTime::TimeZone::Local v0.01;
DateTime::TimeZone::OffsetOnly v0.02;
DateTime::TimeZone::UTC v0.01;
DBD::Pg v2.8.2;
DBI v1.605;
DBIx::SearchBuilder v1.53;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.1901;
Devel::StackTraceFrame v1.1901;
Digest::base v1.00;
Digest::MD5 v2.36_01;
DynaLoader v1.08;
Email::Address v1.889;
Encode v2.23;
Encode::Alias v2.07;
Encode::Config v2.04;
Encode::Encoding v2.05;
Errno v1.1;
Exception::Class v1.24;
Exception::Class::Base v1.2;
Exporter v5.62;
Exporter::Heavy v5.62;
Fcntl v1.06;
File::Basename v2.76;
File::Glob v1.06;
File::Path v2.04;
File::ShareDir v0.05;
File::Spec v3.2701;
File::Spec::Unix v3.2701;
File::Temp v0.18;
FileHandle v2.01;
GD v2.39;
GD::Graph v1.44;
GD::Graph::colour v1.10;
GD::Graph::Data v1.22;
GD::Graph::Error v1.8;
GD::Graph::pie v1.21;
GD::Graph::utils v1.7;
GD::Image v2.27;
GD::Text v0.86;
GD::Text::Align v1.18;
GraphViz v2.03;
HTML::Element v3.23;
HTML::Entities v1.35;
HTML::Formatter v2.04;
HTML::FormatText v2.04;
HTML::Mason v1.36;
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.56;
HTML::Scrubber v0.08;
HTML::Tagset v3.20;
HTML::TreeBuilder v3.23;
I18N::LangTags v0.35;
integer v1.00;
IO v1.23_01;
IO::File v1.14;
IO::Handle v1.27;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.1;
IO::WrapTie v2.110;
IPC::Open2 v1.02;
IPC::Open3 v1.02;
IPC::Run v0.80;
List::Util v1.19;
Locale::Maketext v1.12;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.66;
Locale::Maketext::Lexicon::Gettext v0.16;
Log::Dispatch v2.18;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v2.03;
Mail::Field v2.03;
Mail::Field::AddrList v2.03;
Mail::Field::Date v2.03;
Mail::Field::Generic v2.03;
Mail::Header v2.03;
Mail::Internet v2.03;
Mail::Mailer v2.03;
Mail::Util v2.03;
MIME::Base64 v3.07_01;
MIME::Body v5.426;
MIME::Decoder v5.426;
MIME::Entity v5.426;
MIME::Field::ContDisp v5.426;
MIME::Field::ConTraEnc v5.426;
MIME::Field::ContType v5.426;
MIME::Field::ParamVal v5.426;
MIME::Head v5.426;
MIME::Parser v5.426;
MIME::QuotedPrint v3.07;
MIME::Tools v5.426;
MIME::Words v5.426;
Module::Versions::Report v1.05;
overload v1.06;
Params::Util v0.30;
Params::Validate v0.91;
POSIX v1.13;
re v0.08;
Regexp::Common v2.122;
Regexp::Common::delimited v2.106;
RT v3.8.1;
RT::Extension::Timeline v0.03;
RT::Interface::Email v2;
RT::Interface::Web::Request v0.30;
RTx::Calendar v0.06;
RTx::EmailCompletion v0.05;
Scalar::Util v1.19;
SelectSaver v1.01;
Set::Infinite v0.61;
Socket v1.80;
Storable v2.18;
strict v1.04;
Symbol v1.06;
Sys::Syslog v0.22;
Text::Template v1.44;
Text::Wrapper v1.02;
Tie::Hash v1.02;
Time::HiRes v1.9711;
Time::JulianDay v2003.1125;
Time::Local v1.18;
Time::ParseDate v2006.0814;
Time::Timezone v2006.0814;
Time::Zone v2.22;
UNIVERSAL v1.04;
UNIVERSAL::require v0.11;
URI v1.35;
URI::Escape v3.28;
utf8 v1.07;
vars v1.01;
version v0.74;
Want v0.18;
warnings v1.06;
warnings::register v1.01;
XSLoader v0.08;

RT Config
ActiveStatus new, open, stalled
Active_MakeClicky
AmbiguousDayInFuture 0
AmbiguousDayInPast 0
AutoLogoff 0
CanonicalizeOnCreate 0
CanonicalizeRedirectURLs 0
CommentAddress rt-comment@ftth-sfr.net
CorrespondAddress rt@ftth-sfr.net
CustomFieldValuesSources
DashboardAddress
DashboardSubject %s Dashboard: %s
DatabaseHost localhost
DatabaseName rt3
DatabasePassword Password not printed
DatabasePort
DatabaseRTHost localhost
DatabaseType Pg
DatabaseUser rt_user
DateDayBeforeMonth 1
DateTimeFormat DefaultFormat
DefaultSearchResultFormat ‘id/TITLE:#’,
‘Subject/TITLE:Subject’,
Status, QueueName, OwnerName, Priority, ‘NEWLINE’, ‘’,
‘Requestors’, ‘CreatedRelative’,
‘ToldRelative’,
‘LastUpdatedRelative’, ‘TimeLeft’
DefaultSummaryRows 10
DevelMode 0
EmailCompletionUnprivileged everybody
EmailFrequency Individual messages
EmailInputEncodings utf-8, iso-8859-1, us-ascii
EmailOutputEncoding utf-8
EnableReminders 1
ExtractSubjectTagMatch Regexp
ExtractSubjectTagNoMatch Regexp
ForwardFromUser 0
FriendlyFromLineFormat “%s via RT” <%s>
FriendlyToLineFormat “%s of rt.ftth-sfr.net Ticket #%s”:;
GnuPG Enable, 0, AllowEncryptDataInDB, 0, OutgoingMessagesFormat, RFC
GnuPGOptions homedir, /var/cache/request-tracker3.8/data/gpg
HomepageComponents QuickCreate, Quicksearch, MyAdminQueues,
MySupportQueues, MyReminders, RefreshHomepage, Dashboards
InactiveStatus resolved, rejected, deleted
LexiconLanguages *
LinkTransactionsRun1Scrip 0
LogDir /var/log/request-tracker3.8
LogStackTraces
LogToFileNamed rt.log
LogToScreen info
LogToSyslog info
LogToSyslogConf
LogoURL /rt/NoAuth/images/sfr.jpg
LoopsToRTOwner 1
MailCommand sendmailpipe
MailParams
MasonParameters
MaxAttachmentSize 10000000
MaxInlineBody 12000
MessageBoxHeight 15
MessageBoxRichText 1
MessageBoxWidth 72
MessageBoxWrap HARD
MinimumPasswordLength 5
NetServerOptions
NotifyActor 0
OldestTransactionsFirst 1
Organization ftth-sfr.net
OwnerEmail root
PlainTextPre 0
Plugins RTx::Calendar, RTx::EmailCompletion, RT::Extension::Timeline
PreviewScripMessages 0
RTAddressRegexp ^rt@example.com$
RecordOutgoingEmail 1
RedistributeAutoGeneratedMessages privileged
SMTPDebug 0
SelfServiceRegex Regexp
SendmailArguments -oi -t
SendmailBounceArguments -f “<>”
SendmailPath /usr/sbin/sendmail
ShowBccHeader 0
ShowTransactionImages 1
ShowUnreadMessageNotifications 1
StandaloneMaxServers 1
StandaloneMaxSpareServers 0
StandaloneMinServers 1
StandaloneMinSpareServers 0
StrictLinkACL 1
Timezone CET
UseFriendlyFromLine 1
UseFriendlyToLine 0
UseTransactionBatch 0
UsernameFormat concise
WebBaseURL http://rt.ftth-sfr.net
WebDefaultStylesheet web2
WebDomain localhost
WebFlushDbCacheEveryRequest 1
WebImagesURL /rt/NoAuth/images/
WebNoAuthRegex Regexp
WebPath /rt
WebPort 80
WebSecureCookies 0
WebURL http://rt.ftth-sfr.net/rt/
WikiImplicitLinks 0
rtname rt.ftth-sfr.net
RT Variables
RT::BasePath /usr/share/request-tracker3.8
RT::BinPath /usr/bin
RT::EtcPath /etc/request-tracker3.8
RT::LocalEtcPath /usr/local/share/request-tracker3.8/etc
RT::LocalLexiconPath /usr/local/share/request-tracker3.8/po
RT::LocalLibPath /usr/local/share/request-tracker3.8/lib
RT::LocalPath /usr/local/share/request-tracker3.8
RT::LocalPluginPath /usr/local/share/request-tracker3.8/plugins
RT::MasonComponentRoot /usr/share/request-tracker3.8/html
RT::MasonDataDir /var/cache/request-tracker3.8/mason_data
RT::MasonLocalComponentRoot /usr/local/share/request-tracker3.8/html
RT::MasonSessionDir /var/cache/request-tracker3.8/session_data
RT::SbinPath /usr/sbin
RT::VERSION 3.8.1
RT::VarPath /var/cache/request-tracker3.8
Perl configuration

Summary of my perl5 (revision 5 version 10 subversion 0) configuration:
Platform:
osname=linux, osvers=2.6.24-16-server,
archname=x86_64-linux-gnu-thread-multi
uname=‘linux yellow 2.6.24-16-server #1 smp thu apr 10 13:15:38 utc
2008 x86_64 gnulinux ’
config_args=’-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN
-Dcccdlflags=-fPIC -Darchname=x86_64-linux-gnu -Dprefix=/usr
-Dprivlib=/usr/share/perl/5.10 -Darchlib=/usr/lib/perl/5.10
-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5
-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local
-Dsitelib=/usr/local/share/perl/5.10.0
-Dsitearch=/usr/local/lib/perl/5.10.0 -Dman1dir=/usr/share/man/man1
-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1
-Dsiteman3dir=/usr/local/man/man3 -Dman1ext=1 -Dman3ext=3perl
-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm
-DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib
-Dlibperl=libperl.so.5.10.0 -Dd_dosuid -des’
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=define, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc=‘cc’, ccflags =‘-D_REENTRANT -D_GNU_SOURCE -DDEBIAN
-fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64’,
optimize=‘-O2 -g’,
cppflags=‘-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fno-strict-aliasing
-pipe -I/usr/local/include’
ccversion=‘’, gccversion=‘4.3.2’, gccosandvers=‘’
intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
ivtype=‘long’, ivsize=8, nvtype=‘double’, nvsize=8, Off_t=‘off_t’,
lseeksize=8
alignbytes=8, prototype=define
Linker and Libraries:
ld=‘cc’, ldflags =’ -L/usr/local/lib’
libpth=/usr/local/lib /lib /usr/lib /lib64 /usr/lib64
libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt
perllibs=-ldl -lm -lpthread -lc -lcrypt
libc=/lib/libc-2.8.90.so, so=so, useshrplib=true,
libperl=libperl.so.5.10.0
gnulibc_version=‘2.8.90’
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=‘-Wl,-E’
cccdlflags=‘-fPIC’, lddlflags=‘-shared -O2 -g -L/usr/local/lib’

Perl Include Paths (@INC)

/usr/local/share/request-tracker3.8/lib
/usr/share/request-tracker3.8/lib
/etc/perl
/usr/local/lib/perl/5.10.0
/usr/local/share/perl/5.10.0
/usr/lib/perl5
/usr/share/perl5
/usr/lib/perl/5.10
/usr/share/perl/5.10
/usr/local/lib/site_perl
.

–
Julien Tayon // digital craftsman // making things simpler (when possible)

Truth will out this morning. (Which may really mess things up.)

–
Julien Tayon // digital craftsman // making things simpler (when possible)

Martin was probably ripping them off. That’s some family, isn’t it?
Incest, prostitution, fanaticism, software.
– Charles Willeford, “Miami Blues”

List info: The rt-devel Archives

Best regards, Ruslan.

shaker_Khzym · March 13, 2009, 5:05pm

Dear All,
Is there a chat room to the Group.
I try to install RT on Debian Etch , but the installation steps is not enough to me , now I installed but no color in the login page.
I am going to follow fastcgi steps. but If any one has a document for Debian Etch , please email me with it.
Best wishes,
Shaekir,

Experience all of the new features, and Reconnect with your life.

Mike_Peachey · March 16, 2009, 9:27am

shaker Khzym wrote:

Dear All,

Firstly, this is not an RT Development issue, it is a use issue, hence
you should use RT-Users@lists.bestpractical.com not RT-Devel.

Is there a chat room to the Group.

Please read through the wiki for guidance. It will refer you to the RT
IRC channel. I’m not going to tell you where it is so that you /do/go
and read the wiki
http://wiki.bestpractical.com

I try to install RT on Debian Etch , but the installation steps is
not enough to me , now I installed but no color in the login page.
I am going to follow fastcgi steps. but If any one has a document for
Debian Etch , please email me with it.

You won’t get e-mailed such a document as it has already been documented
on the wiki and there is a lot of information in the RT-Users list archives.

I recommend following the “Manual Install” procedure.

Kind Regards,

Mike Peachey, IT
Tel: +44 114 281 2655
Fax: +44 114 281 2951
Jennic Ltd, Furnival Street, Sheffield, S1 4QT, UK
Comp Reg No: 3191371 - Registered In England

Chris_Adams · March 26, 2009, 6:38pm

http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=18373

I just noticed a very similar problem when someone did a search for
User.id = ‘CurrentUser’, which failed after turning into
LOWER(User.id) in the actual query. Is there a systematic way to get
the Postgres backend to check types or is the answer something more
like “Use MySQL because it’s more tested”?

Chris

Ruslan_Zakirov · March 26, 2009, 8:21pm

Nope, that means “help write tests for this features, luckily there
are plenty of examples in 3.8, so we can catch such problems during
automated testing we run on Pg/MySQL/SQLite and occasionally on
Oracle”.On Thu, Mar 26, 2009 at 9:38 PM, Chris Adams chris@improbable.org wrote:

On Thu, Mar 12, 2009 at 8:05 AM, Ruslan Zakirov ruslan.zakirov@gmail.com wrote:

http://svn.bestpractical.com/cgi-bin/index.cgi/bps/revision/?rev=18373

I just noticed a very similar problem when someone did a search for
User.id = ‘CurrentUser’, which failed after turning into
LOWER(User.id) in the actual query. Is there a systematic way to get
the Postgres backend to check types or is the answer something more
like “Use MySQL because it’s more tested”?

Chris

List info: The rt-devel Archives

Best regards, Ruslan.

Chris_Adams · March 26, 2009, 11:21pm

Nope, that means “help write tests for this features, luckily there
are plenty of examples in 3.8, so we can catch such problems during
automated testing we run on Pg/MySQL/SQLite and occasionally on
Oracle”.

Okay, so where should I start with something like that? Is there some
way to modify the User class so the SQL builder will always generic
integer references for id fields rather than playing whack-a-mole
hunting down every place which generates queries?

Chris

smime.p7s (2.37 KB)

Ruslan_Zakirov · March 27, 2009, 12:07am

I suspect that you’re not familiar with RT’s internals. The easiest
way for you to start is to clone some t/ticket/search_by*.t and adjust
it to reproduce your problem.2009/3/27 Chris Adams chris@improbable.org:

On Mar 26, 2009, at 4:21 PM, Ruslan Zakirov wrote:

Nope, that means “help write tests for this features, luckily there
are plenty of examples in 3.8, so we can catch such problems during
automated testing we run on Pg/MySQL/SQLite and occasionally on
Oracle”.

Okay, so where should I start with something like that? Is there some way to
modify the User class so the SQL builder will always generic integer
references for id fields rather than playing whack-a-mole hunting down every
place which generates queries?

Chris

List info: The rt-devel Archives

Best regards, Ruslan.