Client: Docker Engine - Community
Version: 23.0.1
API version: 1.42
Go version: go1.19.5
Git commit: a5ee5b1
Built: Thu Feb 9 19:46:49 2023
OS/Arch: linux/arm64
Context: default
invoiceninja/docker v5
Describe the bug
After setup of invoiceninja/docker following this video https://www.youtube.com/watch?v=xo6a3KtLC2g I go to http://10.10.1.3:8010 an oversized background image of a invoiceninja loads. At the bottom of the page there is a url that says "500 - Server Error Back 10.10.1.3" when I click on the link it takes me to http://10.10.1.3:8010/client with the same background image and error at the bottom of the page.
dockerfiles-db-1.log
2023-03-28T14:31:39.097097991Z 2023-03-28 14:31:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-28T14:31:39.887614029Z 2023-03-28 14:31:39+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-03-28T14:31:39.925300793Z 2023-03-28 14:31:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-28T14:31:40.805140147Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-03-28T14:31:41.591960755Z 2023-03-28T14:31:41.575893Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-03-28T14:31:41.592047477Z 2023-03-28T14:31:41.582677Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
2023-03-28T14:31:41.606416337Z 2023-03-28T14:31:41.605960Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-28T14:31:42.900450837Z 2023-03-28T14:31:42.899987Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-28T14:31:43.602217601Z 2023-03-28T14:31:43.600287Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-03-28T14:31:43.602301601Z 2023-03-28T14:31:43.600439Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-03-28T14:31:43.629304011Z 2023-03-28T14:31:43.628004Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-03-28T14:31:43.731139488Z 2023-03-28T14:31:43.730776Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-03-28T14:31:43.732448836Z 2023-03-28T14:31:43.732099Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
2023-03-28T15:03:29.853569308Z 2023-03-28T15:03:29.853166Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user . Shutting down mysqld (Version: 8.0.32).
2023-03-28T15:03:31.856453825Z 2023-03-28T15:03:31.855940Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 11 user: 'ninja'.
2023-03-28T15:03:31.856954152Z 2023-03-28T15:03:31.856525Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 12 user: 'ninja'.
2023-03-28T15:03:32.695638552Z 2023-03-28T15:03:32.695311Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-03-28T15:03:34.435197574Z 2023-03-28 15:03:34+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-28T15:03:35.246983624Z 2023-03-28 15:03:35+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-03-28T15:03:35.286696363Z 2023-03-28 15:03:35+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-28T15:03:36.117841386Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-03-28T15:03:36.891365247Z 2023-03-28T15:03:36.862919Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-03-28T15:03:36.891680169Z 2023-03-28T15:03:36.869831Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
2023-03-28T15:03:36.895937936Z 2023-03-28T15:03:36.894188Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-28T15:04:10.460046959Z 2023-03-28T15:04:10.459144Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-28T15:04:11.272126895Z 2023-03-28T15:04:11.271807Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-03-28T15:04:11.272426262Z 2023-03-28T15:04:11.272107Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-03-28T15:04:11.307698578Z 2023-03-28T15:04:11.301805Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-03-28T15:04:11.413447507Z 2023-03-28T15:04:11.413048Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-03-28T15:04:11.414348812Z 2023-03-28T15:04:11.414001Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
dockerfiles-app-1
[28-Mar-2023 15:04:19] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root
[28-Mar-2023 15:04:19] NOTICE: fpm is running, pid 54
[28-Mar-2023 15:04:19] NOTICE: ready to handle connections
2023-03-28 15:04:20,299 INFO success: shutdown entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-03-28 15:04:20,300 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-03-28 15:04:20,300 INFO success: queue-worker_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-03-28 15:04:20,302 INFO success: queue-worker_01 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-03-28 15:04:20,303 INFO success: scheduler entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
172.20.0.4 - 28/Mar/2023:15:04:28 +0000 "GET /index.php" 500
172.20.0.4 - 28/Mar/2023:15:04:35 +0000 "GET /index.php" 500
2023-03-28 15:05:01 Running [queue-size-job] ..................... 92ms DONE
2023-03-28 15:05:01 Running [Callback] .......................... 138ms DONE
2023-03-28 15:05:02 App\Jobs\Ninja\QueueSize ....................... RUNNING
2023-03-28 15:05:02 App\Jobs\Ninja\QueueSize .................. 47.13ms DONE
172.20.0.4 - 28/Mar/2023:15:05:23 +0000 "GET /index.php" 500
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:10:01 Running [queue-size-job] ..................... 88ms DONE
2023-03-28 15:10:01 Running [task-scheduler-job] ................. 48ms DONE
2023-03-28 15:10:01 Running [Callback] ........................... 47ms DONE
2023-03-28 15:10:03 App\Jobs\Ninja\QueueSize ....................... RUNNING
2023-03-28 15:10:03 App\Jobs\Ninja\QueueSize .................. 28.29ms DONE
2023-03-28 15:10:03 App\Jobs\Ninja\TaskScheduler ................... RUNNING
2023-03-28 15:10:03 App\Jobs\Ninja\TaskScheduler .............. 63.15ms DONE
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:15:01 Running [queue-size-job] ..................... 89ms DONE
2023-03-28 15:15:01 Running [Callback] ........................... 54ms DONE
2023-03-28 15:15:04 App\Jobs\Ninja\QueueSize ....................... RUNNING
2023-03-28 15:15:04 App\Jobs\Ninja\QueueSize .................. 40.27ms DONE
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:20:01 Running [queue-size-job] .................... 112ms DONE
2023-03-28 15:20:01 Running [Callback] ........................... 50ms DONE
2023-03-28 15:20:01 App\Jobs\Ninja\QueueSize ....................... RUNNING
2023-03-28 15:20:01 App\Jobs\Ninja\QueueSize .................. 24.07ms DONE
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:25:01 Running [queue-size-job] ..................... 83ms DONE
2023-03-28 15:25:01 Running [Callback] ........................... 47ms DONE
2023-03-28 15:25:02 App\Jobs\Ninja\QueueSize ....................... RUNNING
2023-03-28 15:25:02 App\Jobs\Ninja\QueueSize .................. 25.58ms DONE
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:30:01 Running [queue-size-job] ..................... 65ms DONE
2023-03-28 15:30:01 Running [stale-invoice-job] .................. 42ms DONE
2023-03-28 15:30:01 Running [Callback] ........................... 49ms DONE
2023-03-28 15:30:03 App\Jobs\Ninja\QueueSize ....................... 2023-03-28 15:30:03 App\Jobs\Subscription\CleanStaleInvoiceOrder RUNNING
... RUNNING
2023-03-28 15:30:03 App\Jobs\Ninja\QueueSize .................. 25.52ms DONE
2023-03-28 15:30:03 App\Jobs\Subscription\CleanStaleInvoiceOrder 34.13ms DONE
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:35:01 Running [queue-size-job] ..................... 79ms DONE
2023-03-28 15:35:01 Running [Callback] ........................... 49ms DONE
2023-03-28 15:35:04 App\Jobs\Ninja\QueueSize ....................... RUNNING
2023-03-28 15:35:04 App\Jobs\Ninja\QueueSize .................. 23.78ms DONE
dockerfiles-server-1
10.10.1.212 - - [28/Mar/2023:14:33:50 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
10.10.1.212 - - [28/Mar/2023:14:33:56 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/client" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
10.10.1.212 - - [28/Mar/2023:14:36:41 +0000] "GET / HTTP/1.1" 500 5335 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
10.10.1.212 - - [28/Mar/2023:14:41:51 +0000] "GET / HTTP/1.1" 500 5335 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
2023/03/28 15:04:09 [notice] 1#1: signal 3 (SIGQUIT) received, shutting down
2023/03/28 15:04:09 [notice] 24#24: gracefully shutting down
2023/03/28 15:04:09 [notice] 24#24: exiting
2023/03/28 15:04:09 [notice] 26#26: gracefully shutting down
2023/03/28 15:04:09 [notice] 24#24: exit
2023/03/28 15:04:09 [notice] 26#26: exiting
2023/03/28 15:04:09 [notice] 26#26: exit
2023/03/28 15:04:09 [notice] 25#25: gracefully shutting down
2023/03/28 15:04:09 [notice] 27#27: gracefully shutting down
2023/03/28 15:04:09 [notice] 25#25: exiting
2023/03/28 15:04:09 [notice] 27#27: exiting
2023/03/28 15:04:09 [notice] 25#25: exit
2023/03/28 15:04:09 [notice] 27#27: exit
2023/03/28 15:04:09 [notice] 1#1: signal 17 (SIGCHLD) received from 24
2023/03/28 15:04:09 [notice] 1#1: worker process 24 exited with code 0
2023/03/28 15:04:09 [notice] 1#1: worker process 25 exited with code 0
2023/03/28 15:04:09 [notice] 1#1: signal 29 (SIGIO) received
2023/03/28 15:04:09 [notice] 1#1: signal 17 (SIGCHLD) received from 26
2023/03/28 15:04:09 [notice] 1#1: worker process 26 exited with code 0
2023/03/28 15:04:09 [notice] 1#1: worker process 27 exited with code 0
2023/03/28 15:04:09 [notice] 1#1: exit
/docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration
/docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/
/docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh
10-listen-on-ipv6-by-default.sh: info: IPv6 listen already enabled
/docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh
/docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh
/docker-entrypoint.sh: Configuration complete; ready for start up
2023/03/28 15:04:11 [notice] 1#1: using the "epoll" event method
2023/03/28 15:04:11 [notice] 1#1: nginx/1.23.3
2023/03/28 15:04:11 [notice] 1#1: built by gcc 10.2.1 20210110 (Debian 10.2.1-6)
2023/03/28 15:04:11 [notice] 1#1: OS: Linux 5.19.0-1004-raspi
2023/03/28 15:04:11 [notice] 1#1: getrlimit(RLIMIT_NOFILE): 1048576:1048576
2023/03/28 15:04:11 [notice] 1#1: start worker processes
2023/03/28 15:04:11 [notice] 1#1: start worker process 22
2023/03/28 15:04:11 [notice] 1#1: start worker process 23
2023/03/28 15:04:11 [notice] 1#1: start worker process 24
2023/03/28 15:04:11 [notice] 1#1: start worker process 25
10.10.1.212 - - [28/Mar/2023:15:04:30 +0000] "GET / HTTP/1.1" 500 5335 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
10.10.1.212 - - [28/Mar/2023:15:04:35 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
10.10.1.212 - - [28/Mar/2023:15:05:23 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
#- ./config/caddy/Caddyfile:/etc/caddy/Caddyfiledocker-com
- ./config/nginx/in-vhost.conf:/etc/nginx/conf.d/in-vhost.conf:ro
- ./docker/app/public:/var/www/app/public:ro
depends_on:
- app
# Run webserver nginx on port 80
# Feel free to modify depending what port is already occupied
ports:
- "8010:80"
- "4430:443"
networks:
- invoiceninja
Setup information
I used this video to setup invoiceninja/docker https://www.youtube.com/watch?v=xo6a3KtLC2g
Describe the bug
After setup of invoiceninja/docker following this video https://www.youtube.com/watch?v=xo6a3KtLC2g I go to http://10.10.1.3:8010 an oversized background image of a invoiceninja loads. At the bottom of the page there is a url that says "500 - Server Error Back 10.10.1.3" when I click on the link it takes me to http://10.10.1.3:8010/client with the same background image and error at the bottom of the page.
To reproduce
Steps to reproduce the behavior:
Screenshots/logs
Screenshots of load screen ( I had to zoom in to get it to fit and s take a screenshot) and Portainer showing the 3 containers that were created during setup. https://i.imgur.com/TgZ6LtN.png https://i.imgur.com/Vog1wxC.png
Log Files
dockerfiles-db-1.log 2023-03-28T14:31:39.097097991Z 2023-03-28 14:31:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started. 2023-03-28T14:31:39.887614029Z 2023-03-28 14:31:39+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2023-03-28T14:31:39.925300793Z 2023-03-28 14:31:39+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started. 2023-03-28T14:31:40.805140147Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock' 2023-03-28T14:31:41.591960755Z 2023-03-28T14:31:41.575893Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead. 2023-03-28T14:31:41.592047477Z 2023-03-28T14:31:41.582677Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1 2023-03-28T14:31:41.606416337Z 2023-03-28T14:31:41.605960Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-03-28T14:31:42.900450837Z 2023-03-28T14:31:42.899987Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-03-28T14:31:43.602217601Z 2023-03-28T14:31:43.600287Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-03-28T14:31:43.602301601Z 2023-03-28T14:31:43.600439Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2023-03-28T14:31:43.629304011Z 2023-03-28T14:31:43.628004Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2023-03-28T14:31:43.731139488Z 2023-03-28T14:31:43.730776Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock 2023-03-28T14:31:43.732448836Z 2023-03-28T14:31:43.732099Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL. 2023-03-28T15:03:29.853569308Z 2023-03-28T15:03:29.853166Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user. Shutting down mysqld (Version: 8.0.32).
2023-03-28T15:03:31.856453825Z 2023-03-28T15:03:31.855940Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 11 user: 'ninja'.
2023-03-28T15:03:31.856954152Z 2023-03-28T15:03:31.856525Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 12 user: 'ninja'.
2023-03-28T15:03:32.695638552Z 2023-03-28T15:03:32.695311Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-03-28T15:03:34.435197574Z 2023-03-28 15:03:34+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-28T15:03:35.246983624Z 2023-03-28 15:03:35+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-03-28T15:03:35.286696363Z 2023-03-28 15:03:35+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-28T15:03:36.117841386Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-03-28T15:03:36.891365247Z 2023-03-28T15:03:36.862919Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-03-28T15:03:36.891680169Z 2023-03-28T15:03:36.869831Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.32) starting as process 1
2023-03-28T15:03:36.895937936Z 2023-03-28T15:03:36.894188Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-28T15:04:10.460046959Z 2023-03-28T15:04:10.459144Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-28T15:04:11.272126895Z 2023-03-28T15:04:11.271807Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-03-28T15:04:11.272426262Z 2023-03-28T15:04:11.272107Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-03-28T15:04:11.307698578Z 2023-03-28T15:04:11.301805Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
2023-03-28T15:04:11.413447507Z 2023-03-28T15:04:11.413048Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2023-03-28T15:04:11.414348812Z 2023-03-28T15:04:11.414001Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.32' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
dockerfiles-app-1 [28-Mar-2023 15:04:19] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root [28-Mar-2023 15:04:19] NOTICE: fpm is running, pid 54 [28-Mar-2023 15:04:19] NOTICE: ready to handle connections 2023-03-28 15:04:20,299 INFO success: shutdown entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 2023-03-28 15:04:20,300 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 2023-03-28 15:04:20,300 INFO success: queue-worker_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 2023-03-28 15:04:20,302 INFO success: queue-worker_01 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 2023-03-28 15:04:20,303 INFO success: scheduler entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 172.20.0.4 - 28/Mar/2023:15:04:28 +0000 "GET /index.php" 500 172.20.0.4 - 28/Mar/2023:15:04:35 +0000 "GET /index.php" 500 2023-03-28 15:05:01 Running [queue-size-job] ..................... 92ms DONE 2023-03-28 15:05:01 Running [Callback] .......................... 138ms DONE 2023-03-28 15:05:02 App\Jobs\Ninja\QueueSize ....................... RUNNING 2023-03-28 15:05:02 App\Jobs\Ninja\QueueSize .................. 47.13ms DONE 172.20.0.4 - 28/Mar/2023:15:05:23 +0000 "GET /index.php" 500 INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:10:01 Running [queue-size-job] ..................... 88ms DONE 2023-03-28 15:10:01 Running [task-scheduler-job] ................. 48ms DONE 2023-03-28 15:10:01 Running [Callback] ........................... 47ms DONE 2023-03-28 15:10:03 App\Jobs\Ninja\QueueSize ....................... RUNNING 2023-03-28 15:10:03 App\Jobs\Ninja\QueueSize .................. 28.29ms DONE 2023-03-28 15:10:03 App\Jobs\Ninja\TaskScheduler ................... RUNNING 2023-03-28 15:10:03 App\Jobs\Ninja\TaskScheduler .............. 63.15ms DONE INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:15:01 Running [queue-size-job] ..................... 89ms DONE 2023-03-28 15:15:01 Running [Callback] ........................... 54ms DONE 2023-03-28 15:15:04 App\Jobs\Ninja\QueueSize ....................... RUNNING 2023-03-28 15:15:04 App\Jobs\Ninja\QueueSize .................. 40.27ms DONE INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:20:01 Running [queue-size-job] .................... 112ms DONE 2023-03-28 15:20:01 Running [Callback] ........................... 50ms DONE 2023-03-28 15:20:01 App\Jobs\Ninja\QueueSize ....................... RUNNING 2023-03-28 15:20:01 App\Jobs\Ninja\QueueSize .................. 24.07ms DONE INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:25:01 Running [queue-size-job] ..................... 83ms DONE 2023-03-28 15:25:01 Running [Callback] ........................... 47ms DONE 2023-03-28 15:25:02 App\Jobs\Ninja\QueueSize ....................... RUNNING 2023-03-28 15:25:02 App\Jobs\Ninja\QueueSize .................. 25.58ms DONE INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:30:01 Running [queue-size-job] ..................... 65ms DONE 2023-03-28 15:30:01 Running [stale-invoice-job] .................. 42ms DONE 2023-03-28 15:30:01 Running [Callback] ........................... 49ms DONE 2023-03-28 15:30:03 App\Jobs\Ninja\QueueSize ....................... 2023-03-28 15:30:03 App\Jobs\Subscription\CleanStaleInvoiceOrder RUNNING
... RUNNING 2023-03-28 15:30:03 App\Jobs\Ninja\QueueSize .................. 25.52ms DONE 2023-03-28 15:30:03 App\Jobs\Subscription\CleanStaleInvoiceOrder 34.13ms DONE INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
INFO No scheduled commands are ready to run.
2023-03-28 15:35:01 Running [queue-size-job] ..................... 79ms DONE 2023-03-28 15:35:01 Running [Callback] ........................... 49ms DONE 2023-03-28 15:35:04 App\Jobs\Ninja\QueueSize ....................... RUNNING 2023-03-28 15:35:04 App\Jobs\Ninja\QueueSize .................. 23.78ms DONE
dockerfiles-server-1 10.10.1.212 - - [28/Mar/2023:14:33:50 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-" 10.10.1.212 - - [28/Mar/2023:14:33:56 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/client" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-" 10.10.1.212 - - [28/Mar/2023:14:36:41 +0000] "GET / HTTP/1.1" 500 5335 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-" 10.10.1.212 - - [28/Mar/2023:14:41:51 +0000] "GET / HTTP/1.1" 500 5335 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-" 2023/03/28 15:04:09 [notice] 1#1: signal 3 (SIGQUIT) received, shutting down 2023/03/28 15:04:09 [notice] 24#24: gracefully shutting down 2023/03/28 15:04:09 [notice] 24#24: exiting 2023/03/28 15:04:09 [notice] 26#26: gracefully shutting down 2023/03/28 15:04:09 [notice] 24#24: exit 2023/03/28 15:04:09 [notice] 26#26: exiting 2023/03/28 15:04:09 [notice] 26#26: exit 2023/03/28 15:04:09 [notice] 25#25: gracefully shutting down 2023/03/28 15:04:09 [notice] 27#27: gracefully shutting down 2023/03/28 15:04:09 [notice] 25#25: exiting 2023/03/28 15:04:09 [notice] 27#27: exiting 2023/03/28 15:04:09 [notice] 25#25: exit 2023/03/28 15:04:09 [notice] 27#27: exit 2023/03/28 15:04:09 [notice] 1#1: signal 17 (SIGCHLD) received from 24 2023/03/28 15:04:09 [notice] 1#1: worker process 24 exited with code 0 2023/03/28 15:04:09 [notice] 1#1: worker process 25 exited with code 0 2023/03/28 15:04:09 [notice] 1#1: signal 29 (SIGIO) received 2023/03/28 15:04:09 [notice] 1#1: signal 17 (SIGCHLD) received from 26 2023/03/28 15:04:09 [notice] 1#1: worker process 26 exited with code 0 2023/03/28 15:04:09 [notice] 1#1: worker process 27 exited with code 0 2023/03/28 15:04:09 [notice] 1#1: exit /docker-entrypoint.sh: /docker-entrypoint.d/ is not empty, will attempt to perform configuration /docker-entrypoint.sh: Looking for shell scripts in /docker-entrypoint.d/ /docker-entrypoint.sh: Launching /docker-entrypoint.d/10-listen-on-ipv6-by-default.sh 10-listen-on-ipv6-by-default.sh: info: IPv6 listen already enabled /docker-entrypoint.sh: Launching /docker-entrypoint.d/20-envsubst-on-templates.sh /docker-entrypoint.sh: Launching /docker-entrypoint.d/30-tune-worker-processes.sh /docker-entrypoint.sh: Configuration complete; ready for start up 2023/03/28 15:04:11 [notice] 1#1: using the "epoll" event method 2023/03/28 15:04:11 [notice] 1#1: nginx/1.23.3 2023/03/28 15:04:11 [notice] 1#1: built by gcc 10.2.1 20210110 (Debian 10.2.1-6) 2023/03/28 15:04:11 [notice] 1#1: OS: Linux 5.19.0-1004-raspi 2023/03/28 15:04:11 [notice] 1#1: getrlimit(RLIMIT_NOFILE): 1048576:1048576 2023/03/28 15:04:11 [notice] 1#1: start worker processes 2023/03/28 15:04:11 [notice] 1#1: start worker process 22 2023/03/28 15:04:11 [notice] 1#1: start worker process 23 2023/03/28 15:04:11 [notice] 1#1: start worker process 24 2023/03/28 15:04:11 [notice] 1#1: start worker process 25 10.10.1.212 - - [28/Mar/2023:15:04:30 +0000] "GET / HTTP/1.1" 500 5335 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-" 10.10.1.212 - - [28/Mar/2023:15:04:35 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-" 10.10.1.212 - - [28/Mar/2023:15:05:23 +0000] "GET /client HTTP/1.1" 500 5340 "http://10.10.1.3:8010/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" "-"
Config Files
docker-compose.yaml version: '3.7'
services: server: image: nginx restart: always env_file: env volumes:
Vhost configuration
app: image: invoiceninja/invoiceninja:5 env_file: env restart: always volumes:
invoiceninja
db: image: mysql:8
When running on ARM64 use MariaDB instead of MySQL
image: mariadb:10.4
For auto DB backups comment out image and use the build block below
build:
context: ./config/mysql
ports:
./docker/mysql/data:/var/lib/mysql:rw,delegated
remove comments for next 4 lines if you want auto sql backups
- ./docker/mysql/bak:/backups:rw
- ./config/mysql/backup-script:/etc/cron.daily/daily:ro
- ./config/mysql/backup-script:/etc/cron.weekly/weekly:ro
- ./config/mysql/backup-script:/etc/cron.monthly/monthly:ro
networks:
invoiceninja
THIS IS ONLY A VALID CONFIGURATION FOR IN 4. DO NOT USE FOR IN 5.
cron:
image: invoiceninja/invoiceninja:alpine-4
volumes:
- ./docker/app/public:/var/www/app/public:rw,delegated
- ./docker/app/storage:/var/www/app/storage:rw,delegated
- ./docker/app/public/logo:/var/www/app/public/logo:rw,delegated
entrypoint: |
/bin/sh -c 'sh -s <<EOF
trap "break;exit" SIGHUP SIGINT SIGTERM
sleep 300s
while /bin/true; do
./artisan ninja:send-invoices
./artisan ninja:send-reminders
sleep 1d
done
EOF'
networks:
- invoiceninja
#
networks: invoiceninja:
env file
IN application vars
APP_URL=http://10.10.1.3:8003 APP_KEY=
APP_DEBUG=true
REQUIRE_HTTPS=false
PHANTOMJS_PDF_GENERATION=false
PDF_GENERATOR=snappdf
TRUSTED_PROXIES='*'
QUEUE_CONNECTION=database
DB connection
DB_HOST=db DB_PORT=3306 DB_DATABASE=ninja DB_USERNAME=ninja DB_PASSWORD=ninja
Create initial user
Default to these values if empty
IN_USER_EMAIL=admin@example.com
IN_PASSWORD=changeme!
IN_USER_EMAIL=
IN_PASSWORD=
Mail options
MAIL_MAILER=log MAIL_HOST=smtp.gmail.com MAIL_PORT=587 MAIL_USERNAME=
MAIL_PASSWORD=
MAIL_ENCRYPTION=tls
MAIL_FROM_ADDRESS=''
MAIL_FROM_NAME='Invoice Ninja'
MySQL
MYSQL_ROOT_PASSWORD=ninjaAdm1nPassword MYSQL_USER=ninja MYSQL_PASSWORD=ninja MYSQL_DATABASE=ninja
V4 env vars
DB_STRICT=false
APP_CIPHER=AES-256-CBC
Additional context Add any other context about the problem here.