[Bug]: Suddenly can't remotely connect to MySQL

Have you already looked into this bug?

[ ] I have checked the Troubleshooting Guide
[ ] I have checked Release notes for potential migration steps
[ ] I have checked existing issues for similar bugs
[ ] I have googled this bug already with no luck
[ ] I have not done any of the above

(Optional) Error message

No response

What went wrong?

Suddenly I cannot access MySQL from HeidiSQL (or other external db tools). The devilbox intranet works, i can access the db through phpmyadmin, I can access MySQL CLI via the php container and root with no password, my wordpress site works... I can also connect to redis remotely with Redis Insight. etc... MySQL is fine.

The only information I can provide about "what happened" is that I was step debugging a wordpress request, and then VS Code crashed. A variety of issues followed, so I decided to just wipe all the Docker Images, Containers, Volumes, Cache etc..., recreate them and re-create the WordPress webapp with a backup that I took yesterday. I would have figured that this would solve the problem, but it persists...

Things I've tried:

add bind-address = 0.0.0.0 and skip-grant-tables to the devilbox/cfg/mariadb-10.6/devilbox-custom.cnf file
added a new user and db, and can connect to/use those just fine within Devilbox etc...
FLUSH_PRIVILEGES from mysql within the php container
HeidiSQL works fine with other remote DBs, and nothing changed with its configuration.

Expected behaviour

To be able to connect to mysql remotely

How can we reproduce the bug?

No clue

Host Operating System

Linux

Host Platform (amd64, arm64, other)

amd64

(Linux only) Is SELinux enabled?

Yes, SELinux is enabled

Docker version

Docker version 20.10.18, build b40c2f6

Docker Compose version

Docker Compose version v2.10.2

Devilbox version

Devilbox v3.0.0-beta-0.1 (2022-12-24)

Have you removed stopped containers before starting?

Yes

Have you pulled latest Docker images before starting?

Yes

Devilbox start command

docker compose up httpd bind php mysql redis

Config: .env file

###
###  ---------------------------------------------------
###  D E V I L B O X   R U N - T I M E   S E T T I N G S
###  ---------------------------------------------------
###
###  All the following settings are applied during
###  $ docker-compose up
###
###  No need to rebuild any docker images!
###
###  IMPORTANT:
###  ----------
###  When changing any values ensure to stop, rm and restart:
###  $ docker-compose stop
###  $ docker-compose rm -f
###  $ docker-compose up
###
###  NOTE:
###  -----
###  For you own custom variables, scroll to the bottom
###

# The following line will disable any shellcheck warnings throughout this file
# shellcheck disable=SC2034,SC2125

###
### Show all executed commands in each
### docker image during docker-compose up?
###
### 0: Quiet
### 1: Verbose
### 2: More verbose
DEBUG_COMPOSE_ENTRYPOINT=2

###
### Log to file or Docker logs.
###
### Logging to file means log files are available under log/
### on your host operating system.
### Logging to Docker logs means log files are streamed to
### stdout and stderr.
###
### 1: Log to Docker logs
### 0: Log to file
###
DOCKER_LOGS=0

###
### Relative or absolute path to the devilbox repository.
### (Used as a prefix for all mount paths)
### There is no need to change this.
###
### The only exception is for OSX users wanting to use NFS
### mounts instead of Filesystem mounts due to degraded performance
### on OSX.
###
### Note: When changing this variable you must re-create the container.
###       Simply remove it, it will be auto-created during the next start:
###
### $ docker-compose rm -f
###
DEVILBOX_PATH=.

###
### At what IP address should the docker services listen
### on the Host computer?
###
### The specified default should be fine for Linux and OSX (127.0.0.1:).
### If you are on windows, you will probably have to change
### it to the IP address of the docker machine.
###
### a.) Leave blank, to listen on all interfaces (no trailing colon ':')
###    LOCAL_LISTEN_ADDR=
### b.) If an IP is specified, note the trailing colon ':'
###    LOCAL_LISTEN_ADDR=127.0.0.1:
###
LOCAL_LISTEN_ADDR=

###
### This is the domain suffix your projects will be made available
### with mass-virtual-hosting.
### It is also required for the internal DNS server to be setup.
###
### Note: In addition to period or dot character ('.'), only ALPHA ([a-zA-Z]+) characters are supported.
###       Mac users should not use the .local TLD, as this will not resolve properly due Apple's
###         use of Multicast DNS.##
###
### Example:
###   TLD_SUFFIX=loc
### Makes your project available under xxxx.loc
###
### Example:
###   TLD_SUFFIX=local
### Makes your project available under xxxx.local
###
TLD_SUFFIX=loc

