ejabberd on CentOS Linux, binary install via EPEL repo - mod_logdb MySQL driver included?

Hi everyone

I'm looking to log all users' chats sent through our corporate IM server so that we can build a module on our intranet to allow users to view/search their logs. So they don't have to rely on their IM client's logging settings.

I'm perfectly comfortable with creating the user interface for the logs myself. The problem I have is getting the chats sent through ejabberd into a database for me to be able to access. Fortunately the mod_logdb module looks like it will work for this.

I installed ejabberd on CentOS Linux using the Fedora EPEL repository and at the moment we're using ejabberd's internal DB. Users are authenticated via LDAP.

From reading some of the documentation it appears I might need to re-compile/install from source to include the MySQL 5 database drivers.
I'm referring to this page... http://www.dp.uz.gov.ua/o.palij/mod_logdb/

Are they built in to my binary installation already - as part of being able to use mysql under the odbc_server config?
Or is a different mysql driver needed for mod_logdb?

I'm running ejabberd 2.18 per this package...
http://download.fedora.redhat.com/pub/epel/5/x86_64/repoview/ejabberd.html

Cheers, B

batfastad wrote: Are they

batfastad wrote:

Are they built in to my binary installation already - as part of being able to use mysql under the odbc_server config?

Check if you have th file mysql.beam

If not, then download the mysql erlang driver source code or binaries
Source code: http://www.ejabberd.im/ejabberd-modules
Binaries: https://support.process-one.net/doc/display/MESSENGER/Using+relational+d...

Hi there. Thanks for that

Hi there.
Thanks for that information. I've downloaded the binary but that's given me more questions.

How can I check which version of the binary drivers I need?
Is there a way to check my Erlang version?
r12b5/binary-r13b4/r14b3?

The ejabberd binary installed from EPEL repository is: 2.1.8-2.el5

Also to where should I copy the *.beam files on a CentOS 64bit system?
There are currently .beam files located in the following directories...
/usr/lib64/ejabberd/ebin/
/usr/lib64/erlang/lib/ic-4.2.19/ebin/
/usr/lib64/erlang/lib/orber-3.6.10/ebin/

Cheers, B

batfastad wrote: Thanks for

batfastad wrote:

Thanks for that information. I've downloaded the binary but that's given me more questions.

How can I check which version of the binary drivers I need?
Is there a way to check my Erlang version?
r12b5/binary-r13b4/r14b3?

The ejabberd binary installed from EPEL repository is: 2.1.8-2.el5

Try:

$ erl
Erlang R14B04 (erts-5.8.5) [source] [smp:2:2] [rq:2] [async-threads:0] [kernel-poll:false]

Eshell V5.8.5  (abort with ^G)
1> 
batfastad wrote:

Also to where should I copy the *.beam files on a CentOS 64bit system?
There are currently .beam files located in the following directories...
/usr/lib64/ejabberd/ebin/
/usr/lib64/erlang/lib/ic-4.2.19/ebin/
/usr/lib64/erlang/lib/orber-3.6.10/ebin/

Probably in
/usr/lib64/ejabberd/ebin/

Hi there. Thanks for the

Hi there. Thanks for the reply.

Here's the response to that command...

[root@files ~]# erl
Erlang (BEAM) emulator version 5.6.5 [source] [64-bit] [smp:2] [async-threads:0] [hipe] [kernel-poll:false]

Eshell V5.6.5  (abort with ^G)
1>

This doesn't look like the output that you pasted.

Cheers, B

batfastad wrote: Erlang

batfastad wrote:

Erlang (BEAM) emulator version 5.6.5

Ok, that is R12B-5.

Syndicate content