title: ejabberd 16.04 archiving messages in mysql database
body: <p>These are some of the key points of my <strong>ejabberd.yml</strong></p>
  <pre><code>auth_method: odbc
  
  ##   MySQL server:
  
  odbc_type: mysql
  odbc_server: &quot;localhost&quot;
  odbc_database: &quot;chat&quot;
  odbc_username: &quot;admin&quot;
  odbc_password: &quot;admin&quot;
  
  ## If you want to specify the port:
  odbc_port: 3306
  
  
  modules
  ...
  mod_mam:
  db_type: odbc
  </code></pre>
  <p><strong>Full ejabberd.yml</strong></p>
  <pre><code>###
  ###'           ejabberd configuration file
  ###
  ###
  
  ### The parameters used in this configuration file are explained in more detail
  ### in the ejabberd Installation and Operation Guide.
  ### Please consult the Guide in case of doubts, it is included with
  ### your copy of ejabberd, and is also available online at
  ### http://www.process-one.net/en/ejabberd/docs/
  
  ### The configuration file is written in YAML.
  ### Refer to http://en.wikipedia.org/wiki/YAML for the brief description.
  ### However, ejabberd treats different literals as different types:
  ###
  ### - unquoted or single-quoted strings. They are called &quot;atoms&quot;.
  ###   Example: dog, 'Jupiter', '3.14159', YELLOW
  ###
  ### - numeric literals. Example: 3, -45.0, .0
  ###
  ### - quoted or folded strings.
  ###   Examples of quoted string: &quot;Lizzard&quot;, &quot;orange&quot;.
  ###   Example of folded string:
  ###   &gt; Art thou not Romeo,
  ###     and a Montague?
  
  ###.  =======
  ###'  LOGGING
  
  ##
  ## loglevel: Verbosity of log files generated by ejabberd.
  ## 0: No ejabberd log at all (not recommended)
  ## 1: Critical
  ## 2: Error
  ## 3: Warning
  ## 4: Info
  ## 5: Debug
  ##
  loglevel: 4
  
  ##
  ## rotation: Describe how to rotate logs. Either size and/or date can trigger
  ## log rotation. Setting count to N keeps N rotated logs. Setting count to 0
  ## does not disable rotation, it instead rotates the file and keeps no previous
  ## versions around. Setting size to X rotate log when it reaches X bytes.
  ## To disable rotation set the size to 0 and the date to &quot;&quot;
  ## Date syntax is taken from the syntax newsyslog uses in newsyslog.conf.
  ## Some examples:
  ##  $D0     rotate every night at midnight
  ##  $D23    rotate every day at 23:00 hr
  ##  $W0D23  rotate every week on Sunday at 23:00 hr
  ##  $W5D16  rotate every week on Friday at 16:00 hr
  ##  $M1D0   rotate on the first day of every month at midnight
  ##  $M5D6   rotate on every 5th day of the month at 6:00 hr
  ##
  log_rotate_size: 10485760
  log_rotate_date: &quot;&quot;
  log_rotate_count: 1
  
  ##
  ## overload protection: If you want to limit the number of messages per second
  ## allowed from error_logger, which is a good idea if you want to avoid a flood
  ## of messages when system is overloaded, you can set a limit.
  ## 100 is ejabberd's default.
  log_rate_limit: 100
  
  ##
  ## watchdog_admins: Only useful for developers: if an ejabberd process
  ## consumes a lot of memory, send live notifications to these XMPP
  ## accounts.
  ##
  ## watchdog_admins:
  ##   - &quot;admin@jabber.local&quot;
  
  ###.  ===============
  ###'  NODE PARAMETERS
  
  ##
  ## net_ticktime: Specifies net_kernel tick time in seconds. This options must have
  ## identical value on all nodes, and in most cases shouldn't be changed at all from
  ## default value.
  ##
  ## net_ticktime: 60
  
  ###.  ================
  ###'  SERVED HOSTNAMES
  
  ##
  ## hosts: Domains served by ejabberd.
  ## You can define one or several, for example:
  ## hosts: 
  ##   - &quot;example.net&quot;
  ##   - &quot;example.com&quot;
  ##   - &quot;example.org&quot;
  ##
  hosts:
    - &quot;jabber.local&quot;
  
  ##
  ## route_subdomains: Delegate subdomains to other XMPP servers.
  ## For example, if this ejabberd serves example.org and you want
  ## to allow communication with an XMPP server called im.example.org.
  ##
  ## route_subdomains: s2s
  
  ###.  ===============
  ###'  LISTENING PORTS
  
  ##
  ## listen: The ports ejabberd will listen on, which service each is handled
  ## by and what options to start it with.
  ##
  listen: 
    - 
      port: 5222
      module: ejabberd_c2s
      certfile: &quot;/home/administrador/ejabberd/conf/server.pem&quot;
      starttls: true
      ## To enforce TLS encryption for client connections,
      ## use this instead of the &quot;starttls&quot; option:
      ## starttls_required: true
      ##
      ## Custom OpenSSL options
      ##
      protocol_options:
        - &quot;no_sslv3&quot;
      ##   - &quot;no_tlsv1&quot;
      max_stanza_size: 65536
      shaper: c2s_shaper
      access: c2s
    - 
      port: 5269
      module: ejabberd_s2s_in
      max_stanza_size: 131072
      shaper: s2s_shaper
    ##
    ## ejabberd_service: Interact with external components (transports, ...)
    ##
    ## - 
    ##   port: 8888
    ##   module: ejabberd_service
    ##   access: all
    ##   shaper_rule: fast
    ##   ip: &quot;127.0.0.1&quot;
    ##   hosts:
    ##     &quot;icq.example.org&quot;:
    ##       password: &quot;secret&quot;
    ##     &quot;sms.example.org&quot;:
    ##       password: &quot;secret&quot;
  
    ##
    ## ejabberd_stun: Handles STUN Binding requests
    ##
    ## - 
    ##   port: 3478
    ##   transport: udp
    ##   module: ejabberd_stun
  
    ##
    ## To handle XML-RPC requests that provide admin credentials:
    ##
    ## - 
    ##   port: 4560
    ##   module: ejabberd_xmlrpc
    ##   maxsessions: 10
    ##   timeout: 5000
    ##   access_commands:
    ##     admin:
    ##       commands: all
    ##       options: []
    - 
      port: 5280
      module: ejabberd_http
      request_handlers:
        &quot;/websocket&quot;: ejabberd_http_ws
      ##  &quot;/pub/archive&quot;: mod_http_fileserver
      web_admin: true
      http_bind: true
      register: true
      captcha: false
  
  ###.  ==================
  ###'  S2S GLOBAL OPTIONS
  
  ##
  ## s2s_use_starttls: Enable STARTTLS + Dialback for S2S connections.
  ## Allowed values are: false optional required required_trusted
  ## You must specify a certificate file.
  ##
  ## s2s_use_starttls: optional
  
  ##
  ## s2s_certfile: Specify a certificate file.
  ##
  ## s2s_certfile: &quot;/home/administrador/ejabberd/conf/server.pem&quot;
  
  ## Custom OpenSSL options
  ##
  ## s2s_protocol_options:
  ##   - &quot;no_sslv3&quot;
  ##   - &quot;no_tlsv1&quot;
  
  ##
  ## domain_certfile: Specify a different certificate for each served hostname.
  ##
  ## host_config:
  ##   &quot;example.org&quot;:
  ##     domain_certfile: &quot;/home/administrador/ejabberd/conf/example_org.pem&quot;
  ##   &quot;example.com&quot;:
  ##     domain_certfile: &quot;/home/administrador/ejabberd/conf/example_com.pem&quot;
  
  ##
  ## S2S whitelist or blacklist
  ##
  ## Default s2s policy for undefined hosts.
  ##
  ## s2s_access: s2s
  
  ##
  ## Outgoing S2S options
  ##
  ## Preferred address families (which to try first) and connect timeout
  ## in milliseconds.
  ##
  ## outgoing_s2s_families:
  ##   - ipv4
  ##   - ipv6
  ## outgoing_s2s_timeout: 10000
  
  ###.  ==============
  ###'  AUTHENTICATION
  
  ##
  ## auth_method: Method used to authenticate the users.
  ## The default method is the internal.
  ## If you want to use a different method,
  ## comment this line and enable the correct ones.
  ##
  auth_method: internal
  
  ##
  ## Store the plain passwords or hashed for SCRAM:
  ## auth_password_format: plain
  ## auth_password_format: scram
  ##
  ## Define the FQDN if ejabberd doesn't detect it:
  ## fqdn: &quot;server3.example.com&quot;
  
  ##
  ## Authentication using external script
  ## Make sure the script is executable by ejabberd.
  ##
  ## auth_method: external
  ## extauth_program: &quot;/path/to/authentication/script&quot;
  
  ##
  ## Authentication using ODBC
  ## Remember to setup a database in the next section.
  ##
  ## auth_method: odbc
  
  ##
  ## Authentication using PAM
  ##
  ## auth_method: pam
  ## pam_service: &quot;pamservicename&quot;
  
  ##
  ## Authentication using LDAP
  ##
  ## auth_method: ldap
  ##
  ## List of LDAP servers:
  ## ldap_servers:
  ##   - &quot;localhost&quot;
  ##
  ## Encryption of connection to LDAP servers:
  ## ldap_encrypt: none
  ## ldap_encrypt: tls
  ##
  ## Port to connect to on LDAP servers:
  ## ldap_port: 389
  ## ldap_port: 636
  ##
  ## LDAP manager:
  ## ldap_rootdn: &quot;dc=example,dc=com&quot;
  ##
  ## Password of LDAP manager:
  ## ldap_password: &quot;******&quot;
  ##
  ## Search base of LDAP directory:
  ## ldap_base: &quot;dc=example,dc=com&quot;
  ##
  ## LDAP attribute that holds user ID:
  ## ldap_uids:
  ##   - &quot;mail&quot;: &quot;%u@mail.example.org&quot;
  ##
  ## LDAP filter:
  ## ldap_filter: &quot;(objectClass=shadowAccount)&quot;
  
  ##
  ## Anonymous login support:
  ##   auth_method: anonymous
  ##   anonymous_protocol: sasl_anon | login_anon | both
  ##   allow_multiple_connections: true | false
  ##
  ## host_config:
  ##   &quot;public.example.org&quot;:
  ##     auth_method: anonymous
  ##     allow_multiple_connections: false
  ##     anonymous_protocol: sasl_anon
  ##
  ## To use both anonymous and internal authentication:
  ##
  ## host_config:
  ##   &quot;public.example.org&quot;:
  ##     auth_method:
  ##       - internal
  ##       - anonymous
  
  ###.  ==============
  ###'  DATABASE SETUP
  
  ## ejabberd by default uses the internal Mnesia database,
  ## so you do not necessarily need this section.
  ## This section provides configuration examples in case
  ## you want to use other database backends.
  ## Please consult the ejabberd Guide for details on database creation.
  
  
  ##   MySQL server:
  
  odbc_type: mysql
  odbc_server: &quot;localhost&quot;
  odbc_database: &quot;chat&quot;
  odbc_username: &quot;admin&quot;
  odbc_password: &quot;admin&quot;
    
  ## If you want to specify the port:
  odbc_port: 3306
  
  ##
  ## PostgreSQL server:
  ##
  ## odbc_type: pgsql
  ## odbc_server: &quot;server&quot;
  ## odbc_database: &quot;database&quot;
  ## odbc_username: &quot;username&quot;
  ## odbc_password: &quot;password&quot;
  ##
  ## If you want to specify the port:
  ## odbc_port: 1234
  ##
  ## If you use PostgreSQL, have a large database, and need a
  ## faster but inexact replacement for &quot;select count(*) from users&quot;
  ##
  ## pgsql_users_number_estimate: true
  
  ##
  ## SQLite:
  ##
  ## odbc_type: sqlite
  ## odbc_database: &quot;/home/administrador/ejabberd/database/ejabberd.db&quot;
  
  ##
  ## ODBC compatible or MSSQL server:
  ##
  ## odbc_type: odbc
  ## odbc_server: &quot;DSN=ejabberd;UID=ejabberd;PWD=ejabberd&quot;
  
  ##
  ## Number of connections to open to the database for each virtual host
  ##
  ## odbc_pool_size: 10
  
  ##
  ## Interval to make a dummy SQL request to keep the connections to the
  ## database alive. Specify in seconds: for example 28800 means 8 hours
  ##
  ## odbc_keepalive_interval: undefined
  
  ###.  ===============
  ###'  TRAFFIC SHAPERS
  
  shaper:
    ##
    ## The &quot;normal&quot; shaper limits traffic speed to 1000 B/s
    ##
    normal: 1000
  
    ##
    ## The &quot;fast&quot; shaper limits traffic speed to 50000 B/s
    ##
    fast: 50000
  
  ##
  ## This option specifies the maximum number of elements in the queue
  ## of the FSM. Refer to the documentation for details.
  ##
  max_fsm_queue: 1000
  
  ###.   ====================
  ###'   ACCESS CONTROL LISTS
  acl:
    ##
    ## The 'admin' ACL grants administrative privileges to XMPP accounts.
    ## You can put here as many accounts as you want.
    ##
    admin:
      user:
        - &quot;admin&quot;: &quot;jabber.local&quot;
  
    ##
    ## Blocked users
    ##
    ## blocked:
    ##   user:
    ##     - &quot;baduser&quot;: &quot;example.org&quot;
    ##     - &quot;test&quot;
  
    ## Local users: don't modify this.
    ##
    local: 
      user_regexp: &quot;&quot;
  
    ##
    ## More examples of ACLs
    ##
    ## jabberorg:
    ##   server:
    ##     - &quot;jabber.org&quot;
    ## aleksey:
    ##   user:
    ##     - &quot;aleksey&quot;: &quot;jabber.ru&quot;
    ## test:
    ##   user_regexp: &quot;^test&quot;
    ##   user_glob: &quot;test*&quot;
  
    ##
    ## Loopback network
    ##
    loopback:
      ip:
        - &quot;127.0.0.0/8&quot;
  
    ##
    ## Bad XMPP servers
    ##
    ## bad_servers:
    ##   server:
    ##     - &quot;xmpp.zombie.org&quot;
    ##     - &quot;xmpp.spam.com&quot;
  
  ##
  ## Define specific ACLs in a virtual host.
  ##
  ## host_config:
  ##   &quot;localhost&quot;:
  ##     acl:
  ##       admin:
  ##         user:
  ##           - &quot;bob-local&quot;: &quot;localhost&quot;
  
  ###.  ============
  ###'  ACCESS RULES
  access:
    ## Maximum number of simultaneous sessions allowed for a single user:
    max_user_sessions: 
      all: 10
    ## Maximum number of offline messages that users can have:
    max_user_offline_messages: 
      admin: 5000
      all: 1000
    ## This rule allows access only for local users:
    local: 
      local: allow
    ## Only non-blocked users can use c2s connections:
    c2s: 
      blocked: deny
      all: allow
    ## For C2S connections, all users except admins use the &quot;normal&quot; shaper
    c2s_shaper: 
      admin: none
      all: normal
    ## All S2S connections use the &quot;fast&quot; shaper
    s2s_shaper: 
      all: fast
    ## Only admins can send announcement messages:
    announce: 
      admin: allow
    ## Only admins can use the configuration interface:
    configure: 
      admin: allow
    ## Admins of this server are also admins of the MUC service:
    muc_admin: 
      admin: allow
    ## Only accounts of the local ejabberd server can create rooms:
    muc_create: 
      local: allow
    ## All users are allowed to use the MUC service:
    muc: 
      all: allow
    ## Only accounts on the local ejabberd server can create Pubsub nodes:
    pubsub_createnode: 
      local: allow
    ## In-band registration allows registration of any possible username.
    ## To disable in-band registration, replace 'allow' with 'deny'.
    register: 
      all: allow
    ## Only allow to register from localhost
    trusted_network: 
      loopback: allow
    ## Do not establish S2S connections with bad servers
    ## s2s: 
    ##   bad_servers: deny
    ##   all: allow
  
  ## By default the frequency of account registrations from the same IP
  ## is limited to 1 account every 10 minutes. To disable, specify: infinity
  ## registration_timeout: 600
    
  ##
  ## Define specific Access Rules in a virtual host.
  ##
  ## host_config:
  ##   &quot;localhost&quot;:
  ##     access:
  ##       c2s:
  ##         admin: allow
  ##         all: deny
  ##       register:
  ##         all: deny
  
  ###.  ================
  ###'  DEFAULT LANGUAGE
  
  ##
  ## language: Default language used for server messages.
  ##
  language: &quot;en&quot;
  
  ##
  ## Set a different default language in a virtual host.
  ##
  ## host_config:
  ##   &quot;localhost&quot;:
  ##     language: &quot;ru&quot;
  
  ###.  =======
  ###'  CAPTCHA
  
  ##
  ## Full path to a script that generates the image.
  ##
  ## captcha_cmd: &quot;/home/administrador/ejabberd/lib/ejabberd-16.04/priv/bin/captcha.sh&quot;
  
  ##
  ## Host for the URL and port where ejabberd listens for CAPTCHA requests.
  ##
  ## captcha_host: &quot;jabber.local:5280&quot;
  
  ##
  ## Limit CAPTCHA calls per minute for JID/IP to avoid DoS.
  ##
  ## captcha_limit: 5
  
  ###.  =======
  ###'  MODULES
  
  ##
  ## Modules enabled in all ejabberd virtual hosts.
  ##
  modules: 
    mod_adhoc: {}
    mod_admin_extra: {}
    mod_announce: # recommends mod_adhoc
      access: announce
    mod_blocking: {} # requires mod_privacy
    mod_caps: {}
    mod_carboncopy: {}
    mod_client_state: {}
    mod_configure: {} # requires mod_adhoc
    mod_disco: {}
    ## mod_echo: {}
    ## mod_irc: {}
    mod_http_bind: {}
    ## mod_http_fileserver:
    ##   docroot: &quot;/var/www&quot;
    ##   accesslog: &quot;/home/administrador/ejabberd/logs/access.log&quot;
    mod_last: {}
    mod_mam:
      db_type: odbc
    mod_muc: 
      ## host: &quot;conference.@HOST@&quot;
      access: muc
      access_create: muc_create
      access_persistent: muc_create
      access_admin: muc_admin
    mod_muc_admin: {}
    ## mod_muc_log: {}
    ## mod_multicast: {}
    mod_offline_odbc: 
      access_max_user_messages: max_user_offline_messages
    mod_ping: {}
    ## mod_pres_counter:
    ##   count: 5
    ##   interval: 60
    mod_privacy: {}
    mod_private: {}
    ## mod_proxy65: {}
    mod_pubsub: 
      access_createnode: pubsub_createnode
      ## reduces resource comsumption, but XEP incompliant
      ignore_pep_from_offline: true
      ## XEP compliant, but increases resource comsumption
      ## ignore_pep_from_offline: false
      last_item_cache: false
      plugins: 
        - &quot;flat&quot;
        - &quot;hometree&quot;
        - &quot;pep&quot; # pep requires mod_caps
    mod_register: 
      ##
      ## Protect In-Band account registrations with CAPTCHA.
      ##
      ## captcha_protected: true
  
      ##
      ## Set the minimum informational entropy for passwords.
      ##
      ## password_strength: 32
  
      ##
      ## After successful registration, the user receives
      ## a message with this subject and body.
      ##
      welcome_message: 
        subject: &quot;Welcome!&quot;
        body: |-
          Hi.
          Welcome to this XMPP server.
  
      ##
      ## When a user registers, send a notification to
      ## these XMPP accounts.
      ##
      ## registration_watchers:
      ##   - &quot;admin1@example.org&quot;
  
      ##
      ## Only clients in the server machine can register accounts
      ##
      ip_access: trusted_network
  
      ##
      ## Local c2s or remote s2s users cannot register accounts
      ##
      ## access_from: register
  
      access: register
    mod_roster_odbc: {}
    mod_shared_roster: {}
    ## mod_stats: {}
    ## mod_time: {}
    mod_vcard: {}
    mod_version: {}
  
  ##
  ## Enable modules with custom options in a specific virtual host
  ##
  ## host_config:
  ##   &quot;localhost&quot;:
  ##     modules:
  ##       mod_echo:
  ##         host: &quot;mirror.localhost&quot;
  
  ##
  ## Enable modules management via ejabberdctl for installation and
  ## uninstallation of public/private contributed modules
  ## (enabled by default)
  ##
  
  allow_contrib_modules: true
  
  ###.
  ###'
  ### Local Variables:
  ### mode: yaml
  ### End:
  ### vim: set filetype=yaml tabstop=8 foldmarker=###',###. foldmethod=marker:
  </code></pre>
  <p><strong>Latest entries of ejabberd.log</strong></p>
  <pre><code>2016-05-06 10:26:31.546 [info] &lt;0.7.0&gt; Application lager started on node ejabberd@localhost
  2016-05-06 10:26:31.576 [info] &lt;0.7.0&gt; Application crypto started on node ejabberd@localhost
  2016-05-06 10:26:31.606 [info] &lt;0.7.0&gt; Application sasl started on node ejabberd@localhost
  2016-05-06 10:26:31.631 [info] &lt;0.7.0&gt; Application asn1 started on node ejabberd@localhost
  2016-05-06 10:26:31.632 [info] &lt;0.7.0&gt; Application public_key started on node ejabberd@localhost
  2016-05-06 10:26:31.654 [info] &lt;0.7.0&gt; Application ssl started on node ejabberd@localhost
  2016-05-06 10:26:31.679 [info] &lt;0.7.0&gt; Application fast_yaml started on node ejabberd@localhost
  2016-05-06 10:26:31.711 [info] &lt;0.7.0&gt; Application fast_tls started on node ejabberd@localhost
  2016-05-06 10:26:31.736 [info] &lt;0.7.0&gt; Application fast_xml started on node ejabberd@localhost
  2016-05-06 10:26:31.746 [info] &lt;0.7.0&gt; Application stringprep started on node ejabberd@localhost
  2016-05-06 10:26:31.766 [info] &lt;0.7.0&gt; Application cache_tab started on node ejabberd@localhost
  2016-05-06 10:26:32.099 [info] &lt;0.7.0&gt; Application mnesia started on node ejabberd@localhost
  2016-05-06 10:26:33.919 [info] &lt;0.7.0&gt; Application inets started on node ejabberd@localhost
  2016-05-06 10:26:34.287 [warning] &lt;0.39.0&gt;@ejabberd_config:emit_deprecation_warning:1294 Module mod_roster_odbc is deprecated, use mod_roster with 'db_type: sql' instead
  2016-05-06 10:26:35.975 [info] &lt;0.7.0&gt; Application p1_mysql started on node ejabberd@localhost
  2016-05-06 10:26:36.006 [info] &lt;0.39.0&gt;@cyrsasl_digest:start:60 FQDN used to check DIGEST-MD5 SASL authentication: oficina24
  2016-05-06 10:26:36.202 [info] &lt;0.510.0&gt;@ejabberd_listener:listen_tcp:189 Reusing listening port for {5222,{0,0,0,0},tcp}
  2016-05-06 10:26:36.202 [info] &lt;0.511.0&gt;@ejabberd_listener:listen_tcp:189 Reusing listening port for {5269,{0,0,0,0},tcp}
  2016-05-06 10:26:36.203 [info] &lt;0.513.0&gt;@ejabberd_listener:listen_tcp:189 Reusing listening port for {5280,{0,0,0,0},tcp}
  2016-05-06 10:26:36.203 [info] &lt;0.39.0&gt;@ejabberd_app:start:76 ejabberd 16.04 is started in the node ejabberd@localhost
  2016-05-06 10:26:36.203 [info] &lt;0.7.0&gt; Application ejabberd started on node ejabberd@localhost
  </code></pre>
  <p>I've executed mysql.sql script on phpmyadmin and the database is correctly setted up.</p>
  <p>The problem is that I'm not able to link ejabberd with mysql because when I register a user with ejabberd web admin it doesn't store it in sql database.
  Since I can't store the user I'm not able to check for the messaging storage neither.</p>
  <p>Am I missing something?</p>
  <p>Regards!</p>
  <p><strong>EDIT:</strong></p>
  <p>user on <strong>.yml</strong></p>
  <pre><code>admin:
      user:
        - &quot;admin&quot;: &quot;jabber.local&quot;
        - &quot;admin&quot;: &quot;localhost&quot;
  </code></pre>
  <p><strong>ejabberd.log</strong></p>
  <pre><code>2016-05-06 11:28:40.055 [warning] &lt;0.525.0&gt;@ejabberd_web_admin:process:239 Access of &lt;&lt;&quot;admin@localhost&quot;&gt;&gt; from &lt;&lt;&quot;127.0.0.1&quot;&gt;&gt; failed with error: &lt;&lt;&quot;inexistent-account&quot;&gt;&gt;
  2016-05-06 11:28:43.813 [error] &lt;0.525.0&gt;@ejabberd_sql:check_error:991 SQL query 'Q9525209' at {sql_queries,145} failed: &lt;&lt;&quot;Unknown Host&quot;&gt;&gt;
  2016-05-06 11:28:43.813 [error] &lt;0.525.0&gt;@ejabberd_sql:check_error:991 SQL query 'Q9525209' at {sql_queries,145} failed: &lt;&lt;&quot;Unknown Host&quot;&gt;&gt;
  2016-05-06 11:28:43.813 [error] &lt;0.525.0&gt;@ejabberd_auth:is_user_exists:316 The authentication module ejabberd_auth_sql returned an error
  when checking user &lt;&lt;&quot;admin&quot;&gt;&gt; in server &lt;&lt;&quot;localhost&quot;&gt;&gt;
  Error message: &lt;&lt;&quot;Unknown Host&quot;&gt;&gt;
  </code></pre>