How do we store chat conversations on MySQL database? XMPP Openfire

Question

I am building a web chat application. I want to store the messages or conversations between two parties after every press of "Enter" button. I am using Openfire Server, and MySQL database. I don't see any tables from the database that stores the conversations.

Is there a plugins for that? thanks. I am using strophe js library to send messages. Thanks.

Answer 1

Conversations are only stored if the 'Conversation State Archiving' is enabled under Server-->Archiving-->Archiving Settings in your Openfire Admin Console, and 'Message Archiving' is enabled for either 'Archive one-to-one chats' and/or 'Archive group chats'. Thereafter, the messages are stored in the MySQL database table 'ofMessageArchive'.

This table contains an incrementally updated 'conversationID', UNIX timestamp, and JIDs of conversation participants.

Hope this helps!

Answer 2

You need a plug n for that "Monitoring Services" available under Plugin tab in your admin console. Install that plugin and boom, you are ready to go!