Postgresql 13 MD5 refusé

Elikill58 · Décembre 14, 2020, 3:56

Bonjour,

Sur Postgresql 10, Axelor fonctionne. Mais, sous Postgresql 13 j’ai une erreur indiquant que la méthode d’authentification 10 n’est pas supporté pour l’adresse IP ou le réseau donné.

Comment régler ce problème (ou le contourner) ?

Cordialement.

siddique · Décembre 14, 2020, 5:45

pg_hba updated??

Elikill58 · Décembre 15, 2020, 9:18

This is:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     scram-sha-256
# IPv4 local connections:
host    all             all             127.0.0.1/24            scram-sha-256
host    all             all             fe80::300a:8ceb:f664:74e8%7/128            scram-sha-256

# IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     scram-sha-256
host    replication     all             127.0.0.1/24            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256

And this is more complete error (in french, sorry) :

ERROR 20492 --- [io-8080-exec-23] org.postgresql.Driver : Connection error: 
org.postgresql.util.PSQLException: Le type d'authentification 10 n'est pas supporté. Vérifiez que vous avez configuré le fichier pg_hba.conf pour inclure l'adresse IP du client ou le sous-réseau et qu'il utilise un schéma d'authentification supporté par le pilote.
	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:614)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
	at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
	at org.postgresql.Driver.makeConnection(Driver.java:431)

siddique · Décembre 15, 2020, 5:45

I have not tried but I guess it was md5 for password

please try md5 instead of scram-sha-256

Elikill58 · Décembre 16, 2020, 10:01

Hello,

And do you know if I can change the encryption in the axelor side ? To use scram-sha-256 ?

Elikill58 · Janvier 13, 2021, 2:26

Hi,

Anyone know ?
Personne ne sait ?

bDurtaut · Février 22, 2021, 10:30

Same problem , use V12 … the md5 in the conf file doesn t work

RiadhBH · Mars 23, 2021, 10:17

You should download the new driver version from this link: https://jdbc.postgresql.org/download/postgresql-42.2.19.jar, then put it on your « jdk1.8/jre/lib/ext/ » folder, then run once jdk1.8/bin/extcheck
–> start and enjoy your axelor

laurent-lesterpt · Septembre 14, 2021, 1:32

Citation
You should download the new driver version from this link: https://jdbc.postgresql.org/download/postgresql-42.2.19.jar , then put it on your « jdk1.8/jre/lib/ext/ » folder, then run once jdk1.8/bin/extcheck
–> start and enjoy your axelor

I tried this : .\extcheck.exe -verbose …\jre\lib\ext\postgresql-42.2.23.jar
it returned :
Target file:…\jre\lib\ext\postgresql-42.2.23.jar
IO Exception occured

Shouldn’t the file that should be changed rather be WEB-INF/lib/postgressql-42.0.0.jar in axelor-erp ?
~~I tried changing it myself but it didn’t work, probably Axelor devs need to do something on their side.~~

I changed it and it worked, here are the tables in postgres 13 shown in pgadmin4.