Keycloak docker服务无法连接到数据库

Question

我是docker的新手，我想用Docker-compose启动一个keycloak容器。我正在使用一个mariadb和数据库启动成功。但是当启动keycloak容器时，它会出现这个错误。

原因：java.sql.sqlnontransientconnectionException：无法连接到address=(Host=Project-DB)(Port=3308)(Type=master):套接字无法连接到主机:Project-DB，端口：3308。在org.mariadb.jdbc//org.mariadb.jdbc.internal.util.exceptions.exceptionmapper.get（exceptionmapper.java:241)在org.mariadb.jdbc//org.mariadb.jdbc//org.mariadb.jdbc.internal.protocol.abstractConnectProtocol.connectWithoutProxy（abstractConnectProtocol.java:1243)，在bc//org.mariadb.jdbc.driver.connect（driver.java：86）位于org.jboss.ironjacamar.jdbcadapters@1.4.20。final//org.jboss.jca.adapters.jdbc.localmanagedconnectionfactory.createLocalManagedConnectionFactory.createLocalManagedConnectionFactory(localManagedConnectionFactory.java:321)...57更多原因是：在org.mariadb.jdbc//org.mariadb.jdbc.internal.util.exceptions.exceptionmapper.get（exceptionmapper.java:241)在org.mariadb.jdbc//org.mariadb.jdbc.internal.util.exceptions.exceptionmapper.connexception（exceptionmapper.java:87)在org.mariadb.jdbc//org.mariadb.jdbc//org.mariadb.jdbc.java:474)在org.mariadb.jdbc//org.mariadb.jdbc//org.mariadb.jdbc.internal.protocol.abstractConnectProtocol.ConnectWithOutProxy（abstractConnectProtocol.java:1238)...61更多原因是：java.net.ConnectException：连接拒绝（Connection拒绝）在java.base/java.net.plainsockeTimpl.socketConnect（本机方法）在在java.base/java.net.sockssocketimpl.connect（abstractplainsocketimpl.java:224)在java.base/java.net.sockssocketimpl.connect（sockssocketimpl.java:403)在java.base/java.net.socket.connect（sockssocketimpl.java:403)在java.base/java.net.socket.connect（socket.java:609)在

这是我的码头工人作曲。

version: "3.6"
services:
  project-db:
    container_name: project-maria-db
    image: mariadb:10.5.8-focal
    restart: always
    ports:
      - 3308:3306
    volumes:
      - /project/db:/data/db
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=project
      - MYSQL_USER=user
      - MYSQL_PASSWORD=password

  project-keycloak:
    container_name: project-keycloak
    image: quay.io/keycloak/keycloak:10.0.1
    restart: always
    ports:
      - 8180:8080
    environment:
      PROXY_ADDRESS_FORWARDING: "true"
      DB_VENDOR: mariadb
      DB_ADDR: project-db
      DB_PORT: 3308
      DB_DATABASE: project_keycloak
      DB_USER: user
      DB_PASSWORD: password
      KEYCLOAK_USER: admin
      KEYCLOAK_PASSWORD: admin
    depends_on:
      - project-db

有人能帮我解决这个问题吗？

Answer 1

您需要添加网络来将它们组合在同一个网络中。

version: "3.6"
services:
  project-db:
    container_name: project-maria-db
    image: mariadb:10.5.8-focal
    restart: always
    ports:
      - 3308:3306
    volumes:
      - /project/db:/data/db
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=project
      - MYSQL_USER=user
      - MYSQL_PASSWORD=password
    networks:
      - app-network

  project-keycloak:
    container_name: project-keycloak
    image: quay.io/keycloak/keycloak:10.0.1
    restart: always
    ports:
      - 8180:8080
    environment:
      PROXY_ADDRESS_FORWARDING: "true"
      DB_VENDOR: mariadb
      DB_ADDR: project-db
      DB_PORT: 3308
      DB_DATABASE: project_keycloak
      DB_USER: user
      DB_PASSWORD: password
      KEYCLOAK_USER: admin
      KEYCLOAK_PASSWORD: admin
    depends_on:
      - project-db
    networks:
      - app-network
networks:
  app-network:
    driver: bridge