Mysql Integration on Openfire and Candy

Hi firenaut,

i’m new user of this jabber server and i’ve brige it with Candy chat on my website as a shoutbox. I’m trying to use my existing database with openfire successfully with the doc, but it’s not like i want ^^’

My users tables extract :

id
pseudo
mail
1
elfaus
me@example.com

I would like people could connect on the serv with their id (and password) and the pseudo should display on candy.

I’m trying a lot but can’t do what I want, name = nickname at everytime

Currently i’m doing that :

jdbcAuthProvider.passwordSQL
SELECT password FROM mom_users WHERE id=?
jdbcAuthProvider.passwordType
md5
jdbcProvider.connectionString
jdbc:mysql://127.0.0.1/mydb?user=myuser&password=mypass
jdbcProvider.driver
com.mysql.jdbc.Driver
jdbcUserProvider.allUsersSQL
SELECT id,pseudo FROM mom_users
jdbcUserProvider.emailField
mail
jdbcUserProvider.loadUserSQL
SELECT id,pseudo FROM mom_users WHERE id=?
jdbcUserProvider.nameField
pseudo
jdbcUserProvider.searchSQL
SELECT pseudo FROM mom_users WHERE
jdbcUserProvider.userCountSQL
SELECT COUNT(*) FROM mom_users
jdbcUserProvider.usernameField
id

Plus, i’m using 3.7.1 version cause i can’t make the latest release working together with candy :s