DB_PASSWORD Environment Variable Not Loading in Early Bootstrap

[lazitskiy]

Lumen Version

10.0.4

PHP Version

8.1.0

Database Driver & Version

No response

Description

DB_PASSWORD Environment Variable Not Loading in Early Bootstrap

Description

When using Lumen 10.x with phpdotenv 5.x, there's an issue where the DB_PASSWORD environment variable is not properly loaded during early application bootstrap, while other DB_* variables (DB_HOST, DB_PORT, etc.) load correctly. This affects database connectivity as the password is empty when Eloquent tries to establish a connection.

Environment

• OS: macOS
• PHP Version: 8.1.0
• Lumen Framework Version: 10.0.4
• phpdotenv Version: 5.6.1

Steps To Reproduce

1. Create a new Lumen project
2. Set up a .env file with database configuration:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=test_db
DB_USERNAME=root
DB_PASSWORD=root

3. Enable Eloquent in bootstrap/app.php:

$app->withEloquent();

Try to connect to the database
Current Behavior
All DB_* environment variables are loaded correctly EXCEPT for DB_PASSWORD
env('DB_PASSWORD') returns an empty string
Database connection fails with "Access denied for user 'root'@'localhost' (using password: NO)"
Expected Behavior
DB_PASSWORD should be loaded along with other DB_* variables
Database connection should work with the provided password
Workaround
Currently using this workaround in bootstrap/app.php:

// Manual environment variables loading
$envFile = __DIR__ . '/../.env';
if (file_exists($envFile)) {
    $lines = file($envFile, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
    foreach ($lines as $line) {
        if (strpos($line, '#') === 0 || empty($line)) {
            continue;
        }
        list($name, $value) = explode('=', $line, 2);
        $name = trim($name);
        $value = trim($value);
        putenv("{$name}={$value}");
        $_ENV[$name] = $value;
        $_SERVER[$name] = $value;
    }
}

Additional Context
This only affects the DB_PASSWORD variable; all other environment variables (including other DB_* variables) load correctly
The issue appears to be related to the timing of environment variable loading versus database initialization
The problem doesn't occur in full Laravel framework, only in Lumen

[crynobone]

Hey there,

Unfortunately we don't support this version of the library anymore. Please check out our support policy on which versions we are currently supporting. Can you please try to upgrade to the latest version and see if your problem persists? If so, please open up a new issue and we'll help you out.

Thanks!