How to connect DB-GPT to local MYSQL?I got Errno 111 even when the docker containers run well.

[zjiang4]

Search before asking

• [X] I had searched in the issues and found no similar feature requirement.

Description

docker环境下，我执行了以下步骤，但却不成功，创建在DB-GPT中创建MYSQL数据提示

错误提示

dbgpt Test connect Failure!(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on '127.0.0.1' (【Errno 111】 Connection refused)") (Background on this error at: https://sqlalche.me/e/20/e3q8)

run了一个mysql的容器（我用python可连接）

docker run --name=mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=aa12345678 -dit mysql:latest docker cp C:\Users\zjian\DB-GPT\assets\schema\dbgpt.sql 9e03541c2415:/home/ mysql -h 127.0.0.1 -u root -paa12345678 < ./home/dbgpt.sql

DB-GPT上，baichun可正常使用

docker run -p 5000:5000 --gpus all -e LOCAL_DB_USER=root -e LOCAL_DB_PASSWORD=aa12345678 -e LOCAL_DB_HOST=127.0.0.1 -e LOCAL_DB_PORT=3306 -e LLM_MODEL=baichuan2-7b -e LANGUAGE=zh -v /c/Users/zjian/DB-GPT/models:/app/models -d eosphorosai/dbgpt

Documentation Links

No response

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

[Tarzan999]

我也一样，请问大佬解决了么？

[gjxwwww8888]

2024-05-21 16:45:22 GPU-99 dbgpt.storage.vector_store.connector[3350824] INFO VectorStore:<class 'dbgpt.storage.knowledge_graph.knowledge_graph.BuiltinKnowledgeGraph'> 2024-05-21 16:45:22 GPU-99 dbgpt.storage.graph_store.factory[3350824] ERROR create graph store failed: Couldn't connect to 127.0.0.1:7687 (resolved to ()): Failed to establish connection to ResolvedIPv4Address(('127.0.0.1', 7687)) (reason [Errno 111] Connection refused) 2024-05-21 16:45:22 GPU-99 dbgpt.storage.vector_store.connector[3350824] ERROR connect vector store failed: Couldn't connect to 127.0.0.1:7687 (resolved to ()): Failed to establish connection to ResolvedIPv4Address(('127.0.0.1', 7687)) (reason [Errno 111] Connection refused) 我也遇到这个问题，有答案了吗？

[github-actions[bot]]

This issue has been marked as stale, because it has been over 30 days without any activity.

[github-actions[bot]]

This issue bas been closed, because it has been marked as stale and there has been no activity for over 7 days.

[Storm0921]

2024-05-21 16:45:22 GPU-99 dbgpt.storage.vector_store.connector[3350824] INFO VectorStore:<class 'dbgpt.storage.knowledge_graph.knowledge_graph.BuiltinKnowledgeGraph'>2024-05-21 16:45:22 GPU-99 dbgpt.storage.vector_store连接器[3350824]信息向量存储：<类'dbgpt.store.knowledge_graph.knowledge_graph。内置知识图谱 2024-05-21 16:45:22 GPU-99 dbgpt.storage.graph_store.factory[3350824] ERROR create graph store failed: Couldn't connect to 127.0.0.1:7687 (resolved to ()):2024-05-21 16:45:22 GPU-99 dbgpt.storage.graph_store.factory[3350824]错误创建图形存储失败：无法连接到127.0.0.1:7687（解析为（））： Failed to establish connection to ResolvedIPv4Address(('127.0.0.1', 7687)) (reason [Errno 111] Connection refused)未能建立与ResolvedIPv6地址（'127.0.0.1'，7687）的连接（原因[Errno 111]连接被拒绝） 2024-05-21 16:45:22 GPU-99 dbgpt.storage.vector_store.connector[3350824] ERROR connect vector store failed: Couldn't connect to 127.0.0.1:7687 (resolved to ()):2024-05-21 16:45:22 GPU-99 dbgpt.storage.vector.connector[3350824]错误连接向量存储失败：无法连接到127.0.0.1:7687（解析为（））： Failed to establish connection to ResolvedIPv4Address(('127.0.0.1', 7687)) (reason [Errno 111] Connection refused)未能建立与ResolvedIPv6地址（'127.0.0.1'，7687）的连接（原因[Errno 111]连接被拒绝） 我也遇到这个问题，有答案了吗？

你解决这个问题了吗，我也遇到了

[yellow123Nike]

@Storm0921 你解决了吗？我也遇到了

[xumeivs]

@yellow123Nike tugraph db 没有部署