Password encryption problem

Hey guys,

at first I’d like to thank you all for this great jabber software!

I like it

I just describe my problem:

I installed openfire and everything went fine.

As database I used Mysql which was installed and also that worked fine.

Then I saw an article about password encryption. I guess it was this one: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/db-integ ration-guide.html

And so I copied this code

org.jivesoftware.openfire.auth.JDBCAuthProvider

SELECT password FROM user_account WHERE username=?

sha512

and pasted it in my openfire.xml.

Than I restarted openfire and wanted to login in the web panel. But the only thing I saw was the setup page.

So reinstalled openfire again with the web panel and than I wanted to login again but the setup page was again there.

I changed nothing in the database, I only pasted this code into the openfire.xml.

Can you tell me what I have done wrong?

Thanks

Okay I could solve it.

You don’t need to these lines in the openfire.xml!

Just install openfire normal and login in with the web interface.

then switch to system settings and add this line at the bottom

jdbcAuthProvider.passwordType

256

than your password will saved as sha256 i guess.

i worked 3 hours on it and the problem was so simple! wow!!