Solved

Openfire Server - Recover Admin Password

Posted on 2014-12-30
3
3,592 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Sometimes we have such a need to use two Skype accounts, for example, you may have a personal and a business account that you want to keep separate. By default, Skype can be run only once. Attempting to start it a second time fails. However, we …
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

820 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