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

Re: SUMMARY: Solaved. apache perl cgi script cant load libpq.5.dylib on mac os tiger

From: Tom Allison <tom(at)tacocat(dot)net>
To: Fergus McMenemie <fergus(at)twig(dot)me(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SUMMARY: Solaved. apache perl cgi script cant load libpq.5.dylib on mac os tiger
Date: 2008-06-25 02:27:32
Message-ID: 4861AD14.9060500@tacocat.net (view raw or flat)
Thread:
Lists: pgsql-general
I found a similar problem only with a slight variation.

postgresql, for me, is installed in /opt/local/ with the particular file 
being located at:
/opt/local/lib/postgresql83/libpq.5.dylib

This is all a part of the mac ports installation for apache2 and postgres.

It seems that the problem isn't so much pgsql but apache2 and/or mac 
ports.  But would you (or anyone else) have a suggestion on how to 
proceed?  I could probably just make a lot of soft links, but that 
doesn't seem very robust.

Fergus McMenemie wrote:
> Hmmm,
> 
> It was the protection on the /usr/local/pgsql directory. Solved, by myself
> an hour after making this post. Odd that, its been bugging the heck out of
> me for over a week now, and then one hour after posting....
> 
> 
> 
> At 16:05 +0100 23/5/08, Fergus McMenemie wrote:
>> I have a perl cgi script that wont run on a new mac.  The script runs fine
>>from the command line, so the perl and postgresql seem good. However
>> when run as an apache cgi script the postgresql stuff fails as shown
>> below.  I altered the script to dump %ENV and the paths seem in order.
>>
>> The script is not using mod perl. It is using the apple os x 10.4.11 supplied
>> version of apache, postgresql-8.3.0  and perl, v5.8.8 with DBD::Pg, DBI and
>> JSON installed.
>>
>> I am at a total loss as to why the library cant be found and would be
>> very grateful for any help.
>>
>> Content-type: text/html Software error:
>>
>> install_driver(Pg) failed:
>>   Can't load '/usr/local/lib/perl5/site_perl/5.8.8/darwin-2level/auto/DBD/Pg/Pg.bundle'
>>  for module DBD::Pg: dlopen(/usr/local/lib/perl5/site_perl/5.8.8/darwin-2level/auto/DBD/Pg/Pg.bundle, 1):
>>  Library not loaded: /usr/local/pgsql/lib/libpq.5.dylib
>>  Referenced from: /usr/local/lib/perl5/site_perl/5.8.8/darwin-2level/auto/DBD/Pg/Pg.bundle
>>  Reason: image not found at /usr/local/lib/perl5/5.8.8/darwin-2level/DynaLoader.pm line 230.
>> at (eval 45) line 3
>>  Compilation failed in require at (eval 45) line 3.
>> Perhaps a required shared library or dll isn't installed where expected at /Library/WebServer/cgi-bin/pgcgi.pl line 383
>>
>>     $ENV{AUTH_TYPE} = Basic
>>     $ENV{DOCUMENT_ROOT} = /Library/WebServer/Documents
>>     $ENV{DYLD_LIBRARY_PATH} = /usr/local/pgsql/lib:/usr/lib:/usr/local/lib
>>     $ENV{GATEWAY_INTERFACE} = CGI/1.1
>>     $ENV{HTTPS} = on
>>     $ENV{HTTP_ACCEPT} = text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,/;q=0.5
>>     $ENV{HTTP_ACCEPT_CHARSET} = ISO-8859-1,utf-8;q=0.7,;q=0.7
>>     $ENV{HTTP_ACCEPT_ENCODING} = gzip,deflate
>>     $ENV{HTTP_ACCEPT_LANGUAGE} = en,en-us;q=0.5
>>     $ENV{HTTP_CONNECTION} = keep-alive
>>     $ENV{HTTP_HOST} = XXXXX.co.uk
>>     $ENV{HTTP_KEEP_ALIVE} = 300
>>     $ENV{HTTP_USER_AGENT} = Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1.14) Gecko/20080404 Firefox/2.0.0.14
>>     $ENV{LD_LIBRARY_PATH} = /usr/local/pgsql/lib:/usr/lib:/usr/local/lib
>>     $ENV{PATH} = /usr/local/pgsql/bin:/usr/local/bin:/bin:/sbin:/usr/bin:/usr/sbin
>>     $ENV{QUERY_STRING} =
>>     $ENV{REMOTE_ADDR} = XXXXXX
>>     $ENV{REMOTE_PORT} = 53698
>>     $ENV{REMOTE_USER} = fergus
>>     $ENV{REQUEST_METHOD} = GET
>>     $ENV{REQUEST_URI} = /cgi-bin/pgcgi.pl
>>     $ENV{SCRIPT_FILENAME} = /Library/WebServer/cgi-bin/pgcgi.pl
>>     $ENV{SCRIPT_NAME} = /cgi-bin/pgcgi.pl
>>     $ENV{SERVER_ADDR} = XXXX
>>     $ENV{SERVER_ADMIN} = fergus(at)XXXXX
>>     $ENV{SERVER_NAME} = XXXXX.co.uk
>>     $ENV{SERVER_PORT} = 443
>>     $ENV{SERVER_PROTOCOL} = HTTP/1.1
>>     $ENV{SERVER_SIGNATURE} =  Apache/1.3.41 Server at XXXX.co.uk Port 443
>>     $ENV{SERVER_SOFTWARE} = Apache/1.3.41 (Darwin) mod_ssl/2.8.31 OpenSSL/0.9.7l
>>
>> -- 
>>
>> ===============================================================
>> Fergus McMenemie               Email:fergus(at)twig(dot)me(dot)uk
>> Techmore Ltd                   Phone:(UK) 07721 376021
>>
>> Unix/Mac/Intranets             Analyst Programmer
>> ===============================================================
>>
>> -- 
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
> 


In response to

pgsql-general by date

Next:From: Clemens SchwaighoferDate: 2008-06-25 03:44:01
Subject: Re: Probably been asked a hundred times before.
Previous:From: Greg SmithDate: 2008-06-24 20:56:01
Subject: Re: Probably been asked a hundred times before.

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