Обсуждение: Need help urgent!!!
<div class="Section1"><p class="MsoNormal">Hi,<p class="MsoNormal"> <p class="MsoNormal">I installed PHPPGAdmin, but whenI try open the same I am getting the following message.<p class="MsoNormal"> <p class="MsoNormal">“Your PHP installationdoes not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.”<p class="MsoNormal"> <pclass="MsoNormal">OS: Windows XP Professional<p class="MsoNormal">PHP5 is working fine<p class="MsoNormal">Apachealso is working fine version 2.2<p class="MsoNormal"> <p class="MsoNormal">Please guide me on this<pclass="MsoNormal"> <p class="MsoNormal">Thanks<p class="MsoNormal">Dileep</div>
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@iol.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@iol.ie] Sent: Friday, July 10, 2009 3:15 PM To: dileepav@thirdeyetek.com Cc: pgadmin-support@postgresql.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@iol.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@iol.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@iol.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@postgresql.org [mailto:pgadmin-support- > owner@postgresql.org] On Behalf Of Raymond O'Donnell > Sent: Friday, July 10, 2009 6:14 AM > To: dileepav@thirdeyetek.com > Cc: pgadmin-support@postgresql.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@iol.ie > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support
I think you're on the wrong list<br /><br /><br /> On 07/13/09 15:46, Benjamin Krajmalnik wrote: <blockquote cite="mid:F4E6A2751A2823418A21D4A160B689883FCB4C@fletch.stackdump.local"type="cite"><pre wrap="">There is a bug on the phppg 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@postgresql.org">pgadmin-support-owner@postgresql.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@postgresql.org">owner@postgresql.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@thirdeyetek.com">dileepav@thirdeyetek.com</a> Cc: <a class="moz-txt-link-abbreviated" href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.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="">timeI 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><blockquotetype="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><blockquotetype="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><blockquotetype="cite"><pre wrap="">PHP using the --with-pgsql configure option." </pre></blockquote><pre wrap="">HiDileep, 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><blockquotetype="cite"><pre wrap="">I got around it by rolling back to an earlier version of PHP which </pre></blockquote><prewrap="">did </pre><blockquote type="cite"><pre wrap="">work. I see you're on PHP 5.2.10; you couldtry 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@iol.ie">rod@iol.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@postgresql.org">pgadmin-support@postgresql.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><prewrap=""> </pre></blockquote><br />
PFA to see the php.ini file that I have used here. Thanks & Regards Dileep. -----Original Message----- From: Raymond O'Donnell [mailto:rod@iol.ie] Sent: Friday, July 10, 2009 3:15 PM To: dileepav@thirdeyetek.com Cc: pgadmin-support@postgresql.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@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------