[rt-users] Desperately ned Oracle help

Thu May 17 14:03:25 EDT 2007

Hmm, not sure at this point. Someone else who is more familiar with the
initialize-database part of the install will have to assist. 

________________________________

Justin Brodley 
Supervisor of DataCenter Infrastructure 
SumTotal Systems, Inc. (Nasdaq: SUMT
<http://quotes.nasdaq.com/asp/summaryquote.asp?symbol=SUMT> )
110-110th Ave NE Suite 700
Bellevue, WA 98004 

OFFICE +1 425 637 1506
FAX +1 425 455 3071
MOBILE +1 425 753 7033
EMAIL jbrodley at sumtotalsystems.com

MSN justin_brodley <msnim:chat?contact=justin_brodley at hotmail.com> 

The content of this communication is considered SumTotal Confidential,
and should not be shared with anyone outside of SumTotal, either
electronically or verbally, without the express permission of the
author(s).

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

The Oracle readme said that the DB needs to be prepared.

So i ran the schema.Oracle file via the SQLPlus and it inserted all the
tables and indexes.

So i now have the database setup, just empty. No data.

Then, while running the 'make initialize-database' there's a step in
that script to insert the schema. Since i already did that - i commented
it out, just like the Wiki suggests.

So that step should be skipped and it should just try to insert the
required data into the DB.

And that's where i'm stuck at this point.

After some googling i found that i might have a problem with the
DBD::Oracle. Apparently it tried installing that module as a 64-bit.

But my Perl is 32-bit. This seems to be a common occurence.

Here's what i'm getting when trying to run 'make initialize-database' :

/usr/bin/perl //usr/local/rt3_ora/sbin/rt-setup-database --action init
--dba mwpoc --prompt-for-dba-password
Unquoted string "error" may clash with future reserved word at
/usr/local/rt3_ora/etc/RT_SiteConfig.pm line 286.
In order to create or update your RT database,this script needs to
connect to your Oracle instance on clorad1.aig.com as mwpoc.
Please specify that user's database password below. If the user has no
database
password, just press return.

Password: 
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','mwpoc',...) 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 mwpoc: 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

The hostname where oracle Db is running is clorad1.aig.com.
Instance/Service name is CLORAD1.

________________________________

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

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