Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Openfire Server - Recover Admin Password

Posted on 2014-12-30
3
Medium Priority
?
5,582 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 24

Expert Comment

by:Mohammed Hamada
ID: 40525307
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
ID: 40531938
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
ID: 40541819
This was the only solution that worked.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Yahoo Messenger is one of web's most popular free IM (Instant Messenger) services. Yahoo messenger is very popular with teens who like to use it everyday to be in contact with their friends and family members. It has become a part of the daily life …
Months ago my boss came to me with a simple request, “How can we minimize GoTo meeting accounts and also improve our integration and collaboration initiatives?”  Well the answer, with some research, was easy… Lync.  Lync provided us all the necessar…
The goal of the tutorial is to teach the user how to instant message and make a video call in Skype.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

564 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