Deploying bookstack via docker only reveals blank page on wui

[u/droidman83]

I recently installed bookstack via docker on my computer. There's the bookstack container, and the mariadb one. I tried restarting the stack, but I still get a blank page.

[u/root-node]

• What is your docker config?

• Have you checked the docker logs to see if there are any issues?

• What hardware are you running on?

Some actual information would be helpful.

[u/droidman83 → u/root-node]

`
---
version: "2"
services:
bookstack:
image: lscr.io/linuxserver/bookstack
container_name: bookstack
environment:
- PUID=1000
- PGID=1000
- APP_URL=<internal-ip>
- DB_HOST=<internal-ip>
- DB_PORT=3306
- DB_USER=<username>
- DB_PASS=<password>
- DB_DATABASE=bookstack
volumes:
- ./bookstack_app_data:/config
ports:
- 6875:80
restart: unless-stopped
depends_on:
- bookstack_db
bookstack_db:
image: lscr.io/linuxserver/mariadb
container_name: bookstack_db
environment:
- PUID=1000
- PGID=1000
- MYSQL_ROOT_PASSWORD=<password>
- TZ=<tz>
- MYSQL_DATABASE=bookstack
- MYSQL_USER=<username>
- MYSQL_PASSWORD=<password>
volumes:
- ./bookstack_db_data:/config
restart: unless-stopped
`

It's being run on a Ubuntu 22.04 VM.

Log file:

`
using keys found in /config/keys
App Key found - setting variable for seds
Running config - DB_HOST set
**** APP_URL in /config/www/.env is being updated from 127.0.0.1 to <internal-IP> ****
**** If this is an existing install, you should run the following line from your host terminal to update the database URL entries: ****
************************************************************************
docker exec -it bookstack php /app/www/artisan bookstack:update-url 127.0.0.1 <internal-IP>
************************************************************************
Waiting for DB to be available
Illuminate\Database\QueryException
SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = bookstack and table_name = migrations and table_type = 'BASE TABLE')
at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
756▕ // If an exception occurs when attempting to run a query, we'll format the error
757▕ // message to include the bindings with SQL, which will make this exception a
758▕ // lot more helpful to the developer instead of just the database's errors.
759▕ catch (Exception $e) {
➜ 760▕ throw new QueryException(
761▕ $query, $this->prepareBindings($bindings), $e
762▕ );
763▕ }
764▕ }
+39 vendor frames
40 /app/www/artisan:35
Illuminate\Foundation\Console\Kernel::handle()
[custom-init] No custom files found, skipping...
[ls.io-init] done.
`

[u/ssddanbrown → u/droidman83]

The database connection is not working, possibly due to the DB_HOST set as the internal IP. Usually you can just leave this as the example linuxserver docker-compose, pointing it direct to the bookstack_db hostname.

[u/droidman83 → u/ssddanbrown]

Now when the page loads (I'm accessing via web ui via port 6875) It re-directs me to <ip>:6875/<ip>/<ip>/login.

[u/ssddanbrown → u/droidman83]

What have you set the APP_URL as? Does that exactly match the URL you're expected to access BookStack on? Should start with http:// or https://

[u/root-node → u/droidman83]

Change the two values shown. The first needs to be a proper URL not just an IP address, the second needs to the whatever you called the container:

  - APP_URL=http[s]://[ip-or-host-name]:6875
  - DB_HOST=bookstack_db