Openfire Database

Openfire Openfire Support
1

I just recently installed the Monitoring Service plugin and everything is working well. I can view reports and one on one conversations through the admin console. I had our DB admin create a 2005 SQL DB in our SQL farm for Openfire. The question I have is where are these logs saved? I believe there are saved in the DB. But where in the db and how can I do a clean up on the data so it doesn’t get out of control? Any help and or links to help would be great. Adam

2

fluxy3 wrote:

The question I have is where are these logs saved? I believe there are saved in the DB.

This is correct. Cant say where exactly.

3

Thanks for the reassurance.

Does anyone know where in the database the Monitoring Services stores the logs? The best way to clean up old logs?

4

database tables ofConversation and ofMessageArchive

5

Thanks! I found the tables on the SQL DB. I don’t have much knowledge with DB. Could you please help me understand how to administrate the DB? Any information on what to delete would help a lot.