All internet tutorials about

cloudadmins_org — Thu, 29 Nov 2012 12:31:07 +0000

All internet tutorials about mod_archive in Ejabberd are incomplete or very caotics. Or maybe are old. So my problem is that I am using Ubuntu 12.04 server LTS with Mysql. And I did all the things that are explained in all tutorials or blogs.

So to install mod_archive I need to do this, the typical:
>> svn co https://svn.process-one.net/ejabberd-modules
>> cd ejabberd-modules/mod_archive/trunk
>> ./build.sh
>> cp ebin/*modules in EJABBERD
>> and configure /etc/ejjaberd.cfg

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ but with this methods EJABBERD does not work!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

So I discover that we need to compile other MODULE that are not explained in any site. The module is called CONN_MYSQL

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡We need CONN_MYSQ!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

And we can get in the same ejabber-modules dowloaded. So in SVN (https://svn.process-one.net/ejabberd-modules) there are cd ejabberd-modules/mysql/trunk ./build.sh cp ebin/*modules in EJABBERD

And work !!! Fine!!! :D :D

I need a lot of hours to discover this :'(

I can not use this line configuration in ejabberd.cfg: {odbc_server, "DSN=ejabberd;UID=ejabberd;PWD=ejabberd"} because aplication crashes and says this:

=ERROR REPORT==== 2012-11-28 18:01:08 === E(<0.437.0>:mod_archive_odbc:867) : should_store_jid failed: {xmlelement, "error", [{"code","500"}, {"type", "wait"}], [{xmlelement, "internal-server-error", [{"xmlns", "urn:ietf:params:xml:ns:xmpp-stanzas"}], []}]}

So I use this line in ejabberd.cfg: {odbc_server, {mysql, "server", "database", "username", "password"}}.

and this line into the modules configuration: {mod_archive_odbc, [{database_type, "mysql"}, {default_auto_save, true}, {enforce_default_auto_save, true}]},

So, now works!!!!!!!!!

I don't remmember if I use

'trunk' or 'branches/ejabberd-2.0.x' in Emakefile . You could try one and if not works you could try the other.

Ah! and remmember to compile with:
./configure --enable-odbc

the ejabberd source code. You can get this in "wget http://www.process-one.net/en/ejabberd/ejabberd/2.1.11/ejabberd-2.1.11.tgz"

maybe it is necessary this packages: "apt-get install iodbc libmyodbc"

Good luck!!

./configure --enable-odbc

mfoss — Sat, 22 Dec 2007 22:49:46 +0000

Ok, you have the erlang module odbc, which is included in Erlang/OTP.

However, that error message seems to complain that you don't have installed the erlang module 'ejabberd_odbc', which is included in ejabberd. When you are compiling ejabberd, remember to enable odbc:

$ cd ejabberd/src

$ ./configure --enable-odbc
...
checking whether build odbc... yes
config.status: creating odbc/Makefile
...

$ make
...
/usr/bin/erlc -W -I .. -pz .. -Dgeneric -o .. ejabberd_odbc.erl
/usr/bin/erlc -W -I .. -pz .. -Dgeneric -o .. ejabberd_odbc_sup.erl
...

$ make install

ejabberd - Comments for "mod_archive_odbc doesnt save messages"

All internet tutorials about

./configure --enable-odbc