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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com