mysql - ejabberd 16.06 + mysql 5.5.50，消息历史记录不保存

Question

我使用ejabberd 16.06 + mysql 5.5.50，消息历史记录没有保存。

我的 ejabberd.yml:

## MySQL server:

odbc_type: mysql 
odbc_server: "freldo"
odbc_port: 3306
odbc_database: "ejabberd"
odbc_username: "ejabberd" 
odbc_password: "ejabberd"

modules: 
... 
mod_mam: 
   db_type: odbc 
   default: always

为了形成数据库结构，我使用了: mysql.sql

我收到错误:

@ejabberd_sql:check_error:1039 SQL query 'SELECT timestamp, xml, peer,
kind, nick FROM (SELECT timestamp, xml, peer, kind, nick FROM archive
WHERE username='test' and bare_peer='misha@freldo' ORDER BY timestamp
DESC limit 21) AS t ORDER BY timestamp ASC;' failed: "#42S22Unknown
column 'kind' in 'field list'"

我尚未在数据库中保存消息历史记录。

Answer 1

将 mysql 升级到 5.6+ 版本应该可以解决您的问题。

ejabberd make use of FULLTEXT indexes with InnoDB. Thus, you need MySQL 5.6 or greater to use with ejabberd.

Note: If you do not store message archive in database however, you can try using older 5.5 version. You may need to adapt MySQL database schema to cope with those older MySQL versions.

MySQL 版本 5.6.4 或更高版本是 recommended如果您想存储消息历史记录。