Our organization would like to keep only 60 days worth of messages archived on the server at any time. This would be a rolling window. I have not found a way in OpenFire to tell it to keep only 60 days of messages. I am thinking that I may have to create a MySQL stored procedure that hits the ofconversation and ofmessagearchive tables. I do not want to truncate them. The challenge comes in the date format for those tables. I don’t know how to carry out a select statement on date columns using a bigint(20) type.
If OpenFire has a property that handles this which I am not aware of, please inform me. Otherwise, I’d love to see some suggestions on how to create the stored procedure that would handle the job.
Thanks for your help.