I have a running cluster running full mnesia (ejabber 2.1.5).
I try to set up this cluster against ODBC and native mysql driver for authentication and for every module that support ODBC, but when I start the secondary node, it writes in the log indefinitely :
E(<0.38.0>:ejabberd_rdbms:67) : Start of supervisor 'ejabberd_odbc_sup_MY.DOMAIN.COM' failed:
{error,{{'EXIT',{badarg,[{ets,delete,[sql_pool,"MY.DOMAIN.COM"]},
{mnesia,delete,5},
{mnesia_tm,non_transaction,5},
{ejabberd_odbc_sup,start_link,1},
{supervisor,do_start_child,2},
{supervisor,handle_start_child,2},
{supervisor,handle_call,3},
{gen_server,handle_msg,5}]}},
{child,undefined,'ejabberd_odbc_sup_MY.DOMAIN.COM',
{ejabberd_odbc_sup,start_link,["MY.DOMAIN.COM"]},
transient,infinity,supervisor,
[ejabberd_odbc_sup]}}}
Retrying...Cluster initial setup seems ok (ejabberd1 webadmin shows the second node).
Do you have any idea ?
Here is the conf on 1 :
override_global.
override_local.
override_acls.
{loglevel, 3}.
{acl, admin, {user, "valentin", "MY.DOMAIN.COM"}}.
{hosts, ["MY.DOMAIN.COM"]}.
{listen,
[
{5222, ejabberd_c2s, [
{access, c2s},
{shaper, c2s_shaper},
{max_stanza_size, 65536},
starttls, {certfile, "/usr/local/ejabberd-2.1.5/etc/ejabberd/ejabberd.pem"}
]},
{5269, ejabberd_s2s_in, [
{shaper, s2s_shaper},
{max_stanza_size, 131072}
]},
{5280, ejabberd_http, [
http_bind,
web_admin
]}
]}.
{s2s_use_starttls, true}.
{s2s_certfile, "/usr/local/ejabberd-2.1.5/etc/ejabberd/ejabberd.pem"}.
{auth_method, odbc}.
{odbc_server, {mysql, "10.10.10.10", "DATABASE", "ejabberd", "PASS"}}.
{odbc_keepalive_interval, 120}.
{shaper, normal, {maxrate, 1000}}.
{shaper, fast, {maxrate, 50000}}.
{max_fsm_queue, 1000}.
{acl, local, {user_regexp, ""}}.
{access, max_user_sessions, [{10, all}]}.
{access, max_user_offline_messages, [{5000, admin}, {100, all}]}.
{access, local, [{allow, local}]}.
{access, c2s, [{deny, blocked},
{allow, all}]}.
{access, c2s_shaper, [{none, admin},
{normal, all}]}.
{access, s2s_shaper, [{fast, all}]}.
{access, announce, [{allow, admin}]}.
{access, configure, [{allow, admin}]}.
{access, muc_admin, [{allow, admin}]}.
{access, muc_create, [{allow, local}]}.
{access, muc, [{allow, all}]}.
{access, pubsub_createnode, [{allow, all}]}.
{access, register, [{allow, all}]}.
{language, "en"}.
{modules,
[
{mod_adhoc, []},
{mod_announce, [{access, announce}]}, % recommends mod_adhoc
{mod_caps, []},
{mod_configure,[]}, % requires mod_adhoc
{mod_disco, []},
{mod_http_bind, []},
{mod_last_odbc, []},
{mod_muc, [
{access, muc},
{access_create, muc_create},
{access_persistent, muc_create},
{access_admin, muc_admin}
]},
{mod_offline_odbc, [{access_max_user_messages, max_user_offline_messages}]},
{mod_ping, []},
{mod_privacy_odbc, []},
{mod_private_odbc, []},
{mod_pubsub_odbc, [
{access_createnode, pubsub_createnode},
{ignore_pep_from_offline, true}, % reduces resource comsumption, but XEP incompliant
{last_item_cache, false},
{plugins, ["hometree_odbc", "pep_odbc"]} % pep requires mod_caps
]},
{mod_register, [
{welcome_message, {"Welcome!",
"Hi.\nWelcome to this XMPP server."}},
{access, register}
]},
{mod_roster_odbc, []},
{mod_stats, []},
{mod_time, []},
{mod_vcard_odbc, []},
{mod_version, []}
]}.Here is the conf on 2 :
{loglevel, 3}.
{acl, admin, {user, "valentin", "MY.DOMAIN.COM"}}.
{hosts, ["MY.DOMAIN.COM"]}.
{listen,
[
{5222, ejabberd_c2s, [
{access, c2s},
{shaper, c2s_shaper},
{max_stanza_size, 65536},
starttls, {certfile, "/usr/local/ejabberd-2.1.5/etc/ejabberd/ejabberd.pem"}
]},
{5269, ejabberd_s2s_in, [
{shaper, s2s_shaper},
{max_stanza_size, 131072}
]},
{5280, ejabberd_http, [
captcha,
http_bind,
web_admin
]}
]}.
{s2s_use_starttls, true}.
{s2s_certfile, "/usr/local/ejabberd-2.1.5/etc/ejabberd/ejabberd.pem"}.
{auth_method, odbc}.
{odbc_server, {mysql, "10.10.10.10", "DATABASE", "ejabberd2", "PASS"}}.
{odbc_keepalive_interval, 120}.
{shaper, normal, {maxrate, 1000}}.
{shaper, fast, {maxrate, 50000}}.
{max_fsm_queue, 1000}.
{acl, local, {user_regexp, ""}}.
{access, max_user_sessions, [{10, all}]}.
{access, max_user_offline_messages, [{5000, admin}, {100, all}]}.
{access, local, [{allow, local}]}.
{access, c2s, [{deny, blocked},
{allow, all}]}.
{access, c2s_shaper, [{none, admin},
{normal, all}]}.
{access, s2s_shaper, [{fast, all}]}.
{access, announce, [{allow, admin}]}.
{access, configure, [{allow, admin}]}.
{access, muc_admin, [{allow, admin}]}.
{access, muc_create, [{allow, local}]}.
{access, muc, [{allow, all}]}.
{access, pubsub_createnode, [{allow, all}]}.
{access, register, [{allow, all}]}.
{registration_timeout, 600}.
{language, "en"}.
{modules,
[
{mod_adhoc, []},
{mod_announce, [{access, announce}]}, % recommends mod_adhoc
{mod_caps, []},
{mod_configure,[]}, % requires mod_adhoc
{mod_disco, []},
{mod_http_bind, []},
{mod_last_odbc, []},
{mod_muc, [
{access, muc},
{access_create, muc_create},
{access_persistent, muc_create},
{access_admin, muc_admin}
]},
{mod_offline_odbc, [{access_max_user_messages, max_user_offline_messages}]},
{mod_ping, []},
{mod_privacy_odbc, []},
{mod_private_odbc, []},
{mod_pubsub_odbc, [
{access_createnode, pubsub_createnode},
{ignore_pep_from_offline, true}, % reduces resource comsumption, but XEP incompliant
{last_item_cache, false},
{plugins, ["hometree_odbc", "pep_odbc"]} % pep requires mod_caps
]},
{mod_register, [
{welcome_message, {"Welcome!",
"Hi.\nWelcome to this XMPP server."}},
{access, register}
]},
{mod_roster_odbc, []},
{mod_stats, []},
{mod_time, []},
{mod_vcard_odbc, []},
{mod_version, []}
]}.