I am having trouble with php and postgresql on OS X 10.7.5

Question

Level 1

15 points

I am having trouble with php and postgresql on OS X 10.7.5

I have php, postgresql 5.3.23, and apache installed. However, when I go to my web browser and open the pages things don't work when I try to enter info in the search boxes. I get this error immediately upon typing something in the search box.

Fatal error: Call to undefined function pg_pconnect() in /www/Includes/file.php on line 12

I have installed and configured the php.ini file to reflect extension=pcntl.so and extension=pgsql.so, restarted apache, and still no luck. I have to be just missing some minor thing that is major in terms of workability. Can anyone help?

MacBook Pro, Mac OS X (10.7.5), Intel i7, 8 GM RAM, 1 TB HD

Posted on Mar 27, 2013 1:48 PM

Reply

Answer 1

mnmacmama Author

Level 1

15 points

Mar 29, 2013 7:03 PM in response to mnmacmama

I have noticed that this error is being recorded in the Apache logs.

Warning: PHP Startup: Unable to load dynamic library '/opt/local/lib/php/extensions/pgsql.so' - dlopen(/opt/local/lib/php/extensions/pgsql.so, 9): Library not loaded: /usr/lib/libpq.5.dylib

Referenced from: /opt/local/lib/php/extensions/pgsql.so

Reason: image not found in Unknown on line 0

This has got to be the "missing" piece of my puzzle, but I am having no luck finding what to do about it. I have tried making a link to the libpq.5.3.dylib with no success.

Anyone know what I'm doing wrong?

Reply