mysql таблица users

{hosts, ["ferrari","localhost"]}.

{loglevel, 4}.

%%%   ===============
%%%   LISTENING PORTS

{listen,
[
  {5222, ejabberd_c2s, [
{access, c2s},
{shaper, c2s_shaper},
{max_stanza_size, 65536},
                        %%zlib,
starttls, {certfile, "/etc/ejabberd/ejabberd.pem"}
       ]},
  {5269, ejabberd_s2s_in, [
   {shaper, s2s_shaper},
   {max_stanza_size, 131072}
  ]},
  {5280, ejabberd_http, [
%%{request_handlers,
%% [
%%  {["pub", "archive"], mod_http_fileserver}
%% ]},
%%captcha, ivan
{request_handlers, [ {["web"], mod_http_fileserver} ]},
http_bind,
http_poll,
web_admin
]}
]}.

{s2s_use_starttls, true}.

{s2s_certfile, "/etc/ejabberd/ejabberd.pem"}.

%%%   ==============
%%%   AUTHENTICATION

%%{auth_method, internal}.

{auth_method, odbc}.

{host_config, "ferrari", [{auth_method, [internal, anonymous]},
{anonymous_protocol, both}]}.
%%%   ==============
%%%   DATABASE SETUP

{odbc_server, {mysql, "localhost", 3306, "jabber", "root", "kelebra"}}.
%%%   ===============
%%%   TRAFFIC SHAPERS

{shaper, normal, {maxrate, 1000}}.

{shaper, fast, {maxrate, 50000}}.
%%%   ====================
%%%   ACCESS CONTROL LISTS

{acl, admin, {user, "ivan", "ferrari"}}.

{acl, local, {user_regexp, ""}}.

%%%   ============
%%%   ACCESS RULES

{access, max_user_sessions, [{10, all}]}.

{access, max_user_offline_messages, [{5000, admin}, {100, all}]}.

{access, local, [{allow, local}]}.

{access, c2s, [{deny, blocked},
       {allow, all}]}.

{access, c2s_shaper, [{none, admin},
      {normal, all}]}.

{access, s2s_shaper, [{fast, all}]}.

{access, announce, [{allow, admin}]}.

{access, configure, [{allow, admin}]}.

{access, muc_admin, [{allow, admin}]}.

{access, muc, [{allow, all}]}.

{access, register, [{allow, all}]}.

{registration_timeout, infinity}.

{access, pubsub_createnode, [{allow, all}]}.

%%%   ================
%%%   DEFAULT LANGUAGE

{language, "en"}.

%%%   =======
%%%   MODULES

{modules,
[
{mod_http_bind,  []},
  {mod_adhoc,    []},
  {mod_announce, [{access, announce}]}, % requires mod_adhoc
  {mod_caps,     []},
  {mod_configure,[]}, % requires mod_adhoc
  {mod_admin_extra, []},
  {mod_disco,    []},
  %%{mod_echo,   [{host, "echo.localhost"}]},
  {mod_irc,      []},
  %% NOTE that mod_http_fileserver must also be enabled in the
  %% "request_handlers" clause of the "ejabberd_http" listener
  %% configuration (see the "LISTENING PORTS" section above).
  {mod_http_fileserver, [
                         {docroot, "/var/lib/ejabberd/www"},
                         {accesslog, "/var/log/ejabberd/webaccess.log"}
                        ]},
  {mod_last_odbc,     []},
  {mod_muc,      [
  {host, "conference.ferrari"},
    {access, muc},
    {access_create, muc},
  %%   {access_persistent, muc},
    {access_admin, muc_admin},
    {max_users, 500}
  ]},
{mod_log_chat, [{path, "/home/ivan/www/jabberlog"}, {format, html}]},
%% {mod_offline,  [{access_max_user_messages, max_user_offline_messages}]},
  {mod_offline_odbc,  [{1000, all}]},
  {mod_privacy_odbc,  []},
  {mod_private_odbc,  []},
  {mod_proxy65,  [
  {access, local},
  {shaper, c2s_shaper}
]},
  {mod_pubsub_odbc,   [ % requires mod_caps
  {access_createnode, pubsub_createnode},
  {pep_sendlast_offline, false},
  {last_item_cache, false},
  %%{plugins, ["default", "pep"]}
  {plugins, ["flat_odbc", "hometree_odbc", "pep_odbc"]}  % pep requires mod_caps
]},
  {mod_register, [
  {access, register}
]},
  {mod_roster_odbc,   []},
  {mod_service_log,[]},
  {mod_shared_roster,[]},
  {mod_stats,    []},
  {mod_time,     []},
  {mod_vcard_odbc, []},
  {mod_version,  []}
]}.