Openfire 3.6.4 on debian with mysql

Openfire Openfire Support
1

I’m running Openfire on a Debian Lenny server with a MySQL backend. The default admin user can authenticate to the control panel, but not to chat via a Spark client.

I don’t see anything in the error or warn logs that suggests anything is broken or wrong. When I fail authentication, there isn’t even any error generated.

Here is my openfire.xml… it’s pretty basic:

<?xml version="1.0" encoding="UTF-8"?> 9090 9091 en org.jivesoftware.database.DefaultConnectionProvider com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/openfire openfire PASSWORD select 1 true true 3 50 1.0 true

What am I missing to let users authenticate against MySQL?