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.