Re: BUG #17216: No Password Provided Error - uncaught exception

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: cliffsizer@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2021-10-06T14:16:31Z
Lists: pgsql-bugs
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