<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=270533012-09062005><FONT face=Arial
size=2>Hello,</FONT></SPAN></DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial size=2>I was able to get RT
working with MySQL <SPAN class=270533012-09062005>v4.x </SPAN>quite easily
but the information on Oracle installs is scarce.</FONT></SPAN></DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial size=2>I am having major
pains trying to get RT installed using Oracle as the
database.</FONT></SPAN></DIV><SPAN class=270533012-09062005>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV></SPAN><SPAN class=270533012-09062005><FONT face=Arial size=2>I have added
my own debugging statements to try to figure out what the problem is and this is
what I am getting:</FONT></SPAN></DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial size=2>Now creating a
database for RT.<BR>...skipped as rt is not rt or we're working with
Oracle.</FONT></SPAN></DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial
size=2>.</FONT></SPAN></DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial
size=2>.</FONT></SPAN></DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial
size=2>.</FONT></SPAN></DIV>
<DIV><SPAN class=270533012-09062005><FONT face=Arial size=2>Before Create System
User<BR>Creating system user...<BR>DEBUG: [//opt/rt3/sbin/rt-setup-database 436]
New RT User<BR>DEBUG: User_Overlay.pm - Start _BootstrapCreate<BR>DEBUG:
/opt/rt3/lib/RT/User_Overlay.pm 484 Before BeginTransaction<BR>DEBUG:
[/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 674] Start
BeginTransaction<BR>DEBUG:
[/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 678] TRANSDEPTH =
1<BR>DEBUG: [/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm 685]
BeginTransaction - return self->dbh->begin_work<BR>DEBUG:
[/opt/rt3/lib/RT.pm 287] We DIED - Rollback!<BR>Can't call method "rollback" on
an undefined value at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 742.<BR>make:
*** [initialize-database] Error 2</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=270533012-09062005>Seems like it works
all the way up until "make initialize-database" creates the RT
User.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=270533012-09062005>When I run this
script it does create all of the tables and the sequences etc. but it just
errors out when creating</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=270533012-09062005>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=270533012-09062005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=270533012-09062005>Any help, tips,
ideas or advice is much appreciated.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=270533012-09062005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=270533012-09062005>Also - I updated the
nuke-schema.pl script so that it did not need the "Scriptalicious" program
because it was almost impossible</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=270533012-09062005>for me to install
that on Fedora Core 3 system. My version just uses straight up perl and
connects right to the Oracle database.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=270533012-09062005>Is there a place I
can deposit this script for others to make use of?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><SPAN style="FONT-FAMILY: times new roman"><FONT face=Arial
size=2>T.J. Maciak</FONT></SPAN></DIV><SPAN
style="FONT-FAMILY: times new roman">
<DIV align=left><FONT face=Arial size=2></FONT><FONT face=Arial
size=2></FONT><BR><FONT face=Arial size=2>Internet/Intranet
Developer<BR>Department of IT<BR>City of Grand Rapids<BR>P:
(616)456-3713</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>F:
(616)456-3448<BR><BR></DIV></FONT></SPAN>
<DIV> </DIV></BODY></HTML>