Cannot install Bookstack on 2 different maschines with portainer, .env. will not be updated

[colognerunner]

Attempted Debugging

• I have read the debugging page

Searched GitHub Issues

• I have searched GitHub for the issue.

Describe the Scenario

I have tried to install BookStack on 2 different maschines with portainer. Other applications like PaperlessNGX are running / updating fine in these environments.
The error is the sane on both maschines, during the first deployment the .env will not be updated with the values that are set in the yml file. The resulting error is down below in the log section, together with .env file content taht did not get updated.

The .env file contains default values that are of course not matching the real values in the yml file.

At the beginning i had a # in the password, but I removed it afther reading your debugging page. Makes no difference.

Tried this first on a Raspberry Pi5 and afther a few trials and redeploys, I tried on a UGreen NAS with a N100 Intel Chip. Exact same result on both maschines.

Exact BookStack Version

25.12.3

Log Content

using keys found in /config/keys

Waiting for DB to be available

Illuminate\Database\QueryException

SQLSTATE[HY000] [1045] Access denied for user 'database_username'@'bookstack.bookstack_default' (using password: YES) (Connection: mysql, Host: bookstack_db, Port: 3306, Database: bookstackapp, SQL: select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as `exists`)

at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:838

834▕ $exceptionType = $this->isUniqueConstraintError($e)

835▕ ? UniqueConstraintViolationException::class

836▕ : QueryException::class;

837▕

➜ 838▕ throw new $exceptionType(

839▕ $this->getNameWithReadWriteType(),

840▕ $query,

841▕ $this->prepareBindings($bindings),

842▕ $e,

+41 vendor frames

42 /app/www/artisan:35

Illuminate\Foundation\Console\Kernel::handle()

[custom-init] No custom files found, skipping...

[ls.io-init] done.

The .env file has this content:

# This file, when named as ".env" in the root of your BookStack install

# folder, is used for the core configuration of the application.

# By default this file contains the most common required options but

# a full list of options can be found in the '.env.example.complete' file.



# NOTE: If any of your values contain a space or a hash you will need to

# wrap the entire value in quotes. (eg. MAIL_FROM_NAME="BookStack Mailer")



# Application key

# Used for encryption where needed.

# Run `php artisan key:generate` to generate a valid key.

APP_KEY=SomeRandomString



# Application URL

# This must be the root URL that you want to host BookStack on.

# All URLs in BookStack will be generated using this value

# to ensure URLs generated are consistent and secure.

# If you change this in the future you may need to run a command

# to update stored URLs in the database. Command example:

# php artisan bookstack:update-url https://old.example.com https://new.example.com

APP_URL=https://example.com



# Database details

DB_HOST=localhost

DB_DATABASE=database_database

DB_USERNAME=database_username

DB_PASSWORD=database_user_password



# Storage system to use

# By default files are stored on the local filesystem, with images being placed in

# public web space so they can be efficiently served directly by the web-server.

# For other options with different security levels & considerations, refer to:

# https://www.bookstackapp.com/docs/admin/upload-config/

STORAGE_TYPE=local



# Mail system to use

# Can be 'smtp' or 'sendmail'

MAIL_DRIVER=smtp



# Mail sender details

MAIL_FROM_NAME="BookStack"

MAIL_FROM=bookstack@example.com



# SMTP mail options

# These settings can be checked using the "Send a Test Email"

# feature found in the "Settings > Maintenance" area of the system.

# For more detailed documentation on mail options, refer to:

# https://www.bookstackapp.com/docs/admin/email-webhooks/#email-configuration

MAIL_HOST=localhost

MAIL_PORT=587

MAIL_USERNAME=null

MAIL_PASSWORD=null

MAIL_ENCRYPTION=null

Hosting Environment

Raspberry Pi 5 8GBB RAM
Ugreen NAS DXP2800

[ssddanbrown]

Hi @colognerunner,

The .env file contains default values that are of course not matching the real values in the yml file.

What does your yml file look like?

The linuxserver image used won't update the .env file with all matching environment values, as it does not need to do that.
BookStack will use environment variables if they exist, over .env values, so as long as the env is being set via docker it should be fine, but it sounds like that is not happening in this setup.