Re: pg calls not working from within Apache

Hi,
PHP is loaded as Apache's module or CGI? Remember that this module is=20
not the same that the script interpreter. You can compare the phpinfo()=20
output from both. You have postgresql client libraries in this machine?


bp1974@comcast.net escribi=F3:

>Hi,
> I am trying to get a PostGresql <-->PHP<-->Apache working and am runni=
ng to the well documented problem of :
>
>Fatal error: Call to undefined function: pg_connect() in /var/www/html/d=
bview.php on line 14
>
>I have checked and double checked that php is compiled in with pgsql. Li=
st of compiled in modules looks like:
>[PHP Modules]
>SPL
>SQLite
>SimpleXML
>calendar
>ctype
>dba
>dom
>ftp
>gettext
>iconv
>libxml
>openssl
>pcre
>pgsql <---
>posix
>session
>soap
>standard
>tokenizer
>xml
>zlib
>
>Apache and PHP seem to work, as evidenced by running the basic phpinfo()=
script. I also checked wheter pg calls work when running from the scrip=
t interpreter, i.e. running a php script.=20
>However, I am not able to get the same script running from within a brow=
ser.=20
>Can anyone point out what little bit of the puzzle I might be missing?
>I have pgsql 7.4.3 PHP 4.3.2 and Apache 2.0.
>
>Any help appreciated.
>
>thanks,
>Balaji
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if yo=
ur
> joining column's datatypes do not match
> =20
>

--=20
Andr=E9s Ferrando
Centro de Desarrollo de Sistemas
Secretaria de Industria, Comercio y PyME


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

pg calls not working from within Apache

Hi,
I am trying to get a PostGresql <-->PHP<-->Apache working and am running to the well documented problem of :

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

I have checked and double checked that php is compiled in with pgsql. List of compiled in modules looks like:
[PHP Modules]
SPL
SQLite
SimpleXML
calendar
ctype
dba
dom
ftp
gettext
iconv
libxml
openssl
pcre
pgsql <---
posix
session
soap
standard
tokenizer
xml
zlib

Apache and PHP seem to work, as evidenced by running the basic phpinfo() script. I also checked wheter pg calls work when running from the script interpreter, i.e. running a php script.
However, I am not able to get the same script running from within a browser.
Can anyone point out what little bit of the puzzle I might be missing?
I have pgsql 7.4.3 PHP 4.3.2 and Apache 2.0.

Any help appreciated.

thanks,
Balaji

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Re: pg calls not working from within Apache

Going out on a limb here. Does the user that apache runs under have access
to the pg so files?

Thom Dyson
Director of Information Services
Sybex, Inc.



pgsql-php-owner@postgresql.org wrote on 08/04/2004 10:16:06 AM:

> Hi,
> I am trying to get a PostGresql <-->PHP<-->Apache working and am
> running to the well documented problem of :
>
> Fatal error: Call to undefined function: pg_connect() in
> /var/www/html/dbview.php on line 14


---------------------------(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: pg calls not working from within Apache

bp1974@comcast.net wrote:

>Hi,
> I am trying to get a PostGresql <-->PHP<-->Apache working and am running to the well documented problem of :
>
>Fatal error: Call to undefined function: pg_connect() in /var/www/html/dbview.php on line 14
>
>
>
Call to undefined function, means the pgsql extension is infact not
there. Do you have multiple php's on this machine? Do you have a
misconfigured php.ini lying around in your root directory, that php will
read when its been run from apache. Remember php running from apache
will read configuration files that php running from CLI wouldn't.

cheers

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: pg calls not working from within Apache

Thank You. I got it working shortly after posting it here. I indeed had=20
multiple PHPs on the system and the one apache was detecting did not have=
=20
pgsql support built in. It was just a matter of deleting the "wrong" php=20
and things started working like a charm.



On Thu, 05 Aug 2004 09:47:07 +0200, Justin Wyer wrot=
e:

> bp1974@comcast.net wrote:
>
>> Hi,
>> I am trying to get a PostGresql <-->PHP<-->Apache working and am=20
>> running to the well documented problem of :
>>
>> Fatal error: Call to undefined function: pg_connect() in=20
>> /var/www/html/dbview.php on line 14
>>
>>
> Call to undefined function, means the pgsql extension is infact not=20
> there. Do you have multiple php's on this machine? Do you have a=20
> misconfigured php.ini lying around in your root directory, that php wil=
l=20
> read when its been run from apache. Remember php running from apache=20
> will read configuration files that php running from CLI wouldn't.
>
> cheers
>
> ---------------------------(end of broadcast)--------------------------=
-
> TIP 4: Don't 'kill -9' the postmaster



--=20
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: pg calls not working from within Apache

Balaji Prasad wrote:

> Thank You. I got it working shortly after posting it here. I indeed
> had multiple PHPs on the system and the one apache was detecting did
> not have pgsql support built in. It was just a matter of deleting the
> "wrong" php and things started working like a charm.
>
good stuff, glad i could help

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings