Skip site navigation (1) Skip section navigation (2)

Re: Need your help (frustrating issue)

From: "Siddharth Rath (sirath)" <sirath(at)cisco(dot)com>
To: "'Matt Davies'" <matt(at)mattdavies(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Need your help (frustrating issue)
Date: 2003-11-20 22:01:13
Message-ID: 023b01c3afb1$d00f1f30$d51da143@amer.cisco.com (view raw or flat)
Thread:
Lists: 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(at)mattdavies(dot)net] 
Sent: Thursday, November 20, 2003 1:25 PM
To: sirath(at)cisco(dot)com
Cc: pgsql-admin(at)postgresql(dot)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(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

pgsql-admin by date

Next:From: Rick GiggerDate: 2003-11-20 22:20:53
Subject: Re: performance problem
Previous:From: Matt DaviesDate: 2003-11-20 21:24:37
Subject: Re: Need your help (frustrating issue)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group