Can you try with older DBD::Oracle module? 1.22 or older? On Mon, Jun 22, 2009 at 8:23 PM, Eric Coleman<[email protected]> wrote: > I’m having difficulties installing RT version 3.8.4 utilizing an Oracle > backend and would appreciate assistance/guidance through this issue. > > > > When the RT build process (make initialize-database) reaches the create > schema step I’m receiving an Oracle 4043 error when the Users tables is > populated. The schema objects (tables, indexes and sequences) are being > generated successfully so I’m confident that DBI is making the connection to > the Oracle DB. I’ve verified that the Users table exists and via the > rt_user user as well as via the system (via alter session similar to the > build process) account, both of which are able to successfully access this > table. > > > > I’ve also tried using the following command with the same results: > > TWO_TASK=TIME perl sbin/rt-setup-database --dba=system > --dba-password=<password> --action coredata > > > > Versions: > > RT Version – 3.8.4 > > Perl Version - v5.8.5 built for i386-linux-thread-multi > > Oracle – 10.2.0.4 – Enterprise Edition > > OS - Linux app02.server.com 2.6.9-67.0.0.0.1.ELsmp #1 SMP Sun Nov 18 > 00:23:42 EST 2007 i686 i686 i386 GNU/Linux > > > > Exact Error: > > # TWO_TASK=TIME perl sbin/rt-setup-database --dba=rt_user > --dba-password=xxxxxxx --action coredata > > Working with: > > Type: Oracle > > Host: db01.server.com > > Name: TIME > > User: RT_USER > > DBA: rt_user > > Now inserting RT core system objects > > [Fri Jun 19 17:59:49 2009] [warning]: DBD::Oracle::st execute failed: > ORA-04043: object Users does not exist (DBD ERROR: Can't match some > parameters to LOB fields in the table, check type and name) [for Statement > "INSERT INTO Users (Comments, RealName, Creator, Password, LastUpdatedBy, > Created, id, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)" with > ParamValues: :p1='Do not delete or modify this user. It is integral to RTs > internal database structures', :p2='The RT System itself', :p3='1', > :p4='*NO-PASSWORD*', :p5='1', :p6='2009-06-19 17:59:49', :p7='7', > :p8='RT_System', :p9='2009-06-19 17:59:49'] at > /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 509. > (/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm:509) > > [Fri Jun 19 17:59:49 2009] [warning]: RT::Handle=HASH(0xb059c78) couldn't > execute the query 'INSERT INTO Users (Comments, RealName, Creator, Password, > LastUpdatedBy, Created, id, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, > ?, ?)' at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line > 522 > > > DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb059c78)', > 'INSERT INTO Users (Comments, RealName, Creator, Password, Las...', > 'HASH(0xb16772c)', 'The RT System itself', 1, '*NO-PASSWORD*', 1, > '2009-06-19 17:59:49', 7, ...) called at > /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 357 > > DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xb059c78)', > 'Users', 'Comments', 'HASH(0xb16772c)', 'RealName', 'The RT System itself', > 'Creator', 1, 'Password', ...) called at > /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line 105 > > > DBIx::SearchBuilder::Handle::Oracle::Insert('RT::Handle=HASH(0xb059c78)', > 'Users', 'Comments', 'HASH(0xb16772c)', 'RealName', 'The RT System itself', > 'Creator', 1, 'Password', ...) called at > /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Record.pm line 1293 > > DBIx::SearchBuilder::Record::Create('RT::User=HASH(0xb138bb8)', > 'Comments', 'Do not delete or modify this user. It is integral to RTs > inte...', 'RealName', 'The RT System itself', 'Creator', 1, 'Password', > '*NO-PASSWORD*', ...) called at > /stage/resource_tracker/rt-3.8.4/sbin/../lib/RT/Record.pm line 289 > > RT::Record::Create('RT::User=HASH(0xb138bb8)', 'id', 7, 'Comments', > 'Do not delete or modify this user. It is integral to RTs inte...', > 'Password', '*NO-PASSWORD*', 'LastUpdatedBy', 1, ...) called at > /stage/resource_tracker/rt-3.8.4/sbin/../lib/RT/User_Overlay.pm line 388 > > RT::User::_BootstrapCreate('RT::User=HASH(0xb138bb8)', 'Name', > 'RT_System', 'RealName', 'The RT System itself', 'Comments', 'Do not delete > or modify this user. It is integral to RTs inte...', 'Creator', 1, ...) > called at /stage/resource_tracker/rt-3.8.4/sbin/../lib/RT/Handle.pm line 593 > > RT::Handle::InsertInitialData('RT::Handle=HASH(0xb059c78)') called > at sbin/rt-setup-database line 230 > > main::action_coredata('action', 'coredata', 'dba-password', > '<password>', 'dba', 'rt_user') called at sbin/rt-setup-database line 166 > (/usr/lib/perl5/5.8.5/Carp.pm:204) > > Couldn't finish 'coredata' step. > > > > ERROR: Could not create user > > > > Exact with DBI_TRACE=1 set: > > <- STORE('ShowErrorStatement', 1)= 1 at Oracle.pm line 70 > > <- install_driver= DBI::dr=HASH(0x972fa14) > > connect using > '(DESCRIPTION=(ADDRESS=(HOST=db01.re-questinc.com)(PROTOCOL=tcp)(PORT=1521))(CONNECT_DATA=(SID=T > > IME)))' <- connect('host=db01.re-questinc.com;sid=TIME;port=1521', > 'RT_USER', ...)= DBI::db=HASH(0xbaabb50) > > at DBI.pm line 653 > > <- STORE('PrintError', 1)= 1 at DBI.pm line 705 > > <- STORE('AutoCommit', 1)= 1 at DBI.pm line 705 > > <- STORE('Username', 'RT_USER')= 1 at DBI.pm line 708 > > <> FETCH('Username')= 'RT_USER' ('Username' from cache) at DBI.pm line > 708 > > <- connected('dbi:Oracle:host=db01.re-questinc.com;sid=TIME;port=1521', > 'RT_USER', ...)= undef at DBI.pm l > > ine 714 > > <- connect= DBI::db=HASH(0xbaabb50) > > <- STORE('dbi_connect_closure', CODE(0xbaa9c9c))= 1 at DBI.pm line 723 > > <- STORE('FetchHashKeyName', 'NAME_lc')= 1 at Handle.pm line 110 > > <- STORE('LongTruncOk', 1)= 1 at Oracle.pm line 48 > > <- STORE('LongReadLen', 8000)= 1 at Oracle.pm line 49 > > <- prepare('ALTER SESSION set NLS_DATE_FORMAT = 'YYYY-MM-DD > HH24:MI:SS'')= DBI::st=HASH(0x972f6b4) at Hand > > le.pm line 469 > > <- execute= '0E0' at Handle.pm line 509 > > <- DESTROY(DBI::st=HASH(baabc88))= undef at Oracle.pm line 51 > > <- STORE('LongReadLen', 10000000)= 1 at Handle.pm line 122 > > <- prepare('SELECT * FROM Users WHERE lower(Name) = ?')= > DBI::st=HASH(0xac8bd98) at Handle.pm line 469 > > <- execute('rt_system')= '0E0' at Handle.pm line 509 > > <- fetchrow_hashref= undef at Record.pm line 1213 > > <- err= undef at Record.pm line 1215 > > <- DESTROY(DBI::st=HASH(972f738))= undef at Record.pm line 1126 > > <- ping= 1 at Handle.pm line 827 > > <- ping= 1 at Handle.pm line 827 > > <- begin_work= 1 at Handle.pm line 724 > > <- prepare('SELECT Principals_seq.nextval FROM DUAL')= > DBI::st=HASH(0xbafc500) at Handle.pm line 469 > > <- execute= '0E0' at Handle.pm line 509 > > <- fetchrow_array= ( "4" ) [1 items] row1 at Oracle.pm line 94 > > <- prepare('INSERT INTO Principals (Disabled, PrincipalType, id, > ObjectId) VALUES (?, ?, ?, ?)')= DBI::st= > > HASH(0xbb0012c) at Handle.pm line 469 > > <- execute('0', 'User', ...)= 1 at Handle.pm line 509 > > <- DESTROY(DBI::st=HASH(bb0009c))= undef at Oracle.pm line 107 > > <- DESTROY(DBI::st=HASH(bbb700c))= undef at Record.pm line 1293 > > <- prepare('SELECT * FROM Principals WHERE id = ?')= > DBI::st=HASH(0xbbb6f34) at Handle.pm line 469 > > <- execute('4')= '0E0' at Handle.pm line 509 > > <- fetchrow_hashref= HASH(0xbbaa88c)4keys row1 at Record.pm line 1213 > > <- DESTROY(DBI::st=HASH(bbb7024))= undef at Record.pm line 1126 > > <- prepare('UPDATE Principals SET ObjectId=? WHERE id=? ')= > DBI::st=HASH(0xbbb7108) at Handle.pm line 469 > > <- execute('4', '4')= 1 at Handle.pm line 509 > > <- DESTROY(DBI::st=HASH(bbb7198))= undef at Cachable.pm line 139 > > <- prepare('INSERT INTO Users (Comments, RealName, Creator, Password, > LastUpdatedBy, Created, id, Name, La > > stUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)')= DBI::st=HASH(0xbbb7228) at > Handle.pm line 469 > > <- bind_param(1, undef, ...)= 1 at Handle.pm line 495 > > !! ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR: > Can't match some parameters to LOB fi > > elds in the table, check type and name)' (err#1) > > <- execute('Do not delete or modify this user. It is integral to RT's > internal database structures', 'The > > RT System itself', ...)= undef at Handle.pm line 509 > > ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR: > Can't match some parameters to LOB fi > > elds in the table, check type and name)' (err#0) > > <- errstr= 'ORA-04043: object Users does not exist (DBD ERROR: Can't > match some parameters to LOB fields i > > n the table, check type and name)' at Handle.pm line 525 > > ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR: > Can't match some parameters to LOB fi > > elds in the table, check type and name)' (err#1) > > <- DESTROY(DBI::st=HASH(bbaaac0))= undef at Handle.pm line 357 > > ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR: > Can't match some parameters to LOB fi > > elds in the table, check type and name)' (err#0) > > <- ping= 1 at Handle.pm line 827 > > ERROR: '4043' 'ORA-04043: object Users does not exist (DBD ERROR: > Can't match some parameters to LOB fi > > elds in the table, check type and name)' (err#0) > > <- ping= 1 at Handle.pm line 827 > > !! ERROR: '4043' CLEARED by call to rollback method > > <- rollback= 1 at Handle.pm line 769 > > > > Display for the gmake testdeps step: > > # gmake testdeps > > /usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-Oracle > --with-fastcgi > > perl: > > >=5.8.3(5.8.5)...found > > users: > > rt group (apache)...found > > bin owner (root)...found > > libs owner (root)...found > > libs group (bin)...found > > web owner (apache)...found > > web group (apache)...found > > CLI dependencies: > > Term::ReadKey...found > > Getopt::Long >= 2.24...found > > HTTP::Request::Common...found > > Term::ReadLine...found > > Text::ParseWords...found > > LWP...found > > CORE dependencies: > > Class::ReturnValue >= 0.40...found > > Text::Quoted >= 2.02...found > > CSS::Squish >= 0.06...found > > Encode >= 2.13...found > > Module::Versions::Report >= 1.05...found > > MIME::Entity >= 5.425...found > > DBI >= 1.37...found > > Locale::Maketext::Lexicon >= 0.32...found > > Devel::StackTrace >= 1.19...found > > Digest::base...found > > Time::ParseDate...found > > File::Temp >= 0.18...found > > Locale::Maketext >= 1.06...found > > Tree::Simple >= 1.04...found > > Text::Template >= 1.44...found > > Scalar::Util...found > > HTML::Scrubber >= 0.08...found > > File::Spec >= 0.8...found > > Calendar::Simple...found > > DBIx::SearchBuilder >= 1.54...found > > Sys::Syslog >= 0.16...found > > Mail::Mailer >= 1.57...found > > File::ShareDir...found > > Regexp::Common...found > > Digest::MD5 >= 2.27...found > > HTML::Entities...found > > Cache::Simple::TimedExpiry...found > > File::Glob...found > > Locale::Maketext::Fuzzy...found > > Time::HiRes...found > > Text::Wrapper...found > > Log::Dispatch >= 2.0...found > > UNIVERSAL::require...found > > Email::Address...found > > DASHBOARDS dependencies: > > HTML::RewriteAttributes >= 0.02...found > > MIME::Types...found > > FASTCGI dependencies: > > CGI::Fast...found > > CGI >= 3.38...found > > FCGI...found > > GPG dependencies: > > PerlIO::eol...found > > GnuPG::Interface...found > > ICAL dependencies: > > Data::ICal...found > > MAILGATE dependencies: > > Pod::Usage...found > > HTML::TreeBuilder...found > > Getopt::Long...found > > HTML::FormatText...found > > LWP::UserAgent...found > > MASON dependencies: > > Storable >= 2.08...found > > CSS::Squish >= 0.06...found > > Apache::Session >= 1.53...found > > Errno...found > > Devel::StackTrace >= 1.19...found > > CGI::Cookie >= 1.20...found > > Text::WikiFormat >= 0.76...found > > XML::RSS >= 1.05...found > > HTML::Mason >= 1.36...found > > Digest::MD5 >= 2.27...found > > ORACLE dependencies: > > DBD::Oracle...found > > SMTP dependencies: > > Net::SMTP...found > > STANDALONE dependencies: > > Net::Server::PreFork...found > > Net::Server...found > > HTTP::Server::Simple >= 0.34...found > > HTTP::Server::Simple::Mason >= 0.09...found > > > > _______________________________________________ > 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 >
-- Best regards, Ruslan. _______________________________________________ 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
