Error establishing a database connection. Unable to get environment variables working

[hexclann]

Hello, I have this docker compose file:

version: '3'
services:
  mysql:
    image: mariadb
    volumes:
      - /opt/mariadb:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: dbrootpass
      MYSQL_DATABASE: testdb
      MYSQL_USER: testuser
      MYSQL_PASSWORD: testpassword
    restart: always
  wordpress:
    image: wordpress:php8.2-fpm-alpine
    volumes:
      - /opt/wordpress/sites:/var/www/html
    depends_on:
      - mysql
    environment:
      WORDPRESS_DB_HOST: mysql
      MYSQL_ROOT_PASSWORD: dbrootpass
      WORDPRESS_DB_NAME: testdb
      WORDPRESS_DB_USER: testuser
      WORDPRESS_DB_PASSWORD: testpass
      WORDPRESS_TABLE_PREFIX: wp_
      WORDPRESS_INSTALL_TYPE: blog
      WORDPRESS_EMAIL: [email protected]
      WORDPRESS_SITE_TITLE: MySite
      WORDPRESS_ADMIN_USER: test
      WORDPRESS_ADMIN_PASSWORD: password
    links:
      - mysql
    restart: always
  nginx:
    image: nginx:alpine
    volumes:
      - /opt/wpnginx:/etc/nginx/conf.d
      - /opt/wordpress/sites:/var/www/html
    ports:
      - 80:80
    links:
      - wordpress

However the wordpress container logs shows:

WordPress not found in /var/www/html - copying now...
Complete! WordPress has been successfully copied to /var/www/html
No 'wp-config.php' found in /var/www/html, but 'WORDPRESS_...' variables supplied; copying 'wp-config-docker.php' (WORDPRESS_ADMIN_PASSWORD WORDPRESS_ADMIN_USER WORDPRESS_DB_HOST WORDPRESS_DB_NAME WORDPRESS_DB_PASSWORD WORDPRESS_DB_USER WORDPRESS_EMAIL WORDPRESS_INSTALL_TYPE WORDPRESS_SITE_TITLE WORDPRESS_TABLE_PREFIX)

I was unable to find a solution from the previous issues: #576 #578

[wglambert]

The WORDPRESS_DB_PASSWORD: testpass doesn't match MYSQL_PASSWORD: testpassword

Also WordPress doesn't interpret MYSQL_ROOT_PASSWORD

[hexclann]

@wglambert sorry for the wrong config file, I was manually redacting the credentials. Here is the updated docker compose file:

version: '3'
services:
  mysql:
    image: mariadb
    volumes:
      - /opt/mariadb:/var/lib/mysql
    environment:
      MYSQL_ROOT_PASSWORD: dbrootpass
      MYSQL_DATABASE: testdb
      MYSQL_USER: testuser
      MYSQL_PASSWORD: testpassword
    restart: always
  wordpress:
    image: wordpress:php8.2-fpm-alpine
    volumes:
      - /opt/wordpress/sites:/var/www/html
    depends_on:
      - mysql
    environment:
      WORDPRESS_DB_HOST: mysql
      WORDPRESS_DB_NAME: testdb
      WORDPRESS_DB_USER: testuser
      WORDPRESS_DB_PASSWORD: testpassword
      WORDPRESS_TABLE_PREFIX: wp_
      WORDPRESS_INSTALL_TYPE: blog
      WORDPRESS_EMAIL: [email protected]
      WORDPRESS_SITE_TITLE: MySite
      WORDPRESS_ADMIN_USER: test
      WORDPRESS_ADMIN_PASSWORD: password
    links:
      - mysql
    restart: always
  nginx:
    image: nginx:alpine
    volumes:
      - /opt/wpnginx:/etc/nginx/conf.d
      - /opt/wordpress/sites:/var/www/html
    ports:
      - 80:80
    links:
      - wordpress

I'm still getting the same error. Here is the wordpress container logs:

WordPress not found in /var/www/html - copying now...
Complete! WordPress has been successfully copied to /var/www/html
No 'wp-config.php' found in /var/www/html, but 'WORDPRESS_...' variables supplied; copying 'wp-config-docker.php' (WORDPRESS_ADMIN_PASSWORD WORDPRESS_ADMIN_USER WORDPRESS_DB_HOST WORDPRESS_DB_NAME WORDPRESS_DB_PASSWORD WORDPRESS_DB_USER WORDPRESS_EMAIL WORDPRESS_INSTALL_TYPE WORDPRESS_SITE_TITLE WORDPRESS_TABLE_PREFIX)
[05-Jan-2023 15:53:26] NOTICE: fpm is running, pid 1
[05-Jan-2023 15:53:26] NOTICE: ready to handle connections
172.22.0.4 -  05/Jan/2023:15:53:30 +0000 "GET /index.php" 500
172.22.0.4 -  05/Jan/2023:15:53:31 +0000 "GET /index.php" 500

[wglambert]

I can't reproduce using WordPress Apache. It could be something with the nginx config but otherwise those variables are fine and WordPress installs normally

mysql_1      | 2023-01-05 19:55:24 0 [Note] mariadbd: ready for connections.
mysql_1      | Version: '10.9.2-MariaDB-1:10.9.2+maria~ubu2204'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
wordpress_1  | WordPress not found in /var/www/html - copying now...
wordpress_1  | Complete! WordPress has been successfully copied to /var/www/html
wordpress_1  | No 'wp-config.php' found in /var/www/html, but 'WORDPRESS_...' variables supplied; copying 'wp-config-docker.php' (WORDPRESS_ADMIN_PASSWORD WORDPRESS_ADMIN_USER WORDPRESS_DB_HOST WORDPRESS_DB_NAME WORDPRESS_DB_PASSWORD WORDPRESS_DB_USER WORDPRESS_EMAIL WORDPRESS_INSTALL_TYPE WORDPRESS_SITE_TITLE WORDPRESS_TABLE_PREFIX)
wordpress_1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.25.0.3. Set the 'ServerName' directive globally to suppress this message
wordpress_1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.25.0.3. Set the 'ServerName' directive globally to suppress this message
wordpress_1  | [Thu Jan 05 19:55:19.727724 2023] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.54 (Debian) PHP/8.2.0 configured -- resuming normal operations
wordpress_1  | [Thu Jan 05 19:55:19.727843 2023] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
wordpress_1  | 174.67.152.53 - - [05/Jan/2023:19:55:29 +0000] "GET / HTTP/1.1" 302 414 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36"

$ docker exec -it wordpress_mysql_1 mysql -utestuser -ptestpassword testdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 36
Server version: 10.9.2-MariaDB-1:10.9.2+maria~ubu2204 mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [testdb]> show tables;
+-----------------------+
| Tables_in_testdb      |
+-----------------------+
| wp_commentmeta        |
| wp_comments           |
| wp_links              |
| wp_options            |
| wp_postmeta           |
| wp_posts              |
| wp_term_relationships |
| wp_term_taxonomy      |
| wp_termmeta           |
| wp_terms              |
| wp_usermeta           |
| wp_users              |
+-----------------------+
12 rows in set (0.001 sec)

You could try asking over at the Docker Community Forums, Docker Community Slack, or Stack Overflow as well

[SubhanSh]

Make sure you scaped special characters(such as $ dollar sign) in your password.

[LaurentGoderre]

I notice that you are mounting the same directory into your wordpress and your nginx, is that on purpose?