Every time I sign out from a client, I see the following error log on ejabberd server (v.2.1.6 on CentOS 5.6).
I do use mysql mode for auth.
Here is my c2s part from the config file:
{listen,
[
%%{5222, ejabberd_c2s, [
%% {certfile, "/opt/ejabberd-2.1.6/conf/server.pem"}, starttls,
%% {access, c2s},
%% {shaper, c2s_shaper},
%% {max_stanza_size, 65536}
%% ]},
%%
%% To enable the old SSL connection method in port 5223:
%%
%%{5223, ejabberd_c2s, [
%% {certfile, "/opt/ejabberd-2.1.6/conf/server.pem"}, tls,
%% {access, c2s},
%% {shaper, c2s_shaper},
%% {max_stanza_size, 65536}
%% ]},
{5222, ejabberd_c2s, [
{access, c2s},
{shaper, c2s_shaper},
{max_stanza_size, 65536}
]},
...
Here is the error log I receive:
=INFO REPORT==== 2011-05-08 10:44:27 ===
I(<0.774.0>:ejabberd_c2s:1449) : ({socket_state,gen_tcp,#Port<0.725>,<0.773.0>}) Close session for user1@xmpp.mydomain.com/29357069011304869418701126
=ERROR REPORT==== 2011-05-08 10:44:27 ===
E(<0.774.0>:mod_pubsub_odbc:3624) : transaction return internal error: {aborted,
{aborted,
no_transaction}}
=ERROR REPORT==== 2011-05-08 10:44:27 ===
E(<0.774.0>:ejabberd_hooks:294) : {{badmatch,
{error,
{xmlelement,"error",
[{"code","500"},{"type","wait"}],
[{xmlelement,"internal-server-error",
[{"xmlns",
"urn:ietf:params:xml:ns:xmpp-stanzas"}],
[]}]}}},
[{mod_pubsub_odbc,
'-purge_offline/1-fun-0-',4},
{lists,foldl,3},
{mod_pubsub_odbc,purge_offline,1},
{ejabberd_hooks,run1,3},
{ejabberd_sm,
close_session_unset_presence,5},
{ejabberd_c2s,terminate,3},
{p1_fsm,terminate,7},
{proc_lib,init_p,5}]}
running hook: {sm_remove_connection_hook,
[{{1304,869418,805106},<0.774.0>},
{jid,"user1","xmpp.mydomain.com",
"29357069011304869418701126","user1",
"xmpp.mydomain.com","29357069011304869418701126"},
[{ip,{{24,160,200,87},50251}},
{conn,c2s},
{auth_module,ejabberd_auth_odbc}]]}
Does anyone have any idea why and what is wrong with it?
Thank you in advance,
Kamila
anybody have any idea?
anybody have any idea?
So just to let you guys know
So just to let you guys know that this error goes away if I disable mod_pubsub_odbc.
There is definitely something wrong in mod_pubsub_odbc module. I have tried so many different variation for config settings and installation (from source, from binary).
Thanks
Re
I have tried so many different variation for config settings and installation (from source, from binary).
Did you try to set the plugins as odbc too, as mentioned in the Guide?
{modules, [ ... {mod_pubsub_odbc, [ {access_createnode, pubsub_createnode}, {plugins, ["flat_odbc", "hometree_odbc", "pep_odbc"]} ]}, ... ]}.When I set that plugins values, the error you mentioned doesn't appear.
Thank you very much. Setting
Thank you very much. Setting the plugins to odbc fixed the problem.
Plugins were not mentioned in the guide. Only thing mentioned is the modules.
Thank you again for your help.