I have a Raq4i and I am trying to write PHP 4 to the PostgreSQL. But I keep getting undefined function: pg_connect() . I have the extension enabled and the PHP was compiled for postgreSQL. I do not understand what is going on?
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Thu, 15 May 2003, Mark wrote:
> I have a Raq4i and I am trying to write PHP 4 to the PostgreSQL. But I
> keep getting undefined function: pg_connect() . I have the extension
> enabled and the PHP was compiled for postgreSQL. I do not understand
> what is going on?
If PHP says pg_connect is undefined, then the php the RAQ is running isn't
compiled for postgresql connectivity.
There are two common causes of this:
1: You compiled one build of PHP, the RAQ is running on another build.
2: You told PHP to build in postgresql connectivity, it couldn't find the
right header file, failed, writing an error message to the screen during
configuration, saying something along the lines of "could not find file
xxxxx.h" skipping postgresql configuration.
PHP will then happily build and run, without postgresql capabilities.
Try this:
write a web page with this in it:
phpinfo();
?>
Look through the page to see if it mentions postgresql. At the top will
be a list of all the switches it was configged with. If you have a
--with-pgsql there, but no pgsql section in phpinfo, then the configure
script couldn't find the right headers. Make sure you're running a fairly
late model version of both PHP and postgresql, as there was a bit of an
issue about a year ago when postgresql changed the name of one of it's
connection headers.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Look for the files libpq.h and also libpq-fe??? something like that. Those
are the PostgreSQL headers (.h) and libraires (.so) You'll have to have
those for pg_connect to work. When PHP is built it needs to know where
those are (in path with other includes and libraries? or something else
(/usr/local?/opt/postgre)).
/B
----- Original Message -----
From: "scott.marlowe"
To: "Mark"
Cc:
Sent: Friday, May 16, 2003 11:48
Subject: Re: [PHP] Inquiry From Form [pgsql]
> On Thu, 15 May 2003, Mark wrote:
>
> > I have a Raq4i and I am trying to write PHP 4 to the PostgreSQL. But I
> > keep getting undefined function: pg_connect() . I have the extension
> > enabled and the PHP was compiled for postgreSQL. I do not understand
> > what is going on?
>
> If PHP says pg_connect is undefined, then the php the RAQ is running isn't
> compiled for postgresql connectivity.
>
> There are two common causes of this:
>
> 1: You compiled one build of PHP, the RAQ is running on another build.
>
> 2: You told PHP to build in postgresql connectivity, it couldn't find the
> right header file, failed, writing an error message to the screen during
> configuration, saying something along the lines of "could not find file
> xxxxx.h" skipping postgresql configuration.
>
> PHP will then happily build and run, without postgresql capabilities.
>
> Try this:
>
> write a web page with this in it:
>
>
> phpinfo();
> ?>
>
> Look through the page to see if it mentions postgresql. At the top will
> be a list of all the switches it was configged with. If you have a
> --with-pgsql there, but no pgsql section in phpinfo, then the configure
> script couldn't find the right headers. Make sure you're running a fairly
> late model version of both PHP and postgresql, as there was a bit of an
> issue about a year ago when postgresql changed the name of one of it's
> connection headers.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
---------------------------(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
The way I "show" linux where to find the libs for postgresql is to edit
/etc/ld.so.conf to have a line like /usr/local/pgsql/lib and then run
ldconfig.
Otherwise PHP will compile, but apache won't start.
On Fri, 16 May 2003, David Busby wrote:
> Look for the files libpq.h and also libpq-fe??? something like that. Those
> are the PostgreSQL headers (.h) and libraires (.so) You'll have to have
> those for pg_connect to work. When PHP is built it needs to know where
> those are (in path with other includes and libraries? or something else
> (/usr/local?/opt/postgre)).
>
> /B
>
>
>
> ----- Original Message -----
> From: "scott.marlowe"
> To: "Mark"
> Cc:
>
> Sent: Friday, May 16, 2003 11:48
> Subject: Re: [PHP] Inquiry From Form [pgsql]
>
>
> > On Thu, 15 May 2003, Mark wrote:
> >
> > > I have a Raq4i and I am trying to write PHP 4 to the PostgreSQL. But I
> > > keep getting undefined function: pg_connect() . I have the extension
> > > enabled and the PHP was compiled for postgreSQL. I do not understand
> > > what is going on?
> >
> > If PHP says pg_connect is undefined, then the php the RAQ is running isn't
> > compiled for postgresql connectivity.
> >
> > There are two common causes of this:
> >
> > 1: You compiled one build of PHP, the RAQ is running on another build.
> >
> > 2: You told PHP to build in postgresql connectivity, it couldn't find the
> > right header file, failed, writing an error message to the screen during
> > configuration, saying something along the lines of "could not find file
> > xxxxx.h" skipping postgresql configuration.
> >
> > PHP will then happily build and run, without postgresql capabilities.
> >
> > Try this:
> >
> > write a web page with this in it:
> >
> >
> > phpinfo();
> > ?>
> >
> > Look through the page to see if it mentions postgresql. At the top will
> > be a list of all the switches it was configged with. If you have a
> > --with-pgsql there, but no pgsql section in phpinfo, then the configure
> > script couldn't find the right headers. Make sure you're running a fairly
> > late model version of both PHP and postgresql, as there was a bit of an
> > issue about a year ago when postgresql changed the name of one of it's
> > connection headers.
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> ---------------------------(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
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html