search

cytopia / devilbox

A modern Docker LAMP stack and MEAN stack for local development
http://devilbox.org
MIT License
4.39k stars 654 forks source link

MySQL got timeout reading communication packets #653

Closed cs16lover closed 3 years ago

cs16lover commented 4 years ago

ISSUE TYPE

OS / ENVIRONMENT

  1. Host operating system and version: MacOS Catalina
  2. (Windows) Native Docker or Docker Toolbox: Docker Desktop
  3. Docker version: Engine: 19.03.5
  4. Docker Compose version: Compose: 1.24.1
  5. What git commit hash are you on?: Latest master

SUMMARY

From time to time MySQL got timeout and stops responding. But after some time passes it again comes back.

STEPS TO REPRODUCE

docker-compose up httpd php mysql

EXPECTED BEHAVIOUR

It should work always.

ACTUAL BEHAVIOUR

[Warning] Aborted connection 42 to db: 'tbot' user: 'root' host: '172.16.238.10' (Got timeout reading communication packets)

OTHER INFORMATION

Start command

$ docker-compose up httpd php mysql

.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?
###
### 1: Yes
### 0: No
DEBUG_COMPOSE_ENTRYPOINT=1

###
### 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: Only ALPHA ([a-zA-Z]+) characters are supported.
###
### 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

###
### 1.2 Choose HTTPD Server Image
###
#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=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=percona-5.5
#MYSQL_SERVER=percona-5.6
#MYSQL_SERVER=percona-5.7
#MYSQL_SERVER=percona-8.0

###
### 1.4 Choose PostgreSQL Server Image
###
### IMPORTANT: Apline based images might cause issues on Docker Toolbox or OSX
###            https://github.com/docker/toolbox/issues/510
###
#PGSQL_SERVER=9.0
#PGSQL_SERVER=9.1
#PGSQL_SERVER=9.2
#PGSQL_SERVER=9.2-alpine
#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.0
#PGSQL_SERVER=10.0-alpine
#PGSQL_SERVER=10.1
#PGSQL_SERVER=10.1-alpine
#PGSQL_SERVER=10.2
#PGSQL_SERVER=10.2-alpine
#PGSQL_SERVER=10.3
#PGSQL_SERVER=10.3-alpine
#PGSQL_SERVER=10.4
#PGSQL_SERVER=10.4-alpine
#PGSQL_SERVER=10.5
#PGSQL_SERVER=10.5-alpine
#PGSQL_SERVER=10.6
#PGSQL_SERVER=10.6-alpine
#PGSQL_SERVER=10.7
#PGSQL_SERVER=10.7-alpine
#PGSQL_SERVER=10.8
#PGSQL_SERVER=10.8-alpine
#PGSQL_SERVER=10.9
#PGSQL_SERVER=10.9-alpine
#PGSQL_SERVER=10.10
#PGSQL_SERVER=10.10-alpine
#PGSQL_SERVER=10.11
#PGSQL_SERVER=10.11-alpine
#PGSQL_SERVER=11.0
#PGSQL_SERVER=11.0-alpine
#PGSQL_SERVER=11.2
#PGSQL_SERVER=11.2-alpine
#PGSQL_SERVER=11.3
#PGSQL_SERVER=11.3-alpine
#PGSQL_SERVER=11.4
#PGSQL_SERVER=11.4-alpine
#PGSQL_SERVER=11.5
#PGSQL_SERVER=11.5-alpine
#PGSQL_SERVER=11.6
#PGSQL_SERVER=11.6-alpine
#PGSQL_SERVER=12.0
#PGSQL_SERVER=12.0-alpine
PGSQL_SERVER=12.1
#PGSQL_SERVER=12.1-alpine
#PGSQL_SERVER=latest
#PGSQL_SERVER=alpine

###
### 1.5 Choose Redis Server Image
###
### IMPORTANT: Apline based images might cause issues on Docker Toolbox or OSX
###            https://github.com/docker/toolbox/issues/510
###
#REDIS_SERVER=2.8
#REDIS_SERVER=3.0
#REDIS_SERVER=3.0-alpine
#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=latest
#REDIS_SERVER=alpine

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

###
### 1.7 Choose Mongo Server Image
###
#MONGO_SERVER=2.8
#MONGO_SERVER=3.0
#MONGO_SERVER=3.2
#MONGO_SERVER=3.4
#MONGO_SERVER=3.6
#MONGO_SERVER=4.0
MONGO_SERVER=4.2
#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 ',' (comman).
###
### 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

################################################################################
###
### 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

###
### 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

###
### 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=180

###
### 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=root

###
### 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
###
PGSQL_ROOT_PASSWORD=

###
### 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

File and user permissions (Linux & MacOS)

