Can't login to the Admin Console!

I tried to add another admin aside from myself to administer Openfire but he was not able to login. I added another entry to admin.authorizedJIDs and his login was just below mine. So out of curiosity, I logged out of my session and tried to log back in but now I can’t login. I can’t login at all!! Is there a way to undo those changes from the back end? I do not want to have to reinstall because I just did it yeseterday resulting in much inconvenience for my staff.

Please help.

Thanks

Greg

Hi Greg,

you could delete admin.authorizedJIDs from table OFPROPERTY and restart Openfire. Or set it only to “admin@your-xmpp-domain” and restart Openfire.

LG

How do I edit the database when using the embeddedb?

Hi Greg,

this should make it even more easy to comment a change. First shutdown Openfire and then backup the embedded-db folder.

Take a look at “embedded-db/openfire.log” and delete every line which contains OFPROPERTY. This should help a lot, the lines should like:

/C88/DELETE FROM OFPROPERTY WHERE NAME=‘admin.authorizedJIDs’
INSERT INTO OFPROPERTY VALUES(‘admin.authorizedJIDs’,’…’)

There’s is also a tool to view the database while Openfire is down, bin/extra/embedded-db-viewer.sh if you prefer using SQL.

LG

++ You can even run “grep OFPROPERTY openfire.log” while Openfire is running. If there is nothing than you need to edit the openfire.script file (while Openfire is not running).

Actually, you got me on the right track but the information was actually in openfire.script not .log. I deleted the information and was able to login.

Thaks

Greg