search

w5teams / w5

Security Orchestration, Automation and Response (SOAR) Platform. 安全编排与自动化响应平台，无需编写代码的安全自动化，使用 SOAR 可以让团队工作更加高效
https://w5.io
GNU General Public License v3.0
1.48k stars 244 forks source link

docker搭建失败 #68

Open s7safe opened 4 months ago

s7safe commented 4 months ago

图片 正常docker搭建，mysql启动失败

s7safe commented 4 months ago

mysql_1 | 2024-05-17T01:21:07.906538Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. mysql_1 | 2024-05-17T01:21:07.991299Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. mysql_1 | 2024-05-17T01:21:08.008425Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. mysql_1 | 2024-05-17T01:21:08.008603Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. mysql_1 | 2024-05-17T01:21:08.079362Z 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. mysql_1 | 2024-05-17T01:21:08.080078Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:21:08.080402Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist mysql_1 | 2024-05-17T01:21:08.080446Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. mysql_1 | 2024-05-17T01:21:08.080666Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'. mysql_1 | 2024-05-17T01:21:08.082030Z 0 [ERROR] [MY-010119] [Server] Aborting mysql_1 | 2024-05-17T01:21:09.605572Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL. mysql_1 | 2024-05-17T01:21:09.605613Z 0 [System] [MY-015016] [Server] MySQL Server - end. mysql_1 | 2024-05-17 09:22:11+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started. mysql_1 | 2024-05-17 09:22:12+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' mysql_1 | 2024-05-17 09:22:12+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started. mysql_1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' mysql_1 | 2024-05-17T01:22:14.277258Z 0 [System] [MY-015015] [Server] MySQL Server - start. mysql_1 | 2024-05-17T01:22:15.201422Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1 mysql_1 | 2024-05-17T01:22:15.219775Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. mysql_1 | 2024-05-17T01:22:16.611350Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysql_1 | mysqld: Table 'mysql.plugin' doesn't exist mysql_1 | 2024-05-17T01:22:17.201915Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. mysql_1 | 2024-05-17T01:22:17.202478Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.202793Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.203102Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.203694Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.203903Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.204175Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.204370Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.396823Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. mysql_1 | 2024-05-17T01:22:17.487794Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. mysql_1 | 2024-05-17T01:22:17.502071Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. mysql_1 | 2024-05-17T01:22:17.502131Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. mysql_1 | 2024-05-17T01:22:17.509487Z 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. mysql_1 | 2024-05-17T01:22:17.519455Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables mysql_1 | 2024-05-17T01:22:17.520206Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist mysql_1 | 2024-05-17T01:22:17.520314Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. mysql_1 | 2024-05-17T01:22:17.520832Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'. mysql_1 | 2024-05-17T01:22:17.525253Z 0 [ERROR] [MY-010119] [Server] Aborting mysql_1 | 2024-05-17T01:22:19.091325Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL. mysql_1 | 2024-05-17T01:22:19.091359Z 0 [System] [MY-015016] [Server] MySQL Server - end. mysql_1 | 2024-05-17 09:23:21+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started. mysql_1 | 2024-05-17 09:23:22+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' mysql_1 | 2024-05-17 09:23:22+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started. mysql_1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' mysql_1 | 2024-05-17T01:23:23.611534Z 0 [System] [MY-015015] [Server] MySQL Server - start. mysql_1 | 2024-05-17T01:23:24.977378Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1 mysql_1 | 2024-05-17T01:23:24.991043Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. mysql_1 | 2024-05-17T01:23:26.014000Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysql_1 | mysqld: Table 'mysql.plugin' doesn't exist mysql_1 | 2024-05-17T01:23:26.602608Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.

rfma commented 4 months ago

docker-compose.yaml文件中，修订mysql基础镜像为：
mysql: image: mysql:5.7.41 测试可通过！

starscow commented 2 months ago

试过了不行

ComposerLM commented 1 month ago

修改 docker-compose.yml 文件为如下文件--

version: '3' services: web: build: . restart: always container_name: w5_web

platform: "linux/amd64"

ports:
  - "8888:8888"
depends_on:
  - mysql
  - redis
environment:
  MYSQL_HOST: "mysql"
  MYSQL_PORT: 3306
  MYSQL_DATABASE: "w5_db"
  MYSQL_USER: "root"
  MYSQL_PASSWORD: "w5_12345678"
  REDIS_HOST: "redis"
  REDIS_PORT: 6379
  REDIS_DATABASE: 0
  REDIS_PASSWORD: ""
volumes:
  - ./docker/config.ini:/w5/config.ini
  - ./docker/apps:/w5/apps
  - ./docker/logs:/opt
  - /etc/localtime:/etc/localtime
networks:
  - w5Net

mysql: image: mysql:5.7 restart: always container_name: w5_mysql ports:

networks: w5Net: driver: bridge