Re: Postgres' DBI(Pg) problem

Hi

did you set your LD_LIBRARY_PATH in your apache-config? You should put a "SetEnv LD_LIBRARY_PATH (wherever your . is)/pgsql/lib). And reload or restart apache of course.


Tommi


Nikos Kapsalis wrote:

Hi !

 

I have installed :

 

PostgreSQL 7.0

+ DBI and DBD::Pg

+ the environment vars : LD_LIBRARY_PATH and PGLIB are set to my ./pgsql/lib directory

+ Apache 1.3.22 without "mod_perl" installed

 

When I write a program like :

 

#!/bin/perl -w

 

use DBI;
my $dbh, $sth;

$dbh = DBI->connect("dbi:Pg:dbname=researchdb") or die $DBI::errstr;
$sth = $dbh->prepare("insert into course values('$v1', '$v2')") or die $DBI::errstr;

...

...

...

That runs perfect.

 

 

When I am trying to write a CGI script like this which will run under apache :

 

#!/bin/perl -w

use strict;

use CGI;

use CGI::Carp qw(fatalsToBrowser);

use DBI;

my $dbh, $sth, $query;

$query = new CGI;

$dbh = DBI->connect("dbi:Pg:dbname=researchdb") or die $DBI::errstr;
$sth = $dbh->prepare("insert into answers values('test1', 'test2');") or die $DBI::errstr;

..

print $query->header( ....

..

..

 

It gives me the following error in the browser.

 

install_driver(Pg) failed: [Thu Nov 15 12:09:30 2001] writeAnswers: [Thu Nov 15 12:09:30 2001] writeAnswers : Can't load '/usr/lib/perl5/site_perl/i386-linux/auto/DBD/Pg/Pg.so' for module DBD::Pg: File not found at /usr/lib/perl5/i386-linux/DynaLoader.pm line 169. [Thu Nov 15 12:09:30 2001] writeAnswers: [Thu Nov 15 12:09:30 2001] writeAnswers: [Thu Nov 15 12:09:30 2001] writeAnswers: [Thu Nov 15 12:09:30 2001] writeAnswers : at (eval 11) line 3 Perhaps a required shared library or dll isn't installed where expected at /home/pcguest/sambaShare/cgi-bin/MR.pm line 12

 

-- (Just to know : "writeAswers" is a function which calls the "use DBI;" in the "MR.pm" file )

-- Any idea how to solve that problem ?

 

---

Get your FREE download of MSN Explorer at http://explorer.msn.com