fnOS 部署 RAGFlow，Mysql启动失败，反复重启错误已解决

一點墨

fnOS 部署 RAGFlow，Mysql启动失败，反复重启错误已解决

查询日志发现报错：无法打开引导文件 /data/application/init.sql

2025-01-26T15:32:11.055521Z 0 [ERROR] [MY-010455] [Server] Failed to open the bootstrap file /data/application/init.sql

2025-01-26T15:32:11.055529Z 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.

2025-01-26T15:32:11.055535Z 0 [ERROR] [MY-010119] [Server] Aborting

# 翻译如下：
2025-01- 26 T15：32：11.055521Z 0 [错误] [MY-010455] [服务器]无法打开引导文件/data/application/init. SQL
2025-01- 26 T15：32：11.055529Z 0 [错误] [MY-013236] [服务器]指定的数据目录/var/lib/mysql/不可用。您可以删除服务器添加到其中的所有文件。
2025-01- 26 T15：32：11.055535Z 0 [错误] [MY-010119] [服务器]中止

---

1. 准备工具

安装服务器管理面板 1panel ，修改文件时需要用到

---

2. 打开 1panel 把 RAGFlow 容器挂在的所有文件目录删除

1. 当前 docker 配置文件目录下的 ragflow-logs
2. /vol1/docker/volumes 目录下的所有 RAGFlow 目录

---

3. 打开 1panel 修改docker 配置文件目录下的公共的读取权限 /ragflow/docker initial.sql

4. 重新打开 Docker 的项目管理项启动 RAGFlow

不再有报错提示

项目启动日志：

time="2025-01-26T22:27:36+08:00" level=warning msg="The \"MACOS\" variable is not set. Defaulting to a blank string."
Network ragflow-1_ragflow Creating
Network ragflow-1_ragflow Created
Volume "ragflow-1_minio_data" Creating
Volume "ragflow-1_minio_data" Created
Volume "ragflow-1_redis_data" Creating
Volume "ragflow-1_redis_data" Created
Volume "ragflow-1_esdata01" Creating
Volume "ragflow-1_esdata01" Created
Volume "ragflow-1_mysql_data" Creating
Volume "ragflow-1_mysql_data" Created
Container ragflow-mysql Creating
Container ragflow-redis Creating
Container ragflow-es-01 Creating
Container ragflow-minio Creating
Container ragflow-redis Created
Container ragflow-minio Created
Container ragflow-es-01 Created
Container ragflow-mysql Created
Container ragflow-server Creating
Container ragflow-server Created
Container ragflow-redis Starting
Container ragflow-es-01 Starting
Container ragflow-mysql Starting
Container ragflow-minio Starting
Container ragflow-mysql Started
Container ragflow-mysql Waiting
Container ragflow-redis Started
Container ragflow-es-01 Started
Container ragflow-minio Started
Container ragflow-mysql 
Container ragflow-server Starting
Container ragflow-server Started
Exited:0```

ragflow-server 日志：

  ______           __      ______                     __  

 /_  __/___ ______/ /__   / ____/  _____  _______  __/ /_____  _____

  / / / __ `/ ___/ //_/  / __/ | |/_/ _ \/ ___/ / / / __/ __ \/ ___/

 / / / /_/ (__  ) ,<    / /____>  </  __/ /__/ /_/ / /_/ /_/ / /  

/_/  \__,_/____/_/|_|  /_____/_/|_|\___/\___/\__,_/\__/\____/_/           



2025-01-26 22:28:31,331 INFO     14 TaskExecutor: RAGFlow version: v0.15.0 full

2025-01-26 22:28:31,332 INFO     14 Use Elasticsearch http://es01:9200 as the doc engine.

2025-01-26 22:28:31,337 INFO     14 GET http://es01:9200/ [status:200 duration:0.005s]

2025-01-26 22:28:31,341 INFO     14 HEAD http://es01:9200/ [status:200 duration:0.003s]

2025-01-26 22:28:31,341 INFO     14 Elasticsearch http://es01:9200 is .

一點墨

博客：https://nasai.us.kg/

Gougl

感谢分享，我也遇上了同样的问题，表现也是mysql无限重启，通过相同方法已解决。不过我的错误代码不同，显示的是找不到mysql.user，应该也是init.sql文件访问权限导致的，分享出来给其他人也参考下。