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:
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
The latest mysql schema is here:
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.