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