<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>RE: [rt-users] rt and oracle</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Joe,</FONT>
</P>
<P><FONT SIZE=2>Did you place this "Set($DatabaseType , 'Oracle');" in the file /opt/rt3/etc/RT_SiteConfig.pm ??</FONT>
</P>
<P><FONT SIZE=2>Im trying to set up Oracle db too but having problems on the user creation from the db script but</FONT>
<BR><FONT SIZE=2>I have been able to get it to create the tables, sequences, triggers etc. in my oracle db successfully.</FONT>
</P>
<P><FONT SIZE=2>T.J. Maciak</FONT>
</P>
<P><FONT SIZE=2>Internet/Intranet Developer</FONT>
<BR><FONT SIZE=2>Department of IT</FONT>
<BR><FONT SIZE=2>City of Grand Rapids</FONT>
<BR><FONT SIZE=2>P: (616)456-3713</FONT>
<BR><FONT SIZE=2>F: (616)456-3448</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: rt-users-bounces@lists.bestpractical.com [<A HREF="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</A>] On Behalf Of joe macdonald</FONT></P>
<P><FONT SIZE=2>Sent: Thursday, June 09, 2005 1:06 PM</FONT>
<BR><FONT SIZE=2>To: rt-users@bestpractical.com</FONT>
<BR><FONT SIZE=2>Subject: Re: [rt-users] rt and oracle</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>--- Jesse Vincent <jesse@bestpractical.com> wrote:</FONT>
</P>
<P><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> On Thu, Jun 09, 2005 at 08:26:47AM -0700, joe macdonald wrote:</FONT>
<BR><FONT SIZE=2>> > I have RT installed on a Linux box. I want to use</FONT>
<BR><FONT SIZE=2>> a</FONT>
<BR><FONT SIZE=2>> > remote Oracle db as the backend. I've setup the SiteConfig.pm </FONT>
<BR><FONT SIZE=2>> > appropriately, but I'm kind of lost</FONT>
<BR><FONT SIZE=2>> as</FONT>
<BR><FONT SIZE=2>> > to where to go from here. When I try to pull up</FONT>
<BR><FONT SIZE=2>> the</FONT>
<BR><FONT SIZE=2>> > web interface, Apache logs this error:</FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > Unable to load DBIx::SearchBuilder database handle</FONT>
<BR><FONT SIZE=2>> for</FONT>
<BR><FONT SIZE=2>> > 'oracle'.</FONT>
<BR><FONT SIZE=2>> > Perhaps you've picked an invalid database type or spelled it </FONT>
<BR><FONT SIZE=2>> > incorrectly.</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Oracle, not oracle</FONT>
</P>
<P><FONT SIZE=2>I should have mentioned that I tried both 'oracle' and 'Oracle' prior to posting to the list.</FONT>
</P>
<BR>
<P><FONT SIZE=2>__________________________________________________</FONT>
<BR><FONT SIZE=2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=2>Tired of spam? Yahoo! Mail has the best spam protection around <A HREF="http://mail.yahoo.com" TARGET="_blank">http://mail.yahoo.com</A> _______________________________________________</FONT></P>
<P><FONT SIZE=2><A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" TARGET="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A></FONT>
</P>
<P><FONT SIZE=2>Be sure to check out the RT Wiki at <A HREF="http://wiki.bestpractical.com" TARGET="_blank">http://wiki.bestpractical.com</A></FONT>
</P>
</BODY>
</HTML>