[rt-users] make install problems (insertdata)

[Jesse Vincent]

You really, really don't want to be running RT on oracle in production.
You probably don't even want to be running it for the hell of it, unless
you intend to be doing development on the oracle port.  The oracle port
is currently proof-of-concept level. Patches are gratefully appreciated.

	-j


On Wed, Jan 16, 2002 at 11:54:25AM -0500, Jedrzej.M.Gajewski at gsk.com wrote:
> Trying to install RT 2-0-11with Oracle 8i. I get an error near the end of
> the make install. Searched the archives and did not find anything on this.
> Nothing in the FAQ about it.
> 
> cp -rp ./tools/insertdata \
>          //bioinfo/apps/unsupported/rt2/etc
> /bioinfo/apps/bin/perl -p -i -e "
> s'!!RT_ETC_PATH!!'/bioinfo/apps/unsupported/rt2/etc'g;\
>                    s'!!RT_LIB_PATH!!'/bioinfo/apps/unsupported/rt2/lib'g;"\
>         //bioinfo/apps/unsupported/rt2/etc/insertdata
> /bioinfo/apps/bin/perl /bioinfo/apps/unsupported/rt2/etc/insertdata
> DBI->connect(dbname=DEV;host=131.111.77.831) failed: Can't connect using
> this syntax without specifying a HOST and a SID at
> /home/gastov/perlmod/lib/site_perl/5.005/DBIx/SearchBuilder/Handle/Oracle.pm
> 
> line 73
> Connect Failed Can't connect using this syntax without specifying a HOST
> and a SID
> make: *** [insert] Error 255
> 
> I can log into the database just fine using sqlplus, I see the tables that
> were created earlier by make install...
> All required modules are installed in my home dir account and the PATH to
> perl lib has been updated. The make testdeps reports no errors.
> 
> Anyone have any ideas? To me it looks like SID is never set (no Parameter
> for it in the Makefile)  and then never passed to the Connect method...
> 
> Here are some related code excerpts if it helps:
> 
> from install dir: /tmp/rt/lib/RT/Handle.pm:
> $self->SUPER::Connect(Host => $RT::DatabaseHost,
>                          Database => $RT::DatabaseName,
>                          User => $RT::DatabaseUser,
>                          Password => $RT::DatabasePassword,
>                          Port => $RT::DatabasePort,
>                          Driver => $RT::DatabaseType,
>                          RequireSSL => $RT::DatabaseRequireSSL,
>                         );
> 
> From installed perl modules:
> .../lib/site-perl/5.005/DBIx/SearchBuilder/Handle/Oracle.pm:
> sub Connect  {
>   my $self = shift;
> 
>   my %args = ( Driver => undef,
>                Database => undef,
>                User => undef,
>                Password => undef,
>            SID => undef,
>            Host => undef,
>                @_);
> 
>   my $dsn = "dbi:$args{'Driver'}:dbname=$args{'Database'}";
>   $dsn .= ";sid=$args{'SID'}" if defined $args{'SID'};
>   $dsn .= ";host=$args{'Host'}" if defined $args{'Host'};
> 
>   my $DBIHandle = DBI->connect($dsn, $args{'User'}, $args{'Password'}) ||
> die "Connect Failed $DBI::errstr\n" ;
> 
>   #Set the handle
>   $self->dbh($DBIHandle);
> 
> 
> Thank you in advance,
> Jedrzej G
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.