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

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Walter Weinmann" <walter(dot)weinmann(at)gmail(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,walter(at)konnexions(dot)ch,pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16736: SCRAM authentication is not supported by this driver
Date: 2020-11-26 16:41:31
Message-ID: 09c6f1d4-83b1-41d3-b685-d404b0962c77@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Zhiyu ZY13 Xu 2020-11-26 16:45:18 答复: [External] Re: pgadmin--pgagent---the process hang by unknow reasons
Previous Message Павел Лучин 2020-11-26 16:26:05 Re: BUG #16747: Unexpected behaviour of the overlaps function