[rt-users] Oracle installation help needed

[Ruslan U. Zakirov]

Maciak, TJ wrote:
> 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
Here is RT an/or SB executes first insert and something fails. fails so
terrible that you don't have dbh any more, RT catches error in eval
block below and try to force rollback, but because dbh is not defined
any more it calls rollback on undef value.

Could you turn DBI debug and Oracle query log?
DBI log you can turn on with DBI_TRACE env variable with
"<level>[=<filename>]" syntax. See `perldoc DBI`.

> 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.
Did you update your perl?

>  
> 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
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com