[rt-users] make install problems (insertdata)

[Jesse Vincent]

The last time I tried, it actually _did_ install fine on my oracle
configuration with a local database. The big thing you currently lose 
on is full-text searching of blobs.  Others have it working. 
For 2.0.12, I'll update the readme to make the fact that 
oracle support is not for average users more obvious. Sorry for your trouble.


-j


On Wed, Jan 16, 2002 at 12:23:42PM -0500, Jedrzej.M.Gajewski at gsk.com wrote:
> That is news for me. I read the documentation before proceeding, and it
> stated that there are known issues with Oracle. It did not say it is
> unusable and more specifically, uninstallable. Maybe the README
> documentation should be upgraded to reflect that more clearly before people
> spend time to get it working.
> 
> Thanks for the clarification though....
> 
> Jedrzej G.
> 
> 
> 
>                                                                                                                
>                     "Jesse Vincent"                                                                            
>                     <jesse at bestprac                                                                            
>                     tical.com>                                                                                 
>                                           To:     Jedrzej.M.Gajewski                                           
>                                                                                                                
>                     16-Jan-2002           cc:     rt-users                                                     
>                     12:15                 Subject:     Re: [rt-users] make install problems (insertdata)       
>                                                                                                                
>                                                                                                                
> 
> 
> 
> 
> 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.
> 
> 
> 
> 
> 
> _______________________________________________
> 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.