[Bug] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes

[ChenXun-123]

Plugin Version

Next-2.0.5

AstrBot Version

v4.13.1

Database Type

MySQL

Operating System

Docker

Bug Description

MySQL 数据库链接失败
IP 和 端口号 都正确无误

Steps to Reproduce

1. 安装插件
2. 配置数据库
3. 保存

Expected Behavior

确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes

Error Logs

Astrbot日志
"""
 [11:12:12] [Plug] [INFO] [core.plugin_lifecycle:323]: 尝试启动数据库管理器 (第 1/3 次) 
 [11:12:12] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动… 
 [11:12:12] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes 
 [11:12:12] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes 
Traceback (most recent call last):
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
    await self._ensure_mysql_database_exists()
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
    conn = await aiomysql.connect(
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
    await conn._connect()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
    await self._get_server_information()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
    self.server_thread_id = struct.unpack('<I', data[i:i + 4])
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
 [11:12:12] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:329]: 数据库管理器启动返回 False (尝试 1/3) 
 [11:12:13] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动… 
 [11:12:13] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes 
 [11:12:13] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes 
Traceback (most recent call last):
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
    await self._ensure_mysql_database_exists()
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
    conn = await aiomysql.connect(
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
    await conn._connect()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
    await self._get_server_information()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
    self.server_thread_id = struct.unpack('<I', data[i:i + 4])
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
 [11:12:13] [Plug] [ERRO] [v4.13.1] [webui.manager:105]: 启动数据库管理器失败: 数据库管理器启动失败 
Traceback (most recent call last):
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/webui/manager.py", line 103, in immediate_start
    raise RuntimeError("数据库管理器启动失败")
RuntimeError: 数据库管理器启动失败
 [11:12:14] [Plug] [INFO] [core.plugin_lifecycle:323]: 尝试启动数据库管理器 (第 2/3 次) 
 [11:12:14] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动… 
 [11:12:14] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes 
 [11:12:14] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes 
Traceback (most recent call last):
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
    await self._ensure_mysql_database_exists()
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
    conn = await aiomysql.connect(
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
    await conn._connect()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
    await self._get_server_information()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
    self.server_thread_id = struct.unpack('<I', data[i:i + 4])
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
 [11:12:14] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:329]: 数据库管理器启动返回 False (尝试 2/3) 
 [11:12:16] [Plug] [INFO] [core.plugin_lifecycle:323]: 尝试启动数据库管理器 (第 3/3 次) 
 [11:12:16] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动… 
 [11:12:16] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes 
 [11:12:16] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes 
Traceback (most recent call last):
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
    await self._ensure_mysql_database_exists()
  File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
    conn = await aiomysql.connect(
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
    await conn._connect()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
    await self._get_server_information()
  File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
    self.server_thread_id = struct.unpack('<I', data[i:i + 4])
                            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
 [11:12:16] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:329]: 数据库管理器启动返回 False (尝试 3/3) 
 [11:12:16] [Plug] [ERRO] [v4.13.1] [core.plugin_lifecycle:343]: 数据库管理器启动失败: 所有重试均失败 
 [11:12:16] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:346]: 插件将在数据库功能受限的情况下继续运行 
 [11:12:16] [Plug] [INFO] [core.patterns:43]: 服务状态变更: created -> initializing 
 [11:12:16] [Plug] [ERRO] [v4.13.1] [state.affection_manager:518]: 获取活跃群组列表失败: 数据库管理器未启动，engine不存在 
 [11:12:16] [Plug] [INFO] [state.affection_manager:423]: 没有发现活跃群组，跳过情绪初始化 
 [11:12:16] [Plug] [INFO] [state.affection_manager:139]: 好感度管理服务启动成功 
 [11:12:16] [Plug] [INFO] [core.patterns:43]: 服务状态变更: initializing -> running 
 [11:12:16] [Plug] [INFO] [core.patterns:56]: 服务启动成功 
 [11:12:16] [Plug] [INFO] [core.plugin_lifecycle:352]: 好感度管理服务启动成功 
 [11:12:16] [Plug] [INFO] [webui.manager:207]: 成功获取 AstrBot 框架 PersonaManager: <class 'astrbot.core.persona_mgr.PersonaManager'> 
 [11:12:16] [Plug] [INFO] [webui.dependencies:98]:  [WebUI] persona_updater 获取成功: <class 'data.plugins.astrbot_plugin_self_learning.services.persona.persona_updater.PersonaUpdater'> 
 [11:12:16] [Plug] [INFO] [webui.dependencies:138]: [WebUI] 性能监测模块初始化成功 
 [11:12:16] [Plug] [INFO] [webui.dependencies:155]:  [WebUI] PersonaWebManager 初始化成功 
 [11:12:16] [Plug] [INFO] [webui.dependencies:163]:  [WebUI] 服务容器初始化完成 
 [11:12:16] [Plug] [INFO] [webui.dependencies:218]:  [WebUI] 插件服务设置完成 
 [11:12:16] [Plug] [INFO] [webui.manager:140]: Web 服务器插件服务设置完成 
 [11:12:16] [Plug] [INFO] [webui.manager:147]: 准备启动 Web 服务器: http://0.0.0.0:8080 
 [11:12:16] [Plug] [INFO] [webui.app:49]:  [WebUI] Quart 应用创建成功 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: auth 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: config 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: personas 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: learning 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: jargon 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: chat 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: bug_report 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: metrics 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: social 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: persona_reviews 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: intelligent_chat 
 [11:12:16] [Plug] [INFO] [webui.app:67]:  [WebUI] 已注册蓝图: monitoring 
 [11:12:16] [Plug] [INFO] [webui.app:69]:  [WebUI] 共注册 12 个蓝图 
 [11:12:16] [Plug] [INFO] [webui.server:139]: [WebUI] 启动服务器: http://0.0.0.0:8080 
 [11:12:17] [Plug] [INFO] [webui.server:152]: [WebUI] Web服务器启动成功 
 [11:12:17] [Plug] [INFO] [webui.server:153]: [WebUI] 本地访问: http://127.0.0.1:8080 
 [11:12:17] [Plug] [INFO] [webui.manager:152]: Web 服务器启动完成 
 [11:12:17] [Plug] [INFO] [core.plugin_lifecycle:401]: 自学习插件加载完成 """

