Rt and oracle

RT Users
1

I have RT installed on a Linux box. I want to use a
remote Oracle db as the backend. I’ve setup the
SiteConfig.pm appropriately, but I’m kind of lost as
to where to go from here. When I try to pull up the
web interface, Apache logs this error:

Unable to load DBIx::SearchBuilder database handle for
‘oracle’.
Perhaps you’ve picked an invalid database type or
spelled it incorrectly.

???

Also - which components of Oracle do I need to have
installed on the RT box? Which components does
DBD::Oracle require?

Thanks for any tips/guidance.

joe.

Discover Yahoo!
Stay in touch with email, IM, photo sharing and more. Check it out!
http://discover.yahoo.com/stayintouch.html

2

I have RT installed on a Linux box. I want to use a
remote Oracle db as the backend. I’ve setup the
SiteConfig.pm appropriately, but I’m kind of lost as
to where to go from here. When I try to pull up the
web interface, Apache logs this error:

Unable to load DBIx::SearchBuilder database handle for
‘oracle’.
Perhaps you’ve picked an invalid database type or
spelled it incorrectly.

Oracle, not oracle

3

I have RT installed on a Linux box. I want to use
a
remote Oracle db as the backend. I’ve setup the
SiteConfig.pm appropriately, but I’m kind of lost
as
to where to go from here. When I try to pull up
the
web interface, Apache logs this error:

Unable to load DBIx::SearchBuilder database handle
for
‘oracle’.
Perhaps you’ve picked an invalid database type or
spelled it incorrectly.

Oracle, not oracle

I should have mentioned that I tried both ‘oracle’ and
‘Oracle’ prior to posting to the list.

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

4

Joe,

Did you place this “Set($DatabaseType , ‘Oracle’);” in the file
/opt/rt3/etc/RT_SiteConfig.pm ??

Im trying to set up Oracle db too but having problems on the user creation
from the db script but
I have been able to get it to create the tables, sequences, triggers etc. in
my oracle db successfully.

T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of joe macdonald
Sent: Thursday, June 09, 2005 1:06 PM
To: rt-users@bestpractical.com
Subject: Re: [rt-users] rt and oracle

I have RT installed on a Linux box. I want to use
a
remote Oracle db as the backend. I’ve setup the SiteConfig.pm
appropriately, but I’m kind of lost
as
to where to go from here. When I try to pull up
the
web interface, Apache logs this error:

Unable to load DBIx::SearchBuilder database handle
for
‘oracle’.
Perhaps you’ve picked an invalid database type or spelled it
incorrectly.

Oracle, not oracle

I should have mentioned that I tried both ‘oracle’ and ‘Oracle’ prior to
posting to the list.

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com _______________________________________________
The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com