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