Re: fcgi-perl on Sun 5.5.1 with DBI/DBD-Oracle

Sean Dowd (sdowd@inm.eds.com)
Tue, 10 Jun 1997 14:18:47 -0500 (CDT) 

Date: Tue, 10 Jun 1997 14:18:47 -0500 (CDT)
Message-Id: <199706101918.OAA20818@axton.inm.eds.com>
From: Sean Dowd <sdowd@inm.eds.com>
To: philr@peoplelink.com
Subject: Re: fcgi-perl on Sun 5.5.1 with DBI/DBD-Oracle
In-Reply-To: <339D9CD5.997A705E@peoplelink.com>
 <339D9CD5.997A705E@peoplelink.com>

>>>>> "phil" == G Philip Reger <philr@peoplelink.com> writes:

  phil> I have used DBI/DBD with fcgi before.. what is the exact error you
  phil> are getting?

Can't load '/usr/local/lib/perl5/site_perl/sun4-solaris/auto/DBI/DBI.so' for module DBI: ld.so.1: /usr/local/perl5-fcgi/bin/perl: fatal: relocation error: symbol not found: Perl_na: referenced in /usr/local/lib/perl5/site_perl/sun4-solaris/auto/DBI/DBI.so at /usr/local/lib/perl5/DynaLoader.pm line 140.
 
 at /usr/local/lib/perl5/site_perl/DBI.pm line 32
BEGIN failed--compilation aborted at ././dbi.pl line 14.


Here's my sample script.  Just running as-is (with the perl-fcgi binary)
yields the above error.  Running with my perl works fine.

#!/usr/local/perl5-fcgi/bin/perl
 
BEGIN {
    # push the paths for my perl on @INC so we don't have to install twice...
    unshift(@INC, "/usr/local/lib/perl5");
    unshift(@INC, "/usr/local/lib/perl5/site_perl");
    unshift(@INC, "/usr/local/lib/perl5/site_perl/sun4-solaris");
    
    print "INC\n";
    for (@INC) {
        print "\t", $_, "\n";
    }
    print "\n";
    require DBI;
}

print "creating dbh...\n";
$drh = DBI->install_driver('Oracle');

$dbh = $drh->connect($ENV{'ORACLE_SID'}, "user", "password", "Oracle") or
    print "DBI Error: ", $DBI::err, ", Message: ", $DBI::errstr, "\n";

print "SQL-ing...\n";
$dbs = $dbh->prepare("SELECT * FROM ssdtemp");
$dbs->execute();
@fieldnames = @{$dbs->{'NAME'}};
print "NAMEs = @fieldnames\n";
$dbs->finish;

print "Finished.\n";