From: Tom Lane <tgl@sss.pgh.pa.us>
To: cliffsizer@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17216: No Password Provided Error - uncaught exception
Date: Wed, 06 Oct 2021 10:16:31 -0400
Message-ID: <4139744.1633529791@sss.pgh.pa.us> (raw)
In-Reply-To: <17216-fa0d1504d9dd5b7c@postgresql.org>
References: <17216-fa0d1504d9dd5b7c@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> Using connecting to the pg database 14.0 using jdbc (driver 42.2.24)
How old is that JDBC driver?
> and no
> password (empty) is specified the following error message is returned
> "Something unusual has occurred to cause the driver to fail. Please report
> this exception." In previous versions (13.4) the password specific error
> message is returned "The server requested password-based authentication, but
> no password was provided"
I suspect the server is asking for a SCRAM-encrypted password and the
JDBC driver doesn't recognize that as a valid authentication request.
If you don't want to update the driver, don't use SCRAM passwords.
(Note that SCRAM password encryption is on by default in v14;
see password_encryption setting.)
regards, tom lane
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, cliffsizer@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17216: No Password Provided Error - uncaught exception
In-Reply-To: <4139744.1633529791@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