Mysql日志
"""
2026-03-02 11:12:41+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
2026-03-02 11:12:41+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2026-03-02 11:12:41+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2026-03-02T03:12:41.966710Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2026-03-02T03:12:41.967964Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
2026-03-02T03:12:41.972642Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-03-02T03:12:42.186532Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-03-02T03:12:42.429814Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-03-02T03:12:42.429874Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-03-02T03:12:42.432390Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2026-03-02T03:12:42.455386Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2026-03-02T03:12:42.455501Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.34'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
"""

Relevant Configuration

我的Astrbot 和 Mysql 分别是两个docker容器

Additional Context

刚开始玩BOT, 不懂的还很多, 希望大佬能多指点一下, 谢谢

[github-actions]

🤖 Issue 审查报告

优先级: 🟠 high

📋 用户处理意见

问题摘要: 该报错来自 aiomysql 在握手阶段读取到异常/不完整的 MySQL 协议数据，通常不是账号密码或端口写错，而是连到了“不是 MySQL 协议”的端口（如 33060/mysqlx、反向代理/负载均衡返回了 HTTP），或容器网络/DNS 指向错误导致连错服务。

问题分类: 环境问题

建议操作：

1. 先在 AstrBot 容器里验证你连到的到底是不是 MySQL 3306：

1. 进入 AstrBot 容器：docker exec -it <astrbot_container> sh
2. 安装客户端(任选)：apk add mysql-client 或 apt-get update && apt-get install -y mariadb-client
3. 直接连：mysql -h <MYSQL_HOST> -P 3306 -u -p -e "SELECT VERSION();"

2. 确认你配置的端口是 3306，不要填 33060（33060 是 MySQL X Plugin 端口，aiomysql 不能连）。从你贴的 MySQL 日志看：port: 3306 才是正确端口。
3. 如果你在配置里使用了 127.0.0.1/localhost：在 Docker 场景这会指向 AstrBot 容器自己而不是 MySQL 容器。请改为 MySQL 容器名（同一 docker network 下）或宿主机 IP。

