molemanx
molemanx
PostsComments
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
That looks to have worked, makes sense, so no need to go into the container itself and change the password, thank you!
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
I'll let you know if it works, thanks for your help!
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Amazing thank you, whatever the cause of the issue is seems to be down to my setup in some way. I'll make that change in half hour or so, just going to get something to eat
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Maybe I can try that instead? It would at least change the password away from the default at that point
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Do you reckon the password actually changes away from postgres if I create the container, get it working, then switch the password away from default? That seems to work, but I don't know why, although I don't think I care if someone else agrees the password does actually change
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
So I really don't know what password it thinks it's grabbing 😅
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Just tried changing the password back to the default postgres after the above failed attempt, still no luck sadly. So weirdly, creating the container with 'postgres' as the password works, but creating it with a custom password fails, and switching it back to postgres still fails
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Back to failing sadly 
[Nest] 17  - 12/27/2024, 1:09:43 PM   ERROR [ExceptionHandler] password authentication failed for user "postgres"
error: password authentication failed for user "postgres"
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
microservices worker exited with code 1
Killing api process
[Nest] 17  - 12/27/2024, 1:09:43 PM   ERROR [ExceptionHandler] password authentication failed for user "postgres"
error: password authentication failed for user "postgres"
    at Parser.parseErrorMessage (/usr/src/app/node_modules/pg-protocol/dist/parser.js:283:98)
    at Parser.handlePacket (/usr/src/app/node_modules/pg-protocol/dist/parser.js:122:29)
    at Parser.parse (/usr/src/app/node_modules/pg-protocol/dist/parser.js:35:38)
    at Socket.<anonymous> (/usr/src/app/node_modules/pg-protocol/dist/index.js:11:42)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
microservices worker exited with code 1
Killing api process
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
The only files I have that I'm keeping are the ones mapped to the upload location, I don't think that should make a difference?
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Hm one second, will see if I can re-create again for good measure
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
So in my case the files at $DOCKERDIR/immich/database
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
That's correct, sorry!
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
I did wonder if that was correct, or if I should be connecting into the container and doing something else?
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Destroying all the files at /var/lib/postgresql/data
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
I'm not 100% convinced it's using the new password I placed into the compose file though
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
I have also managed to get it working by starting the stack with the default varaibles listed in the docker compose file above, then bringing the stack down and at that point swapping the default password out. For some reason, that seems to work?
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Nope, those work fine because I saw they pull from the environment variables rather than the variables from the .env
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Yeah sorry I should have been clearer, that's the working docker compose file, my aim is to remove the .env file which I've managed to do other than this small hurdle
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
Using postgres_password as that's the environment variable, DB password is pulled in from the .env which I've stripped out of the docker compose file
45 replies
IImmich
Created by molemanx on 12/27/2024 in #help-desk-support
Unable To Change Postgres Password
I've tried only letters and numbers as the documentation suggests, sadly it still fails. I've also destroyed the postgres database multiple times so it re-builds from scratch, but still no luck
45 replies