Wordpress cannot reach the DB if it is accessed with a domain name from outside the network

[RodrigoTomeES]

Hi,

I am deployment a website with the stack SWAG, Wordpress and MariaDB in a Raspberry Pi 4. I configurated all an it works well when I am access to the website with local ip but if I use the domain to connect with Wordpress, it doesn't connect with the data base. My docker compose is this:

version: "3.9"
services:
  # https://hub.docker.com/r/linuxserver/swag
  swag:
    depends_on:
      - wordpress
    image: lscr.io/linuxserver/swag
    container_name: swag
    cap_add:
      - NET_ADMIN
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Europe/Madrid
      - URL=${SWAG_URL}
      - VALIDATION=http
      - SUBDOMAINS=${SWAG_SUBDOMAINS} #optional
      - ONLY_SUBDOMAINS=false #optional
      - STAGING=false #optional
    volumes:
      - ${SWAG_CONFIG}:/config
      - ${WORDPRESS_DIR}:/config/www
    ports:
      - 443:443
      - 80:80 #optional
    restart: unless-stopped

  # https://hub.docker.com/_/mariadb
  db:
    image: mariadb:latest
    container_name: db
    environment:
      MARIADB_ROOT_PASSWORD: ${DB_MARIADB_ROOT_PASSWORD}
      MARIADB_DATABASE: ${DB_MARIADB_DATABASE}
      MARIADB_USER: ${DB_MARIADB_USER}
      MARIADB_PASSWORD: ${DB_MARIADB_PASSWORD}
    volumes:
      - ${DB_MARIADB}:/var/lib/mariadb
      - ${DB_MYSQL}:/var/lib/mysql
    restart: unless-stopped

  # https://hub.docker.com/_/wordpress
  wordpress:
    depends_on:
      - db
    image: wordpress:latest
    container_name: wordpress
    environment:
      - WORDPRESS_DB_HOST=db
      - WORDPRESS_DB_USER=${DB_MARIADB_USER}
      - WORDPRESS_DB_PASSWORD=${DB_MARIADB_PASSWORD}
      - WORDPRESS_DB_NAME=${DB_MARIADB_DATABASE}
      - VIRTUAL_PORT=80
    volumes:
      - ${WORDPRESS_DIR}:/var/www/html
    ports:
      - 8080:80
    restart: unless-stopped

  adminer:
    image: adminer
    container_name: adminer
    restart: always
    ports:
      - 9333:8080

It is not a problem of external access to my Wordpress instance since the database error appears and before installing Wordpress the SWAG static page appears correctly.

Access from local network

Access with domain

Do you know what could be happening?

Thanks!

[wglambert]

What do the docker logs show when you get the error?

[RodrigoTomeES]

@wglambert the wordpress container doesn't show any connection when I access with the domain

Here are the logs:

_db_logs.txt
_swag_logs.txt
_wordpress_logs.txt

Thanks for your help!

[wglambert]

Hmm, nothing comes up in the logs for any failures with anything, The GETs are all 200.
The only thing is that the address connecting to it is still internal so I'm not sure your connection to the URL is being established

I'm not able to reproduce and can connect externally and setup the site just fine

$ docker logs wordpress
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_DB_HOST WORDPRESS_DB_NAME WORDPRESS_DB_PASSWORD WORDPRESS_DB_USER)
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.24.0.3. Set the 'ServerName' directive globally to suppress this message
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.24.0.3. Set the 'ServerName' directive globally to suppress this message
[Mon Apr 11 16:35:55.282357 2022] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.52 (Debian) PHP/7.4.28 configured -- resuming normal operations
[Mon Apr 11 16:35:55.282434 2022] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
31.171.154.xxx - - [11/Apr/2022:16:36:15 +0000] "GET / HTTP/1.1" 302 415 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.81 Safari/537.36"
31.171.154.xxx - - [11/Apr/2022:16:36:15 +0000] "GET /wp-admin/install.php HTTP/1.1" 200 4631 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.81 Safari/537.36"
31.171.154.xxx - - [11/Apr/2022:16:36:17 +0000] "GET /favicon.ico HTTP/1.1" 302 414 "http://demo.url.net:8080/wp-admin/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.81 Safari/537.36"
31.171.154.xxx - - [11/Apr/2022:16:36:17 +0000] "GET /wp-admin/install.php HTTP/1.1" 200 4631 "http://demo.url.net:8080/wp-admin/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.81 Safari/537.36"
31.171.154.xxx - - [11/Apr/2022:16:36:18 +0000] "POST /wp-admin/install.php?step=1 HTTP/1.1" 200 2818 "http://demo.url.net:8080/wp-admin/install.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.81 Safari/537.36"
31.171.154.xxx - - [11/Apr/2022:16:36:19 +0000] "GET /favicon.ico HTTP/1.1" 302 414 "http://demo.url.net:8080/wp-admin/install.php?step=1" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.81 Safari/537.36"
31.171.154.xxx - - [11/Apr/2022:16:36:19 +0000] "GET /wp-admin/install.php HTTP/1.1" 200 4631 "http://demo.url.net:8080/wp-admin/install.php?step=1" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.81 Safari/537.36

You might also try asking over at the Docker Community Forums, Docker Community Slack, or Stack Overflow. Since these repos aren't really a user-help forum

[RodrigoTomeES]

@wglambert thanks, I will ask in those forums