https://www.ejabberd.im/node/2743 en https://www.ejabberd.im/node/2743#comment-59277 <p>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.</p> <p>So to install mod_archive I need to do this, the typical:<br /> &gt;&gt; svn co <noindex><a href="https://svn.process-one.net/ejabberd-modules" title="https://svn.process-one.net/ejabberd-modules" rel="nofollow" >https://svn.process-one.net/ejabberd-modules</a></noindex><br /> &gt;&gt; cd ejabberd-modules/mod_archive/trunk<br /> &gt;&gt; ./build.sh<br /> &gt;&gt; cp ebin/*modules in EJABBERD<br /> &gt;&gt; and configure /etc/ejjaberd.cfg</p> <p>¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ but with this methods EJABBERD does not work!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</p> <p>So I discover that we need to compile other MODULE that are not explained in any site. The module is called CONN_MYSQL</p> <p>¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡We need CONN_MYSQ!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!</p> <p>And we can get in the same ejabber-modules dowloaded. So in SVN (<noindex><a href="https://svn.process-one.net/ejabberd-modules" title="https://svn.process-one.net/ejabberd-modules" rel="nofollow" >https://svn.process-one.net/ejabberd-modules</a></noindex>) there are cd ejabberd-modules/mysql/trunk ./build.sh cp ebin/*modules in EJABBERD</p> <p>And work !!! Fine!!! :D :D</p> <p>I need a lot of hours to discover this :'(</p> <p>I can not use this line configuration in ejabberd.cfg: {odbc_server, "DSN=ejabberd;UID=ejabberd;PWD=ejabberd"} because aplication crashes and says this:</p> <p>=ERROR REPORT==== 2012-11-28 18:01:08 === E(&lt;0.437.0&gt;: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"}], []}]}</p> <p>So I use this line in ejabberd.cfg: {odbc_server, {mysql, "server", "database", "username", "password"}}.</p> <p>and this line into the modules configuration: {mod_archive_odbc, [{database_type, "mysql"}, {default_auto_save, true}, {enforce_default_auto_save, true}]},</p> <p>So, now works!!!!!!!!!</p> <p>I don't remmember if I use</p> <p>'trunk' or 'branches/ejabberd-2.0.x' in Emakefile . You could try one and if not works you could try the other.</p> <p>Ah! and remmember to compile with:<br /> ./configure --enable-odbc</p> <p>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"</p> <p>maybe it is necessary this packages: "apt-get install iodbc libmyodbc"</p> <p>Good luck!!</p> Thu, 29 Nov 2012 12:31:07 +0000 cloudadmins_org comment 59277 at https://www.ejabberd.im https://www.ejabberd.im/node/2743#comment-51500 <p>Ok, you have the erlang module odbc, which is included in Erlang/OTP.</p> <p>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:</p> <pre>$ 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</pre> Sat, 22 Dec 2007 22:49:46 +0000 mfoss comment 51500 at https://www.ejabberd.im