Can not use my mysql db for user auth

Openfire Openfire Support
1

I have two problems:

My first question is: how I can use a password in another mysql db? The password field in mysql looks like

5en6G6MezRroT3XKqkdPOmY/BfQ=

I have tested it with:

<jdbcAuthProvider>
     <passwordSQL>SELECT password FROM user WHERE username=?</passwordSQL>
     <passwordType>sha1</passwordType>
  </jdbcAuthProvider>

he run this query but I can’t login to my admin console

Later I have testet a more simple one. I create a db oftest with user table and plain password.

If I change the database settings and set passwordType to plain. It doesn’t work too…

Any idea?

Thanks!

cu