module mod_muc_odbc for Mysql. Need your help.

Hi all! Guys, I've got ejabberd 2.1.11.
where can I find the link for mod_muc_odbc and mysql-schema for this module?
now I have mod_muc_odbc from here: http://git.deb.at/w/pkg/ejabberd.git/tree/7c6629c5619bdb039a87af6bb89c6b...

but I haven't Mysql tables.
old versions had two Mysql tables: muc_registered and muc_room, they are always empty, though conference works...
I need extract data from Mysql about chats.

so I need any working mod_muc with MySql + schema.

help me please.. I'm waiting for your answers...

The latest mysql schema is

Thank you very much - I'll

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

can you save the data to

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

I cannot open a muc_odbc

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

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

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: []

Note the above post is

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.

Syndicate content