From sgnerd@yahoo.com.sg Fri Mar 19 12:39:41 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8757CD1BAC8 for ; Fri, 19 Mar 2004 12:39:41 +0000 (GMT) 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 65253-10 for ; Fri, 19 Mar 2004 08:39:40 -0400 (AST) Received: from smtp106.mail.sc5.yahoo.com (smtp106.mail.sc5.yahoo.com [66.163.169.226]) by svr1.postgresql.org (Postfix) with SMTP id 1ACFAD1B542 for ; Fri, 19 Mar 2004 08:39:36 -0400 (AST) Received: from unknown (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp106.mail.sc5.yahoo.com with SMTP; 19 Mar 2004 12:39:16 -0000 Message-ID: <026601c40daf$442ffcd0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls Date: Fri, 19 Mar 2004 18:09:33 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0263_01C40DDD.54FE9340" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/199 X-Sequence-Number: 17298 This is a multi-part message in MIME format. ------=_NextPart_000_0263_01C40DDD.54FE9340 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, I have installed Linux Fedore and wanted to work with the default installed= postgres 7.3.4 database. I could able to create to create user, but while try to connect, I got the = following error message psql: FATAL 1: IDENT authentication failed for user=20 My pg_hba.conf file looks like below # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD local all all trust host all all 192.168.2.0 255.255.255.0 trust=20 I couldnt understand why. Please shed some light ------=_NextPart_000_0263_01C40DDD.54FE9340 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear Friends,

I have installed Linux Fedore and wanted to work with t= he=20 default installed postgres 7.3.4 database.

I could able to create to create user, but while try to= =20 connect, I got the following error message

psql: FATAL 1: IDENT authentication failed for user

My pg_hba.conf file looks like below

# TYPE DATABASE =20 USER =20 IP-ADDRESS =20 IP-MASK =20 METHOD

local =20 all =20 all = &nb= sp; = =20 trust
host all =20 all 192.168.2.0 255.255.255.0 = ;=20 trust

I couldnt understand why. Please shed some light

<= /FONT>

------=_NextPart_000_0263_01C40DDD.54FE9340-- From martin@bugs.unl.edu.ar Fri Mar 19 13:07:28 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D6301D1E9CD for ; Fri, 19 Mar 2004 13:07:28 +0000 (GMT) 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 77996-08 for ; Fri, 19 Mar 2004 09:07:30 -0400 (AST) Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by svr1.postgresql.org (Postfix) with ESMTP id 9BFE0D1E9B5 for ; Fri, 19 Mar 2004 09:07:22 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 7817B11E3D; Fri, 19 Mar 2004 10:05:42 -0300 (ART) Received: from bugs.unl.edu.ar ([127.0.0.1]) by localhost (bugs [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06995-10; Fri, 19 Mar 2004 10:05:42 -0300 (ART) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 0035911DB0; Fri, 19 Mar 2004 10:05:41 -0300 (ART) From: Martin Marques To: "Kumar" , "psql" Subject: Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls Date: Fri, 19 Mar 2004 10:05:40 -0300 User-Agent: KMail/1.5.4 References: <026601c40daf$442ffcd0$7502a8c0@hdsc.com> In-Reply-To: <026601c40daf$442ffcd0$7502a8c0@hdsc.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200403191005.40561.martin@bugs.unl.edu.ar> X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at unl.edu.ar X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/201 X-Sequence-Number: 17300 El Vie 19 Mar 2004 09:39, Kumar escribi=F3: > Dear Friends, > > I have installed Linux Fedore and wanted to work with the default install= ed > postgres 7.3.4 database. > > I could able to create to create user, but while try to connect, I got the > following error message psql: FATAL 1: IDENT authentication failed for us= er > > My pg_hba.conf file looks like below > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > > local all all trust > host all all 192.168.2.0 255.255.255.0 trust > > I couldnt understand why. Please shed some light This is not the default configuration, so I suspect that you changed it. Tr= y=20 to reload PostgreSQL and try again. --=20 10:04:02 up 10 days, 14:35, 4 users, load average: 0.27, 0.24, 0.27 ----------------------------------------------------------------- Mart=EDn Marqu=E9s | select 'mmarques' || '@' || 'unl.edu.ar' Centro de Telematica | DBA, Programador, Administrador Universidad Nacional del Litoral ----------------------------------------------------------------- From devrim@gunduz.org Fri Mar 19 14:23:36 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6DB38D1E94C for ; Fri, 19 Mar 2004 14:23:36 +0000 (GMT) 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 15017-05 for ; Fri, 19 Mar 2004 10:23:30 -0400 (AST) Received: from emo.org.tr (emo.org.tr [195.142.105.9]) by svr1.postgresql.org (Postfix) with ESMTP id 85238D1B561 for ; Fri, 19 Mar 2004 10:23:21 -0400 (AST) Received: by emo.org.tr (Postfix, from userid 41643) id 03516EE518; Fri, 19 Mar 2004 16:23:11 +0200 (EET) Received: from localhost (localhost [127.0.0.1]) by emo.org.tr (Postfix) with ESMTP id F0C9BEE494; Fri, 19 Mar 2004 16:23:11 +0200 (EET) Date: Fri, 19 Mar 2004 16:23:10 +0200 (EET) From: Devrim GUNDUZ X-X-Sender: devrim2@emo.org.tr To: Kumar Cc: psql Subject: Re: psql: FATAL 1: IDENT authentication failed for user error In-Reply-To: <026601c40daf$442ffcd0$7502a8c0@hdsc.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/203 X-Sequence-Number: 17302 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, On Fri, 19 Mar 2004, Kumar wrote: > I have installed Linux Fedore and wanted to work with the default installed postgres 7.3.4 database. > > I could able to create to create user, but while try to connect, I got the following error message > psql: FATAL 1: IDENT authentication failed for user > > My pg_hba.conf file looks like below > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > > local all all trust > host all all 192.168.2.0 255.255.255.0 trust Are you sure that you've commented (or maybe deleted) the "ident" line? AFAIR, if there is a line about ident auth before the lines that you've pasted, PostgreSQL will take care of that line and will try ident auth. Also, a reload is required after a change in pg_hba.conf. Regards, - -- Devrim GUNDUZ devrim@gunduz.org devrim.gunduz@linux.org.tr http://www.TDMSoft.com http://www.gunduz.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQFAWwJPtl86P3SPfQ4RAnh4AKCPqY2Xu/ZBkuytA1puv2qtBN5AwQCglCuZ 7kouiIpk0hvxOOuAxhfPZnY= =ktdd -----END PGP SIGNATURE----- From tgl@sss.pgh.pa.us Fri Mar 19 15:12:15 2004 X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 443CBD1B4BC for ; Fri, 19 Mar 2004 15:12:15 +0000 (GMT) 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 38143-05 for ; Fri, 19 Mar 2004 11:12:13 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 5CFC0D1EBD0 for ; Fri, 19 Mar 2004 11:12:09 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2JFCBis024214; Fri, 19 Mar 2004 10:12:11 -0500 (EST) To: Martin Marques Cc: "Kumar" , "psql" Subject: Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls In-reply-to: <200403191005.40561.martin@bugs.unl.edu.ar> References: <026601c40daf$442ffcd0$7502a8c0@hdsc.com> <200403191005.40561.martin@bugs.unl.edu.ar> Comments: In-reply-to Martin Marques message dated "Fri, 19 Mar 2004 10:05:40 -0300" Date: Fri, 19 Mar 2004 10:12:11 -0500 Message-ID: <24213.1079709131@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/205 X-Sequence-Number: 17304 Martin Marques writes: > El Vie 19 Mar 2004 09:39, Kumar escribió: >> My pg_hba.conf file looks like below >> >> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD >> >> local all all trust >> host all all 192.168.2.0 255.255.255.0 trust >> >> I couldnt understand why. Please shed some light > This is not the default configuration, so I suspect that you changed it. ... and forgot to SIGHUP the postmaster after changing it, so the original IDENT-based selection is still active. Do "pg_ctl reload" to get the postmaster to notice changes in its config files. regards, tom lane