DBeaver PostgreSQL Database - SCRAM authentication is not supported by this driver

Question

I am trying to add a PostgreSQL database to DBeaver and am getting the following error when I try to connect to the database. I'm using DBeaver Version 7.2.3.202010191702. And after receiving this message I installed the latest version of the JDK (11.0.9) and pgJDBC (postgresql-42.2.18.jar). I've not had PostgreSQL on this machine yet, so it's a fresh install of the latest version (v13). Any suggestions?

SCRAM authentication is not supported by this driver. You need JDK >= 8 and pgjdbc >= 42.2.0 (not ".jre" vesions)

Tobey

I guess you didn't install it in the right way, and DBeaver is still using the old version. – Rennin

Answer 1

I had same error and in my situation I had old database drivers. These steps fixed it for me:

• Go to Database Driver Manager
• Select PostgreSQL (either double click or single select and then "Edit ...")
• Click on "Download/Update"
• Choose newer version (see bold version text) e.g. 42.2.18 for org.postgresql:postgresql:RELEASE
• Press "Download"

Casebound

Answer 2

Even using all the tips and tricks found on SO I was not able to connect to PGSQL 14 DBs.
I fixed it by using PostgreSQL (Old) driver, and it now works.

Photocopy

Answer 3

The problem I faced was identical, and what resolved it for me was:

1. Removing the previous PostgreSQL JDBC from the lib folder.
2. Downloading the latest PostgreSQL JDBC.
3. Substituting the old JDBC with the new one.

Banderole

Answer 4

I tried the suggestion by Nicolas Kuebler and it worked. However, I had to repeat this every single time I opened DBeaver and would lose any unsaved scripts in the process. In my case I found out that even when I was updating the driver using the process in the answer above DBeaver was not updating its dbeaver-drivers-config.xml file to fix the name of the jdk.

To fix this I did the following

1. Follow instructions from the initial answer. Remember to check the Force Download /Overwrite checkbox in the download popup in step 4

• Go to Database Driver Manager
• Select PostgreSQL (either double click or single select and then "Edit ...")
• Click on "Download/Update"
• Choose newer version (see bold version text) e.g. 42.5.4 for org.postgresql:postgresql:RELEASE
• Press "Download"

2. Once you complete this step open the dbeaver-drivers-config.xml file at C:\Program Files\DBeaver\dbeaver-drivers-config.xml or a different path where you installed it.

3. Read the /drivers/provider/library/@path attribute value for postgresql provider in the XML and make sure that the path is valid on your computer and the name of the jar file is correct.

For me the old driver was not being deleted and the path to the file in the @path attribute was pointing to the old jar file. Whenver DBeaver launched again, it tried to use the old jar file and threw the same error. I manually changed this to the new name of the jar file and that fixed the issue.

Superdreadnought

Answer 5

I had a problem similar to yours. This is the way to fix it:

1. open folder PostgreSQL\14\data, edit postgresql.config fix password_encryption to md5
2. alter all METHOD value to password in pg_hba.conf
3. restart postgres server

Ileum

Answer 6

In my case, JRE version postgres being used in Pom.xml. Update it to the latest version and it should work

Viridissa

Please add more details with code. – Pinkiepinkish