Make install problems (insertdata)

RT Users
1

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,
);

2

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.

-jOn Wed, Jan 16, 2002 at 11:54:25AM -0500, Jedrzej.M.Gajewski@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

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

3

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@bestprac                                                                            
                tical.com>                                                                                 
                                                                                                           
                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

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

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

4

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.

-jOn Wed, Jan 16, 2002 at 12:23:42PM -0500, Jedrzej.M.Gajewski@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@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@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@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

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