请教关于nocobase的docker部署MySQL数据库启动错误的处理方法

中文讨论区 使用咨询
1

请教一下大佬：
最近部署nocobase一直出错，界面显示如下：

image
image765×418 6.18 KB

请问是什么原因？
docker-compose up日志如下：

Creating nocobase_mysql_1 ... done
Creating nocobase_mysql_1 ...
Creating nocobase_app_1   ... done
Attaching to nocobase_mysql_1, nocobase_app_1
mysql_1  | 2024-08-23 03:47:05+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
app_1    | copying...
mysql_1  | 2024-08-23 03:47:05+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1  | 2024-08-23 03:47:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1  | 2024-08-23 03:47:06+00:00 [Note] [Entrypoint]: Initializing database files
mysql_1  | 2024-08-23T03:47:06.269666Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
mysql_1  | 2024-08-23T03:47:06.271234Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.4.0) initializing of server in progress as process 82
mysql_1  | 2024-08-23T03:47:06.272665Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
mysql_1  | 2024-08-23T03:47:06.272671Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
mysql_1  | 2024-08-23T03:47:06.272722Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql_1  | 2024-08-23T03:47:06.273184Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
nocobase_mysql_1 exited with code 1



docker-compose.yml文件配置：
version: "3"

networks:
  nocobase:
    driver: bridge

services:
  app:
    image: registry.cn-shanghai.aliyuncs.com/nocobase/nocobase:1.2.4-alpha
    networks:
      - nocobase
    depends_on:
      - mysql
    environment:
      # 应用的密钥，用于生成用户 token 等
      # 如果 APP_KEY 修改了，旧的 token 也会随之失效
      # 可以是任意随机字符串，并确保不对外泄露
      - APP_KEY=your-secret-key
      # 数据库类型，支持 postgres, mysql, mariadb, sqlite
      - DB_DIALECT=mysql
      # 数据库主机，可以替换为已有的数据库服务器 IP
      - DB_HOST=127.0.0.1
      # 数据库名
      - DB_DATABASE=nocobase
      # 数据库用户
      - DB_USER=root
      # 数据库密码
      - DB_PASSWORD=nocobase
      # 仅 MySQL（或 MariaDB）有效
      - DB_TIMEZONE=+08:00
      # 数据库表名、字段名是否转为 snake case 风格
      - DB_UNDERSCORED=true
    volumes:
      - ./storage:/app/nocobase/storage
    ports:
      - "13000:80"
    # init: true

# 如果使用已有数据库服务，可以不启动 mysql
  mysql:
    image: registry.cn-shanghai.aliyuncs.com/nocobase/mysql:8
    environment:
      MYSQL_DATABASE: nocobase
      MYSQL_USER: nocobase
      MYSQL_PASSWORD: nocobase
      MYSQL_ROOT_PASSWORD: nocobase
    restart: always
    volumes:
      - ./storage/db/mysql:/var/lib/mysql
    networks:
      - nocobase
[root@localhost nocobase]#
2

docker部署，DB_HOST=127.0.0.1是错误的配置，建议不改变官方的默认设定部署启动

3

老师，还是不行，没有起作用：

[root@localhost nocobase]# clear
[root@localhost nocobase]# vi docker-compose.yml
[root@localhost nocobase]# docker-compose up
Starting nocobase_mysql_1 ... done
Recreating nocobase_app_1 ... done
Attaching to nocobase_mysql_1, nocobase_app_1
mysql_1  | 2024-08-23 04:06:47+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1  | 2024-08-23 04:06:47+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1  | 2024-08-23 04:06:47+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
app_1    | copying...
mysql_1  | 2024-08-23 04:06:47+00:00 [Note] [Entrypoint]: Initializing database files
mysql_1  | 2024-08-23T04:06:47.698407Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
mysql_1  | 2024-08-23T04:06:47.700319Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.4.0) initializing of server in progress as process 82
mysql_1  | 2024-08-23T04:06:47.702143Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
mysql_1  | 2024-08-23T04:06:47.702150Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
mysql_1  | 2024-08-23T04:06:47.702221Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql_1  | 2024-08-23T04:06:47.702657Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
app_1    | yarn run v1.22.19
app_1    | $ nocobase create-nginx-conf
app_1    | Done in 0.69s.
app_1    | nginx started
app_1    | yarn run v1.22.19
nocobase_mysql_1 exited with code 1
app_1    | $ nocobase start --quickstart
mysql_1  | 2024-08-23 03:47:05+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1  | 2024-08-23 03:47:05+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1  | 2024-08-23 03:47:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
mysql_1  | 2024-08-23 03:47:06+00:00 [Note] [Entrypoint]: Initializing database files
mysql_1  | 2024-08-23T03:47:06.269666Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
mysql_1  | 2024-08-23T03:47:06.271234Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.4.0) initializing of server in progress as process 82
mysql_1  | 2024-08-23T03:47:06.272665Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
mysql_1  | 2024-08-23T03:47:06.272671Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
mysql_1  | 2024-08-23T03:47:06.272722Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql_1  | 2024-08-23T03:47:06.273184Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
4

修改了的docker-compose.yml：

version: "3"

networks:
  nocobase:
    driver: bridge

services:
  app:
    image: registry.cn-shanghai.aliyuncs.com/nocobase/nocobase:1.2.4-alpha
    networks:
      - nocobase
    depends_on:
      - mysql
    environment:
      # 应用的密钥，用于生成用户 token 等
      # 如果 APP_KEY 修改了，旧的 token 也会随之失效
      # 可以是任意随机字符串，并确保不对外泄露
      - APP_KEY=your-secret-key
      # 数据库类型，支持 postgres, mysql, mariadb, sqlite
      - DB_DIALECT=mysql
      # 数据库主机，可以替换为已有的数据库服务器 IP
      - DB_HOST=mysql
      # 数据库名
      - DB_DATABASE=nocobase
      # 数据库用户
      - DB_USER=root
      # 数据库密码
      - DB_PASSWORD=nocobase
      # 仅 MySQL（或 MariaDB）有效
      - DB_TIMEZONE=+08:00
      # 数据库表名、字段名是否转为 snake case 风格
      - DB_UNDERSCORED=true
    volumes:
      - ./storage:/app/nocobase/storage
    ports:
      - "13000:80"
    # init: true

# 如果使用已有数据库服务，可以不启动 mysql
  mysql:
    image: registry.cn-shanghai.aliyuncs.com/nocobase/mysql:8
    environment:
      MYSQL_DATABASE: nocobase
      MYSQL_USER: nocobase
      MYSQL_PASSWORD: nocobase
      MYSQL_ROOT_PASSWORD: nocobase
    restart: always
    volumes:
      - ./storage/db/mysql:/var/lib/mysql
"docker-compose.yml" 51L, 1421C