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
JAva.sql.SQLRecoverableException: 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 is caused if the SSL certs are not trusted by Confluence Tomcat application.
Solution
You 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
keytool -import -trustcacerts -keystore <cacerts path> -storepass <password> -noprompt -alias <alias-name> -file <cert_file_path>
Error Message
IO Error: General SSLEngine problem, connect lapse 70 ms., Authentication lapse 0 ms.
Log Entries
ERROR [http-nio-8096-exec-24] [confluence.sql.config.DBConnection] connectViaDriverManager Error while checking connection : java.sql.SQLRecoverableException: IO Error: General SSLEngine problem, connect lapse 51 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
When you 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, you see the above error message in logs.
Solution
To avoid the error message, you 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, you can try using the SQL macro on a test page and enter the Data source name jdbc/confluence and click on the preview.
Error Message
"Cannot create PoolableConnectionFactory (IO Error: NL Exception was generated TNS-04610: No literals left, reached end of NV pair)".
Log Entries
ERROR [http-nio-8096-exec-25] [confluence.sql.config.DBConnection] globalDSConnection Error finding Datasource : java.sql.SQLException: Cannot create PoolableConnectionFactory (IO Error: NL Exception was generated TNS-04610: No literals left, reached end of NV pair)
Cause