search

tobybatch / kimai2

Docker containers for the kimai2 web application including docker-compose and kubernetes/helm deployment.
MIT License
181 stars 96 forks source link

[BUG] kimai2 white screen #468

Closed swoop124 closed 1 year ago

swoop124 commented 1 year ago

Hello,

Describe the bug i use Kimai2 since over two years or so and it worked great so far. But since yesterday, when i open the kimia2 homepage there is only a white screen.

To Reproduce Steps to reproduce the behaviour:

  1. Start the all kimai-container
  2. open the kimai site
  3. the page is white
  4. See error

Desktop (please complete the following information):

Command used to run the container

Docker compose file (with passwords redacted)

services:

  sqldb:
    image: mysql:5.7
    environment:
      - MYSQL_DATABASE=kimai
      - MYSQL_USER=user
      - MYSQL_PASSWORD=PW
      - MYSQL_ROOT_PASSWORD=PPW
    volumes:
      - /daten/docker/kimai2/db_data:/var/lib/mysql
      - /daten/docker/kimai2:/db
    command: --default-storage-engine innodb
    restart: unless-stopped
    healthcheck:
      test: mysqladmin -pPPW ping -h localhost
      interval: 20s
      start_period: 10s
      timeout: 10s
      retries: 3

  nginx: 
    image: tobybatch/nginx-fpm-reverse-proxy
    ports:
      - 8001:80
    volumes:
      - /daten/docker/kimai2/public:/opt/kimai/public:ro
    restart: unless-stopped
    depends_on:
      - kimai
    healthcheck:
      test:  wget --spider http://nginx/health || exit 1
      interval: 20s
      start_period: 10s
      timeout: 10s
      retries: 3

  kimai: # This is the latest FPM image of kimai
    image: kimai/kimai2:fpm
    environment:
      - ADMINMAIL=office@mydomain.tld
      - ADMINPASS=PPW
      - DATABASE_URL=mysql://user:PW@sqldb/kimai
      - TRUSTED_HOSTS=nginx,localhost,127.0.0.1,docker3.mydomain.tld,192.168.251.59,kimai.mydomain.tld
    volumes:
      - /daten/docker/kimai2/public:/opt/kimai/public
      - /daten/docker/kimai2/var/invoices:/opt/kimai/var/invoices
      - /daten/docker/kimai2/var/data:/opt/kimai/var/data
      # - ./ldap.conf:/etc/openldap/ldap.conf:z
      # - ./ROOT-CA.pem:/etc/ssl/certs/ROOT-CA.pem:z
    restart: unless-stopped

  postfix:
    image: catatnight/postfix:latest
    environment:
      maildomain: mydomain.tld
      smtp_user: kimai:kimai
    restart: unless-stopped

Additional context it was working til yesterday afternoon, then i had to reboot the server. After the reboot this problem was present.

After this happened, i tried debian update and upgrade and even moved to a second docker server i have. I updated docker and docker-compose

I get this logs:

