Openfire XMPP Admin password recovery
I tried to login today after a long time into my XMPP Server via admin console and to my surprise none of the passwords i normally use worked, hence the conlusion: “I forgot the password”.
In order to change the password for the admin user i logged into the database and manually changed the Column containing the encrypted password for the ‘admin’ user.
users are stored in ‘ofUser’ table and the password for ‘admin’ user can be changed (e.g ‘abc123′) using the following query:
UPDATE ofUser SET plainPassword='test123', encryptedPassword=NULL WHERE username='admin';
After the above change just restart the XmppServer and you are good to go!
And one more important thing “Dont forget to change the password after logging in!”