Docker-compose not working with alternative DB_PORT

wouterverduin commented 1 year ago

The bug

Hi All! Was hoping to try out Immich for my photos.

Quite familiar with docker but couldnt get it running with altered settings. I finally got it running with an unaltered docker-compose and .env file and figured out the culprit: the DB_PORT setting.

I am running multiple services on docker and the standard port of 5432 is taken. However if i alter the .env and give it another port number i get errors. From the webpage:

500: connect ECONNREFUSED 172.24.0.7:3001

Docker logs (immich_server):

[Nest] 1 - 04/04/2023, 6:13:17 AM ERROR [ExceptionHandler] connect ECONNREFUSED 172.25.0.2:5442 Error: connect ECONNREFUSED 172.25.0.2:5442

The OS that Immich Server is running on

Ubuntu 22.04

Version of Immich Server

Latest

Version of Immich Mobile App

-

Platform with the issue

[X] Server
[ ] Web
[ ] Mobile

Your docker-compose.yml content

version: "3.8"

services:
  immich-server:
    container_name: immich_server
    image: ghcr.io/immich-app/immich-server:release
    entrypoint: ["/bin/sh", "./start-server.sh"]
    volumes:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
    env_file:
      - .env
    environment:
      - NODE_ENV=production
    depends_on:
      - redis
      - database
      - typesense
    restart: always

  immich-microservices:
    container_name: immich_microservices
    image: ghcr.io/immich-app/immich-server:release
    entrypoint: ["/bin/sh", "./start-microservices.sh"]
    volumes:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
    env_file:
      - .env
    environment:
      - NODE_ENV=production
    depends_on:
      - redis
      - database
      - typesense
    restart: always

  immich-machine-learning:
    container_name: immich_machine_learning
    image: ghcr.io/immich-app/immich-machine-learning:release
    volumes:
      - ${UPLOAD_LOCATION}:/usr/src/app/upload
      - model-cache:/cache
    env_file:
      - .env
    environment:
      - NODE_ENV=production
    restart: always

  immich-web:
    container_name: immich_web
    image: ghcr.io/immich-app/immich-web:release
    entrypoint: ["/bin/sh", "./entrypoint.sh"]
    env_file:
      - .env
    restart: always

  typesense:
    container_name: immich_typesense
    image: typesense/typesense:0.24.0
    environment:
      - TYPESENSE_API_KEY=${TYPESENSE_API_KEY}
      - TYPESENSE_DATA_DIR=/data
    logging:
      driver: none
    volumes:
      - tsdata:/data
    restart: always

  redis:
    container_name: immich_redis
    image: redis:6.2
    restart: always

  database:
    container_name: immich_postgres
    image: postgres:14
    env_file:
      - .env
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      PG_DATA: /var/lib/postgresql/data
    volumes:
      - ./pgdata:/var/lib/postgresql/data
    restart: always
  immich-proxy:
    container_name: immich_proxy
    image: ghcr.io/immich-app/immich-proxy:release
    environment:
      # Make sure these values get passed through from the env file
      - IMMICH_SERVER_URL
      - IMMICH_WEB_URL
    ports:
      - 2283:8080
    logging:
      driver: none
    depends_on:
      - immich-server
    restart: always

volumes:
  pgdata:
  model-cache:
  tsdata:

Your .env content

###################################################################################
# Database
###################################################################################

DB_HOSTNAME=immich_postgres
DB_USERNAME=postgres
DB_PASSWORD=postgres
DB_DATABASE_NAME=immich

# Optional Database settings:
# DB_PORT=5432
DB_PORT=5442

###################################################################################
# Redis
###################################################################################

REDIS_HOSTNAME=immich_redis

# Optional Redis settings:

# Note: these parameters are not automatically passed to the Redis Container
# to do so, please edit the docker-compose.yml file as well. Redis is not configured
# via environment variables, only redis.conf or the command line

# REDIS_PORT=6379
# REDIS_DBINDEX=0
# REDIS_PASSWORD=
# REDIS_SOCKET=

###################################################################################
# Upload File Location
#
# This is the location where uploaded files are stored.
###################################################################################

UPLOAD_LOCATION=/MEDIA/Immich

###################################################################################
# Typesense
###################################################################################
TYPESENSE_API_KEY=some-random-text
# TYPESENSE_ENABLED=false

###################################################################################
# Reverse Geocoding
#
# Reverse geocoding is done locally which has a small impact on memory usage
# This memory usage can be altered by changing the REVERSE_GEOCODING_PRECISION variable
# This ranges from 0-3 with 3 being the most precise
# 3 - Cities > 500 population: ~200MB RAM
# 2 - Cities > 1000 population: ~150MB RAM
# 1 - Cities > 5000 population: ~80MB RAM
# 0 - Cities > 15000 population: ~40MB RAM
####################################################################################

# DISABLE_REVERSE_GEOCODING=false
# REVERSE_GEOCODING_PRECISION=3

####################################################################################
# WEB - Optional
#
# Custom message on the login page, should be written in HTML form.
# For example:
# PUBLIC_LOGIN_PAGE_MESSAGE="This is a demo instance of Immich.<br><br>Email: <i>demo@demo.de</i><br>Password: <i>demo</i>"
####################################################################################

PUBLIC_LOGIN_PAGE_MESSAGE=

####################################################################################
# Alternative Service Addresses - Optional
#
# This is an advanced feature for users who may be running their immich services on different hosts.
# It will not change which address or port that services bind to within their containers, but it will change where other services look for their peers.
# Note: immich-microservices is bound to 3002, but no references are made
####################################################################################

IMMICH_WEB_URL=http://immich-web:3000
IMMICH_SERVER_URL=http://immich-server:3001
IMMICH_MACHINE_LEARNING_URL=http://immich-machine-learning:3003

####################################################################################
# Alternative API's External Address - Optional
#
# This is an advanced feature used to control the public server endpoint returned to clients during Well-known discovery.
# You should only use this if you want mobile apps to access the immich API over a custom URL. Do not include trailing slash.
# NOTE: At this time, the web app will not be affected by this setting and will continue to use the relative path: /api
# Examples: http://localhost:3001, http://immich-api.example.com, etc
####################################################################################

#IMMICH_API_URL_EXTERNAL=http://localhost:3001

Reproduction steps

1. Download docker-compose.yml and .env
2. Alter port to anything (DB_PORT=5442 for example)
3. Docker-compose up -d
4. Check localip:2283 and receiver error

Additional information

No response

samip5 commented 1 year ago

If you want to change the postgres container port, you also need to make sure it actually binds to the port you specify. It also shouldn't matter as if it's not exposed outside docker, it should work with the default DB_PORT.

wouterverduin commented 1 year ago

Thanks for the reply!

I noticed that indeed it didnst bind to that port. But even if i alter the docker-compose.yml to redirect port 5442:5432 i get the similar error.

[Nest] 1 - 04/04/2023, 9:39:01 AM ERROR [ExceptionHandler] connect ECONNREFUSED 172.26.0.5:5442 Error: connect ECONNREFUSED 172.26.0.5:5442

Docker: postgres:14 "docker-entrypoint.s…" 2 minutes ago Up 2 minutes 0.0.0.0:5442->5432/tcp, :::5442->5432/tcp immich_postgres

Any tips and directions are well appreciated!

samip5 commented 1 year ago

Thanks for the reply!

I noticed that indeed it didnst bind to that port. But even if i alter the docker-compose.yml to redirect port 5442:5432 i get the similar error.

[Nest] 1 - 04/04/2023, 9:39:01 AM ERROR [ExceptionHandler] connect ECONNREFUSED 172.26.0.5:5442 Error: connect ECONNREFUSED 172.26.0.5:5442

Docker: postgres:14 "docker-entrypoint.s…" 2 minutes ago Up 2 minutes 0.0.0.0:5442->5432/tcp, :::5442->5432/tcp immich_postgres

Any tips and directions are well appreciated!

Inside Docker doesn't use those exposed ports, so again it doesn't matter. You still need to actually tell it to bind differently for it to work and the defaults should be perfectly fine as is even if you have multiple containers running that already "uses" the port (as long as it's not actually exposed, it doesn't matter).

I think you're misunderstanding how container networking works in Docker.

immich-app / immich