X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 90EE8D1B352 for ; Wed, 19 May 2004 17:28:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 93178-06 for ; Wed, 19 May 2004 17:28:38 -0300 (ADT) Received: from web12903.mail.yahoo.com (web12903.mail.yahoo.com [216.136.174.70]) by svr1.postgresql.org (Postfix) with SMTP id 01027D1B1AA for ; Wed, 19 May 2004 17:28:36 -0300 (ADT) Message-ID: <20040519202834.15105.qmail@web12903.mail.yahoo.com> Received: from [192.88.67.254] by web12903.mail.yahoo.com via HTTP; Wed, 19 May 2004 13:28:34 PDT Date: Wed, 19 May 2004 13:28:34 -0700 (PDT) From: Bill Chandler Subject: Missing or errooneous pg_hba.conf file To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS, MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200405/200 X-Sequence-Number: 13516 Hello, Running 7.4.2 on Solaris 8 (binaries were built on a different Solaris 8 box). I keep getting the following message when trying to connect to server: FATAL: missing or erroneous pg_hba.conf file HINT: see server log for details. Server log contains message: LOG: invalid entry in pg_hba.conf file at line 60, token "255.255.255.255" The only change I've made was to postgresql.conf to change "tcpip_socket = true". I have not modified pg_hba.conf at all. Line 60 is the default 'host' entry for 127.0.0.1. The token in question is the IP-MASK field. I have found that if I change this value to anything other than "255.255.255.255" (e.g. "255.255.255.254") the message goes away. I get the same message if I add other lines with IP-MASK=255.255.255.255 to the pg_hba.conf file. It just doesn't seem to like '255.255.255.255' for some reason. I get the error using both the 'psql -h ...' command and trying to connect via JDBC. Incidentally, I saw the same problem running in 7.4.1. I ended up just commenting out line 60 to get around it. But now I need IP-MASK=255.255.255.255 so I need to get it resolved. Interestingly the same 7.4.1 binary running on a different machine did not exhibit the problem. Could it be a Solaris patch level thing? thanks in advance, Bill billybobc1210@yahoo.com __________________________________ Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/