mod_muc_odbc error at startup

When I start ejabberd (or restart) i get the following in my /var/log/ejabberd.log:

=INFO REPORT==== 2013-11-05 14:37:19 ===
I(<0.4101.0>:ejabberd_app:89) : ejabberd 2.1.11 is stopped in the node 'ejabberd@<domain-a>'

=INFO REPORT==== 2013-11-05 14:37:22 ===
I(<0.4610.0>:cyrsasl_digest:44) : FQDN used to check DIGEST-MD5 SASL authentication: "jabber.<domain>.hr"

=ERROR REPORT==== 2013-11-05 14:37:22 ===
E(<0.5020.0>:mod_muc_odbc:537) : {badarg,
                                  [{erlang,phash,[{1383,658642,322701},0],[]},
                                   {ejabberd_odbc_sup,get_random_pid,1,
                                    [{file,"ejabberd_odbc_sup.erl"},
                                     {line,108}]},
                                   {ejabberd_odbc,sql_call,2,
                                    [{file,"ejabberd_odbc.erl"},{line,124}]},
                                   {mod_muc_odbc,load_permanent_rooms,5,
                                    [{file,"mod_muc_odbc.erl"},{line,533}]},
                                   {mod_muc_odbc,init,1,
                                    [{file,"mod_muc_odbc.erl"},{line,207}]},
                                   {gen_server,init_it,6,
                                    [{file,"gen_server.erl"},{line,304}]},
                                   {proc_lib,init_p_do_apply,3,
                                    [{file,"proc_lib.erl"},{line,239}]}]}

And everything seems to work fine after that (then again, it's a new install on test and i haven't done much testing).

My (relevant part of) config is as follows:

%% Admins of this server are also admins of MUC service:
{access, muc_admin, [{allow, admin}]}.

%% All users are allowed to use MUC service:
{access, muc, [{allow, all}]}.

  {mod_muc_odbc, [
                  {host, "conference.@HOST@"},
                  {access, muc},
                  {access_create, muc},
                  {access_persistent, muc},
                  {access_admin, muc_admin}
                 ]},

I tried google, but with no luck.

Have you insert in dns A

Have you insert in dns A value, refered to "conference"?

Try to turn off mod_muc_odbc

%% {mod_muc_odbc, [
%% {host, "conference.@HOST@"},
%% {access, muc},
%% {access_create, muc},
%% {access_persistent, muc},
%% {access_admin, muc_admin}
%% ]},

I don't have all the domains

I don't have all the domains in DNS, but even if i change config to:

  {mod_muc_odbc, [
                {host, "conference.jabber.<domain>.com"},
                {access, muc},
                {access_create, muc},
                {access_persistent, muc},
                {access_admin, muc_admin}
               ]},

for which i have a dns record:

# dig conference.jabber.<domain>.com

; <<>> DiG 9.8.4-rpz2+rl005.12-P1 <<>> conference.jabber.<domain>.com
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 37211
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 1, ADDITIONAL: 1

;; QUESTION SECTION:
;conference.jabber.<domain>.com. IN A

;; ANSWER SECTION:
conference.jabber.<domain>.com. 259200 IN A XXX.YYY.0.163

;; AUTHORITY SECTION:
jabber.<domain>.com. 259200 IN NS ns1.jabber.<domain>.com.

;; ADDITIONAL SECTION:
ns1.jabber.<domain>.com. 259200 IN A XXX.YYY.0.165

;; Query time: 1 msec
;; SERVER: XXX.YYY.0.165#53(XXX.YYY.0.165)
;; WHEN: Thu Nov  7 09:38:28 2013
;; MSG SIZE  rcvd: 93

i still get the error:

=ERROR REPORT==== 2013-11-07 09:34:52 ===
E(<0.2354.0>:mod_muc_odbc:537) : {badarg,
                                  [{erlang,phash,[{1383,813292,555596},0],[]},
                                   {ejabberd_odbc_sup,get_random_pid,1,
                                    [{file,"ejabberd_odbc_sup.erl"},
                                     {line,108}]},
                                   {ejabberd_odbc,sql_call,2,
                                    [{file,"ejabberd_odbc.erl"},{line,124}]},
                                   {mod_muc_odbc,load_permanent_rooms,5,
                                    [{file,"mod_muc_odbc.erl"},{line,533}]},
                                   {mod_muc_odbc,init,1,
                                    [{file,"mod_muc_odbc.erl"},{line,207}]},
                                   {gen_server,init_it,6,
                                    [{file,"gen_server.erl"},{line,304}]},
                                   {proc_lib,init_p_do_apply,3,
                                    [{file,"proc_lib.erl"},{line,239}]}]}

And if i comment out the mod_muc_odbc i get no error.

Syndicate content