How To Recover Openfire admin Password

By Angsuman Chakraborty, Gaea News Network
Monday, October 22, 2007

Openfire is a cross-platform java based free Instant Messaging server which implements the XAMPP (Jabber) protocol with extensions. It is very well suited as corporate instant messaging solution. Here is how you can recover the admin password, in case you forget it.

How to recover Openfire admin password

1. Login to MySQL and use openfire database. I use the command:
mysql -uroot -p openfire

2. Display the password for the admin user with the query:
select password from jiveUser where username = 'admin';

This will display the initially chosen password for admin. However if you have at any time changed the password from the administration screen then it will display NULL instead.
After first change the password is encrypted and stored in the encryptedPassword field and cannot be recovered.

However you can change the password even without knowing the original password.

How to change Openfire admin password

Change the admin (or any other users) password by setting password field to chosen value and encryptedPassword field to null. For example here is the query to set the admin password to 123456:
update jiveUser set password='123456', encryptedPassword = null where username ='admin';

This will change the current admin password to 123456. Remember to change it to a different value after you login to the admin console. This will also have the side-effect of encrypting your password in database for added security.

Note: Openfire admin console is available at https://localhost:9090


hasan vidin
June 10, 2010: 11:25 am

Openfire Admin Login
How to change Openfire’s admin login when using Windows Vista and an embedded database:

1. Shut down Openfire
2. As the Windows Administrator,

C:\Program Files (x86)\Openfire\embedded-db\openfire.script

3. Change the line that looks something like this

INSERT INTO OFUSER VALUES(’admin’,NULL,”, ‘Administrator’,'admin’,'0′,’0′)


INSERT INTO OFUSER VALUES(’admin’,”,NULL, ‘Administrator’,'admin’,'0′,’0′)

4. Save the file, exit the editor
5. Restart Openfire

April 28, 2009: 11:04 am

The command for current versions of openfire (3.6.x) is a little different than this guide.

update ofuser set plainPassword=’123456′, encryptedPassword = null where username =’admin’;

jiveuser is ofuser, and password becomes plainPassword.

February 6, 2009: 3:31 pm

I wasn’t able to follow your instructions to find out my password. I’m using Openfire 3.6.3 on Ubuntu.

However, your post was helpful because it lead me to the conclusion that I could get the password from mysql.

I used the following mySQL commands:

USE openfire;
SHOW tables;

There, I saw that there was a table called ofUser. So I used:

SHOW columns FROM ofUser;

I then used

and discovered that the default password for user admin was admin, though I had entered a different password. I tried that password, and it worked!

will not be displayed