Problem Statement
The profile is showing an error when trying to setup SSL connection to Oracle Database using SQL for Confluene(pro)
Environment
Application | Confluence |
|---|---|
Database Type | Oracle |
Error Message
javax.net.ssl.keyStore=e:\uatdbkeystore.jks;javax.net.ssl.keyStoreType=JKS;javax.net.ssl.keyStorePassword=keyStore-password;javax.net.ssl.trustStore=e:\uattruststore.jks;javax.net.ssl.trustStoreType=JKS;javax.net.ssl.trustStorePassword=password123 with the error message: IO Error: General SSLEngine problem, connect lapse 64 ms., Authentication lapse 0 ms.
Log Entries
ERROR [http-nio-8096-exec-23] [confluence.sql.config.DBConnection] connectViaDriverManager Error while checking connection : java.sql.SQLRecoverableException: IO Error: General SSLEngine problem, connect lapse 79 ms., Authentication lapse 0 ms. – referer:
Cause
The error could be caused if the SSL certs are not trusted by Confluence Tomcat application.
Solution
We need to get a copy of the SSL certs and install it into Confluence used Java cacerts using keytool.
Syntax to import certs into JAVA CACERTS
keytool -import -trustcacerts -keystore <cacerts path> -storepass <password> -noprompt -alias <alias-name> -file <cert_file_path>