[rt-users] Oracle installation help needed

[Maciak, TJ]

Hello,
 
I was able to get RT working with MySQL v4.x quite easily but the
information on Oracle installs is scarce.
I am having major pains trying to get RT installed using Oracle as the
database.
 
I have added my own debugging statements to try to figure out what the
problem is and this is what I am getting:
 
Now creating a database for RT.
...skipped as rt is not rt or we're working with Oracle.
.
.
.
Before Create System User
Creating system user...
DEBUG: [//opt/rt3/sbin/rt-setup-database 436] 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.
make: *** [initialize-database] Error 2
 
Seems like it works all the way up until "make initialize-database" creates
the RT User.
When I run this script it does create all of the tables and the sequences
etc. but it just errors out when creating
the initial system users.  For some reason it is bombing out on me right
after the BeginTransaction returns the self->dbh->begin_work as the result.
 
Any help, tips, ideas or advice is much appreciated.
 
Also - I updated the nuke-schema.pl script so that it did not need the
"Scriptalicious" program because it was almost impossible
for me to install that on Fedora Core 3 system.  My version just uses
straight up perl and connects right to the Oracle database.
Is there a place I can deposit this script for others to make use of?
 
T.J. Maciak

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


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