You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to deploy CTFnote, however trying to open the website the website keeps refreshing and loading. Checking the postgreSQL logs I seem to get errors about broken permissions.
PostgreSQL Database directory appears to contain a database; Skipping initialization
2023-08-16 14:18:33.784 UTC [1] LOG: starting PostgreSQL 14.3 (Debian 14.3-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
2023-08-16 14:18:33.784 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2023-08-16 14:18:33.784 UTC [1] LOG: listening on IPv6 address "::", port 5432
2023-08-16 14:18:33.789 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-08-16 14:18:33.797 UTC [26] LOG: database system was shut down at 2023-08-16 14:18:23 UTC
2023-08-16 14:18:33.802 UTC [1] LOG: database system is ready to accept connections
2023-08-16 14:32:19.706 UTC [65] ERROR: relation "Sessions" does not exist at character 13
2023-08-16 14:32:19.706 UTC [65] STATEMENT: DELETE FROM "Sessions" WHERE "expires" < '2023-08-16 14:32:19.663 +00:00'
2023-08-16 14:43:45.519 UTC [100] ERROR: permission denied for table settings
2023-08-16 14:43:45.519 UTC [100] STATEMENT: with __local_0__ as (select to_json((json_build_object('__identifiers'::text, json_build_array(__local_1__."unique_id"), 'registrationAllowed'::text, (__local_1__."registration_allowed"), 'registrationPasswordAllowed'::text, (__local_1__."registration_password_allowed"), 'style'::text, (__local_1__."style")))) as "@nodes" from (select __local_1__.*
from "ctfnote"."settings" as __local_1__
where (TRUE) and (TRUE)
order by __local_1__."unique_id" ASC
) __local_1__), __local_2__ as (select json_agg(to_json(__local_0__)) as data from __local_0__) select coalesce((select __local_2__.data from __local_2__), '[]'::json) as "data"
2023-08-16 14:43:45.728 UTC [100] ERROR: permission denied for table settings
2023-08-16 14:43:45.728 UTC [100] STATEMENT: with __local_0__ as (select to_json((json_build_object('__identifiers'::text, json_build_array(__local_1__."unique_id"), 'registrationAllowed'::text, (__local_1__."registration_allowed"), 'registrationPasswordAllowed'::text, (__local_1__."registration_password_allowed"), 'style'::text, (__local_1__."style")))) as "@nodes" from (select __local_1__.*
from "ctfnote"."settings" as __local_1__
where (TRUE) and (TRUE)
order by __local_1__."unique_id" ASC
) __local_1__), __local_2__ as (select json_agg(to_json(__local_0__)) as data from __local_0__) select coalesce((select __local_2__.data from __local_2__), '[]'::json) as "data"
The text was updated successfully, but these errors were encountered:
I am trying to deploy CTFnote, however trying to open the website the website keeps refreshing and loading. Checking the postgreSQL logs I seem to get errors about broken permissions.
The text was updated successfully, but these errors were encountered: