mod_log_chat_mysql

Developed by Jérôme Sautret [email protected], Adapted for DB Logging by Michael Weibel [email protected].

Installation

• 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)
• 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)