Mysql Database Problem

Openfire Openfire Support
1

Hi, I want to use useres from an existing mysql database for Openfire but if I insert the database information into the openfire.xml, i get no mysql traffic (and surely I can’t log into the adminconsolewithout db information). subscriber is the name of the directory the username and password are stored in.Here is my openfire.xml:

true 9090 9091 de com.mysql.jdbc.Driver jdbc:mysql://192.168.1.233:3306/openser?user=***;password=*** org.jivesoftware.openfire.auth.JDBCAuthProvider org.jivesoftware.openfire.user.JDBCUserProvider SELECT password FROM subscriber WHERE username=? plain SELECT name,email FROM subscriber WHERE username=? SELECT COUNT(*) FROM subscriber SELECT username FROM subscriber SELECT username FROM subscriber WHERE username last_name email_adress

true

Anyone an idea?