pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: walter@konnexions.ch
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16736: SCRAM authentication is not supported by this driver
Date: Sat, 21 Nov 2020 12:44:55 -0500
Message-ID: <1546115.1605980695@sss.pgh.pa.us> (raw)
In-Reply-To: <16736-08a2d0d16b76e87e@postgresql.org>
References: <16736-08a2d0d16b76e87e@postgresql.org>

PG Bug reporting form <noreply@postgresql.org> writes:
> Version 13 was fine, but now with version 13.1 (via Docker image
> postgres:13.1-alpine) and postgresql-42.2.18.jar I get:

> Nov. 21, 2020 6:26:36 AM org.postgresql.core.v3.ConnectionFactoryImpl log
> WARNING: SQLException occurred while connecting to localhost:5432
> org.postgresql.util.PSQLException: SCRAM authentication is not supported by
> this driver. You need JDK >= 8 and pgjdbc >= 42.2.0 (not ".jre" versions)

I doubt this has anything to do with an update to 13.1 per se.
What more likely happened is that you changed your account password
and it's now stored under SCRAM hashing, which your client-side
code is evidently too old to support.  If you don't want to update
your client-side code right now, do "set password_encryption = md5"
and then set the password again.  If you're running as superuser
you can look into pg_authid.rolpassword to verify that the hashed
password starts with "md5" not "SCRAM".

(BTW, md5 is still the default value for password_encryption in v13,
so it seems like you must have overridden that.)

			regards, tom lane





view thread (5+ messages)  latest in thread

Message-ID: <1546115.1605980695@sss.pgh.pa.us>
Permalink:  ../1546115.1605980695@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1546115.1605980695@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, walter@konnexions.ch, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16736: SCRAM authentication is not supported by this driver
  In-Reply-To: <1546115.1605980695@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox