Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 60FAF1337C02 for ; Thu, 7 Apr 2011 14:42:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 84680-06 for ; Thu, 7 Apr 2011 17:42:07 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from zeus.simkin.ca (zeus.simkin.ca [72.51.27.124]) by mail.postgresql.org (Postfix) with ESMTP id E1BBE1337BF2 for ; Thu, 7 Apr 2011 14:42:06 -0300 (ADT) Received: from charon.medialogik.com (S0106000c6eb33e73.vc.shawcable.net [96.49.227.24]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by zeus.simkin.ca (Postfix) with ESMTPSA id 526E4270192 for ; Thu, 7 Apr 2011 10:42:06 -0700 (PDT) From: Alan Hodgson Organization: Simkin Network Consulting To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 Date: Thu, 7 Apr 2011 10:42:05 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.35-25-generic; KDE/4.5.1; i686; ; ) References: <201104070951.36063@hal.medialogik.com> In-Reply-To: X-KMail-Markup: true MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary-01=_tdfnN9J3pMROm6Z" Content-Transfer-Encoding: 7bit Message-Id: <201104071042.05559@hal.medialogik.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/11 X-Sequence-Number: 4173 --Boundary-01=_tdfnN9J3pMROm6Z Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable On April 7, 2011, Rich Shepard wrote: > On Thu, 7 Apr 2011, Alan Hodgson wrote: > > What does your pg_hba.conf file contain? >=20 > Unmodified from the sample: >=20 > # TYPE DATABASE USER CIDR-ADDRESS METHOD >=20 > @remove-line-for-nolocal@# "local" is for Unix domain socket connections > only > @remove-line-for-nolocal@local all all > # IPv4 local connections: > host all all 127.0.0.1/32 =20 > @authmethod@ # IPv6 local connections: > host all all ::1/128 =20 > @authmethod@ >=20 > Rich What is @authmethod@? That looks like a substitution parameter from=20 something? The default that should be in there is I think ident, which probably allows= =20 you to access it as rshepard but not the web server to do so, which is=20 running under a different user. Try changing the auth method on 127.0.0.1/32 to trust (just for testing),= =20 and then if that works set it to md5 and assign a password. =2D-=20 The era of procrastination, of half-measures, of soothing and baffling=20 expedients, of delays, is coming to a close. In its place we are entering a= =20 period of consequences=E2=80=A6 --Boundary-01=_tdfnN9J3pMROm6Z Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable

On April 7,= 2011, Rich Shepard <rshepard@appl-ecosys.com> wrote:

> On Thu= , 7 Apr 2011, Alan Hodgson wrote:

> > W= hat does your pg_hba.conf file contain?

>

> Unm= odified from the sample:

>

> # TYPE= DATABASE USER CIDR-ADDRESS METHOD

>

> @remov= e-line-for-nolocal@# "local" is for Unix domain socket connection= s

> only

> @remov= e-line-for-nolocal@local all all

> # IPv4= local connections:

> host = all all 127.0.0.1/32

> @authm= ethod@ # IPv6 local connections:

> host = all all ::1/128

> @authm= ethod@

>

> Rich

What is @au= thmethod@? That looks like a substitution parameter from something?

The default= that should be in there is I think ident, which probably allows you to acc= ess it as rshepard but not the web server to do so, which is running under = a different user.

Try changin= g the auth method on 127.0.0.1/32 to trust (just for testing), and then if= that works set it to md5 and assign a password.

--

The era of = procrastination, of half-measures, of soothing and baffling expedients, of = delays, is coming to a close. In its place we are entering a period of cons= equences=E2=80=A6

--Boundary-01=_tdfnN9J3pMROm6Z--