I would like to know if anyone knows what OpenFire database table and associated field that denotes if a room is persisted or not. I need to load test my OpenFire development environment and I have a .NET Windows Form application using Jabber-Net to remove all created rooms for my OpenFire domain and service; this could potentially be up to 5K rooms if not more. Unfortunately it does not appear I can programmatically remove persisted rooms so one idea I had is a could update the database and revert this “flag” and the perform the room removals with this application.
Getting closer… for reference here is the schema for the OpenFire Database.
Openfire: Database Schema Guide
I did not fine the specific table and field used to flag a persisted room but I did end up revising my .NET Winform application with Jabber-Net to remove persistent rooms. With that said I guess I can close this up.