Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 4AF751337BEC for ; Thu, 7 Apr 2011 14:53:06 -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 51438-06 for ; Thu, 7 Apr 2011 17:52:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from salmo.appl-ecosys.com (appl-ecosys.com [216.99.206.23]) by mail.postgresql.org (Postfix) with ESMTP id 9F8341337BFA for ; Thu, 7 Apr 2011 14:52:47 -0300 (ADT) Received: by salmo.appl-ecosys.com (Postfix, from userid 1000) id E83C137BC6; Thu, 7 Apr 2011 10:52:46 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by salmo.appl-ecosys.com (Postfix) with ESMTP id E037E37B42 for ; Thu, 7 Apr 2011 10:52:46 -0700 (PDT) Date: Thu, 7 Apr 2011 10:52:46 -0700 (PDT) From: Rich Shepard To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 In-Reply-To: <201104071042.05559@hal.medialogik.com> Message-ID: References: <201104070951.36063@hal.medialogik.com> <201104071042.05559@hal.medialogik.com> User-Agent: Alpine 2.00 (LNX 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/12 X-Sequence-Number: 4174 On Thu, 7 Apr 2011, Alan Hodgson wrote: > What is @authmethod@? That looks like a substitution parameter from > something? Alan, Oops! Copied tail of wrong file. It's not at the end of /usr/local/pgsql/data/pg_hba.conf. That has: # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust > Try changing 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. That's what it is: trust. Rich