search

cytopia / devilbox

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

phpmyadmin-5.0.4 - service unavailable #839

Closed robots4life closed 2 years ago

robots4life commented 3 years ago

ISSUE TYPE

Checklist

OS / ENVIRONMENT

  1. Host operating system and version: 18.04
  2. (Windows only) Native Docker or Docker Toolbox:
  3. Docker version: Docker version 20.10.8, build 3967b7d
  4. Docker Compose version: docker-compose version 1.28.6, build 5db8d86f
  5. (Linux) Is SELinux enabled?: no
  6. What git commit hash are you on?: commit f6bbdc72fdc6b3a3b50ef0951b3e81f15de0c57f

SUMMARY

phpmyadmin-5.0.4 - service unavailable

STEPS TO REPRODUCE

Prune all old volumes, containers, images, etc. Fresh install of Devilbox. Go to localhost -> tools -> phpmyadmin -> sql -> 

Error in processing request
Error code: 503
Error text: Service Unavailable (rejected)
It seems that the connection to server has been lost. Please check your network connectivity and server status.

-> reload page -> white page

php-fpm.error

[02-Oct-2021 14:03:29] NOTICE: fpm is running, pid 1550
[02-Oct-2021 14:03:29] NOTICE: ready to handle connections
[02-Oct-2021 14:03:41] WARNING: [pool www] child 1697 exited on signal 11 (SIGSEGV - core dumped) after 7.913777 seconds from start
[02-Oct-2021 14:03:41] NOTICE: [pool www] child 1783 started
[02-Oct-2021 14:03:46] WARNING: [pool www] child 1659 exited on signal 11 (SIGSEGV - core dumped) after 13.868678 seconds from start
[02-Oct-2021 14:03:46] NOTICE: [pool www] child 1794 started
[02-Oct-2021 14:03:53] WARNING: [pool www] child 1783 exited on signal 11 (SIGSEGV - core dumped) after 12.486384 seconds from start
[02-Oct-2021 14:03:53] NOTICE: [pool www] child 1809 started
[02-Oct-2021 14:03:58 UTC] PHP Fatal error:  Uncaught TypeError: __TwigTemplate_6b8cc8afa4cbaa2d9e13b462d330f2838bdb54d2ef9b58c0d35ab27da9087edf::__construct(): Argument #1 ($env) must be of type Twig\Environment, Twig\Environment given, called in /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Environment.php on line 430 and defined in /tmp/twig/b0/b0db19a9939837a928c08ffbb2e4f1269378ae71831b7a179c53accf92ef6e53.php:21
Stack trace:
#0 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Environment.php(430): __TwigTemplate_6b8cc8afa4cbaa2d9e13b462d330f2838bdb54d2ef9b58c0d35ab27da9087edf->__construct(Object(Twig\Environment))
#1 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Environment.php(381): Twig\Environment->loadClass('__TwigTemplate_...', 'server/privileg...', NULL)
#2 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Environment.php(359): Twig\Environment->loadTemplate('server/privileg...')
#3 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Template.php(100): Twig\Environment->load('server/privileg...')
#4 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Template.php(134): PhpMyAdmin\Template->load('server/privileg...')
#5 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Server/Privileges.php(4730): PhpMyAdmin\Template->render('server/privileg...', Array)
#6 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Server/Privileges.php(3905): PhpMyAdmin\Server\Privileges->getAddUserHtmlFieldset()
#7 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Server/Privileges.php(3751): PhpMyAdmin\Server\Privileges->getFieldsetForAddDeleteUser()
#8 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Server/Privileges.php(4955): PhpMyAdmin\Server\Privileges->getUsersOverview(Object(mysqli_result), Array, './themes/pmahom...', 'ltr')
#9 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/server_privileges.php(463): PhpMyAdmin\Server\Privileges->getHtmlForUserOverview('./themes/pmahom...', 'ltr')
#10 {main}
  thrown in /tmp/twig/b0/b0db19a9939837a928c08ffbb2e4f1269378ae71831b7a179c53accf92ef6e53.php on line 21
[02-Oct-2021 14:04:05] WARNING: [pool www] child 1699 exited on signal 11 (SIGSEGV - core dumped) after 31.681160 seconds from start
[02-Oct-2021 14:04:05] NOTICE: [pool www] child 1832 started

EXPECTED BEHAVIOUR

Be able to use phpmyadmin

ACTUAL BEHAVIOUR

Cannot use phpmyadmin

OTHER INFORMATION

Start command

$ docker-compose up...

Outputs

$ ./check-config.sh

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

# ==============================================================================
# Checking .env file
# ==============================================================================
[SUCC]  .env file exists
[SUCC]  .env file is readable
[SUCC]  All variables are present in .env file
[SUCC]  No variables is duplicated in .env file

# ==============================================================================
# Checking .env file values
# ==============================================================================
[SUCC]  All .env file variables have correct values

# ==============================================================================
# Checking required Devilbox core directories exist
# ==============================================================================
[SUCC]  All PHP cfg/ sub directories are present
[SUCC]  All PHP log/ sub directories are present
[SUCC]  All PHP mod/ sub directories are present
[SUCC]  All HTTPD cfg/ sub directories are present
[SUCC]  All HTTPD log/ sub directories are present

# ==============================================================================
# Checking devilbox core directory permissions
# ==============================================================================
[SUCC]  All devilbox directories have correct permissions
[SUCC]  All devilbox directories have correct uid
[SUCC]  All devilbox directories have correct gid

# ==============================================================================
# Checking devilbox core file permissions
# ==============================================================================
[SUCC]  All devilbox files have correct permissions
[SUCC]  All devilbox files have correct uid
[SUCC]  All devilbox files have correct gid

# ==============================================================================
# Checking projects permissions
# ==============================================================================
[SUCC]  All project dirs have correct permissions
[SUCC]  All project dirs have correct uid
[SUCC]  All project dirs have correct gid

# ==============================================================================
# Checking projects settings
# ==============================================================================
[SUCC]  All projects have valid DNS records
[SUCC]  All projects have valid HTTPD_DOCROOT_DIR

# ==============================================================================
# Checking customizations
# ==============================================================================
[NOTE]  [docker]     Custom docker-compose.override.yml present
[NOTE]  [bash]      Custom script present in bash/

# ==============================================================================
# SUMMARY
# ==============================================================================
[SUCC]  Found no errors
[NOTE]  2 custom configurations applied. If you encounter issues, reset them first.
[INFO]  Ensure to run 'docker-compose stop; docker-compose rm -f' on .env changes or custom configs
$ docker-compose logs

