Cannot get new instance to connect to database
Very strange behavior going on with a new install of immich on a new server instance. The host is Truenas Scale EE. I am setting this up as a docker compose and env file. I get the same behavior with using a custom yaml install, portainer, komodo or docker compose up -d from a shell. Each time, the instance will deploy and run, but no matter what, I cannot get the server to connect to the database. I am using the exact same config from another truenas scale EE install deployed through Komodo. I’m not sure what I’m missing here. I original started with not having the DB_HOSTNAME, DB_URI, etc set in the .env file, but then tried to add those manually to force the instance to look for each of those containers. Additionally, I’ve deleted all of the directories and re-deployed and forced to re-pull images to no avail.
13 Replies
:wave: Hey @octotron15,
Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:.
References
- Container Logs:
docker compose logs docs
- Container Status: docker ps -a docs
- Reverse Proxy: https://immich.app/docs/administration/reverse-proxy
- Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJAChecklist
I have...
1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: read applicable release notes.
3. :ballot_box_with_check: reviewed the FAQs for known issues.
4. :ballot_box_with_check: reviewed Github for known issues.
5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: uploaded the relevant information (see below).
7. :ballot_box_with_check: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable
(an item can be marked as "complete" by reacting with the appropriate number)
Information
In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:
- Your docker-compose.yml and .env files.
- Logs from all the containers and their status (see above).
- All the troubleshooting steps you've tried so far.
- Any recent changes you've made to Immich or your system.
- Details about your system (both software/OS and hardware).
- Details about your storage (filesystems, type of disks, output of commands like
fdisk -l and df -h).
- The version of the Immich server, mobile app, and other relevant pieces.
- Any other information that you think might be relevant.
Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)
If this ticket can be closed you can use the /close command, and re-open it later if needed.GitHub
immich-app immich · Discussions
Explore the GitHub Discussions forum for immich-app immich. Discuss code, ask questions & collaborate with the developer community.
FAQ | Immich
User
GitHub
Issues · immich-app/immich
High performance self-hosted photo and video management solution. - Issues · immich-app/immich
Successfully submitted, a tag has been added to inform contributors. :white_check_mark:
You may want to post this question in #truenas
Thanks, I'll post it there as well
Can you connect to the Database outside of immich?
I’m having this issue as well but on unraid
the exact same issue? i would verify that you can connect to the DB outside of immich
I’m not at my pc to 100% check it’s the exact same errors but I remember it being an db connection issue
That and I’m new to immich and not sure how to check that
If the db is up, and you can connect with something like PGadmin thats good, means the server probably has the wrong password or something. I hate to say it but if you are not sure about how to check some of these thing it might be a steep learning curve to troubleshoot this.
oh wait, i just looked at the env file that OP uploaded and the db looks like its on the host network? is that correct? I think it should be in the docker network
this part seems wrong
DB_URL=192.168.20.111
Also from the docs, db_url string is formatted wrong..?
Environment Variables | Immich
To change environment variables, you must recreate the Immich containers.
I have an update on this. When using the .env file, it appears that the pgvector container isn't pulling the variables for name, username, password etc. from the .env file, but the rest of the containers are. I was able to get it to set up and running by manually entering the database details in this section of the stack. It doesn't make much sense to me. The .env file is accessible to each container in the same directory.
env_file:
- .env
environment:
POSTGRES_DB: immich
POSTGRES_INITDB_ARGS: '--data-checksums'
POSTGRES_PASSWORD: xxxxxxxxxxx
POSTGRES_USER: postgres
Thanks for the direction on the database URL. I'll also look at checking into changing that.