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
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...