Creating network "kimai2_default" with the default driver
Creating kimai2_sqldb_1   ... done
Creating kimai2_postfix_1 ... done
Creating kimai2_kimai_1   ... done
Creating kimai2_nginx_1   ... done
Attaching to kimai2_postfix_1, kimai2_sqldb_1, kimai2_kimai_1, kimai2_nginx_1
kimai_1    |
kimai_1    | Wait for MySQL DB connection ...
kimai_1    | Testing DB:** new \PDO(mysql:host=sqldb;dbname=kimai;port=3306, kimaiuser, lCJW459bWOjPHQIevLflPgYs, [ \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION ]);*Connection established 
kimai_1    | /startup.sh: line 41: [: : integer expression expected
kimai_1    | /startup.sh: line 44: assets/monolog.yaml: No such file or directory
kimai_1    | tar: public/touch-icon-512x512.png: Cannot open: Permission denied
kimai_1    | tar: public/apple-touch-icon-precomposed.png: Cannot open: Permission denied
kimai_1    | tar: public/.htaccess: Cannot open: File exists
kimai_1    | tar: public/favicon-16x16.png: Cannot open: Permission denied
kimai_1    | tar: public/index.php: Cannot open: File exists
kimai_1    | tar: public/manifest.json: Cannot open: File exists
kimai_1    | tar: public/favicon.ico: Cannot open: File exists
kimai_1    | tar: public/browserconfig.xml: Cannot open: File exists
kimai_1    | tar: public/touch-icon-192x192.png: Cannot open: File exists
kimai_1    | tar: public/wizard: Cannot mkdir: Permission denied
kimai_1    | tar: public/wizard: Cannot mkdir: Permission denied
kimai_1    | tar: public/wizard/time-management.png: Cannot open: No such file or directory
kimai_1    | tar: public/wizard: Cannot mkdir: Permission denied
kimai_1    | tar: public/wizard/done.png: Cannot open: No such file or directory
kimai_1    | tar: public/touch-icon-180x180.png: Cannot open: Permission denied
kimai_1    | tar: public/favicon-32x32.png: Cannot open: File exists
kimai_1    | tar: public/apple-touch-icon.png: Cannot open: File exists
kimai_1    | tar: public/robots.txt: Cannot open: File exists
kimai_1    | tar: public: Cannot utime: Operation not permitted
kimai_1    | tar: Exiting with failure status due to previous errors
kimai_1    |
kimai_1    | Kimai installation running ...
kimai_1    | ==============================
kimai_1    |
kimai_1    | Database `kimai` for connection named default already exists. Skipped.
kimai_1    |
kimai_1    |  [OK] Already at the latest version ("DoctrineMigrations\Version20230126002049")
kimai_1    |
kimai_1    |
kimai_1    |  Rebuilding your cache, please be patient ...
kimai_1    |
kimai_1    |  // Clearing the cache for the prod environment with debug false
kimai_1    |
postfix_1  | find: `/etc/postfix/certs': No such file or directory
sqldb_1    | 2023-02-10 16:07:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.
postfix_1  | find: `/etc/opendkim/domainkeys': No such file or directory
sqldb_1    | 2023-02-10 16:07:36+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
postfix_1  | 2023-02-10 16:07:36,442 CRIT Supervisor running as root (no user in config file)
postfix_1  | 2023-02-10 16:07:36,442 WARN Included extra file "/etc/supervisor/conf.d/supervisord.conf" during parsing
postfix_1  | 2023-02-10 16:07:36,466 INFO RPC interface 'supervisor' initialized
postfix_1  | 2023-02-10 16:07:36,466 CRIT Server 'unix_http_server' running without any HTTP authentication checking
postfix_1  | 2023-02-10 16:07:36,467 INFO supervisord started with pid 24
sqldb_1    | 2023-02-10 16:07:36+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.
postfix_1  | 2023-02-10 16:07:37,478 INFO spawned: 'postfix' with pid 34
postfix_1  | 2023-02-10 16:07:37,479 INFO spawned: 'rsyslog' with pid 35
sqldb_1    | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
sqldb_1    | 2023-02-10T16:07:36.606912Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
sqldb_1    | 2023-02-10T16:07:36.608096Z 0 [Note] mysqld (mysqld 5.7.41) starting as process 1 ...
sqldb_1    | 2023-02-10T16:07:36.611111Z 0 [Note] InnoDB: PUNCH HOLE support available
sqldb_1    | 2023-02-10T16:07:36.611130Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
sqldb_1    | 2023-02-10T16:07:36.611135Z 0 [Note] InnoDB: Uses event mutexes
sqldb_1    | 2023-02-10T16:07:36.611138Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
sqldb_1    | 2023-02-10T16:07:36.611142Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
sqldb_1    | 2023-02-10T16:07:36.611148Z 0 [Note] InnoDB: Using Linux native AIO
sqldb_1    | 2023-02-10T16:07:36.611361Z 0 [Note] InnoDB: Number of pools: 1
sqldb_1    | 2023-02-10T16:07:36.611447Z 0 [Note] InnoDB: Using CPU crc32 instructions
sqldb_1    | 2023-02-10T16:07:36.612800Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
sqldb_1    | 2023-02-10T16:07:36.620743Z 0 [Note] InnoDB: Completed initialization of buffer pool
sqldb_1    | 2023-02-10T16:07:36.622325Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().        
sqldb_1    | 2023-02-10T16:07:36.640375Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
sqldb_1    | 2023-02-10T16:07:36.781923Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
sqldb_1    | 2023-02-10T16:07:36.781983Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
sqldb_1    | 2023-02-10T16:07:36.896241Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
sqldb_1    | 2023-02-10T16:07:36.896826Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
sqldb_1    | 2023-02-10T16:07:36.896834Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
sqldb_1    | 2023-02-10T16:07:36.897068Z 0 [Note] InnoDB: Waiting for purge to start
sqldb_1    | 2023-02-10T16:07:36.947184Z 0 [Note] InnoDB: 5.7.41 started; log sequence number 22661149
sqldb_1    | 2023-02-10T16:07:36.947416Z 0 [Note] Plugin 'FEDERATED' is disabled.
sqldb_1    | 2023-02-10T16:07:36.947600Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
sqldb_1    | 2023-02-10T16:07:36.962646Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
sqldb_1    | 2023-02-10T16:07:36.962662Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
sqldb_1    | 2023-02-10T16:07:36.962665Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
sqldb_1    | 2023-02-10T16:07:36.962667Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
sqldb_1    | 2023-02-10T16:07:36.963655Z 0 [Warning] CA certificate ca.pem is self signed.
sqldb_1    | 2023-02-10T16:07:36.963688Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
sqldb_1    | 2023-02-10T16:07:36.963897Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
sqldb_1    | 2023-02-10T16:07:36.963921Z 0 [Note] IPv6 is available.
sqldb_1    | 2023-02-10T16:07:36.963929Z 0 [Note]   - '::' resolves to '::';
sqldb_1    | 2023-02-10T16:07:36.963943Z 0 [Note] Server socket created on IP: '::'.
sqldb_1    | 2023-02-10T16:07:36.999992Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230210 16:07:36
sqldb_1    | 2023-02-10T16:07:37.010233Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
sqldb_1    | 2023-02-10T16:07:37.065239Z 0 [Warning] Optional native table 'performance_schema'.'processlist' has the wrong structure or is missing.
sqldb_1    | 2023-02-10T16:07:37.065971Z 0 [Note] Event Scheduler: Loaded 0 events
sqldb_1    | 2023-02-10T16:07:37.066123Z 0 [Note] mysqld: ready for connections.
sqldb_1    | Version: '5.7.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
postfix_1  | 2023-02-10 16:07:38,544 INFO success: postfix entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
postfix_1  | 2023-02-10 16:07:38,544 INFO success: rsyslog entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
postfix_1  | 2023-02-10 16:07:38,578 INFO exited: postfix (exit status 1; not expected)
postfix_1  | 2023-02-10 16:07:39,580 INFO spawned: 'postfix' with pid 102
postfix_1  | 2023-02-10 16:07:40,643 INFO success: postfix entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
kimai_1    | PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 32768 bytes) in /opt/kimai/var/cache/pro_/twig/60/60cede130964e7514cc23eb34d2257a4.php on line 82
kimai_1    | PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 32768 bytes) in /opt/kimai/vendor/symfony/var-dumper/Dumper/CliDumper.php on line 1
kimai_1    | 
kimai_1    | Kimai updates running ...
kimai_1    | =========================
kimai_1    |
kimai_1    | 
kimai_1    |  [OK] Already at the latest version ("DoctrineMigrations\Version20230126002049")
kimai_1    |
kimai_1    |
kimai_1    |  Rebuilding your cache, please be patient ...
kimai_1    |
kimai_1    |  // Clearing the cache for the prod environment with debug false
kimai_1    |
kimai_1    | PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /opt/kimai/vendor/twig/twig/src/Node/PrintNode.php on line 27
kimai_1    | PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 32768 bytes) in /opt/kimai/vendor/symfony/error-handler/Error/OutOfMemoryError.php on line 1
kimai_1    | 
kimai_1    |
kimai_1    |   The command "kimai:reset:locales" does not exist.
kimai_1    |
kimai_1    |
kimai_1    | Kimai2 ready
kimai_1    | 
kimai_1    | Reloading configurations ...
kimai_1    | ============================
kimai_1    |
kimai_1    | 
kimai_1    |  [OK] All 25 YAML files contain valid syntax.
kimai_1    |
kimai_1    |
kimai_1    | 
kimai_1    |  [OK] All 513 XLIFF files contain valid syntax.
kimai_1    |
kimai_1    |
kimai_1    |  Rebuilding your cache, please be patient ...
kimai_1    | 
kimai_1    |  // Clearing the cache for the prod environment with debug false
kimai_1    |
nginx_1    | 192.168.240.5 - - [10/Feb/2023:16:07:58 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
kimai_1    | PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /opt/kimai/vendor/twig/twig/src/Node/Expression/ConstantExpression.php on line 21
kimai_1    | PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /opt/kimai/vendor/monolog/monolog/src/Monolog/Formatter/LineFormatter.php on line 61
kimai_1    | [10-Feb-2023 17:07:58] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root
kimai_1    | [10-Feb-2023 17:07:58] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root
kimai_1    | [10-Feb-2023 17:07:58] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root
kimai_1    | [10-Feb-2023 17:07:58] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root
kimai_1    | [10-Feb-2023 17:07:58] NOTICE: fpm is running, pid 1
kimai_1    | [10-Feb-2023 17:07:58] NOTICE: ready to handle connections
kimai_1    | 192.168.240.5 -  10/Feb/2023:17:08:13 +0100 "GET /index.php" 500
kimai_1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23    
kimai_1    | Stack trace:
kimai_1    | #0 {main}
kimai_1    |   thrown in /opt/kimai/public/index.php on line 23
nginx_1    | 2023/02/10 16:08:13 [error] 8#8: *2 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
nginx_1    | Stack trace:
nginx_1    | #0 {main}
nginx_1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.240.1, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://192.168.240.4:9000", host: "docker3.domain.tld:8001"
nginx_1    | 192.168.240.1 - - [10/Feb/2023:16:08:13 +0000] "GET / HTTP/1.1" 500 5 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0" "-"
nginx_1    | 192.168.240.1 - - [10/Feb/2023:16:08:13 +0000] "GET /favicon.ico HTTP/1.1" 200 1150 "http://docker3.domain.tld:8001/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0" "-"
kimai_1    | 127.0.0.1 -  10/Feb/2023:17:08:17 +0100 "GET /ping" 404
nginx_1    | 192.168.240.5 - - [10/Feb/2023:16:08:18 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
kimai_1    | 127.0.0.1 -  10/Feb/2023:17:08:37 +0100 "GET /ping" 404

to get my instance working again, i switched back to version fpm-1.30.6-prod But i rather would like to work with the new version.

tobybatch commented 1 year ago

You're running out of memory/thread 

PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /opt/kimai/vendor/twig/twig/src/Node/PrintNode.php on line 27

Are you running with a lot of plugins?

tobybatch commented 1 year ago

You can up the memory limit at run time using:

-e memory_limit=512

or

    environment:
      - memory_limit=512
swoop124 commented 1 year ago

Hello tobybatch,

no Plugins installed, according to Plugins Tab.

thanks for the memmory advice, now this message is gon, but the problem is now a 500 internal server error:

root@docker3:/daten/docker/kimai2# docker-compose up -d && docker-compose logs -f
[+] Running 5/5
 ⠿ Network kimai2_default      Created                                                                                                                                     0.2s 
 ⠿ Container kimai2-sqldb-1    Started                                                                                                                                    15.2s
 ⠿ Container kimai2-kimai-1    Started                                                                                                                                    15.8s 
 ⠿ Container kimai2-postfix-1  Started                                                                                                                                    15.0s 
 ⠿ Container kimai2-nginx-1    Started                                                                                                                                     8.4s
kimai2-postfix-1  | find: `/etc/postfix/certs': No such file or directory
kimai2-sqldb-1    | 2023-02-10 23:20:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.
kimai2-postfix-1  | find: `/etc/opendkim/domainkeys': No such file or directory
kimai2-postfix-1  | 2023-02-10 23:20:17,624 CRIT Supervisor running as root (no user in config file)
kimai2-postfix-1  | 2023-02-10 23:20:17,624 WARN Included extra file "/etc/supervisor/conf.d/supervisord.conf" during parsing
kimai2-postfix-1  | 2023-02-10 23:20:17,643 INFO RPC interface 'supervisor' initialized
kimai2-postfix-1  | 2023-02-10 23:20:17,643 CRIT Server 'unix_http_server' running without any HTTP authentication checking
kimai2-postfix-1  | 2023-02-10 23:20:17,643 INFO supervisord started with pid 24
kimai2-sqldb-1    | 2023-02-10 23:20:17+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
kimai2-sqldb-1    | 2023-02-10 23:20:17+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.
kimai2-sqldb-1    | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
kimai2-sqldb-1    | 2023-02-10T23:20:17.684360Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
kimai2-sqldb-1    | 2023-02-10T23:20:17.685270Z 0 [Note] mysqld (mysqld 5.7.41) starting as process 1 ...
kimai2-sqldb-1    | 2023-02-10T23:20:17.707333Z 0 [Note] InnoDB: PUNCH HOLE support available
kimai2-sqldb-1    | 2023-02-10T23:20:17.707356Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
kimai2-sqldb-1    | 2023-02-10T23:20:17.707359Z 0 [Note] InnoDB: Uses event mutexes
kimai2-sqldb-1    | 2023-02-10T23:20:17.707361Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
kimai2-sqldb-1    | 2023-02-10T23:20:17.707363Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
kimai2-sqldb-1    | 2023-02-10T23:20:17.707366Z 0 [Note] InnoDB: Using Linux native AIO
kimai2-sqldb-1    | 2023-02-10T23:20:17.707517Z 0 [Note] InnoDB: Number of pools: 1
kimai2-sqldb-1    | 2023-02-10T23:20:17.707590Z 0 [Note] InnoDB: Using CPU crc32 instructions
kimai2-sqldb-1    | 2023-02-10T23:20:17.708721Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
kimai2-sqldb-1    | 2023-02-10T23:20:17.714097Z 0 [Note] InnoDB: Completed initialization of buffer pool
kimai2-sqldb-1    | 2023-02-10T23:20:17.715460Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
kimai2-sqldb-1    | 2023-02-10T23:20:17.726817Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
kimai2-sqldb-1    | 2023-02-10T23:20:17.790543Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
kimai2-sqldb-1    | 2023-02-10T23:20:17.790614Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
kimai2-sqldb-1    | 2023-02-10T23:20:17.943115Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
kimai2-sqldb-1    | 2023-02-10T23:20:17.943720Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
kimai2-sqldb-1    | 2023-02-10T23:20:17.943731Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
kimai2-sqldb-1    | 2023-02-10T23:20:17.944044Z 0 [Note] InnoDB: 5.7.41 started; log sequence number 811674185
kimai2-sqldb-1    | 2023-02-10T23:20:17.944148Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
kimai2-sqldb-1    | 2023-02-10T23:20:17.944281Z 0 [Note] Plugin 'FEDERATED' is disabled.
kimai2-sqldb-1    | 2023-02-10T23:20:17.945669Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230210 23:20:17
kimai2-sqldb-1    | 2023-02-10T23:20:17.947980Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
kimai2-sqldb-1    | 2023-02-10T23:20:17.947993Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
kimai2-sqldb-1    | 2023-02-10T23:20:17.947997Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
kimai2-sqldb-1    | 2023-02-10T23:20:17.947999Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
kimai2-sqldb-1    | 2023-02-10T23:20:17.948419Z 0 [Warning] CA certificate ca.pem is self signed.
kimai2-sqldb-1    | 2023-02-10T23:20:17.948452Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
kimai2-sqldb-1    | 2023-02-10T23:20:17.948664Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
kimai2-sqldb-1    | 2023-02-10T23:20:17.948693Z 0 [Note] IPv6 is available.
kimai2-sqldb-1    | 2023-02-10T23:20:17.948702Z 0 [Note]   - '::' resolves to '::';
kimai2-sqldb-1    | 2023-02-10T23:20:17.948716Z 0 [Note] Server socket created on IP: '::'.
kimai2-sqldb-1    | 2023-02-10T23:20:18.040174Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
kimai2-sqldb-1    | 2023-02-10T23:20:18.046402Z 0 [Warning] Optional native table 'performance_schema'.'processlist' has the wrong structure or is missing.
kimai2-sqldb-1    | 2023-02-10T23:20:18.046575Z 0 [Note] Event Scheduler: Loaded 0 events
kimai2-sqldb-1    | 2023-02-10T23:20:18.046685Z 0 [Note] mysqld: ready for connections.
kimai2-sqldb-1    | Version: '5.7.41'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
kimai2-kimai-1    |
kimai2-kimai-1    | Wait for MySQL DB connection ...
kimai2-kimai-1    | Testing DB:** new \PDO(mysql:host=sqldb;dbname=kimai;port=3306, kimaiuser, lCJW459bWOjPHQIevLflPgYs, [ \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION ]);*Connection established
kimai2-kimai-1    | /startup.sh: line 41: [: : integer expression expected
kimai2-kimai-1    | /startup.sh: line 44: assets/monolog.yaml: No such file or directory
kimai2-kimai-1    | tar: public/touch-icon-512x512.png: Cannot open: Permission denied
kimai2-kimai-1    | tar: public/apple-touch-icon-precomposed.png: Cannot open: Permission denied
kimai2-kimai-1    | tar: public/.htaccess: Cannot open: File exists
kimai2-kimai-1    | tar: public/favicon-16x16.png: Cannot open: Permission denied
kimai2-kimai-1    | tar: public/index.php: Cannot open: File exists
kimai2-kimai-1    | tar: public/manifest.json: Cannot open: File exists
kimai2-kimai-1    | tar: public/favicon.ico: Cannot open: File exists
kimai2-kimai-1    | tar: public/browserconfig.xml: Cannot open: File exists
kimai2-kimai-1    | tar: public/touch-icon-192x192.png: Cannot open: File exists
kimai2-kimai-1    | tar: public/wizard: Cannot mkdir: Permission denied
kimai2-kimai-1    | tar: public/wizard: Cannot mkdir: Permission denied
kimai2-kimai-1    | tar: public/wizard/time-management.png: Cannot open: No such file or directory
kimai2-kimai-1    | tar: public/wizard: Cannot mkdir: Permission denied
kimai2-kimai-1    | tar: public/wizard/done.png: Cannot open: No such file or directory
kimai2-kimai-1    | tar: public/touch-icon-180x180.png: Cannot open: Permission denied
kimai2-kimai-1    | tar: public/favicon-32x32.png: Cannot open: File exists
kimai2-kimai-1    | tar: public/apple-touch-icon.png: Cannot open: File exists
kimai2-kimai-1    | tar: public/robots.txt: Cannot open: File exists
kimai2-kimai-1    | tar: public: Cannot utime: Operation not permitted
kimai2-kimai-1    | tar: Exiting with failure status due to previous errors
kimai2-kimai-1    |
kimai2-kimai-1    | Kimai installation running ...
kimai2-kimai-1    | ==============================
kimai2-kimai-1    |
kimai2-kimai-1    | Database `kimai` for connection named default already exists. Skipped.
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Already at the latest version ("DoctrineMigrations\Version20230126002049")
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  Rebuilding your cache, please be patient ...
kimai2-kimai-1    |
kimai2-kimai-1    |  // Clearing the cache for the prod environment with debug false
kimai2-kimai-1    |
kimai2-postfix-1  | 2023-02-10 23:20:18,645 INFO spawned: 'postfix' with pid 27
kimai2-postfix-1  | 2023-02-10 23:20:18,646 INFO spawned: 'rsyslog' with pid 28
kimai2-postfix-1  | 2023-02-10 23:20:19,633 INFO exited: postfix (exit status 1; not expected)
kimai2-postfix-1  | 2023-02-10 23:20:20,634 INFO spawned: 'postfix' with pid 95
kimai2-postfix-1  | 2023-02-10 23:20:20,635 INFO success: rsyslog entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
kimai2-postfix-1  | 2023-02-10 23:20:21,671 INFO success: postfix entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
kimai2-kimai-1    |  [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  // Warming up the cache for the prod environment with debug false
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Cache for the "prod" environment (debug=false) was successfully warmed.   
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Congratulations! Successfully installed Kimai version 2.0.0
kimai2-kimai-1    |
kimai2-kimai-1    | 
kimai2-kimai-1    | Kimai updates running ...
kimai2-kimai-1    | =========================
kimai2-kimai-1    |
kimai2-kimai-1    | 
kimai2-kimai-1    |  [OK] Already at the latest version ("DoctrineMigrations\Version20230126002049")
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  Rebuilding your cache, please be patient ...
kimai2-kimai-1    |
kimai2-kimai-1    |  // Clearing the cache for the prod environment with debug false
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  // Warming up the cache for the prod environment with debug false
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Cache for the "prod" environment (debug=false) was successfully warmed.   
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Congratulations! Successfully updated Kimai to version 2.0.0
kimai2-kimai-1    |
kimai2-kimai-1    | 
kimai2-kimai-1    |
kimai2-kimai-1    |   The command "kimai:reset:locales" does not exist.
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    | Kimai2 ready
kimai2-kimai-1    | 
kimai2-kimai-1    | Reloading configurations ...
kimai2-kimai-1    | ============================
kimai2-kimai-1    |
kimai2-kimai-1    | 
kimai2-kimai-1    |  [OK] All 25 YAML files contain valid syntax.
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-nginx-1    | 172.25.0.5 - - [10/Feb/2023:23:20:38 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
kimai2-kimai-1    | 
kimai2-kimai-1    |  [OK] All 513 XLIFF files contain valid syntax.
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  Rebuilding your cache, please be patient ...
kimai2-kimai-1    |
kimai2-kimai-1    |  // Clearing the cache for the prod environment with debug false
kimai2-kimai-1    |
kimai2-nginx-1    | 172.25.0.1 - - [10/Feb/2023:23:20:42 +0000] "GET / HTTP/1.1" 502 158 "-" "axios/0.27.2" "10.10.10.212"
kimai2-nginx-1    | 2023/02/10 23:20:42 [error] 8#8: *2 connect() failed (111: Connection refused) while connecting to upstream, client: 172.25.0.1, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-kimai-1    |  [OK] Cache for the "prod" environment (debug=false) was successfully cleared.  
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  // Warming up the cache for the prod environment with debug false
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Cache for the "prod" environment (debug=false) was successfully warmed.   
kimai2-kimai-1    |
kimai2-kimai-1    |
kimai2-kimai-1    |  [OK] Kimai config was reloaded
kimai2-kimai-1    |
kimai2-kimai-1    | [11-Feb-2023 00:20:47] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root
kimai2-kimai-1    | [11-Feb-2023 00:20:47] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root
kimai2-kimai-1    | [11-Feb-2023 00:20:47] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root
kimai2-kimai-1    | [11-Feb-2023 00:20:47] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root
kimai2-kimai-1    | [11-Feb-2023 00:20:47] NOTICE: fpm is running, pid 1
kimai2-kimai-1    | [11-Feb-2023 00:20:47] NOTICE: ready to handle connections
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:20:57 +0100 "GET /index.php" 500
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | 2023/02/10 23:20:57 [error] 8#8: *4 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.251.59, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-nginx-1    | 192.168.251.59 - - [10/Feb/2023:23:20:57 +0000] "GET / HTTP/1.1" 500 5 "-" "axios/0.27.2" "10.10.10.212"
kimai2-kimai-1    | 127.0.0.1 -  11/Feb/2023:00:20:58 +0100 "GET /ping" 404
kimai2-nginx-1    | 172.25.0.5 - - [10/Feb/2023:23:20:59 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:21:15 +0100 "GET /index.php" 500
kimai2-nginx-1    | 192.168.251.59 - - [10/Feb/2023:23:21:15 +0000] "GET / HTTP/1.1" 500 5 "-" "axios/0.27.2" "10.10.10.212"
kimai2-nginx-1    | 2023/02/10 23:21:15 [error] 8#8: *7 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.251.59, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-kimai-1    | 127.0.0.1 -  11/Feb/2023:00:21:18 +0100 "GET /ping" 404
kimai2-nginx-1    | 172.25.0.5 - - [10/Feb/2023:23:21:19 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:21:26 +0100 "GET /index.php" 500
kimai2-nginx-1    | 192.168.251.59 - - [10/Feb/2023:23:21:26 +0000] "GET /de/doctor HTTP/1.1" 500 5 "https://kimai.domain.tld/de/admin/plugins/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.76" "2a05:1142:1::2ef9"
kimai2-nginx-1    | 2023/02/10 23:21:26 [error] 8#8: *10 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.251.59, server: nginx, request: "GET /de/doctor HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld", referrer: "https://kimai.domain.tld/de/admin/plugins/"
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:21:32 +0100 "GET /index.php" 500
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-nginx-1    | 2023/02/10 23:21:32 [error] 8#8: *12 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.251.59, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-nginx-1    | 192.168.251.59 - - [10/Feb/2023:23:21:32 +0000] "GET / HTTP/1.1" 500 5 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.76" "2a05:1142:::2ef9"
kimai2-kimai-1    | 127.0.0.1 -  11/Feb/2023:00:21:38 +0100 "GET /ping" 404
kimai2-nginx-1    | 172.25.0.5 - - [10/Feb/2023:23:21:39 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:21:42 +0100 "GET /index.php" 500
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-nginx-1    | 2023/02/10 23:21:42 [error] 8#8: *15 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 172.25.0.1, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-nginx-1    | 172.25.0.1 - - [10/Feb/2023:23:21:42 +0000] "GET / HTTP/1.1" 500 5 "-" "axios/0.27.2" "10.10.10.212"
kimai2-nginx-1    | 2023/02/10 23:21:44 [error] 8#8: *17 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:21:44 +0100 "GET /index.php" 500
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.251.59, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-nginx-1    | 192.168.251.59 - - [10/Feb/2023:23:21:44 +0000] "GET / HTTP/1.1" 500 5 "-" "axios/0.27.2" "10.10.10.212"
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:21:57 +0100 "GET /index.php" 500
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-nginx-1    | 172.25.0.1 - - [10/Feb/2023:23:21:57 +0000] "GET / HTTP/1.1" 500 5 "-" "axios/0.27.2" "10.10.10.212"
kimai2-nginx-1    | 2023/02/10 23:21:57 [error] 8#8: *19 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 172.25.0.1, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-kimai-1    | 127.0.0.1 -  11/Feb/2023:00:21:58 +0100 "GET /ping" 404
kimai2-nginx-1    | 172.25.0.5 - - [10/Feb/2023:23:22:00 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:22:10 +0100 "GET /index.php" 500
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-nginx-1    | 192.168.251.59 - - [10/Feb/2023:23:22:10 +0000] "GET / HTTP/1.1" 500 5 "-" "axios/0.27.2" "10.10.10.212"
kimai2-nginx-1    | 2023/02/10 23:22:10 [error] 8#8: *22 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.251.59, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-nginx-1    | 2023/02/10 23:22:14 [error] 8#8: *24 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 172.25.0.1, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "docker3.domain.tld:8001"
kimai2-nginx-1    | 172.25.0.1 - - [10/Feb/2023:23:22:14 +0000] "GET / HTTP/1.1" 500 5 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36 Edg/108.0.1462.76" "-"
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:22:14 +0100 "GET /index.php" 500
kimai2-kimai-1    | NOTICE: PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-kimai-1    | Stack trace:
kimai2-kimai-1    | 172.25.0.5 -  11/Feb/2023:00:22:15 +0100 "GET /index.php" 500
kimai2-kimai-1    | #0 {main}
kimai2-kimai-1    |   thrown in /opt/kimai/public/index.php on line 23
kimai2-nginx-1    | 192.168.251.59 - - [10/Feb/2023:23:22:15 +0000] "GET / HTTP/1.1" 500 5 "-" "axios/0.27.2" "10.10.10.212"
kimai2-nginx-1    | 2023/02/10 23:22:15 [error] 8#8: *27 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Undefined constant Symfony\Component\HttpFoundation\Request::HEADER_X_FORWARDED_ALL in /opt/kimai/public/index.php:23
kimai2-nginx-1    | Stack trace:
kimai2-nginx-1    | #0 {main}
kimai2-nginx-1    |   thrown in /opt/kimai/public/index.php on line 23" while reading response header from upstream, client: 192.168.251.59, server: nginx, request: "GET / HTTP/1.1", upstream: "fastcgi://172.25.0.4:9000", host: "kimai.domain.tld"
kimai2-kimai-1    | 127.0.0.1 -  11/Feb/2023:00:22:18 +0100 "GET /ping" 404
kimai2-nginx-1    | 172.25.0.5 - - [10/Feb/2023:23:22:20 +0000] "GET /health HTTP/1.1" 200 5 "-" "Wget" "-"
^Ccanceled
root@docker3:/daten/docker/kimai2# docker-compose down
[+] Running 5/5
 ⠿ Container kimai2-nginx-1    Removed                                                                                                                                     1.1s 
 ⠿ Container kimai2-postfix-1  Removed                                                                                                                                    11.1s 
 ⠿ Container kimai2-sqldb-1    Removed                                                                                                                                     2.5s 
 ⠿ Container kimai2-kimai-1    Removed                                                                                                                                     1.1s
 ⠿ Network kimai2_default      Removed                                                                                                                                     0.4s

OK, there are some permission errors. So i changed /publics owner to 82:82 All inside this folder have 82:82 as owner already. How should the permissions be correctly? Maybe i should correct the permissions? After i changed the permissions, the login screen appears but without the logo. There is only a placeholder. This happens when i try to connect to servers-IP:8001 (docker3.domain.tld:8001) but not when i brows to kimai.domain.tld (over nginx proxy manager). It takes forever to load. So i will try it on another docker server and report back.

swoop124 commented 1 year ago

Hello,

i tested it on the second docker server and now it looks very good. Good Job with the new look. It looks like the previous docker server is little overloaded.

thanks again

thanks for your help.

hexxone commented 1 year ago

It seems I just had the same permission problem after updating to the latest version:

image_2023-02-15_10-27-51

went as root into the container, set the permissions manually and I hope thats enough to fix it for now.

But I dont actually think so because the folder is not persisted in any way by default?

Might this be a freshly introduced bug, or is there a way to fix the perms in Dockerfile?

Anyway here is what I did:

#-u 0 = as root
docker exec -it -u 0 kimai bash   
chown -R www-data var/
chmod -R 777 var/
swoop124 commented 1 year ago

hi,

I did the permissions through the host. I went into to folder of kimai, then i changed the permissions of the folder publicwith: chown 82:82 public Then restart kimai.

All Folder and Files in publicshould be owned by 82:82. At least that is it on my system.