[rt-users] Desperately ned Oracle help

Thu May 17 13:47:15 EDT 2007

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