###
### Optional DNS configuration
### Allows you to add extra DNS records (above the wildcard entry)
### Useful if your host computer run other Docker services that you want to connect to or reach
### from within the Devilbox network by a custom hostname.
###
### Format:
### -------
### Resolve any custom defined hostname to an IP address (useable inside container and host os)
###     EXTRA_HOSTS=<hostname>=<ip>[,<hostname>=<ip>]
###
### Resolve any custom defined hostname to whatever IP address a CNAME resolves to
### (Useable inside the container and host OS).
### Note: CNAME must be resolvable by Google DNS
###     EXTRA_HOSTS=<hostname>=<CNAME>[,<hostname>=<CNAME>]
###
### Examples:
### ---------
### EXTRA_HOSTS=hostname.loc=1.2.3.4
### EXTRA_HOSTS=host.loc=1.2.3.4,host.example.org=3.4.5.6
EXTRA_HOSTS=

###
### Set your user id and group id
###
### This should be changed to the value of your local
### users uid and gid
###
### Type `id` on the terminal to find out your values
###
NEW_UID=1000
NEW_GID=1000

###
### Timezone for PHP Docker container (system and php.ini)
###
TIMEZONE=UTC

################################################################################
###
### INTRANET SETTINGS
###
################################################################################

###
### TLD_SUFFIX domains are checked if they are set in the
### host computer /etc/hosts or available via attached DNS server.
### Timeout is done on vhosts.php (intranet) via ajax calls.
### In order to keep performance, set this to a low value.
### DNS checks might not succeed in time on slow machines.
### If DNS is valid, but timeout is expired, set this to a higher value.
###
### DNS_CHECK_TIMEOUT value is how many seconds to time out
### Default is to timeout after 1 second (DNS_CHECK_TIMEOUT=1)
###
DNS_CHECK_TIMEOUT=1

###
### Devilbox UI SSL Certificate generation
###
### When using SSL each certificate requires names for which it is responsible:
### Common Name as well as alternative names.
###
### Specify comma separated hostnames below by which you want to access the Devilbox.
### Those hostnames will be included in the SSL certificate for the Devilbox intranet.
### This has nothing to do for SSL certificates for projects, it is just for the intranet
### itself.
###
DEVILBOX_UI_SSL_CN=localhost,*.localhost,devilbox,*.devilbox,httpd

###
### Devilbox UI Password protection enable/disable (1/0)
###
### Set DEVILBOX_UI_PROTECT to 1 in order to password protect the
### intranet.
###
### Example:
###   DEVILBOX_UI_PROTECT=1
###   DEVILBOX_UI_PROTECT=0
###
DEVILBOX_UI_PROTECT=0

###
### Devilbox UI Password
###
### When DEVILBOX_UI_PROTECT=1, use the following password
### to log in. The password can always be changed.
### When changing the password, make sure to restart your
### PHP container.
###
### Example:
###   DEVILBOX_UI_PASSWORD=my-very-secure-password
###   DEVILBOX_UI_PASSWORD=Some pass with spaces
###
### The default username is 'devilbox'
###
DEVILBOX_UI_PASSWORD=password

###
### Enable the Devilbox Intranet?
###
### Example:
###   DEVILBOX_UI_ENABLE=1
###   DEVILBOX_UI_ENABLE=0
###
DEVILBOX_UI_ENABLE=1

###
### Automatically be logged in into phpMyAdmin
###
### Example:
###   DEVILBOX_VENDOR_PHPMYADMIN_AUTOLOGIN=1
###   DEVILBOX_VENDOR_PHPMYADMIN_AUTOLOGIN=0
###
DEVILBOX_VENDOR_PHPMYADMIN_AUTOLOGIN=1

###
### Automatically be logged in into phpPgAdmin
###
### Example:
###   DEVILBOX_VENDOR_PHPPGADMIN_AUTOLOGIN=1
###   DEVILBOX_VENDOR_PHPPGADMIN_AUTOLOGIN=0
###
DEVILBOX_VENDOR_PHPPGADMIN_AUTOLOGIN=1

################################################################################
###
### 1. Choose Images (Version)
###
################################################################################

###
### You can choose any combination of httpd, mysql, postgresql or php.
### Each of them are fully compatible between one another.
###

###
### 1.1 Choose PHP Server Image
###
### Note: PHP 5.2 is not officially supported. Intranet won't work (due to lack of namespace support).
###       PHP 5.2 only works with Apache 2.4, Nginx stable and Nginx mainline.
###       Use at your own risk.
###
#PHP_SERVER=5.2
#PHP_SERVER=5.3
#PHP_SERVER=5.4
#PHP_SERVER=5.5
#PHP_SERVER=5.6
#PHP_SERVER=7.0
#PHP_SERVER=7.1
#PHP_SERVER=7.2
#PHP_SERVER=7.3
#PHP_SERVER=7.4
#PHP_SERVER=8.0
PHP_SERVER=8.1
#PHP_SERVER=8.2

###
### 1.2 Choose HTTPD Server Image
###
### Choose between 'debian' or 'alpine' flavour and then select the version
###
### Note: apache-2.2 has no arm64 support on 'alpine' flavour
###
HTTPD_FLAVOUR=alpine

