Update bundled MySQL JDBC driver to the newest 5.1.x version


Openfire is still shipping with the older MySQL JDBC driver (5.0.8), while the latest driver available from MySQL page is 5.1.26. Older driver has issues with the newest MySQL (Users list is not showing in the Admin Console, maybe other issues or performance bugs). New driver should be backwards compatible, but some testing should be done.

MySQL 5.6.10 - works fine (newest versions don't work, because the have no SET OPTION support anymore)
MySQL 5.1.x - Jason will test this, no bad reports, assuming that works fine
MySQL 5.0.x - Jorge reports - works fine
HSQL (Embedded database) - has its own driver, so not affected


MySQL 5.6.x


May 12, 2014, 7:20 PM

As there are no further issue reports and users report it is working with various MySQL versions, closing this ticket for now (new reports or comments should be directed to the forums).

dolphin dolphin
May 12, 2014, 6:25 PM

tried driver 5.1.28 with mysql 5.0.96 and so far so good.

Tom Evans
April 26, 2014, 6:35 PM

FYI, updated the MySQL client to 5.1.30 for the upcoming Openfire 3.9.2 release.

Tom Evans
April 26, 2014, 6:08 PM

Per their release notes, MySQL claims that the new JDBC driver maintains compatibility with older servers going back to 4.1.

February 17, 2014, 2:15 PM

Check for yourself. Download this jar, rename it to mysql.jar, backup older mysql.jar in openfire\lib\, stop Openfire, copy new jar on top of the old one, start Openfire and check if it works. Report back, as nobody yet reported is it working with 5.0.x MySQL.

Your pinned fields
Click on the next to a field label to start pinning.


Daryl Herzmann