Re: BUG #16736: SCRAM authentication is not supported by this driver

Поиск
Список
Период
Сортировка
От Daniel Verite
Тема Re: BUG #16736: SCRAM authentication is not supported by this driver
Дата
Msg-id 09c6f1d4-83b1-41d3-b685-d404b0962c77@manitou-mail.org
обсуждение исходный текст
Ответ на Re: BUG #16736: SCRAM authentication is not supported by this driver  (Walter Weinmann <walter.weinmann@gmail.com>)
Список pgsql-bugs
    Walter Weinmann wrote:

> I use the official PostgreSQL image of DockerHub (docker pull
> postgres:13.1) Is it possible that in 13.1 the default password encryption
> has been changed to scram-sha-256? That would explain my problem, because
> in the image the parameter *password_encryption* in *postgresql.conf* is
> commented out.

Another possibility is that your deployment process includes a
pg_hba.conf with scram-sha-256 as the auth method.
In that case, if the client cannot do scram-sha-256 it will be rejected,
no matter what is in password_encryption and the format of the
actual password in pg_authid.

See the output of
 select * from pg_hba_file_rules;


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: https://www.manitou-mail.org
Twitter: @DanielVerite



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #16747: Unexpected behaviour of the overlaps function
Следующее
От: Peter Smith
Дата:
Сообщение: Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop