How To Recover Openfire admin Password
By Angsuman Chakraborty, Gaea News NetworkMonday, 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
Tags: Jabber, Remember
|
June 10, 2010: 11:25 am
Openfire Admin Login 1. Shut down Openfire 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′) to INSERT INTO OFUSER VALUES(’admin’,”,NULL, ‘Administrator’,'admin’,'0′,’0′) 4. Save the file, exit the editor |
 openfireuser |
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: There, I saw that there was a table called ofUser. So I used:
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! |
hasan vidin