5.6-php7.2-apache + : Database Connection Issue WP-CLI

[briannezhad]

docker-compose.yml file example:

version: "3.3"
services:
  db:
    image: mysql:5.7
    ports:
      - 3306:3306
    volumes:
      - db_data:/var/lib/mysql
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: somewordpress
      MYSQL_DATABASE: wordpress
      MYSQL_USER: wordpress
      MYSQL_PASSWORD: wordpress
  wordpress:
    depends_on:
      - db
    build: .
    ports:
      - 80:80
    restart: always
    environment:
      WORDPRESS_DB_HOST: db:3306
      WORDPRESS_DB_NAME: wordpress
      WORDPRESS_DB_USER: wordpress
      WORDPRESS_DB_PASSWORD: wordpress
      WORDPRESS_TABLE_PREFIX: "wp_"
      WORDPRESS_DEBUG: 1
      WORDPRESS_CONFIG_EXTRA: define( 'WP_DEFAULT_THEME', 'default' );
    volumes:
      - wp_data:/var/www/html
      - ./posttypes.txt:/var/www/html/posttypes.txt
      - ./uploads.ini:/usr/local/etc/php/conf.d/uploads.ini
      - ./default:/var/www/html/wp-content/themes/default/
      - ./wp-content:/var/www/html/wp-content/
      - ./.htaccess:/var/www/html/.htaccess
  wordpress-cli:
    depends_on:
      - db
      - wordpress
    image: wordpress:cli
    user: xfs
    command: >
      /bin/sh -c '
      sleep 10;
      wp core multisite-install --path="/var/www/html" --url="http://localhost" --title="Intranet" --admin_user=admin --admin_password=admin --admin_email=admin@admin.admin --skip-email;
      wp core update-db --network --allow-root
      wp theme enable default --network --activate;
      wp site list --field=url | xargs -n1 -I {} sh -c "wp --url={} theme activate default";
      wp site list --field=url | xargs -n1 -I % wp --url=% relevanssi index
      wp plugin delete hello akismet hello-dolly;
      wp theme delete twentysixteen twentyseventeen twentynineteen twentytwenty twentytwentyone twentytwentytwo;
      wp plugin update --all;
      wp plugin activate --all --network;
      wp redirection database upgrade;
      wp option update permalink_structure "/%postname%/";
      wp config set DISALLOW_FILE_EDIT true --raw;
      wp config set ALLOW_UNFILTERED_UPLOADS true --raw;
      wp rewrite flush;
      '
    volumes:
      - wp_data:/var/www/html
      - ./posttypes.txt:/var/www/html/posttypes.txt
      - ./uploads.ini:/usr/local/etc/php/conf.d/uploads.ini
      - ./default:/var/www/html/wp-content/themes/default/
      - ./wp-content:/var/www/html/wp-content/
      - ./.htaccess:/var/www/html/.htaccess
volumes:
  db_data:
  # vstm: add shared volume
  wp_data:

Dockerfile

#Base operating System
FROM library/wordpress:php7.4

#install wp-cli
RUN curl -O https://raw.githubusercontent.com/wp-cli/builds/gh-pages/phar/wp-cli.phar && \
    chmod +x wp-cli.phar && \
    mv wp-cli.phar /usr/local/bin/wp

# Install Postfix.
RUN apt-get update -y && \
      echo "postfix postfix/main_mailer_type string Internet site" > preseed.txt && 
# Use Mailbox format.
      debconf-set-selections preseed.txt && \
      DEBIAN_FRONTEND=noninteractive apt-get install -q -y postfix

# Install net-tools
RUN apt-get install net-tools

# Install Ghostscript & ImageMagick
RUN apt-get update -y
RUN apt-get install -y ghostscript
RUN apt-get install -y imagemagick

RUN echo "sendmail_path=sendmail -t -i" >> /usr/local/etc/php/conf.d/sendmail.ini \
 && echo '#!/bin/bash' >> /usr/local/bin/docker-entrypoint-wrapper.sh \
 && echo 'service postfix restart' >> /usr/local/bin/docker-entrypoint-wrapper.sh \
 && echo 'exec docker-entrypoint.sh "$@"' >> /usr/local/bin/docker-entrypoint-wrapper.sh \
 && chmod +x /usr/local/bin/docker-entrypoint-wrapper.sh

# Grant postdrop permission to www-data
RUN usermod -aG postdrop www-data

# Install packages: wget
RUN apt-get install -y wget

#copy built files to WordPress files system
COPY default  /var/www/html/wp-content/themes/default
COPY ts-child  /var/www/html/wp-content/themes/ts-child

#copy wp plugin install script
COPY wp-plugins-install.sh  /var/www/html/

ENTRYPOINT ["docker-entrypoint-wrapper.sh"]
CMD ["apache2-foreground"]

The WordPress container and MySQL get created perfectly, but when we get to wordpress:cli we get the following error:

wordpress-cli_1  | Error: Error establishing a database connection. This either means that the username and password information in your `wp-config.php` file is incorrect or that contact with the database server at `mysql` could not be established. This could mean your host’s database server is down.
wordpress-cli_1  | Error: Error establishing a database connection.

This only happens in any image above 5.6-php7.2-apache. Any idea how to resolve this?

[yosifkit]

Since #557 / #572, the environment values are not embedded in the wp-config.php file at first startup, but are instead always read from the environment when wp-config.php is run (like when running the WP cli). So any of your environment variables that would affect what WP cli is doing or how it can access the database, need to also be defined for its container.