ejabberd - Comments for "ejabberd v2.1.11 mod_muc_odbc not working" https://www.ejabberd.im/node/5448 en nice work! guys, where can I https://www.ejabberd.im/node/5448#comment-59099 <p>nice work!<br /> guys, where can I find the link for mod_muc_odbc and mysql-schema for this?<br /> I have mod_muc_odbc but I haven't Mysql tables.<br /> old versions had two Mysql tables: muc_registered and muc_room, so they are always empty...</p> Wed, 26 Sep 2012 15:02:48 +0000 DeMiRioN comment 59099 at https://www.ejabberd.im Hi, Thanks. I changed the https://www.ejabberd.im/node/5448#comment-58785 <p>Hi,</p> <p>Thanks. I changed the ejabberd.cfg file i.e. uncomment the "%%host..." statement as below, then the problem is resolved. It is my configuration file error.</p> <p>{mod_muc_odbc, [{host, "conference.@HOST@"},</p> Mon, 11 Jun 2012 03:46:06 +0000 cmeng comment 58785 at https://www.ejabberd.im First, I must say that I'm https://www.ejabberd.im/node/5448#comment-58655 <p>First, I must say that I'm not competent in this area. I don't use this module, neither do I use ODBC. The following is speculation based on source and logs only.</p> <p>The problem appears in the following sequence of calls:<br /> mod_muc_odbc:load_permanent_rooms(... Serverhost...) -&gt; ejabberd_odbc:sql_query(LServer, ...) -&gt; sql_call(Host ...) -&gt; ejabberd_odbc_sup:get_random_pid(Host) -&gt; get_pids(Host). The last call returns empty result, thus the next call to erlang:phash(now(), length(Pids)) is executed as erlang:phash(now(), 0), and this is naturally a <noindex><a href="http://www.erlang.org/doc/reference_manual/errors.html#id81672" rel="nofollow" >badarg</a></noindex> (see <noindex><a href="http://www.erlang.org/doc/man/erlang.html#phash-2" rel="nofollow" >phash</a></noindex>).</p> <p>The problem may be either some bug (then developers will hopefully fix it), or some sort of misconfiguration on your part: something could have gone wrong when you created the ODBC structure for 2.1.11; or you have remnants of a Host in your config that is absent from the ODBC...</p> <p>You could try to narrow down the specific Host that causes this, by inserting<br /> <code>?ERROR_MSG(&quot;~p&quot;, [LServer]),</code><br /> between lines 536 and 537 of mod_muc_odbc.erl. Then the host name would appear before the abovementioned error.</p> <p>HTH.</p> Mon, 14 May 2012 11:52:04 +0000 mikekaganski comment 58655 at https://www.ejabberd.im