Selfhosted

60526 readers

859 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Detailed Rules Post

Be civil.
No spam.
Posts are to be related to self-hosting.
Don't duplicate the full text of your blog or readme if you're providing a link.
Submission headline should match the article title.
No trolling.
Promotion posts require active participation, with an account that is at least 30 days old. F/LOSS without a paywall has exceptions, with requirements. See the rules link for details.
AI-related discussions and AI-involved promotional posts have additional requirements for tagging, as noted in Rule 7 and the AI & Promotional Post Expanded Rules post.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 3 years ago

MODERATORS

curbstickle@anarchist.nexus

curbstickle_lw@lemmy.world

Help with MariaDB root login (feddit.uk)

submitted 1 month ago by brewery@feddit.uk to c/selfhosted@lemmy.world

4 comments fedilink hide all child comments

I am switching to Databasus for backing up my databases. Postgres has been fine but on two separate mariadb databases, Databasus cannot create read only users. Everything is on docker compose on separate stacks with a bridge network backup-db between the database containers and Databasus.

I think the problem is that the normal user only has permission for the single database but not universal, so have something I can try but I can't seem to actually login to the databases with the root passwords set in .env a long time ago (along with the normal user / pw which seen to be used fine by the apps). My Nextcloud database is one of the issues. The root PW env variable is the one taken from there database documentation.

Trying to access through "docker exec -it <db_container_name> mariadb -u root -p"

I have already tried setting the -h flag as localhost, 127.0.0.1, <db_container_name> and <nextcloud_app_container_name>.

I tried changing the root PW too.

Any help would be greatly appreciated!

top 4 comments

sorted by: hot top controversial new old

[–] Zwuzelmaus@feddit.org 4 points 1 month ago

This description leaves many holes. So either someone succeeds with guessing, or you need someone to interact with you for analyzing step by step what's really going on there.

My guess is that you need to use the right user on the right system, because "env" exists only in the context of one certain user on one certain (virtual or real) system.

[–] captcha_incorrect@lemmy.world 1 points 1 month ago (1 children)

Are you trying with the correct db user? Try connecting to image with the root user for MariaDB and create a new user with permissions. I’ve had to do similar things with Postgres, connecting with the user psql with success.

[–] brewery@feddit.uk 1 points 1 month ago (1 children)

I can't seem to login to the root user on two different mariadb databases to make those changes so must be doing something wrong

[–] captcha_incorrect@lemmy.world 1 points 1 month ago

If you copy the DB file to your computer, you should be able to inspect them with some kind of viewer. Perhaps you can figure out the username/password that way?