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

Unable to use earlier versions of MySQL Workbench in Percona 5.7 mysql #775

Closed wp4nuv closed 3 years ago

wp4nuv commented 3 years ago

ISSUE TYPE

Checklist

OS / ENVIRONMENT

  1. Host operating system and version: Windows 10 Pro version 20H2
  2. (Windows only) Native Docker or Docker Toolbox: Native Docker
  3. Docker version: 3.0.0(50684)
  4. Docker Compose version: 1.27.4
  5. (Linux) Is SELinux enabled?: N/A
  6. What git commit hash are you on?: cdfb55ec

SUMMARY

When using Percona Mysql 5.7 its impossible to use a version of Mysql Workbench prior to 8.0 due to SSL problems even when the certficates exist: mysql_1 | 2020-12-28T21:19:48.094984Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. mysql_1 | 2020-12-28T21:19:48.095527Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.

STEPS TO REPRODUCE

Select Percona Mysql version 5.7 Install the latest Mysql Workbench 6.3 Attempt to connect to db through localhost. If the SSL default (If Required) is turned off, connection succeeds but importing a SQL file fails due to SSL errors. If the SSL value is replaced to "If Required", no connection is possible.

EXPECTED BEHAVIOUR

Connect to Devilbox Mysql instance using the correct Workbench version for mysql 5.7

ACTUAL BEHAVIOUR

User is unable to import sql files due to SSL errors. Users cannot connect to database if the default "If Required" option is active in Workbench.

OTHER INFORMATION

Start command

$ docker-compose up -d

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]  [php.ini]    Custom config present in cfg/php-ini-7.2/
[NOTE]  [startup]    Custom script present in cfg/php-startup-7.2/

