HSQL user roster corruption

Openfire Openfire Support
1

I had a user that entered a bad jabber ID. This has made the user unable to connect. Is there a way to delete the bad information directly from HSQL?

Here is the error from the server.

java.lang.IllegalArgumentException: Illegal JID: jhp_johnson

2

HSQL, you mean the embedded-db? Stop Openfire, open /openfire/embedded-db/openfire.script with a text editor and try to find a line starting with

INSERT INTO OFUSER VALUES(‘username’…

delete that line and save the file. Username is the user you want to delete.