How to fix the server log error: SCRAM authentication requires libpq version 10 or above QPSQL

You can solve the problem with the PostgreSQL authentication method by changing scram-sha-256 to md5 or trust. We recommend using md5, as it is the most secure among the compatible methods.

1. Stop the KickidlerNode service:

   sudo systemctl stop kickidlernode

2. Open the PostgreSQL configuration file:

   sudo nano /etc/postgresql/14/main/postgresql.conf

   Find the line

   #password_encryption = scram-sha-256

   uncomment it and change it to:

   password_encryption = md5

   

   Save the file.

3. Restart PostgreSQL:

   sudo systemctl restart postgresql

4. Open the pg_hba.conf file:

   sudo nano /etc/postgresql/14/main/pg_hba.conf

   Find the lines where scram-sha-256 is used and change the method to md5. For example:

   host all all 127.0.0.1/32 md5

   

   Save the file.

5. Change the password for the kickidler_node user so that it is stored in md5 format:

   Switch to the Postgres user:

sudo su postgres

Start the PostgreSQL interactive mode:

psql

Change the password using the command:

\password kickidler_node

Enter the password: scout

Exit psql:

\q

Exit from the postgres user:

exit

6. Restart PostgreSQL again:

   sudo systemctl restart postgresql

7. Start KickidlerNode:

   sudo systemctl start kickidlernode

   After that, authentication will work using the md5 method.