How do we store chat conversations in a MySQL database? XMPP Openfire

Question

I am creating a web chat application. I want to save messages or conversations between two parties after each press of the "Enter" button. I am using Openfire Server and a MySQL database. I do not see any tables from the database in which the conversations are stored.

Are there any plugins for this? Thank you I use the strophe js library to send messages. Thank you

Answer 1

Conversations are saved only if “Archiving conversation status” is enabled in the section “Server → Archiving → Archiving options in the Openfire admin console” and “Message archiving” is enabled for “One-on-one message archiving” and / or “Archived group chats'. After this, messages are stored in the MySQL database table 'ofMessageArchive'.

This table contains a step-by-step updated “conversation identifier”, UNIX timestamp, and JID of the conversation participants.

Hope this helps!

Answer 2

You will need the n plug-in for this Monitoring Service, available on the Plugin tab in the admin console. Install this plugin and arrow, you are ready to go!