Hi All, Can you please hep me on the creation of shared roster group.
I have installed ejabberd 16.06 distribution in Windows 7 OS with MS SQL Server as the back-end database.
I can able to authenticate the users successfully.
I have created a shared roster group through admin panel and able to see the same in the 'sr_group' table.
But after giving the all the values it is saying 'Not Found'.
Here are ejabberd server logs:
2016-07-20 20:00:22.151 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select name from sr_group"
2016-07-20 20:00:23.181 [debug] <0.531.0>@ejabberd_http:process_header:281 (#Port<0.19079>) http query: 'GET' <<"/admin/server/nchat.com/shared-roster/Everybody/">>
2016-07-20 20:00:23.181 [debug] <0.531.0>@ejabberd_http:process:353 [<<"admin">>,<<"server">>,<<"nchat.com">>,<<"shared-roster">>,<<"Everybody">>] matches [<<"admin">>]
2016-07-20 20:00:23.182 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select password from users where username='admin'"
2016-07-20 20:00:23.184 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select password from users where username='admin'"
2016-07-20 20:00:23.186 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select opts from sr_group where name='Everybody'"
2016-07-20 20:00:23.188 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select jid from sr_user where grp='Everybody'"
2016-07-20 20:01:04.619 [debug] <0.531.0>@ejabberd_http:process_header:281 (#Port<0.19079>) http query: 'POST' <<"/admin/server/nchat.com/shared-roster/Everybody/">>
2016-07-20 20:01:04.619 [debug] <0.531.0>@ejabberd_http:extract_path_query:395 client data: <<"name=Everybody&description=Can+see+all+users&members=%40all%40&dispgroups=Everybody&submit=Submit">>
2016-07-20 20:01:04.619 [debug] <0.531.0>@ejabberd_http:process:353 [<<"admin">>,<<"server">>,<<"nchat.com">>,<<"shared-roster">>,<<"Everybody">>] matches [<<"admin">>]
2016-07-20 20:01:04.620 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select password from users where username='admin'"
2016-07-20 20:01:04.634 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select password from users where username='admin'"
2016-07-20 20:01:04.636 [debug] <0.430.0>@ejabberd_sql:sql_query_internal:570 SQL: "select jid from sr_user where grp='Everybody'"
2016-07-20 20:01:04.638 [debug] <0.427.0>@ejabberd_sql:sql_query_internal:570 SQL: "select name, opts from sr_group"
2016-07-20 20:01:04.639 [debug] <0.427.0>@ejabberd_sql:sql_query_internal:570 SQL: "begin;"
2016-07-20 20:01:04.640 [debug] <0.427.0>@ejabberd_sql:sql_query_internal:570 SQL: "UPDATE sr_group SET opts='[{name,<<\"Everybody\">>},\n {displayed_groups,[<<\"Everybody\">>]},\n {description,<<\"Can see all users\">>},\n {all_users,true}]' WHERE name='Everybody'"
2016-07-20 20:01:04.642 [debug] <0.427.0>@ejabberd_sql:sql_query_internal:570 SQL: "commit;"
2016-07-20 20:01:04.643 [debug] <0.427.0>@ejabberd_sql:sql_query_internal:570 SQL: "select opts from sr_group where name='Everybody'"
2016-07-20 20:01:04.645 [error] <0.531.0>@ejabberd_hooks:run_fold1:368 {{badmatch,{error,{1,erl_scan,{string,34,"Everybody\">>},\n "}},1}},[{ejabberd_sql,decode_term,1,[{file,"src/ejabberd_sql.erl"},{line,238}]},{mod_shared_roster_sql,get_group_opts,2,[{file,"src/mod_shared_roster_sql.erl"},{line,80}]},{mod_shared_roster,shared_roster_group,4,[{file,"src/mod_shared_roster.erl"},{line,919}]},{mod_shared_roster,webadmin_page,3,[{file,"src/mod_shared_roster.erl"},{line,844}]},{ejabberd_hooks,safe_apply,3,[{file,"src/ejabberd_hooks.erl"},{line,382}]},{ejabberd_hooks,run_fold1,4,[{file,"src/ejabberd_hooks.erl"},{line,365}]},{ejabberd_web_admin,process_admin,2,[{file,"src/ejabberd_web_admin.erl"},{line,1052}]},{ejabberd_http,process,5,[{file,"src/ejabberd_http.erl"},{line,363}]}]}
running hook: {webadmin_page_host,[<<"nchat.com">>,{request,'POST',[<<"shared-roster">>,<<"Everybody">>],[{<<"name">>,<<"Everybody">>},{<<"description">>,<<"Can see all users">>},{<<"members">>,<<"@all@">>},{<<"dispgroups">>,<<"Everybody">>},{<<"submit">>,<<"Submit">>}],{<<"admin">>,<<"nchat.com">>},{auth_jid,{<<"admin@nchat.com">>,<<"admin">>},{jid,<<"admin">>,<<"nchat.com">>,<<>>,<<"admin">>,<<"nchat.com">>,<<>>}},<<"en-US">>,<<"name=Everybody&description=Can+see+all+users&members=%40all%40&dispgroups=Everybody&submit=Submit">>,{{192,168,3,21},61191},<<"192.168.3.21">>,5280,[inet,{captcha,false},{http_bind,true},{web_admin,true},{request_handlers,[{<<"/websocket">>,ejabberd_http_ws}]},{ip,{0,0,0,0}}],http,[{'Cookie',<<"i18next=en">>},{'Accept-Language',<<"en-US,en;q=0.8,fr-FR;q=0.6,fr;q=0.4">>},{'Accept-Encoding',<<"gzip, deflate">>},{'Referer',<<"http://192.168.3.21:5280/admin/server/nchat.com/shared-roster/Everybody/">>},{'Accept',<<"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8">>},{'Content-Type',<<"application/x-www-form-urlencoded">>},{'User-Agent',<<"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36">>},{<<"Upgrade-Insecure-Requests">>,<<"1">>},{<<"Origin">>,<<"http://192.168.3.21:5280">>},{'Authorization',<<"Basic YWRtaW5AbmNoYXQuY29tOmFkbWlu">>},{'Cache-Control',<<"max-age=0">>},{'Content-Length',<<"97">>},{'Connection',<<"keep-alive">>},{'Host',<<"192.168.3.21:5280">>}]}]}
Also tracked here, without
Also tracked here, without solution yet:https://github.com/processone/ejabberd/issues/1202