v 1.1.1 on Gentoo Linux fails to work with MySQL

Here's what I get when I start ejabberd configured to use mysql, although I've made ejabberd user, ejabber table and imported /usr/share/doc/ejabberd-1.1.1/mysql.sql:

=CRASH REPORT==== 15-May-2006::02:42:47 ===
  crasher:
    pid: <0.205.0>
    registered_name: []
    error_info: {undef,[{mysql_conn,start,
                                     ["localhost",
                                      3306,
                                      "ejabberd",
                                      "mypass",
                                      "ejabberd",
                                      #Fun]},
                         {ejabberd_odbc,mysql_connect,4},
                         {gen_server,init_it,6},
                         {proc_lib,init_p,5}]}
    initial_call: {gen,init_it,
                      [gen_server,
                       <0.204.0>,
                       <0.204.0>,
                       ejabberd_odbc,
                       ["mydomain.org"],
                       []]}
    ancestors: ['ejabberd_odbc_sup_mydomain.org',ejabberd_sup,<0.40.0>]
    messages: []
    links: [<0.204.0>]
    dictionary: []
    trap_exit: false
    status: running
    heap_size: 377
    stack_size: 21
    reductions: 123
  neighbours:

=SUPERVISOR REPORT==== 15-May-2006::02:42:47 ===
     Supervisor: {local,
                                              'ejabberd_odbc_sup_mydomain.org'}
     Context:    start_error
     Reason:     {undef,[{mysql_conn,start,
                                     ["localhost",
                                      3306,
                                      "ejabberd",
                                      "mypass",
                                      "ejabberd",
                                      #Fun]},
                         {ejabberd_odbc,mysql_connect,4},
                         {gen_server,init_it,6},
                         {proc_lib,init_p,5}]}
     Offender:   [{pid,undefined},
                  {name,1},
                  {mfa,{ejabberd_odbc,start_link,["mydomain.org"]}},
                  {restart_type,transient},
                  {shutdown,brutal_kill},
                  {child_type,worker}]


=PROGRESS REPORT==== 15-May-2006::02:42:47 ===
          supervisor: {local,ejabberd_sup}
             started: [{pid,<0.229.0>},
                       {name,'ejabberd_mod_echo_mydomain.org'},
                       {mfa,{mod_echo,start_link,
                                      ["mydomain.org",[{host,"echo.mydomain.org"}]]}},
                       {restart_type,temporary},
                       {shutdown,1000},
                       {child_type,worker}]

My /etc/jabber/ejabberd.cfg is:

override_global.
override_local.
override_acls.

{acl, local, {user_regexp, ""}}.

{access, configure, [{allow, admin}]}.

{access, register, [{allow, all}]}.

{welcome_message,
 {"Welcome!",
  "Welcome to Jabber Service.  "
  "For information about Jabber visit http://jabber.org"}}.

{access, announce, [{allow, admin}]}.

{access, c2s, [{deny, blocked},
               {allow, all}]}.

{shaper, normal, {maxrate, 1000}}.

{shaper, fast, {maxrate, 50000}}.

{access, c2s_shaper, [{none, admin},
                      {normal, all}]}.

{access, s2s_shaper, [{fast, all}]}.

{access, muc_admin, [{allow, admin}]}.

{access, muc, [{allow, all}]}.

{auth_method, odbc}.
{odbc_server, {mysql, "localhost", "ejabberd", "ejabberd", "mypass"}}.

{hosts, ["mydomain.org"]}.

{language, "en"}.

{listen,
 [{5222, ejabberd_c2s,     [{access, c2s}, {shaper, c2s_shaper},
                            {max_stanza_size, 65536},
                            starttls, {certfile, "./ssl.pem"}]},
  {5223, ejabberd_c2s,     [{access, c2s},
                            {max_stanza_size, 65536},
                            tls, {certfile, "./ssl.pem"}]},
  % Use these two lines instead if TLS support is not compiled
  %{5222, ejabberd_c2s,     [{access, c2s}, {shaper, c2s_shaper}]},
  %{5223, ejabberd_c2s,     [{access, c2s}, ssl, {certfile, "./ssl.pem"}]},
  {5269, ejabberd_s2s_in,  [{shaper, s2s_shaper},
                            {max_stanza_size, 131072}
                           ]},
  {5280, ejabberd_http,    [http_poll, web_admin]},
  {8888, ejabberd_service, [{access, all},
                            {hosts, ["icq.mydomain.org", "sms.mydomain.org"],
                             [{password, "mypass"}]}]}
 ]}.

{s2s_use_starttls, true}.
{s2s_certfile, "./ssl.pem"}.

{outgoing_s2s_port, 5269}.

{modules,
 [
  {mod_register,   [{access, register}]},
  {mod_roster_odbc,     []},
  {mod_privacy,    []},
  {mod_adhoc,      []},
  {mod_configure,  []}, % Depends on mod_adhoc
  {mod_configure2, []},
  {mod_disco,      []},
  {mod_stats,      []},
  {mod_vcard_odbc,      []},
  {mod_offline_odbc,    []},
  {mod_announce,   [{access, announce}]}, % Depends on mod_adhoc
  {mod_echo,       [{host, "echo.mydomain.org"}]},
  {mod_private,    []},
  {mod_muc,        [{access, muc},
                    {access_create, muc},
                    {access_admin, muc_admin}]},
  {mod_pubsub,     []},
  {mod_time,       []},
  {mod_last_odbc,       []},
  {mod_version,    []}
 ]}.

Re: v 1.1.1 on Gentoo Linux fails to work with MySQL

tnt wrote:

error_info: {undef,[{mysql_conn,start,

It seems ejabberd can't find the Mysql Erlang library. Maybe you didn't install it, or it isn't on the right directory...

Syndicate content