CyberSocialist
CyberSocialist
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
Or some other placeholder url if this is never to be internet-facing? (Say accessed over a vpn, for example)
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
So question around that: is the host name supposed to match the local IP, or the globally reachable URL that will be on the letsencrypt certificate ?
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
dozzzle shows it as fine
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
ok - we're getting there... now I'm seeing this from the 'immich_microservices' container. Anyone any thoughts?

immich_microservices | Error: connect ETIMEDOUT
immich_microservices | at Socket.<anonymous> (/usr/src/app/node_modules/ioredis/built/Redis.js:170:41)
immich_microservices | at Object.onceWrapper (node:events:628:28)
immich_microservices | at Socket.emit (node:events:514:28)
immich_microservices | at Socket._onTimeout (node:net:571:8)
immich_microservices | at listOnTimeout (node:internal/timers:569:17)
immich_microservices | at process.processTimers (node:internal/timers:512:7) {
immich_microservices | errorno: 'ETIMEDOUT',
immich_microservices | code: 'ETIMEDOUT',
immich_microservices | syscall: 'connect'

immich_microservices | Error: connect ETIMEDOUT
immich_microservices | at Socket.<anonymous> (/usr/src/app/node_modules/ioredis/built/Redis.js:170:41)
immich_microservices | at Object.onceWrapper (node:events:628:28)
immich_microservices | at Socket.emit (node:events:514:28)
immich_microservices | at Socket._onTimeout (node:net:571:8)
immich_microservices | at listOnTimeout (node:internal/timers:569:17)
immich_microservices | at process.processTimers (node:internal/timers:512:7) {
immich_microservices | errorno: 'ETIMEDOUT',
immich_microservices | code: 'ETIMEDOUT',
immich_microservices | syscall: 'connect'
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
Quick question: where is that documented? It seems that containers do this differently, and it’s never really clear…did I miss this ?
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
Ah. Ok. So I need to move it back then, I’ll try that.
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
Does it not follow paths?
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
No. But it’s path is correct .
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
thank you
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
wow that is nicer!
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
(and yeah, I bet it will be!)
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
oh - how do I do that?
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
(please excuse the formatting nightmare - is there a better way of sharing the compose and env?)
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database


# The location where your uploaded files are stored
UPLOAD_LOCATION=/home/admin/Docker/immich/upload


# The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=release

# Connection secrets for postgres and typesense. You should change these to random passwords
TYPESENSE_API_KEY=xxxxxxxxxxxxx!xxxxxxxxxxxx
DB_PASSWORD=postgres

# The values below this line do not need to be changed
###################################################################################
DB_HOSTNAME=immich_postgres
DB_USERNAME=postgres
DB_DATABASE_NAME=immich

REDIS_HOSTNAME=immich_redis

PUBLIC_LOGIN_PAGE_MESSAGE=Welcome to my album
IMMICH_WEB_URL=http://immich-web:3000
IMMICH_SERVER_URL=http://immich-server:3001
IMMICH_MACHINE_LEARNING_URL=http://immich-machine-learning:3003


# The location where your uploaded files are stored
UPLOAD_LOCATION=/home/admin/Docker/immich/upload


# The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=release

# Connection secrets for postgres and typesense. You should change these to random passwords
TYPESENSE_API_KEY=xxxxxxxxxxxxx!xxxxxxxxxxxx
DB_PASSWORD=postgres

# The values below this line do not need to be changed
###################################################################################
DB_HOSTNAME=immich_postgres
DB_USERNAME=postgres
DB_DATABASE_NAME=immich

REDIS_HOSTNAME=immich_redis

PUBLIC_LOGIN_PAGE_MESSAGE=Welcome to my album
IMMICH_WEB_URL=http://immich-web:3000
IMMICH_SERVER_URL=http://immich-server:3001
IMMICH_MACHINE_LEARNING_URL=http://immich-machine-learning:3003
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database

immich-machine-learning:
container_name: immich_machine_learning
image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
volumes:
- "/home/admin/Docker/immich/model-cache/:/cache"
env_file:
- "/home/admin/Docker/immich/env/.env"
restart: always

immich-web:
container_name: immich_web
image: ghcr.io/immich-app/immich-web:${IMMICH_VERSION:-release}
env_file:
- "/home/admin/Docker/immich/env/.env"
restart: always

typesense:
container_name: immich_typesense
image: typesense/typesense:0.24.1@sha256:9bcff2b829f12074426ca044b56160ca9d777a0c488303469143dd9f8259d4dd
environment:
- TYPESENSE_API_KEY=${TYPESENSE_API_KEY}
- TYPESENSE_DATA_DIR=/data
# remove this to get debug messages
- GLOG_minloglevel=1
volumes:
- "/home/admin/Docker/immich/tsdata/:/data"
restart: always

immich_redis: #redis
container_name: immich_redis
image: redis:6.2-alpine@sha256:70a7a5b641117670beae0d80658430853896b5ef269ccf00d1827427e3263fa3
restart: always

immich_postgres: #database
container_name: immich_postgres
image: postgres:14-alpine@sha256:28407a9961e76f2d285dc6991e8e48893503cc3836a4755bbc2d40bcc272a441
env_file:
- "/home/admin/Docker/immich/env/.env"
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
volumes:
- "/home/admin/Docker/immich/pgdata/:/var/lib/postgresql/data"
restart: always

immich-proxy:
container_name: immich_proxy
image: ghcr.io/immich-app/immich-proxy:${IMMICH_VERSION:-release}
environment:
# Make sure these values get passed through from the env file
- IMMICH_SERVER_URL
- IMMICH_WEB_URL
ports:
- 2283:8080
depends_on:
- immich-server
- immich-web
restart: always

#volumes:
# pgdata:
# model-cache:
# tsdata:

immich-machine-learning:
container_name: immich_machine_learning
image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
volumes:
- "/home/admin/Docker/immich/model-cache/:/cache"
env_file:
- "/home/admin/Docker/immich/env/.env"
restart: always

immich-web:
container_name: immich_web
image: ghcr.io/immich-app/immich-web:${IMMICH_VERSION:-release}
env_file:
- "/home/admin/Docker/immich/env/.env"
restart: always

typesense:
container_name: immich_typesense
image: typesense/typesense:0.24.1@sha256:9bcff2b829f12074426ca044b56160ca9d777a0c488303469143dd9f8259d4dd
environment:
- TYPESENSE_API_KEY=${TYPESENSE_API_KEY}
- TYPESENSE_DATA_DIR=/data
# remove this to get debug messages
- GLOG_minloglevel=1
volumes:
- "/home/admin/Docker/immich/tsdata/:/data"
restart: always

immich_redis: #redis
container_name: immich_redis
image: redis:6.2-alpine@sha256:70a7a5b641117670beae0d80658430853896b5ef269ccf00d1827427e3263fa3
restart: always

immich_postgres: #database
container_name: immich_postgres
image: postgres:14-alpine@sha256:28407a9961e76f2d285dc6991e8e48893503cc3836a4755bbc2d40bcc272a441
env_file:
- "/home/admin/Docker/immich/env/.env"
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
volumes:
- "/home/admin/Docker/immich/pgdata/:/var/lib/postgresql/data"
restart: always

immich-proxy:
container_name: immich_proxy
image: ghcr.io/immich-app/immich-proxy:${IMMICH_VERSION:-release}
environment:
# Make sure these values get passed through from the env file
- IMMICH_SERVER_URL
- IMMICH_WEB_URL
ports:
- 2283:8080
depends_on:
- immich-server
- immich-web
restart: always

#volumes:
# pgdata:
# model-cache:
# tsdata:
```
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database

version: "3.8"

services:
immich-server:
container_name: immich_server
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
command: [ "start.sh", "immich" ]
volumes:
- ${UPLOAD_LOCATION}/:/usr/src/app/upload
env_file:
- /home/admin/Docker/immich/env/.env
depends_on:
- immich_redis
- immich_postgres
- typesense
restart: always

immich-microservices:
container_name: immich_microservices
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
# extends:
# file: hwaccel.yml
# service: hwaccel
command: [ "start.sh", "microservices" ]
volumes:
- ${UPLOAD_LOCATION}/:/usr/src/app/upload
env_file:
- "/home/admin/Docker/immich/env/.env" #in the immich bind mount folder "/immich/env"
depends_on:
- immich_redis
- immich_postgres
- typesense
restart: always

version: "3.8"

services:
immich-server:
container_name: immich_server
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
command: [ "start.sh", "immich" ]
volumes:
- ${UPLOAD_LOCATION}/:/usr/src/app/upload
env_file:
- /home/admin/Docker/immich/env/.env
depends_on:
- immich_redis
- immich_postgres
- typesense
restart: always

immich-microservices:
container_name: immich_microservices
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
# extends:
# file: hwaccel.yml
# service: hwaccel
command: [ "start.sh", "microservices" ]
volumes:
- ${UPLOAD_LOCATION}/:/usr/src/app/upload
env_file:
- "/home/admin/Docker/immich/env/.env" #in the immich bind mount folder "/immich/env"
depends_on:
- immich_redis
- immich_postgres
- typesense
restart: always
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
(I can - but the character limits will wreck it)
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
yes - except for one thing: I've changed the name for the container 'database' to 'immich_postgres' - but I've made sure (i think) that that name change is reflected everywhere else that 'database' was referenced. Unless this is a hard coded variable?
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
brand new
37 replies
IImmich
Created by CyberSocialist on 8/20/2023 in #help-desk-support
ERROR [TypeOrmModule] Unable to connect to the database
(might be useful to note that the pgdata folder also seems to have its owner remapped to '70' and not the user that the container is started as....that an issue?)
37 replies