HELP! Admin Account Deleted

I just took over control of the admin for Spark and mistakenly deleted the admin user account from the Wildfire admin console. Any advice on how to fix this…being that I can’'t login to the admin console anymore.


Perhaps you could edit the conf/openfire.xml config file and add another JID to the section, restart wildfire and see if you can get in with a different account. Then you could regenerate the admin account?


Thanks and don’'t laugh…but I have no idea how to do what you suggest. Do I do this by going to a command prompt?

Yes, you will need for example SSH access to your server if you want to modify this file. After that you will have to restart openfire.

Another way would be to create a new admin user. For this you will need direct access to your database. Simply create a new entry in table jiveUser. In MySQL prompt just enter the following command:

INSERT INTO jiveUser (username, email, password, creationDate, modificationDate) VALUES (''admin'','''',''yourNewAdminPassword'',0,0);

But on most servers access to the database will be firewalled for security reasons.



if you are using Windows and want to edit openfire.xml try to look for it in %programfiles%\Openfire\conf with the Explorer and make a copy of it. Use then your favorite editor to edit openfire.xml and save it with local encoding (not as UTF-8).


Hi All,
While deleting inactive users i mistakenly deleted the “admin” user from admin console and now my admin consol is opening fine but as admin deleted i can’t login to admin consol., openfire server installed on windows 10. I am using openfire inbuilt database ( embedded database )
I need to gain access to do my daily administration tasks to create new users and get reports etc …
Can you suggest me how to fix it ?
Exp : can i recreate admin users through any back end config file ?
can i give admin/administrator rights to aready existed normal user in openfire ?
any possible way kindly share …
waiting for replies…

This issue is fixable, After endless efforts i have overcome this issue but had bad experience bcoz no one replied on my issue from comunity, I edited the HSQL and fixed the issue.
If anyone facing similar just msg here or email i will happy to fix it. Solution is bit complex no matter which OS you have or which database you are with my sollution applied for all.

Talwinder, although I appreciate your attempt to help people recovering from this problem, reviving a thread that is over ten years old probably isn’t the best way of doing this. Furthermore, I would appreciate you writing down your solution, rather than directing people away from this community into your private inbox.

In any case: To temporarily restore access to the admin console of Openfire, you can configure Openfire to use a a One-Time Access Token. This process is described in