connect: connection refused with modified Docker compose file

[DesertCookie]

Having followed the instructions for set up with Docker compose here I now face this error from the lobe-casdoor container: panic: dial tcp 172.19.0.2:5439: connect: connection refused.

172.19.0.2 is the internal IP address of the lobe-postgres container. I had to change some ports (5432->5439, 9001->9009) since some ports were already in use by other containers. I did a simple CTRL+F search in nano within the .env and docker-compose.yml files.

Here they are for full context:

# Proxy, if you need it
# HTTP_PROXY=http://localhost:7890
# HTTPS_PROXY=http://localhost:7890


# Other environment variables, as needed. You can refer to the environment variables configuration for the client v> 7 # OPENAI_API_KEY=sk-xxxx
# OPENAI_PROXY_URL=https://api.openai.com/v1
# OPENAI_MODEL_LIST=...


# ===========================
# ====== Preset config ======
# ===========================
# if no special requirements, no need to change
LOBE_PORT=3210
CASDOOR_PORT=8004
MINIO_PORT=9000
APP_URL=http://MY_MACHINE_IP:3210
AUTH_URL=http://MY_MACHINE_IP:3210/api/auth

# Postgres related, which are the necessary environment variables for DB
LOBE_DB_NAME=lobechat
POSTGRES_PASSWORD=REDACTED

AUTH_CASDOOR_ISSUER=http://MY_MACHINE_IP:8004
# Casdoor secret
AUTH_CASDOOR_ID=REDACTED
AUTH_CASDOOR_SECRET=REDACTED

# MinIO S3 configuration
MINIO_ROOT_USER=admin
MINIO_ROOT_PASSWORD=REDACTED

# Configure the bucket information of MinIO
S3_PUBLIC_DOMAIN=http://MY_MACHINE_IP:9000
S3_ENDPOINT=http://MY_MACHINE_IP:9000
MINIO_LOBE_BUCKET=lobe

# Configure for casdoor
origin=http://MY_MACHINE_IP:8004

name: lobe-chat-database
services:
  network-service:
    image: alpine
    container_name: lobe-network
    restart: always
    ports:
      - '${MINIO_PORT}:${MINIO_PORT}' # MinIO API
      - '9009:9001' # MinIO Console
      - '${CASDOOR_PORT}:${CASDOOR_PORT}' # Casdoor
      - '${LOBE_PORT}:3210' # LobeChat
    command: tail -f /dev/null
    networks:
      - lobe-network

  postgresql:
    image: pgvector/pgvector:pg17
    container_name: lobe-postgres
    ports:
      - '5439:5432'
    volumes:
      - './data:/var/lib/postgresql/data'
    environment:
      - 'POSTGRES_DB=${LOBE_DB_NAME}'
      - 'POSTGRES_PASSWORD=${POSTGRES_PASSWORD}'
    healthcheck:
      test: ['CMD-SHELL', 'pg_isready -U postgres']
      interval: 5s
      timeout: 5s
      retries: 5
    restart: always
    networks:
      - lobe-network

  minio:
    image: minio/minio
    container_name: lobe-minio
    network_mode: 'service:network-service'
    volumes:
      - './s3_data:/etc/minio/data'
    environment:
      - 'MINIO_API_CORS_ALLOW_ORIGIN=*'
    env_file:
      - .env
    restart: always
    entrypoint: >
      /bin/sh -c "
        minio server /etc/minio/data --address ':${MINIO_PORT}' --console-address ':9009' &
        MINIO_PID=\$!
        while ! curl -s http://localhost:${MINIO_PORT}/minio/health/live; do
          echo 'Waiting for MinIO to start...'
          sleep 1
        done
        sleep 5
        mc alias set myminio http://localhost:${MINIO_PORT} ${MINIO_ROOT_USER} ${MINIO_ROOT_PASSWORD}
        echo 'Creating bucket ${MINIO_LOBE_BUCKET}'
        mc mb myminio/${MINIO_LOBE_BUCKET}
        wait \$MINIO_PID
      "

