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

mysql xmpp openfire strophe
leeshin picture leeshin · Aug 22, 2013 · Viewed 9.9k times · Source

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

Radix picture Radix · Aug 29, 2013

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!

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More