EMQX5.3 数据桥接mysql 连接错误 400 TEST_FAILED:unhealthy_target,其他功能正常
求助,什么原因
就是连上不你的mysql啊,你看看emqx 的日志,有具体的报错原因的。
缺一张表
CREATE TABLE t_mqtt_msg
(
id
int NOT NULL AUTO_INCREMENT,
msgid
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
sender
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
topic
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
qos
int DEFAULT NULL,
retain
int DEFAULT NULL,
payload
text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
arrived
timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
你的数据库连上了吗
,怎么做的