Gettin the error: Unknown authenticationOk message typeMessage { name: ‘authenticationOk’, length: 23 }, while connectig vNode SQL Client with Postgres Database

Created by Vester Business Support Team, Modified on Wed, 2 Aug, 2023 at 12:40 AM by Vester Business Support Team

When connecting vNode SQL Client with Postgres Database, appears an error on the log: " Unknown authenticationOk message typeMessage { name: ‘authenticationOk’, length: 23 } " it blocks SQL client to make a connection properly to the the database, while the behavior of the module is changing from running to stop. 


This is caused by the encryption of the Postgres string connection based on " scram sha-256" method. 


Solution:


1- Open pg_hba.conf ( which is located under C:\Program Files\PostgreSQL\14\data ).
2- Scroll down to the bottom of the file, there you will find at the end of every line “scram-sha-256”.
3- Replace the  scram-sha-256 with trust, and that’s gonna fix your problem.

4- Restart you Postgres service and make the test connection again with vNode SQL Client module. 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article