ejabberd : replace mnesia with mysql [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 9 years ago.

Improve this question

Is there any way to setup mysql in place of mnesia. any help on th开发者_Python百科is is much appreciated. Everything for me went on fine. Also I need to archive the history text.

Thanks in advance Abraham

---

Check out these links:

http://www.ndl.kiev.ua/content/mod_archive_odbc-release (Skip the first part about the erlang driver) https://support.process-one.net/doc/display/MESSENGER/Using+ejabberd+with+MySQL+native+driver http://www.ejabberd.im/ejabberd-modules

I sucesfully setup message archiving on a windows machine after some work, but still need to document the process...

The basic process is get the mod_archive_odbc files from the ejabberd SVN as described in the first link. Compiel the .erl file and put the .beam file in your lib//ebin directory. (For windows binary installs, put the .erl file into the /bin directory of your ejabberd installation and run (third link):

erlc -I includes/ejabberd/include mod_<name>.erl

After you place the .beam file, you should follow the directions for setting up mysql native DB, run the mod_archive_odbc_mysql.sql script on your mysql ejabberd DB, configure e-jabberd and then restart the server. (Note: if you don't migrate the mnesia data, you will have to manually re-create the admin user.)

Good Luck!

---

It seems you can. Read here.