• docker-compose 推荐：把 host 填 mysql（服务名），并确保两容器在同一个 network。

4. 排查是否连到了 HTTP/反向代理端口：在 AstrBot 容器里执行：

• nc -vz <MYSQL_HOST> 3306
• (可选) apk add busybox-extras && telnet <MYSQL_HOST> 3306
  正常 MySQL 会返回握手乱码；如果看到 HTTP 字样/返回为空，说明走错端口或被代理拦截。

5. 确认 MySQL 允许远程连接：MySQL 容器需暴露/映射 3306，且用户授权包含来源地址：

• 在 MySQL 容器内：SELECT user,host FROM mysql.user;
• 如需要：CREATE USER 'xxx'@'%' IDENTIFIED BY 'pwd'; GRANT ALL ON .* TO 'xxx'@'%'; FLUSH PRIVILEGES;

6. 若仍失败，请补充：你在 WebUI 里填写的 MySQL host/port、docker-compose（或 docker run）两容器的网络配置，以及在 AstrBot 容器里执行 mysql -h ... -P ... 的输出。

---

🔧 开发者修复建议（点击展开）

技术摘要: 插件在 _ensure_mysql_database_exists() 中直接调用 aiomysql.connect，遇到“连错端口/非 MySQL 协议/握手不完整”时抛出 struct.error，当前仅打印通用错误信息，缺少对常见误配（33060、localhost、HTTP 代理）的诊断提示与前置校验。

相关模块: services.database, webui.config

相关文件: services/database/sqlalchemy_database_manager.py, services/database/manager_factory.py, webui/blueprints/config.py, webui/services/config_service.py

根因分析: 根据堆栈，错误发生在 services/database/sqlalchemy_database_manager.py:_ensure_mysql_database_exists -> aiomysql.connection._get_server_information(struct.unpack)。这类 struct.error 通常是握手包长度不足，根因多为连接目标不是 MySQL 经典协议端口(3306)或网络层返回了非 MySQL 数据/空数据；插件侧未做端口/协议探测与更友好的报错分类。

修复建议: 在 services/database/sqlalchemy_database_manager.py 的 _ensure_mysql_database_exists() 增强连接前校验与异常处理：

1. 在读取配置后，若 port==33060 明确提示“这是 MySQLX 端口，请用 3306”。
2. 对 struct.error / asyncio.IncompleteReadError / aiomysql.OperationalError 做分支捕获，输出更具体的排查建议（docker 下不要用 localhost；确认容器网络；确认目标端口是否 MySQL；可提示用户用 mysql -h host -P port 验证）。
3. 可选：增加一个轻量 TCP 探测（asyncio.open_connection）读取前 N 字节，若以 'HTTP/' 开头则提示连到了 HTTP 服务；若无数据提示被防火墙/代理断开。
4. 记录实际连接参数（host、port、是否 ssl、db 名称）但注意脱敏密码。
   这样即使用户环境问题，也能在插件日志中快速定位，不再只有“unpack requires a buffer of 4 bytes”。

---

Note

信息不完整 — 请补充以下信息以便我们更快地处理：

• reproduction steps
• expected behavior
• actual behavior
• logs

---

_{🤖 此报告由 AI 自动生成，已分析仓库源码，仅供参考。开发者会尽快审阅您的 issue。}

[ChenXun-123]

Plugin Version

Next-2.0.5

AstrBot Version

v4.13.1

Database Type

MySQL

Operating System

Docker

Bug Description

MySQL 数据库链接失败 IP 和 端口号 都正确无误

Steps to Reproduce

1. 安装插件
2. 配置数据库
3. 保存

Expected Behavior

希望可以正确连接数据库

Error Logs

