Following to my previous post : GeoNetwork 4.2.1 (Debian) install : error message?
The problem seems to come from the JDBC driver wants to connect over SSL. Do you know why JDBC driver wants by default to connect over SSL? With GeoNetwork, is it mandatory to use SSL protocol? It would be possible 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 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
For information, below, the GeoNetwork logs generated when I try to start GeoNetwork :
2022-12-08T11:46:03,644 WARN [geonetwork.databasemigration] - - Migration: Exception running migration for version: 4.2.1-0 subversion: SNAPSHOT. Cannot create PoolableConnectionFactory (SSL error: Connection reset) 2022-12-08T11:46:03,663 ERROR [jeeves] - JeevesContextLoaderListener: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/lib/gn-domain-4.2.1-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL error: Connection reset) org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/lib/gn-domain-4.2.1-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL error: Connection reset)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL error: Connection reset)
2022-12-08T11:46:03,689 FATAL [jeeves.engine] - Raised exception during init 2022-12-08T11:46:03,689 FATAL [jeeves.engine] - Exception : org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/lib/gn-domain-4.2.1-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL error: Connection reset)
2022-12-08T11:46:03,689 FATAL [jeeves.engine] - Message : Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/lib/gn-domain-4.2.1-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL error: Connection reset) 2022-12-08T11:46:03,693 FATAL [jeeves.engine] - Stack : org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in URL [jar:file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/lib/gn-domain-4.2.1-0.jar!/config-spring-geonetwork.xml]: Cannot resolve reference to bean 'jdbcDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdbcDataSource' defined in URL [file:/var/lib/tomcat9/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Cannot create PoolableConnectionFactory (SSL error: Connection reset)
