Openfire store plain password in mysql base

Openfire Openfire Support
1

I would like that openfire store user passwords like plain text in external db

I tried following:

1.insert in db.ofProperty (‘jdbcAuthProvider.passwordType’, ‘plain’); not work

2.insert in db.ofProperty ‘jdbcAuthProvider.passwordSQL’, ‘SELECT plainPassword FROM ofUser WHERE username=?’) not work

Can anyone help me plz?

2

Hi!!!

I found answer in docs on this site

password in my sql query is unencrypted. If you set the user.usePlainPassword to true in web console, or direct in db.

INSERT INTO ofProperty (name, propValue) VALUES (‘user.usePlainPassword’,‘true’);

3

Hi, One question, I need unactive the option PLAIN authentication to my server, someone can helpme with this, thanks! …