我的ejabberd.log:

2018-05-15 21:40:05.965 [error] <0.414.0>@ejabberd_sql:log:950 p1_mysql_conn: post_start error connect_failed

2018-05-15 21:40:05.965 [info] <0.414.0>@ejabberd_sql:connecting:339 mysql connection failed:


**原因:connect_failed
**重试:30秒后

MySQL server:

sql_type: mysql

sql_server: "ejabberd"

sql_database: "ejabberd"

sql_username: "ejabberd"

sql_password: ""

sql_port: 3306


default_db:SQL

sql_pool_size:10

new_sql_schema:是

管理员:

user:


##-“ admin @ localhost”

  - "admin@server"


s2s_shaper:快速

模块:

mod_admin_update_sql:{}

mod_roster:

db_type: sql

default: always


enter image description here

最佳答案

按着这些次序
如果只想迁移数据,则按相同顺序在文档ejabberd中的https://docs.ejabberd.im/admin/databases/mysql/,不要在后端提及身份验证## auth_method:sql。

1. Create ejabberd user
2. Create ejabberd database
3.  test the user and database
4. adapt MySQL schema whit command in mysql source C://path.mysq.sql;
5. you can show the list of SQL tables.
6. Adding MySQL connection configuration to ejabberd config file
7. Switch modules to use MySQL instead of Mnesia
8. Migrating data from internal database to MySQL
9. ejd2sql:export(<<"imserver.com">>, sql). //name server ejabberd
10. show data in schema work breanch.

关于mysql - ejabberd无法连接mysql,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/50362652/

10-12 00:22
查看更多