X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E9794D1C4BC for ; Thu, 7 Aug 2003 06:37:18 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 41974-04 for ; Thu, 7 Aug 2003 03:35:54 -0300 (ADT) Received: from dns.robbyrussell.com (12-224-181-23.client.attbi.com [12.224.181.23]) by svr1.postgresql.org (Postfix) with ESMTP id 505D4D1C4BF for ; Thu, 7 Aug 2003 03:37:06 -0300 (ADT) Received: from commandprompt.com (unknown [192.168.1.252]) by dns.robbyrussell.com (Postfix) with ESMTP id 8C60E94278; Wed, 6 Aug 2003 23:37:01 -0700 (PDT) Message-ID: <3F31C960.30309@commandprompt.com> Date: Wed, 06 Aug 2003 23:37:04 -0400 From: Robby Russell Organization: Command Prompt, Inc User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5b) Gecko/20030727 Thunderbird/0.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Cath Lawrence Cc: pgsql-php@postgresql.org Subject: Re: authentication question References: <43AF36DA-C8A0-11D7-9EC1-00039390F614@anu.edu.au> In-Reply-To: <43AF36DA-C8A0-11D7-9EC1-00039390F614@anu.edu.au> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/20 X-Sequence-Number: 2197 Cath Lawrence wrote: > On Thursday, August 7, 2003, at 01:12 PM, Robby Russell wrote: > >> Cath Lawrence wrote: >> I'm not sure if this will help you or not, but try adding this to the >> bottom (seen this as a common practice) >> # reject all connections from all hosts not granted above >> host all 0.0.0.0 0.0.0.0 reject > > > D'oh! That does it. Thanks Robby. > Blindly copy'n'paste-ing a line with the wrong netmask did NOT help! > > But while I'm here - how does PHP connect? If rejecting connections > from the local machine and from 127.0.0.1 didn't do the trick, why > not? (Or is that getting into network issues and I needed the host's > IP address?) Cath, It depends, is the php (on apache I assume) running on the same machine? If it is, than usually rejecting 127.0.0.1 will do the trick (given that the /etc/hosts file has an entry for localhost). If it's a remote connection, than you will need to look at all your configuration settings to try and determine this issue. Glad that other bit of info helped though. -- Robby Russell, | Sr. Administrator / Lead Programmer Command Prompt, Inc. | http://www.commandprompt.com rrussell@commandprompt.com | Telephone: (503) 222.2783