problem authenticating with encrypted passwords in pg_shadow

Поиск
Список
Период
Сортировка
От Joey Mingrone
Тема problem authenticating with encrypted passwords in pg_shadow
Дата
Msg-id be5k8.55333$3O2.19768146@typhoon.southeast.rr.com
обсуждение исходный текст
Список pgsql-general
I just upgraded to postgresql 7.2 and I'm having trouble connecting to the
postmaster with psql.

Here is what I've done:

I added this line to the top of the pg_hba.conf file.

# TYPE    DATABASE    IP_ADDRESS    MASK    AUTH_TYPE    AUTH_ARGUMENT
 local            all
md5

Now I connect to the postmaster with the postgres account using psql
(postgres' password is stored as plain text in pg_shadow so I can connect
without any problems) and I run this command:

CREATE USER test WITH ENCRYPTED PASSWORD 'blah';

When I try to connect with the user test form the same host the postmaster
is running on, (psql -U test -d template1) I get the response:

psql: FATAL 1:  Password authentication failed for user "test"

When I change the password for the user test back to plain text I can
connect fine.

Anyone know what's going on?

Thanks,

Joey



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

Предыдущее
От: Dave Smith
Дата:
Сообщение: Re: JDBC Prepared Statement Bug
Следующее
От: "otisg"
Дата:
Сообщение: Re: pgmonitor