#HTTPD_SERVER=apache-2.2
#HTTPD_SERVER=apache-2.4
HTTPD_SERVER=nginx-stable
#HTTPD_SERVER=nginx-mainline

###
### 1.3 Choose MySQL Server Image
###
#MYSQL_SERVER=mysql-5.5
#MYSQL_SERVER=mysql-5.6
#MYSQL_SERVER=mysql-5.7
#MYSQL_SERVER=mysql-8.0
#MYSQL_SERVER=percona-5.5
#MYSQL_SERVER=percona-5.6
#MYSQL_SERVER=percona-5.7
#MYSQL_SERVER=percona-8.0
#MYSQL_SERVER=mariadb-5.5
#MYSQL_SERVER=mariadb-10.0
#MYSQL_SERVER=mariadb-10.1
#MYSQL_SERVER=mariadb-10.2
#MYSQL_SERVER=mariadb-10.3
#MYSQL_SERVER=mariadb-10.4
#MYSQL_SERVER=mariadb-10.5
MYSQL_SERVER=mariadb-10.6
#MYSQL_SERVER=mariadb-10.7
#MYSQL_SERVER=mariadb-10.8

###
### 1.4 Choose PostgreSQL Server Image
###
### https://www.postgresql.org/support/versioning/
###
### IMPORTANT: Alpine based images might cause issues on Docker Toolbox or OSX
###            https://github.com/docker/toolbox/issues/510
###
#
# PostgreSQL without arm64 support
#
#PGSQL_SERVER=9.0
#PGSQL_SERVER=9.1
#PGSQL_SERVER=9.2-alpine
#
# PostgreSQL with arm64 support
#
#PGSQL_SERVER=9.2
#PGSQL_SERVER=9.3
#PGSQL_SERVER=9.3-alpine
#PGSQL_SERVER=9.4
#PGSQL_SERVER=9.4-alpine
#PGSQL_SERVER=9.5
#PGSQL_SERVER=9.5-alpine
#PGSQL_SERVER=9.6
#PGSQL_SERVER=9.6-alpine
#PGSQL_SERVER=10
#PGSQL_SERVER=10-alpine
#PGSQL_SERVER=11
#PGSQL_SERVER=11-alpine
#PGSQL_SERVER=12
#PGSQL_SERVER=12-alpine
#PGSQL_SERVER=13
#PGSQL_SERVER=13-alpine
#PGSQL_SERVER=14
PGSQL_SERVER=14-alpine
#PGSQL_SERVER=latest
#PGSQL_SERVER=alpine

###
### 1.5 Choose Redis Server Image
###
### IMPORTANT: Alpine based images might cause issues on Docker Toolbox or OSX
###            https://github.com/docker/toolbox/issues/510
###
#
# Redis without arm64 support
#
#REDIS_SERVER=2.8
#REDIS_SERVER=3.0
#REDIS_SERVER=3.0-alpine
#
# Redis with arm64 support
#
#REDIS_SERVER=3.2
#REDIS_SERVER=3.2-alpine
#REDIS_SERVER=4.0
#REDIS_SERVER=4.0-alpine
#REDIS_SERVER=5.0
#REDIS_SERVER=5.0-alpine
#REDIS_SERVER=6.0
#REDIS_SERVER=6.0-alpine
#REDIS_SERVER=6.2
REDIS_SERVER=6.2-alpine
#REDIS_SERVER=latest
#REDIS_SERVER=alpine

###
### 1.6 Choose Memcached Server Image
###
### IMPORTANT: Alpine based images might cause issues on Docker Toolbox or OSX
###            https://github.com/docker/toolbox/issues/510
###
#
# Memcached without arm64 support
#
#MEMCD_SERVER=1.4
#MEMCD_SERVER=1.4-alpine
#
# Memcached with arm64 support
#
#MEMCD_SERVER=1.5
#MEMCD_SERVER=1.5-alpine
#MEMCD_SERVER=1.6
MEMCD_SERVER=1.6-alpine
#MEMCD_SERVER=latest
#MEMCD_SERVER=alpine

###
### 1.7 Choose Mongo Server Image
###
### https://www.mongodb.com/evolved
###
#
# MongoDB without arm64 support
#
#MONGO_SERVER=2.8
#MONGO_SERVER=3.0
#MONGO_SERVER=3.2
#
# MongoDB with arm64 support
#
#MONGO_SERVER=3.4
#MONGO_SERVER=3.6
#MONGO_SERVER=4.0
#MONGO_SERVER=4.2
#MONGO_SERVER=4.4
MONGO_SERVER=5.0
#MONGO_SERVER=latest

################################################################################
###
### 2. Host Mounts (Your computer)
###
################################################################################

###
### Global mount options
###
### Note: When adding custom mount options, ensure to start with a
###       leading ',' (comma), as those options are prepended to already
###       existing mount options.
###
### Note: If no mount options are specified, leave this variable empty
###       and do not add a leading ',' (comma).
###
### MOUNT_OPTIONS=,cached
### MOUNT_OPTIONS=
###
### Example: Allow to share mounts accross container with SELINUX enabled
###
### MOUNT_OPTIONS=,z
###
MOUNT_OPTIONS=

