I am, using SUSE 13.1 and 3.9.1 with MySQL 5.6.12
Everything was ok until I upgraded from SUSE 12.3 to 13.1. Then all user logins were no longer authorised. I checked all the usual suspects including missing php5-mcrypt and I loaded the latest mysql.jar connector.
This is what happens:
If I set plain passwords in the database and set the encrypted passwords to null then everything works fine.
If I set a new user password the user can still log in ok. New passwords generate an encrypted password and delete the plain one.
If I restart Openfire then the previously good user log-in fails authorisation. I re-enter the password in Admin and the user can log-in again.
It’s like the encryption changes with each log-in.
Any idea what is going on?
Any way to force plain passwords until I sort it so I can at least create new users without database hacking?
David Goadby