I have deployed cachet and postgres as docker containers. When I try to access the webapp it's failing on http status code 500.
The following is what I see in the cachet logs and postgres logs. Seems to be an issue with data in postgres?
Postgres:
chmod: /var/run/postgresql: Operation not permitted
PostgreSQL Database directory appears to contain a database; Skipping initialization
2023-05-03 01:16:13.443 UTC [1] LOG: starting PostgreSQL 12.14 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r4) 12.2.1 20220924, 64-bit
2023-05-03 01:16:13.443 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2023-05-03 01:16:13.443 UTC [1] LOG: listening on IPv6 address "::", port 5432
2023-05-03 01:16:13.485 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-05-03 01:16:13.586 UTC [14] LOG: database system was shut down at 2023-05-03 01:10:42 UTC
2023-05-03 01:16:13.632 UTC [1] LOG: database system is ready to accept connections
2023-05-03 01:32:03.005 UTC [38] ERROR: relation "chq_settings" does not exist at character 29
2023-05-03 01:32:03.005 UTC [38] STATEMENT: select "name", "value" from "chq_settings"
2023-05-03 01:32:03.085 UTC [39] ERROR: relation "chq_settings" does not exist at character 29
2023-05-03 01:32:03.085 UTC [39] STATEMENT: select "name", "value" from "chq_settings"
2023-05-03 01:32:03.101 UTC [40] ERROR: relation "chq_settings" does not exist at character 29
2023-05-03 01:32:03.101 UTC [40] STATEMENT: select "name", "value" from "chq_settings"
Cachet:
Cachet is installed ⚡
Table chq_sessions exists! ...
Nothing to migrate.
Database seeding completed successfully.
Starting Cachet! ...
Configuration cache cleared!
Configuration cached successfully!
2023-05-03 01:32:09,518 WARN For [program:queue-worker], AUTO logging used for stderr_logfile without rollover, set maxbytes > 0 to avoid filling up filesystem unintentionally
2023-05-03 01:32:09,522 INFO supervisord started with pid 83
2023-05-03 01:32:10,524 INFO spawned: 'nginx' with pid 85
2023-05-03 01:32:10,526 INFO spawned: 'php-fpm' with pid 86
2023-05-03 01:32:10,528 INFO spawned: 'queue-worker' with pid 87
[03-May-2023 01:32:10] NOTICE: fpm is running, pid 86
[03-May-2023 01:32:10] NOTICE: ready to handle connections
2023-05-03 01:32:11,571 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-05-03 01:32:11,571 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-05-03 01:32:11,571 INFO success: queue-worker entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
10.131.4.142 - - [03/May/2023:01:48:21 +0000] "GET / HTTP/1.1" 500 3169 "-" "curl/7.66.0" "-"
10.128.4.1 - - [03/May/2023:15:18:28 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36" ""
10.128.4.1 - - [03/May/2023:15:18:29 +0000] "GET /favicon.ico HTTP/1.1" 200 952 "http://cachet.apps.xxx.com/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36" ""
10.128.4.1 - - [03/May/2023:15:50:35 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36" ""
10.128.4.1 - - [03/May/2023:15:50:35 +0000] "GET /favicon.ico HTTP/1.1" 200 952 "http://cachet.apps.xxx.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36" ""
10.128.4.1 - - [03/May/2023:15:51:36 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36" ""
10.128.4.1 - - [03/May/2023:18:38:24 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/112.0" ""
I have deployed cachet and postgres as docker containers. When I try to access the webapp it's failing on http status code 500.
The following is what I see in the cachet logs and postgres logs. Seems to be an issue with data in postgres?
Postgres:
chmod: /var/run/postgresql: Operation not permitted PostgreSQL Database directory appears to contain a database; Skipping initialization 2023-05-03 01:16:13.443 UTC [1] LOG: starting PostgreSQL 12.14 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r4) 12.2.1 20220924, 64-bit 2023-05-03 01:16:13.443 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2023-05-03 01:16:13.443 UTC [1] LOG: listening on IPv6 address "::", port 5432 2023-05-03 01:16:13.485 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2023-05-03 01:16:13.586 UTC [14] LOG: database system was shut down at 2023-05-03 01:10:42 UTC 2023-05-03 01:16:13.632 UTC [1] LOG: database system is ready to accept connections 2023-05-03 01:32:03.005 UTC [38] ERROR: relation "chq_settings" does not exist at character 29 2023-05-03 01:32:03.005 UTC [38] STATEMENT: select "name", "value" from "chq_settings" 2023-05-03 01:32:03.085 UTC [39] ERROR: relation "chq_settings" does not exist at character 29 2023-05-03 01:32:03.085 UTC [39] STATEMENT: select "name", "value" from "chq_settings" 2023-05-03 01:32:03.101 UTC [40] ERROR: relation "chq_settings" does not exist at character 29 2023-05-03 01:32:03.101 UTC [40] STATEMENT: select "name", "value" from "chq_settings"
Cachet:
Cachet is installed ⚡ Table chq_sessions exists! ... Nothing to migrate. Database seeding completed successfully. Starting Cachet! ... Configuration cache cleared! Configuration cached successfully! 2023-05-03 01:32:09,518 WARN For [program:queue-worker], AUTO logging used for stderr_logfile without rollover, set maxbytes > 0 to avoid filling up filesystem unintentionally 2023-05-03 01:32:09,522 INFO supervisord started with pid 83 2023-05-03 01:32:10,524 INFO spawned: 'nginx' with pid 85 2023-05-03 01:32:10,526 INFO spawned: 'php-fpm' with pid 86 2023-05-03 01:32:10,528 INFO spawned: 'queue-worker' with pid 87 [03-May-2023 01:32:10] NOTICE: fpm is running, pid 86 [03-May-2023 01:32:10] NOTICE: ready to handle connections 2023-05-03 01:32:11,571 INFO success: nginx entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 2023-05-03 01:32:11,571 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 2023-05-03 01:32:11,571 INFO success: queue-worker entered RUNNING state, process has stayed up for > than 1 seconds (startsecs) 10.131.4.142 - - [03/May/2023:01:48:21 +0000] "GET / HTTP/1.1" 500 3169 "-" "curl/7.66.0" "-" 10.128.4.1 - - [03/May/2023:15:18:28 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36" "" 10.128.4.1 - - [03/May/2023:15:18:29 +0000] "GET /favicon.ico HTTP/1.1" 200 952 "http://cachet.apps.xxx.com/" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36" "" 10.128.4.1 - - [03/May/2023:15:50:35 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36" "" 10.128.4.1 - - [03/May/2023:15:50:35 +0000] "GET /favicon.ico HTTP/1.1" 200 952 "http://cachet.apps.xxx.com/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36" "" 10.128.4.1 - - [03/May/2023:15:51:36 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36" "" 10.128.4.1 - - [03/May/2023:18:38:24 +0000] "GET / HTTP/1.1" 500 3217 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:109.0) Gecko/20100101 Firefox/112.0" ""