I did an OS upgrade, and Jive Messenger isn''t working right anymore!

Openfire Openfire Support
21

I got this problem too and I found that it may be related to the use of Server-side Prepared Statements in the JDBC Driver.

After I disable the use of server-side prepared statements, it works fine.

Here is the way to disable it, simple add ‘‘useServerPrepStmts=false’’ to the end of the ‘‘DB Connection URL’’ when you configure the server, and it should looks like

jdbc:mysql://xxx.xxx.xx.xxx:3306/wildfire?useServerPrepStmts=false

22

Yup, the problem was determined to be that the Mandriva 2006.0 build of MySQL broke Prepared Statements at least with the JDBC Driver.

The bug report is here:

http://qa.mandriva.com/show_bug.cgi?id=18864

To get around this bug and keep using prepared statements, I finally ended up rebuilding MySQL 5.0.16 from cooker, and using that instead. You could also probably downgrade to the MySQL build from 2005LE.