wp-config not working!!!

[dbrosy]

This is frustrating,

my wp-config.php no longer has database connection setting set. Instead it has getenv_docker...
if I use wp db check this fails as it is trying to connect to mysql

I have set environment variables 'WORDPRESS_DB_HOST' etc but its not reading them

using wp cli 2.6.0

I see lots of people having issues but no solutions.

if I set database credentials via env variables should wpcli read the variables?

[wglambert]

Can you give all the commands you ran and any relevant files or logs for reproducing the issue

If you're using an initialized volume then environment variables won't get changed

[dbrosy]

I'm running:

wp db check

and get following:

mysqlcheck: Got error: 2005: Unknown MySQL server host 'mysql' (-2) when trying to connect

printenv shows:

WORDPRESS_DB_HOST=mariadb
WORDPRESS_DB_PASSWORD=<replaced>
WORDPRESS_CLI_VERSION=2.6.0
WORDPRESS_DB_USER=root
WORDPRESS_DB_NAME=<replaced>
WORDPRESS_CLI_SHA512=08dd9035fda1d529807380d5b757839e2809e289eb1a698fe33e7e21a1431d3f77c551c2b2db5adc55083d5075ea4137407994111890f765e790a97e6d9ca7af

wp-cli debug:

root@107c3cdc0419:/var/www/html# wp db check --debug
Debug (bootstrap): Fallback autoloader paths: phar://wp-cli.phar/vendor/autoload.php (0.009s)
Debug (bootstrap): Loading detected autoloader: phar://wp-cli.phar/vendor/autoload.php (0.01s)
Debug (commands): Adding command: package (0.015s)
Debug (commands): Adding command: cache (0.016s)
Debug (commands): Adding command: transient (0.017s)
Debug (commands): Adding command: comment (0.018s)
Debug (commands): Adding command: meta in comment Namespace (0.019s)
Debug (commands): Adding command: menu (0.019s)
Debug (commands): Adding command: item in menu Namespace (0.02s)
Debug (commands): Adding command: location in menu Namespace (0.02s)
Debug (commands): Deferring command: network meta (0.02s)
Debug (commands): Adding command: option (0.021s)
Debug (commands): Adding command: post (0.022s)
Debug (commands): Adding command: meta in post Namespace (0.022s)
Debug (commands): Adding command: term in post Namespace (0.022s)
Debug (commands): Adding command: post-type (0.023s)
Debug (commands): Adding command: site (0.024s)
Debug (commands): Adding command: meta in site Namespace (0.024s)
Debug (commands): Adding command: option in site Namespace (0.025s)
Debug (commands): Adding command: taxonomy (0.025s)
Debug (commands): Adding command: term (0.026s)
Debug (commands): Adding command: meta in term Namespace (0.026s)
Debug (commands): Adding command: user (0.028s)
Debug (commands): Adding command: application-password in user Namespace (0.028s)
Debug (commands): Adding command: meta in user Namespace (0.029s)
Debug (commands): Adding command: session in user Namespace (0.029s)
Debug (commands): Adding command: term in user Namespace (0.029s)
Debug (commands): Adding command: network (0.029s)
Debug (hooks): Processing hook "after_add_command:network" with 1 callbacks (0.029s)
Debug (hooks): On hook "after_add_command:network": Closure in file phar:///usr/local/bin/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 696 (0.029s)
Debug (commands): Adding command: meta in network Namespace (0.03s)
Debug (commands): Adding command: plugin (0.032s)
Debug (commands): Adding command: auto-updates in plugin Namespace (0.032s)
Debug (commands): Adding command: theme (0.033s)
Debug (commands): Adding command: auto-updates in theme Namespace (0.034s)
Debug (commands): Adding command: mod in theme Namespace (0.034s)
Debug (commands): Adding command: db (0.036s)
Debug (commands): Adding command: media (0.037s)
Debug (commands): Adding command: scaffold (0.039s)
Debug (commands): Adding command: export (0.04s)
Debug (commands): Adding command: core (0.04s)
Debug (commands): Adding command: verify-checksums in core Namespace (0.041s)
Debug (commands): Adding command: verify-checksums in plugin Namespace (0.041s)
Debug (commands): Adding command: import (0.042s)
Debug (commands): Adding command: server (0.042s)
Debug (commands): Adding command: super-admin (0.043s)
Debug (commands): Adding command: config (0.044s)
Debug (commands): Adding command: core (0.046s)
Debug (commands): Adding command: cron (0.046s)
Debug (commands): Adding command: event in cron Namespace (0.047s)
Debug (commands): Adding command: schedule in cron Namespace (0.047s)
Debug (commands): Adding command: embed (0.047s)
Debug (commands): Adding command: fetch in embed Namespace (0.048s)
Debug (commands): Adding command: provider in embed Namespace (0.048s)
Debug (commands): Adding command: handler in embed Namespace (0.048s)
Debug (commands): Adding command: cache in embed Namespace (0.049s)
Debug (commands): Adding command: eval (0.049s)
Debug (commands): Adding command: eval-file (0.049s)
Debug (commands): Adding command: i18n (0.05s)
Debug (commands): Adding command: make-pot in i18n Namespace (0.051s)
Debug (commands): Adding command: make-json in i18n Namespace (0.051s)
Debug (commands): Adding command: make-mo in i18n Namespace (0.051s)
Debug (commands): Adding command: maintenance-mode (0.052s)
Debug (commands): Deferring command: language core (0.053s)
Debug (commands): Deferring command: language plugin (0.053s)
Debug (commands): Deferring command: language theme (0.054s)
Debug (hooks): Immediately invoking on passed hook "after_add_command:site": Closure in file phar:///usr/local/bin/wp-cli.phar/vendor/wp-cli/language-command/language-command.php at line 39 (0.054s)
Debug (commands): Adding command: switch-language in site Namespace (0.054s)
Debug (commands): Adding command: language (0.054s)
Debug (hooks): Processing hook "after_add_command:language" with 3 callbacks (0.054s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///usr/local/bin/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 696 (0.054s)
Debug (commands): Adding command: core in language Namespace (0.054s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///usr/local/bin/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 696 (0.054s)
Debug (commands): Adding command: plugin in language Namespace (0.055s)
Debug (hooks): On hook "after_add_command:language": Closure in file phar:///usr/local/bin/wp-cli.phar/vendor/wp-cli/wp-cli/php/class-wp-cli.php at line 696 (0.055s)
Debug (commands): Adding command: theme in language Namespace (0.055s)
Debug (commands): Adding command: rewrite (0.056s)
Debug (commands): Adding command: rewrite (0.056s)
Debug (commands): Adding command: cap (0.056s)
Debug (commands): Adding command: role (0.057s)
Debug (commands): Adding command: search-replace (0.059s)
Debug (commands): Adding command: shell (0.059s)
Debug (commands): Adding command: widget (0.06s)
Debug (commands): Adding command: sidebar (0.06s)
Debug (bootstrap): Adding framework command: phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/commands/cli.php (0.06s)
Debug (commands): Adding command: cli (0.062s)
Debug (commands): Adding command: cache in cli Namespace (0.062s)
Debug (commands): Adding command: alias in cli Namespace (0.062s)
Debug (bootstrap): Adding framework command: phar://wp-cli.phar/vendor/wp-cli/wp-cli/php/commands/help.php (0.062s)
Debug (commands): Adding command: help (0.063s)
Debug (bootstrap): No readable global config found (0.064s)
Debug (bootstrap): No project config found (0.064s)
Debug (bootstrap): argv: /usr/local/bin/wp-cli.phar db check --debug (0.064s)
Debug (bootstrap): ABSPATH defined: /var/www/html/ (0.064s)
Debug (context): Using context 'cli' (0.064s)
Debug (bootstrap): Begin WordPress load (0.064s)
Debug (bootstrap): wp-config.php path: /var/www/html/wp-config.php (0.064s)
Debug (bootstrap): Looking for UTF-8 BOM (0.064s)
Debug (bootstrap): Looking for UTF-16 (BE) BOM (0.064s)
Debug (bootstrap): Looking for UTF-16 (LE) BOM (0.064s)
Debug (hooks): Processing hook "before_run_command" with 1 callbacks (0.065s)
Debug (hooks): On hook "before_run_command": WP_CLI\Bootstrap\RegisterDeferredCommands->add_deferred_commands() (0.065s)
Debug (bootstrap): Running command: db check (0.065s)
Debug (db): Running shell command: /usr/bin/env mysqlcheck --no-defaults %s (0.07s)
Debug (db): Final MySQL command: /usr/bin/env mysqlcheck --no-defaults 'wordpress' --check --default-character-set='utf8' --user='example username' --host='mysql' (0.07s)
mysqlcheck: Got error: 2005: Unknown MySQL server host 'mysql' (-2) when trying to connect

note in the Final MySQL command it is using defaults from wp-config.php and not the env variables and was expected.

If I replace wp-config.php with old style config then command works as expected.

[wglambert]

Using the docker-compose.yml from https://github.com/docker-library/docs/tree/master/wordpress#-via-docker-stack-deploy-or-docker-compose

After setting up the site real quick I followed the wordpress:cli instructions https://github.com/docker-library/docs/tree/master/wordpress#wordpresscli

$ docker run -it --rm \
--volumes-from wordpress_wordpress_1 \
--network container:wordpress_wordpress_1 \
-e WORDPRESS_DB_HOST=db \
-e WORDPRESS_DB_PASSWORD=examplepass \
-e WORDPRESS_DB_NAME=exampledb \
-e WORDPRESS_DB_USER=exampleuser \
wordpress:cli user list

+----+------------+--------------+--------------+---------------------+---------------+
| ID | user_login | display_name | user_email   | user_registered     | roles         |
+----+------------+--------------+--------------+---------------------+---------------+
| 1  | admin      | admin        | null@null.nl | 2022-07-06 17:22:13 | administrator |
+----+------------+--------------+--------------+---------------------+---------------+

[dbrosy]

@wglambert thanks for your feedback and testing, I will review our custom image and see if I can identify why it behaves differently. I saw others had the same issue on wpcli github issues page and had a workaround.

[devphoenix2404]

@dbrosy Can you please share the solution as I'm also having the same issue, where the getenv_docker... values are not updated even when all the environment variables have the value.
Thanks in advance :)

[yosifkit]

getenv_docker will not embed the values into the wp-config file; the values need to be present in the environment every time wp-config.php is run (like when wp-cli uses it, the values also need to be defined there too, #731 (comment)).