Astrbot日志
"""
[11:12:12] [Plug] [INFO] [core.plugin_lifecycle:323]: 尝试启动数据库管理器 (第 1/3 次)
[11:12:12] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动…
[11:12:12] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes
[11:12:12] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes
Traceback (most recent call last):
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
await self._ensure_mysql_database_exists()
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
conn = await aiomysql.connect(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
await conn._connect()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
await self._get_server_information()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
self.server_thread_id = struct.unpack('<I', data[i:i + 4])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
[11:12:12] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:329]: 数据库管理器启动返回 False (尝试 1/3)
[11:12:13] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动…
[11:12:13] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes
[11:12:13] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes
Traceback (most recent call last):
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
await self._ensure_mysql_database_exists()
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
conn = await aiomysql.connect(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
await conn._connect()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
await self._get_server_information()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
self.server_thread_id = struct.unpack('<I', data[i:i + 4])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
[11:12:13] [Plug] [ERRO] [v4.13.1] [webui.manager:105]: 启动数据库管理器失败: 数据库管理器启动失败
Traceback (most recent call last):
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/webui/manager.py", line 103, in immediate_start
raise RuntimeError("数据库管理器启动失败")
RuntimeError: 数据库管理器启动失败
[11:12:14] [Plug] [INFO] [core.plugin_lifecycle:323]: 尝试启动数据库管理器 (第 2/3 次)
[11:12:14] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动…
[11:12:14] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes
[11:12:14] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes
Traceback (most recent call last):
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
await self._ensure_mysql_database_exists()
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
conn = await aiomysql.connect(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
await conn._connect()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
await self._get_server_information()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
self.server_thread_id = struct.unpack('<I', data[i:i + 4])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
[11:12:14] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:329]: 数据库管理器启动返回 False (尝试 2/3)
[11:12:16] [Plug] [INFO] [core.plugin_lifecycle:323]: 尝试启动数据库管理器 (第 3/3 次)
[11:12:16] [Plug] [INFO] [database.sqlalchemy_database_manager:66]: [DomainRouter] 开始启动…
[11:12:16] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:182]: [DomainRouter] 确保 MySQL 数据库存在失败: unpack requires a buffer of 4 bytes
[11:12:16] [Plug] [ERRO] [v4.13.1] [database.sqlalchemy_database_manager:93]: [DomainRouter] 启动失败: unpack requires a buffer of 4 bytes
Traceback (most recent call last):
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 71, in start
await self._ensure_mysql_database_exists()
File "/AstrBot/data/plugins/astrbot_plugin_self_learning/services/database/sqlalchemy_database_manager.py", line 162, in _ensure_mysql_database_exists
conn = await aiomysql.connect(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 74, in _connect
await conn._connect()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 539, in _connect
await self._get_server_information()
File "/usr/local/lib/python3.11/site-packages/aiomysql/connection.py", line 1058, in _get_server_information
self.server_thread_id = struct.unpack('<I', data[i:i + 4])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
struct.error: unpack requires a buffer of 4 bytes
[11:12:16] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:329]: 数据库管理器启动返回 False (尝试 3/3)
[11:12:16] [Plug] [ERRO] [v4.13.1] [core.plugin_lifecycle:343]: 数据库管理器启动失败: 所有重试均失败
[11:12:16] [Plug] [WARN] [v4.13.1] [core.plugin_lifecycle:346]: 插件将在数据库功能受限的情况下继续运行
[11:12:16] [Plug] [INFO] [core.patterns:43]: 服务状态变更: created -> initializing
[11:12:16] [Plug] [ERRO] [v4.13.1] [state.affection_manager:518]: 获取活跃群组列表失败: 数据库管理器未启动，engine不存在
[11:12:16] [Plug] [INFO] [state.affection_manager:423]: 没有发现活跃群组，跳过情绪初始化
[11:12:16] [Plug] [INFO] [state.affection_manager:139]: 好感度管理服务启动成功
[11:12:16] [Plug] [INFO] [core.patterns:43]: 服务状态变更: initializing -> running
[11:12:16] [Plug] [INFO] [core.patterns:56]: 服务启动成功
[11:12:16] [Plug] [INFO] [core.plugin_lifecycle:352]: 好感度管理服务启动成功
[11:12:16] [Plug] [INFO] [webui.manager:207]: 成功获取 AstrBot 框架 PersonaManager: <class 'astrbot.core.persona_mgr.PersonaManager'>
[11:12:16] [Plug] [INFO] [webui.dependencies:98]: [WebUI] persona_updater 获取成功: <class 'data.plugins.astrbot_plugin_self_learning.services.persona.persona_updater.PersonaUpdater'>
[11:12:16] [Plug] [INFO] [webui.dependencies:138]: [WebUI] 性能监测模块初始化成功
[11:12:16] [Plug] [INFO] [webui.dependencies:155]: [WebUI] PersonaWebManager 初始化成功
[11:12:16] [Plug] [INFO] [webui.dependencies:163]: [WebUI] 服务容器初始化完成
[11:12:16] [Plug] [INFO] [webui.dependencies:218]: [WebUI] 插件服务设置完成
[11:12:16] [Plug] [INFO] [webui.manager:140]: Web 服务器插件服务设置完成
[11:12:16] [Plug] [INFO] [webui.manager:147]: 准备启动 Web 服务器: http://0.0.0.0:8080
[11:12:16] [Plug] [INFO] [webui.app:49]: [WebUI] Quart 应用创建成功
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: auth
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: config
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: personas
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: learning
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: jargon
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: chat
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: bug_report
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: metrics
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: social
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: persona_reviews
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: intelligent_chat
[11:12:16] [Plug] [INFO] [webui.app:67]: [WebUI] 已注册蓝图: monitoring
[11:12:16] [Plug] [INFO] [webui.app:69]: [WebUI] 共注册 12 个蓝图
[11:12:16] [Plug] [INFO] [webui.server:139]: [WebUI] 启动服务器: http://0.0.0.0:8080
[11:12:17] [Plug] [INFO] [webui.server:152]: [WebUI] Web服务器启动成功
[11:12:17] [Plug] [INFO] [webui.server:153]: [WebUI] 本地访问: http://127.0.0.1:8080
[11:12:17] [Plug] [INFO] [webui.manager:152]: Web 服务器启动完成
[11:12:17] [Plug] [INFO] [core.plugin_lifecycle:401]: 自学习插件加载完成 """

