ejabberd - Comments for "module mod_muc_odbc for Mysql. Need your help."

Note the above post is

stony999 — Tue, 21 May 2013 15:03:40 +0000

Note the above post is happening when I have manually set up an entry in the muc_rooms tabele.
It dissappears when I delete this entry.

However I cannot open a muc_odbc conference.

My Config is (as of ejabberdctl dump file)
{mod_muc_odbc,
[{host,"conference.@HOST@"},
{access,muc},
{access_create,muc_create},
{access_persistent,muc_create},
{access_admin,muc_admin}]},

There are no errors in the log file.

If I change mod_muc_odbc to mod_muc it works.

Ngrepping the traffic I can see that odbc is working
Login user:

T 127.0.0.1:39266 -> 127.0.0.1:3306 [AP]
3....select password from users where username='admin';
#
T 127.0.0.1:3306 -> 127.0.0.1:39266 [AP]
.....8....def.ejabberd.users.users.password.password.!.........................password.........

Open a MUC

T 127.0.0.1:55881 -> 127.0.0.1:3306 [AP]
  Y....select opts from muc_room where name='main2' and host='conference.my_jabber.de';
#
T 127.0.0.1:3306 -> 127.0.0.1:55881 [AP]
  .....6....def.ejabberd.muc_room.muc_room.opts.opts.!..................................

So database connection is there.
I also manually entered an entry into the 'rooms' database table (with empty opts field), but no change.

Grepping on port 5222 I can see:

T 192.168.178.126:39428 -> 192.168.178.171:5222 [AP]
<message to='main2@conference.my_jabber.de' id='6' type='groupchat' xml:lang='de-DE'><body>test</body></message>
#
T 192.168.178.171:5222 -> 192.168.178.126:39428 [AP]
<message from='main2@conference.my_jabber.de' to='admin@my_jabber.de/tkabber' type='error' id='6' xml:lang='de-DE'><body>test</body><error code='503' type='cancel'><service-unavailable xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'/></error></message>

Any help is appreciated.

I just received a crash

stony999 — Tue, 21 May 2013 10:44:46 +0000

I just received a crash report:

=PROGRESS REPORT==== 21-May-2013::14:25:01 ===
          supervisor: {local,ejabberd_sup}
             started: [{pid,<0.325.0>},
                       {name,'ejabberd_mod_muc_sup_my_domain.de'},
                       {mfargs,
                           {ejabberd_tmp_sup,start_link,
                               ['ejabberd_mod_muc_sup_my_domain.de',
                                mod_muc_room]}},
                       {restart_type,permanent},
                       {shutdown,infinity},
                       {child_type,supervisor}]
=CRASH REPORT==== 21-May-2013::14:25:01 ===
  crasher:
    initial call: mod_muc_odbc:init/1
    pid: <0.326.0>
    registered_name: []
    exception exit: {undef,[{ejabberd_odbc,decode_term,[[]]},
                            {mod_muc_odbc,'-load_permanent_rooms/5-fun-0-',6},
                            {lists,foreach,2},
                            {mod_muc_odbc,init,1},
                            {gen_server,init_it,6},
                            {proc_lib,init_p_do_apply,3}]}
      in function  gen_server:init_it/6
    ancestors: [ejabberd_sup,<0.37.0>]
    messages: []
    links: [<0.62.0>,<0.226.0>]
    dictionary: []

I cannot open a muc_odbc

stony999 — Tue, 21 May 2013 10:37:11 +0000

I cannot open a muc_odbc conference.

My Config is (as of ejabberdctl dump file)
{mod_muc_odbc,
[{host,"conference.@HOST@"},
{access,muc},
{access_create,muc_create},
{access_persistent,muc_create},
{access_admin,muc_admin}]},

There are no errors in the log file.

If I change mod_muc_odbc to mod_muc it works.

Ngrepping the traffic I can see that odbc is working
Login user:

T 127.0.0.1:39266 -> 127.0.0.1:3306 [AP]
3....select password from users where username='admin';
#
T 127.0.0.1:3306 -> 127.0.0.1:39266 [AP]
.....8....def.ejabberd.users.users.password.password.!.........................password.........

Open a MUC

T 127.0.0.1:55881 -> 127.0.0.1:3306 [AP]
  Y....select opts from muc_room where name='main2' and host='conference.my_jabber.de';
#
T 127.0.0.1:3306 -> 127.0.0.1:55881 [AP]
  .....6....def.ejabberd.muc_room.muc_room.opts.opts.!..................................

So database connection is there.
I also manually entered an entry into the 'rooms' database table (with empty opts field), but no change.

Grepping on port 5222 I can see:

T 192.168.178.126:39428 -> 192.168.178.171:5222 [AP]
<message to='main2@conference.my_jabber.de' id='6' type='groupchat' xml:lang='de-DE'><body>test</body></message>
#
T 192.168.178.171:5222 -> 192.168.178.126:39428 [AP]
<message from='main2@conference.my_jabber.de' to='admin@my_jabber.de/tkabber' type='error' id='6' xml:lang='de-DE'><body>test</body><error code='503' type='cancel'><service-unavailable xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'/></error></message>

Any help is appreciated.

I cannot open a muc_odbc

stony999 — Tue, 21 May 2013 10:32:00 +0000

I cannot open a muc_odbc conference.

My Config is (as of ejabberdctl dump file)
{mod_muc_odbc,
[{host,"conference.@HOST@"},
{access,muc},
{access_create,muc_create},
{access_persistent,muc_create},
{access_admin,muc_admin}]},

There are no errors in the log file.

If I change mod_muc_odbc to mod_muc it works.

Ngrepping the traffic I can see that odbc is working
Login user:

T 127.0.0.1:39266 -> 127.0.0.1:3306 [AP]
3....select password from users where username='admin';
#
T 127.0.0.1:3306 -> 127.0.0.1:39266 [AP]
.....8....def.ejabberd.users.users.password.password.!.........................password.........

Open a MUC

T 127.0.0.1:55881 -> 127.0.0.1:3306 [AP]
  Y....select opts from muc_room where name='main2' and host='conference.my_jabber.de';
#
T 127.0.0.1:3306 -> 127.0.0.1:55881 [AP]
  .....6....def.ejabberd.muc_room.muc_room.opts.opts.!..................................

So database connection is there.
I also manually entered an entry into the 'rooms' database table (with empty opts field), but no change.

Grepping on port 5222 I can see:

T 192.168.178.126:39428 -> 192.168.178.171:5222 [AP]
<message to='main2@conference.my_jabber.de' id='6' type='groupchat' xml:lang='de-DE'><body>test</body></message>
#
T 192.168.178.171:5222 -> 192.168.178.126:39428 [AP]
<message from='main2@conference.my_jabber.de' to='admin@my_jabber.de/tkabber' type='error' id='6' xml:lang='de-DE'><body>test</body><error code='503' type='cancel'><service-unavailable xmlns='urn:ietf:params:xml:ns:xmpp-stanzas'/></error></message>

Any help is appreciated.

can you save the data to

MKC — Thu, 21 Mar 2013 16:54:43 +0000

can you save the data to mysql when you use the latest mysql schema???
i met the same problem,even i used the latest mysql schema,there is no data in mysql.how can you did it

Thank you very much - I'll

DeMiRioN — Sat, 13 Oct 2012 06:32:05 +0000

Thank you very much - I'll try that! ;)

The latest mysql schema is

cybpsy — Fri, 12 Oct 2012 07:55:45 +0000

The latest mysql schema is here: https://github.com/processone/ejabberd/blob/2.1.x/src/odbc/mysql.sql