mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-05 08:39:55 +03:00
Connection problem between my client and my database on docker compose install #2897
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @Azrod31 on GitHub (Jul 9, 2022).
Attempted Debugging
Searched GitHub Issues
Describe the Scenario
Hello,
My problem is that my client can't connect to the database. I see from the logs that the wrong user is selected. Is it possible to change this in a config file?
Here is the error in question :
In addition, I manage to connect to the database and execute the command that is indicated, but even after having executed it, it does not change anything.
Thanks for help.
Exact BookStack Version
v22.06.2-ls24
Log Content
No response
PHP Version
No response
Hosting Environment
Debian 11 - up to date
Kernel : 5.10.0-14
@ssddanbrown commented on GitHub (Jul 9, 2022):
Hi @Azrod31,
The shown command, in the error message, reflects the command BookStack is attempting to use, not the command which would fix the issue.
Yes, but how you do that depends on how you're running BookStack. Based on your provided version it looks like you are using the linuxserver.io docker image. How are you running the container and are you passing environment options? The linuxserver docker image usage instructions provide details on database credentials: https://github.com/linuxserver/docker-bookstack/#usage
@Azrod31 commented on GitHub (Jul 9, 2022):
Hi @ssddanbrown,
Thanks for you reply. Yes I'm use the linuxserver.io docker image.
Here is my docker-compose.yml :
I have change the DB_USER and DB_PASS to DB_USERNAME and DB_PASSWORD because I found in this issue that it could cause problems. https://github.com/linuxserver/docker-bookstack/issues/58
Yes, I have pass environment options, and I think it's right because my user is debian and I put PUID: 1000 and GUID: 1000 :
You thinks the problem it's the incorrect PUID and GUID ?
@ssddanbrown commented on GitHub (Jul 9, 2022):
Nothing shown is making me think that those are the issue here.
One thing I noticed it that you have mounted volumes, for both the BookStack and Database containers, at the same path. This is quite dangerous in my opinion. May not be causing your specific issue though.
Have you ran any additional commands on the MySQL system? Anything to harden or add security to the database? The error shown does not really reflect the wrong user being used but reflects an unexpected host value, maybe for the system as a whole or for the bookstack user.
@Azrod31 commented on GitHub (Jul 9, 2022):
Ok thanks, I found my mistake. It is indeed a volume problem which are mounted on the same path. I changed the base volume path by adding
/dband it works.Thanks @ssddanbrown
@ssddanbrown commented on GitHub (Jul 9, 2022):
Alright, Will therefore close this off. Just remember to keep the
/path/to/datafiles safe.That's only really there as an example, since that's an uncommon path. Usually I'd use something like
./db:/configfor the database container and./bookstack:/configfor the bookstack container, to store the data within the same folder as thedocker-compose.ymlfile.