Re: Need your help (frustrating issue)

From: Matt Davies <matt(at)mattdavies(dot)net>
To: sirath(at)cisco(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Need your help (frustrating issue)
Date: 2003-11-20 21:24:37
Message-ID: 1069363477.3fbd31151faba@www.mattdavies.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)cisco(dot)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
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Siddharth Rath (sirath) 2003-11-20 22:01:13 Re: Need your help (frustrating issue)
Previous Message Jan Wieck 2003-11-20 21:19:56 Re: Point-in-time data recovery - v.7.4