ejabberd - Comments for "mod_logdb: Could not connect to MySQL Server"

Seberoth, Can you please

rumcho — Wed, 11 Apr 2012 23:02:29 +0000

Seberoth,
Can you please elaborate - what is the version of ejabberd you got it to work on and where you found the mysql_conn.erl source file with "start/7"? I only find source files with "start/6".
I actually found one that has "start/7" but it breaks big time, here're some excerpts from the ejabberd log file:
==============================
=INFO REPORT==== 2012-04-11 14:53:40 ===
I(<0.264.0>:mod_logdb_mysql5:142) : Opening mysql connection root@server.localdomain:3306/db123

=ERROR REPORT==== 2012-04-11 14:53:40 ===
Error in process <0.266.0> on node 'ejabberd@localhost' with exit value: {function_clause,[{mysql_conn,do_recv,[[65536,131072],<0.268.0>,undefined]},{mysql_conn,mysql_init,5},{mysql_conn,init,8}]}

...

=ERROR REPORT==== 2012-04-11 14:53:45 ===
E(<0.264.0>:mod_logdb_mysql5:127) : MySQL connection failed: "timed out"

==============================

Looking at mysql query logs, it doesn't issue any commands to my mysql server, not even authentication; netstat shows "TIME_WAIT" but never actually goes into "ESTABLISHED" for (ejabberd) <---> (mysql server) connection
I don't know any erlang so I'm at loss here. Any help/clues would be greatly appreciated.

Now its working. Thanks

Seberoth — Wed, 25 Aug 2010 16:11:26 +0000

Now its working. Thanks

Check your config

mfoss — Wed, 11 Aug 2010 17:23:05 +0000

Seberoth wrote:

Ok. Now I use a mysql_conn.beam wirh start/7. But now i get the next error^^

    exception exit: {function_clause,
                        [{mysql_conn,start,
                             ["localhost","3306","ejabberd","test",
                              "jabberlog",
                              [65536,131072],
                              #Fun<mod_logdb_mysql5.1.37672236>]},
                         {mod_logdb_mysql5,init,1},

The only differnce is the "exception exit: {function_clause".

The function start wants the port to be an integer, like 3306, but you provided a string like "3306" (or maybe it's a bug in mod_logdb?).

Check your configuration file and replace "3306" with 3306.

Ok. Now I use a

Seberoth — Thu, 05 Aug 2010 18:35:39 +0000

Ok. Now I use a mysql_conn.beam wirh start/7. But now i get the next error^^

=CRASH REPORT==== 5-Aug-2010::20:26:03 ===
  crasher:
    pid: <0.1244.0>
    registered_name: 'mod_logdb_mysql5_web-sim.de'
    exception exit: {function_clause,
                        [{mysql_conn,start,
                             ["localhost","3306","ejabberd","test",
                              "jabberlog",
                              [65536,131072],
                              #Fun<mod_logdb_mysql5.1.37672236>]},
                         {mod_logdb_mysql5,init,1},
                         {gen_server,init_it,6},
                         {proc_lib,init_p,5}]}
      in function  gen_server:init_it/6
    initial call: gen:init_it(gen_server,<0.1243.0>,self,
                              {local,'mod_logdb_mysql5_web-sim.de'},
                              mod_logdb_mysql5,
                              ["web-sim.de",
                               [{user,"ejabberd"},
                                {password,"test"},
                                {server,"localhost"},
                                {port,"3306"},
                                {db,"jabberlog"}]],
                              [])
    ancestors: ['ejabberd_mod_logdb_web-sim.de',ejabberd_sup,<0.850.0>]
    messages: []
    links: []
    dictionary: []
    trap_exit: false
    status: running
    heap_size: 610
    stack_size: 23
    reductions: 163
  neighbours:

The only differnce is the "exception exit: {function_clause".

Seberoth wrote: Hi, i have

mfoss — Mon, 02 Aug 2010 14:14:06 +0000

Seberoth wrote:

Hi,

i have ejabberd 2.1.4 and try to run mog_logdb. But it can't connect to the MySQL Database (5.1.41).
I also tried it with MySQL 5.0.xx

erlang.log:

    exception exit: {undef,
                        [{mysql_conn,start,
                             ["localhost","3306","xxx","xxx",
                              "jabberlog",
                              [65536,131072],
                              #Fun<mod_logdb_mysql5.1.37672236>]},
                         {mod_logdb_mysql5,init,1},
                         {gen_server,init_it,6},
                         {proc_lib,init_p,5}]}

I tried the patched MySQL Driver, the newest from SVN and http://code.google.com/p/erlang-mysql-driver/

Can anyone help me?

The error means that erlang couldn't find a file called mysql_conn.beam, or that the file was found but it doesn't export a function called start/7, where 7 is the 7 arguments that mod_logdb_mysql5 provided in that function call.

Now you can check all the different mysql_conn.erl versions that you have downloaded, and find one that contains something like this:

-export([start/7,
   ...

Once you find the proper mysql driver, compile it and install it (or copy it with all the other ejabberd *.beam files).