Hello,
I have spent the last few hours trying to run both v4 and v5 using the docker image from docker hub. I either case, the container logs seem to do the db migration then post a status that php-fpm is ready to handle connection. However, when I try to access the web app, I continuously get a 503 error. Below is my config, can anyone provide some suggestions?
My docker-compose file is like the following.
version: '2'
services:
invoice-ninja-mariadb:
image: mariadb
command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
volumes:
- /srv/dev-disk-by-label-mainpool/docker/volumes/invoice-ninja/mariadb/mysql:/var/lib/mysql
environment:
- MYSQL_ROOT_PASSWORD=Obfuscated
- MYSQL_PASSWORD=Obfuscated
- MYSQL_DATABASE=ninja
- MYSQL_USER=ninja
invoice-ninja:
image: invoiceninja/invoiceninja:latest
volumes:
- /srv/dev-disk-by-label-mainpool/docker/volumes/invoice-ninja/invoice-ninja/public:/var/app/public
- /srv/dev-disk-by-label-mainpool/docker/volumes/invoice-ninja/invoice-ninja/storage:/var/app/storage
environment:
- APP_ENV=development
- APP_DEBUG=1
- APP_URL=https://billing.home.theorlandog.com/
- APP_KEY=Obfuscated
- APP_CIPHER=AES-256-CBC
- DB_TYPE=mysql
- DB_STRICT=false
- DB_HOST1=db
- DB_PORT1=3306
- DB_DATABASE1=ninja
- DB_USERNAME1=ninja
- DB_PASSWORD1=Obfuscated
- TRUSTED_PROXIES=10.0.0.0/8
ports:
- 127.0.0.1:9420:9000
depends_on:
- invoice-ninja-mariadb
links:
- invoice-ninja-mariadb:db
The logs of the container are below
Configuration cache cleared!,
Configuration cached successfully!,
Configuration cache cleared!,
Configuration cached successfully!,
Route cache cleared!,
Routes cached successfully!,
les cached successfully!,
Nothing to migrate.,
[15-Feb-2021 15:28:17] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root,
[15-Feb-2021 15:28:17] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root,
[15-Feb-2021 15:28:17] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root,
[15-Feb-2021 15:28:17] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root,
[15-Feb-2021 15:28:17] NOTICE: fpm is running, pid 78,
[15-Feb-2021 15:28:17] NOTICE: ready to handle connections,
Schedule worker started successfully.,
,
Execution #1 output:,
Running scheduled command: '/usr/local/bin/php' 'artisan' queue:work > '/dev/null' 2>&1,
,
Execution #2 output:,
Running scheduled command: '/usr/local/bin/php' 'artisan' queue:restart > '/dev/null' 2>&1,
Running scheduled command: App\Jobs\Util\SchedulerCheck,
Running scheduled command: Turbo124\Beacon\Jobs\BatchMetrics,
[2021-02-15 15:30:05][3] Processing: App\Jobs\Util\SchedulerCheck,
[2021-02-15 15:30:05][3] Processed: App\Jobs\Util\SchedulerCheck,
[2021-02-15 15:30:05][4] Processing: App\Jobs\Util\VersionCheck,
[2021-02-15 15:30:05][4] Processed: App\Jobs\Util\VersionCheck,
,
Execution #3 output:,
Running scheduled command: '/usr/local/bin/php' 'artisan' queue:work > '/dev/null' 2>&1,
,
Execution #4 output:,
No scheduled commands are ready to run.,
,
Execution #5 output:,
No scheduled commands are ready to run.,
,
Execution #6 output:,
No scheduled commands are ready to run.,
,
Execution #7 output:,
Running scheduled command: '/usr/local/bin/php' 'artisan' queue:restart > '/dev/null' 2>&1,
Running scheduled command: App\Jobs\Util\SchedulerCheck,
Running scheduled command: Turbo124\Beacon\Jobs\BatchMetrics,
[2021-02-15 15:35:04][5] Processing: App\Jobs\Util\SchedulerCheck,
[2021-02-15 15:35:04][5] Processed: App\Jobs\Util\SchedulerCheck,
[2021-02-15 15:35:04][6] Processing: App\Jobs\Util\VersionCheck,
[2021-02-15 15:35:04][6] Processed: App\Jobs\Util\VersionCheck,
,
Execution #8 output:,
Running scheduled command: '/usr/local/bin/php' 'artisan' queue:work > '/dev/null' 2>&1,
,
Execution #9 output:,
No scheduled commands are ready to run.,
,
Execution #10 output:,
No scheduled commands are ready to run.,
Strangely enough, even if I exec into the container I can’t get a response from the php-fpm process.
~ $ netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.11:44095 0.0.0.0:* LISTEN -
tcp 0 0 :::9000 :::* LISTEN 78/php-fpm.conf)
udp 0 0 127.0.0.11:36469 0.0.0.0:* -
~ $ curl http://127.0.0.1:9000
curl: (56) Recv failure: Connection reset by peer