mysql - ejabberd连接mysql失败

Question

我的 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:

** 原因:连接失败** 重试时间:30 秒

MySQL server:

sql_type: mysql

sql_server: "ejabberd"

sql_database: "ejabberd"

sql_username: "ejabberd"

sql_password: ""

sql_port: 3306

默认数据库:sql

sql_pool_size:10

new_sql_schema:true

管理员:

user:

## - “admin@localhost”

  - "admin@server"

s2s_shaper:快

模块:

mod_admin_update_sql:{}

mod_名册:

db_type: sql

default: always

enter image description here

Answer 1

请按照以下步骤操作 https://docs.ejabberd.im/admin/databases/mysql/在文档ejabberd中以相同的顺序如果您只想迁移数据，则不要提及身份验证##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.