本地 docker 部署后修改数据库为 MySQL 失败

[iTofu]

已知

• 修改至 MySQL 方案来自：https://www.bilibili.com/video/BV1iV4y1T7kh/
• docker 方案来自：https://alist.nn.ci/zh/guide/install/docker.html
• 最终 docker compose 文件：

  services:
    alist:
        image: xhofe/alist:latest
        container_name: alist
        volumes:
            - ./data:/opt/alist/data
        ports:
            - 5244:5244
        environment:
            - TZ=Asia/Shanghai
            - PUID=0
            - PGID=0
            - UMASK=022
        restart: unless-stopped
        # restart: on-failure:3
        depends_on:
            - alist-db
    
    alist-db:
        image: mysql:latest
        container_name: alist-db
        restart: unless-stopped
        # restart: on-failure:3
        #   env_file:
        #       - .env
        environment:
            - MYSQL_DATABASE=alist
            - MYSQL_ROOT_PASSWORD=root
            - MYSQL_USER=alist
            - MYSQL_PASSWORD=xxxxxxx
        ports:
            - 13306:3306
        volumes:
            - ./dbdata:/var/lib/mysql
            - ./my.cnf:/etc/mysql/conf.d/my.cnf   # 挂载自定义的配置文件
        healthcheck:
            test: ["CMD", "mysqladmin", "ping", "-h", "localhost"]
            interval: 2s
            timeout: 5s
            retries: 5
  

  my.cnf:

  [mysqld]
  character-set-server = utf8mb4
  collation-server = utf8mb4_general_ci
  
  [client]
  default-character-set = utf8mb4
  
  [mysql]
  default-character-set = utf8mb4
  

  config.json 修改 db 部分：

  "database": {
    "type": "mysql",
    "host": "localhost",
    "port": 13306,
    "user": "root",
    "password": "root",
    "name": "alist",
    "db_file": "data/data.db",
    "table_prefix": "x_",
    "ssl_mode": "",
    "dsn": ""
  },
  

问题

docker 运行后，alist-db 容器成功启动，使用 DBeaver 工具也能连接。但 alist 容器启动失败，日志：

INFO[2024-09-17 17:48:47] reading config file: data/config.json        
INFO[2024-09-17 17:48:47] load config from env with prefix:            
INFO[2024-09-17 17:48:47] init logrus...                               
INFO[2024-09-17 17:48:48] reading config file: data/config.json        
INFO[2024-09-17 17:48:48] load config from env with prefix:            
INFO[2024-09-17 17:48:48] init logrus...                               
INFO[2024-09-17 17:48:49] reading config file: data/config.json        
INFO[2024-09-17 17:48:49] load config from env with prefix:            
INFO[2024-09-17 17:48:49] init logrus...                               
INFO[2024-09-17 17:48:50] reading config file: data/config.json        
INFO[2024-09-17 17:48:50] load config from env with prefix:            
INFO[2024-09-17 17:48:50] init logrus...                               
INFO[2024-09-17 17:48:52] reading config file: data/config.json        
INFO[2024-09-17 17:48:52] load config from env with prefix:            
INFO[2024-09-17 17:48:52] init logrus...      

尝试过：在本地起了个单纯的 MySQL docker 镜像，端口 3306，和用户名密码等配置丢进 config.json 后，docker 启动还是相同的错误 :(

麻烦有空帮我看一下，谢谢！

[Soulballad]

我也遇到这个问题，一直无法解决