Received: from smtp0.telegraaf.net (smtp0.telegraaf.net [217.196.45.130]) by postgresql.org (Postfix) with ESMTP id 713D2475B5E for ; Mon, 22 Apr 2002 08:42:48 -0400 (EDT) Received: from server9.telegraafnet.nl (server9.telegraafnet.nl [192.168.1.9]) by smtp0.telegraaf.net (Postfix) with ESMTP id 38DFC439B2; Mon, 22 Apr 2002 14:42:51 +0200 (CEST) Received: from there (c22601.ws.tem.nl [192.168.1.61]) by server9.telegraafnet.nl (8.11.1/8.11.1/Debian 8.11.0-6) with SMTP id g3MCgrB04858; Mon, 22 Apr 2002 14:42:53 +0200 Message-Id: <200204221242.g3MCgrB04858@server9.telegraafnet.nl> X-Authentication-Warning: server9.telegraafnet.nl: Host c22601.ws.tem.nl [192.168.1.61] claimed to be there Content-Type: text/plain; charset="iso-8859-1" From: Ferdinand Smit To: gunnar@gunix.mine.nu, pgsql-admin@postgresql.org Subject: Re: Connection problem Date: Mon, 22 Apr 2002 14:42:48 +0200 X-Mailer: KMail [version 1.3.2] References: <02042109351701.08765@fire> In-Reply-To: <02042109351701.08765@fire> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200204/196 X-Sequence-Number: 4084 On Sunday 21 April 2002 09:35, Gunnar wrote: > I'm having problems connecting to my postgresql 7.2.1 running on my Debian > Linux box. > > (as root) > $ psql template1 foobar > psql: FATAL 1: IDENT authentication failed for user "foobar" > > Could anybody tell me what the problem is? > The user "foobar" is created with the createuser command without any > problem. > > Here is the pg_hba.conf > > local all ident sameuser > local all trust I think that postgres only uses the first line and that line says that postgres uses the ident autentication (without a password if the user is the same). This means that the user MUST exist in the /etc/passwd. The second line (not used because the first is the same) allows al users without a password. So remove the first line or add user to passwd. Ferdinand