same problem here. Any fix?

gbello — Sun, 25 Sep 2011 20:52:33 +0000

Hi Anh25721, i need your

eniquall — Wed, 06 Jul 2011 10:03:45 +0000

Hi Anh25721, i need your fixes too, please share it in some way.
Thanks a lot.

Can you upload / paste your changes?

Franky — Mon, 28 Mar 2011 17:24:01 +0000

anh25721 wrote:

In fact this module mod_admin_extra was just blindly trying to write to internal DB.

We have fixed this issue, but i do not know how to upload this fixes.

Hi Anh25721,

Would you mind sharing your changes? I have hit the exact same issue...

Thank you in advance

--Franky

Paste anywhere

mfoss — Tue, 08 Mar 2011 19:10:16 +0000

anh25721 wrote:

In fact this module mod_admin_extra was just blindly trying to write to internal DB.

We have fixed this issue, but i do not know how to upload this fixes.

If it is few lines (less than 30 lines), you can put here in a comment. If it is long, you can put in http://pastebin.com/ or http://paste.jabbim.cz/ and then comment here the URL.

I'll either commit your patch to SVN, or upload the patch to a permanent page.

ejabberdclt does not work with odbc

anh25721 — Tue, 08 Mar 2011 18:04:41 +0000

In fact this module mod_admin_extra was just blindly trying to write to internal DB.

We have fixed this issue, but i do not know how to upload this fixes.

Update

synack — Tue, 08 Mar 2011 13:39:37 +0000

dbl post :(

Update

synack — Mon, 07 Mar 2011 09:15:06 +0000

Thought I would post a update.

I've managed to insert a entry into the db and now when I run ejabberdctl get_roster it is actually returning the entry. Also, when I log on, the web interface is showing the contact too. How ever, if I add a roster entry via the web interface, which is still basically executing the add_rosteritem command, then no entry shows up in the mySQL db, but it does show up in the web interface.

What this says to me, is that when get_roster is being run by the web interface, it's getting results from the mnesia db AND the mySQL db.

I've upped the logging to level 5 and I can see some select statements being run for get roster, how ever, no insert/update statements are being run for adding a roster entry.

I've included bits of a log entry of a add rosteritem command executes


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1698.0>:ejabberd_commands:314) : Executing command mod_admin_extra:add_rosteritem with Args=["42",
                                                                                                  "host.net",
                                                                                                  "24912",
                                                                                                  "host.net",
                                                                                                  "Garth",
                                                                                                  "Contacts",
                                                                                                  "both"]


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1698.0>:ejabberd_router:313) : route
	from {jid,"42","host.net","ijabE258D","42",
                  "host.net","ijabE258D"}
	to {jid,"42","host.net","ijabE258D","42",
                "host.net","ijabE258D"}
	packet {xmlelement,"iq",
                   [{"type","set"},{"id","push"}],
                   [{xmlelement,"query",
                        [{"xmlns","jabber:iq:roster"}],
                        [{xmlelement,"item",
                             [{"jid","24912@host.net"},
                              {"name","Garth"},
                              {"subscription","both"}],
                             [{xmlelement,"group",[],
                                  [{xmlcdata,"Contacts"}]}]}]}]}


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1698.0>:ejabberd_local:286) : local route
	from {jid,"42","host.net","ijabE258D","42",
                  "host.net","ijabE258D"}
	to {jid,"42","host.net","ijabE258D","42",
                "host.net","ijabE258D"}
	packet {xmlelement,"iq",
                           [{"type","set"},{"id",[...]}],
                           [{xmlelement,[...],...}]}



=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1144.0>:ejabberd_c2s:1205) : broadcast
[{item,{"24912","host.net",[]},both}]


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1144.0>:ejabberd_c2s:1936) : roster changed for "42"


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1695.0>:ejabberd_http_bind:899) : OutPacket: [{xmlstreamelement,
                                                    {xmlelement,"iq",
                                                     [{"from",
                                                       "42@host.net/ijabE258D"},
                                                      {"to",
                                                       "42@host.net/ijabE258D"},
                                                      {"type","set"},
                                                      {"id","push"}],
                                                     [{xmlelement,"query",
                                                       [{"xmlns",
                                                         "jabber:iq:roster"}],
                                                       [{xmlelement,"item",
                                                         [{"jid",
                                                           "24912@host.net"},
                                                          {"name","Garth"},
                                                          {"subscription",
                                                           "both"}],
                                                         [{xmlelement,
                                                           "group",[],
                                                           [{xmlcdata,
                                                             "Contacts"}]}]}]}]}}]


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1699.0>:ejabberd_http:135) : S: [{["r3st"],mod_rest},
                                      {["admin"],ejabberd_web_admin},
                                      {["http-bind"],mod_http_bind},
                                      {["http-poll"],ejabberd_http_poll}]


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1143.0>:ejabberd_http_bind:410) : New request: {http_put,3553578,
                                                     [{"xmlns",
                                                       "http://jabber.org/protocol/httpbind"},
                                                      {"rid","3553578"},
                                                      {"sid",
                                                       "9fb97d543f8b73c5326965f5ce9b5985e26f8629"}],
                                                     [],112,1,[],
                                                     {{192,168,2,1},49466}}

=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1143.0>:shaper:61) : State: {maxrate,1000,3.7650727139653224,
                                     1299487891766445}, Size=112
M=56.10562087112097, I=4587.914


=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1143.0>:ejabberd_http_bind:550) : New request: {http_put,3553578,
                                                     [{"xmlns",
                                                       "http://jabber.org/protocol/httpbind"},
                                                      {"rid","3553578"},
                                                      {"sid",
                                                       "9fb97d543f8b73c5326965f5ce9b5985e26f8629"}],
                                                     [],112,1,[],
                                                     {{192,168,2,1},49466}}

=INFO REPORT==== 2011-03-07 10:51:36 ===
D(<0.1143.0>:ejabberd_http_bind:668) : reqlist: [{hbr,3553578,[],[]},
                                                 {hbr,3553577,[],
                                                  [{xmlstreamelement,
                                                    {xmlelement,"iq",
                                                     [{"from",
                                                       "42@host.net/ijabE258D"},
                                                      {"to",
                                                       "42@host.net/ijabE258D"},
                                                      {"type","set"},
                                                      {"id","push"}],
                                                     [{xmlelement,"query",
                                                       [{"xmlns",
                                                         "jabber:iq:roster"}],
                                                       [{xmlelement,"item",
                                                         [{"jid",
                                                           "24912@host.net"},
                                                          {"name","Garth"},
                                                          {"subscription",
                                                           "both"}],
                                                         [{xmlelement,
                                                           "group",[],
                                                           [{xmlcdata,
                                                             "Contacts"}]}]}]}]}}]}]

ejabberd - Comments for "Rosters in mySQL"

same problem here. Any fix?

Hi Anh25721, i need your

Can you upload / paste your changes?

Paste anywhere

ejabberdclt does not work with odbc

Update

Update