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

The following bug has been logged on the website:

Bug reference:      17216
Logged by:          cliff sizer
Email address:      cliffsizer@gmail.com
PostgreSQL version: 14.0
Operating system:   Debian 14.0-1.pgdg110+1 on x86_64-pc-linux-gnu
Description:

Using connecting to the pg database 14.0 using jdbc (driver 42.2.24) 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"

The password specific exception is expected rather than the generic message.
According to the release notes the following new feature has been
implemented:

E.1.3.1.8. Authentication - Allow passwords of an arbitrary length (Tom
Lane, Nathan Bossart)

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