I'm using Openfire 4.0.2 with Swift client. I sent some message to an offline user and I like to delete it. Where offline messages stored?
In the database. In Openfire: Database Schema Guide ofOffline table. There is no GUI to delete them. You will have to edit the database.
Can you show me how can I do it?
if the username is "test" then can you show me the correct commands?
I can't, I'm not a db guy. You will have to stop Openfire and then edit your database with a suitable tool based on the type of database. If you are using the embedded one, it is text based. You can open /openfire/embedded-db/openfire.script and search for the messages. You should keep the structure when editing. Of course, do backup first as direct database editing is not recommended.
I found the solution but the problem is that it will remove all offline messages from all users. In MySQL console write:
> show databases;
> use openfire;
> show tables;
> delete from ofoffline;
You should be able to delete individual entries. Maybe with Select command filtering out what you need to delete.
Retrieving data ...