[rt-users] Desperately ned Oracle help

[Justin Brodley]

I would make sure the variable is set everywhere, the initial data is
imported with the schema, that you commented out. Out of curiosity why
are you commenting out the "schema" the only reason you would do this is
if the database was already created with all the appropriate tables. Our
oracle guys just setup the RT user as per the oracle readme and then we
just ran initialize-database and it created the rest. 

 

Justin Brodley

 

From: Baytalskiy, Sal [mailto:Sal.Baytalskiy at AIG.com] 
Sent: Thursday, May 17, 2007 10:34 AM
To: Justin Brodley; rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Desperately ned Oracle help

 

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/c5de9c84/attachment.htm>