mod_log_chat_mysql

Developed by Jérôme Sautret jerome.sautret@process-one.net, Adapted for DB Logging by Michael Weibel michael.weibel@amiadogroup.com.

Prerequisite

In order to compile Emysql, Erlang R13 or newer will need to be installed. If you are using the 2.1.10 ejabberd installer, that comes with an old version of Erlang and you will not be able to compile Emysql.

Installation

Download Emysql: https://github.com/Eonblast/Emysql
cd Emysql && make
Make sure that emysql.app is present in the Emysql/ebin folder. If not build the Emysql module again.
In another directory download ejabbed-modules from subversion: svn co https://svn.process-one.net/ejabberd-modules
Copy Emysql/ebin/* to your ejabberd-modules (ebin) folder: cp Emysql/ebin/* ejabberd-modules/ejabberd-dev/trunk/ebin/
Download mod_log_chat_mysql5 : git clone https://github.com/candy-chat/mod_log_chat_mysql5.git
Move the mod_log_chat_mysql5 directory into the root of the ejabberd-modules folder
Navigate to the mod_log_chat_mysql5 directory in the ejabberd-modules folder and call ./build.sh
If successful the module has been compiled and output to ebin/mod_log_chat_mysql5.beam. Copy this file to your ejabberd system ebin folder folder (e.g. /usr/lib/ejabberd/ebin on Debian)
Copy all the Emysql files to your ejabberd system ebin folder as well. (Emysql/ebin/*)
Create required mysql table like this

    CREATE TABLE mod_log_chat_mysql5 (
       id INT AUTO_INCREMENT PRIMARY KEY,
       fromJid VARCHAR(255) NOT NULL, 
       toJid VARCHAR(255) NOT NULL, 
       sentDate TIMESTAMP NOT NULL, 
       body TEXT, 
       type VARCHAR(10)
    ) ENGINE=MyISAM CHARACTER SET utf8;

See conf/ejabberd.conf.sample for an example configuration
Once the ejabberd module is loaded and you have started ejabberd. Look at the log files to see if the module has been correctly started (erlang.log)

candy-chat/mod_log_chat_mysql5

mod_log_chat_mysql

Prerequisite

Installation