Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

Attachments

1
  • 19 Jan 2014, 11:55 AM

Activity

Show:

wroot May 12, 2014 at 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 at 6:25 PM

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

Tom Evans April 26, 2014 at 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 at 6:08 PM

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

wroot February 17, 2014 at 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.

Fixed

Details

Assignee

Reporter

Labels

Fix versions

Affects versions

Priority

Created September 13, 2013 at 4:01 AM
Updated May 12, 2014 at 7:20 PM
Resolved February 6, 2014 at 9:11 PM