[BUG] All red Xs for database with mariadb docker

[TheQwenton]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

New to setting up / using databases and new to projectsend. I am using unraid to run linuxserver's projectsend docker container. Using mariadb docker for database. I created a new database 'projectsenddb' and given user 'projectsend' full access to it. I tried to input this information to projectsend for database setup and am seeing all red x's.

Expected Behavior

Database should connect with green checks.

Steps To Reproduce

1. create database and user on maria db CREATE DATABASE projectsenddb; CREATE USER 'projectuser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON projectsend.* TO 'projectuser'@'localhost'; FLUSH PRIVILEGES;
2. Input database and user into project send
   
3. database connects when pressing check

Environment

- OS:Unraid
- How docker service was installed:CA unraid apps browser
- Linux server projectsend docker container
- MariaDB docker container

CPU architecture

x86-64

Docker creation

I cant copy paste a screenshot in here for some reason. Default settings were used to create this docker container. Only changed the data location. I will add a comment with screenshots

Container logs

I will provide a screenshot in a comment for the docker logs

[github-actions]

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

[TheQwenton]

Docker creation

Container Logs

[LinuxServer-CI]

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

[UbuntuEvangelist]

we are facing same on ubuntu 24

[j0nnymoe]

for the container, you need to be using host wildcard, not local host when creating the user: 'projectuser'@'localhost'

[LinuxServer-CI]

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

[drizuid]

as j0nny stated, OP has restricted the user to only login from mariadb itself, not from projectsend. for the tag-along user, they put localhost implying projectsend is the database, which it is not. Closing this as the solution to OP was provided but no response.