###
### Local filesystem path to www projects.
###
### Note: When changing this variable you must re-create the container.
###       Simply remove it, it will be auto-created during the next start:
###
### $ docker-compose rm -f
###
HOST_PATH_HTTPD_DATADIR=./data/www

###
### Local filesystem path to where your backups are stored
###
### Note: When changing this variable you must re-create the container.
###       Simply remove it, it will be auto-created during the next start:
###
### $ docker-compose rm -f
###
HOST_PATH_BACKUPDIR=./backups

###
### The path on your host OS of the ssh directory to be mounted into the
### PHP container into /home/devilbox/.ssh.
###
### IMPORTANT: The path is mounted read-only to ensure you cannot accidentally
##             delete anything inside the php container.
###
HOST_PATH_SSH_DIR=~/.ssh

################################################################################
###
### 3. PHP Docker Settings
###
################################################################################

###
### Enable certain PHP modules which are not enabled by default
###
### Currently the only modules that can be enabled are 'ioncube' and 'blackfire'
### Also ensure to disable xdebug when using any of the above:
### https://xdebug.org/docs/install#compat
###
### PHP_MODULES_ENABLE=ioncube, blackfire
###
PHP_MODULES_ENABLE=

###
### Disable any PHP modules that you don't require
###
### Specify a comma separated list without spaces of modules to disable
###
### PHP_MODULES_DISABLE=xdebug,imagick,swoole
###
PHP_MODULES_DISABLE=oci8,PDO_OCI,pdo_sqlsrv,sqlsrv,rdkafka,swoole

###
### Postfix settings for email catch-all
###
### When set to '1' postfix is normally started and made available. However you still need
### to configure it to your needs yourself. For that you can use the autostart scripts
### and define a couple of 'postconf -e name=value' commands.
###
### When set to '2' (email catch-all), no mail will leave the Devilbox. It is automatically
### internally routed the the devilbox mail account and you can see each sent mail
### in the bundled intranet: https://localhost/mail.php
###
### Values:
### 0: Disable postfix (do not start it)
### 1: Enable/Start postfix
### 2: Enable/Start postfix and enable email catch-all
###
PHP_MAIL_CATCH_ALL=2

###
### Configure everything else about PHP in
### * cfg/php-ini-X.X/*.ini
### * cfg/php-fpm-X.X/*.conf

################################################################################
###
### 4. HTTPD Docker Settings
###
################################################################################

###
### Expose HTTPD Port to Host
###
HOST_PORT_HTTPD=80
HOST_PORT_HTTPD_SSL=443

###
### Globally enable/disable HTTP/2 support
###
### This cannot be done on a per vhost level and must be enabled/disabled globally.
###
### Values:
###  * 0: HTTP/2 is disabled
###  * 1: HTTP/2 is enabled
###
HTTPD_HTTP2_ENABLE=1

###
### SSL (HTTP/HTTPS) settings for automated vhost generation
###
### By default each project will have two vhosts (one for HTTP and one for HTTPS).
### You can control the SSL settings for your projects via the below stated values.
###
### This is internally achieved via the '-m' argument of https://github.com/devilbox/vhost-gen
###
### Values:
###   * both:  Serve HTTP and HTTPS for all projects
###   * redir: HTTP always redirects to HTTPS
###   * ssl:   Only serve HTTPS
###   * plain: Only serve HTTP
###
HTTPD_VHOST_SSL_TYPE=both

###
### Document Root Subdirectory
###
### In your project directory, which subfolder should
### serve your files?
###
### When changing this value, restart the devilbox.
###
HTTPD_DOCROOT_DIR=htdocs

###
### Per vHost Config Subdirectory
###
### In your project directory, which subfolder should
### hold apache, nginx templates for a customized vhost?
###
### When changing this value, restart the devilbox.
###
HTTPD_TEMPLATE_DIR=.devilbox

###
### Webserver timeout (in seconds) to upstream PHP-FPM server
###
### This value should be greater than PHP's max_execution_time,
### otherwise the php script could still run and the webserver will
### simply drop the connection before getting an answer by PHP.
###
HTTPD_TIMEOUT_TO_PHP_FPM=1200

###
### NGINX ONLY
###
### Set worker_processes and worker_connections
###
### https://nginx.org/en/docs/ngx_core_module.html#worker_processes
### https://nginx.org/en/docs/ngx_core_module.html#worker_connections
###
HTTPD_NGINX_WORKER_PROCESSES=auto
HTTPD_NGINX_WORKER_CONNECTIONS=1024

################################################################################
###
### 5. MySQL Docker Settings
###
################################################################################

