Need Help Install Power-Tools

[kaylopez1962]

I have attempted to install Power-Tools and I am getting the following message:

Database connection failed getaddrinfo ENOTFOUND "immich-postgres"

How do I find the correct value to enter into the .env file? I have tried "datebase", the IP address of my Immich install. No luck. Please help.

Thank you so much!

[iolaire]

Look at your docker compose in the settings for the database, does it have a container_name? If so use that. For example in this sample of my docker compose I have "container_name: immich_postgres"

name: immich

services:
.. other items removed ..
  database:
    container_name: immich_postgres
    image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
    environment:
      POSTGRES_PASSWORD: ${DB_PASSWORD}
      POSTGRES_USER: ${DB_USERNAME}
      POSTGRES_DB: ${DB_DATABASE_NAME}
      POSTGRES_INITDB_ARGS: '--data-checksums'
    volumes:
      # Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
      - ${DB_DATA_LOCATION}:/var/lib/postgresql/data

[NightHawkATL]

I am running into the same issue:

This is the only thing showing in the logs:

Here is the compose for postgres:

Here is the power tools compose:

[kaylopez1962]

I have tried the suggested solution and I am still getting the same error message.

[iolaire]

You are probably already doing it but have you stopped and re-loaded the docker compose for both power tools and immich? i.e.

docker compose stop
docker  compose up -d

[NightHawkATL]

I just restarted my whole immich stack and get the same error.

[iolaire]

My only other suggestion is to read through the logs on the power tools docker instance to see if those show anything.

[NightHawkATL]

My only other suggestion is to read through the logs on the power tools docker instance to see if those show anything.

This is all the docker logs show.

[varun-raj]

Hi, Can you check if immich db and power tools are in the same docker network?

[NightHawkATL]

I have all my Immich stuff in a single stack so they will all be on the same docker network. Simplifies communications most times..

[varun-raj]

@NightHawkATL can you try changing the hypen in your immich url to underscore?

immich-server -> immich_server

[NightHawkATL]

Here is the latest with the updated changes.

[satmandu]

I finally got this to work.

This is what I added for just power-tools in my docker-compose.yml:

  # Other services...
  power-tools:
    container_name: immich_power_tools
    image: ghcr.io/varun-raj/immich-power-tools:latest
    networks:
      - immich_network
    environment:
      DB_HOST: immich_postgres
      DB_PORT: 5432
      IMMICH_URL: "http://immich_server:2283"
    ports:
      - "8001:3000"
    env_file:
      - .env

I also added this at the bottom of my docker-compose.yml:

networks:
  immich_network:
    driver: bridge

Additionally, I made sure that every service in docker-compose.yml also had this:

networks:
      - immich_network

[jamess60]

+1, getting the same issue. My config is identical to @NightHawkATL

[naamah75]

+1, getting the same issue. Any solution?

[pchresta]

Try removing the " " and also remove the whitepsaces from the environment like this:

IMMICH_URL= IMMICH_API_KEY= DB_USERNAME= DB_PASSWORD= DB_HOST= DB_PORT= DB_DATABASE_NAME=

[naamah75]

This is my solution for installing on TrueNAS:

networks:
  immich-network:
    external: True
    name: ix-immich_default
services:
  immich-power-tools:
    environment:
      DB_DATABASE_NAME: immich
      DB_HOST: ix-immich-pgvecto-1
      DB_PASSWORD: ****
      DB_PORT: '5432'
      DB_USERNAME: immich
      EXTERNAL_IMMICH_URL: http://****:2283
      GEMINI_API_KEY: ****
      GOOGLE_MAPS_API_KEY: ****
      IMMICH_API_KEY: ****
      IMMICH_URL: http://****:30041
      SECURE_COOKIE: 'true'
    image: ghcr.io/varun-raj/immich-power-tools:latest
    networks:
      - immich-network
    ports:
      - '30042:3000'
    restart: unless-stopped