cytopia / devilbox

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

[Bug]: connection refused mysql #1032

Open Biziol opened 1 day ago

Biziol commented 1 day ago

Have you already looked into this bug?

(Optional) Error message

Connection error! connect ECONNREFUSED 127.0.0.1:3306

What went wrong?

I don't know, I installed devilbox as usual and it always worked, this time it refuses the connection both to the portal on locahost accessible from a browser and to the mysql db

Expected behaviour

I would have expected it to connect

How can we reproduce the bug?

I did the following commands:

sudo dnf install docker

sudo dnf install docker-compose

git clone https://github.com/cytopia/devilbox

cd devilbox cp env-example .env

sudo docker-compose up -d

Host Operating System

Linux

Host Platform (amd64, arm64, other)

amd64

(Linux only) Is SELinux enabled?

Yes, SELinux is enabled

Docker version

Docker version 27.3.1, build 2.fc41

Docker Compose version

Docker Compose version 2.29.7

Devilbox version

the one that is installed by cloning the github repository

Have you removed stopped containers before starting?

Yes

Have you pulled latest Docker images before starting?

Yes

Devilbox start command

sudo docker-compose up -d

Config: .env file

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

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

###
### Show all executed commands in each
### docker image during docker-compose up?
###
### 0: Errors
### 1: Errors, Warnings
### 2: Errors, Warnings, Infos  (Recommended)
### 3: Errors, Warnings, Infos, Debug
### 4: Errors, Warnings, Infos, Debug, Trace
DEBUG_ENTRYPOINT=2

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

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

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

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

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

###
### HTTPD Supvervisord management
###
DEVILBOX_HTTPD_MGMT_USER=supervisord
DEVILBOX_HTTPD_MGMT_PASS=mypassword

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

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

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

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

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

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

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

###
### 1.5 Choose Redis Server Image
###
### IMPORTANT: Alpine based images might cause issues on Docker Toolbox or OSX
###            https://github.com/docker/toolbox/issues/510
###
#
# Redis without arm64 support
#
#REDIS_SERVER=2.8
#REDIS_SERVER=3.0
#REDIS_SERVER=3.0-alpine
#
# Redis with arm64 support
#
#REDIS_SERVER=3.2
#REDIS_SERVER=3.2-alpine
#REDIS_SERVER=4.0
#REDIS_SERVER=4.0-alpine
#REDIS_SERVER=5.0
#REDIS_SERVER=5.0-alpine
#REDIS_SERVER=6.0
#REDIS_SERVER=6.0-alpine
#REDIS_SERVER=6.2
REDIS_SERVER=6.2-alpine
#REDIS_SERVER=7.0
#REDIS_SERVER=7.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
###
#
# Memcached without arm64 support
#
#MEMCD_SERVER=1.4
#MEMCD_SERVER=1.4-alpine
#
# Memcached with arm64 support
#
#MEMCD_SERVER=1.5
#MEMCD_SERVER=1.5-alpine
#MEMCD_SERVER=1.6
MEMCD_SERVER=1.6-alpine
#MEMCD_SERVER=latest
#MEMCD_SERVER=alpine

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

###
### Remote (Upstream) Backend Timeout
###
### This setting specifies the Timeout for a remote Backend server,
### such as PHP-FPM or a Reverse Proxy.
###
### As for PHP, keep in mind that 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_BACKEND_TIMEOUT=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

Config: docker-compose.override.yml

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

# The following override shows an example for the cockroachdb
services:
  # Your custom Docker image here:
  cockroach:
    image: cockroachdb/cockroach:latest
    command: start --insecure
    # Ensure the chosen ports are not occupied on the host system
    ports:
      - "${LOCAL_LISTEN_ADDR}26257:26257"
      - "${LOCAL_LISTEN_ADDR}8080:8080"
    networks:
      app_net:
        # Ensure to pick an IP address from docker-compose.yml network
        # that is not yet taken by other sevices
        ipv4_address: 172.16.238.200
    # (Optional) For ease of use always automatically start these:
    depends_on:
      - bind
      - php
      - httpd

Config: ./check-config.sh

bizio@Asdrubale:~/devilbox$ ./check-config.sh

