Re: BUG #17216: No Password Provided Error - uncaught exception - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17216: No Password Provided Error - uncaught exception
Date
Msg-id 4139744.1633529791@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17216: No Password Provided Error - uncaught exception  (PG Bug reporting form <noreply@postgresql.org>)
List 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



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17217: PANIC: stuck spinlock detected at LockBufHdr, bufmgr.c:4297
Next
From: Judith Meyer
Date:
Subject: Bug / Unexpected behaviour of NOT LIKE