...
Application | Confluence |
|---|---|
Database Type | Oracle |
Error Message
| Code Block |
|---|
javaxJAva.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: sql.SQLRecoverableException: IO Error: General SSLEngine problem, connect lapse 64 ms., Authentication lapse 0 ms. |
...
| Panel | ||
|---|---|---|
| ||
The error could be is caused if the SSL certs are not trusted by Confluence Tomcat application. |
Solution
We need to
...
have a copy of the SSL certs and install it into Confluence
...
using Java cacerts using keytool.
Syntax to import certs into JAVA CACERTS
| Code Block |
|---|
keytool -import -trustcacerts -keystore <cacerts path> -storepass <password> -noprompt -alias <alias-name> -file <cert_file_path> |
Error Message
| Code Block |
|---|
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 6470 ms., Authentication lapse 0 ms. |
Log Entries
| Code Block |
|---|
ERROR [http-nio-8096-exec-2324] [confluence.sql.config.DBConnection] connectViaDriverManager Error while checking connection : java.sql.SQLRecoverableException: IO Error: General SSLEngine problem, connect lapse 7951 ms., Authentication lapse 0 ms. –-- referer: https://<confluence-url>/admin/plugins/org.swift.confluence.sql/configure.action | url: /plugins/org.swift.confluence.sql/testconnection.action | traceId: <traced>| userName: test | action: testconnection |
Cause
| Panel | ||
|---|---|---|
| ||
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
...
When we create the Resource Data Source within the Tomcat server.xml file and create another SQL Datasource profile from the Add-on page and validate the Test Connection we see the above error message in logs. |
Solution
To avoid the error message, we need to remove the profile from the SQL for Confluence configuration Add-on i.e. from the SQL for Confluence configuration Add-on, go to view and modify Data source profiles and remove the related profile.
Next, we can try using the SQL macro on a test page and enter the Data source name jdbc/confluence and click on preview
| Info |
|---|