###
### MySQL root user password
###
### The password is required for the initial creation of the MySQL database
### as well as the Devilbox intranet to display schema and configuration settings.
###
### If you change your MySQL root user password via mysql cli, phpMyAdmin or other tools
### after the database has been created, ensure to adjust the value here accordingly as well.
###
### If you only change this value here after the database has been created,
### the MySQL root user password will not actually be changed and the Devilbox intranet
### won't be able to connect to the MySQL service.
###
MYSQL_ROOT_PASSWORD=

###
### Expose MySQL Port to Host
###
HOST_PORT_MYSQL=3306

################################################################################
###
### 6. PostgreSQL Docker Settings
###
################################################################################

###
### PostgreSQL 'root' user name (usually postgres)
###
PGSQL_ROOT_USER=postgres

###
### PostgreSQL 'root' user password
###
### If you want to set a password, ensure to remove 'trust' from
### PGSQL_HOST_AUTH_METHOD below
###
PGSQL_ROOT_PASSWORD=

###
### In order to not use a password for PostgreSQL, keep this value at 'trust'
###
PGSQL_HOST_AUTH_METHOD=trust

###
### Expose PostgreSQL Port to Host
###
HOST_PORT_PGSQL=5432

################################################################################
###
### 7. Redis Docker Settings
###
################################################################################

###
### Expose Redis Port to Host
###
HOST_PORT_REDIS=6379

###
### Custom startup arguments
###
### Apply custom startup arguments to redis
###
### Example: Password protection
###   Add password protection to the Redis server by specifying it should
###   require a password.
###   Note: Do not add quotes or spaces to the password
###
###   REDIS_ARGS=--requirepass my-redis-root-password
###
### Example: Verbosity
###
###   REDIS_ARGS=--loglevel verbose
###
REDIS_ARGS=
#REDIS_ARGS=--loglevel verbose --requirepass my-redis-root-password

################################################################################
###
### 8. Memcached Docker Settings
###
################################################################################

###
### Expose Memcached Port to Host
###
HOST_PORT_MEMCD=11211

################################################################################
###
### 9. MongoDB Docker Settings
###
################################################################################

###
### Expose MongoDB Port to Host
###
HOST_PORT_MONGO=27017

################################################################################
###
### 10. Bind Docker Settings
###
################################################################################

###
### Expose Bind Port to Host
###
HOST_PORT_BIND=1053

###
### Add comma separated DNS server from which you want to receive DNS
### You can also add DNS servers from your LAN (if any are available)
###
BIND_DNS_RESOLVER=8.8.8.8,8.8.4.4

###
### Validate DNSSEC
###
### Values:
###  no:    DNSSEC validation is disabled
###  yes:   DNSSEC validation is enabled, but a trust anchor must be manually configured.
###  auto:  DNSSEC validation is enabled, and a default trust anchor for root zone is used.
###
BIND_DNSSEC_VALIDATE=no

###
### Bind timing options (time in seconds)
###
### Leave empty for defaults.
### Only change when you know what you are doing.
###
BIND_TTL_TIME=
BIND_REFRESH_TIME=
BIND_RETRY_TIME=
BIND_EXPIRY_TIME=
BIND_MAX_CACHE_TIME=

###
### Show DNS Queries in Docker logs output?
###
### 1: Yes
### 0: No
BIND_LOG_DNS_QUERIES=0

################################################################################
###
### 11. Custom variables
###
################################################################################

###
### Any variable defined in this file will be available
### as environment variables to your PHP/HHV Docker container.
###
### This might be useful to set application environment and retrieve
### them via: <?php getenv('MY_APPLICATION_ENV'); ?>
###

###
### Example:
### <?php echo getenv('Foo'); ?> would produce: 'some value'
###
#Foo=some value

#ElasticSearch
HOST_PORT_ELK_ELASTIC=9200  #Controls the host port on which Elastic Search will be available at.
HOST_PORT_ELK_KIBANA=5601   #Controls the host port on which Kibana will be available at.
#ELK_SERVER=7.9.2   #Controls the ELK stack version to use.
ELK_SERVER=8.4.2    #Controls the ELK stack version to use.

DEBUG_ENTRYPOINT=1
HTTPD_BACKEND_TIMEOUT=2000

Config: docker-compose.override.yml

No response

Config: ./check-config.sh

# ==============================================================================
# Checking git
# ==============================================================================
[SUCC]  git is clean

# ==============================================================================
# Checking .env file
# ==============================================================================
[SUCC]  .env file exists
[SUCC]  .env file is readable
[ERR]   Variable 'DEVILBOX_HTTPD_MGMT_USER' missing in .env file
[ERR]   Variable 'DEVILBOX_HTTPD_MGMT_PASS' missing in .env file

Log: docker-compose logs

