We're updating the issue view to help you get more done. 

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

Description

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

Environment

MySQL 5.6.x

Acceptance Test - Entry

None

Activity

Show:
wroot
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.

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.

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.

dolphin dolphin
May 12, 2014, 6:25 PM

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

wroot
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).

Fixed

Assignee

Daryl Herzmann

Reporter

wroot

Labels

Expected Effort

None

Ignite Forum URL

None

Fix versions

Affects versions

Priority

Major
Configure