Lemmy on Docker - Postgre Authentication Fail
  • tkohhh tkohhh 1y ago 100%

    Thank you! I did figure that out as I got further along into this... so much new stuff to learn!!

    1
  • Lemmy on Docker - Postgre Authentication Fail
  • tkohhh tkohhh 1y ago 100%

    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

    1
  • Lemmy on Docker - Postgre Authentication Fail
  • tkohhh tkohhh 1y ago 100%

    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. :(

    1
  • Lemmy on Docker - Postgre Authentication Fail
  • tkohhh tkohhh 1y ago 0%

    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?

    0
  • I'm trying to get Lemmy up and running on an Ubuntu 22.04 host. I've followed [this guide](https://join-lemmy.org/docs/administration/install_docker.html) supplemented by googling. I can actually get to the front end, but it gives me "There was an error on the server." When I dig into the logs, I see this: ```` "thread 'main' panicked at 'Error connecting to postgres://lemmy:<my pg password>@postgres:5432/lemmy: FATAL: password authentication failed for user \"lemmy\"\n","stream":"stderr","time":"2023-06-26T03:14:17.47460915Z"} ```` The only thing I can find about this error related to Lemmy is [this thread](https://github.com/LemmyNet/lemmy/issues/897), which indicates that the password was not defined in the `docker-compose.yml` file prior to starting the containers. I have since redone the configuration three times, each time deleting the `volumes` folder and double-checking that my postgre password is correct both in `docker-compose.yml` and `lemmy.hjson`. Any ideas what might be the problem? Thank you kindly for any help you can provide!

    2
    12
    [Resolved] Trying to set up my own Lemmy server, but I think I'm in over my head
  • tkohhh tkohhh 1y ago 100%

    Do you mind sharing what exactly you changed in order to get it to work? I got nginx_internal.conf installed, but did not make any changes to it. I'm not able to get the UI using http://<ipaddress>:1236

    I'm not a complete newb when it comes to nginx, but I'm having a hard time understanding what all the different parts are here. For instance, what is the lemmy-ui container for? Is that what needs to be exposed for me to access the UI? If so, I don't see any port mapping the in container definition, so is it hard-coded to use a specific port?

    Any help you can provide is greatly appreciated!

    1
  • "Initials" by "Florian Körner", licensed under "CC0 1.0". / Remix of the original. - Created with dicebear.comInitialsFlorian Körnerhttps://github.com/dicebear/dicebearIN
    Interior Decorating tkohhh 1y ago 100%
    Wall-Mount Decorative Lighting

    Does anybody have any ideas for some decorative but functional lighting to go above my computer monitor? I've noticed that my image on Zoom calls is fairly dark, and I think some lighting on the wall above my monitor would help. However, the standard utilitarian webcam lighting (like the ring) aren't really what I want to be looking at all day. Any and all ideas are welcome!

    1
    0

    Is there a reason we're not Federated with [https://lemmit.online](https://lemmit.online)? I'd like to subscribe to the Home Assistant community there.

    1
    0
    A Guide to Monitor Linux Server using Prometheus and Grafana
  • tkohhh tkohhh 1y ago 100%

    Influxdb + grafana for me! Good stuff!

    1
  • is it better to use subdomains or paths?
  • tkohhh tkohhh 1y ago 100%

    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!

    1
  • is it better to use subdomains or paths?
  • tkohhh tkohhh 1y ago 100%

    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.

    3
  • Best self-hosted photos?
  • tkohhh tkohhh 1y ago 100%

    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

    4
  • Declassified report reveals that the US government is buying troves of data about its citizens
  • tkohhh tkohhh 1y ago 100%

    Tangential point: if your "smart home" can be shut down by a third party, then you aren't Smart Homing correctly.

    3
  • I would occasionally pop into the LiveSound and AudioEngineering subreddits. Is there any interest in hosting those here? They seem to fit in with the theme of this server. Just a thought!

    1
    6