MySQL在ejabberd配置中的错误
我尝试用Debian 9在我的VPS上安装ejabberd，使用mariadb-server。
从智能安装ejabberd (16.09-4)。
我指的是：https://docs.ejabberd.im/admin/databases/mysql/
我用: wget https://raw.githubusercontent.com/processone/ejabberd/master/sql/mysql.sql下载了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按照文档：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中的要求，在编辑SQL部件后，它停止工作。
当然，模式是加载的。
当重新启动ejabberd时，ejabberd.log中的这个报告失败了:谢谢您的帮助或提示。
2018-09-02 20:24:29.684 info <0.31.0> Application lager启动于节点ejabberd@vps574962 2018-09-02 20:24:29.692 info <0.31.0>应用程序密码启动于节点ejabberd@vps574962 2018-09-02 20:24:29.696 info <0.31.0> Application sasl启动于节点ejabberd@vps574962 2018-09-02 20:24:29.702 info <0.31.0> Application asn1启动于节点ejabberd@vps574962 2018-09-02 20:24:29.703 info <0.31.0> Application public_key启动于节点ejabberd@vps574962 2018-09-02 20:24:29.708 info <0.31.0>应用程序ssl启动于节点ejabberd@vps574962 2018-09-02 20:24:29.713 info <0.31.0> Application fast_yaml启动于节点ejabberd@vps574962 2018-09-02 20:24:29.723 info <0.31.0> Application fast_tls启动于节点ejabberd@vps574962 2018-09-02 20:24:29.729 info <0.31.0> Application fast_xml启动于节点ejabberd@vps574962 2018-09-02 20:24:29.735 info <0.31.0>应用程序字符串准备程序在节点ejabberd@vps574962上启动 2018-09-02 20:24:29.739 info <0.31.0> Application cache_tab启动于节点ejabberd@vps574962 2018-09-02 20:24:29.834 info <0.31.0> Application mnesia启动节点ejabberd@vps574962 2018-09-02 20:24:30.228 info <0.31.0>应用程序inets启动于节点ejabberd@vps574962 2018-09-02 20:24:30.245错误<0.61.0>崩溃报告处理<0.61.0>与0邻居退出原因:没有函数子句匹配列表:map(#乐趣，sql)第1238行在应用程序_主:init/4行134 2018-09-02 20:24:30.245 info <0.31.0>应用程序ejabberd退出原因:没有匹配列表的函数子句:map(#<0.31.0>，sql)第1238行
Stack Overflow用户
发布于 2018-09-04 06:35:24
尝试修复ejabberd.yml中的以下缩进
从…
mod_version: {}
allow_contrib_modules: trueallow_contrib_modules:真
至
mod_version: {}
allow_contrib_modules: truehttps://stackoverflow.com/questions/52140019
复制相似问题
腾讯云开发者
