powered by Jive Software

Affiliation based conversation log


I’m currently working on a moderated Chat. I have 4 roles… Admin, Moderator, VIP and Participant.

I allready store a xml log file out of the OfMucConversationLog Table.

Instead of a conversation log I want to have a more an event based log… which means I want to store the role of the user who sent the message. The problem, I don’t kno how to do.

The Table OfMucAffiliation doesn’t help much because it just distinguishes between admin or not admin.

Did I may overlooked something helpful in the database schema?

An idea is to add a column to the OfMucConversation Table like “role”. So that evertime the message gets send it also stores the role of the user.

Adding a table is not the problem but is there any possibility to change and influence what openfire automatically stores into the DB?

If yes, how could I do this?

Thank you!

Best Regards


you may want to write your own monitoring plugin using the Openfire API to log or store the things you need. Modifying the default tables is a bad idea as this may break Openfire updates.



I guess that would be a solution. Thanks.

Is it a good idea to use the Monitoring Service plugin to develop and change it further for my requirements?

I read the plugin developer guide but i didn’t find the information i searched for…

I tried to look into the source code of the monitorin service plugin to get a first impression about accessing and writing into a DB but I didn’t find or was not able to see the source code.

Is the source code within the lib folder with the filename.jar.pack files? How could I look into the source code?


you can download the source code here: http://www.igniterealtime.org/downloads/source.jsp or use SVN http://www.igniterealtime.org/fisheye/viewrep/svn-org/openfire

Take also a look at http://www.igniterealtime.org/community/docs/DOC-1020 or http://www.igniterealtime.org/community/docs/DOC-1022 to setup your development environment.

In http://www.igniterealtime.org/community/docs/DOC-1041 you’ll find some more plugins, they usually include the source code.

I did not look at the source code of the plugins so I can’t recommend one or the other to extend.