devilbox-bind-1   | [INFO] Debug level: 1
devilbox-bind-1   | 
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | /etc/bind/named.conf
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | include "/etc/bind/named.conf.logging";
devilbox-bind-1   | include "/etc/bind/named.conf.options";
devilbox-bind-1   | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
devilbox-bind-1   | [INFO] BIND logging: disabled explicitly
devilbox-bind-1   | [INFO] Using default DNS TTL time: 3600 sec
devilbox-bind-1   | [INFO] Using default DNS Refresh time: 1200 sec
devilbox-bind-1   | [INFO] Using default DNS Retry time: 180 sec
devilbox-bind-1   | [INFO] Using default DNS Expiry time: 1209600 sec
devilbox-bind-1   | [INFO] Using default DNS Max Cache time: 10800 sec
devilbox-bind-1   | [INFO] Changing DNS Max Cache size to: 90%
devilbox-bind-1   | [INFO] Not adding any PTR records
devilbox-bind-1   | [INFO] Adding A Record: *.loc -> 127.0.0.1
devilbox-bind-1   | [INFO] Not adding any CNAME records
devilbox-bind-1   | [INFO] $ALLOW_QUERY not set.
devilbox-bind-1   | [INFO] DNS query rules will not be set
devilbox-bind-1   | [INFO] $ALLOW_RECURSION not set.
devilbox-bind-1   | [INFO] DNS recursion rules will not be set
devilbox-bind-1   | [INFO] DNSSEC Validation: no
devilbox-bind-1   | [INFO] Adding custom DNS forwarder: 8.8.8.8,8.8.4.4
devilbox-bind-1   | 
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | /etc/bind/named.conf.options
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | options {
devilbox-bind-1   |     directory "/var/cache/bind";
devilbox-bind-1   |     dnssec-validation no;
devilbox-bind-1   |     auth-nxdomain no;    # conform to RFC1035
devilbox-bind-1   |     listen-on-v6 { any; };
devilbox-bind-1   |     max-cache-size 90%;
devilbox-bind-1   |     response-policy { zone "rpz"; };
devilbox-bind-1   |     forwarders {
devilbox-bind-1   |         8.8.8.8;
devilbox-bind-1   |         8.8.4.4;
devilbox-bind-1   |     };
devilbox-bind-1   | };
devilbox-bind-1   | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
devilbox-bind-1   | 
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | /etc/bind/custom/conf/rpz.conf
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | zone "rpz" IN {
devilbox-bind-1   |     type master;
devilbox-bind-1   |     allow-transfer { any; };
devilbox-bind-1   |     allow-update { any; };
devilbox-bind-1   |     file "/etc/bind/custom/zone/rpz";
devilbox-bind-1   | };
devilbox-bind-1   | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
devilbox-bind-1   | 
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | /etc/bind/custom/zone/rpz
devilbox-bind-1   | --------------------------------------------------------------------------------
devilbox-bind-1   | $TTL 3600
devilbox-bind-1   | @                               IN   SOA     bind. admin.bind. (
devilbox-bind-1   |                                              1672957073     ; Serial number
devilbox-bind-1   |                                              1200           ; Refresh time
devilbox-bind-1   |                                              180            ; Retry time
devilbox-bind-1   |                                              1209600        ; Expiry time
devilbox-bind-1   |                                              10800          ; Negative Cache TTL
devilbox-bind-1   | )
devilbox-bind-1   | 
devilbox-bind-1   | ; NS Records
devilbox-bind-1   |                                 IN   NS      bind.
devilbox-bind-1   | 
devilbox-bind-1   | ; Custom Records
devilbox-bind-1   | *.loc                           IN   A       127.0.0.1
devilbox-bind-1   | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
devilbox-bind-1   | [INFO] Starting BIND 9.18.10
devilbox-php-1    | [INFO] Debug level: 1
devilbox-php-1    | [INFO] Changing user 'devilbox' uid to: 1000
devilbox-php-1    | usermod: no changes
devilbox-php-1    | [INFO] Changing group 'devilbox' gid to: 1000
devilbox-php-1    | [INFO] Setting container timezone to: UTC
devilbox-php-1    | [INFO] Setting PHP: timezone=UTC
devilbox-php-1    | [INFO] Docker date set to: Thu Jan  5 22:17:53 UTC 2023
devilbox-php-1    | [INFO] $DOCKER_LOGS set to 0. Logging to files under: /var/log/php
devilbox-php-1    | [INFO] Make sure to mount this directory in order to view logs
devilbox-php-1    | [INFO] $ENABLE_MAIL set to 2. Enabling postfix catch-all
devilbox-mysql-1  | 2023-01-05 22:17:54+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.11+maria~ubu2004 started.
devilbox-redis-1  | 1:C 05 Jan 2023 22:17:54.965 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
devilbox-redis-1  | 1:C 05 Jan 2023 22:17:54.965 # Redis version=6.2.8, bits=64, commit=00000000, modified=0, pid=1, just started
devilbox-redis-1  | 1:C 05 Jan 2023 22:17:54.965 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.966 * monotonic clock: POSIX clock_gettime
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.966 * Running mode=standalone, port=6379.
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.966 # Server initialized
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.966 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.967 * Loading RDB produced by version 6.2.8
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.967 * RDB age 217 seconds
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.967 * RDB memory usage when created 0.77 Mb
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.967 # Done loading RDB, keys loaded: 1, keys expired: 0.
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.967 * DB loaded from disk: 0.000 seconds
devilbox-redis-1  | 1:M 05 Jan 2023 22:17:54.967 * Ready to accept connections
devilbox-httpd-1  | [DONE] Starting supervisord: 4.2.4 [HTTPD: nginx/1.22.1]
devilbox-mysql-1  | 2023-01-05 22:17:55+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
devilbox-mysql-1  | 2023-01-05 22:17:55+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.11+maria~ubu2004 started.
devilbox-mysql-1  | 2023-01-05 22:17:55+00:00 [Note] [Entrypoint]: MariaDB upgrade not required
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] mysqld (server 10.6.11-MariaDB-1:10.6.11+maria~ubu2004-log) starting as process 1 ...
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Number of pools: 1
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Using Linux native AIO
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Completed initialization of buffer pool
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: 128 rollback segments are active.
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: 10.6.11 started; log sequence number 91578892; transaction id 3434
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] Plugin 'FEEDBACK' is disabled.
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] Server socket created on IP: '0.0.0.0'.
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] mysqld: ready for connections.
devilbox-mysql-1  | Version: '10.6.11-MariaDB-1:10.6.11+maria~ubu2004-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
devilbox-mysql-1  | 2023-01-05 22:17:55 0 [Note] InnoDB: Buffer pool(s) load completed at 230105 22:17:55
devilbox-php-1    | [INFO] Forwarding httpd:80 to 127.0.0.1:80 inside this docker.
devilbox-php-1    | [INFO] Forwarding httpd:443 to 127.0.0.1:443 inside this docker.
devilbox-php-1    | [INFO] Forwarding mysql:3306 to 127.0.0.1:3306 inside this docker.
devilbox-php-1    | [INFO] Forwarding pgsql:5432 to 127.0.0.1:5432 inside this docker.
devilbox-php-1    | [INFO] Forwarding redis:6379 to 127.0.0.1:6379 inside this docker.
devilbox-php-1    | [INFO] Forwarding memcd:11211 to 127.0.0.1:11211 inside this docker.
devilbox-php-1    | [INFO] Forwarding mongo:27017 to 127.0.0.1:27017 inside this docker.
devilbox-php-1    | [INFO] Forwarding elastic:9200 to 127.0.0.1:9200 inside this docker.
devilbox-php-1    | [INFO] Forwarding txtai:8001 to 127.0.0.1:8001 inside this docker.
devilbox-php-1    | [INFO] Enabling 'socat-80-httpd-80' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-443-httpd-443' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-3306-mysql-3306' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-5432-pgsql-5432' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-6379-redis-6379' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-11211-memcd-11211' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-27017-mongo-27017' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-9200-elastic-9200' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'socat-8001-txtai-8001' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'rsyslogd' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'postfix' to be started by supervisord
devilbox-php-1    | [INFO] Enabling 'php-fpm' to be started by supervisord
devilbox-php-1    | [INFO] PHP.ini: xdebug.ini -> /usr/local/etc/php/conf.d/yyy-devilbox-user-runtime-xdebug.ini
devilbox-php-1    | [INFO] PHP.ini: devilbox-php.ini -> /usr/local/etc/php/conf.d/yyy-devilbox-user-runtime-devilbox-php.ini
devilbox-php-1    | [INFO] PHP-FPM.conf: devilbox-fpm.conf -> /usr/local/etc/php-fpm.d/yyy-devilbox-user-runtime-devilbox-fpm.conf
devilbox-php-1    | [INFO] $ENABLE_MODULES set, but empty. Not enabling any PHP modules.
devilbox-php-1    | [INFO] Disabling the following PHP modules: oci8,PDO_OCI,pdo_sqlsrv,sqlsrv,rdkafka,swoole
devilbox-php-1    | [INFO] $MYSQL_BACKUP_USER set for mysqldump-secure. Changing to 'root'
devilbox-php-1    | [INFO] $MYSQL_BACKUP_PASS set for mysqldump-secure. Changing to '******'
devilbox-php-1    | [INFO] $MYSQL_BACKUP_HOST set for mysqldump-secure. Changing to 'mysql'
devilbox-php-1    | Updating certificates in /etc/ssl/certs...
devilbox-php-1    | 1 added, 0 removed; done.
devilbox-php-1    | Running hooks in /etc/ca-certificates/update.d...
devilbox-php-1    | done.
devilbox-php-1    | [INFO] Starting supervisord
devilbox-php-1    | 2023-01-05 22:17:57,828 WARN No file matches via include "/etc/supervisor/custom.d/*.conf"
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/php-fpm.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/postfix.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/rsyslogd.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-11211-memcd-11211.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-27017-mongo-27017.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-3306-mysql-3306.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-443-httpd-443.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-5432-pgsql-5432.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-6379-redis-6379.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-80-httpd-80.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-8001-txtai-8001.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Included extra file "/etc/supervisor/conf.d/socat-9200-elastic-9200.conf" during parsing
devilbox-php-1    | 2023-01-05 22:17:57,828 INFO Set uid to user 0 succeeded
devilbox-php-1    | 2023-01-05 22:17:57,830 INFO supervisord started with pid 1
devilbox-php-1    | 2023-01-05 22:17:58,833 INFO spawned: 'rsyslogd' with pid 1509
devilbox-php-1    | 2023-01-05 22:17:58,834 INFO spawned: 'php-fpm' with pid 1510
devilbox-php-1    | 2023-01-05 22:17:58,836 INFO spawned: 'postfix' with pid 1511
devilbox-php-1    | 2023-01-05 22:17:58,837 INFO spawned: 'socat-11211-memcd-11211' with pid 1512
devilbox-php-1    | 2023-01-05 22:17:58,839 INFO spawned: 'socat-27017-mongo-27017' with pid 1513
devilbox-php-1    | 2023-01-05 22:17:58,841 INFO spawned: 'socat-3306-mysql-3306' with pid 1515
devilbox-php-1    | 2023-01-05 22:17:58,843 INFO spawned: 'socat-443-httpd-443' with pid 1518
devilbox-php-1    | 2023-01-05 22:17:58,845 INFO spawned: 'socat-5432-pgsql-5432' with pid 1519
devilbox-php-1    | 2023-01-05 22:17:58,847 INFO spawned: 'socat-6379-redis-6379' with pid 1520
devilbox-php-1    | 2023-01-05 22:17:58,850 INFO spawned: 'socat-80-httpd-80' with pid 1521
devilbox-php-1    | 2023-01-05 22:17:58,851 INFO spawned: 'socat-8001-txtai-8001' with pid 1522
devilbox-php-1    | 2023-01-05 22:17:58,854 INFO spawned: 'socat-9200-elastic-9200' with pid 1523
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: rsyslogd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: postfix entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-11211-memcd-11211 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-27017-mongo-27017 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-3306-mysql-3306 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-443-httpd-443 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-5432-pgsql-5432 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-6379-redis-6379 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-80-httpd-80 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-8001-txtai-8001 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
devilbox-php-1    | 2023-01-05 22:17:59,905 INFO success: socat-9200-elastic-9200 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

