Synchrony Cannot Communicate with SQL Server through SSL with jTDS Driver v1.3.1

Summary

Synchrony is unable to communicate with SQL Sever if the connection is SSL encrypted.

In atlassian-confuence.log , you can see

2017-06-26 18:29:05,557 INFO [Long running task: EnableTask] [plugins.synchrony.config.DefaultSynchronyConfigurationManager] postConfigToSynchrony [Collab editing plugin] Synchrony connection failure: Could not generate/verify AppID/Secret for real-time collaboration service at http://localhost:8091/synchrony/v1

Environment

• Microsoft SQL Server database
• SSL encrypted JDBC connection
• Using bundled v1.3.1 jTDS driver

Steps to Reproduce

1. Set up Confluence communicating to the database through SSL
2. Try to use the editor

Expected Results

The editor works as expected.

Actual Results

You are unable to open the editor.

Notes

This issue is caused by the following bug in jTDS v1.3.1:

• jTDS driver ssl connection hangs with JRE 1.8

The patched version could be bundled to avoid the occurrence of this issue.

Workaround

Replace the bundled JTDS driver with jtds-1.3.1-v20140512. You can download this patched version here:

• jtds-1.3.1-v20140512