$ id
uid=501(abcuser) gid=20(staff) groups=20(staff),12(everyone),61(localaccounts),79(_appserverusr),80(admin),81(_appserveradm),98(_lpadmin),33(_appstore),100(_lpoperator),204(_developer),250(_analyticsusers),395(com.apple.access_ftp),398(com.apple.access_screensharing),399(com.apple.access_ssh),400(com.apple.access_remote_ae),701(com.apple.sharepoint.group.1)
$ ls -al
total 376
drwxr-xr-x  32 abcuser  admin   1088 Dec 30 11:42 .
drwxr-xr-x   7 abcuser  admin    238 Dec 29 19:41 ..
-rw-r--r--@  1 abcuser  admin   8196 Dec 30 11:42 .DS_Store
drwxr-xr-x   4 abcuser  admin    136 Dec 29 19:42 .devilbox
-rw-r--r--   1 abcuser  admin   2502 Dec 29 19:42 .editorconfig
-rw-r--r--   1 abcuser  admin  17143 Dec 29 22:00 .env
drwxr-xr-x  14 abcuser  admin    476 Dec 30 22:13 .git
drwxr-xr-x   6 abcuser  admin    204 Dec 29 19:42 .github
-rw-r--r--   1 abcuser  admin   3612 Dec 29 19:42 .gitignore
drwxr-xr-x   7 abcuser  admin    238 Dec 29 19:42 .tests
-rw-r--r--   1 abcuser  admin  11465 Dec 29 19:42 .travis.yml
-rw-r--r--   1 abcuser  admin   6480 Dec 29 19:42 CHANGELOG.md
-rw-r--r--   1 abcuser  admin   2770 Dec 29 19:42 CONTRIBUTING.md
-rw-r--r--   1 abcuser  admin   1064 Dec 29 19:42 LICENSE.md
-rw-r--r--   1 abcuser  admin  64531 Dec 29 19:42 README.md
-rw-r--r--   1 abcuser  admin   1490 Dec 29 19:42 UPDATING.md
drwxr-xr-x   5 abcuser  admin    170 Dec 29 19:42 autostart
drwxr-xr-x@  4 abcuser  admin    136 Dec 29 20:46 backups
drwxr-xr-x   4 abcuser  admin    136 Dec 29 19:42 bash
drwxr-xr-x@  6 abcuser  admin    204 Dec 29 20:46 ca
drwxr-xr-x  58 abcuser  admin   1972 Dec 29 19:42 cfg
drwxr-xr-x  11 abcuser  admin    374 Dec 29 19:42 compose
drwxr-xr-x   5 abcuser  admin    170 Dec 30 11:42 data
-rw-r--r--   1 abcuser  admin    743 Dec 29 19:42 docker-compose.override.yml-example
-rw-r--r--   1 abcuser  admin  14672 Dec 29 19:42 docker-compose.yml
drwxr-xr-x  40 abcuser  admin   1360 Dec 29 19:42 docs
-rw-r--r--   1 abcuser  admin  17139 Dec 29 19:42 env-example
drwxr-xr-x   8 abcuser  admin    272 Dec 29 22:06 log
drwxr-xr-x  11 abcuser  admin    374 Dec 29 22:06 mod
-rw-r--r--   1 abcuser  admin     86 Dec 29 19:42 shell.bat
-rwxr-xr-x   1 abcuser  admin     59 Dec 29 19:42 shell.sh
-rwxr-xr-x   1 abcuser  admin   2265 Dec 29 19:42 update-docker.sh
$ ls -al data/www
total 16
drwxr-xr-x@ 5 abcuser  admin   170 Dec 30 11:42 .
drwxr-xr-x  5 abcuser  admin   170 Dec 30 11:42 ..
-rw-r--r--@ 1 abcuser  admin  6148 Dec 30 11:42 .DS_Store
-rw-r--r--  1 abcuser  admin     0 Dec 29 19:42 .keepme
drwxr-xr-x  4 abcuser  admin   136 Dec 30 11:42 tbot

logs:

