首页 > 解决方案 > Prisma - 连接到外部数据库

问题描述

Prisma 正在使用 docker 设置的数据库,并且工作正常。我想使用另一个数据库,如 AWS RDS。我正在使用这个文档:https ://www.prisma.io/docs/tutorials/setup-prisma/connect-empty-db/mysql-dusee0nore

这里有我之前的文件:

docker-compose.yml(之前)

version: '3'
services:
  prisma:
    image: prismagraphql/prisma:1.8
    restart: always
    ports:
      - '4466:4466'
    environment:
      PRISMA_CONFIG: |
        port: 4466
        # uncomment the next line and provide the env var PRISMA_MANAGEMENT_API_SECRET=my-secret to activate cluster security
        # managementApiSecret: my-secret
        databases:
          default:
            connector: mysql
            host: mysql
            port: 3306
            user: root
            password: prisma
            migrations: true
  mysql:
    ports:
      - '3306:3306'
    image: mysql:5.7
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: prisma
      TZ: America/Los_Angeles
    volumes:
      - mysql:/var/lib/mysql
volumes:
  mysql:

docker-compose.yml(之后)

version: '3'
services:
  prisma:
    image: prismagraphql/prisma:1.8
    restart: always
    ports:
      - '4466:4466'
    environment:
      PRISMA_CONFIG: |
        port: 4466
        # uncomment the next line and provide the env var PRISMA_MANAGEMENT_API_SECRET=my-secret to activate cluster security
        # managementApiSecret: my-secret
        databases:
          default:
            connector: mysql
            host: *************.us-west-2.rds.amazonaws.com
            user: *************
            password: *************
            rawAccess: true
            port: '3306'
            migrations: false

字段主机、用户和密码很好,因为我可以使用其他工具连接到这个数据库。

然后:

> docker-compose up -d
> Recreating server_prisma_1 ... done

启动服务器后,我得到:

[Network error]: FetchError: request to http://localhost:4466/nacho/prod failed, reason: connect ECONNREFUSED 127.0.0.1:4466

或者

[Network error]: FetchError: request to http://localhost:4466/nacho/prod failed, reason: socket hang up

知道如何调试吗?

标签: databasedockerprisma

解决方案


推荐阅读