[rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

Thanks a lot, Justin!!!
This is very valuable info!
 
However, i'm not at that step yet. I've just built RT with Oracle support
and was trying to run 'make initialize-database'
I've commented out the 'insert_schema()' method call, cause schema is
already in place.
I was expecting the thing to insert the initial RT data into the DB. But
that's where it was failing.
 
Do you think i should set the variable you mentioned in the shell and try
running it again?


  _____  

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Justin
Brodley
Sent: Thursday, May 17, 2007 1:20 PM
To: Baytalskiy, Sal; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help



Sal- It has to do with Apache and your CGI handler not knowing the oracle
parameters. We use Fast CGI on Redhat connecting to a remote Oracle servers.
I had to add the following lines to my httpd.conf file:

 

# RT STUFF FOR APACHE

SetEnv LD_LIBRARY_PATH /u01/app/oracle/product/10.2.0/client_1/lib

SetEnv ORACLE_HOME /u01/app/oracle/product/10.2.0/client_1

SetEnv ORACLE_SID rt

SetEnv TWO_TASK rt

(change above variables to your implementation)

 

In Httpd conf I also had to change the initialization string for Fastcgi,
this is the line in my config.

 

FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4
-initial-env LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib
-initial-env ORACLE_HOME=/u01/app/oracle/product/10.2.0/client1 -initial-env
ORACLE_SID=rt -initial-env TWO_TASK=rt

 

Some of this might be a bit excessive but I was trying everything and spent
a ton of time on the fastcgi and apache websites trying to figure this out.
Once this was all completed I was successful in getting DBI Searchbuilder
working. This took about a 12 hours of research and trial and error on my
part, and I've meant to go back and put this information in the wiki but
haven't had a chance. 

 

 Justin Brodley

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Baytalskiy,
Sal
Sent: Wednesday, May 16, 2007 9:49 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Desperately ned Oracle help

 

Hey everyone!

As ive already mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.

Well, today i finally got an Oracle 10g instance up and loaded the
schema.Oracle file into it.

Did the ./configure for RT(./configure --prefix=/usr/local/rt3_ora
--with-db-type=Oracle --with-db-host=clorad1.example.com --with-db-port=1521
--with-db-rt-host=localhost --with-db-dba=rtusr --with-db-database=clorad1
--with-db-rt-user=rtusr --with-db-rt-pass=***** )

 

Everything was ok.

 

While doing make initialize-database i got this error: Unable to load
DBIx::SearchBuilder database handle for 'Oracle'.

 

Realized that i don't have DBD::Oracle installed, so i downloaded that from
CPAN and installed that.

There were errors during the install and i found a workaround to delete
-xarch=v9 from the Makefile. After that install finished.

 

Then i followed the Wiki and commented out the insert_schema() method call.

 

But i'm still getting errors trying to init the DB.

 

 

Test suggested by the Wiki (TWO_TASK=FOO perl -MDBI -le
'DBI->connect("DBI:Oracle:", "rt3", "rt3")') seems to be successful. Or at
least it doesn't give any errors.

 

This is the error i get while doing make initialize-database :

 

DSN component 'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627
DBI connect('CLORAD1;port=1521','rtusr',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103
Failed to connect to dbi:Oracle:CLORAD1;port=1521 as rtusr: Can't connect
using this syntax without specifying a HOST and one of SID INSTANCE_NAME
SERVER SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
<STDIN> line 1.
make: *** [initialize-database] Error 255

 

 

PLEASE HELP !!!

 

Thanks in advance,

Sal.

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