X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E366B3B4AE8 for ; Thu, 23 Dec 2004 20:29:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53900-10 for ; Thu, 23 Dec 2004 20:29:15 +0000 (GMT) Received: from graciousstyle.com (mail.graciousstyle.com [66.199.249.234]) by svr1.postgresql.org (Postfix) with ESMTP id 2AE9A3B4AE1 for ; Thu, 23 Dec 2004 20:29:16 +0000 (GMT) Received: from [192.168.1.105] (localdevelopmentserver.com [70.33.126.86]) (authenticated bits=0) by graciousstyle.com (8.12.11/8.12.11) with ESMTP id iBNKTFMa017308 for ; Thu, 23 Dec 2004 12:29:15 -0800 Message-ID: <41CB2A6B.8050609@graciousstyle.com> Date: Thu, 23 Dec 2004 12:28:27 -0800 From: Si Chen Reply-To: schen@graciousstyle.com Organization: Gracious Style User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_hba.conf and password authentication problem Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/230 X-Sequence-Number: 15816 I am having a really strange password authentication problem. I created a user with $ createuser -W myuser and a database with $ createdb mydb Then, I put in /var/lib/pgsql/data/pg_hba.conf: host mydb myuser 127.0.0.1 255.255.255.255 password Yet whenever I try to login to the database using either JDBC or the command line: $ psql -W mydb -U myuser -h 127.0.0.1 and enter the correct password (believe me--it was correct!) I get the psql: FATAL: Password authentication failed for user "myuser" Could it be a mis-specified IP or netmask combination? I have the exact same database and user on another server where everything works properly. (I'm trying to set up a backup server.) On the main server where the password authentication works, I have in /etc/hosts 127.0.0.1 localhost localhost.localdomain and a $ /sbin/ifconfig gives lo inet addr: 127.0.0.1 Mask 255.0.0.0 On the backup server, I have in /etc/hosts 127.0.0.1 localhost and $ /sbin/ifconfig lo inet addr: 127.0.0.1 Mask 255.0.0.0 The IP addresses themselves have different netmasks of 255.255.255.248 and 255.255.255.128. Where should I be looking for the source of this problem? Sorry but I couldn't find anything about it in the documentation or online and don't even know where to start. Thanks in advance! Si Chen