ejabberd: retrieve chat history from mysql db

Question

I'm building a chat system based on ejabberd using an iOS client (and XMPPFramework).

My current chat system supports only one-on-one conversations between users saving a chat history on a MySQL database.

In order to recreate the same chat system, i'd need ejabberd to retrieve chat history from my database so the users don't lose previous conversations when switching to the new chat system.

I'd like not to save the conversation client-side since the iOS app can be deleted and reinstalled (or the user could switch device).

Is it possible to make ejabberd read chat history from my MySQL db?

Answer 1

This should be possible with mod_archive_odbc. It's an additional ejabberd module that you can find by checking out http://svn.process-one.net/ejabberd-modules/ with SVN. An example on how to build and install a module on Debian can be found here.