$ docker-compose up httpd php mysql
devilbox_bind_1 is up-to-date
Starting devilbox_php_1 ... done
Starting devilbox_httpd_1 ... done
Starting devilbox_mysql_1 ... done
Attaching to devilbox_php_1, devilbox_httpd_1, devilbox_mysql_1
httpd_1  | [INFO] Debug level: 1
php_1    | [INFO] Debug level: 1
httpd_1  | [INFO] Runtime debug: 1
httpd_1  | [INFO] Changing user 'nginx' uid to: 1000
mysql_1  | 2019-12-30 13:16:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.3.21+maria~bionic started.
php_1    | [INFO] Changing user 'devilbox' uid to: 1000
httpd_1  | usermod: no changes
httpd_1  | [INFO] Changing group 'nginx' gid to: 1000
httpd_1  | [INFO] Setting container timezone to: UTC
httpd_1  | [INFO] Docker date set to: Mon Dec 30 13:16:05 UTC 2019
php_1    | usermod: no changes
httpd_1  | [INFO] $WORKER_PROCESSES set to its default value: 'auto'.
httpd_1  | [INFO] Setting worker_connections to: 1024
httpd_1  | [INFO] $DOCKER_LOGS disabled. Logging errors and access to log files inside container.
httpd_1  | [INFO] PHP-FPM: Enabled
httpd_1  | [INFO] PHP-FPM: Server address: php
php_1    | [INFO] Changing group 'devilbox' gid to: 1000
php_1    | [INFO] Setting container timezone to: UTC
httpd_1  | [INFO] PHP-FPM: Server port: 9000
php_1    | [INFO] Setting PHP: timezone=UTC
httpd_1  | [INFO] PHP-FPM: Timeout: 180
httpd_1  | [INFO] Main vhost: Enabled
httpd_1  | [INFO] Main vhost: Setting SSL type to: http and https
httpd_1  | [INFO] Main vhost: Enable automatic generation of SSL certificates
httpd_1  | [INFO] Main vhost: SSL CN: localhost,*.localhost,devilbox,*.devilbox,httpd
httpd_1  | [INFO] $MAIN_VHOST_DOCROOT not specified. Keeping default: htdocs
httpd_1  | [INFO] $MAIN_VHOST_TPL not specified. Keeping default: cfg
httpd_1  | [INFO] Main vhost: Enabling httpd status page
httpd_1  | [INFO] Main vhost: Changing status page alias to: /devilbox-httpd-status
httpd_1  | [INFO] Mass vhost: Enabled
httpd_1  | [INFO] Mass vhost: Setting SSL type to: http and https
httpd_1  | [INFO] Mass vhost: Enable automatic generation of SSL certificates
php_1    | [INFO] Docker date set to: Mon Dec 30 13:16:04 UTC 2019
httpd_1  | [INFO] Mass vhost: changing tld to: .loc
httpd_1  | [INFO] Mass vhost: changing document root to: htdocs
httpd_1  | [INFO] Mass vhost: changing template dir to: .devilbox
httpd_1  | [INFO] vhost-gen: no customized template found
httpd_1  | [WARN] override template not found:  /var/www/default/cfg/nginx.yml
php_1    | [INFO] $DOCKER_LOGS set to 0. Logging to files under: /var/log/php
php_1    | [INFO] Make sure to mount this directory in order to view logs
php_1    | [INFO] $ENABLE_MAIL set to 1. Enabling postfix catch-all
httpd_1  | vhostgen: [2019-12-30 13:16:05] Adding: localhost
httpd_1  | $ openssl req -newkey rsa:2048 -sha256 -nodes -extensions v3_req -config <(echo "[req]
httpd_1  | distinguished_name = req_distinguished_name
httpd_1  | x509_extensions = v3_req
httpd_1  |
httpd_1  | [req_distinguished_name]
httpd_1  |
httpd_1  | [ v3_req ]
httpd_1  | basicConstraints = critical, CA:FALSE
httpd_1  | subjectKeyIdentifier = hash
httpd_1  | keyUsage = critical, digitalSignature, keyEncipherment
httpd_1  | authorityKeyIdentifier = keyid:always,issuer:always
httpd_1  | extendedKeyUsage = serverAuth, clientAuth
httpd_1  | subjectAltName=${ALT_NAMES}") -keyout /etc/httpd/cert/main/localhost.key -subj '/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=localhost/emailAddress=admin@localhost' -out /etc/httpd/cert/main/localhost.csr
httpd_1  | $ openssl x509 -req -sha256 -extensions v3_req -extfile <(echo "[req]
httpd_1  | distinguished_name = req_distinguished_name
httpd_1  | x509_extensions = v3_req
httpd_1  |
httpd_1  | [req_distinguished_name]
httpd_1  |
httpd_1  | [ v3_req ]
httpd_1  | basicConstraints = critical, CA:FALSE
httpd_1  | subjectKeyIdentifier = hash
httpd_1  | keyUsage = critical, digitalSignature, keyEncipherment
httpd_1  | authorityKeyIdentifier = keyid:always,issuer:always
httpd_1  | extendedKeyUsage = serverAuth, clientAuth
httpd_1  | subjectAltName=${ALT_NAMES}") -days 825 -in /etc/httpd/cert/main/localhost.csr -CA /ca/devilbox-ca.crt -CAkey /ca/devilbox-ca.key -CAcreateserial -out /etc/httpd/cert/main/localhost.crt
httpd_1  | Certificate:
httpd_1  |     Data:
httpd_1  |         Version: 3 (0x2)
httpd_1  |         Serial Number:
httpd_1  |             2a:29:23:56:42:7d:a1:ee:9a:d0:0c:6a:92:e0:ab:04:88:fd:e4:54
httpd_1  |         Signature Algorithm: sha256WithRSAEncryption
httpd_1  |         Issuer: C = DE, ST = Berlin, L = Berlin, O = Devilbox, OU = Devilbox, CN = Devilbox Root CA, emailAddress = cytopia@devilbox.org, dnQualifier = cTZDjWzJ2nRzJTJ1SemsWBujY1g=
httpd_1  |         Validity
httpd_1  |             Not Before: Dec 30 13:16:06 2019 GMT
httpd_1  |             Not After : Apr  3 13:16:06 2022 GMT
httpd_1  |         Subject: C = DE, ST = Berlin, L = Berlin, O = Devilbox, OU = Devilbox, CN = localhost, emailAddress = admin@localhost
httpd_1  |         Subject Public Key Info:
httpd_1  |             Public Key Algorithm: rsaEncryption
httpd_1  |                 RSA Public-Key: (2048 bit)
httpd_1  |                 Modulus:
httpd_1  |                     00:c9:29:13:2b:76:97:8d:6e:da:f2:6d:e1:11:f2:
httpd_1  |                     ee:5c:e3:08:5e:a8:b8:d6:cc:98:2b:95:c6:63:e6:
httpd_1  |                     58:e2:e7:fc:0e:de:86:4a:c1:70:15:49:92:86:5e:
httpd_1  |                     81:6b:56:59:e2:b2:d4:f8:c3:8d:8d:40:23:77:a8:
httpd_1  |                     e3:b4:29:5e:a6:03:4d:97:fa:65:97:8b:f8:9d:3e:
httpd_1  |                     07:8c:5a:8a:46:b5:1e:0a:5b:14:44:41:07:ba:99:
httpd_1  |                     d5:c7:53:ee:06:0f:6b:8d:6e:7b:64:18:6a:b0:d8:
httpd_1  |                     bf:1e:8a:83:69:55:77:0e:1f:5d:4c:c9:d0:3d:6a:
httpd_1  |                     71:57:9b:d4:29:bb:33:7a:23:7e:0c:84:ac:af:bc:
httpd_1  |                     ff:99:03:c4:b8:65:66:6c:6b:e1:bd:57:20:18:25:
httpd_1  |                     2d:ae:33:57:79:b5:9c:68:4c:9a:a1:d6:ed:d4:04:
httpd_1  |                     5b:87:6e:47:25:e2:1d:5f:10:b2:8b:65:57:1e:34:
httpd_1  |                     c3:10:db:9a:c1:80:07:05:05:33:20:75:a3:44:0a:
httpd_1  |                     4b:3a:54:74:93:25:75:29:b7:78:7e:f6:ab:df:89:
httpd_1  |                     9b:de:a3:e9:bb:2c:b1:3b:1a:ab:36:67:0f:42:83:
httpd_1  |                     76:dc:a8:52:d9:bb:3a:c8:50:9d:8e:9e:21:03:20:
httpd_1  |                     fc:f1:6a:d5:0a:2e:8d:e7:72:f2:5c:5b:24:cb:25:
httpd_1  |                     54:13
httpd_1  |                 Exponent: 65537 (0x10001)
httpd_1  |         X509v3 extensions:
httpd_1  |             X509v3 Basic Constraints: critical
httpd_1  |                 CA:FALSE
httpd_1  |             X509v3 Subject Key Identifier:
httpd_1  |                 D7:DA:4F:FF:10:C5:97:73:AA:6F:E6:10:C1:41:82:DE:03:A9:D6:6B
httpd_1  |             X509v3 Key Usage: critical
httpd_1  |                 Digital Signature, Key Encipherment
httpd_1  |             X509v3 Authority Key Identifier:
httpd_1  |                 keyid:71:36:43:8D:6C:C9:DA:74:73:25:32:75:49:E9:AC:58:1B:A3:63:58
httpd_1  |                 DirName:/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=Devilbox Root CA/emailAddress=cytopia@devilbox.org/dnQualifier=cTZDjWzJ2nRzJTJ1SemsWBujY1g=
httpd_1  |                 serial:16:D0:D1:A5:C4:52:56:50:72:2A:87:C9:70:BB:11:C1:28:A6:36:DF
httpd_1  |
httpd_1  |             X509v3 Extended Key Usage:
httpd_1  |                 TLS Web Server Authentication, TLS Web Client Authentication
httpd_1  |             X509v3 Subject Alternative Name:
httpd_1  |                 DNS:localhost, DNS:localhost, DNS:*.localhost, DNS:devilbox, DNS:*.devilbox, DNS:httpd
httpd_1  |     Signature Algorithm: sha256WithRSAEncryption
httpd_1  |          93:ce:a5:48:de:d3:27:49:e6:77:36:7d:8f:c9:3f:d3:99:36:
httpd_1  |          54:df:94:01:07:13:e7:0a:33:31:22:47:0c:fe:a4:a7:2b:b9:
httpd_1  |          ba:dd:37:dd:06:ff:5e:4b:34:cc:1e:70:95:b4:a1:67:21:bd:
httpd_1  |          06:0a:09:39:70:9e:30:5d:21:0b:4e:ae:e5:2b:e3:25:f2:a9:
httpd_1  |          56:49:a6:c5:ae:73:cf:d6:90:4e:b5:80:72:50:cd:d1:5d:43:
httpd_1  |          9f:b1:ce:3b:36:22:6d:aa:5f:c1:3d:23:7a:33:15:3d:dc:1e:
httpd_1  |          e9:a0:02:7b:e7:de:a4:63:26:60:74:7b:18:1c:14:cb:12:fd:
httpd_1  |          af:da:13:aa:e8:2e:ff:32:dc:bc:b9:a4:23:94:c4:8a:f2:42:
httpd_1  |          55:2a:cb:dc:8c:2f:08:8e:fc:05:45:d1:a0:83:ec:2f:ca:b9:
httpd_1  |          55:9b:55:68:a4:e7:94:d4:f3:ab:96:4f:19:4c:ff:8e:02:85:
httpd_1  |          3e:11:81:ba:56:7d:3a:cf:43:a1:7e:d1:33:59:a0:48:a1:f4:
httpd_1  |          9d:eb:ef:33:a2:96:bf:47:c6:d0:54:fc:63:f2:63:9d:70:60:
httpd_1  |          96:a2:7c:34:fa:c1:68:5a:ac:b9:56:1f:f1:6e:d1:29:06:50:
httpd_1  |          4c:8d:cc:53:1e:65:a6:b4:2d:2d:d5:13:02:7b:e8:8f:91:00:
httpd_1  |          0c:ee:8b:ba
httpd_1  | /etc/httpd/cert/main/localhost.crt: OK
php_1    | [INFO] Forwarding httpd:80 to 127.0.0.1:80 inside this docker.
httpd_1  | [INFO] Starting supervisord: 3.3.5
php_1    | [INFO] Forwarding httpd:443 to 127.0.0.1:443 inside this docker.
php_1    | [INFO] Forwarding mysql:3306 to 127.0.0.1:3306 inside this docker.
php_1    | [INFO] Forwarding pgsql:5432 to 127.0.0.1:5432 inside this docker.
httpd_1  | 2019-12-30 13:16:06,785 INFO Set uid to user 0 succeeded
httpd_1  | 2019-12-30 13:16:06,788 INFO supervisord started with pid 1
php_1    | [INFO] Forwarding redis:6379 to 127.0.0.1:6379 inside this docker.
php_1    | [INFO] Forwarding memcd:11211 to 127.0.0.1:11211 inside this docker.
php_1    | [INFO] Forwarding mongo:27017 to 127.0.0.1:27017 inside this docker.
php_1    | [INFO] Enabling 'socat-80-httpd-80' to be started by supervisord
php_1    | [INFO] Enabling 'socat-443-httpd-443' to be started by supervisord
php_1    | [INFO] Enabling 'socat-3306-mysql-3306' to be started by supervisord
mysql_1  | 2019-12-30 13:16:06+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1  | 2019-12-30 13:16:06+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.3.21+maria~bionic started.
php_1    | [INFO] Enabling 'socat-5432-pgsql-5432' to be started by supervisord
php_1    | [INFO] Enabling 'socat-6379-redis-6379' to be started by supervisord
php_1    | [INFO] Enabling 'socat-11211-memcd-11211' to be started by supervisord
php_1    | [INFO] Enabling 'socat-27017-mongo-27017' to be started by supervisord
php_1    | [INFO] Enabling 'rsyslogd' to be started by supervisord
php_1    | [INFO] Enabling 'postfix' to be started by supervisord
php_1    | [INFO] Enabling 'php-fpm' to be started by supervisord
php_1    | [INFO] $ENABLE_MODULES set, but empty. Not enabling any PHP modules.
php_1    | [INFO] Disabling the following PHP modules: oci8,PDO_OCI,pdo_sqlsrv,sqlsrv,rdkafka,swoole
php_1    | [INFO] $MYSQL_BACKUP_USER set for mysqldump-secure. Changing to 'root'
php_1    | [INFO] $MYSQL_BACKUP_PASS set for mysqldump-secure. Changing to '******'
php_1    | [INFO] $MYSQL_BACKUP_HOST set for mysqldump-secure. Changing to 'mysql'
mysql_1  | 2019-12-30 13:16:07 0 [Note] mysqld (mysqld 10.3.21-MariaDB-1:10.3.21+maria~bionic) starting as process 1 ...
php_1    | Updating certificates in /etc/ssl/certs...
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Using Linux native AIO
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Uses event mutexes
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Number of pools: 1
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
httpd_1  | 2019-12-30 13:16:07,792 INFO spawned: 'httpd' with pid 202
httpd_1  | 2019-12-30 13:16:07,795 INFO spawned: 'watcherd' with pid 203
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Waiting for purge to start
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: 10.3.21 started; log sequence number 21846922; transaction id 14754
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1  | 2019-12-30 13:16:07 0 [Note] Plugin 'FEEDBACK' is disabled.
mysql_1  | 2019-12-30 13:16:07 0 [Note] Server socket created on IP: '::'.
mysql_1  | 2019-12-30 13:16:07 0 [Warning] 'proxies_priv' entry '@% root@mysql' ignored in --skip-name-resolve mode.
mysql_1  | 2019-12-30 13:16:07 0 [Note] InnoDB: Buffer pool(s) load completed at 191230 13:16:07
mysql_1  | 2019-12-30 13:16:07 0 [Note] Reading of all Master_info entries succeeded
mysql_1  | 2019-12-30 13:16:07 0 [Note] Added new Master_info '' to hash table
mysql_1  | 2019-12-30 13:16:07 0 [Note] mysqld: ready for connections.
mysql_1  | Version: '10.3.21-MariaDB-1:10.3.21+maria~bionic'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
php_1    | 0 added, 0 removed; done.
php_1    | Running hooks in /etc/ca-certificates/update.d...
php_1    | done.
php_1    | [INFO] Starting supervisord
php_1    | 2019-12-30 13:16:08,678 INFO Included extra file "/etc/supervisor/conf.d/php-fpm.conf" during parsing
php_1    | 2019-12-30 13:16:08,679 INFO Included extra file "/etc/supervisor/conf.d/postfix.conf" during parsing
php_1    | 2019-12-30 13:16:08,679 INFO Included extra file "/etc/supervisor/conf.d/rsyslogd.conf" during parsing
php_1    | 2019-12-30 13:16:08,679 INFO Included extra file "/etc/supervisor/conf.d/socat-11211-memcd-11211.conf" during parsing
php_1    | 2019-12-30 13:16:08,680 INFO Included extra file "/etc/supervisor/conf.d/socat-27017-mongo-27017.conf" during parsing
php_1    | 2019-12-30 13:16:08,681 INFO Included extra file "/etc/supervisor/conf.d/socat-3306-mysql-3306.conf" during parsing
php_1    | 2019-12-30 13:16:08,682 INFO Included extra file "/etc/supervisor/conf.d/socat-443-httpd-443.conf" during parsing
php_1    | 2019-12-30 13:16:08,682 INFO Included extra file "/etc/supervisor/conf.d/socat-5432-pgsql-5432.conf" during parsing
php_1    | 2019-12-30 13:16:08,683 INFO Included extra file "/etc/supervisor/conf.d/socat-6379-redis-6379.conf" during parsing
php_1    | 2019-12-30 13:16:08,684 INFO Included extra file "/etc/supervisor/conf.d/socat-80-httpd-80.conf" during parsing
php_1    | 2019-12-30 13:16:08,685 INFO Set uid to user 0 succeeded
php_1    | 2019-12-30 13:16:08,689 INFO supervisord started with pid 1
httpd_1  | 2019-12-30 13:16:08,799 INFO success: httpd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
httpd_1  | 2019-12-30 13:16:08,800 INFO success: watcherd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:09,695 INFO spawned: 'rsyslogd' with pid 1135
php_1    | 2019-12-30 13:16:09,700 INFO spawned: 'socat-3306-mysql-3306' with pid 1136
php_1    | 2019-12-30 13:16:09,705 INFO spawned: 'socat-6379-redis-6379' with pid 1137
php_1    | 2019-12-30 13:16:09,710 INFO spawned: 'postfix' with pid 1138
php_1    | 2019-12-30 13:16:09,714 INFO spawned: 'socat-27017-mongo-27017' with pid 1139
php_1    | 2019-12-30 13:16:09,719 INFO spawned: 'php-fpm' with pid 1140
php_1    | 2019-12-30 13:16:09,722 INFO spawned: 'socat-80-httpd-80' with pid 1141
php_1    | 2019-12-30 13:16:09,726 INFO spawned: 'socat-443-httpd-443' with pid 1142
php_1    | 2019-12-30 13:16:09,729 INFO spawned: 'socat-11211-memcd-11211' with pid 1143
php_1    | 2019-12-30 13:16:09,733 INFO spawned: 'socat-5432-pgsql-5432' with pid 1144
php_1    | rsyslogd: imklog: cannot open kernel log (/proc/kmsg): Operation not permitted.
php_1    | rsyslogd: activation of module imklog failed [v8.1901.0 try https://www.rsyslog.com/e/2145 ]
httpd_1  | watcherd: [2019-12-30 13:16:10] Starting daemon.
php_1    | 2019-12-30 13:16:10,841 INFO success: rsyslogd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,842 INFO success: socat-3306-mysql-3306 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,842 INFO success: socat-6379-redis-6379 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,843 INFO success: postfix entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,843 INFO success: socat-27017-mongo-27017 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,843 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,844 INFO success: socat-80-httpd-80 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,844 INFO success: socat-443-httpd-443 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,844 INFO success: socat-11211-memcd-11211 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2019-12-30 13:16:10,845 INFO success: socat-5432-pgsql-5432 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
httpd_1  | $ openssl req -newkey rsa:2048 -sha256 -nodes -extensions v3_req -config <(echo "[req]
httpd_1  | distinguished_name = req_distinguished_name
httpd_1  | x509_extensions = v3_req
httpd_1  |
httpd_1  | [req_distinguished_name]
httpd_1  |
httpd_1  | [ v3_req ]
httpd_1  | basicConstraints = critical, CA:FALSE
httpd_1  | subjectKeyIdentifier = hash
httpd_1  | keyUsage = critical, digitalSignature, keyEncipherment
httpd_1  | authorityKeyIdentifier = keyid:always,issuer:always
httpd_1  | extendedKeyUsage = serverAuth, clientAuth
httpd_1  | subjectAltName=${ALT_NAMES}") -keyout /etc/httpd/cert/mass/tbot.loc.key -subj '/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=tbot.loc/emailAddress=admin@tbot.loc' -out /etc/httpd/cert/mass/tbot.loc.csr
httpd_1  | $ openssl x509 -req -sha256 -extensions v3_req -extfile <(echo "[req]
httpd_1  | distinguished_name = req_distinguished_name
httpd_1  | x509_extensions = v3_req
httpd_1  |
httpd_1  | [req_distinguished_name]
httpd_1  |
httpd_1  | [ v3_req ]
httpd_1  | basicConstraints = critical, CA:FALSE
httpd_1  | subjectKeyIdentifier = hash
httpd_1  | keyUsage = critical, digitalSignature, keyEncipherment
httpd_1  | authorityKeyIdentifier = keyid:always,issuer:always
httpd_1  | extendedKeyUsage = serverAuth, clientAuth
httpd_1  | subjectAltName=${ALT_NAMES}") -days 825 -in /etc/httpd/cert/mass/tbot.loc.csr -CA /ca/devilbox-ca.crt -CAkey /ca/devilbox-ca.key -CAcreateserial -out /etc/httpd/cert/mass/tbot.loc.crt
httpd_1  | Certificate:
httpd_1  |     Data:
httpd_1  |         Version: 3 (0x2)
httpd_1  |         Serial Number:
httpd_1  |             2a:29:23:56:42:7d:a1:ee:9a:d0:0c:6a:92:e0:ab:04:88:fd:e4:55
httpd_1  |         Signature Algorithm: sha256WithRSAEncryption
httpd_1  |         Issuer: C = DE, ST = Berlin, L = Berlin, O = Devilbox, OU = Devilbox, CN = Devilbox Root CA, emailAddress = cytopia@devilbox.org, dnQualifier = cTZDjWzJ2nRzJTJ1SemsWBujY1g=
httpd_1  |         Validity
httpd_1  |             Not Before: Dec 30 13:16:11 2019 GMT
httpd_1  |             Not After : Apr  3 13:16:11 2022 GMT
httpd_1  |         Subject: C = DE, ST = Berlin, L = Berlin, O = Devilbox, OU = Devilbox, CN = tbot.loc, emailAddress = admin@tbot.loc
httpd_1  |         Subject Public Key Info:
httpd_1  |             Public Key Algorithm: rsaEncryption
httpd_1  |                 RSA Public-Key: (2048 bit)
httpd_1  |                 Modulus:
httpd_1  |                     00:ca:92:5b:6f:e8:18:30:5a:39:44:e1:32:1c:cb:
httpd_1  |                     03:5d:d4:8d:c9:83:92:9d:69:a5:98:b6:8f:67:14:
httpd_1  |                     1a:b4:12:cf:66:8b:05:a5:d7:a1:18:1b:8b:b2:3b:
httpd_1  |                     78:a1:80:b5:4c:89:af:6b:26:6b:a8:7c:e0:6a:76:
httpd_1  |                     90:83:8d:3f:a0:c4:48:cd:7c:2e:35:b6:30:ce:28:
httpd_1  |                     8b:fe:52:af:a0:6d:35:27:33:d5:78:e3:57:32:9d:
httpd_1  |                     94:15:e3:41:d9:56:1f:31:82:b7:04:7d:94:f1:3b:
httpd_1  |                     e4:4c:07:6b:76:77:a3:89:14:78:0e:ac:4f:39:4b:
httpd_1  |                     39:52:0d:03:dd:71:c1:25:b6:86:48:9f:4f:19:85:
httpd_1  |                     c6:22:cf:2d:63:72:2f:cd:70:cd:54:98:8e:fb:8a:
httpd_1  |                     27:ac:dc:45:ac:93:2b:cb:7c:e8:a2:76:b4:15:2f:
httpd_1  |                     ea:cf:4a:9d:ef:63:6c:3e:e0:9b:20:b8:67:1e:29:
httpd_1  |                     9d:00:17:e7:6e:c1:d0:a3:a7:00:a4:91:93:d2:fe:
httpd_1  |                     83:ca:bb:ae:89:51:54:b9:cb:4a:3c:76:f6:c7:37:
httpd_1  |                     78:7c:bd:91:92:44:5d:93:89:ba:ac:4a:9a:b9:45:
httpd_1  |                     bb:c4:33:a3:33:00:5f:fd:ea:a6:79:63:e1:42:6e:
httpd_1  |                     49:f5:8e:09:db:4d:0a:83:f9:2f:39:fc:a7:ed:6d:
httpd_1  |                     72:bf
httpd_1  |                 Exponent: 65537 (0x10001)
httpd_1  |         X509v3 extensions:
httpd_1  |             X509v3 Basic Constraints: critical
httpd_1  |                 CA:FALSE
httpd_1  |             X509v3 Subject Key Identifier:
httpd_1  |                 F2:C9:7A:49:1E:C8:3D:4E:42:28:C3:3E:7B:15:1C:E4:E0:53:DA:7C
httpd_1  |             X509v3 Key Usage: critical
httpd_1  |                 Digital Signature, Key Encipherment
httpd_1  |             X509v3 Authority Key Identifier:
httpd_1  |                 keyid:71:36:43:8D:6C:C9:DA:74:73:25:32:75:49:E9:AC:58:1B:A3:63:58
httpd_1  |                 DirName:/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=Devilbox Root CA/emailAddress=cytopia@devilbox.org/dnQualifier=cTZDjWzJ2nRzJTJ1SemsWBujY1g=
httpd_1  |                 serial:16:D0:D1:A5:C4:52:56:50:72:2A:87:C9:70:BB:11:C1:28:A6:36:DF
httpd_1  |
httpd_1  |             X509v3 Extended Key Usage:
httpd_1  |                 TLS Web Server Authentication, TLS Web Client Authentication
httpd_1  |             X509v3 Subject Alternative Name:
httpd_1  |                 DNS:tbot.loc, DNS:*.tbot.loc
httpd_1  |     Signature Algorithm: sha256WithRSAEncryption
httpd_1  |          18:48:c2:c6:de:cf:bb:de:04:3f:64:91:f3:a2:a0:0e:26:c0:
httpd_1  |          0a:65:7c:97:4a:81:08:c0:a8:f8:06:3c:b8:64:4c:5d:7f:71:
httpd_1  |          d4:54:2e:25:21:b2:b0:b7:f8:57:35:67:00:ba:7b:50:17:02:
httpd_1  |          f6:2f:8b:f7:55:41:78:8f:3f:6f:ee:68:cc:d3:00:88:c5:be:
httpd_1  |          52:a5:18:7e:28:5d:b1:52:1a:ed:df:41:98:2a:80:e6:3f:fa:
httpd_1  |          f7:59:25:4e:75:f1:0f:df:3d:28:a0:b8:21:70:af:3b:e5:a6:
httpd_1  |          c4:85:d6:ef:ef:38:d7:12:19:00:54:92:70:83:fa:48:b2:e7:
httpd_1  |          ce:19:b9:d2:4c:63:33:a0:62:f8:08:96:78:dc:74:71:23:49:
httpd_1  |          7e:7d:a2:de:eb:fa:c2:f6:2c:e8:12:5b:b4:4c:19:b3:e7:2e:
httpd_1  |          2c:c5:08:0c:05:19:1a:8d:67:09:92:0e:1c:d1:1b:62:75:99:
httpd_1  |          2d:91:ca:4b:c6:90:17:0f:10:06:a5:99:4c:0a:8e:27:9b:a3:
httpd_1  |          3f:aa:85:9c:38:fa:1f:c7:5c:e2:cf:40:f5:0a:2f:4c:9b:43:
httpd_1  |          2d:89:68:6a:65:d5:bb:c6:22:ca:78:07:b4:17:33:6a:f4:2e:
httpd_1  |          84:ef:47:49:a0:5b:bb:87:81:14:7b:c6:e9:8f:26:53:f7:00:
httpd_1  |          3c:1a:c0:67
httpd_1  | /etc/httpd/cert/mass/tbot.loc.crt: OK
httpd_1  | $ vhost_gen.py -p "/shared/httpd/tbot" -n "tbot" -c /etc/vhost-gen/mass.yml -o "/shared/httpd/tbot/.devilbox/" -s -v -m both
httpd_1  | [WARN] override template not found:  /shared/httpd/tbot/.devilbox/nginx.yml
httpd_1  | vhostgen: [2019-12-30 13:16:11] Adding: tbot.loc
httpd_1  | watcherd: [2019-12-30 13:16:11] [OK]  ADD: succeeded: /shared/httpd/tbot
httpd_1  | 2019/12/30 13:16:11 [notice] 237#237: signal process started
httpd_1  | watcherd: [2019-12-30 13:16:11] [OK]  TRIGGER succeeded: nginx -s stop
httpd_1  | watcherd: [2019-12-30 13:16:11] Using bash loop to watch for changes.
httpd_1  | 2019-12-30 13:16:11,412 INFO exited: httpd (exit status 0; expected)
httpd_1  | 2019-12-30 13:16:12,416 INFO spawned: 'httpd' with pid 254
httpd_1  | 2019-12-30 13:16:13,419 INFO success: httpd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
mysql_1  | 2019-12-30 18:22:20 42 [Warning] Aborted connection 42 to db: 'tbot' user: 'root' host: '172.16.238.10' (Got timeout reading communication packets)
mysql_1  | 2019-12-30 18:41:21 65 [Warning] Aborted connection 65 to db: 'tbot' user: 'root' host: '172.16.238.10' (Got timeout reading communication packets)
mysql_1  | 2019-12-30 19:09:01 70 [Warning] Aborted connection 70 to db: 'tbot' user: 'root' host: '172.16.238.10' (Got timeout reading communication packets)
cs16lover commented 4 years ago

Maybe its related or not but from some research on internet some people thought it can be related about wait_timeout value:

SHOW global VARIABLES LIKE "wait_timeout";

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 600   |
+---------------+-------+

And some possible advices for solutions: https://www.percona.com/blog/2016/05/16/mysql-got-an-error-reading-communication-packet-errors/

cytopia commented 4 years ago

@cs16lover I've let it for a very long time, but was unable to reproduce this behaviour. Do you have any other network issues (other Docker Compose stacks or on the host system)?

cs16lover commented 4 years ago

No. Its just mysql problem. I am accessing it through phpmyadmin and php-mysqli extension. Only it gave connection errors.

cytopia commented 4 years ago

@cs16lover

I did some more digging on it and it seems to be a more general issue:

1. Update the docker image

First of all, ensure that you have the latest MySQL/MariaDB/Percona images locally:

./update-docker.sh mysql

2. Adjust settings

What I've taken from the reading are the following MySQL/MariaDB/Percona settings that you should give a try:

[mysqld]
skip-name-resolve
connect_timeout = 600
net_read_timeout = 600
net_write_timeout = 600
max_allowed_packet = 256M

Here is how to configure the above settings: https://devilbox.readthedocs.io/en/latest/configuration-files/my-cnf.html

Afterwards, verify in web interface that those are actually applied: http://localhost/info_mysql.php

Please let me know how they work and I might add those as defaults.

cs16lover commented 4 years ago

I've updated mysql docker image, and also updates devilbox to git master version. Now I have a new problem (because of the new problem, I didn't have a chance to test mysql problem as its not coming up)

$ docker-compose up httpd php mysql
WARNING: The HOST_PATH_SSH_DIR variable is not set. Defaulting to a blank string.
Creating devilbox_bind_1 ... done
Creating devilbox_php_1  ... error

ERROR: for devilbox_php_1  Cannot create container for service php: create .: volume name is too short, names should be at least two alphanumeric characters

ERROR: for php  Cannot create container for service php: create .: volume name is too short, names should be at least two alphanumeric characters
ERROR: Encountered errors while bringing up the project.
cytopia commented 4 years ago

@cs16lover copy env-example over to .env there is a new option included that needs to be set.

https://devilbox.readthedocs.io/en/latest/maintenance/update-the-devilbox.html#keep-env-file-in-sync

mmalek06 commented 4 years ago

@cs16lover have you managed to solve the issue? I'm also struggling with that problem and what's funny, in my case it was working fine and then it stopped suddenly. I didn't change any settings, nor did I update docker or mysql...

stale[bot] commented 4 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] commented 4 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.