Solved

Openfire Server - Recover Admin Password

Posted on 2014-12-30
3
4,001 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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 …
Article by: Ahmedn1
Introduction Some developers today tend to use Skypekit in their applications to make it more interactive with the user. Skype API is very awesome indeed but the problem is it is only available in C++, Java and Python. I can't understand why Micr…
The goal of the tutorial is to teach the user how to instant message and make a video call in Skype.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

751 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