470,647 Members | 1,155 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Installing DBD::Pg Perl module locally.

Hey guys,

I have a need to install the DBD::Pg Perl module on many shared web servers,
which do not have PostgreSQL installed. Then the DBD::Pg module will just
connect to a remote PostgreSQL database, hosted elsewhere. I'm having some
problems doing this.

First off, I modified the Makefile.PL, and added the three following links
just above the check for environment variables:

$ENV{POSTGRES_INCLUDE} = "./include";
$ENV{POSTGRES_LIB} = "./lib";

I then downloads the entire /include/ directory from my server, and the
following files from the /lib/ directory:

I'm not 100% sure why I chose those exact lib files. Just looked like the
right ones I guess. Anyway, then I can install the module by running:
perl Makefile.PL PREFIX=/path/to/whatever LIB=/path/to/whatever
make test
make install

The module itself seems to install fine. However, when I try to load it
through a Perl script, I receive the following:

Can't load '/home3/globalenet/envex/lib/i386-linux/auto/DBD/Pg/Pg.so' for
module DBD::Pg: libssl.so.2: cannot open shared object file: No such file or
directory at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 200.

The Pg.so file does exist, and I CHMODed it to 755, and still got the same
error. Also, I installed the DBD::Pg module locally with less /include and
/lib files. It would then load through a Perl script, but when it tried to
connect to a remote database, I would get an error saying something like,
unable to load function pqConnect, or something like that.

Any help would be greatly appreciated.


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #1
0 2181

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Envex Developments | last post: by
reply views Thread by Alex | last post: by
10 posts views Thread by Ausrack Webmaster | last post: by
4 posts views Thread by Patrick Hatcher | last post: by
2 posts views Thread by David Siebert | last post: by
1 post views Thread by Korara | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.