X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 06F369DCE0C for ; Thu, 12 Jan 2006 16:27:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84239-04 for ; Thu, 12 Jan 2006 16:27:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id EEC059DCE0E for ; Thu, 12 Jan 2006 16:27:49 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k0CKRka9010366 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 12 Jan 2006 13:27:48 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k0CKRjs5022812; Thu, 12 Jan 2006 13:27:45 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k0CKRjvf022811; Thu, 12 Jan 2006 13:27:45 -0700 (MST) (envelope-from mfuhr) Date: Thu, 12 Jan 2006 13:27:45 -0700 From: Michael Fuhr To: Torsten Mager Cc: pgsql-interfaces@postgresql.org Subject: Re: [libpq] Password authentication failed for user Message-ID: <20060112202745.GA84415@winnie.fuhr.org> References: <43C65F71.7060407@nugmbh.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43C65F71.7060407@nugmbh.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.094 required=5 tests=[AWL=0.094] X-Spam-Score: 0.094 X-Spam-Level: X-Archive-Number: 200601/29 X-Sequence-Number: 5945 On Thu, Jan 12, 2006 at 02:53:53PM +0100, Torsten Mager wrote: > In one case everything is ok and the connection to the database works. > > The other program does not work fine, the error-message "Password > authentication failed for user" appears. If i change the configuration > of the server in "pg_hba.conf" from "md5" to "password", everything > works fine too. > > What is the problem?!? What's different about how the two programs connect to the database? Apparently something's different; figure out what that is and you'll be closer to finding the problem. Are the programs connecting to the same database (not just to the same server, but to the same database on that server)? Are they connecting as the same user? -- Michael Fuhr