Does ejabberd support storing muc room information in MySQL database?

Question

I was trying ejabberd (the latest version on the ProcessOne site) on Ubuntu Linux and configured it to store data in a MySQL database.

When I add users I can see them in the users table but nothing about muc rooms appears in any of the tables.

Looking at the guide it was not clear if ejabberd supports this. I need easy access to muc room information in the database because other parts of our system are going to use this data.

Does ejabberd (I am using v15.03) support storing muc room info (room jid ,room subjects and room chat history) in an external database such as MySQL? If not, what about Openfire? Would you recommend Openfire on this?

Answer 1

ejabberd supports SQL backend for MUC. You need to configure mod_muc to use proper db_type. Please refer to mod_muc ejabberd documentation

Please note that:

• MUC room configuration is only stored in database for persistent chat room. Make sure your rooms are configured accordingly if you want them to be store.
• Short term history is kept in memory. This is what is automatically resent when user joins a MUC room.
• Message archive rely on XEP-0313: Message Archive Management XMPP extensions. Make sure it is enable and configured appropriately to store content in database. Please read ejabberd documentation on mod_mam