# ==============================================================================
# Checking git
# ==============================================================================
[ERR]   git is unclean
 M docker-compose.yml

# ==============================================================================
# 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 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
# ==============================================================================
[INFO]  No custom configurations applied

# ==============================================================================
# SUMMARY
# ==============================================================================
[ERR]   Found 1 error(s)
[ERR]   Devilbox might not work properly
[ERR]   Fix the issues before submitting a bug report
[INFO]  No custom configurations applied
[INFO]  Ensure to run 'docker-compose stop; docker-compose rm -f' on .env changes or custom configs
bizio@Asdrubale:~/devilbox$ sudo docker-compose stop
bizio@Asdrubale:~/devilbox$ sudo docker-compose rm -f
No stopped containers
bizio@Asdrubale:~/devilbox$

Log: docker-compose logs

bizio@Asdrubale:~/devilbox$ sudo docker-compose logs
bizio@Asdrubale:~/devilbox$

(Optional) Additional information

No response

Biziol commented 7 hours ago

This is log of docker-compose

sudo docker-compose up [+] Running 8/0 ✔ Container devilbox-bind-1 Running 0.0s ✔ Container devilbox-php-1 Created 0.0s ✔ Container devilbox-httpd-1 Created 0.0s ✔ Container devilbox-mongo-1 Running 0.0s ✔ Container devilbox-memcd-1 Running 0.0s ✔ Container devilbox-pgsql-1 Running 0.0s ✔ Container devilbox-redis-1 Running 0.0s ✔ Container devilbox-mysql-1 Created 0.0s Attaching to bind-1, httpd-1, memcd-1, mongo-1, mysql-1, pgsql-1, php-1, redis-1 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 | usermod: no changes 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 /etc/supervisor/custom.d php-1 | chown: cannot read directory '/etc/supervisor/custom.d': Permission denied httpd-1 | [INFO] Entrypoint debug: 2 httpd-1 | [INFO] Runtime debug: 1 httpd-1 | [INFO] ------------------------------------------------------------------------- httpd-1 | [INFO] Environment Variables (set/default) httpd-1 | [INFO] ------------------------------------------------------------------------- php-1 exited with code 1 httpd-1 | [INFO] Variables: General: httpd-1 | [INFO] Set $NEW_UID Value: 1000 httpd-1 | [INFO] Set $NEW_GID Value: 1000 httpd-1 | [INFO] Set $TIMEZONE Value: UTC httpd-1 | [INFO] Variables: Main Vhost: httpd-1 | [INFO] Set $MAIN_VHOST_ENABLE Value: 1 httpd-1 | [INFO] Unset $MAIN_VHOST_DOCROOT_DIR Default: htdocs httpd-1 | [INFO] Unset $MAIN_VHOST_TEMPLATE_DIR Default: cfg httpd-1 | [INFO] Set $MAIN_VHOST_ALIASES_ALLOW Value: /devilbox-api/:/var/www/default/api, /vhost.d/:/etc/httpd httpd-1 | [INFO] Unset $MAIN_VHOST_ALIASES_DENY Default: /.git, /.ht. httpd-1 | [INFO] Set $MAIN_VHOST_BACKEND Value: conf:phpfpm:tcp:172.16.238.10:9000 httpd-1 | [INFO] Set $MAIN_VHOST_BACKEND_TIMEOUT Value: 180 httpd-1 | [INFO] Set $MAIN_VHOST_SSL_TYPE Value: both httpd-1 | [INFO] Set $MAIN_VHOST_SSL_CN Value: localhost,.localhost,devilbox,.devilbox,httpd httpd-1 | [INFO] Set $MAIN_VHOST_STATUS_ENABLE Value: 1 httpd-1 | [INFO] Set $MAIN_VHOST_STATUS_ALIAS Value: /devilbox-httpd-status httpd-1 | [INFO] Variables: Mass Vhost: httpd-1 | [INFO] Set $MASS_VHOST_ENABLE Value: 1 httpd-1 | [INFO] Set $MASS_VHOST_DOCROOT_DIR Value: htdocs httpd-1 | [INFO] Set $MASS_VHOST_TEMPLATE_DIR Value: .devilbox httpd-1 | [INFO] Set $MASS_VHOST_ALIASES_ALLOW Value: /devilbox-api/:/var/www/default/api:http(s)?://(.)$ httpd-1 | [INFO] Unset $MASS_VHOST_ALIASES_DENY Default: /.git, /.ht. httpd-1 | [INFO] Set $MASS_VHOST_BACKEND Value: conf:phpfpm:tcp:172.16.238.10:9000 httpd-1 | [INFO] Set $MASS_VHOST_BACKEND_REWRITE Value: file:backend.cfg httpd-1 | [INFO] Set $MASS_VHOST_BACKEND_TIMEOUT Value: 180 httpd-1 | [INFO] Set $MASS_VHOST_SSL_TYPE Value: both httpd-1 | [INFO] Set $MASS_VHOST_TLD_SUFFIX Value: .dvl.to httpd-1 | [INFO] Variables: Misc: httpd-1 | [INFO] Set $WORKER_CONNECTIONS Value: 1024 httpd-1 | [INFO] Set $WORKER_PROCESSES Value: auto httpd-1 | [INFO] Set $HTTP2_ENABLE Value: 1 httpd-1 | [INFO] Set $DOCKER_LOGS Value: 0 httpd-1 | [INFO] ------------------------------------------------------------------------- httpd-1 | [INFO] Validate Settings httpd-1 | [INFO] ------------------------------------------------------------------------- httpd-1 | [INFO] Settings: General: httpd-1 | [OK] Valid $NEW_UID User ID (uid) 1000 httpd-1 | [OK] Valid $NEW_GID Group ID (gid) 1000 httpd-1 | [OK] Valid $TIMEZONE ignored (not specified) httpd-1 | [INFO] Settings: Main Vhost: httpd-1 | [OK] Valid $MAIN_VHOST_ENABLE Default vhost Enabled httpd-1 | [OK] Valid $MAIN_VHOST_DOCROOT_DIR Document root: /var/www/default/htdocs httpd-1 | [OK] Valid $MAIN_VHOST_TEMPLATE_DIR Template dir /var/www/default/cfg httpd-1 | [OK] Valid $MAIN_VHOST_ALIASES_ALLOW Defined Aliases /devilbox-api/, /vhost.d/ httpd-1 | [OK] Valid $MAIN_VHOST_ALIASES_DENY Defined Aliases /.git, /.ht. httpd-1 | [OK] Valid $MAIN_VHOST_BACKEND PHP via PHP-FPM Remote: tcp://172.16.238.10:9000 httpd-1 | [OK] Valid $MAIN_VHOST_BACKEND_TIMEOUT Timeout: 180sec httpd-1 | [OK] Valid $MAIN_VHOST_SSL_TYPE Vhost protocol HTTP and HTTPS httpd-1 | [OK] Valid $MAIN_VHOST_SSL_CN SSL cert subject CN = localhost,.localhost,devilbox,.devilbox,httpd httpd-1 | [OK] Valid $MAIN_VHOST_STATUS_ENABLE Status page Enabled httpd-1 | [OK] Valid $MAIN_VHOST_STATUS_ALIAS Status page URL /devilbox-httpd-status httpd-1 | [INFO] Settings: Mass Vhost: httpd-1 | [OK] Valid $MASS_VHOST_ENABLE Mass vhost Enabled httpd-1 | [OK] Valid $MASS_VHOST_DOCROOT_DIR Document root: /shared/httpd//htdocs httpd-1 | [OK] Valid $MASS_VHOST_TEMPLATE_DIR Template dir /shared/httpd//.devilbox httpd-1 | [OK] Valid $MASS_VHOST_ALIASES_ALLOW Defined Aliases /devilbox-api/ httpd-1 | [OK] Valid $MASS_VHOST_ALIASES_DENY Defined Aliases /.git, /.ht.* httpd-1 | [OK] Valid $MASS_VHOST_BACKEND PHP via PHP-FPM Remote: tcp://172.16.238.10:9000 httpd-1 | [OK] Valid $MASS_VHOST_BACKEND_REWRITE Backend overwrite /shared/httpd//.devilbox/backend.cfg httpd-1 | [OK] Valid $MASS_VHOST_BACKEND_TIMEOUT Timeout: 180sec mysql-1 | 2024-11-18 14:11:28+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.6.12+maria~ubu2004 started. httpd-1 | [OK] Valid $MASS_VHOST_SSL_TYPE Vhost protocol HTTP and HTTPS mysql-1 | 2024-11-18 14:11:28+00:00 [ERROR] [Entrypoint]: mariadbd failed while attempting to check config mysql-1 | command was: mysqld --verbose --help mysql-1 | mysqld: Can't read dir of '/etc/mysql/docker-default.d/' (Errcode: 13 "Permission denied") mysql-1 | Fatal error in defaults handling. Program aborted httpd-1 | [OK] Valid $MASS_VHOST_TLD_SUFFIX Vhost domain .dvl.to httpd-1 | [INFO] Settings: Misc: httpd-1 | [OK] Valid $WORKER_CONNECTIONS worker_connections 1024 httpd-1 | [OK] Valid $WORKER_PROCESSES worker_processes auto httpd-1 | [OK] Valid $HTTP2_ENABLE HTTP/2 Enabled httpd-1 | [OK] Valid $DOCKER_LOGS Log to stdout and stderr httpd-1 | [INFO] ------------------------------------------------------------------------- httpd-1 | [INFO] Apply Settings httpd-1 | [INFO] ------------------------------------------------------------------------- httpd-1 | [INFO] Setting uid to 1000 (user: nginx) httpd-1 | usermod: no changes httpd-1 | uid=1000(nginx) gid=1000(nginx) groups=1000(nginx),1000(nginx) httpd-1 | [INFO] Setting gid to 1000 (group: nginx) httpd-1 | uid=1000(nginx) gid=1000(nginx) groups=1000(nginx),1000(nginx) httpd-1 | [INFO] Skipping timezone. Already set to UTC: Mon Nov 18 14:11:28 UTC 2024 httpd-1 | [INFO] vhost-gen: no custom global template found in: /etc/vhost-gen.d/nginx.yml httpd-1 | vhost-gen: [INFO] Loading configuration file (-c): /etc/vhost-gen/main.yml httpd-1 | vhost-gen: [INFO] Loading vhost template (global) (-t): /etc/vhost-gen/templates-main/nginx.yml httpd-1 | vhost-gen: [INFO] Loading vhost template (override) (-o): /var/www/default/cfg/nginx.yml httpd-1 | vhost-gen: [INFO] Override Vhost template not found: /var/www/default/cfg/nginx.yml httpd-1 | vhost-gen: [INFO] Creating vhost type: https and http (both) httpd-1 | vhost-gen: [INFO] Using vhost name: localhost httpd-1 | vhost-gen: [INFO] Log setting: dir -> True httpd-1 | vhost-gen: [INFO] Log setting: Not specified httpd-1 | vhost-gen: [INFO] Vhost config written to: /etc/httpd/conf.d/localhost.conf httpd-1 | [WARN] (Re)creating Certificate Authority. You may need to (re)import it into your browser. httpd-1 | [FAIL] Failed to create Certificate Authority. httpd-1 | [FAIL] ca-gen -v -c DE -s Berlin -l Berlin -o Devilbox -u Devilbox -n 'Devilbox Root CA' -e 'cytopia@devilbox.org' "/ca/devilbox-ca.key" "/ca/devilbox-ca.crt" httpd-1 | ca-gen: [INFO] Create CA KEY file: /ca/devilbox-ca.key httpd-1 | ca-gen: [ERR] Command: openssl genrsa -out /ca/devilbox-ca.key 2048 httpd-1 | ca-gen: [ERR] Output: genrsa: Can't open "/ca/devilbox-ca.key" for writing, Permission denied mysql-1 exited with code 1 httpd-1 exited with code 1

mysqld: Can't read dir of '/etc/mysql/docker-default.d/' (Errcode: 13 "Permission denied") mysql-1 | Fatal error in defaults handling. Program aborted

httpd-1 | ca-gen: [ERR] Command: openssl genrsa -out /ca/devilbox-ca.key 2048 httpd-1 | ca-gen: [ERR] Output: genrsa: Can't open "/ca/devilbox-ca.key" for writing, Permission denied