# ==============================================================================
# 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_pgsql_1, devilbox_redis_1, devilbox_mongo_1, devilbox_memcd_1, devilbox_mysql_1, devilbox_httpd_1, devilbox_php_1, devilbox_bind_1
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.107+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":"2020-12-28T21:19:48.109+00:00"},"s":"W",  "c":"ASIO",     "id":22601,   "ctx":"main","msg":"No TransportLayer configured during NetworkInterface startup"}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.109+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":"2020-12-28T21:19:48.109+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":"2020-12-28T21:19:48.110+00:00"},"s":"I",  "c":"CONTROL",  "id":23403,   "ctx":"initandlisten","msg":"Build Info","attr":{"buildInfo":{"version":"4.4.2","gitVersion":"15e73dc5738d2278b688f8929aee605fe4279b0e","openSSLVersion":"OpenSSL 1.1.1  11 Sep 2018","modules":[],"allocator":"tcmalloc","environment":{"distmod":"ubuntu1804","distarch":"x86_64","target_arch":"x86_64"}}}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.110+00:00"},"s":"I",  "c":"CONTROL",  "id":51765,   "ctx":"initandlisten","msg":"Operating System","attr":{"os":{"name":"Ubuntu","version":"18.04"}}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.110+00:00"},"s":"I",  "c":"CONTROL",  "id":21951,   "ctx":"initandlisten","msg":"Options set by command line","attr":{"options":{"net":{"bindIp":"*"}}}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.110+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":"2020-12-28T21:19:48.110+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":"2020-12-28T21:19:48.110+00:00"},"s":"I",  "c":"STORAGE",  "id":22315,   "ctx":"initandlisten","msg":"Opening WiredTiger","attr":{"config":"create,cache_size=25127M,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":"2020-12-28T21:19:48.483+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1609190388:483569][1:0x7fd62da7bac0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 4 through 5"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.507+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1609190388:507525][1:0x7fd62da7bac0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 5 through 5"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.551+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1609190388:551554][1:0x7fd62da7bac0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Main recovery loop: starting at 4/258432 to 5/256"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.598+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1609190388:598001][1:0x7fd62da7bac0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 4 through 5"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.627+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1609190388:627550][1:0x7fd62da7bac0], txn-recover: [WT_VERB_RECOVERY_PROGRESS] Recovering log 5 through 5"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.651+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1609190388:651111][1:0x7fd62da7bac0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Set global recovery timestamp: (0, 0)"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.651+00:00"},"s":"I",  "c":"STORAGE",  "id":22430,   "ctx":"initandlisten","msg":"WiredTiger message","attr":{"message":"[1609190388:651171][1:0x7fd62da7bac0], txn-recover: [WT_VERB_RECOVERY | WT_VERB_RECOVERY_PROGRESS] Set global oldest timestamp: (0, 0)"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.668+00:00"},"s":"I",  "c":"STORAGE",  "id":4795906, "ctx":"initandlisten","msg":"WiredTiger opened","attr":{"durationMillis":558}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.668+00:00"},"s":"I",  "c":"RECOVERY", "id":23987,   "ctx":"initandlisten","msg":"WiredTiger recoveryTimestamp","attr":{"recoveryTimestamp":{"$timestamp":{"t":0,"i":0}}}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.668+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":"2020-12-28T21:19:48.669+00:00"},"s":"I",  "c":"STORAGE",  "id":22262,   "ctx":"initandlisten","msg":"Timestamp monitor starting"}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.673+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":"2020-12-28T21:19:48.673+00:00"},"s":"W",  "c":"CONTROL",  "id":22178,   "ctx":"initandlisten","msg":"/sys/kernel/mm/transparent_hugepage/enabled is 'always'. We suggest setting it to 'never'","tags":["startupWarnings"]}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.673+00:00"},"s":"I",  "c":"STORAGE",  "id":20536,   "ctx":"initandlisten","msg":"Flow Control is enabled on this deployment"}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.674+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":"2020-12-28T21:19:48.675+00:00"},"s":"I",  "c":"NETWORK",  "id":23015,   "ctx":"listener","msg":"Listening on","attr":{"address":"/tmp/mongodb-27017.sock"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.675+00:00"},"s":"I",  "c":"NETWORK",  "id":23015,   "ctx":"listener","msg":"Listening on","attr":{"address":"0.0.0.0"}}
mongo_1  | {"t":{"$date":"2020-12-28T21:19:48.675+00:00"},"s":"I",  "c":"NETWORK",  "id":23016,   "ctx":"listener","msg":"Waiting for connections","attr":{"port":27017,"ssl":"off"}}
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: Mon Dec 28 21:19:47 UTC 2020
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: redirect http to 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: redirect http to 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 redir
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): Loading configuration file        (-c): /etc/vhost-gen/main.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): Loading vhost template (global)   (-t): /etc/vhost-gen/templates/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): Loading vhost template (override) (-o): /var/www/default/cfg/apache24.yml
httpd_1  | vhost-gen: [WARN]  (2020-12-28 21:19:47): Override Vhost template not found: /var/www/default/cfg/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): Creating vhost type: https and redirect http to https (redir)
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): Using vhost name: localhost
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): Log setting: dir -> True
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): Log setting: Not specified
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:47): 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 $ mkdir -p /etc/httpd/cert/main
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
httpd_1  | Certificate:
httpd_1  |     Data:
httpd_1  |         Version: 3 (0x2)
httpd_1  |         Serial Number:
httpd_1  |             4a:53:c1:72:dd:21:10:ea:c8:8f:f2:49:d9:37:f1:ae:bd:8f:e6:78
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 = tmWBdh1tKq511lMrvDCEbyXP3nI=
httpd_1  |         Validity
httpd_1  |             Not Before: Dec 28 21:19:47 2020 GMT
httpd_1  |             Not After : Apr  2 21:19:47 2023 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:b5:9c:c7:0f:fd:bb:42:52:28:6d:14:58:c8:f3:
httpd_1  |                     06:86:1d:e1:38:e7:92:ed:7e:9d:71:7c:36:3d:e8:
httpd_1  |                     9c:f2:2c:32:82:19:9b:55:51:1d:f8:b6:79:18:8f:
httpd_1  |                     df:65:1f:22:24:32:98:74:30:4d:46:04:a4:1d:71:
httpd_1  |                     29:20:3e:cd:2e:9f:70:b0:20:38:e4:9e:ce:0f:74:
httpd_1  |                     00:6b:c9:b6:ce:14:63:3a:0e:6f:a0:51:4b:b7:5c:
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 1609190384
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  |                     87:10:97:8e:9f:11:ce:35:1f:b7:a0:db:e6:8b:93:
httpd_1  |                     2e:26:31:9c:40:02:4c:5a:e0:5d:fa:df:71:68:e4:
httpd_1  |                     f8:4b:99:34:6a:85:60:d3:b9:11:3b:b5:8f:e9:b9:
httpd_1  |                     b6:62:ca:76:80:54:63:1b:40:da:95:16:ce:5f:81:
httpd_1  |                     c0:09:39:a0:62:eb:4c:13:1e:38:db:01:58:8c:4a:
httpd_1  |                     47:7a:5c:ff:94:1d:c7:f6:19:85:be:e0:8a:34:0a:
httpd_1  |                     95:e0:46:0b:f0:46:4d:17:4f:c4:55:0c:4b:31:f9:
httpd_1  |                     8d:d0:49:7f:2a:ad:08:13:b8:2d:e3:c2:56:98:f7:
httpd_1  |                     68:b3:e6:a7:64:1b:39:14:8a:05:2f:41:26:5f:0e:
httpd_1  |                     12:8a:af:d8:ab:be:c0:18:a0:69:fe:5f:6e:bb:4a:
httpd_1  |                     52:99:19:ea:34:29:41:06:58:1f:f5:5e:ca:71:41:
httpd_1  |                     50:bb
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  |                 98:C2:0B:85:EE:1F:E9:F2:D3:13:3F:36:49:3B:0D:88:D1:49:CF:73
httpd_1  |             X509v3 Key Usage: critical
httpd_1  |                 Digital Signature, Key Encipherment
httpd_1  |             X509v3 Authority Key Identifier:
httpd_1  |                 keyid:B6:65:81:76:1D:6D:2A:AE:75:D6:53:2B:BC:30:84:6F:25:CF:DE:72
httpd_1  |                 DirName:/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=Devilbox Root CA/emailAddress=cytopia@devilbox.org/dnQualifier=tmWBdh1tKq511lMrvDCEbyXP3nI=
httpd_1  |                 serial:40:9D:61:E7:4F:4F:89:59:73:8A:C0:7B:FB:1F:4C:01:DD:1A:DE:92
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  |          60:8d:41:aa:71:38:db:7e:1d:5c:cf:a8:6b:03:4f:29:d2:a4:
httpd_1  |          b5:d2:ac:c3:6f:ec:f6:83:3e:74:20:d6:86:5d:20:85:31:ce:
httpd_1  |          12:99:2e:93:69:42:34:4c:58:16:18:ae:5b:7b:e9:f6:a7:30:
httpd_1  |          8f:f8:0e:99:87:e1:88:4a:3e:5b:15:32:70:75:96:52:8c:9a:
httpd_1  |          c4:5e:05:41:51:a1:3a:df:63:0d:d7:15:53:d9:5c:fd:d2:cf:
httpd_1  |          fc:f2:71:18:70:16:26:cc:48:c4:41:de:26:16:7d:30:28:75:
httpd_1  |          01:b4:e4:59:fd:1e:fc:d5:a8:8f:de:f6:43:0d:af:08:ce:2f:
httpd_1  |          33:c0:ab:89:0d:cb:b4:41:75:ff:d0:a9:83:03:db:01:42:1c:
httpd_1  |          06:72:ef:cd:3c:92:4f:17:b4:9a:7d:45:7c:be:6e:e3:ed:ad:
httpd_1  |          ef:fc:3d:8c:e6:96:50:12:d5:a6:90:29:99:65:b2:30:89:e9:
httpd_1  |          22:9d:47:84:2d:2a:52:08:eb:cc:62:14:03:bb:52:e7:81:c7:
httpd_1  |          9f:bb:98:55:49:2f:f0:02:b9:6d:72:3a:61:03:26:53:d6:d7:
httpd_1  |          bb:bf:63:8f:78:79:8d:4b:4c:c9:91:6d:5b:8f:52:76:f9:c4:
httpd_1  |          27:83:4d:63:fc:25:31:12:7d:4b:3d:97:16:7f:70:e2:09:56:
httpd_1  |          48:64:e4:6e
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  | 2020-12-28 21:19:47,755 INFO Set uid to user 0 succeeded
httpd_1  | 2020-12-28 21:19:47,756 INFO supervisord started with pid 1
httpd_1  | 2020-12-28 21:19:48,758 INFO spawned: 'httpd' with pid 233
httpd_1  | 2020-12-28 21:19:48,759 INFO spawned: 'watcherd' with pid 234
httpd_1  | [Mon Dec 28 21:19:48.781492 2020] [mpm_event:notice] [pid 233:tid 140362409862272] AH00489: Apache/2.4.46 (Unix) OpenSSL/1.1.1d configured -- resuming normal operations
httpd_1  | [Mon Dec 28 21:19:48.781568 2020] [core:notice] [pid 233:tid 140362409862272] AH00094: Command line: 'httpd -D FOREGROUND'
httpd_1  | 2020-12-28 21:19:49,782 INFO success: httpd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
httpd_1  | 2020-12-28 21:19:49,782 INFO success: watcherd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
httpd_1  | watcherd: [2020-12-28 21:19:51] 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/blncake3.loc.key -subj '/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=blncake3.loc/emailAddress=admin@blncake3.loc' -out /etc/httpd/cert/mass/blncake3.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/blncake3.loc.csr -CA /ca/devilbox-ca.crt -CAkey /ca/devilbox-ca.key -CAcreateserial -out /etc/httpd/cert/mass/blncake3.loc.crt
httpd_1  | Certificate:
httpd_1  |     Data:
httpd_1  |         Version: 3 (0x2)
httpd_1  |         Serial Number:
httpd_1  |             4a:53:c1:72:dd:21:10:ea:c8:8f:f2:49:d9:37:f1:ae:bd:8f:e6:79
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 = tmWBdh1tKq511lMrvDCEbyXP3nI=
httpd_1  |         Validity
httpd_1  |             Not Before: Dec 28 21:19:51 2020 GMT
httpd_1  |             Not After : Apr  2 21:19:51 2023 GMT
httpd_1  |         Subject: C = DE, ST = Berlin, L = Berlin, O = Devilbox, OU = Devilbox, CN = blncake3.loc, emailAddress = admin@blncake3.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:e2:a5:f2:24:15:84:b7:11:ae:3a:0a:b1:b1:e5:
httpd_1  |                     52:64:45:ce:18:e8:20:62:56:bf:ff:b7:86:48:0f:
httpd_1  |                     58:42:5d:30:bd:d7:e7:7b:c9:86:0f:ce:5a:28:a6:
httpd_1  |                     24:ad:10:7e:40:ba:25:a6:92:4a:6b:80:c8:c6:fe:
httpd_1  |                     19:43:2c:f6:01:2c:fa:e8:29:d3:2c:7e:e8:08:d9:
httpd_1  |                     21:de:59:50:2d:d3:04:bc:b6:23:13:80:b6:a7:7f:
httpd_1  |                     7f:93:ef:20:a8:04:0e:59:f0:4b:25:41:f6:29:b4:
httpd_1  |                     ca:36:e9:88:aa:48:b1:1e:42:d1:6e:18:c3:01:d7:
httpd_1  |                     a3:d4:1d:d1:db:5b:09:de:e4:77:de:3c:3b:d9:24:
httpd_1  |                     01:b9:6a:c8:e7:45:72:6a:72:6a:fc:be:13:14:cd:
httpd_1  |                     51:7c:9d:6c:29:91:eb:89:30:dc:a5:a8:15:9c:38:
httpd_1  |                     7b:89:82:0e:d2:27:3e:4f:4a:8d:9c:d4:f6:ea:97:
httpd_1  |                     89:54:72:91:88:ed:6d:48:18:29:35:37:2b:83:fd:
httpd_1  |                     16:98:7e:cf:37:8e:8b:cb:5a:08:26:75:b6:74:b1:
httpd_1  |                     30:f8:01:29:6f:91:43:fb:70:ac:80:c1:23:00:0b:
httpd_1  |                     21:cb:30:8c:81:0f:1c:34:de:bd:24:58:b6:52:ca:
httpd_1  |                     fd:df:c0:f3:74:76:db:1d:bb:05:07:14:9a:d9:88:
httpd_1  |                     15:b7
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  |                 F8:D7:79:78:E0:B2:9C:3C:14:57:F5:68:F9:E9:8F:03:7C:AA:A7:3F
httpd_1  |             X509v3 Key Usage: critical
httpd_1  |                 Digital Signature, Key Encipherment
httpd_1  |             X509v3 Authority Key Identifier:
httpd_1  |                 keyid:B6:65:81:76:1D:6D:2A:AE:75:D6:53:2B:BC:30:84:6F:25:CF:DE:72
httpd_1  |                 DirName:/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=Devilbox Root CA/emailAddress=cytopia@devilbox.org/dnQualifier=tmWBdh1tKq511lMrvDCEbyXP3nI=
httpd_1  |                 serial:40:9D:61:E7:4F:4F:89:59:73:8A:C0:7B:FB:1F:4C:01:DD:1A:DE:92
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:blncake3.loc, DNS:*.blncake3.loc
httpd_1  |     Signature Algorithm: sha256WithRSAEncryption
httpd_1  |          7e:60:e3:83:5a:ad:f5:af:10:ef:df:ae:37:ed:8f:f9:45:77:
httpd_1  |          d0:1e:a4:3c:c6:74:a2:1d:b7:a8:c9:72:a4:e4:f3:ae:a3:4f:
httpd_1  |          9f:03:b1:f3:16:84:c9:69:c2:c2:c6:75:08:ee:92:ae:9f:38:
httpd_1  |          63:a5:ff:c2:e7:52:b9:eb:e2:15:3f:c5:e2:b7:13:53:b3:97:
httpd_1  |          50:74:11:d8:67:6b:90:28:ef:80:1c:a8:d8:91:c4:d7:e0:a2:
httpd_1  |          17:fc:d6:38:65:0b:4e:42:b8:13:0f:69:8b:bd:ed:3a:6c:29:
httpd_1  |          01:48:ef:0b:b1:b3:38:22:84:f9:62:56:da:df:74:42:18:41:
httpd_1  |          f6:04:33:8e:70:4d:f1:db:9a:49:70:47:03:2a:50:3b:8c:44:
httpd_1  |          17:9b:7d:78:40:21:b7:95:7e:1f:03:5e:7b:fc:81:a5:95:96:
httpd_1  |          8a:41:3d:c5:4e:c6:a7:86:76:23:fb:ee:b0:ec:a9:21:04:4b:
httpd_1  |          4e:30:18:f1:b7:fe:0a:22:18:90:ab:b3:a3:3d:6c:f3:e8:4f:
httpd_1  |          aa:56:48:af:ba:19:6e:03:8c:3b:1c:37:27:9c:73:2c:86:6c:
httpd_1  |          71:e6:2b:60:7e:34:4c:ea:c6:04:5b:7c:68:64:02:d3:4c:18:
httpd_1  |          1f:0e:49:74:20:65:7a:54:5e:a8:e9:e5:e3:79:76:3c:c1:8c:
httpd_1  |          8c:24:61:82
httpd_1  | /etc/httpd/cert/mass/blncake3.loc.crt: OK
httpd_1  | $ vhost-gen -p "/shared/httpd/blncake3" -n "blncake3" -c /etc/vhost-gen/mass.yml -o "/shared/httpd/blncake3/.devilbox/" -s -v -m redir
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Loading configuration file        (-c): /etc/vhost-gen/mass.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Loading vhost template (global)   (-t): /etc/vhost-gen/templates/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Loading vhost template (override) (-o): /shared/httpd/blncake3/.devilbox/apache24.yml
httpd_1  | vhost-gen: [WARN]  (2020-12-28 21:19:51): Override Vhost template not found: /shared/httpd/blncake3/.devilbox/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Creating vhost type: https and redirect http to https (redir)
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Using vhost name: blncake3.loc
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Log setting: dir -> True
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Log setting: Not specified
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Vhost config written to: /etc/httpd/vhost.d/blncake3.conf
httpd_1  | watcherd: [2020-12-28 21:19:51] [OK]  ADD: succeeded: /shared/httpd/blncake3
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/blnlocal.loc.key -subj '/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=blnlocal.loc/emailAddress=admin@blnlocal.loc' -out /etc/httpd/cert/mass/blnlocal.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/blnlocal.loc.csr -CA /ca/devilbox-ca.crt -CAkey /ca/devilbox-ca.key -CAcreateserial -out /etc/httpd/cert/mass/blnlocal.loc.crt
httpd_1  | Certificate:
httpd_1  |     Data:
httpd_1  |         Version: 3 (0x2)
httpd_1  |         Serial Number:
httpd_1  |             4a:53:c1:72:dd:21:10:ea:c8:8f:f2:49:d9:37:f1:ae:bd:8f:e6:7a
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 = tmWBdh1tKq511lMrvDCEbyXP3nI=
httpd_1  |         Validity
httpd_1  |             Not Before: Dec 28 21:19:51 2020 GMT
httpd_1  |             Not After : Apr  2 21:19:51 2023 GMT
httpd_1  |         Subject: C = DE, ST = Berlin, L = Berlin, O = Devilbox, OU = Devilbox, CN = blnlocal.loc, emailAddress = admin@blnlocal.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:bc:3f:e3:69:9c:33:03:24:3c:c2:1b:d4:08:fb:
httpd_1  |                     30:17:fc:ad:ea:c2:32:e3:69:41:ef:15:6e:be:d7:
httpd_1  |                     0c:80:dc:d1:6c:12:10:13:ef:83:dc:45:0a:43:c0:
httpd_1  |                     ed:7c:18:a6:2e:68:de:ba:95:47:c7:6b:ba:46:af:
httpd_1  |                     f0:17:18:b5:58:d6:78:ba:bf:75:a5:12:f6:4a:9a:
httpd_1  |                     af:81:c6:14:db:be:a6:00:1a:b7:e7:72:c9:6b:81:
httpd_1  |                     84:4c:8d:cc:d5:04:73:08:19:08:38:e4:b0:bb:f2:
httpd_1  |                     f2:4b:6d:ce:74:f7:e4:fd:b5:b8:b2:84:9f:1f:be:
httpd_1  |                     cd:4b:ba:70:61:71:57:a2:29:83:d9:8e:3d:cf:bd:
httpd_1  |                     9f:57:0a:d4:2d:1f:d9:9f:00:f7:47:45:3b:8c:9b:
httpd_1  |                     5c:74:12:f2:f3:b2:b0:7f:89:ac:20:d7:fb:d0:05:
httpd_1  |                     ca:47:9c:a8:f5:9f:d8:e8:26:74:84:cf:d4:91:4c:
httpd_1  |                     5c:c5:f3:c4:54:b5:aa:09:86:4c:4b:df:64:f9:98:
httpd_1  |                     6d:9e:26:c2:64:de:29:06:37:18:46:fd:39:3f:bc:
httpd_1  |                     c3:89:54:31:17:11:cc:c2:67:97:cc:f0:b7:20:e0:
httpd_1  |                     de:d3:12:3f:09:1d:f5:83:52:f3:c9:ce:15:32:44:
httpd_1  |                     ae:27:d0:8b:50:dc:49:63:a8:85:91:69:8b:20:a2:
httpd_1  |                     25:df
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  |                 23:EA:29:3B:62:0F:CA:97:C6:A1:E5:BF:A1:99:99:F7:0E:F7:10:78
httpd_1  |             X509v3 Key Usage: critical
httpd_1  |                 Digital Signature, Key Encipherment
httpd_1  |             X509v3 Authority Key Identifier:
httpd_1  |                 keyid:B6:65:81:76:1D:6D:2A:AE:75:D6:53:2B:BC:30:84:6F:25:CF:DE:72
httpd_1  |                 DirName:/C=DE/ST=Berlin/L=Berlin/O=Devilbox/OU=Devilbox/CN=Devilbox Root CA/emailAddress=cytopia@devilbox.org/dnQualifier=tmWBdh1tKq511lMrvDCEbyXP3nI=
httpd_1  |                 serial:40:9D:61:E7:4F:4F:89:59:73:8A:C0:7B:FB:1F:4C:01:DD:1A:DE:92
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:blnlocal.loc, DNS:*.blnlocal.loc
httpd_1  |     Signature Algorithm: sha256WithRSAEncryption
httpd_1  |          43:a4:0e:9d:8d:a4:97:09:65:24:94:cd:2e:07:c4:e2:4a:80:
httpd_1  |          f5:6d:54:35:0c:66:96:f3:be:5b:6f:71:a3:04:d3:6a:84:47:
httpd_1  |          ce:36:7b:9c:b3:e7:52:75:4d:05:e7:48:fb:f8:24:de:d6:dc:
httpd_1  |          7b:e3:b2:2f:d3:ae:02:72:0e:e5:37:3f:96:01:79:59:80:c9:
httpd_1  |          43:fa:bf:ce:f2:4b:67:69:19:b0:b3:a7:62:93:b0:57:86:28:
httpd_1  |          10:73:27:3b:ac:d3:66:4a:5d:91:66:59:78:07:27:56:5f:00:
httpd_1  |          cf:c4:f6:99:c3:0a:8d:5c:48:98:62:da:19:36:43:28:fa:33:
httpd_1  |          b2:28:b8:62:db:94:24:6f:e9:d1:9b:92:7a:e2:a7:aa:dd:19:
httpd_1  |          ef:a1:3e:8b:2e:06:06:3b:47:54:b1:77:0a:bf:94:1c:3d:70:
httpd_1  |          55:b4:6a:35:4a:e1:98:c1:1d:ba:2d:33:fc:fe:1c:f7:a6:5d:
httpd_1  |          a0:da:5c:36:23:93:46:9b:27:93:50:2a:c0:52:8a:b1:74:c6:
httpd_1  |          2b:d6:1d:19:61:4f:93:b7:a8:4b:a5:e6:66:c2:a0:ed:51:7f:
httpd_1  |          24:a3:69:e9:f9:ba:8d:28:90:68:ad:07:95:6d:3d:b1:7e:7b:
httpd_1  |          d4:0f:21:09:ca:40:7a:96:cf:86:a1:b5:e3:91:19:81:53:d8:
httpd_1  |          60:1a:5d:db
httpd_1  | /etc/httpd/cert/mass/blnlocal.loc.crt: OK
httpd_1  | $ vhost-gen -p "/shared/httpd/blnlocal" -n "blnlocal" -c /etc/vhost-gen/mass.yml -o "/shared/httpd/blnlocal/.devilbox/" -s -v -m redir
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:51): Loading configuration file        (-c): /etc/vhost-gen/mass.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:52): Loading vhost template (global)   (-t): /etc/vhost-gen/templates/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:52): Loading vhost template (override) (-o): /shared/httpd/blnlocal/.devilbox/apache24.yml
httpd_1  | vhost-gen: [WARN]  (2020-12-28 21:19:52): Override Vhost template not found: /shared/httpd/blnlocal/.devilbox/apache24.yml
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:52): Creating vhost type: https and redirect http to https (redir)
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:52): Using vhost name: blnlocal.loc
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:52): Log setting: dir -> True
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:52): Log setting: Not specified
httpd_1  | vhost-gen: [INFO]  (2020-12-28 21:19:52): Vhost config written to: /etc/httpd/vhost.d/blnlocal.conf
httpd_1  | watcherd: [2020-12-28 21:19:52] [OK]  ADD: succeeded: /shared/httpd/blnlocal
httpd_1  | watcherd: [2020-12-28 21:19:52] [OK]  TRIGGER succeeded: /usr/local/apache2/bin/httpd -k stop
httpd_1  | watcherd: [2020-12-28 21:19:52] Using bash loop to watch for changes.
httpd_1  | [Mon Dec 28 21:19:52.056643 2020] [mpm_event:notice] [pid 233:tid 140362409862272] AH00491: caught SIGTERM, shutting down
httpd_1  | 2020-12-28 21:19:52,067 INFO exited: httpd (exit status 0; expected)
httpd_1  | 2020-12-28 21:19:53,069 INFO spawned: 'httpd' with pid 529
httpd_1  | [Mon Dec 28 21:19:53.093581 2020] [mpm_event:notice] [pid 529:tid 140075092616320] AH00489: Apache/2.4.46 (Unix) OpenSSL/1.1.1d configured -- resuming normal operations
httpd_1  | [Mon Dec 28 21:19:53.093651 2020] [core:notice] [pid 529:tid 140075092616320] AH00094: Command line: 'httpd -D FOREGROUND'
httpd_1  | 2020-12-28 21:19:54,094 INFO success: httpd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
mysql_1  | 2020-12-28T21:19:48.001045Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
mysql_1  | 2020-12-28T21:19:48.001947Z 0 [Note] mysqld (mysqld 5.7.32-35) starting as process 1 ...
mysql_1  | 2020-12-28T21:19:48.003793Z 0 [Note] InnoDB: PUNCH HOLE support available
mysql_1  | 2020-12-28T21:19:48.003820Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
mysql_1  | 2020-12-28T21:19:48.003824Z 0 [Note] InnoDB: Uses event mutexes
mysql_1  | 2020-12-28T21:19:48.003825Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
mysql_1  | 2020-12-28T21:19:48.003826Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
mysql_1  | 2020-12-28T21:19:48.003828Z 0 [Note] InnoDB: Using Linux native AIO
mysql_1  | 2020-12-28T21:19:48.003938Z 0 [Note] InnoDB: Number of pools: 1
mysql_1  | 2020-12-28T21:19:48.004006Z 0 [Note] InnoDB: Using CPU crc32 instructions
mysql_1  | 2020-12-28T21:19:48.005038Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
mysql_1  | 2020-12-28T21:19:48.007364Z 0 [Note] InnoDB: Completed initialization of buffer pool
mysql_1  | 2020-12-28T21:19:48.008991Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
mysql_1  | 2020-12-28T21:19:48.019804Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
mysql_1  | 2020-12-28T21:19:48.020324Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
mysql_1  | 2020-12-28T21:19:48.027581Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
mysql_1  | 2020-12-28T21:19:48.030252Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
mysql_1  | 2020-12-28T21:19:48.030304Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
mysql_1  | 2020-12-28T21:19:48.040492Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
mysql_1  | 2020-12-28T21:19:48.041074Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
mysql_1  | 2020-12-28T21:19:48.041097Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
mysql_1  | 2020-12-28T21:19:48.041584Z 0 [Note] InnoDB: Waiting for purge to start
mysql_1  | 2020-12-28T21:19:48.091902Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.32-35 started; log sequence number 20756878223
mysql_1  | 2020-12-28T21:19:48.092022Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
mysql_1  | 2020-12-28T21:19:48.092263Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysql_1  | 2020-12-28T21:19:48.093755Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201228 21:19:48
mysql_1  | 2020-12-28T21:19:48.094984Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
mysql_1  | 2020-12-28T21:19:48.095014Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
mysql_1  | 2020-12-28T21:19:48.095490Z 0 [Warning] CA certificate ca.pem is self signed.
mysql_1  | 2020-12-28T21:19:48.095527Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
mysql_1  | 2020-12-28T21:19:48.095763Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
mysql_1  | 2020-12-28T21:19:48.095792Z 0 [Note] IPv6 is available.
mysql_1  | 2020-12-28T21:19:48.095796Z 0 [Note]   - '::' resolves to '::';
mysql_1  | 2020-12-28T21:19:48.095805Z 0 [Note] Server socket created on IP: '::'.
mysql_1  | 2020-12-28T21:19:48.104728Z 0 [Note] Event Scheduler: Loaded 0 events
mysql_1  | 2020-12-28T21:19:48.104895Z 0 [Note] mysqld: ready for connections.
mysql_1  | Version: '5.7.32-35'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona Server (GPL), Release 35, Revision 5688520
mysql_1  | 2020-12-28T21:25:49.591712Z 2 [Note] Bad handshake
mysql_1  | 2020-12-28T21:26:49.357174Z 3 [Note] Bad handshake
mysql_1  | 2020-12-28T21:28:01.405566Z 4 [Note] Bad handshake
mysql_1  | 2020-12-28T21:28:51.588617Z 5 [Note] Bad handshake
mysql_1  | 2020-12-28T21:29:01.708496Z 6 [Note] Bad handshake
mysql_1  | 2020-12-28T21:30:01.055677Z 7 [Note] Bad handshake
mysql_1  | 2020-12-28T21:30:16.271069Z 8 [Note] Bad handshake
mysql_1  | 2020-12-28T21:31:21.456091Z 9 [Note] Bad handshake
mysql_1  | 2020-12-28T21:32:14.488266Z 10 [Note] Bad handshake
mysql_1  | 2020-12-28T21:32:23.008095Z 11 [Note] Bad handshake
mysql_1  | 2020-12-28T21:32:31.000000Z 12 [Note] Bad handshake
mysql_1  | 2020-12-28T21:34:12.824498Z 13 [Note] Bad handshake
mysql_1  | 2020-12-28T21:34:27.498826Z 14 [Note] Bad handshake
mysql_1  | 2020-12-28T21:35:07.106523Z 15 [Note] Bad handshake
mysql_1  | 2020-12-28T21:35:09.970265Z 16 [Note] Bad handshake
mysql_1  | 2020-12-28T21:35:16.615171Z 17 [Note] Bad handshake
mysql_1  | 2020-12-28T21:35:17.061307Z 18 [Note] Bad handshake
mysql_1  | 2020-12-28T21:35:19.856187Z 19 [Note] Bad handshake
mysql_1  | 2020-12-28T21:35:39.596905Z 20 [Note] Access denied for user 'root'@'172.16.238.1' (using password: NO)
mysql_1  | 2020-12-28T21:35:54.998917Z 32 [Note] Bad handshake
mysql_1  | 2020-12-28T21:39:29.696066Z 33 [Note] Bad handshake
mysql_1  | 2020-12-28T21:39:46.291560Z 34 [Note] Bad handshake
pgsql_1  |
pgsql_1  | PostgreSQL Database directory appears to contain a database; Skipping initialization
pgsql_1  |
pgsql_1  | 2020-12-28 21:19:48.214 UTC [1] LOG:  starting PostgreSQL 13.0 (Debian 13.0-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
pgsql_1  | 2020-12-28 21:19:48.214 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
pgsql_1  | 2020-12-28 21:19:48.215 UTC [1] LOG:  listening on IPv6 address "::", port 5432
pgsql_1  | 2020-12-28 21:19:48.218 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
pgsql_1  | 2020-12-28 21:19:48.223 UTC [28] LOG:  database system was shut down at 2020-12-28 21:19:12 UTC
pgsql_1  | 2020-12-28 21:19:48.226 UTC [1] LOG:  database system is ready to accept connections
redis_1  | 1:C 28 Dec 2020 21:19:48.086 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
redis_1  | 1:C 28 Dec 2020 21:19:48.086 # Redis version=6.0.9, bits=64, commit=00000000, modified=0, pid=1, just started
redis_1  | 1:C 28 Dec 2020 21:19:48.086 # 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 28 Dec 2020 21:19:48.086 * Running mode=standalone, port=6379.
redis_1  | 1:M 28 Dec 2020 21:19:48.086 # WARNING: The TCP backlog setting of 511 cannot be enforced because /proc/sys/net/core/somaxconn is set to the lower value of 128.
redis_1  | 1:M 28 Dec 2020 21:19:48.086 # Server initialized
redis_1  | 1:M 28 Dec 2020 21:19:48.086 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo madvise > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled (set to 'madvise' or 'never').
redis_1  | 1:M 28 Dec 2020 21:19:48.087 * 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: Mon Dec 28 21:19:46 UTC 2020
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 $ 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 $ 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 $ rm /usr/local/etc/php/conf.d/docker-php-ext-pdo_sqlsrv.ini
php_1    | root $ rm /usr/local/etc/php/conf.d/docker-php-ext-sqlsrv.ini
php_1    | root $ rm /usr/local/etc/php/conf.d/docker-php-ext-rdkafka.ini
php_1    | root $ rm /usr/local/etc/php/conf.d/docker-php-ext-swoole.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 = Boogy*Man225/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 $ update-ca-certificates
php_1    | Updating certificates in /etc/ssl/certs...
php_1    | 1 added, 0 removed; done.
php_1    | Running hooks in /etc/ca-certificates/update.d...
php_1    | done.
php_1    | [INFO] Starting supervisord
php_1    | 2020-12-28 21:19:50,390 WARN No file matches via include "/etc/supervisor/custom.d/*.conf"
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/php-fpm.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/postfix.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/rsyslogd.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/socat-11211-memcd-11211.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/socat-27017-mongo-27017.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/socat-3306-mysql-3306.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/socat-443-httpd-443.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/socat-5432-pgsql-5432.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/socat-6379-redis-6379.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Included extra file "/etc/supervisor/conf.d/socat-80-httpd-80.conf" during parsing
php_1    | 2020-12-28 21:19:50,390 INFO Set uid to user 0 succeeded
php_1    | 2020-12-28 21:19:50,391 INFO supervisord started with pid 1
php_1    | 2020-12-28 21:19:51,393 INFO spawned: 'rsyslogd' with pid 1479
php_1    | 2020-12-28 21:19:51,394 INFO spawned: 'socat-3306-mysql-3306' with pid 1480
php_1    | 2020-12-28 21:19:51,394 INFO spawned: 'socat-6379-redis-6379' with pid 1481
php_1    | 2020-12-28 21:19:51,395 INFO spawned: 'postfix' with pid 1482
php_1    | 2020-12-28 21:19:51,396 INFO spawned: 'socat-27017-mongo-27017' with pid 1483
php_1    | 2020-12-28 21:19:51,397 INFO spawned: 'php-fpm' with pid 1486
php_1    | 2020-12-28 21:19:51,397 INFO spawned: 'socat-80-httpd-80' with pid 1487
php_1    | 2020-12-28 21:19:51,398 INFO spawned: 'socat-443-httpd-443' with pid 1489
php_1    | 2020-12-28 21:19:51,399 INFO spawned: 'socat-11211-memcd-11211' with pid 1490
php_1    | 2020-12-28 21:19:51,399 INFO spawned: 'socat-5432-pgsql-5432' with pid 1491
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    | 2020-12-28 21:19:52,443 INFO success: rsyslogd entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: socat-3306-mysql-3306 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: socat-6379-redis-6379 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: postfix entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: socat-27017-mongo-27017 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: socat-80-httpd-80 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: socat-443-httpd-443 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: socat-11211-memcd-11211 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
php_1    | 2020-12-28 21:19:52,443 INFO success: socat-5432-pgsql-5432 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

output of .env:

###
###  ---------------------------------------------------
###  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=./data/www

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

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

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

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

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

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

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

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

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

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

###
### 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=Boogy*Man225

###
### 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=Boogy*Man225

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

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

Custom config cfg/php-ini7.2/xdebug.ini :

; ############################################################
; # Devilbox php.ini: Xdebug example
; ############################################################
;
; Information
; -----------
; * Do not edit this file (it belongs to git)
; * This file show a possible Xdebug example configuration
; * If this file is enabled, it will overwrite the current Xdebug settings
;
; How to enable?
; --------------
; * Copy this file to another file with ".ini" extension
; * Only files with ".ini" extensions will be applied by PHP

;
; PHP.ini configuration
;
[PHP]

; Xdebug
; Use these settings to enable Xdebug for PHP
; Make sure to read up on Xdebug some settings might significantly slow down requests.
; The following is just an example configuration and should be adjusted
xdebug.default_enable   = On
xdebug.profiler_enable  = On
xdebug.remote_enable    = On
xdebug.remote_autostart = On
xdebug.remote_handler   = dbgp
xdebug.remote_port      = 9000
xdebug.idekey           = vscode
xdebug.remote_log       = /var/log/php/xdebug.log

; vim: set ft=dosini:

Custom config cfg/php-startup-7.2/01-apt-update.sh

#!/bin/bash
#
# Simple example showing how to update the packet index
#

DEBIAN_FRONTEND=noninteractive apt-get update -q
cytopia commented 3 years ago

Hi @wp4nuv thanks for the detailed bug report.

From your docker logs I am seeing the following error message:

mysql_1  | 2020-12-28T21:35:39.596905Z 20 [Note] Access denied for user 'root'@'172.16.238.1' (using password: NO)

In the .env file however you've setup a password for MySQL. Can you double check this on your setup

wp4nuv commented 3 years ago

Hi @wp4nuv thanks for the detailed bug report.

From your docker logs I am seeing the following error message:

mysql_1  | 2020-12-28T21:35:39.596905Z 20 [Note] Access denied for user 'root'@'172.16.238.1' (using password: NO)

In the .env file however you've setup a password for MySQL. Can you double check this on your setup

I can't say for sure why that shows... it may be transient. I can run another log dump to see if its recurring P.

cytopia commented 3 years ago

You did already state this in your post: It does work with MySQL Workbench >= 8.0. Just checked it (as it is the version I have installed)
Screenshot 2020-12-31 12-24-45 selection Screenshot 2020-12-31 12-25-31 selection

I would rather assume it must be an issue with older Workbench versions, as SSL clearly seems to work. Wdyt?

wp4nuv commented 3 years ago

That makes sense, but here’s the interesting part: I even made copies of all the generated server keys in case it was looking for those.. but the result was the same. I know I can use Workbench 8, but because our database is not 8, there’s always the possibility that a backup made with the newer Workbench won’t load properly into a 5.7 db. I agree that this seems to be more of a Workbench issue not recognizing the server SSL status. Any chance that the default behavior of generating SSL certs could be turned off?

From: cytopia notifications@github.com Sent: Thursday, December 31, 2020 06:31 To: cytopia/devilbox devilbox@noreply.github.com Cc: Pedro J Maldonado pmaldonado1@mac.com; Mention mention@noreply.github.com Subject: Re: [cytopia/devilbox] Unable to use earlier versions of MySQL Workbench in Percona 5.7 mysql (#775)

You did already state this in your post: It does work with MySQL Workbench >= 8.0. Just checked it (as it is the version I have installed)

https://user-images.githubusercontent.com/12533999/103408629-9cd54480-4b63-11eb-8359-d6f5cac03e72.png

https://user-images.githubusercontent.com/12533999/103408632-9d6ddb00-4b63-11eb-8ee8-8cd972035e2a.png

I would rather assume it must be an issue with older Workbench versions, as SSL clearly seems to work. Wdyt?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cytopia/devilbox/issues/775#issuecomment-752931617 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEMLQIUDT5HRC7FMISDTT3SXROF5ANCNFSM4VMRDCLQ . https://github.com/notifications/beacon/AAEMLQN4TZNCBLCDEPU5ITLSXROF5A5CNFSM4VMRDCL2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOFTQNGII.gif

cytopia commented 3 years ago

Any chance that the default behavior of generating SSL certs could be turned off?

I am not really maintaining those images. I just use a combined repository to bring together MySQL, MariaDB and Percona and make them behave the same way (https://github.com/devilbox/docker-mysql)

See for percona 5.7 for instance: https://github.com/devilbox/docker-mysql/blob/master/Dockerfiles/percona-5.7 All it's doing is ensuring required directories are present and then use entrypoint script from percona.

So you would have more luck, looking at the original images:

wp4nuv commented 3 years ago

Awesome, thank you! I think this can be closed. If I do come up with a way to turn it off, ok to submit a PR even though they are not maintained?

From: cytopia notifications@github.com Sent: Thursday, December 31, 2020 12:04 To: cytopia/devilbox devilbox@noreply.github.com Cc: Pedro J Maldonado pmaldonado1@mac.com; Mention mention@noreply.github.com Subject: Re: [cytopia/devilbox] Unable to use earlier versions of MySQL Workbench in Percona 5.7 mysql (#775)

Any chance that the default behavior of generating SSL certs could be turned off?

I am not really maintaining those images. I just use a combined repository to bring together MySQL, MariaDB and Percona and make them behave the same way (https://github.com/devilbox/docker-mysql)

See for percona 5.7 for instance: https://github.com/devilbox/docker-mysql/blob/master/Dockerfiles/percona-5.7 All it's doing is ensuring required directories are present and then use entrypoint script from percona.

So you would have more luck, looking at the original images:

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/cytopia/devilbox/issues/775#issuecomment-753006721 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEMLQJGE74XTHGYPYRKHITSXSVHJANCNFSM4VMRDCLQ . https://github.com/notifications/beacon/AAEMLQNI3HDSSQF3DLVJSXLSXSVHJA5CNFSM4VMRDCL2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOFTQ7RAI.gif

cytopia commented 3 years ago

If I do come up with a way to turn it off, ok to submit a PR even though they are not maintained?

Totally, would even be much appreciated :+1: