Re: Need help urgent!!!

Hi,

I installed PHPPGAdmin, but when I try open the same I am getting the
following message.

"Your PHP installation does not support PostgreSQL. You need to recompile
PHP using the --with-pgsql configure option."

OS: Windows XP Professional

PHP5 is working fine

Apache also is working fine version 2.2

Please guide me on this

Thanks

Dileep

On 10/07/2009 06:39, Dileep A.V wrote:
> "Your PHP installation does not support PostgreSQL. You need to recompile
> PHP using the --with-pgsql configure option."

You need to enable PostgreSQL support in your PHP installation. On
Windows, you do this by uncommenting the appropriate line in php.ini -

extension=php_pgsql.dll

-or something like that.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Hi Ray,

Thanks for the reply and your time. There is no statement like:

extension=php_pgsql.dll in my php.ini file. Anyway I have added a new line
for the same. Then I restarted the Apache Web Server(Apache). But after that
When I try to open the phppgadmin, url is http://localhost:8081/phpPgAdmin/,

I am getting the following error:

Your PHP installation does not support PostgreSQL. You need to recompile PHP
using the --with-pgsql configure option.

What may be the problem, Kindly help me.

Thanks & Regards
Dileep.

-----Original Message-----
From: Raymond O'Donnell [mailto:rod(at)iol(dot)ie]
Sent: Friday, July 10, 2009 3:15 PM
To: dileepav(at)thirdeyetek(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Need help urgent!!!

On 10/07/2009 06:39, Dileep A.V wrote:
> "Your PHP installation does not support PostgreSQL. You need to recompile
> PHP using the --with-pgsql configure option."

You need to enable PostgreSQL support in your PHP installation. On
Windows, you do this by uncommenting the appropriate line in php.ini -

extension=php_pgsql.dll

-or something like that.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

PFA to see the php.ini file that I have used here.

Thanks & Regards
Dileep.

-----Original Message-----
From: Raymond O'Donnell [mailto:rod(at)iol(dot)ie]
Sent: Friday, July 10, 2009 3:15 PM
To: dileepav(at)thirdeyetek(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Need help urgent!!!

On 10/07/2009 06:39, Dileep A.V wrote:
> "Your PHP installation does not support PostgreSQL. You need to recompile
> PHP using the --with-pgsql configure option."

You need to enable PostgreSQL support in your PHP installation. On
Windows, you do this by uncommenting the appropriate line in php.ini -

extension=php_pgsql.dll

-or something like that.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On 10/07/2009 12:24, Dileep A.V wrote:
> Hi Ray,
>
> Thanks for the reply and your time. There is no statement like:
>
> extension=php_pgsql.dll in my php.ini file. Anyway I have added a new line
> for the same. Then I restarted the Apache Web Server(Apache). But after that
> When I try to open the phppgadmin, url is http://localhost:8081/phpPgAdmin/,
>
> I am getting the following error:
>
> Your PHP installation does not support PostgreSQL. You need to recompile PHP
> using the --with-pgsql configure option.

Are you sure that PHP is using the correct php.ini? Doing a phpinfo()
will tell you, somewhere in the first few blocks of information.

Also, have you told PHP where to look for dynamic extensions? There's an
option for that in php.ini also; on my laptop, for example, it's -

extension_dir = "c:\php\ext"

- under the "Paths and directories" section of php.ini.

Finally, check that php_pgsql.dll exists, and that the PHP user has
execute permissions on it.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

On 10/07/2009 13:12, Dileep A.V wrote:
> Next is last time I have not told PHP, where to look for extensions, this
> time I have told that one also, in my laptop also, the location is same " so
> I have included this statement:
> extension_dir = "c:\php\ext", then restarted the web server. As advised by
> you I have included this under "paths and directories".
>
> I found that php_pgsql.dll also exists in the following path:
>
> C:\PHP\ext.
>
> After doing all these things I have done the reset of Apache, and then again
> started running the phppgadmin, but still getting the same error:
>
> "Your PHP installation does not support PostgreSQL. You need to recompile
> PHP using the --with-pgsql configure option."

Hi Dileep,

Have you tried enabling any of the other dynamic extensions, to see if
they work? If they do, there'll be a section for them in the phpinfo()
output. - Try cURL, for example, AFAIK it isn't enabled by default.

I'm afraid I'm out of ideas at this point... I remember once I had
problems with this same problem, and never did get to the bottom of it.
I got around it by rolling back to an earlier version of PHP which did
work. I see you're on PHP 5.2.10; you could try 5.3 and see if that
works for you - obviously, you have to make the same changes in the .ini
file.

Good luck!

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

There is a bug on the php pg libraries for windows.
Apparently they are having an issue loading the libraries (started about
a year ago with an apparent change in the way the p libraries are
compiled)..
On my windows test installations I have had to downgrade to earlier
versions of PHP.

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-
> owner(at)postgresql(dot)org] On Behalf Of Raymond O'Donnell
> Sent: Friday, July 10, 2009 6:14 AM
> To: dileepav(at)thirdeyetek(dot)com
> Cc: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Need help urgent!!!
>
> On 10/07/2009 13:12, Dileep A.V wrote:
> > Next is last time I have not told PHP, where to look for extensions,
> this
> > time I have told that one also, in my laptop also, the location is
> same " so
> > I have included this statement:
> > extension_dir = "c:\php\ext", then restarted the web server. As
> advised by
> > you I have included this under "paths and directories".
> >
> > I found that php_pgsql.dll also exists in the following path:
> >
> > C:\PHP\ext.
> >
> > After doing all these things I have done the reset of Apache, and
> then again
> > started running the phppgadmin, but still getting the same error:
> >
> > "Your PHP installation does not support PostgreSQL. You need to
> recompile
> > PHP using the --with-pgsql configure option."
>
> Hi Dileep,
>
> Have you tried enabling any of the other dynamic extensions, to see if
> they work? If they do, there'll be a section for them in the phpinfo()
> output. - Try cURL, for example, AFAIK it isn't enabled by default.
>
> I'm afraid I'm out of ideas at this point... I remember once I had
> problems with this same problem, and never did get to the bottom of
it.
> I got around it by rolling back to an earlier version of PHP which
did
> work. I see you're on PHP 5.2.10; you could try 5.3 and see if that
> works for you - obviously, you have to make the same changes in the
> .ini
> file.
>
> Good luck!
>
> Ray.
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
I think you're on the wrong list<br>
<br>
<br>
On 07/13/09 15:46, Benjamin Krajmalnik wrote:
<blockquote
cite="mid:F4E6A2751A2823418A21D4A160B689883FCB4C(at)fletch(dot)stackdump(dot)local"
type="cite">
<pre wrap="">There is a bug on the php pg libraries for windows.
Apparently they are having an issue loading the libraries (started about
a year ago with an apparent change in the way the p libraries are
compiled)..
On my windows test installations I have had to downgrade to earlier
versions of PHP.

</pre>
<blockquote type="cite">
<pre wrap="">-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:pgadmin-support-owner(at)postgresql(dot)org">pgadmin-support-owner(at)postgresql(dot)org</a> [<a class="moz-txt-link-freetext" href="mailto:pgadmin-support">mailto:pgadmin-support</a>-
<a class="moz-txt-link-abbreviated" href="mailto:owner(at)postgresql(dot)org">owner(at)postgresql(dot)org</a>] On Behalf Of Raymond O'Donnell
Sent: Friday, July 10, 2009 6:14 AM
To: <a class="moz-txt-link-abbreviated" href="mailto:dileepav(at)thirdeyetek(dot)com">dileepav(at)thirdeyetek(dot)com</a>
Cc: <a class="moz-txt-link-abbreviated" href="mailto:pgadmin-support(at)postgresql(dot)org">pgadmin-support(at)postgresql(dot)org</a>
Subject: Re: [pgadmin-support] Need help urgent!!!

On 10/07/2009 13:12, Dileep A.V wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Next is last time I have not told PHP, where to look for extensions,
</pre>
</blockquote>
<pre wrap="">this
</pre>
<blockquote type="cite">
<pre wrap="">time I have told that one also, in my laptop also, the location is
</pre>
</blockquote>
<pre wrap="">same " so
</pre>
<blockquote type="cite">
<pre wrap="">I have included this statement:
extension_dir = "c:\php\ext", then restarted the web server. As
</pre>
</blockquote>
<pre wrap="">advised by
</pre>
<blockquote type="cite">
<pre wrap="">you I have included this under "paths and directories".

I found that php_pgsql.dll also exists in the following path:

C:\PHP\ext.

After doing all these things I have done the reset of Apache, and
</pre>
</blockquote>
<pre wrap="">then again
</pre>
<blockquote type="cite">
<pre wrap="">started running the phppgadmin, but still getting the same error:

"Your PHP installation does not support PostgreSQL. You need to
</pre>
</blockquote>
<pre wrap="">recompile
</pre>
<blockquote type="cite">
<pre wrap="">PHP using the --with-pgsql configure option."
</pre>
</blockquote>
<pre wrap="">Hi Dileep,

Have you tried enabling any of the other dynamic extensions, to see if
they work? If they do, there'll be a section for them in the phpinfo()
output. - Try cURL, for example, AFAIK it isn't enabled by default.

I'm afraid I'm out of ideas at this point... I remember once I had
problems with this same problem, and never did get to the bottom of
</pre>
</blockquote>
<pre wrap=""><!---->it.
</pre>
<blockquote type="cite">
<pre wrap="">I got around it by rolling back to an earlier version of PHP which
</pre>
</blockquote>
<pre wrap=""><!---->did
</pre>
<blockquote type="cite">
<pre wrap="">work. I see you're on PHP 5.2.10; you could try 5.3 and see if that
works for you - obviously, you have to make the same changes in the
.ini
file.

Good luck!

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
<a class="moz-txt-link-abbreviated" href="mailto:rod(at)iol(dot)ie">rod(at)iol(dot)ie</a>
Galway Cathedral Recitals: <a class="moz-txt-link-freetext" href="http://www.galwaycathedral.org/recitals">http://www.galwaycathedral.org/recitals</a>
------------------------------------------------------------------

--
Sent via pgadmin-support mailing list (<a class="moz-txt-link-abbreviated" href="mailto:pgadmin-support(at)postgresql(dot)org">pgadmin-support(at)postgresql(dot)org</a>)
To make changes to your subscription:
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/mailpref/pgadmin-support">http://www.postgresql.org/mailpref/pgadmin-support</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
</body>
</html>