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.
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).