Openfire Server - Recover Admin Password

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.
LVL 5
jkeegan123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohammed HamadaSenior IT ConsultantCommented:
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
jkeegan123Author Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jkeegan123Author Commented:
This was the only solution that worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Chat / IM

From novice to tech pro — start learning today.