PostgreSQL SASL Authentication error

Posted on
Fri Mar 19, 2021 8:37 am
harrjca offline
Posts: 1
Joined: Mar 19, 2021

PostgreSQL SASL Authentication error

Hi there,

I am trying to setup SQL Logger to use a local installation of PostgreSQL version 13.2

I have confirmed that the PostgreSQL server is installed and working. I can connect to it from the psql command line.

However, when I enable the SQL Logger in Indigo 7.5, I get the following error in the event log:

SQL Logger Error exception trying to connect or create database indigo_history on 127.0.0.1
SQL Logger Error FATAL: SASL authentication is not supported in protocol version 2

SQL Logger Error reconnect attempt scheduled in 5 seconds

I'm not sure where to go with this. Any ideas?

Thanks.

Posted on
Fri Mar 19, 2021 5:54 pm
matt (support) offline
Site Admin
User avatar
Posts: 20473
Joined: Jan 27, 2003
Location: Texas

Re: PostgreSQL SASL Authentication error

I think you need to use a different authentication mode (not SASL/scram). Based on the documentation here the other options are md5 or password. Based on that page the method available depends on how the password is encrypted/hashed:

The availability of the different password-based authentication methods depends on how a user's password on the server is encrypted (or hashed, more accurately). This is controlled by the configuration parameter password_encryption at the time the password is set.

Image

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest