password method in pg_hba.conf fails

Поиск
Список
Период
Сортировка
От Emmanuel Dreyfus
Тема password method in pg_hba.conf fails
Дата
Msg-id 20030226164454.GE12956@melancolie.net.espci.fr
обсуждение исходный текст
Ответы Re: password method in pg_hba.conf fails  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@netbsd.org

В списке pgsql-general по дате отправления:

Предыдущее
От: Fernando Schapachnik
Дата:
Сообщение: Unable to delete row on 7.3.2 with schemas
Следующее
От: "Luc Martienau"
Дата:
Сообщение: Re: 7.4?