Thank you for enlightening me on the -W option in psql. I have successfully logged in using the expected password for lemmy. This points to something with the connection string. According to the error log, the connection string being used is:
postgres://lemmy:<my percent-encoded password>@postgres:5432/lemmy
As far as I can tell, the percent encoding is correct. Any ideas how to troubleshoot this further?
Frustratingly, when you use psql on the terminal, it does not prompt you for a password. So I’m still not sure if the password works or not :(
Ahh, ok… if you add the -W option when logging in to psql (psql -U lemmy -W), it will prompt for the password.
The password works! So, apparently it’s something with the connection string.
Username definitely matches!
And yes, I have several special characters, but the password is surrounded by single quotes in docker-compose.yml, so that should not matter, right?
Influxdb + grafana for me! Good stuff!
If your router has NAT reflection, then the problem you describe is non existent. I use the same domain/protocol both inside and outside my network.
I like Photostructure as a way to browse my photos. It does logical deduping, and automatic organization of your photos (if you want it to). Like some others mentioned in this thread, it’s a very young software, but the developer is very active and transparent about the progress.
Edit to add link: photostructure.com
This makes sense, and I do have a dollar sign in my password…
However, I have confirmed that postgres does in fact parse the password correctly, as I can log in with the defined username/password combo directly using
psqlSo I think that disproves this theory, doesn’t it?
edit: I tried getting rid of the dollar sign just in case… unfortunately I’m still getting the same error