Mysql日志
"""
2026-03-02 11:12:41+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
2026-03-02 11:12:41+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2026-03-02 11:12:41+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2026-03-02T03:12:41.966710Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2026-03-02T03:12:41.967964Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
2026-03-02T03:12:41.972642Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2026-03-02T03:12:42.186532Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2026-03-02T03:12:42.429814Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2026-03-02T03:12:42.429874Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2026-03-02T03:12:42.432390Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2026-03-02T03:12:42.455386Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2026-03-02T03:12:42.455501Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.34' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
"""

Relevant Configuration

我的Astrbot 和 Mysql 分别是两个docker容器

Additional Context

刚开始玩BOT, 不懂的还很多, 希望大佬能多指点一下, 谢谢

[NickCharlie]

@ChenXun-123
你好，这个 unpack requires a buffer of 4 bytes 错误的主因是 MySQL 8.0 默认开启 TLS，aiomysql 解析握手包时数据格式不匹配。此问题已在 Next-2.0.6 中修复（显式禁用 SSL 连接）。另外从日志看，你的插件在 11:12:12 尝试连接，而 MySQL 在 11:12:42 才就绪，存在 30 秒的启动时序差。

建议排查解决步骤：

1. 升级插件到 Next-2.0.6（核心修复，直接解决 SSL 握手问题） Release Next-2.0.6: Stability & Reliability Fixes #66
2. 确认端口填的是 3306（不是 33060），Host 不要填 localhost/127.0.0.1，填 MySQL 容器名或服务名
3. docker-compose 中给 MySQL 加 healthcheck + depends_on，确保 MySQL 就绪后 AstrBot 再启动
4. 检查环境安装的依赖库是否与本插件的requirements.txt中规定的依赖库版本一致
5. 如仍有问题，参考上方 bot 回复中的容器内连通性测试步骤验证网络是否通畅
6. 升级后如果还有问题，请贴一下你的最新的错误日志

[ChenXun-123]

已经可以成功链接了, 感谢作者