BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: rariasamaya(at)gmail(dot)com
Subject: BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18
Date: 2022-12-13 21:02:56
Message-ID: 17719-1b134207edf65c08@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17719
Logged by: Ramiro Arias-Amaya
Email address: rariasamaya(at)gmail(dot)com
PostgreSQL version: 11.18
Operating system: Debian Linux 11.5
Description:

I have two machines:
1. HP EliteDesk 800 G1 SFF business computer
21 GiB RAM, 4.5 TB hard disk
Processor: Intel i5

2. HP Envy 17-s151nr laptop
16 GiB RAM, 4 TB hard disk
Processor: Intel i7

Installing PostgreSQL 11 (11.18 was installed) under Debian 11.5. Once
postgres password has been assigned and after that edit pg_hba.conf using
scram-sha-256, I got the following result:

ramiro(at)HP-s151nr:~$ sudo -u postgres psql -p 5432
[sudo] password for ramiro:
Password for user postgres:
psql: error: connection to server on socket
"/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: password authentication
failed for user "postgres"
ramiro(at)HP-s151nr:~$

Repeating the previous procedure installing from scratch PostgreSQL 14 (14.6
was installed) the command sudo -u postgres psql -p 5432 executed
flawlessly.

Repeating the procedure, installing PostgreSQL 11 (11.18 was installed),
assigning password to postgres, then edit pga_hba.conf using md5, the
command sudo -u postgres psql -p 5432 executed flawlessly.

In both machines the behaviour was the same. scram-sha-256 is not working on
PostgreSQL 11.18 , despite PostgreSQL claims it works since version 10.
scram-sha-256 DOES work on PostgreSQL version 14.6, which I tested in both
machines.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2022-12-14 02:56:15 Re: BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18
Previous Message Tom Lane 2022-12-13 19:26:58 Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands