Re: BUG #15035: scram-sha-256 blocks all logins

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15035: scram-sha-256 blocks all logins
Дата
Msg-id 29276.1517287253@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #15035: scram-sha-256 blocks all logins  (Meirav Rath <meirav.rath@imperva.com>)
Список pgsql-bugs
Meirav Rath <meirav.rath@imperva.com> writes:
> I set up the password hashing method to scram and now no one can login to the server and that's not a bug??

You told it to lock out md5 passwords, and it did.

Try changing the passwords to scram type *first*.  Note where it
says in the fine manual:

    To ease transition from the md5 method to the newer SCRAM method, if
    md5 is specified as a method in pg_hba.conf but the user's password on
    the server is encrypted for SCRAM (see below), then SCRAM-based
    authentication will automatically be chosen instead.

            regards, tom lane


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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: BUG #15035: scram-sha-256 blocks all logins
Следующее
От: Meirav Rath
Дата:
Сообщение: RE: BUG #15035: scram-sha-256 blocks all logins