Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A3453650EA3 for ; Wed, 25 Jun 2008 12:50:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10283-01 for ; Wed, 25 Jun 2008 12:50:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ag-out-0708.google.com (ag-out-0708.google.com [72.14.246.245]) by postgresql.org (Postfix) with ESMTP id 79BCE650E9E for ; Wed, 25 Jun 2008 12:50:29 -0300 (ADT) Received: by ag-out-0708.google.com with SMTP id 31so27056309agc.5 for ; Wed, 25 Jun 2008 08:50:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=wJ/9rFxAG2it3qtJsUU0i44MBW7glhI9MTe3vGa34C4=; b=LdKPJneg2JDMLYrGJvVwmeR0XFxFnf2NwDZn4QHNnNdSP/EpHnjZaATnUCqC/4wOQ5 5Jur3nzG5gMT8Ee9cqnPD1IwSLp05etMbcKw38j1xLASHPqpe16BXHLPktO5BM0Aa2ZD 1mlTzqtQVh8STTUKuVDCb4wA5m0JdbK+NmM84= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=brCelMO5ERfg0vlgVToDFgDhQYGVVkq/EXgvAxm0LXTvhYQLvzwi7WhBxYi1S6BXjN UOYNUCa2sfn8cTbLCWlG624Ygk3T0sVk+Gwmv1lSrV3RmhyYoZrzDHiapvL+ENCO4z2N sbgft0T03JTpbI/wz+zwy/bMDURF1aTlhK868= Received: by 10.100.251.11 with SMTP id y11mr18612181anh.114.1214409027062; Wed, 25 Jun 2008 08:50:27 -0700 (PDT) Received: by 10.101.70.4 with HTTP; Wed, 25 Jun 2008 08:50:27 -0700 (PDT) Message-ID: Date: Wed, 25 Jun 2008 11:50:27 -0400 From: "Chandra ASGI Tech" To: "Vince Vielhaber" Subject: Re: Can't connect to postgresql using php Cc: "roche magsayo" , Chris , pgsql-php@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9402_10008279.1214409027056" References: <873a98c60806242327v521393cen2d13ee196d9122d0@mail.gmail.com> <4861EBDB.5010401@gmail.com> <873a98c60806250237m7519ccdaid3ce993016aa9e55@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200806/15 X-Sequence-Number: 3862 ------=_Part_9402_10008279.1214409027056 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Vince, Can you please specify the version of Apache and PHP? It seems there is a problem with the pgsql extension in PHP5.2.6 - as Jason Minion had mentioned in another thread, please refer http://bugs.php.net/bug.php?id=44905. I am using WAMPServer 2 (http://www.wampserver.com/en/index.php) - which provides a good development environment for Windows based Apache - PHP. It allows you to install almost all the existing releases( http://www.wampserver.com/en/add-ons.php) of Apache, PHP (and MySQL) and configure them easily - so that you can enable the MySQL or PgSQL modules as you want in your PHP extensions. I have PostgreSQL 8.2.4 and WampServer2 (Apache 2.2.6 and PHP 5.2.5) installed on my XP laptop and it works fine. I also use phppgadmin ( http://sourceforge.net/projects/phppgadmin) which is similar to but not as much userfriendly (atleast) like phpmyadmin. Though I have not used myself, I still know that WampServer allows you to install * any number of * latest releases of Apache and PHP and configure and switch between them. Thanks and Regards, Chandra-ASGI On Wed, Jun 25, 2008 at 7:05 AM, Vince Vielhaber wrote: > On Wed, 25 Jun 2008, roche magsayo wrote: > > What error do you get? >>> >> This is the error i get: >> =========================== >> The website cannot display the page >> HTTP 500 >> Most likely causes: >> The website is under maintenance. >> The website has a programming error. >> ========================== >> >> Have you installed the php-pgsql.dll file and also edited the php.ini >>> file to include it? >>> >> I've already installed it and edited the php.ini >> [PHP_PGSQL] >> extension=php_pgsql.dll >> >> Have you restarted apache? >>> >> i've restarted many time, still i got those... >> >> Does postgresql show up in a phpinfo() page? >>> >> phpinfo(), it's work. >> > > Does this mean there's a section in phpinfo() for postgresql? > > If it does, post the code you're using to connect. > > Vince. > -- > Michigan VHF Corp. http://www.nobucks.net/ http://www.CDupe.com/ > Bringing the world a little coloser to your business > > > > > -- > Sent via pgsql-php mailing list (pgsql-php@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-php > ------=_Part_9402_10008279.1214409027056 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi Vince,
 
Can you please specify the version of Apache and PHP?  It seems there is a problem with the pgsql extension in PHP5.2.6 - as Jason Minion had mentioned in another thread, please refer http://bugs.php.net/bug.php?id=44905.
I am using WAMPServer 2 (http://www.wampserver.com/en/index.php) - which provides a good development environment for Windows based Apache - PHP.  It allows you to install almost all the existing releases(http://www.wampserver.com/en/add-ons.php) of Apache, PHP (and MySQL)  and configure them easily - so that you can enable the MySQL or PgSQL modules as you want in your PHP extensions.
 
I have PostgreSQL 8.2.4 and WampServer2 (Apache 2.2.6 and PHP 5.2.5) installed on my XP laptop and it works fine. I also use phppgadmin (http://sourceforge.net/projects/phppgadmin) which is similar to but not as much userfriendly (atleast) like phpmyadmin.
 
Though I have not used myself, I still know that WampServer allows you to install * any number of * latest releases of Apache and PHP and configure and switch between them.
 
Thanks and Regards,
Chandra-ASGI
 

On Wed, Jun 25, 2008 at 7:05 AM, Vince Vielhaber <vev@michvhf.com> wrote:
On Wed, 25 Jun 2008, roche magsayo wrote:

What error do you get?
This is the error i get:
===========================
The website cannot display the page
HTTP 500
 Most likely causes:
The website is under maintenance.
The website has a programming error.
==========================

Have you installed the php-pgsql.dll file and also edited the php.ini
file to include it?
I've already installed it and edited the php.ini
[PHP_PGSQL]
extension=php_pgsql.dll

Have you restarted apache?
i've restarted many time, still i got those...

Does postgresql show up in a phpinfo() page?
phpinfo(), it's work.

Does this mean there's a section in phpinfo() for postgresql?

If it does, post the code you're using to connect.

Vince.
--
 Michigan VHF Corp.   http://www.nobucks.net/   http://www.CDupe.com/
          Bringing the world a little coloser to your business




--
Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

------=_Part_9402_10008279.1214409027056--