Attaching to devilbox_memcd_1, devilbox_mongo_1, devilbox_pgsql_1, devilbox_mysql_1, devilbox_redis_1, devilbox_httpd_1, devilbox_php_1, devilbox_bind_1
httpd_1  | [INFO] Debug level: 2
httpd_1  | [INFO] Runtime debug: 2
httpd_1  | [INFO] Changing user 'daemon' uid to: 1000
httpd_1  | root $ usermod -u 1000 daemon
httpd_1  | root $ chown -R daemon /usr/sbin
httpd_1  | [INFO] Changing group 'daemon' gid to: 1000
httpd_1  | root $ groupmod -g 1000 daemon
httpd_1  | root $ chown -R :daemon /usr/sbin
httpd_1  | [INFO] Setting container timezone to: UTC
httpd_1  | root $ ln -sf /usr/share/zoneinfo/UTC /etc/localtime
httpd_1  | [INFO] Docker date set to: Sat Oct  2 14:15:43 UTC 2021
httpd_1  | [INFO] $DOCKER_LOGS disabled. Logging errors and access to log files inside container.
httpd_1  | [INFO] PHP 5.2 compatibility mode: Disabled
httpd_1  | [INFO] PHP-FPM: Enabled
httpd_1  | [INFO] PHP-FPM: Server address: 172.16.238.10
httpd_1  | [INFO] PHP-FPM: Server port: 9000
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
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] Disabling PHP 5.2 compat mode
httpd_1  | [INFO] vhost-gen: no customized template found
httpd_1  | root $ sed -i'' 's/__PHP_ENABLE__/yes/g' /etc/vhost-gen/main.yml
httpd_1  | root $ sed -i'' 's/__PHP_ADDR__/172.16.238.10/g' /etc/vhost-gen/main.yml
httpd_1  | root $ sed -i'' 's/__PHP_PORT__/9000/g' /etc/vhost-gen/main.yml
httpd_1  | root $ sed -i'' 's/__PHP_TIMEOUT__/180/g' /etc/vhost-gen/main.yml
httpd_1  | root $ sed -i'' 's/__PHP_ENABLE__/yes/g' /etc/vhost-gen/mass.yml
httpd_1  | root $ sed -i'' 's/__PHP_ADDR__/172.16.238.10/g' /etc/vhost-gen/mass.yml
httpd_1  | root $ sed -i'' 's/__PHP_PORT__/9000/g' /etc/vhost-gen/mass.yml
httpd_1  | root $ sed -i'' 's/__PHP_TIMEOUT__/180/g' /etc/vhost-gen/mass.yml
httpd_1  | root $ sed -i'' 's/__DOCKER_LOGS_ERROR__/no/g' /etc/vhost-gen/main.yml
httpd_1  | root $ sed -i'' 's/__DOCKER_LOGS_ACCESS__/no/g' /etc/vhost-gen/main.yml
httpd_1  | root $ sed -i'' 's/__DOCKER_LOGS_ERROR__/no/g' /etc/vhost-gen/mass.yml
httpd_1  | root $ sed -i'' 's/__DOCKER_LOGS_ACCESS__/no/g' /etc/vhost-gen/mass.yml
httpd_1  | root $ sed -i'' 's|__ENABLE_STATUS__|yes|g' /etc/vhost-gen/main.yml
httpd_1  | root $ sed -i'' 's|__STATUS_ALIAS__|/devilbox-httpd-status|g' /etc/vhost-gen/main.yml
httpd_1  | root $ vhost-gen -n localhost -p /var/www/default/htdocs -c /etc/vhost-gen/main.yml -o /var/www/default/cfg -v -d -s -m both
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Loading configuration file        (-c): /etc/vhost-gen/main.yml
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Loading vhost template (global)   (-t): /etc/vhost-gen/templates/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Loading vhost template (override) (-o): /var/www/default/cfg/apache24.yml
httpd_1  | vhost-gen: [WARN]  (2021-10-02 14:15:44): Override Vhost template not found: /var/www/default/cfg/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Creating vhost type: https and http (both)
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Using vhost name: localhost
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Log setting: dir -> True
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Log setting: Not specified
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:44): Vhost config written to: /etc/httpd/conf.d/localhost.conf
httpd_1  | root $ sed -i'' 's|__DOCROOT_SUFFIX__|htdocs|g' /etc/vhost-gen/mass.yml
httpd_1  | root $ sed -i'' 's/__TLD__/.loc/g' /etc/vhost-gen/mass.yml
httpd_1  | root $ cert-gen -v -c DE -s Berlin -l Berlin -o Devilbox -u Devilbox -n 'localhost' -e 'admin@localhost' -a 'localhost *.localhost devilbox *.devilbox httpd' /ca/devilbox-ca.key /ca/devilbox-ca.crt /etc/httpd/cert/main/localhost.key /etc/httpd/cert/main/localhost.csr /etc/httpd/cert/main/localhost.crt
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
bind_1   | [INFO] Debug level: 2
bind_1   | [INFO] BIND logging: disabled explicitly
bind_1   | [INFO] Using default DNS TTL time: 3600 sec
bind_1   | [INFO] Using default DNS Refresh time: 1200 sec
bind_1   | [INFO] Using default DNS Retry time: 180 sec
bind_1   | [INFO] Using default DNS Expiry time: 1209600 sec
bind_1   | [INFO] Using default DNS Max Cache time: 10800 sec
bind_1   | [INFO] Adding wildcard DNS: *.loc -> 127.0.0.1
bind_1   | 
bind_1   | zone loc/IN: loaded serial 1633184142
bind_1   | OK
bind_1   | [INFO] Not adding any extra hosts
bind_1   | [INFO] DNSSEC Validation: no
bind_1   | [INFO] Adding custom DNS forwarder: 8.8.8.8,8.8.4.4
bind_1   | [INFO] Starting BIND 9.11.3
httpd_1  | Certificate:
httpd_1  |     Data:
httpd_1  |         Version: 3 (0x2)
httpd_1  |         Serial Number:
httpd_1  |             20:e1:5e:a3:fc:70:7d:d8:ed:bd:d8:fd:10:e6:af:47:6b:e4:ec:c0
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 = ZkIj5od0qhwhn6BEwKZsGT2vBh4=
httpd_1  |         Validity
httpd_1  |             Not Before: Oct  2 14:15:44 2021 GMT
httpd_1  |             Not After : Jan  5 14:15:44 2024 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:db:7b:b1:6c:b7:44:33:90:89:a0:be:ae:b8:68:
httpd_1  |                     2e:95:77:a4:a5:2b:f2:c5:92:26:a5:31:74:db:81:
httpd_1  |                     39:a3:59:24:6f:8f:23:ac:0f:35:ad:c4:aa:28:5b:
httpd_1  |                     a6:fc:42:d3:d6:80:f6:9e:cf:9f:79:d0:54:ed:57:
httpd_1  |                     dc:4f:b7:dd:95:f1:00:d6:6a:48:bc:14:3a:0b:50:
httpd_1  |                     d1:24:9d:5c:4a:7e:5b:03:32:d1:b6:02:b3:c8:80:
httpd_1  |                     ac:e2:02:b0:a6:f3:d4:a0:7d:7a:2d:46:27:b9:16:
httpd_1  |                     2c:ec:20:e8:13:73:b7:06:81:e0:65:64:1f:64:fb:
httpd_1  |                     00:8a:db:46:6a:c3:ad:21:28:64:e4:89:81:90:d5:
httpd_1  |                     69:b0:18:f1:77:0d:14:42:19:5b:c4:ac:c0:c2:e4:
httpd_1  |                     b7:02:8a:d6:35:ca:63:82:2c:d6:15:c4:10:f1:24:
httpd_1  |                     8d:c5:3c:5f:f0:d3:15:37:4d:eb:f2:af:21:31:3f:
httpd_1  |                     3f:91:7c:a6:ce:77:94:34:fa:05:d2:8c:a1:f6:eb:
httpd_1  |                     8d:26:67:3a:5a:1d:fb:ca:c5:63:fc:a0:26:9a:ed:
httpd_1  |                     4a:f5:a5:ea:42:a4:7e:96:4d:67:5c:6f:3e:5c:aa:
httpd_1  |                     07:10:ce:c3:b9:78:23:5a:26:7e:3b:ab:bd:bb:8b:
httpd_1  |                     ab:8a:6a:91:67:02:92:72:5a:f4:1e:5c:02:5c:b0:
httpd_1  |                     99:a1
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  |                 E7:42:F4:0D:E8:B5:23:02:15:62:6D:3F:EA:B3:82:00:26:A5:97:29
httpd_1  |             X509v3 Key Usage: critical
httpd_1  |                 Digital Signature, Key Encipherment
httpd_1  |             X509v3 Authority Key Identifier: 
httpd_1  |                 keyid:66:42:23:E6:87:74:AA:1C:21:9F:A0:44:C0:A6:6C:19:3D:AF:06:1E
httpd_1  |                 DirName:/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=Devilbox Root CA/emailAddress=cytopia@devilbox.org/dnQualifier=ZkIj5od0qhwhn6BEwKZsGT2vBh4=
httpd_1  |                 serial:5B:FB:9F:7B:CA:39:11:A2:BF:4F:5F:C3:76:3F:B7:1D:09:7B:60:75
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  |          98:c7:61:9a:b9:95:82:62:35:22:6b:40:c6:1a:41:5d:eb:7b:
httpd_1  |          53:06:4d:30:4c:f0:1f:2f:0d:3d:5d:32:b6:d9:f9:2a:14:29:
httpd_1  |          4b:d6:c5:7b:c3:df:82:6f:50:7c:2d:5c:d2:95:d3:ef:30:c2:
httpd_1  |          7f:d1:4f:c8:74:a6:6b:f9:97:18:1d:89:27:f3:50:a3:05:61:
httpd_1  |          14:75:e0:e8:51:fb:7f:fb:ff:a9:19:27:dc:f7:c6:a0:0f:56:
httpd_1  |          c1:5a:c1:7f:2f:3b:e9:d4:e3:45:a0:c5:df:d4:9c:77:ab:00:
httpd_1  |          9f:b3:c5:36:84:27:f0:3f:5b:31:23:98:e2:8d:3b:97:f0:e3:
httpd_1  |          e9:cd:17:79:2a:9f:7a:75:a0:1f:90:72:8e:af:7e:24:12:63:
httpd_1  |          7b:c2:8d:07:ea:25:8d:33:74:6a:52:34:fa:32:83:85:41:4f:
httpd_1  |          b9:71:af:7f:4c:21:2d:01:a7:43:5c:29:b6:c3:44:e9:66:22:
httpd_1  |          5b:5e:4c:8e:72:f4:3f:94:19:33:62:61:11:2f:d7:c5:7f:8b:
httpd_1  |          a2:43:30:7e:da:82:4e:98:76:07:8d:56:ec:81:ca:76:1e:21:
httpd_1  |          9c:18:c2:5c:4b:76:bc:03:35:03:d2:21:84:f8:60:53:b0:db:
httpd_1  |          8c:41:99:3c:fc:5c:88:8e:78:36:f6:14:d4:d5:92:71:ff:3a:
httpd_1  |          70:32:18:56
httpd_1  | /etc/httpd/cert/main/localhost.crt: OK
httpd_1  | root $ chown -R 1000:1000 /ca
httpd_1  | [INFO] Starting supervisord: 3.3.5
httpd_1  | 2021-10-02 14:15:44,614 INFO Set uid to user 0 succeeded
httpd_1  | 2021-10-02 14:15:44,615 INFO supervisord started with pid 1
httpd_1  | 2021-10-02 14:15:45,617 INFO spawned: 'httpd' with pid 228
httpd_1  | 2021-10-02 14:15:45,619 INFO spawned: 'watcherd' with pid 229
httpd_1  | [Sat Oct 02 14:15:45.662603 2021] [mpm_event:notice] [pid 228:tid 140089893872768] AH00489: Apache/2.4.46 (Unix) OpenSSL/1.1.1d configured -- resuming normal operations
httpd_1  | [Sat Oct 02 14:15:45.662718 2021] [core:notice] [pid 228:tid 140089893872768] AH00094: Command line: 'httpd -D FOREGROUND'
httpd_1  | 2021-10-02 14:15:46,664 INFO success: httpd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
httpd_1  | 2021-10-02 14:15:46,664 INFO success: watcherd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
httpd_1  | watcherd: [2021-10-02 14:15:48] Starting daemon.
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/xyz.loc.key -subj '/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=xyz.loc/emailAddress=admin@xyz.loc' -out /etc/httpd/cert/mass/xyz.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/xyz.loc.csr -CA /ca/devilbox-ca.crt -CAkey /ca/devilbox-ca.key -CAcreateserial -out /etc/httpd/cert/mass/xyz.loc.crt
httpd_1  | Certificate:
httpd_1  |     Data:
httpd_1  |         Version: 3 (0x2)
httpd_1  |         Serial Number:
httpd_1  |             20:e1:5e:a3:fc:70:7d:d8:ed:bd:d8:fd:10:e6:af:47:6b:e4:ec:c1
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 = ZkIj5od0qhwhn6BEwKZsGT2vBh4=
httpd_1  |         Validity
httpd_1  |             Not Before: Oct  2 14:15:48 2021 GMT
httpd_1  |             Not After : Jan  5 14:15:48 2024 GMT
httpd_1  |         Subject: C = DE, ST = Berlin, L = Berlin, O = Devilbox, OU = Devilbox, CN = xyz.loc, emailAddress = admin@xyz.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:d4:18:17:06:58:00:e3:eb:2e:35:6d:79:6d:10:
httpd_1  |                     e7:bc:ec:9b:3a:f4:8d:71:59:4e:71:9a:b8:ae:ae:
httpd_1  |                     4d:c0:99:e6:bb:c4:a9:56:92:03:5e:f1:9a:3a:1b:
httpd_1  |                     54:36:ca:58:93:91:b6:ee:78:1a:4f:7d:f8:5f:f6:
httpd_1  |                     5e:e8:8a:04:fb:f9:ef:13:66:d5:7e:3e:3b:0c:4f:
httpd_1  |                     33:29:81:47:b1:ba:fe:6d:77:39:4e:6c:4f:cf:b5:
httpd_1  |                     5f:af:c6:4b:a5:10:62:ff:ae:83:20:2a:ec:0a:71:
httpd_1  |                     7b:1a:e8:9b:81:47:37:1c:93:b9:83:ca:26:83:53:
httpd_1  |                     ac:6a:9a:cd:79:86:a2:23:fe:6e:41:37:1c:25:49:
mysql_1  | 2021-10-02 14:15:44+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.
mysql_1  | 2021-10-02 14:15:44+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1  | 2021-10-02 14:15:44+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.22-1debian10 started.
mysql_1  | 2021-10-02T14:15:44.799515Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.22) starting as process 1
mysql_1  | 2021-10-02T14:15:44.810063Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql_1  | 2021-10-02T14:15:44.985238Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql_1  | 2021-10-02T14:15:45.110664Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
mysql_1  | 2021-10-02T14:15:45.170357Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql_1  | 2021-10-02T14:15:45.170605Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql_1  | 2021-10-02T14:15:45.175296Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1  | 2021-10-02T14:15:45.199784Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.22'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
mysql_1  | mbind: Operation not permitted
mysql_1  | mbind: Operation not permitted
mysql_1  | mbind: Operation not permitted
mysql_1  | mbind: Operation not permitted
httpd_1  |                     5e:fa:7c:05:ba:6d:90:34:4b:4b:8a:2e:3a:ad:46:
httpd_1  |                     69:2a:db:e2:e3:2c:be:02:b0:89:8e:f4:dc:95:e6:
httpd_1  |                     e8:a8:74:b0:2e:84:f9:ea:07:3c:36:11:45:97:6f:
httpd_1  |                     b9:b6:18:6e:cf:32:4d:ea:6e:fe:a5:a3:8f:34:ed:
httpd_1  |                     55:6f:c9:17:9e:4e:8d:4e:d3:52:68:3f:b7:32:5b:
httpd_1  |                     6b:24:c7:6a:88:2c:e2:12:93:25:b6:1e:7d:62:cc:
httpd_1  |                     4c:cc:88:35:17:b8:bf:6e:10:d9:e3:02:2f:19:c9:
httpd_1  |                     b1:f5:bc:93:94:87:e4:75:a7:03:09:3d:95:6a:55:
httpd_1  |                     4c:07
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  |                 F0:1C:0D:7C:C8:E3:66:50:CF:4B:65:7D:90:6A:2C:FD:96:21:5F:BF
httpd_1  |             X509v3 Key Usage: critical
httpd_1  |                 Digital Signature, Key Encipherment
httpd_1  |             X509v3 Authority Key Identifier: 
httpd_1  |                 keyid:66:42:23:E6:87:74:AA:1C:21:9F:A0:44:C0:A6:6C:19:3D:AF:06:1E
httpd_1  |                 DirName:/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=Devilbox Root CA/emailAddress=cytopia@devilbox.org/dnQualifier=ZkIj5od0qhwhn6BEwKZsGT2vBh4=
httpd_1  |                 serial:5B:FB:9F:7B:CA:39:11:A2:BF:4F:5F:C3:76:3F:B7:1D:09:7B:60:75
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:xyz.loc, DNS:*.xyz.loc
httpd_1  |     Signature Algorithm: sha256WithRSAEncryption
httpd_1  |          0b:f4:79:d3:c1:63:ae:a0:e6:a0:6e:ba:ac:5a:46:98:6e:cb:
httpd_1  |          7a:15:36:d3:59:fd:42:87:0d:c7:71:54:8a:c4:25:c6:2c:cf:
httpd_1  |          47:4f:2e:fe:64:c7:f2:21:b8:1f:9b:1e:4d:43:ca:73:f9:29:
httpd_1  |          d8:a8:5b:d7:9f:2f:c2:6c:8d:da:a5:48:6a:2e:69:46:8d:51:
httpd_1  |          bc:65:aa:34:73:1a:ac:71:d3:61:f1:75:a2:63:67:21:39:03:
httpd_1  |          fa:86:1b:dd:fc:86:41:78:ba:80:e5:e6:07:0a:8c:72:48:84:
httpd_1  |          62:54:93:32:1c:4c:f9:68:3a:e5:82:47:c0:7c:be:79:06:06:
httpd_1  |          37:2c:ed:f2:2d:ef:ed:75:b8:35:34:07:94:1f:a1:ee:af:77:
httpd_1  |          0f:19:fb:d4:75:44:03:81:d5:4a:1a:94:60:32:12:16:62:ff:
httpd_1  |          a3:99:9f:1a:2f:81:d4:3b:c3:4f:90:16:ef:97:6c:30:f3:23:
httpd_1  |          ba:ec:81:7e:eb:90:af:43:00:1e:94:e6:05:50:97:08:7c:7f:
httpd_1  |          be:69:85:7f:d6:f2:99:ec:b4:be:68:cf:fe:b2:df:f8:a3:16:
httpd_1  |          8a:b2:52:87:a3:17:e9:3b:5a:99:bc:d7:8e:1e:52:37:3f:6e:
httpd_1  |          e1:a8:b6:b0:84:56:90:23:c6:f7:b3:2c:4c:94:71:b7:f8:6a:
httpd_1  |          9a:4c:30:ce
httpd_1  | /etc/httpd/cert/mass/xyz.loc.crt: OK
httpd_1  | $ vhost-gen -p "/shared/httpd/xyz" -n "xyz" -c /etc/vhost-gen/mass.yml -o "/shared/httpd/xyz/.devilbox/" -s -v -m both
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Loading configuration file        (-c): /etc/vhost-gen/mass.yml
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Loading vhost template (global)   (-t): /etc/vhost-gen/templates/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Loading vhost template (override) (-o): /shared/httpd/xyz/.devilbox/apache24.yml
httpd_1  | vhost-gen: [WARN]  (2021-10-02 14:15:48): Override Vhost template not found: /shared/httpd/xyz/.devilbox/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Creating vhost type: https and http (both)
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Using vhost name: xyz.loc
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Log setting: dir -> True
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Log setting: Not specified
httpd_1  | vhost-gen: [INFO]  (2021-10-02 14:15:48): Vhost config written to: /etc/httpd/vhost.d/xyz.conf
httpd_1  | watcherd: [2021-10-02 14:15:48] [OK]  ADD: succeeded: /shared/httpd/xyz
httpd_1  | watcherd: [2021-10-02 14:15:48] [OK]  TRIGGER succeeded: /usr/local/apache2/bin/httpd -k stop
httpd_1  | watcherd: [2021-10-02 14:15:48] Using bash loop to watch for changes.
httpd_1  | [Sat Oct 02 14:15:48.925990 2021] [mpm_event:notice] [pid 228:tid 140089893872768] AH00491: caught SIGTERM, shutting down
httpd_1  | 2021-10-02 14:15:48,937 INFO exited: httpd (exit status 0; expected)
httpd_1  | 2021-10-02 14:15:49,942 INFO spawned: 'httpd' with pid 493
httpd_1  | [Sat Oct 02 14:15:50.001262 2021] [mpm_event:notice] [pid 493:tid 140531971085440] AH00489: Apache/2.4.46 (Unix) OpenSSL/1.1.1d configured -- resuming normal operations
httpd_1  | [Sat Oct 02 14:15:50.001395 2021] [core:notice] [pid 493:tid 140531971085440] AH00094: Command line: 'httpd -D FOREGROUND'
httpd_1  | 2021-10-02 14:15:51,002 INFO success: httpd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
pgsql_1  | 
pgsql_1  | PostgreSQL Database directory appears to contain a database; Skipping initialization
pgsql_1  | 
pgsql_1  | 2021-10-02 14:15:45.468 UTC [1] LOG:  starting PostgreSQL 12.4 (Debian 12.4-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
pgsql_1  | 2021-10-02 14:15:45.468 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
pgsql_1  | 2021-10-02 14:15:45.468 UTC [1] LOG:  listening on IPv6 address "::", port 5432
pgsql_1  | 2021-10-02 14:15:45.473 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
pgsql_1  | 2021-10-02 14:15:45.496 UTC [25] LOG:  database system was shut down at 2021-10-02 14:11:07 UTC
pgsql_1  | 2021-10-02 14:15:45.502 UTC [1] LOG:  database system is ready to accept connections
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.519+00:00"},"s":"I",  "c":"CONTROL",  "id":23285,   "ctx":"main","msg":"Automatically disabling TLS 1.0, to force-enable TLS 1.0 specify --sslDisabledProtocols 'none'"}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.523+00:00"},"s":"W",  "c":"ASIO",     "id":22601,   "ctx":"main","msg":"No TransportLayer configured during NetworkInterface startup"}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.523+00:00"},"s":"I",  "c":"NETWORK",  "id":4648601, "ctx":"main","msg":"Implicit TCP FastOpen unavailable. If TCP FastOpen is required, set tcpFastOpenServer, tcpFastOpenClient, and tcpFastOpenQueueSize."}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.523+00:00"},"s":"I",  "c":"STORAGE",  "id":4615611, "ctx":"initandlisten","msg":"MongoDB starting","attr":{"pid":1,"port":27017,"dbPath":"/data/db","architecture":"64-bit","host":"mongo"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.523+00:00"},"s":"I",  "c":"CONTROL",  "id":23403,   "ctx":"initandlisten","msg":"Build Info","attr":{"buildInfo":{"version":"4.4.9","gitVersion":"b4048e19814bfebac717cf5a880076aa69aba481","openSSLVersion":"OpenSSL 1.1.1f  31 Mar 2020","modules":[],"allocator":"tcmalloc","environment":{"distmod":"ubuntu2004","distarch":"x86_64","target_arch":"x86_64"}}}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.523+00:00"},"s":"I",  "c":"CONTROL",  "id":51765,   "ctx":"initandlisten","msg":"Operating System","attr":{"os":{"name":"Ubuntu","version":"20.04"}}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.523+00:00"},"s":"I",  "c":"CONTROL",  "id":21951,   "ctx":"initandlisten","msg":"Options set by command line","attr":{"options":{"net":{"bindIp":"*"}}}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.525+00:00"},"s":"I",  "c":"STORAGE",  "id":22270,   "ctx":"initandlisten","msg":"Storage engine to use detected by data files","attr":{"dbpath":"/data/db","storageEngine":"wiredTiger"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.525+00:00"},"s":"I",  "c":"STORAGE",  "id":22297,   "ctx":"initandlisten","msg":"Using the XFS filesystem is strongly recommended with the WiredTiger storage engine. See http://dochub.mongodb.org/core/prodnotes-filesystem","tags":["startupWarnings"]}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:44.525+00:00"},"s":"I",  "c":"STORAGE",  "id":22315,   "ctx":"initandlisten","msg":"Opening WiredTiger","attr":{"config":"create,cache_size=7442M,session_max=33000,eviction=(threads_min=4,threads_max=4),config_base=false,statistics=(fast),log=(enabled=true,archive=true,path=journal,compressor=snappy),file_manager=(close_idle_time=100000,close_scan_interval=10,close_handle_minimum=250),statistics_log=(wait=0),verbose=[recovery_progress,checkpoint_progress,compact_progress],"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.023+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:23513][1:0x7f4c981edcc0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 7 through 8"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.065+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:65026][1:0x7f4c981edcc0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 8 through 8"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.139+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:139340][1:0x7f4c981edcc0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Main recovery loop: starting at 7/5120 to 8/256"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.230+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:230710][1:0x7f4c981edcc0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 7 through 8"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.284+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:284080][1:0x7f4c981edcc0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 8 through 8"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.331+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:331450][1:0x7f4c981edcc0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Set global recovery timestamp: (0, 0)"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.331+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:331509][1:0x7f4c981edcc0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Set global oldest timestamp: (0, 0)"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.335+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1633184145:335499][1:0x7f4c981edcc0], WT_SESSION.checkpoint: [WT_VERB_CHECKPOINT_PROGRESS] saving checkpoint snapshot min: 1, snapshot max: 1 snapshot count: 0, oldest timestamp: (0, 0) , meta checkpoint timestamp: (0, 0) base write gen: 145"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.347+00:00"},"s":"I",  "c":"STORAGE",  "id":4795906, "ctx":"initandlisten","msg":"WiredTiger opened","attr":{"durationMillis":822}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.347+00:00"},"s":"I",  "c":"RECOVERY", "id":23987,   "ctx":"initandlisten","msg":"WiredTiger recoveryTimestamp","attr":{"recoveryTimestamp":{"$timestamp":{"t":0,"i":0}}}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.352+00:00"},"s":"I",  "c":"STORAGE",  "id":4366408, "ctx":"initandlisten","msg":"No table logging settings modifications are required for existing WiredTiger tables","attr":{"loggingEnabled":true}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.356+00:00"},"s":"I",  "c":"STORAGE",  "id":22262,   "ctx":"initandlisten","msg":"Timestamp monitor starting"}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.363+00:00"},"s":"W",  "c":"CONTROL",  "id":22120,   "ctx":"initandlisten","msg":"Access control is not enabled for the database. Read and write access to data and configuration is unrestricted","tags":["startupWarnings"]}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.367+00:00"},"s":"I",  "c":"STORAGE",  "id":20536,   "ctx":"initandlisten","msg":"Flow Control is enabled on this deployment"}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.371+00:00"},"s":"I",  "c":"FTDC",     "id":20625,   "ctx":"initandlisten","msg":"Initializing full-time diagnostic data capture","attr":{"dataDirectory":"/data/db/diagnostic.data"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.373+00:00"},"s":"I",  "c":"NETWORK",  "id":23015,   "ctx":"listener","msg":"Listening on","attr":{"address":"/tmp/mongodb-27017.sock"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.373+00:00"},"s":"I",  "c":"NETWORK",  "id":23015,   "ctx":"listener","msg":"Listening on","attr":{"address":"0.0.0.0"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:45.373+00:00"},"s":"I",  "c":"NETWORK",  "id":23016,   "ctx":"listener","msg":"Waiting for connections","attr":{"port":27017,"ssl":"off"}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:51.406+00:00"},"s":"I",  "c":"NETWORK",  "id":22943,   "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.16.238.10:46676","connectionId":1,"connectionCount":1}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:51.406+00:00"},"s":"I",  "c":"NETWORK",  "id":51800,   "ctx":"conn1","msg":"client metadata","attr":{"remote":"172.16.238.10:46676","client":"conn1","doc":{"driver":{"name":"mongoc / ext-mongodb:PHP ","version":"1.17.4 / 1.9.1 "},"os":{"type":"Linux","name":"Debian GNU/Linux","version":"10","architecture":"x86_64"},"platform":"PHP 8.1.0-dev cfg=0x03d156a8e9 posix=200809 stdc=201710 CC=GCC 8.3.0 CFLAGS=\"\" LDFLAGS=\"\""}}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:51.444+00:00"},"s":"I",  "c":"NETWORK",  "id":22943,   "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.16.238.10:46718","connectionId":2,"connectionCount":2}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:51.444+00:00"},"s":"I",  "c":"NETWORK",  "id":51800,   "ctx":"conn2","msg":"client metadata","attr":{"remote":"172.16.238.10:46718","client":"conn2","doc":{"driver":{"name":"mongoc / ext-mongodb:PHP ","version":"1.17.4 / 1.9.1 "},"os":{"type":"Linux","name":"Debian GNU/Linux","version":"10","architecture":"x86_64"},"platform":"PHP 8.1.0-dev cfg=0x03d156a8e9 posix=200809 stdc=201710 CC=GCC 8.3.0 CFLAGS=\"\" LDFLAGS=\"\""}}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:51.446+00:00"},"s":"I",  "c":"NETWORK",  "id":22943,   "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.16.238.10:46722","connectionId":3,"connectionCount":3}}
mongo_1  | {"t":{"$date":"2021-10-02T14:15:51.446+00:00"},"s":"I",  "c":"NETWORK",  "id":51800,   "ctx":"conn3","msg":"client metadata","attr":{"remote":"172.16.238.10:46722","client":"conn3","doc":{"driver":{"name":"mongoc / ext-mongodb:PHP ","version":"1.17.4 / 1.9.1 "},"os":{"type":"Linux","name":"Debian GNU/Linux","version":"10","architecture":"x86_64"},"platform":"PHP 8.1.0-dev cfg=0x03d156a8e9 posix=200809 stdc=201710 CC=GCC 8.3.0 CFLAGS=\"\" LDFLAGS=\"\""}}}
mongo_1  | {"t":{"$date":"2021-10-02T14:16:08.955+00:00"},"s":"I",  "c":"NETWORK",  "id":22944,   "ctx":"conn3","msg":"Connection ended","attr":{"remote":"172.16.238.10:46722","connectionId":3,"connectionCount":2}}
mongo_1  | {"t":{"$date":"2021-10-02T14:16:08.956+00:00"},"s":"I",  "c":"NETWORK",  "id":22944,   "ctx":"conn2","msg":"Connection ended","attr":{"remote":"172.16.238.10:46718","connectionId":2,"connectionCount":1}}
mongo_1  | {"t":{"$date":"2021-10-02T14:16:08.958+00:00"},"s":"I",  "c":"NETWORK",  "id":22944,   "ctx":"conn1","msg":"Connection ended","attr":{"remote":"172.16.238.10:46676","connectionId":1,"connectionCount":0}}
mongo_1  | {"t":{"$date":"2021-10-02T14:16:45.358+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"WTCheckpointThread","msg":"WiredTiger message","attr":{"message":"[1633184205:358141][1:0x7f4c911de700], WT_SESSION.checkpoint: [WT_VERB_CHECKPOINT_PROGRESS] saving checkpoint snapshot min: 3, snapshot max: 3 snapshot count: 0, oldest timestamp: (0, 0) , meta checkpoint timestamp: (0, 0) base write gen: 145"}}
redis_1  | 1:C 02 Oct 2021 14:15:44.365 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1  | 1:C 02 Oct 2021 14:15:44.365 # Redis version=6.0.15, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1  | 1:C 02 Oct 2021 14:15:44.365 # Warning: no config file specified, using the default config. In order to specify a config file use redis-server /path/to/redis.conf
redis_1  | 1:M 02 Oct 2021 14:15:44.367 * Running mode=standalone, port=6379.
redis_1  | 1:M 02 Oct 2021 14:15:44.367 # Server initialized
redis_1  | 1:M 02 Oct 2021 14:15:44.367 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. 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.
redis_1  | 1:M 02 Oct 2021 14:15:44.367 * Ready to accept connections
php_1    | [INFO] Debug level: 2
php_1    | [INFO] Changing user 'devilbox' uid to: 1000
php_1    | root $ usermod -u 1000 devilbox 2>/dev/null
php_1    | root $ chown -R devilbox /home/devilbox 2>/dev/null || true
php_1    | root $ chown -R devilbox /var/lib/php/session
php_1    | root $ chown -R devilbox /var/lib/php/wsdlcache
php_1    | root $ chown -R devilbox /var/spool/mail/devilbox
php_1    | root $ chown -R devilbox /etc/supervisor/custom.d
php_1    | [INFO] Changing group 'devilbox' gid to: 1000
php_1    | root $ groupmod -g 1000 devilbox 2>/dev/null
php_1    | root $ chown -R :devilbox /home/devilbox 2>/dev/null || true
php_1    | root $ chown -R :devilbox /var/lib/php/session
php_1    | root $ chown -R :devilbox /var/lib/php/wsdlcache
php_1    | root $ chown -R :devilbox /var/spool/mail/devilbox
php_1    | root $ chown -R :devilbox /etc/supervisor/custom.d
php_1    | [INFO] Setting container timezone to: UTC
php_1    | root $ ln -sf /usr/share/zoneinfo/UTC /etc/localtime
php_1    | [INFO] Setting PHP: timezone=UTC
php_1    | root $ echo 'date.timezone = UTC' > /usr/local/etc/php/conf.d/devilbox-runtime-timezone.ini
php_1    | [INFO] Docker date set to: Sat Oct  2 14:15:43 UTC 2021
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    | root $ touch /var/log/php/php-fpm.access
php_1    | root $ touch /var/log/php/php-fpm.error
php_1    | root $ chown -R devilbox:devilbox /var/log/php
php_1    | root $ chmod 0755 /var/log/php
php_1    | [INFO] $ENABLE_MAIL set to 2. Enabling postfix catch-all
php_1    | root $ touch /var/log/php/mail.log
php_1    | root $ chown devilbox:devilbox /var/log/php
php_1    | root $ chown devilbox:devilbox /var/log/php/mail.log
php_1    | root $ chmod 0644 /var/log/php/mail.log
php_1    | root $ chmod 0644 /var/mail/devilbox
php_1    | root $ chown devilbox:devilbox /var/mail
php_1    | root $ chown devilbox:devilbox /var/mail/devilbox
php_1    | root $ postconf -e 'strict_mailbox_ownership=no'
php_1    | root $ postconf -e 'inet_protocols=ipv4'
php_1    | root $ postconf -e 'virtual_alias_maps=pcre:/etc/postfix/virtual'
php_1    | root $ echo '/.*@.*/ devilbox' >> /etc/postfix/virtual
php_1    | root $ newaliases
php_1    | [INFO] Forwarding httpd:80 to 127.0.0.1:80 inside this docker.
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.
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
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    | root $ find /usr/local/etc/php/conf.d -type f -iname '*.ini' -exec chmod 0644 "{}" \;
php_1    | root $ find /usr/local/etc/php-fpm.d -type f -iname '*.conf' -exec chmod 0644 "{}" \;
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    | root $ rm /usr/local/etc/php/conf.d/docker-php-ext-oci8.ini
php_1    | root $ chown devilbox:devilbox /etc/mysqldump-secure.conf
php_1    | root $ chown devilbox:devilbox /etc/mysqldump-secure.cnf
php_1    | root $ chown devilbox:devilbox /var/log/mysqldump-secure.log
php_1    | root $ chown devilbox:devilbox /shared/backups/mysql
php_1    | [INFO] $MYSQL_BACKUP_USER set for mysqldump-secure. Changing to 'root'
php_1    | root $ sed -i'' 's/^user.*/user = root/g' /etc/mysqldump-secure.cnf
php_1    | [INFO] $MYSQL_BACKUP_PASS set for mysqldump-secure. Changing to '******'
php_1    | root $ perl -pi -e 's/^password.*/password = /g' /etc/mysqldump-secure.cnf
php_1    | [INFO] $MYSQL_BACKUP_HOST set for mysqldump-secure. Changing to 'mysql'
php_1    | root $ sed -i'' 's/^host.*/host = mysql/g' /etc/mysqldump-secure.cnf
php_1    | root $ chown devilbox:devilbox /shared/backups
php_1    | root $ chown devilbox:devilbox /shared/httpd
php_1    | root $ chmod 0755 /shared/backups
php_1    | root $ chmod 0755 /shared/httpd
php_1    | root $ cp /ca/devilbox-ca.crt /usr/local/share/ca-certificates/devilbox-devilbox-ca.crt
php_1    | root $ cp /ca/certs/main/localhost.crt /usr/local/share/ca-certificates/devilbox-localhost.crt
php_1    | root $ update-ca-certificates
php_1    | Updating certificates in /etc/ssl/certs...
php_1    | 2 added, 0 removed; done.
php_1    | Running hooks in /etc/ca-certificates/update.d...
php_1    | done.
php_1    | [INFO] Starting supervisord
php_1    | 2021-10-02 14:15:46,843 WARN No file matches via include "/etc/supervisor/custom.d/*.conf"
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/php-fpm.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/postfix.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/rsyslogd.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/socat-11211-memcd-11211.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/socat-27017-mongo-27017.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/socat-3306-mysql-3306.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/socat-443-httpd-443.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/socat-5432-pgsql-5432.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/socat-6379-redis-6379.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Included extra file "/etc/supervisor/conf.d/socat-80-httpd-80.conf" during parsing
php_1    | 2021-10-02 14:15:46,844 INFO Set uid to user 0 succeeded
php_1    | 2021-10-02 14:15:46,845 INFO supervisord started with pid 1
php_1    | 2021-10-02 14:15:47,849 INFO spawned: 'rsyslogd' with pid 1534
php_1    | 2021-10-02 14:15:47,853 INFO spawned: 'socat-3306-mysql-3306' with pid 1535
php_1    | 2021-10-02 14:15:47,857 INFO spawned: 'socat-6379-redis-6379' with pid 1536
php_1    | 2021-10-02 14:15:47,861 INFO spawned: 'postfix' with pid 1537
php_1    | 2021-10-02 14:15:47,866 INFO spawned: 'socat-27017-mongo-27017' with pid 1538
php_1    | 2021-10-02 14:15:47,873 INFO spawned: 'php-fpm' with pid 1539
php_1    | 2021-10-02 14:15:47,877 INFO spawned: 'socat-80-httpd-80' with pid 1542
php_1    | 2021-10-02 14:15:47,880 INFO spawned: 'socat-443-httpd-443' with pid 1543
php_1    | 2021-10-02 14:15:47,883 INFO spawned: 'socat-11211-memcd-11211' with pid 1544
php_1    | 2021-10-02 14:15:47,885 INFO spawned: 'socat-5432-pgsql-5432' with pid 1546
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 ]
php_1    | 2021-10-02 14:15:48,934 INFO success: rsyslogd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: socat-3306-mysql-3306 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: socat-6379-redis-6379 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: postfix entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: socat-27017-mongo-27017 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: socat-80-httpd-80 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: socat-443-httpd-443 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: socat-11211-memcd-11211 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2021-10-02 14:15:48,935 INFO success: socat-5432-pgsql-5432 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

docker-compose.override.yml

# IMPORTANT: The version must match the version of docker-compose.yml
version: "2.3"

services:
  php:
    ports:
      # ---- Format: ----
      # [HOST-ADDR : ] HOST-PORT : DOCKER-PORT

      - "35729:35729"

      - "5000:5000"

      - "24678:24678"

      - "3000:3000"

      # - "10000:10000"
      # - "33440:33440"
      # - "4500:4500"
      # - "1337:1337"

  httpd:
    volumes:
      # ---- Format: ----
      # HOST-DIRECTORY : DOCKER-DIRECTORY

      - ${DEVILBOX_PATH}/ca/certs:/etc/httpd/cert:rw${MOUNT_OPTIONS}
    restart: always

.env is identical to default env-example except for HOST_PATH_HTTPD_DATADIR=/media/user/d/WWW/dev/ and HOST_PATH_BACKUPDIR=/media/user/d/WWW/devilbox_backups/

###
###  ---------------------------------------------------
###  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: 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
PHP_SERVER=8.1

###
### 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=mariadb-10.5
#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: Alpine 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.1
#PGSQL_SERVER=11.1-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=11.7
#PGSQL_SERVER=11.7-alpine
#PGSQL_SERVER=11.8
#PGSQL_SERVER=11.8-alpine
#PGSQL_SERVER=11.9
#PGSQL_SERVER=11.9-alpine
#PGSQL_SERVER=12.0
#PGSQL_SERVER=12.0-alpine
#PGSQL_SERVER=12.1
#PGSQL_SERVER=12.1-alpine
#PGSQL_SERVER=12.2
#PGSQL_SERVER=12.2-alpine
#PGSQL_SERVER=12.3
#PGSQL_SERVER=12.3-alpine
PGSQL_SERVER=12.4
#PGSQL_SERVER=12.4-alpine
#PGSQL_SERVER=13.0
#PGSQL_SERVER=13.0-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_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=6.0
#REDIS_SERVER=6.0-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
###
#MEMCD_SERVER=1.4
#MEMCD_SERVER=1.4-alpine
#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
###
#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=4.4
#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=/media/user/d/WWW/dev/

###
### 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=/media/user/d/WWW/devilbox_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

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

###
### 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
robots4life commented 2 years ago

@cytopia this is still happening, I cannot use phpmyadmin due to this, are you looking into this ? Is there something I should add to the bug report or do from my side to get this sorted ? Thank you.

Next Twig\Error\RuntimeError: An exception has been thrown during the rendering of a template ("Unknown system variable 'storage_engine'"). in /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/templates/database/structure/body_for_table_summary.twig:42
Stack trace:
#0 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling(Array, Array)
#1 /tmp/twig/bd/bd4e7d14bdb7b140a2c140a527a50c64c9daa53a54dcecd64234e18f762ce4ab.php(224): Twig\Template->display(Array)
#2 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Template.php(405): __TwigTemplate_5feec263cf11152a16183116f2dd141bf27b4b06b09db2ad06140038876d7898->doDisplay(Array, Array)
#3 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Template.php(378): Twig\Template->displayWithErrorHandling(Array, Array)
#4 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/Template.php(390): Twig\Template->display(Array)
#5 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render(Array, Array)
#6 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Template.php(134): Twig\TemplateWrapper->render(Array)
#7 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Controllers/Database/StructureController.php(659): PhpMyAdmin\Template->render('database/struct...', Array)
#8 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/libraries/classes/Controllers/Database/StructureController.php(172): PhpMyAdmin\Controllers\Database\StructureController->displayTableList()
#9 /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/db_structure.php(56): PhpMyAdmin\Controllers\Database\StructureController->index(Array)
#10 {main}
  thrown in /var/www/default/htdocs/vendor/phpmyadmin-5.0.4/templates/database/structure/body_for_table_summary.twig on line 42
dietcheese commented 2 years ago

Encountering same issue.

dietcheese commented 2 years ago

Not sure if it's related, but also intermittently getting this error, and pages will fail to load:

/devilbox/log/php-fpm-8.1/php-fpm.error

WARNING: [pool www] child 1785 exited on signal 11 (SIGSEGV) after 9.012598 seconds from start

jamie07051975 commented 2 years ago

Was having the same issue. Looks like its related to PHP 8.1 running with this version of MySQL. Running PHP 8.0 works fine

cytopia commented 2 years ago

@robots4life @dietcheese @jamie07051975 Seems to have been resolved by: https://github.com/cytopia/devilbox/pull/859 At least it works fine for me now.

ghost commented 2 years ago

I'm trying to delete a database in phpMyAdmin and I'm getting the attached image error. How can I resolve this?

Edit: In fact, whatever action requires authorization, this message is returned with error 500.

image