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

I've had this problem (or something very similar) happen before several
times on new installations.  I think I resolved it by re-installing
DBD::Pg - but this was a while ago.

Are you sure Pg.so is in your @INC path?

Try adding this to your CGI to be sure it's looking in the right place.
use lib qw(/path_to_preferred_perl_version/perl /apps/myapp/perl/lib);

> 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
>>
>>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>