Re: PHP4 Not Seeing PostgreSQL 7.2

if the install directory /usr/local/pgql or /usr/local/pgsql What does your phpinfo() give for postgres? .: B i g D o g :. ----- Original Message ----- From: "Eric" <emayo@pozicom.net> To: <php-db@lists.php.net> Sent: Sunday, July 21, 2002 9:09 AM Subject: [PHP-DB] PHP4 Not Seeing PostgreSQL 7.2 > Can someone please tell me what the hell I am doing wrong. (2 days of no > success = very frustrated). > > PGSQL is up and running no problem. I start it with: > postmaster -D /path/to/data/cluster -i & > > I can connect to the postgresql v.7.2.1 database from remote workstations > and execute queries no problem. > > > In my php code I have tried: > dl("pgsql.so") even though there is no pgsql.so on the server. > I have installed both Postgres7.2 and PHP4 from source. Where does pgsql.so > come from? (PHP or Postgre compile?) > > Tried to copy the /lib/libpgsql.2.2.so into place and rename. PHP erros out > that > pgsql.so is not a valid PHP library. (Kind of suspected this would happen). > > Tried include("DB/pgsql.php") and this gives endless errors > about class db_common can't inherit etc... > > Isn't there any clear cut examples or step-by-step how tos? > > What am I missing here? > > By the way, I have set the LD_LIBRARY_PATH and I have included > /usr/local/pgsql/lib > path in /etc/ld.so.conf. > > Compiled PHP4 as follows: > ./configure --enable-track-vars --with-gettext --enable-force-cgi-redirect > --with-apache=../apache_1.3.26 --without-mysql > --with-pgsql=/usr/local/pgql > > > PHP code is working with Apache because other things work. Just that > pg_connect() is always 'unknown function'. > > Here is how apache was compiled: > ./configure --enable-module=so --activate-module=src/modules/php4/libphp4.a > --enable-module=php4 > > Suggestions and help are very greatly appreciated! > > Eric > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php