Disable JDBC driver SSL connection attempt with GeoNetwork/PostgreSQL-PostGIS DB

Поиск
Список
Период
Сортировка
От celati Laurent
Тема Disable JDBC driver SSL connection attempt with GeoNetwork/PostgreSQL-PostGIS DB
Дата
Msg-id CAHByMH33D6pWxqNaf4sbB7aQ45r_m03hzuxBOpau6xFwdYxhtQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Disable JDBC driver SSL connection attempt with GeoNetwork/PostgreSQL-PostGIS DB  (Mark Rotteveel <mark@lawinegevaar.nl>)
Список pgsql-jdbc
Hello,

i work with postgresql 13 and java 8

Following to my previous post : https://gis.stackexchange.com/questions/445280/geonetwork-4-2-1-debian-install-error-message

The problem seems to come from the JDBC driver wants to connect over SSL. How to disable SSL connection attempt? I would prefer to try disable SSL connection attempt via GeoNetwork config files rather than to enable/set a SSL configuration (like set a certificate for instance) on the PostgreSQL/PostGIS db.

For information, I succeed in connecting to my PostGIS db via psql console. Below the geonetwork jdbc.properties at jdbc.connectionProperties is on ssl=false


jdbc.connectionProperties=ssl=false
jdbc.basic.removeAbandoned=true
jdbc.basic.removeAbandonedTimeout=300
jdbc.basic.logAbandoned=true
jdbc.basic.maxActive=30
jdbc.basic.maxIdle=10
jdbc.basic.initialSize=10
jdbc.basic.maxWait=500
jdbc.basic.testOnBorrow=true
jdbc.basic.timeBetweenEvictionRunsMillis=1000
jdbc.basic.minEvictableIdleTimeMillis=1800000
jdbc.basic.testWhileIdle=true
jdbc.basic.numTestsPerEvictionRun=5
jdbc.basic.poolPreparedStatements=true
jdbc.basic.maxOpenPreparedStatements=1200
jdbc.basic.validationQuery=SELECT 1
jdbc.basic.defaultReadOnly=false
jdbc.basic.defaultAutoCommit=false


But i have still the same error messages regarding ssl when i try to start geonetwork. 
This morning, i saw this post : 

So i tried to test with sslmode=disable

But it does not work for me. Still the same logs/errors messages. 
Any guidances  ? Thanks a lot.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: Would preparing internally during XAResource.end(xid, TMSUCCESS) works?
Следующее
От: Mark Rotteveel
Дата:
Сообщение: Re: Disable JDBC driver SSL connection attempt with GeoNetwork/PostgreSQL-PostGIS DB