我尝试用debian9在我的vps上安装ejabberd，使用mariadb服务器。
ejabberd安装自aptitude（16.09-4）。
我提到：https://docs.ejabberd.im/admin/databases/mysql/
我用wget下载了mysql模式https://raw.githubusercontent.com/processone/ejabberd/master/sql/mysql.sql
下面是我的ejabberd.yml conf文件：（我删除了所有以####开头的注解行）

loglevel: 4
log_rotate_size: 0
log_rotate_date: ""
log_rate_limit: 100
hosts:
  - "XXXXX.com"
  - "YYYYY.com"
  - "ZZZZZ.de"
listen: 
  - 
    port: 5222
    ip: "::"
    module: ejabberd_c2s
    certfile: "/etc/ejabberd/CCCCCCCCCCCCCCCCC.pem"
    starttls_required: true
    protocol_options:
      - "no_sslv3"
    max_stanza_size: 65536
    shaper: c2s_shaper
    access: c2s
    zlib: true
    resend_on_timeout: if_offline
  - 
    port: 5269
    ip: "::"
    module: ejabberd_s2s_in
  -
    port: 5281
    ip: "::"
    module: ejabberd_http
    web_admin: true
    http_bind: true
    tls: true
    certfile: "/etc/ejabberd/CCCCCCC.pem"
s2s_use_starttls: optional
s2s_certfile: "/etc/ejabberd/ejabberd.pem"
s2s_protocol_options:
  - "no_sslv3"
auth_password_format: scram
auth_method: sql
sql_type: mysql
sql_server: "localhost"
sql_database: "ejabberd"
sql_username: "MYNAME"
sql_password: "PASSWORD"
sql_port: 3306
shaper:
  normal: 1000
  fast: 50000
max_fsm_queue: 1000
acl:
  admin:
     user:
       - "MYNAME@localhost"
  local: 
    user_regexp: ""  
  loopback:
    ip:
      - "127.0.0.0/8"
shaper_rules:
  max_user_sessions: 10
  max_user_offline_messages:
    - 5000: admin
    - 100
  c2s_shaper:
    - none: admin
    - normal
  s2s_shaper: fast
access_rules:
  local:
    - allow: local
  c2s:
    - deny: blocked
    - allow
  announce:
    - allow: admin
  configure: 
    - allow: admin
  muc_create: 
    - allow: local
  pubsub_createnode: 
    - allow: local
  register: 
    - allow
  trusted_network: 
    - allow: loopback
language: "en"
modules:
  default_db: sql 
  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_last: {}
  mod_muc: 
    access:
      - allow
    access_admin:
      - allow: admin
    access_create: muc_create
    access_persistent: muc_create
  mod_muc_admin: {}
  mod_offline: 
    access_max_user_messages: max_user_offline_messages
  mod_ping: {}
  mod_privacy: {}
  mod_private: {}
  mod_pubsub: 
    access_createnode: pubsub_createnode
    ignore_pep_from_offline: true
    last_item_cache: false
    plugins: 
      - "flat"
      - "hometree"
      - "pep" # pep requires mod_caps
  mod_roster:
    versioning: true
  mod_shared_roster: {}
  mod_stats: {}
  mod_time: {}
  mod_vcard:
    search: false
  mod_version: {}
allow_contrib_modules: true

按照文档中的要求，它在编辑sql部件后停止工作： auth_password_format: scram auth_method: sql sql_type: mysql sql_server: "localhost" sql_database: "ejabberd" sql_username: "MYNAME" sql_password: "PASSWORD" sql_port: 3306 当然，架构已加载。
再次启动ejabberd时，我在ejabberd.log中遇到了一个失败的报告：感谢您的帮助或提示。。。
2018-09-02 20:24:29.684[信息]<0.31.0>节点上的应用程序延迟已启动ejabberd@vps574962
2018-09-02 20:24:29.692[信息]<0.31.0>应用程序加密已在节点上启动ejabberd@vps574962
2018-09-02 20:24:29.696[信息]<0.31.0>应用程序sasl已在节点上启动ejabberd@vps574962
2018-09-02 20:24:29.702[信息]<0.31.0>应用程序asn1在节点上启动ejabberd@vps574962
2018-09-02 20:24:29.703[信息]<0.31.0>应用程序公钥在节点上启动ejabberd@vps574962
2018-09-02 20:24:29.708[信息]<0.31.0>应用程序ssl已在节点上启动ejabberd@vps574962
2018-09-02 20:24:29.713[信息]<0.31.0>节点上启动应用程序fast\u yamlejabberd@vps574962
2018-09-02 20:24:29.723[信息]<0.31.0>在节点上启动应用程序快速\u tlsejabberd@vps574962
2018-09-02 20:24:29.729[信息]<0.31.0>在节点上启动应用程序fast\u xmlejabberd@vps574962
2018-09-02 20:24:29.735[信息]<0.31.0>应用程序stringprep已在节点上启动ejabberd@vps574962
2018-09-02 20:24:29.739[信息]<0.31.0>应用程序缓存选项卡在节点上启动ejabberd@vps574962
2018-09-02 20:24:29.834[信息]<0.31.0>节点上启动应用程序记忆ejabberd@vps574962
2018-09-02 20:24:30.228[信息]<0.31.0>应用程序inets在节点上启动ejabberd@vps574962
2018-09-02 20:24:30.245[错误]<0.61.0>崩溃报告过程<0.61.0>0邻居退出，原因：无函数子句匹配lists:map（#fun，sql）应用程序中的第1238行_master:init/4 第134行
2018-09-02 20:24:30.245[info]<0.31.0>应用程序ejabberd退出，原因：没有匹配的函数子句lists:map（#fun，sql）第1238行