search

rbeckman-nextgen / test-mc3

0 stars 0 forks source link

Support MySQL 8.0 #4148

Closed rbeckman-nextgen closed 4 years ago

rbeckman-nextgen commented 4 years ago

The GA release of MySQL was recently updated to version 8.0 (4/19/2018) and this is what docker's "latest" points to. Mirth Connect fails to connect to this docker instance. If you set the version to "5.7" instead of "latest", Mirth Connect connects with no problems.

Here is a list of upgrade information for 8.0:

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

Imported Issue. Original Details: Jira Issue Key: MIRTH-4292 Reporter: narupley Created: 2018-06-11T11:00:29.000-0700

rbeckman-nextgen commented 4 years ago

Upgraded to MySQL Connector/J 8.0.16.

This new driver doesn't support versions of MySQL older than 5.6. Those older versions are over 10 years old and EOL by Oracle, so with this issue we've updated our System Requirements to reflect that 5.6+ is the new minimum supported version of MySQL.

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-versions.html http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf

You can still connect to older versions of MySQL by including the older JDBC driver JAR as a custom library resource.

Imported Comment. Original Details: Author: narupley Created: 2019-06-20T08:40:22.000-0700