(Optional) Additional information

(.venv) nick@DESKTOP-DIFRTR1:~$ sudo ss -ltnp
State                     Recv-Q                    Send-Q                                       Local Address:Port                                        Peer Address:Port                   Process                                                    
LISTEN                    0                         4096                                               0.0.0.0:443                                              0.0.0.0:*                       users:(("docker-proxy",pid=22532,fd=4))                   
LISTEN                    0                         4096                                               0.0.0.0:1053                                             0.0.0.0:*                       users:(("docker-proxy",pid=22123,fd=4))                   
LISTEN                    0                         4096                                               0.0.0.0:3306                                             0.0.0.0:*                       users:(("docker-proxy",pid=22763,fd=4))                   
LISTEN                    0                         4096                                               0.0.0.0:6379                                             0.0.0.0:*                       users:(("docker-proxy",pid=22851,fd=4))                   
LISTEN                    0                         511                                              127.0.0.1:40015                                            0.0.0.0:*                       users:(("node",pid=27839,fd=26))                          
LISTEN                    0                         4096                                               0.0.0.0:80                                               0.0.0.0:*                       users:(("docker-proxy",pid=22561,fd=4))                   
LISTEN                    0                         511                                              127.0.0.1:36439                                            0.0.0.0:*                       users:(("node",pid=27755,fd=18))                          
LISTEN                    0                         4096                                                  [::]:443                                                 [::]:*                       users:(("docker-proxy",pid=22541,fd=4))                   
LISTEN                    0                         4096                                                  [::]:1053                                                [::]:*                       users:(("docker-proxy",pid=22131,fd=4))                   
LISTEN                    0                         4096                                                  [::]:3306                                                [::]:*                       users:(("docker-proxy",pid=22774,fd=4))                   
LISTEN                    0                         4096                                                  [::]:6379                                                [::]:*                       users:(("docker-proxy",pid=22860,fd=4))                   
LISTEN                    0                         4096                                                  [::]:80                                                  [::]:*                       users:(("docker-proxy",pid=22569,fd=4))

(.venv) nick@DESKTOP-DIFRTR1:~$ sudo ufw allow 3306/tcp
Rule added
Rule added (v6)
(.venv) nick@DESKTOP-DIFRTR1:~$ sudo ufw status verbose
Status: active
Logging: on (low)
Default: deny (incoming), allow (outgoing), deny (routed)
New profiles: skip

To                         Action      From
--                         ------      ----
3306/tcp                   ALLOW IN    Anywhere                  
3306/tcp (v6)              ALLOW IN    Anywhere (v6)

cytopia / devilbox