Docker - 7.9.20 - Database Connection

Ignition
,
1

I am having issues getting an Ignition 7.9.20 Docker image to connect to a database installed on the host machine.

The host machine is running Windows 10 and has SQL Server Express 17 installed.

This same setup works great for many 7.8.x Docker images, 7.9.18, and many of 8.1.x Docker images.

The error is:

Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "No appropriate protocol (protocol is disabled or cipher suites are inappropriate)".)

The gateway on 7.9.20 was imported from an export made on a 7.9.18 Docker image that connected to the database just fine.

Let me know what additional information is required.

2

What version of JDBC driver are you using? You probably need to update the version (latest is 11.2) from the one that ships with Ignition 7.9.20 (sqljdbc4). Past that, you'll likely get a PKIX certificate path validation unless you've customized the certificate (i.e. replaced the self-signed default certificate) used on SQL Server. See this JDBC encryption guide for more information on how to proceed.

3

Updating the driver and adding

;trustServerCertificate=true

to the Extra Connection Properties fixed the issue. Thanks!