Re: BUG #16736: SCRAM authentication is not supported by this driver - Mailing list pgsql-bugs

From Daniel Verite
Subject Re: BUG #16736: SCRAM authentication is not supported by this driver
Date
Msg-id 09c6f1d4-83b1-41d3-b685-d404b0962c77@manitou-mail.org
Whole thread Raw
In response to Re: BUG #16736: SCRAM authentication is not supported by this driver  (Walter Weinmann <walter.weinmann@gmail.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #16747: Unexpected behaviour of the overlaps function
Next
From: Peter Smith
Date:
Subject: Re: BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in startup loop