Openfire 3.9.x (anything above 3.8.2 ) and mysql

Hi, any time I try to use openfire 3.9 and mysql it fails to authenticate.

If it’s a upgrade or even if i do a fresh install what I get in the logs is

java.sql.SQLException: Unable to load authentication plugin

also I note that even in a empty database when I import openfire/resources/database/openfire_mysql.sql

I get ERROR 1050 (42S01) at line 4: Table ‘ofUser’ already exists

If I run 3.8.2 I dont run into these mysql issues.

Any Pointers would be greatly appreciated.

Net Nut

can’t reproduce your error …

i have openfire 3.9.x installed on win2008r2 x64 amd ubuntu 14 x64 both are connecting fine to a mysql db stored on a linux server.

did you select mySQL or MSSQL … thats a difference : )

I am running this on centos 7 (happened when I was still using centos 6.x as well)

and even a fresh install I have trouble getting 3.9 to use mysql but 3.8.2 is working fine