ejabberd + mysql on Debian Lenny

Submitted by marekc12 on Thu, 2010-06-24 10:51

Installation problems

Hello,

i have installed ejabberd and mysql-server on Debian Lenny. I want to configure ejabberd to use MySQL.

What i did:

aptitude install erlang build-essential
wget http://www.process-one.net/downloads/ejabberd/2.1.4/ejabberd-2.1.4.tar.gz
tar -xvzf ejabberd-2.1.4.tar.gz
cd ejabberd-2.1.4/src
./configure --enable-odbc
make
make install

And i changed these lines in file 'ejabberd.cfg':

%%{auth_method, internal}
{auth_method, odbc}.
{odbc_server, {mysql, "localhost", "my_database", "root", "***"}}.

When i try to run ejabberd i get an error (in file: var/log/ejabberd/ejabberd.log):

=ERROR REPORT==== 2010-06-24 11:35:34 ===
C(<0.37.0>:ejabberd_check:63) : ejabberd is configured to use 'mysql', but the following Erlang modules are not installed: '[mysql,
mysql_auth,
mysql_conn,
mysql_recv]'
=INFO REPORT==== 2010-06-24 11:35:34 ===
    application: ejabberd
    exited: {bad_return,{{ejabberd_app,start,[normal,[]]},
                         {'EXIT',database_module_missing}}}
    type: temporary

I don't know how to install modules: mysql, mysql_auth, mysql_conn, mysql_recv.

marekc12 wrote: I don't know

Submitted by badlop on Thu, 2010-06-24 11:06.

marekc12 wrote:

I don't know how to install modules: mysql, mysql_auth, mysql_conn, mysql_recv.

It's mentioned in
http://www.process-one.net/en/ejabberd/guide_en#compilemysql

Short instructions:
1. svn checkout http://svn.process-one.net/ejabberd-modules/mysql/trunk/ mysql
2. ./build.sh
3. Copy the beam files
4. Start ejabberd again

location of the beam files

Submitted by loboloco on Thu, 2010-10-07 13:54.

i did the build and resulted in a src dir containing the following files:
mysql_auth.erl
mysql_conn.erl
mysql.erl
mysql.hrl
mysql_recv.erl

now where exactly need the files to be copied?

I'm running ubuntu server 9.04 with ejabberd installation from the ubuntu repositories.

Same as other ejabberd beam files

Submitted by badlop on Mon, 2010-10-11 14:24.

loboloco wrote:

now where exactly need the files to be copied?

I'm running ubuntu server 9.04 with ejabberd installation from the ubuntu repositories.

You can copy them to the same directory were all the other ejabberd beam files are already copied: /usr/lib/ejabberd/ebin/
See:
http://packages.ubuntu.com/jaunty/i386/ejabberd/filelist