# version lock ref: https://github.com/lobehub/lobe-chat/pull/7331
  casdoor:
    image: casbin/casdoor:v1.843.0
    container_name: lobe-casdoor
    entrypoint: /bin/sh -c './server --createDatabase=true'
    network_mode: 'service:network-service'
    depends_on:
      postgresql:
        condition: service_healthy
    environment:
      httpport: ${CASDOOR_PORT}
      RUNNING_IN_DOCKER: 'true'
      driverName: 'postgres'
      dataSourceName: 'user=postgres password=${POSTGRES_PASSWORD} host=postgresql port=5439 sslmode=disable dbnam> 75       runmode: 'dev'
    volumes:
      - ./init_data.json:/init_data.json
    env_file:
      - .env
   lobe:
    image: lobehub/lobe-chat-database
    container_name: lobe-chat
    network_mode: 'service:network-service'
    depends_on:
      postgresql:
        condition: service_healthy
      network-service:
        condition: service_started
      minio:
        condition: service_started
      casdoor:
        condition: service_started

    environment:
      - 'NEXT_AUTH_SSO_PROVIDERS=casdoor'
      - 'KEY_VAULTS_SECRET=Kix2wcUONd4CX51E/ZPAd36BqM4wzJgKjPtz2sGztqQ='
      - 'NEXT_AUTH_SECRET=NX2kaPE923dt6BL2U8e9oSre5RfoT7hg'
      - 'DATABASE_URL=postgresql://postgres:${POSTGRES_PASSWORD}@postgresql:5439/${LOBE_DB_NAME}'
      - 'S3_BUCKET=${MINIO_LOBE_BUCKET}'
      - 'S3_ENABLE_PATH_STYLE=1'
      - 'S3_ACCESS_KEY=${MINIO_ROOT_USER}'
      - 'S3_ACCESS_KEY_ID=${MINIO_ROOT_USER}'
      - 'S3_SECRET_ACCESS_KEY=${MINIO_ROOT_PASSWORD}'
      - 'LLM_VISION_IMAGE_USE_BASE64=1'
      - 'S3_SET_ACL=0'
      - 'SEARXNG_URL=http://searxng:8080'
    env_file:
      - .env
    restart: always
    entrypoint: >
      /bin/sh -c "
        /bin/node /app/startServer.js &
        LOBE_PID=\$!
        sleep 3
        if [ $(wget --timeout=5 --spider --server-response ${AUTH_CASDOOR_ISSUER}/.well-known/openid-configuration>130           echo ' ^z   ^oWarning: Unable to fetch OIDC configuration from Casdoor'
          echo 'Request URL: ${AUTH_CASDOOR_ISSUER}/.well-known/openid-configuration'
          echo 'Read more at: https://lobehub.com/docs/self-hosting/server-database/docker-compose#necessary-confi>133           echo ''
          echo ' ^z   ^o    ^d^o  ^z ^w   ^u  ^n Casdoor  ^n  ^o^v OIDC  ^e^m   '
          echo '     ^b URL: ${AUTH_CASDOOR_ISSUER}/.well-known/openid-configuration'                              136           echo '  ^f    ^{   ^z  ^zhttps://lobehub.com/zh/docs/self-hosting/server-database/docker-compose#necessa>137           echo ''
        else
          if ! wget -O - --timeout=5 ${AUTH_CASDOOR_ISSUER}/.well-known/openid-configuration 2>&1 | grep 'issuer' >140             printf ' ^}^lError: The Auth issuer is conflict, Issuer in OIDC configuration is: %s' \$(wget -O - --t>141             echo ' , but the issuer in .env file is: ${AUTH_CASDOOR_ISSUER} '
            echo 'Request URL: ${AUTH_CASDOOR_ISSUER}/.well-known/openid-configuration'
            echo 'Read more at: https://lobehub.com/docs/self-hosting/server-database/docker-compose#necessary-con>144             echo ''
            printf ' ^}^l ^t^y     ^zAuth  ^z^d issuer  ^f   ^a  ^lOIDC  ^e^m       ^z^d issuer  ^x   ^z%s' \$(wge>146             echo ' ,   ^f .env  ^v^g       ^z^d issuer  ^x   ^z${AUTH_CASDOOR_ISSUER} '
            echo '     ^b URL: ${AUTH_CASDOOR_ISSUER}/.well-known/openid-configuration'
            echo '  ^f    ^{   ^z  ^zhttps://lobehub.com/zh/docs/self-hosting/server-database/docker-compose#neces>149             echo ''
          fi
        fi
        if [ $(wget --timeout=5 --spider --server-response ${S3_ENDPOINT}/minio/health/live 2>&1 | grep -c 'HTTP/1>153           echo ' ^z   ^oWarning: Unable to fetch MinIO health status'
          echo 'Request URL: ${S3_ENDPOINT}/minio/health/live'
          echo 'Read more at: https://lobehub.com/docs/self-hosting/server-database/docker-compose#necessary-confi>156           echo ''
          echo ' ^z   ^o    ^d^o  ^z ^w   ^u ^n  ^o^v MinIO  ^a     ^j  ^`^a'
          echo '     ^b URL: ${S3_ENDPOINT}/minio/health/live'
          echo '  ^f    ^{   ^z  ^zhttps://lobehub.com/zh/docs/self-hosting/server-database/docker-compose#necessa>160           echo ''
        fi
        wait \$LOBE_PID
      "

volumes:
  data:
    driver: local
  s3_data:
    driver: local

networks:
  lobe-network:
    driver: bridge

My system:

• Raspberry Pi 5 8 GB
• PiKVM OS running Docker 28.1.1
• 240 GB LUKS-encrypted BTRFS SSD via USB3.0

[dosubot[bot]]

Hi @DesertCookie! I'm Dosu and I’m helping the lobe-chat team.

The issue is that your Casdoor and Lobe Chat containers are trying to connect to Postgres on port 5439, but inside Docker, Postgres is only listening on its default internal port 5432. The port mapping '5439:5432' only affects host-to-container access, not container-to-container communication. For services talking to each other inside Docker, always use the internal port (5432) in your connection strings and environment variables, not the mapped host port.

To fix this, update all references to the Postgres port in your Docker Compose and environment files (especially Casdoor's dataSourceName and Lobe Chat's DATABASE_URL) to use port 5432, not 5439. You can keep the external mapping as '5439:5432' if you need to avoid conflicts on your host, but all internal service-to-service connections must use 5432. This is the standard and expected setup for Lobe Chat and Casdoor in Docker Compose (example).

After making these changes, restart your Docker Compose stack. If you still see issues, check the logs for the Postgres, Casdoor, and Lobe Chat containers to confirm everything is healthy and using the correct ports.

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}