powered by Jive Software

Encrypted Passwords stop working after Openfire restart. OK with plain

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