mod_roster with mysql odbc always return Service Unvailable with ejabberd 14.07

I installed ejabberd 14.07 with odbc as mysql database, everything is working except the mod_roster odbc. So I am not able to add user to the rosterusers table.

Below is my configuration part from ejabberd.yml,

mod_roster:
db_type: odbc
versioning: true
store_current_id: true
managers:
- "localhost"

I followed the guide and modified the below configuration, but is always return below response packet in the log

2014-08-31 06:22:45.762 [debug] <0.403.0>@ejabberd_router:do_route:322 route
from {jid,<<"umar">>,<<"localhost">>,<<>>,<<"umar">>,<<"localhost">>,<<>>}
to {jid,<<"umar">>,<<"localhost">>,<<"mobile">>,<<"umar">>,<<"localhost">>,<<"mobile">>}
packet {xmlel,<<"iq">>,[{<<"type">>,<<"error">>},{<<"to">>,<<"umar@localhost/mobile">>},{<<"xml:lang">>,<<"en">>},{<<"id">>,<<"vn1cj62j26">>}],[{xmlel,<<"query">>,[{<<"xmlns">>,<<"jabber:iq:roster">>}],[{xmlel,<<"item">>,[{<<"jid">>,<<"test3@localhost">>}],[]}]},{xmlel,<<"error">>,[{<<"code">>,<<"503">>},{<<"type">>,<<"cancel">>}],[{xmlel,<<"service-unavailable">>,[{<<"xmlns">>,<<"urn:ietf:params:xml:ns:xmpp-stanzas">>}],[]}]}]}

Awaiting for help to solve above issue.

Thanks

Syndicate content