linuxserver / docker-projectsend

GNU General Public License v3.0
74 stars 26 forks source link

[BUG] All red Xs for database with mariadb docker #46

Open TheQwenton opened 2 months ago

TheQwenton commented 2 months ago

Is there an existing issue for this?

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 image
  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[bot] commented 2 months ago

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

TheQwenton commented 2 months ago

Docker creation image

Container Logs image

LinuxServer-CI commented 1 month ago

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 commented 2 weeks ago

we are facing same on ubuntu 24

Screenshot from 2024-11-07 04-20-04

j0nnymoe commented 2 weeks ago

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