docker compose up access denied sql

[markdjones82]

Hey all,
Doing some testing and running docker compose locally on my machine. It is failing on connecting to the mariadb. I am using the example env file with defaults so I would think it should work. On boot of terrareg_app. Is the db password not getting setup?

2025-01-13 16:06:07 sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) 1044 (42000): Access denied for user 'terrareg'@'%' to database 'terrareg'

[markdjones82]

Update: It appears to not be respecting the ENV file. Looking a little further into it, but when I add the environment variables to the environment block on the mysql container, it works!

[markdjones82]

ah ha! typo in the EXAMPLE.env

The database is MARIABD instead of MARIADB

MySQL configurations

ALLOW_EMPTY_PASSWORD=yes
MARIABD_DATABASE=terrareg
MARIADB_USER=terrareg
MARIADB_PASSWORD=terrareg

[markdjones82]

@MatthewJohn If you want to create a gitlab issue for this or just add it to your next updates. It took me a few hours to find this little error lol

[MatthewJohn]

Thanks @markdjones82 :) I can create an issue, certainly :)

[markdjones82]

Just remembered I have access to your gitlab so I can do some of that going forward. Should I do pull requests still here on github?

[MatthewJohn]

On Gitlab, if that's okay? :)

[markdjones82]

I haven't used gitlab much. I'll give it a try for next contribution. Just opened a PR on here for a couple of them in the meantime.