falcon icon indicating copy to clipboard operation
falcon copied to clipboard

PostgreSQL Scram-sha-256 authentication does not work

Open ced75 opened this issue 5 years ago • 3 comments

Hi,

The authentication mecanism with scram-sha-256, introduced with PostgreSQL v10 (more secure than MD5 authentication) generates the following error message: Unknown authenticationOk message typeMessage { name: 'authenticationOk', length: 23 }

In the database logs, the connection seems to be OK (connection received), but is cancelled a few time later due to timeout.

Is it possible to integrate this authentication method for PostgreSQL?

Thanks in advance, Cedric

ced75 avatar Mar 15 '19 13:03 ced75

I am facing the same problem with Postgresql version 13.2

NobleAscent avatar Apr 18 '21 22:04 NobleAscent

It is July 2021, is this issue solved at all? I opened the development tools and it mentioned about error code 500 and not sure how to make this work. Any ideas or thoughts? Thanks in advance and thanks. image

yunpeng-zhang avatar Jul 26 '21 18:07 yunpeng-zhang

Getting Error Unknown authenticationOk message typeMessage { name: 'authenticationOk', length: 42 }

khanakia avatar Jan 24 '24 18:01 khanakia