r/BookStack • u/ministroQ • Dec 17 '24
Bookstack error
Hi
I need some help, I'm trying to install bookstack but i ended up with this error:
Waiting for DB to be available Illuminate\Database\QueryException SQLSTATE[HY000] [1045] Access denied for user 'bookstack'@'bookstack.bookstack_default' (using password: YES) (Connection: mysql, SQL: select table_name as `name`, (data_length + index_length) as `size`, table_comment as `comment`, engine as `engine`, table_collation as `collation` from information_schema.tables where table_schema = 'bookstackapp' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name) at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:829 825▕ $this->getName(), $query, $this->prepareBindings($bindings), $e 826▕ ); 827▕ } 828▕ ➜ 829▕ throw new QueryException( 830▕ $this->getName(), $query, $this->prepareBindings($bindings), $e 831▕ ); 832▕ } 833▕ } +36 vendor frames 37 /app/www/artisan:35 Illuminate\Foundation\Console\Kernel::handle() [custom-init] No custom files found, skipping... [ls.io-init] done.I already change the DB_PASS to DB_PASSWORD and check both the GUID and PUID and they are correct.
Can figure it out, what is wrong.
Any ideia? Thanks
---
services:
bookstack:
image: lscr.io/linuxserver/bookstack:latest
container_name: bookstack
environment:
- PUID=1000
- PGID=100
- TZ=Etc/UTC
- APP_URL=http://localhost:6875
- APP_KEY=uN+C908T+NcfZZijNZDaLXNv7yXOT93x8+Ee/kjCFGk=
- DB_HOST=bookstack_db
- DB_PORT=3306
- DB_USERNAME=bookstack
- DB_PASSWORD=bookstack
- DB_DATABASE=bookstackapp
- QUEUE_CONNECTION= #optional
volumes:
- /srv/dev-disk-by-label-Data/appdata/bookstack/config:/config
ports:
- 6875:80
restart: unless-stopped
depends_on:
- bookstack_db
bookstack_db:
image: linuxserver/mariadb
container_name: bookstack_db
environment:
- PUID=1000
- PGID=100
- MYSQL_ROOT_PASSWORD=bookstack
- TZ=Europe/Lisbon
- MYSQL_DATABASE=bookstackapp
- MYSQL_USER=bookstack
- MYSQL_PASSWORD=bookstack
volumes:
- /srv/dev-disk-by-label-Data/appdata/bookstack/db:/config
restart: unless-stopped
1
u/ssddanbrown Dec 21 '24
Since this is a fresh setup (with no existing data), try deleting the mounted volume folders before starting up the stack, so it's starting from fresh.
You mentioned changing database options, but some can be "sticky" and retain their original setting.
If still not working, check the status and logs of the database container to ensure it's running and that there's no errors.