Solved

Openfire Server - Recover Admin Password

Posted on 2014-12-30
3
2,717 Views
Last Modified: 2015-01-10
Hello,

I have installed the most recent version of OpenFire server v3.9.3.  I set it up with LDAP authentication against my Active Directory, and everything was working GREAT until I went into the server options and tried to add some additional admins.  The LDAP account that I installed with was listed as the admin (openfiresvc@servername), and I added a few other users.  After I did this, the listed admin then showed as HIDDEN...and after this, I was unable to login to the admin console of OPENFIRE, although the service will stop and start just fine.

How can I recover the admin password?  

Or if not, is there a way, in a config file, to add a NEW admin user?  

I did not use MYSQL or any other external database, the local database is whatever Openfire uses as the DEFAULT, the database type escapes me...and it's looking at LDAP/Active Directory for ALL users authentication, and it's working...but I cannot log in with the configured username that was setup as admin.

How can I reset the admin?  Or can I access the database from a command line and make modifications to the table to set the admin to ONLY be the configured account that was originally setup?  

IT's NOT MYSQL...it's not SQL...it's whatever Openfire uses as the default database type.
0
Comment
Question by:jkeegan123
  • 2
3 Comments
 
LVL 23

Expert Comment

by:Mohammed Hamada
Comment Utility
I think Openfire uses postgres database but it might be something else. Have you tried restart the server after installation ? if not try the second solution in this link ?
http://serverfault.com/questions/29529/openfire-installation-issue-cant-login-to-admin-panel

If you are using the embedded db on Windows, this will be in embedded-db/openfire.script:
INSERT INTO OFUSER VALUES('admin',NULL, ...
Change the NULL to your password. Then restart your OpenFire server.

Try this one too

https://community.igniterealtime.org/thread/34754

good luck
0
 
LVL 5

Accepted Solution

by:
jkeegan123 earned 0 total points
Comment Utility
I was using the embedded database, and was not able to resolve this.  I simply saved all settings, reinstalled the server, and wrote off a few hours of loss.  Everything worked after reinstall, and after this nightmare, I set the database to be MySQL on the same server.  It was fairly easy to initialize the MySQL database once installed, and everything has been working ever since.
0
 
LVL 5

Author Closing Comment

by:jkeegan123
Comment Utility
This was the only solution that worked.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Let Bitmoji into your life. Now is the time to learn a new language of smartphone messaging with this brief introduction.
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
The goal of the tutorial is to teach the user how to instant message and make a video call in Skype.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now