Offline messages are not stored in database while connecting through ODBC

Hi

I am using ejabberd 2.1.4
we have configured mssql 2005

Also changed modules for offline messages
but this is not going in DB

Following is my module configuration
{modules,
[
{mod_adhoc, []},
{mod_announce, [{access, announce}]}, % requires mod_adhoc
{mod_caps, []},
{mod_configure,[]}, % requires mod_adhoc
{mod_disco, []},
%%{mod_echo, [{host, "echo.COM94"}]},
{mod_http_bind,[]},
%%{mod_http_fileserver, [
%% {docroot, "C:\\Program Files\\ejabberd-2.1.4\\www"},
%% {accesslog, "C:\\Program Files\\ejabberd-2.1.4\\www/webaccess.log"},
%% {content_types, [{".htm", "text/html"}]},
%% {directory_indices, ["index.html", "index.htm"]}
%%]},
{mod_irc, []},
{mod_last_odbc, []},
{mod_muc, [
%%{host, "conference.@HOST@"},
{access, muc},
{access_create, muc_create},
{access_persistent, muc_create},
{access_admin, muc_admin}
]},
%%{mod_muc_log,[]},
{mod_offline_odbc, []},
{mod_privacy_odbc, []},
{mod_private_odbc, []},
%%{mod_proxy65,[]},
{mod_pubsub, [ % requires mod_caps
{access_createnode, pubsub_createnode},
{ignore_pep_from_offline, true},
{last_item_cache, false},
{plugins, ["flat", "hometree", "pep"]}
]},
{mod_register, [
%%
%% After successful registration, the user receives
%% a message with this subject and body.
%%
{welcome_message, {"Welcome!",
"Welcome to this Jabber server."}},

%%
%% When a user registers, send a notification to
%% these Jabber accounts.
%%
%%{registration_watchers, ["admin1@example.org"]},

{access, register}
]},
{mod_roster_odbc, []},
%%{mod_service_log,[]},
{mod_shared_roster,[]},
%%{mod_stats, []},
{mod_time, []},
{mod_vcard_odbc, [{search,true},
{matches,20},
{allow_return_all,true},
{search_all_hosts,false}]},
{mod_version, []}
]}.

Please provide help for the same

With that configuration, is

With that configuration,

  • is the roster stored in ODBC or in internal Mnesia database?
  • is the offline messages stored in internal Mnesia database, or nowhere?
  • If it is stored nowhere, do you get some error message in ejabberd log files?
Syndicate content