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 psql

So 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

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?

edit: it just occurred to me that my container name is lemmy_postgres_1, not postgres as was entered in my lemmy.hjson file. Let’s see if changing that will work…

edit2: no, that had no effect. I’m getting the authentication error for user lemmy on both the lemmy container and the postgres container. :(

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?

If you’re a 1. d4 player, you need to know the Englund Gambit

For whatever my opinion is worth (I’m ~1350 blitz on lichess), if you’re finding your openings boring, then just try something new. For me, it helps to keep in mind that the goal is to have fun, NOT to maintain a certain Elo.

Influxdb + grafana for me! Good stuff!

I don’t know for sure… but my instinct is that NAT reflection is moot in that case, because your connection is going out past the edge router and doing the DNS query there, which will then direct you back to your public IP. I’m sure there’s somebody around that knows the answer for certain!

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