Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kgWwv-0000Fl-LO for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Nov 2020 17:45:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kgWwu-0001g7-64 for pgsql-bugs@arkaria.postgresql.org; Sat, 21 Nov 2020 17:45:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kgWwt-0001g0-Vs for pgsql-bugs@lists.postgresql.org; Sat, 21 Nov 2020 17:45:23 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kgWwa-0003is-Lj for pgsql-bugs@lists.postgresql.org; Sat, 21 Nov 2020 17:45:22 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 0ALHitXx1546116; Sat, 21 Nov 2020 12:44:56 -0500 From: Tom Lane To: walter@konnexions.ch cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16736: SCRAM authentication is not supported by this driver In-reply-to: <16736-08a2d0d16b76e87e@postgresql.org> References: <16736-08a2d0d16b76e87e@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Sat, 21 Nov 2020 06:06:08 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1546114.1605980695.1@sss.pgh.pa.us> Date: Sat, 21 Nov 2020 12:44:55 -0500 Message-ID: <1546115.1605980695@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PG Bug reporting form 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