Apache, Php and postgresql on windows

Hello Everyone,

I have installed apache, php and postgresql on my system. Now i am calling
pg_connect() function. If i run the php script through command line
everything is working fine. But when i run the same script through apache 2,
it gives me an error

Fatal error: Call to undefined function pg_connect()

It seems in apache, php isn't able to access php_pgsql.dll, Where as in
command line execution it is able to.

What can be a possible fix for this.

-Abhishek

____________________________________________________________ _____
NRIs, Free Money Transfers to over 30 Million Visa Cards in India.
http://creative.mediaturf.net/creatives/icicibank/MSN_VISA_T OL.htm


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

Re: Apache, Php and postgresql on windows

By default the pgsql functions are not enabled in php on windows. Check your
php.ini file, and if necessary, import the pgsql.dll file from the full zip
(not the cgi-based install) into wherever you're housing your php
extensions, then look for the line "extension=php_pgsql.dll" in your php.ini
file and uncomment it (remove the ";" from in front of it.

Then the pg_ functions should be available to you.

Z-

-----Original Message-----
From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]
On Behalf Of Abhishek Goyal
Sent: Friday, January 20, 2006 11:57 AM
To: pgsql-php@postgresql.org
Subject: [PHP] Apache, Php and postgresql on windows

Hello Everyone,

I have installed apache, php and postgresql on my system. Now i am calling
pg_connect() function. If i run the php script through command line
everything is working fine. But when i run the same script through apache 2,

it gives me an error

Fatal error: Call to undefined function pg_connect()

It seems in apache, php isn't able to access php_pgsql.dll, Where as in
command line execution it is able to.

What can be a possible fix for this.

-Abhishek

____________________________________________________________ _____
NRIs, Free Money Transfers to over 30 Million Visa Cards in India.
http://creative.mediaturf.net/creatives/icicibank/MSN_VISA_T OL.htm


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


--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/235 - Release Date: 1/19/2006



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

Re: Apache, Php and postgresql on windows

--- Abhishek Goyal wrote:

> Hello Everyone,
>=20
> I have installed apache, php and postgresql on my
> system. Now i am calling=20
> pg_connect() function. If i run the php script
> through command line=20
> everything is working fine. But when i run the same
> script through apache 2,=20
> it gives me an error
>=20
> Fatal error: Call to undefined function pg_connect()
>=20
> It seems in apache, php isn't able to access
> php_pgsql.dll, Where as in=20
> command line execution it is able to.
>=20
> What can be a possible fix for this.
>=20
> -Abhishek
>=20

These questions can be tough b/c we don't know exactly
what you did during the install.

did you enable php_pgsql.dll in apache's config file
(httpd.conf)?

yuou may want to google the error message. i had a
problem with php and apache b/c i installed it as cgi
and i had to change a setting to get it to work -
which wasn't, at least at the time, in the
instructions.

i created and posted some pretty current and complete
apache, php and postgresql winxp install instruction
here...

http://www.geocities.com/operationsengineer1/

i know it worked on at least one machine... ;-)

good luck.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Apache, Php and postgresql on windows

The problem was finally discovered to be with phpinidir configuration in
httpd.conf. Through command line it was working fine because php was able to
find php.ini in system directory (C:\windows), but apache wasn't able to
find php.ini and thus didn't knew if php should use any extensions.

Thanks everyone for the help,
-Abhishek


>From:
>To: Abhishek Goyal , pgsql-php@postgresql.org
>Subject: Re: [PHP] Apache, Php and postgresql on windows
>Date: Sun, 22 Jan 2006 12:29:46 -0800 (PST)
>
>--- Abhishek Goyal wrote:
>
> > Hello Everyone,
> >
> > I have installed apache, php and postgresql on my
> > system. Now i am calling
> > pg_connect() function. If i run the php script
> > through command line
> > everything is working fine. But when i run the same
> > script through apache 2,
> > it gives me an error
> >
> > Fatal error: Call to undefined function pg_connect()
> >
> > It seems in apache, php isn't able to access
> > php_pgsql.dll, Where as in
> > command line execution it is able to.
> >
> > What can be a possible fix for this.
> >
> > -Abhishek
> >
>
>These questions can be tough b/c we don't know exactly
>what you did during the install.
>
>did you enable php_pgsql.dll in apache's config file
>(httpd.conf)?
>
>yuou may want to google the error message. i had a
>problem with php and apache b/c i installed it as cgi
>and i had to change a setting to get it to work -
>which wasn't, at least at the time, in the
>instructions.
>
>i created and posted some pretty current and complete
>apache, php and postgresql winxp install instruction
>here...
>
>http://www.geocities.com/operationsengineer1/
>
>i know it worked on at least one machine... ;-)
>
>good luck.
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend

____________________________________________________________ _____
Tried the new MSN Messenger? It’s cool! Download now.
http://messenger.msn.com/Download/Default.aspx?mkt=en-in


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