Looking for ejabberd docs?

To access the most up-to-date ejabberd documentation, please visit docs.ejabberd.im »

ejabberd + mysql on Debian Lenny

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

ejabberd Administration

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 mfoss 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

Ok, it works. Thank you very

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

Ok, it works. Thank you very much.

I'm on Centos 6. I installed

Submitted by badai on Wed, 2014-11-26 10:04.

I'm on Centos 6. I installed ejabberd using yum from EPEL-Repository

Now where is the "beam" folder located?

Thanks.

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 mfoss 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

Do i need to compile it

Submitted by jayeshjain24 on Wed, 2014-10-29 06:08.

Do i need to compile it first,follow some procedure or directly put the .erl files in the ebin directory?