Hello, we have been running openfire 4.1.5 for a year with MySQL 5.6. Now 5.6 is EOL in a few months so we need to upgrade. Is there a way for me to find out what is the highest version of mysql that openfire 4.1.5 is compatible with?
On Windows you can find mysql-connector-java-xxx.jar file in Openfire\lib folder (should be similar on Linux). Try searching which MySQL versions are supported by that particular xxx version of a connector. Like https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-versions.html
Thanks @wroot, this got me on the right track. The following may benefit others: you can find what version of connector is being used by openfire server by going to the Server -> Server Manager -> Database page (https://openfire-host-name/server-db.jsp). Once you know that, you can find on that page you listed (https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-versions.html) the compatibility matrix. As of this post, looks like there are only 2 connector versions available officially (5.1 and 8) and both support MySQL 5.6, 5.7, and 8.0. That’s the info I needed. BTW based on wikipedia MySQL Release history those are the 3 most recent versions of MySQL so that good.