[rt-users] Desperately ned Oracle help

[Baytalskiy, Sal]

Yep, I had to edit the Makefile as well. Not only did I change all /lib to
/lib32, but I also had to remove the -xarch=v9 from everywhere.
That fixed the make process for DBD::Oracle.

Now, the good news: I finally figured it out and made the 'make
initialize-database' work. It even inserted the schema all by itself.
Here's what I had to do:

In the file /usr/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm

I replaced
my $handle = DBI->connect($self->DSN, $args{'User'}, $args{'Password'}) ||
croak "Connect Failed $DBI::errstr\n" ;
With
my $handle = DBI->connect("DBI:Oracle:CLORAD1", $args{'User'},
$args{'Password'}) || croak "Connect Failed $DBI::errstr\n" ;

Effectively hardcoding the connection info.

That seems to fix the errors I was getting and finally populated the DB.

I then used other suggestions that were made here and added some more
directives to my httpd.conf file and I can finally connect to the RT
instance with Oracle 10g backend.

I have to say that ticket creation takes much longer than with local MySQL
instance. I'm not sure if its my setup or its just that slow.

Now the new challenge is to install RTFM and AssetTracker. They both make
additions to the DB as well. We'll see how that works out...


Thanks everyone!!!

Sal.

-----Original Message-----
From: Joop van de Wege [mailto:JoopvandeWege at mococo.nl] 
Sent: Friday, May 18, 2007 6:04 AM
To: Baytalskiy, Sal
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Desperately ned Oracle help

Baytalskiy, Sal wrote:
> Hey guys!
> A little update:
> i've been looking at the rt-setup-database script trying to figure out 
> how to get around the issues i'm having.
> So the very first error mentioned this: at 
> //usr/local/rt3_ora/sbin/rt-setup-database line 103 which is this 
> *$dbh = DBI->connect( get_system_dsn(), $args{'dba'}, 
> $args{'dba-password'} )* So i replaced that with: $dbh = DBI->connect( 
> "DBI:Oracle:", $args{'dba'}, $args{'dba-password'} )
>  
> That seemed to get me a bit farther as i got this output:
> Now creating a database for RT.
> ...skipped as mwpoc is not mwpoc or we're working with Oracle.
> 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 138 *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 138, <STDIN> line 1.
> make: *** [initialize-database] Error 255
I'm using Oracle too and it should not matter whether the database is on
  the localhost or a remote one, so I would go back and do the following:
- drop the schema of RT on the remote server
- add the RT user or grant DBA role to it (temporarily)
- configure RT again with the correct parameters these are mine adjust
accordingly:
   -- export ORACLE_HOME=/your/oracle/home
   -- export ORACLE_SID=YOURSID
   -- (else the following line will barf)
   -- ./configure --with-db-type=Oracle --with-db-dba=rt_user
      --with-db-database=XE

  (if XE is in your tnsnames.ora then everything should work doesn't matter
where that db is)
- make initialize-database

As to the 32/64bit problem that used to be an issue but since I haven't done
a clean install in a while I don't  know if current DBD::Oracle still has
problems. The way I fixed this once, from memory, is that I did edit the
make file to use $ORACLE_HOME/lib32 instead of $ORACLE_HOME/lib which is
since 10g 64bit instead of 32 as is used to be in pre 10g.
But you should get a error from making DBD::Oracle which should be rather
clear on  this issue since it complains about elf64 problems.

Hope this helps, either contact me offlist, I might be able to help.

Joop