I installed NextCloud previously and it sucked. Most of it, in my mind was down to how slow and clunky it felt. I came here and people said the default installation can be like that, so I kinda just left things alone, determined that I would eventually come back and sort things.

Fast forward to now and my system has matured enough, well at least enough that I’ve installed Postgres and can access it via Adminer.

So I clear out all my directories, delete the container and decide it’s time to reinstall NextCloud. Simple right? Wrong! It’s telling me that I have the wrong username and password.

I asked for some help and someone said, don’t give any app default access and that’s fair and then they pointed me to the docs. The docs said to do some shit I didn’t understand really. But from what I could gather, essentially open the console and run a command.

Problem! Every time I try and open the console for the container, it says it can’t read the image details. Okay, let’s work around that then. I open up Adminer and via SQL command run:

CREATE USER nextcloud WITH PASSWORD 'R4ND0MP4SS' CREATEDB;
CREATE DATABASE nextcloud TEMPLATE template0 ENCODING 'UTF8';
ALTER DATABASE nextcloud OWNER TO nextcloud;
GRANT ALL PRIVILEGES ON DATABASE nextcloud TO nextcloud;
GRANT ALL PRIVILEGES ON SCHEMA public TO nextcloud;

I actually manage to log into Adminer with said details. NextCloud on the other hand is telling me that the username and/or password is incorrect. What am I doing wrong?

  • krolden@lemmy.ml
    link
    fedilink
    arrow-up
    2
    ·
    9 months ago

    Yes nextcloud requires the entire database. You could try moving all of your bind mounted dirs to a single dir for the entire compose stack so you dont mix it up with other postgresql containers you may use in the future. So like /opt/nextcloud/db/data:/var/lib/postgresql/data

    Personally I like to use volumes for databases.

    • sabreW4K3OP
      link
      fedilink
      arrow-up
      1
      ·
      9 months ago

      I really need to thank you. Truly I learned so much from you and I’m extremely grateful. My database works properly now. Thank you!