Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

docker-compose启动one-api服务报错:failed to initialize database, got error dial tcp: lookup db on 127.0.0.11:53: server misbehaving #1077

Closed
5 tasks done
syusama opened this issue Mar 4, 2024 · 3 comments
Labels
bug Something isn't working

Comments

@syusama
Copy link

syusama commented Mar 4, 2024

例行检查

  • 我已确认目前没有类似 issue
  • 我已确认我已升级到最新版本
  • 我已完整查看过项目 README,尤其是常见问题部分
  • 我理解并愿意跟进此 issue,协助测试和提供反馈
  • 我理解并认可上述内容,并理解项目维护者精力有限,不遵循规则的 issue 可能会被无视或直接关闭

问题描述
docker-compose启动one-api服务报错:failed to initialize database, got error dial tcp: lookup db on 127.0.0.11:53: server misbehaving
复现步骤
这是我的docker-compose.yml
`version: '3.4'

services:
one-api:
image: justsong/one-api:v0.6.0
container_name: one-api
restart: always
command: --log-dir /app/logs
ports:
- "3001:3000"
volumes:
- ./data/oneapi:/data
- ./logs:/app/logs
environment:
- SQL_DSN=oneapi:123456@tcp(db:3306)/one-api # 修改此行,或注释掉以使用 SQLite 作为数据库
- REDIS_CONN_STRING=redis://one-api-redis
- SESSION_SECRET=123456 # 修改为随机字符串
- TZ=Asia/Shanghai

- NODE_TYPE=slave # 多机部署时从节点取消注释该行

- SYNC_FREQUENCY=60 # 需要定期从数据库加载数据时取消注释该行

- FRONTEND_BASE_URL=https://openai.justsong.cn # 多机部署时从节点取消注释该行

depends_on:
  - one-api-redis
  - one-api-mysql
healthcheck:
  test: [ "CMD-SHELL", "wget -q -O - http://localhost:3000/api/status | grep -o '\"success\":\\s*true' | awk -F: '{print $$2}'" ]
  interval: 30s
  timeout: 10s
  retries: 3

one-api-redis:
image: redis:latest
container_name: one-api-redis
restart: always

one-api-mysql:
image: mysql:8.2.0
restart: always
container_name: one-api-mysql
volumes:
- ./data/mysql:/var/lib/mysql # 挂载目录,持久化存储
ports:
- '3307:3306'
environment:
TZ: Asia/Shanghai # 设置时区
MYSQL_ROOT_PASSWORD: '123456' # 设置 root 用户的密码
MYSQL_USER: oneapi # 创建专用用户
MYSQL_PASSWORD: '123456' # 设置专用用户密码
MYSQL_DATABASE: one-api # 自动创建数据库`
预期结果
启动后one-api服务报错
相关截图
如果没有的话,请删除此节。
1709544722347

@syusama syusama added the bug Something isn't working label Mar 4, 2024
@syusama syusama closed this as completed Mar 4, 2024
@Crush-RY
Copy link

出现了同样的问题,可以告知下如何解决的吗?谢谢!

@Axe-l
Copy link

Axe-l commented Mar 30, 2024

SAME

@anjia1991
Copy link

  • SQL_DSN=oneapi:123456@tcp($YOUR_DB_IP:3306)/one-api

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants