can"t connect to a postgreSQL database from PHP

HelpHi everybody!

I've got a problem using PHP to connect to a postgre database, it seems that
the function for postgre are not recognized or something like that because a
I get the following error in the web navigator:
"Fatal Error: Calling to undefined function pg_connect() ...)"

I configured php with: ./configure --with-apache=/usr/local/apache_1.3.26
--with-pgsql=shared
--enable-track-vars
--with-xml
after that I reconfigured Apache to take into account php:

./configure --prefix=/usr/local/apache_1.3.26
--activate-module=src/module
s/php4/libphp4.a


Any idea to solve it?

Thank you all.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: can"t connect to a postgreSQL database from PHP

Carlos wrote:

> I get the following error in the web navigator:
> "Fatal Error: Calling to undefined function pg_connect() ...)"

It seems that PHP can't find your pgsql dynamic extension.

Have you edited php.ini to have the correct lines:

extension_dir = /path/to/php/extensions

extension=pgsql.so



--
Benjamin Oris Jr.
ImagineAsia Animation Studio

---------------------------(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

Re: can"t connect to a postgreSQL database from PHP

On Sun, 11 Aug 2002, Carlos wrote:

> HelpHi everybody!
>
> I've got a problem using PHP to connect to a postgre database, it seems that
> the function for postgre are not recognized or something like that because a
> I get the following error in the web navigator:
> "Fatal Error: Calling to undefined function pg_connect() ...)"
>
> I configured php with: ./configure --with-apache=/usr/local/apache_1.3.26
> --with-pgsql=shared
> --enable-track-vars
> --with-xml

Why do you have --with-pgsql=shared? Normally, you just need the switch
--with-pgsql.

when you ran the ./configure script, did you save the output and see
whether it said it found and configured postgresql? My bet is that it
failed during ./configure and you didn't notice, as it won't cause the
../configure script to error out.

Also, I'd recommend compiling apache for DSO support, i.e. using the
--with-apxs switch setting. I've seen problems show up with using the .a
libs instead of .so. Since shared objects seems the preferred
methodology, it seems like problems with configuration that affect dso get
fixed much quicker than static libs.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html