password method in pg_hba.conf fails

From: Emmanuel Dreyfus <manu(at)netbsd(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: password method in pg_hba.conf fails
Date: 2003-02-26 16:44:54
Message-ID: 20030226164454.GE12956@melancolie.net.espci.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everybody

I just upgraded from 7.2.2 to 7.3.2, and I this upgrade broke the way I
handled authentication.

I had an external password file ~pgsql/data/pg_passwd with lines like this:
guest:OgP29.PYhgA

~pg_hba.conf/data/ contains entries like this (I had to add one field when
upgrading to 7.3.2, the beast complaining about it)
local all guest trust
local template1 all password pg_passwd
local dirdb all password pg_passwd

Then I try to login. I get this:
$ psql -U pgsql dirdb
Password:
psql: FATAL: Password authentication failed for user "pgsql"

ktrace'ing the postgres process (I'm running on NetBSD) shows that it never
try to open ~pgsql/data/pg_passwd.

What turned wrong?

--
Emmanuel Dreyfus
manu(at)netbsd(dot)org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Tkach 2003-02-26 16:48:09 Re: Compilation errors?
Previous Message Robert Fitzpatrick 2003-02-26 16:26:59 Automated backup