Re: [OT] Accessing PostgreSQL through Apache and PHP4

This looks like a php/Apache problem.  During my brief fling with php, I got
best results when I built apache and php together using apachetoolbox from
apachetoolbox.com.  Running Slackware, I had postgresql in the standard
/usr/local/pgdata directory, and the apachetoolbox scripts found it there and
built support for it into php.  Relatively painless.

Ultimately, I ditched php in favor of using mod_perl and Mason, mainly because
php database calls were SO database specific and I couldn't find a decent
abstraction layer, and also because I couldn't find a decent templating
solution.  I found some attempts at both, but DBI and Mason are years ahead in
terms of features.  ObDisclaimer: I've been using perl for several years now, so
that may have unfairly raised my expectations or otherwise biased my evaluation.
:-)

Wes
P.S.  Even more OT: Anyone know how to access email on a domino server using a
generic linux mail client?  No, I don't believe our domino server is set up to
support IMAP or POP.



"Holt, Jack C." <JACK.C.HOLT%saic.com@interlock.lexmark.com> on 10/18/2001
10:55:42 AM

To:   pgsql-general%postgresql.org@interlock.lexmark.com
cc:    (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject:  [GENERAL] Accessing PostgreSQL through Apache and PHP4 on Linux

I am running PostgreSQL 7.1.3, RedHat 7.1 (kernel 2.4.2-2), and PHP/4.0.4pl1.
When I try to run a PHP page found below I get an error that says:



Fatal error: Call to undefined function: pg_connect() in
/var/www/html/psolver.php on line 10



Additionally, even though pgsql.so IS in /usr/lib/php4 (and php.ini tells PHP to
look there for extensions), I get the following error on the call to dl().



Warning: Unable to load dynamic library '/usr/lib/php4/pgsql.so' - libpq.so:
cannot load shared object file: No such file or directory in
/var/www/html/psolver.php on line 7



Code snippet:

-----------------------------------------------------------------------------------------------

<?

  dl("pgsql.so");



  //connect to database

  $conn = pg_connect("","","","psolver");

  if(!$conn) {

    print("Couldn't connect to psolver");

    exit;

  }

?>