通過dockercompose運行keycloak和postgresdb

我目前有一個 docker compose 檔案，它設定一個 psql 資料庫并運行大約 80 個 sql 檔案來為我的應用程式創建關系。我現在要做的是向應用程式添加一個 keycloak 層。我也在嘗試通過撰寫檔案來執行此操作，但我不斷收到錯誤訊息，說我的一個關系已經存在。我認為正在發生的是，當我運行 keycloak 服務時，它試圖覆寫資料庫，我不希望這種情況發生。我不知道如何解決這個問題，我已經嘗試了很多在網上找到的其他方法，但它們都不起作用。

這是我的撰寫檔案（洗掉一些 sql 腳本以使其更簡單）：

---
version: "3.8"

services:
  database:
    container_name: database
    environment:
    # add multiple schemas
      # POSTGRES_MULTIPLE_DATABASES: ${POSTGRESQL_DATABASE},${POSTGRESQL_KEYCLOAK_DATABASE}
      POSTGRES_USER: ${POSTGRESQL_USER}
      POSTGRES_PASSWORD: ${POSTGRESQL_PASSWORD}
      POSTGRES_DB: ${POSTGRESQL_DATABASE}
      # POSTGRES_KEYCLOAK_USER: ${POSTGRESQL_KEYCLOAK_USER}
      # POSTGRES_KEYCLOAK_PASSWORD: ${POSTGRESQL_KEYCLOAK_PASSWORD}
      # POSTGRES_DB2: ${POSTGRESQL_KEYCLOAK_DATABASE}
    hostname: local
    image: postgres:12
    restart: always
    volumes:
      - /pgdata
      - ./sql/access_attempt.sql:/docker-entrypoint-initdb.d/A.sql
      - ./sql/bceid.sql:/docker-entrypoint-initdb.d/B.sql
      - ./sql/lookup_activitytype.sql:/docker-entrypoint-initdb.d/C.sql
      - ./sql/lookup_gender_pronoun.sql:/docker-entrypoint-initdb.d/D.sql
      - ./sql/client.sql:/docker-entrypoint-initdb.d/E.sql
     
    ports: 
      - "5432:5432"
    networks:
      - db-keycloak

  backend:
    container_name: backend
    entrypoint:
      - "sh"
      - "-c"
      - "npm i && npm run start"
    environment:
      NODE_ENV: development
      POSTGRESQL_HOST: ${POSTGRESQL_HOST}
      POSTGRESQL_USER: ${POSTGRESQL_USER}
      POSTGRESQL_PASSWORD: ${POSTGRESQL_PASSWORD}
      POSTGRESQL_DATABASE: ${POSTGRESQL_DATABASE}
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:3000"]
      interval: 1m30s
      timeout: 10s
      retries: 3
      start_period: 40s
    hostname: backend
    image: node:14
    links:
      - database
    ports:
      - "3001:3000"
    volumes:
      - ./backend:/app:z
      - /app/node_modules
    working_dir: "/app"

  keycloak:
    image: jboss/keycloak:13.0.1
    container_name: keycloak-service
    environment:
      DB_VENDOR: POSTGRES
      DB_ADDR: database
      DB_SCHEMA: public
      DB_DATABASE: ${POSTGRESQL_DATABASE}
      DB_USER: ${POSTGRESQL_USER}
      DB_PASSWORD: ${POSTGRESQL_PASSWORD}
      KEYCLOAK_USER:  ${POSTGRESQL_KEYCLOAK_USER}
      KEYCLOAK_PASSWORD: ${POSTGRESQL_KEYCLOAK_PASSWORD}
    ports:
      - "28080:8080"
    depends_on:
      - database
    restart: always
    links: 
      - database
    networks:
      - db-keycloak

  frontend:
    container_name: frontend
    entrypoint:
      - "sh"
      - "-c"
      - "npm i && npm run start"
    environment:
      NODE_ENV: development
      BACKEND_URL: backend
    healthcheck:
      test: ["CMD", "curl", "-f", "http://localhost:3000"]
      interval: 1m30s
      timeout: 10s
      retries: 3
      start_period: 40s
    hostname: frontend
    image: node:14
    links:
      - backend
    ports:
      - "3000:3000"
    volumes:
      - ./frontend:/app:z
      - /app/node_modules
    working_dir: "/app"

networks:
  db-keycloak:

這是錯誤：

18:05:57,142 ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool -- 69) Change Set META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final-KEYCLOAK-5461::[email protected] failed.  Error: ERROR: relation "client" already exists [Failed SQL: CREATE TABLE public.CLIENT (DTYPE VARCHAR(31) NOT NULL, ID VARCHAR(36) NOT NULL, ALLOWED_CLAIMS_MASK BIGINT, ENABLED BOOLEAN DEFAULT FALSE NOT NULL, FULL_SCOPE_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, NAME VARCHAR(255), NOT_BEFORE INT, PUBLIC_CLIENT BOOLEAN DEFAULT FALSE NOT NULL, SECRET VARCHAR(255), BASE_URL VARCHAR(255), BEARER_ONLY BOOLEAN DEFAULT FALSE NOT NULL, MANAGEMENT_URL VARCHAR(255), SURROGATE_AUTH_REQUIRED BOOLEAN DEFAULT FALSE NOT NULL, DIRECT_GRANTS_ONLY BOOLEAN DEFAULT FALSE NOT NULL, REALM_ID VARCHAR(36))]
18:05:57,142 ERROR 
[org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 69) Error has occurred while updating the database: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.0.0.Final.xml::1.0.0.Final-KEYCLOAK-5461::[email protected]:
         Reason: liquibase.exception.DatabaseException: ERROR: relation "client" already exists [Failed SQL: CREATE TABLE public.CLIENT (DTYPE VARCHAR(31) NOT NULL, ID VARCHAR(36) NOT NULL, ALLOWED_CLAIMS_MASK BIGINT, ENABLED BOOLEAN DEFAULT FALSE NOT NULL, FULL_SCOPE_ALLOWED BOOLEAN DEFAULT FALSE NOT NULL, NAME VARCHAR(255), NOT_BEFORE INT, PUBLIC_CLIENT BOOLEAN DEFAULT FALSE NOT NULL, SECRET VARCHAR(255), BASE_URL VARCHAR(255), BEARER_ONLY BOOLEAN DEFAULT FALSE NOT NULL, MANAGEMENT_URL VARCHAR(255), SURROGATE_AUTH_REQUIRED BOOLEAN DEFAULT FALSE NOT NULL, DIRECT_GRANTS_ONLY BOOLEAN DEFAULT FALSE NOT NULL, REALM_ID VARCHAR(36))]

uj5u.com熱心網友回復：

根據錯誤，您現有的 postgres 資料庫已經有名為client. 但是 Keycloak 正在嘗試創建client自己的表，這會導致此錯誤。

要解決此問題，我建議使用兩種不同的 postgres databases/schemas，一種用于您的應用程式，另一種用于 keycloak 實體。

標籤：PostgreSQL码头工人码头工人撰写钥匙斗篷

上一篇：如何將Terraform變數傳遞給.yaml檔案？

下一篇：將變數與shell中的單位后綴進行比較