[rt-users] Oracle installation help needed

[Maciak, TJ]

This is what I get when I do DBI_TRACE=1
Seems like the DB connection info is valid as its creating the tables etc.

--- start script

First part creates all tables, sequences etc. successfully
.
.
.
Done setting up database schema.
Now inserting database ACLs
Now inserting RT core system objects
DEBUG: Handle.pm using Oracle
DEBUG: Handle.pm DB connect 1of3
DEBUG: Connect to Oracle DB USER:rt PW:xxx
    -> DBI->connect(DBI:Oracle:host=rabbit; sid=devl, rt, ****)
connect using
'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(HOST=rabbit)(PROTOCOL=tcp)(PORT=1526))
(ADDRESS=(HOST=rabbit)(PROTOCOL=tcp)(P
ORT=1521)))(CONNECT_DATA=(SID=devl)))'    <- connect('host=rabbit; sid=devl'
'rt' ...)= DBI::db=HASH(0xa4cd470) at DBI.pm line 5
99
    <- STORE('PrintError' 1)= 1 at DBI.pm line 646
    <- STORE('AutoCommit' 1)= 1 at DBI.pm line 646
    <- STORE('Username' 'rt')= 1 at DBI.pm line 649
    <> FETCH('Username')= 'rt' ('Username' from cache) at DBI.pm line 649
    <- connect= DBI::db=HASH(0xa4cd470)
    <- STORE('dbi_connect_closure' CODE(0xac7a438))= 1 at DBI.pm line 669
DEBUG: Handle.pm DB connect 2of3
    <- STORE('LongReadLen' 10000000)= 1 at Handle.pm line 121
DEBUG: Handle.pm DB connect 3of3
    <- DESTROY(DBI::db=HASH(a4cd470))= undef at rt-setup-database line 415
Checking for existing system user...DISABLED
Before Create System User
Creating system user...
DEBUG: [//opt/rt3/sbin/rt-setup-database 444] New RT User
DEBUG: User_Overlay.pm - Start _BootstrapCreate
DEBUG: /opt/rt3/lib/RT/User_Overlay.pm 484 Before BeginTransaction
DEBUG: [/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 674]
Start BeginTransaction
DEBUG: [/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 678]
TRANSDEPTH = 1
DEBUG: [/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 685]
BeginTransaction - return self->dbh->begin_work
DEBUG: [/opt/rt3/lib/RT.pm 287] We DIED - Rollback!
Can't call method "rollback" on an undefined value at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 742.
    <- disconnect_all= (not implemented) at DBI.pm line 678
!   <- DESTROY(DBI::db=HASH(a4de1a8))= undef during global destruction
!   <- DESTROY(DBI::dr=HASH(a1814ec))= undef during global destruction
make: *** [initialize-database] Error 2


T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448



-----Original Message-----
From: Stephen Turner [mailto:sturner at MIT.EDU] 
Sent: Thursday, June 09, 2005 9:53 AM
To: Maciak, TJ; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Oracle installation help needed


At Thursday 6/9/2005 08:42 AM, Maciak, TJ wrote:
>Hello,
>Can't call method "rollback" on an undefined value at 
>/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 742.
>make: *** [initialize-database] Error 2
>

I'm guessing that the database handle is null because the connect failed. 
Are you sure that the connect is using a valid username/password?

Steve 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050609/1845bf50/attachment.htm>