Re: Need your help (frustrating issue) - Mailing list pgsql-admin

Hi Matt,
Thanx for the response. Actually I did put the
LD_LIBRARY_PATH as $ENV{LD_LIBRARY_PATH}=
Hope you meant the same way. Somehow it doesn't workout.
Secondly since I done have access to /usr/local or /etc/profile
I did install the postgresql and DBD::Pg as per below.

 /path_to_preferred_perl_version/perl -I /apps/myapp/perl/lib
Makefile.PL PREFIX=/apps/myapp/perl LIB=/apps/myapp/perl/lib

The issue is yet to resolved ,please let me know if theres any other way
to resolve the same.

Thanx and regards
Sidd
-----Original Message-----
From: Matt Davies [mailto:matt@mattdavies.net]
Sent: Thursday, November 20, 2003 1:25 PM
To: sirath@cisco.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Need your help (frustrating issue)


In the past, I have always put the LD_LIBRARY_PATH environment setting
in the /etc/profile (make sure to export it if necessary) and that
seemed to solve all my problems.

Make sure you are setting the LD_LIBRARY_PATH _environment_ variable in
your cgi not just a varible named LD_LIBRARY_PATH.

Yet one more solution, and I don't know if it is possible or not, is to
wrap your application with a small script that will set the environment
for you such
as:

#!/bin/sh

export LD_LIBRARY_PATH=.....

/usr/local/apache/cgi/asd.cgi (or the like)




HTH's

Matt

Quoting "Siddharth Rath (sirath)" <sirath@cisco.com>:

> Hi ,
> I'm facing an issue with Postgresql 7.3.4.
> I've installed DBI version 1.37 & DBD::Pg (1.22) on a Solaris  8
> machine w/ perl 5.6.1 .The basic
> problem is I can connect to Postgres just fine from the command line,
> but it
> craps out when I try from a CGI with the below error message:
> install_driver(Pg) failed: Can't load
> '/apps/systran/perl/lib/sun4-solaris/auto/DBD/Pg/Pg.so' for module
> DBD::Pg: ld.so.1: /usr/local/bin/perl: fatal: libgcc_s.so.1: open
> failed: No such file or directory at
> /usr/local/perl5.6.1/lib/sun4-solaris/DynaLoader.pm line 206.
>  at (eval 1) line 3
>
>
>
> I got an link in google that says :
> Christoph Lange <[PRIVACY PROTECTION]> writes: > install_driver(Pg)
> failed: Can't load >
> '/soft/perl/lib/site_perl/sun4-solaris/auto/DBD/Pg/Pg.so' for module
> DBD::Pg: ld.so.1: /soft/local/bin/perl: fatal: > libpq.so: open
>
> failed: No such file or directory!
>
> Probably you have not told ldconfig where to look for libpq.so. The
> directory containing that shlib needs to be part of the system search
> path for shlibs (/etc/ld.so.conf I think). regards, tom lane
>
>
> It's Solaris, so there's no ldconfig to work on the fly's of libraries

> .I did put the LD_LIBRARY_PATH correctly in the cgi  itself , hoping
> that it would work out, but it didnt help me out.
>
> Can you please help me out in resolving it.
>
> Thanx and regards
>
> Sidd
>
>