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 2B9AA3AC11B for ; Tue, 28 Dec 2004 14:05:06 +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 52427-10 for ; Tue, 28 Dec 2004 14:04:49 +0000 (GMT) Received: from mbopi.cytera.com.py (host40-42.wireless.com.py [200.85.40.42]) by svr1.postgresql.org (Postfix) with ESMTP id 5FD9D3AC5C9 for ; Tue, 28 Dec 2004 14:04:47 +0000 (GMT) Received: from [192.168.102.36] (ariel.cytera.com.py [192.168.102.36]) by mbopi.cytera.com.py (8.12.8/8.12.8) with ESMTP id iBSE318W004867; Tue, 28 Dec 2004 11:03:02 -0300 Message-ID: <41D1757F.8080808@cybira.biz> Date: Tue, 28 Dec 2004 11:02:23 -0400 From: =?ISO-8859-1?Q?=22Lic=2E_Guillermo_Gonz=E1lez=22?= User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Sukhdeep Johar Cc: pgsql-admin@postgresql.org Subject: Re: help with - psql: FATAL: Password authentication failed References: <2ef564dc04122802535f2b22c@mail.gmail.com> <2ef564dc041228025440383142@mail.gmail.com> <41D15C8C.7080600@cybira.biz> <2ef564dc041228055320229353@mail.gmail.com> In-Reply-To: <2ef564dc041228055320229353@mail.gmail.com> X-Enigmail-Version: 0.89.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.314 tagged_above=0 required=5 tests=AWL, BIZ_TLD, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/256 X-Sequence-Number: 15842 Sukhdeep Johar wrote: > can i set database specific access permission in pg_hba.conf ? > Can you give me some more details. > > My pg_hba.conf setting is : > local all all trust > host all all 127.0.0.1 255.255.255.255 crypt > I disabled all other lines. > > I changed the second line to this : > host all all 0.0.0.0 0.0.0.0 trust > Now the psql command passes, but even after removing > all access restrictions, pg_connct() is still failing. > > Can you please give some pointers what is going wrong ? > > -Sukhdeep > > > > On Tue, 28 Dec 2004 09:15:56 -0400, Lic. Guillermo González > wrote: > >>Sukhdeep Johar wrote: >> >>>I followed these steps to create a new user : >>>1. createuser -P gforge >>>2. createdb -U gforge -E UNICODE gforge >>>3. createlang plpgsql gforge >>> >>>this gave no errors. >>>But when I try to log in, I get the foll error >>># psql -h localhost -U gforge gforge >>>psql: FATAL: Password authentication failed for user "gforge" >>> >>>Any comments, what may be going wrong ? >>>-- >>>Neither success nor failure is ever final >>> >>> >> >>Did you check your pg_hba.conf for gforge database access permisions? >> >> > > > Try this, In your pg_hba.conf local all all md5 host all all 127.0.0.1 255.255.255.255 md5 then execute with postgres user to reload de pg_hba.conf changes: pg_ctl reload and to access your database: psql gforge -U gforge -W Obs.: - refer to the psql man pages for more information about psql options. - Note that in the psql command is not present the -h localhost option. Regards,