wp-config not working!!! #763

dbrosy · 2022-07-02T07:10:59Z

dbrosy
Jul 2, 2022

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 · 2022-07-05T16:15:06Z

wglambert
Jul 5, 2022

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

0 replies

dbrosy · 2022-07-06T10:55:58Z

dbrosy
Jul 6, 2022
Author

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.

0 replies

wglambert · 2022-07-06T17:29:30Z

wglambert
Jul 6, 2022

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        | [email protected] | 2022-07-06 17:22:13 | administrator |
+----+------------+--------------+--------------+---------------------+---------------+

0 replies

dbrosy · 2022-07-09T02:12:18Z

dbrosy
Jul 9, 2022
Author

@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.

0 replies

devphoenix2404 · 2022-07-18T10:40:49Z

devphoenix2404
Jul 18, 2022

@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 :)

0 replies

yosifkit · 2022-07-18T17:44:34Z

yosifkit
Jul 18, 2022
Maintainer

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)).

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

wp-config not working!!! #763

{{title}}

Replies: 6 comments

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

wp-config not working!!! #763

dbrosy Jul 2, 2022

Replies: 6 comments

wglambert Jul 5, 2022

dbrosy Jul 6, 2022 Author

wglambert Jul 6, 2022

dbrosy Jul 9, 2022 Author

devphoenix2404 Jul 18, 2022

yosifkit Jul 18, 2022 Maintainer

dbrosy
Jul 2, 2022

wglambert
Jul 5, 2022

dbrosy
Jul 6, 2022
Author

wglambert
Jul 6, 2022

dbrosy
Jul 9, 2022
Author

devphoenix2404
Jul 18, 2022

yosifkit
Jul 18, 2022
Maintainer