firezone-postgres-1 | The files belonging to this database system will be owned by user "postgres". firezone-postgres-1 | This user must also own the server process. firezone-postgres-1 | firezone-postgres-1 | The database cluster will be initialized with locale "en_US.utf8". firezone-postgres-1 | The default database encoding has accordingly been set to "UTF8". firezone-postgres-1 | The default text search configuration will be set to "english". firezone-postgres-1 | firezone-postgres-1 | Data page checksums are disabled. firezone-postgres-1 | firezone-postgres-1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok firezone-postgres-1 | creating subdirectories ... ok firezone-postgres-1 | selecting dynamic shared memory implementation ... posix firezone-postgres-1 | selecting default max_connections ... 100 firezone-postgres-1 | selecting default shared_buffers ... 128MB firezone-postgres-1 | selecting default time zone ... Etc/UTC firezone-postgres-1 | creating configuration files ... ok firezone-postgres-1 | running bootstrap script ... ok firezone-postgres-1 | performing post-bootstrap initialization ... ok firezone-postgres-1 | initdb: warning: enabling "trust" authentication for local connections firezone-postgres-1 | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. firezone-postgres-1 | syncing data to disk ... ok firezone-postgres-1 | firezone-postgres-1 | firezone-postgres-1 | Success. You can now start the database server using: firezone-postgres-1 | firezone-postgres-1 | pg_ctl -D /var/lib/postgresql/data -l logfile start firezone-postgres-1 | firezone-postgres-1 | waiting for server to start....2022-11-24 12:43:02.190 UTC [47] LOG: starting PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit firezone-postgres-1 | 2022-11-24 12:43:02.193 UTC [47] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" firezone-postgres-1 | 2022-11-24 12:43:02.199 UTC [50] LOG: database system was shut down at 2022-11-24 12:43:01 UTC firezone-postgres-1 | 2022-11-24 12:43:02.215 UTC [47] LOG: database system is ready to accept connections firezone-postgres-1 | done firezone-postgres-1 | server started firezone-postgres-1 | CREATE DATABASE firezone-postgres-1 | firezone-postgres-1 | firezone-postgres-1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/* firezone-postgres-1 | firezone-postgres-1 | 2022-11-24 12:43:02.404 UTC [47] LOG: received fast shutdown request firezone-postgres-1 | waiting for server to shut down....2022-11-24 12:43:02.407 UTC [47] LOG: aborting any active transactions firezone-postgres-1 | 2022-11-24 12:43:02.409 UTC [47] LOG: background worker "logical replication launcher" (PID 53) exited with exit code 1 firezone-postgres-1 | 2022-11-24 12:43:02.414 UTC [48] LOG: shutting down firezone-postgres-1 | 2022-11-24 12:43:02.416 UTC [48] LOG: checkpoint starting: shutdown immediate firezone-postgres-1 | 2022-11-24 12:43:02.978 UTC [48] LOG: checkpoint complete: wrote 918 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.551 s, sync=0.007 s, total=0.564 s; sync files=250, longest=0.003 s, average=0.001 s; distance=4217 kB, estimate=4217 kB firezone-postgres-1 | 2022-11-24 12:43:02.985 UTC [47] LOG: database system is shut down firezone-postgres-1 | done firezone-postgres-1 | server stopped firezone-postgres-1 | firezone-postgres-1 | PostgreSQL init process complete; ready for start up. firezone-postgres-1 | firezone-postgres-1 | 2022-11-24 12:43:03.029 UTC [1] LOG: starting PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit firezone-postgres-1 | 2022-11-24 12:43:03.030 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 firezone-postgres-1 | 2022-11-24 12:43:03.030 UTC [1] LOG: listening on IPv6 address "::", port 5432 firezone-postgres-1 | 2022-11-24 12:43:03.033 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" firezone-postgres-1 | 2022-11-24 12:43:03.039 UTC [62] LOG: database system was shut down at 2022-11-24 12:43:02 UTC firezone-postgres-1 | 2022-11-24 12:43:03.046 UTC [1] LOG: database system is ready to accept connections firezone-postgres-1 | 2022-11-24 12:43:09.197 UTC [1] LOG: received fast shutdown request firezone-postgres-1 | 2022-11-24 12:43:09.206 UTC [1] LOG: aborting any active transactions firezone-postgres-1 | 2022-11-24 12:43:09.209 UTC [1] LOG: background worker "logical replication launcher" (PID 65) exited with exit code 1 firezone-postgres-1 | 2022-11-24 12:43:09.212 UTC [60] LOG: shutting down firezone-postgres-1 | 2022-11-24 12:43:09.217 UTC [60] LOG: checkpoint starting: shutdown immediate firezone-postgres-1 | 2022-11-24 12:43:09.302 UTC [60] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.007 s, sync=0.013 s, total=0.091 s; sync files=5, longest=0.005 s, average=0.003 s; distance=2 kB, estimate=2 kB firezone-postgres-1 | 2022-11-24 12:43:09.307 UTC [1] LOG: database system is shut down firezone-postgres-1 exited with code 0 firezone-postgres-1 exited with code 0 [root@heimdall .firezone]# docker compose logs -f firezone-postgres-1 | firezone-postgres-1 | PostgreSQL Database directory appears to contain a database; Skipping initialization firezone-postgres-1 | firezone-postgres-1 | 2022-11-24 12:43:10.495 UTC [1] LOG: starting PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit firezone-postgres-1 | 2022-11-24 12:43:10.495 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 firezone-postgres-1 | 2022-11-24 12:43:10.496 UTC [1] LOG: listening on IPv6 address "::", port 5432 firezone-postgres-1 | 2022-11-24 12:43:10.499 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" firezone-postgres-1 | 2022-11-24 12:43:10.504 UTC [27] LOG: database system was shut down at 2022-11-24 12:43:09 UTC firezone-postgres-1 | 2022-11-24 12:43:10.510 UTC [1] LOG: database system is ready to accept connections firezone-caddy-1 | {"level":"info","ts":1669293790.183886,"msg":"using provided configuration","config_file":"/etc/caddy/Caddyfile","config_adapter":""} firezone-caddy-1 | {"level":"warn","ts":1669293790.187407,"msg":"Caddyfile input is not formatted; run the 'caddy fmt' command to fix inconsistencies","adapter":"caddyfile","file":"/etc/caddy/Caddyfile","line":1} firezone-caddy-1 | {"level":"info","ts":1669293790.1887586,"logger":"admin","msg":"admin endpoint started","address":"localhost:2019","enforce_origin":false,"origins":["//localhost:2019","//[::1]:2019","//127.0.0.1:2019"]} firezone-caddy-1 | {"level":"info","ts":1669293790.188901,"logger":"http","msg":"enabling automatic HTTP->HTTPS redirects","server_name":"srv0"} firezone-caddy-1 | {"level":"warn","ts":1669293790.189158,"logger":"tls","msg":"YOUR SERVER MAY BE VULNERABLE TO ABUSE: on-demand TLS is enabled, but no protections are in place","docs":"https://caddyserver.com/docs/automatic-https#on-demand-tls"} firezone-caddy-1 | {"level":"info","ts":1669293790.1893172,"logger":"http","msg":"enabling HTTP/3 listener","addr":":443"} firezone-caddy-1 | {"level":"info","ts":1669293790.1894586,"msg":"failed to sufficiently increase receive buffer size (was: 208 kiB, wanted: 2048 kiB, got: 416 kiB). See https://github.com/lucas-clemente/quic-go/wiki/UDP-Receive-Buffer-Size for details."} firezone-caddy-1 | {"level":"info","ts":1669293790.1895447,"logger":"http.log","msg":"server running","name":"srv0","protocols":["h1","h2","h3"]} firezone-caddy-1 | {"level":"info","ts":1669293790.1895745,"logger":"http.log","msg":"server running","name":"remaining_auto_https_redirects","protocols":["h1","h2","h3"]} firezone-caddy-1 | {"level":"info","ts":1669293790.1898077,"msg":"autosaved config (load with --resume flag)","file":"/config/caddy/autosave.json"} firezone-caddy-1 | {"level":"info","ts":1669293790.1898146,"msg":"serving initial configuration"} firezone-caddy-1 | {"level":"info","ts":1669293790.189926,"logger":"tls.cache.maintenance","msg":"started background certificate maintenance","cache":"0x40003fbab0"} firezone-caddy-1 | {"level":"info","ts":1669293790.1899893,"logger":"tls","msg":"cleaning storage unit","description":"FileStorage:/data/caddy"} firezone-caddy-1 | {"level":"info","ts":1669293790.190061,"logger":"tls","msg":"finished cleaning storage units"} firezone-firezone-1 | Generating a RSA private key firezone-firezone-1 | ......................+++++ firezone-firezone-1 | .........................................................+++++ firezone-firezone-1 | writing new private key to '/var/firezone/saml.key' firezone-firezone-1 | ----- firezone-firezone-1 | 12:43:12.809 [info] == Running 20200225005454 FzHttp.Repo.Migrations.CreateUsers.change/0 forward firezone-firezone-1 | 12:43:12.812 [info] create table users firezone-firezone-1 | 12:43:12.821 [info] create index users_email_index firezone-firezone-1 | 12:43:12.824 [info] create index users_sign_in_token_sign_in_token_created_at_index firezone-firezone-1 | 12:43:12.829 [info] == Migrated 20200225005454 in 0.0s firezone-firezone-1 | 12:43:12.850 [info] == Running 20200228145810 FzHttp.Repo.Migrations.CreateDevices.change/0 forward firezone-firezone-1 | 12:43:12.851 [info] create table devices firezone-firezone-1 | 12:43:12.859 [info] execute "CREATE SEQUENCE address_sequence AS SMALLINT MINVALUE 2 MAXVALUE 254 START 2 CYCLE OWNED BY devices.address " firezone-firezone-1 | 12:43:12.860 [info] execute "ALTER TABLE devices ALTER COLUMN address SET DEFAULT NEXTVAL('address_sequence')" firezone-firezone-1 | 12:43:12.860 [info] create index devices_user_id_index firezone-firezone-1 | 12:43:12.863 [info] create index devices_public_key_index firezone-firezone-1 | 12:43:12.866 [info] create index devices_private_key_index firezone-firezone-1 | 12:43:12.869 [info] create index devices_user_id_name_index firezone-firezone-1 | 12:43:12.872 [info] create index devices_address_index firezone-firezone-1 | 12:43:12.875 [info] == Migrated 20200228145810 in 0.0s firezone-firezone-1 | 12:43:12.879 [info] == Running 20200228154815 FzHttp.Repo.Migrations.CreateRules.change/0 forward firezone-firezone-1 | 12:43:12.879 [info] execute "CREATE TYPE action_enum AS ENUM ('drop', 'accept')" firezone-firezone-1 | 12:43:12.880 [info] create table rules firezone-firezone-1 | 12:43:12.886 [info] create index rules_destination_action_index firezone-firezone-1 | 12:43:12.889 [info] == Migrated 20200228154815 in 0.0s firezone-firezone-1 | 12:43:12.892 [info] == Running 20210929172417 FzHttp.Repo.Migrations.AddDnsServersToDevices.change/0 forward firezone-firezone-1 | 12:43:12.892 [info] alter table devices firezone-firezone-1 | 12:43:12.893 [info] == Migrated 20210929172417 in 0.0s firezone-firezone-1 | 12:43:12.896 [info] == Running 20211116172808 FzHttp.Repo.Migrations.CreateConnectivityChecks.change/0 forward firezone-firezone-1 | 12:43:12.896 [info] create table connectivity_checks firezone-firezone-1 | 12:43:12.902 [info] create index connectivity_checks_inserted_at_index firezone-firezone-1 | 12:43:12.905 [info] == Migrated 20211116172808 in 0.0s firezone-firezone-1 | 12:43:12.908 [info] == Running 20211116173236 FzHttp.Repo.Migrations.CreateSettings.change/0 forward firezone-firezone-1 | 12:43:12.909 [info] create table settings firezone-firezone-1 | 12:43:12.914 [info] create index settings_key_index firezone-firezone-1 | 12:43:12.918 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('default.device.dns_servers', null, '2022-11-24 12:43:12.917368Z', '2022-11-24 12:43:12.917368Z'),\n('default.device.allowed_ips', null, '2022-11-24 12:43:12.917368Z', '2022-11-24 12:43:12.917368Z'),\n('default.device.endpoint', null, '2022-11-24 12:43:12.917368Z', '2022-11-24 12:43:12.917368Z')\n" firezone-firezone-1 | 12:43:12.919 [info] == Migrated 20211116173236 in 0.0s firezone-firezone-1 | 12:43:12.923 [info] == Running 20211203012238 FzHttp.Repo.Migrations.ChangeDeviceColumnDefaults.change/0 forward firezone-firezone-1 | 12:43:12.923 [info] alter table devices firezone-firezone-1 | 12:43:12.926 [info] == Migrated 20211203012238 in 0.0s firezone-firezone-1 | 12:43:12.928 [info] == Running 20211216155557 FzHttp.Repo.Migrations.AddConfigTokenToDevices.change/0 forward firezone-firezone-1 | 12:43:12.929 [info] alter table devices firezone-firezone-1 | 12:43:12.929 [info] create index devices_config_token_index firezone-firezone-1 | 12:43:12.932 [info] == Migrated 20211216155557 in 0.0s firezone-firezone-1 | 12:43:12.935 [info] == Running 20211217003247 FzHttp.Repo.Migrations.AddPersistentKeepalives.change/0 forward firezone-firezone-1 | 12:43:12.935 [info] alter table devices firezone-firezone-1 | 12:43:12.936 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('default.device.persistent_keepalives', null, '2022-11-24 12:43:12.935804Z', '2022-11-24 12:43:12.935804Z')\n" firezone-firezone-1 | 12:43:12.937 [info] == Migrated 20211217003247 in 0.0s firezone-firezone-1 | 12:43:12.940 [info] == Running 20211221183311 FzHttp.Repo.Migrations.AddRoleToUsers.change/0 forward firezone-firezone-1 | 12:43:12.940 [info] execute "CREATE TYPE role_enum AS ENUM ('unprivileged', 'admin')" firezone-firezone-1 | 12:43:12.940 [info] alter table users firezone-firezone-1 | 12:43:12.941 [info] execute "UPDATE users SET role = 'admin' WHERE email = 'teknisk@digiserv.no'" firezone-firezone-1 | 12:43:12.942 [info] == Migrated 20211221183311 in 0.0s firezone-firezone-1 | 12:43:12.945 [info] == Running 20211223161545 FzHttp.Repo.Migrations.AddRequireAuthForVpnSetting.change/0 forward firezone-firezone-1 | 12:43:12.946 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('security.require_auth_for_vpn_frequency', '0', '2022-11-24 12:43:12.945766Z', '2022-11-24 12:43:12.945766Z')\n" firezone-firezone-1 | 12:43:12.946 [info] == Migrated 20211223161545 in 0.0s firezone-firezone-1 | 12:43:12.949 [info] == Running 20220103175026 FzHttp.Repo.Migrations.AddInetsToDevices.change/0 forward firezone-firezone-1 | 12:43:12.949 [info] alter table devices firezone-firezone-1 | 12:43:12.950 [info] create index devices_ipv4_index firezone-firezone-1 | 12:43:12.953 [info] create index devices_ipv6_index firezone-firezone-1 | 12:43:12.956 [info] execute "UPDATE devices\nSET ipv4 = ('10.3.2.' || address)::INET, ipv6 = ('fd00::3:2:' || address)::INET;\n" firezone-firezone-1 | 12:43:12.958 [info] alter table devices firezone-firezone-1 | 12:43:12.959 [info] == Migrated 20220103175026 in 0.0s firezone-firezone-1 | 12:43:12.962 [info] == Running 20220111004847 FzHttp.Repo.Migrations.AddMtuToDevices.change/0 forwardfirezone-firezone-1 | 12:43:12.963 [info] alter table devices firezone-firezone-1 | 12:43:12.964 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('default.device.mtu', null, '2022-11-24 12:43:12.963106Z', '2022-11-24 12:43:12.963106Z')\n" firezone-firezone-1 | 12:43:12.964 [info] == Migrated 20220111004847 in 0.0s firezone-firezone-1 | 12:43:12.967 [info] == Running 20220124162404 FzHttp.Repo.Migrations.AddUuids.change/0 forward firezone-firezone-1 | 12:43:12.967 [info] execute "CREATE EXTENSION IF NOT EXISTS pgcrypto" firezone-firezone-1 | 12:43:12.972 [info] execute "ALTER TABLE rules ADD COLUMN uuid uuid DEFAULT gen_random_uuid() NOT NULL" firezone-firezone-1 | 12:43:12.981 [info] execute "ALTER TABLE devices ADD COLUMN uuid uuid DEFAULT gen_random_uuid() NOT NULL" firezone-firezone-1 | 12:43:13.003 [info] execute "ALTER TABLE users ADD COLUMN uuid uuid DEFAULT gen_random_uuid() NOT NULL" firezone-firezone-1 | 12:43:13.018 [info] create index rules_uuid_index firezone-firezone-1 | 12:43:13.022 [info] create index devices_uuid_index firezone-firezone-1 | 12:43:13.025 [info] create index users_uuid_index firezone-firezone-1 | 12:43:13.027 [info] == Migrated 20220124162404 in 0.0s firezone-firezone-1 | 12:43:13.033 [info] == Running 20220127021835 FzHttp.Repo.Migrations.RenamePersistentKeepalives.change/0 forward firezone-firezone-1 | 12:43:13.033 [info] execute "UPDATE settings\nSET key = 'default.device.persistent_keepalive'\nWHERE key = 'default.device.persistent_keepalives'\n" firezone-firezone-1 | 12:43:13.034 [info] rename column persistent_keepalives to persistent_keepalive on table devices firezone-firezone-1 | 12:43:13.035 [info] rename column use_default_persistent_keepalives to use_default_persistent_keepalive on table devices firezone-firezone-1 | 12:43:13.035 [info] == Migrated 20220127021835 in 0.0s firezone-firezone-1 | 12:43:13.038 [info] == Running 20220127191440 FzHttp.Repo.Migrations.RenameDnsServersToDns.change/0 forward firezone-firezone-1 | 12:43:13.039 [info] execute "UPDATE settings\nSET key = 'default.device.dns'\nWHERE key = 'default.device.dns_servers'\n" firezone-firezone-1 | 12:43:13.039 [info] rename column dns_servers to dns on table devices firezone-firezone-1 | 12:43:13.040 [info] rename column use_default_dns_servers to use_default_dns on table devices firezone-firezone-1 | 12:43:13.041 [info] == Migrated 20220127191440 in 0.0s firezone-firezone-1 | 12:43:13.044 [info] == Running 20220208184257 FzHttp.Repo.Migrations.SettingsToSites.change/0 forwardfirezone-firezone-1 | 12:43:13.045 [info] create table sites firezone-firezone-1 | 12:43:13.051 [info] execute "INSERT INTO sites (id, name, inserted_at, updated_at)\nVALUES (gen_random_uuid(), 'default', '2022-11-24 12:43:13.044896Z', '2022-11-24 12:43:13.044896Z')\n" firezone-firezone-1 | 12:43:13.052 [info] execute " UPDATE sites\n SET dns = (\n SELECT value\n FROM settings\n WHERE key = 'default.device.dns'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.053 [info] execute " UPDATE sites\n SET allowed_ips = (\n SELECT value\n FROM settings\n WHERE key = 'default.device.allowed_ips'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.053 [info] execute " UPDATE sites\n SET endpoint = (\n SELECT value\n FROM settings\n WHERE key = 'default.device.endpoint'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.054 [info] execute " UPDATE sites\n SET persistent_keepalive = (\n SELECT value::INTEGER\n FROM settings\n WHERE key = 'default.device.persistent_keepalive'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.054 [info] execute " UPDATE sites\n SET mtu = (\n SELECT value::INTEGER\n FROM settings\n WHERE key = 'default.device.mtu'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.055 [info] execute " UPDATE sites\n SET vpn_session_duration = (\n SELECT value::INTEGER\n FROM settings\n WHERE key = 'security.require_auth_for_vpn_frequency'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.056 [info] drop table settings firezone-firezone-1 | 12:43:13.057 [info] create index sites_name_index firezone-firezone-1 | 12:43:13.059 [info] == Migrated 20220208184257 in 0.0s firezone-firezone-1 | 12:43:13.065 [info] == Running 20220209005201 FzHttp.Repo.Migrations.RenameUseDefaultToUseSite.change/0 forward firezone-firezone-1 | 12:43:13.065 [info] rename column use_default_allowed_ips to use_site_allowed_ips on table devices firezone-firezone-1 | 12:43:13.066 [info] rename column use_default_dns to use_site_dns on table devices firezone-firezone-1 | 12:43:13.066 [info] rename column use_default_endpoint to use_site_endpoint on table devices firezone-firezone-1 | 12:43:13.067 [info] rename column use_default_persistent_keepalive to use_site_persistent_keepalive on table devices firezone-firezone-1 | 12:43:13.067 [info] rename column use_default_mtu to use_site_mtu on table devices firezone-firezone-1 | 12:43:13.068 [info] == Migrated 20220209005201 in 0.0s firezone-firezone-1 | 12:43:13.071 [info] == Running 20220211201727 FzHttp.Repo.Migrations.RemovePrivateKeys.change/0 forward firezone-firezone-1 | 12:43:13.071 [info] alter table devices firezone-firezone-1 | 12:43:13.072 [info] == Migrated 20220211201727 in 0.0s firezone-firezone-1 | 12:43:13.075 [info] == Running 20220219165023 FzHttp.Repo.Migrations.AddKeyRegeneratedAt.change/0 forward firezone-firezone-1 | 12:43:13.075 [info] alter table devices firezone-firezone-1 | 12:43:13.076 [info] == Migrated 20220219165023 in 0.0s firezone-firezone-1 | 12:43:13.078 [info] == Running 20220227215313 FzHttp.Repo.Migrations.AddLastSignedInMethodToUser.change/0 forward firezone-firezone-1 | 12:43:13.079 [info] alter table users firezone-firezone-1 | 12:43:13.079 [info] == Migrated 20220227215313 in 0.0s firezone-firezone-1 | 12:43:13.082 [info] == Running 20220412144151 FzHttp.Repo.Migrations.AddPskToDevices.change/0 forwardfirezone-firezone-1 | 12:43:13.082 [info] alter table devices firezone-firezone-1 | 12:43:13.083 [info] == Migrated 20220412144151 in 0.0s firezone-firezone-1 | 12:43:13.086 [info] == Running 20220419172036 FzHttp.Repo.Migrations.AddStatsToDevices.change/0 forward firezone-firezone-1 | 12:43:13.086 [info] alter table devices firezone-firezone-1 | 12:43:13.087 [info] rename column last_seen_at to latest_handshake on table devices firezone-firezone-1 | 12:43:13.087 [info] == Migrated 20220419172036 in 0.0s firezone-firezone-1 | 12:43:13.090 [info] == Running 20220427140943 FzHttp.Repo.Migrations.AddDescriptionToDevices.change/0 forward firezone-firezone-1 | 12:43:13.090 [info] alter table devices firezone-firezone-1 | 12:43:13.091 [info] == Migrated 20220427140943 in 0.0s firezone-firezone-1 | 12:43:13.093 [info] == Running 20220516063916 FzHttp.Repo.Migrations.ChangeAllowedIpsToText.up/0 forward firezone-firezone-1 | 12:43:13.093 [info] alter table devices firezone-firezone-1 | 12:43:13.094 [info] alter table sites firezone-firezone-1 | 12:43:13.095 [info] == Migrated 20220516063916 in 0.0s firezone-firezone-1 | 12:43:13.098 [info] == Running 20220519034545 FzHttp.Repo.Migrations.CreateOidcConnections.change/0 forward firezone-firezone-1 | 12:43:13.098 [info] create table oidc_connections firezone-firezone-1 | 12:43:13.105 [info] create index oidc_connections_user_id_provider_index firezone-firezone-1 | 12:43:13.108 [info] == Migrated 20220519034545 in 0.0s firezone-firezone-1 | 12:43:13.111 [info] == Running 20220520072323 FzHttp.Repo.Migrations.AddDisabledAtToUser.change/0 forward firezone-firezone-1 | 12:43:13.111 [info] alter table users firezone-firezone-1 | 12:43:13.112 [info] == Migrated 20220520072323 in 0.0s firezone-firezone-1 | 12:43:13.115 [info] == Running 20220530073152 FzHttp.Repo.Migrations.CreateMfaMethods.change/0 forward firezone-firezone-1 | 12:43:13.116 [info] execute "CREATE TYPE mfa_type_enum AS ENUM ('totp', 'native', 'portable')" firezone-firezone-1 | 12:43:13.116 [info] create table mfa_methods firezone-firezone-1 | 12:43:13.122 [info] create index mfa_methods_user_id_index firezone-firezone-1 | 12:43:13.125 [info] create index mfa_methods_credential_id_index firezone-firezone-1 | 12:43:13.129 [info] == Migrated 20220530073152 in 0.0s firezone-firezone-1 | 12:43:13.132 [info] == Running 20220609232854 FzHttp.Repo.Migrations.ChangeRefreshTokenToText.change/0 forward firezone-firezone-1 | 12:43:13.132 [info] alter table oidc_connections firezone-firezone-1 | 12:43:13.133 [info] == Migrated 20220609232854 in 0.0s firezone-firezone-1 | 12:43:13.135 [info] == Running 20220614192937 FzHttp.Repo.Migrations.AddUserIdToRules.change/0 forward firezone-firezone-1 | 12:43:13.136 [info] drop index rules_destination_action_index firezone-firezone-1 | 12:43:13.136 [info] alter table rules firezone-firezone-1 | 12:43:13.138 [info] execute "\n DELETE FROM rules r1\n USING rules r2\n WHERE r2.destination >> r1.destination\n AND r2.action = r1.action\n AND r1.user_id IS NULL\n AND r2.user_id IS NULL\n "firezone-firezone-1 | 12:43:13.139 [info] execute "\n DELETE FROM rules r1\n USING rules r2\n WHERE r2.destination >> r1.destination\n AND r2.action = r1.action\n AND r2.user_id = r1.user_id\n " firezone-firezone-1 | 12:43:13.140 [info] execute "CREATE EXTENSION btree_gist" firezone-firezone-1 | 12:43:13.173 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_usr_rule EXCLUDE USING gist (destination inet_ops WITH &&, user_id WITH =, action WITH =) WHERE (user_id IS NOT NULL)" firezone-firezone-1 | 12:43:13.175 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl EXCLUDE USING gist (destination inet_ops WITH &&, action WITH =) WHERE (user_id IS NULL)" firezone-firezone-1 | 12:43:13.176 [info] == Migrated 20220614192937 in 0.0s firezone-firezone-1 | 12:43:13.183 [info] == Running 20220713050742 FzHttp.Repo.Migrations.CreateConfigurations.change/0 forward firezone-firezone-1 | 12:43:13.183 [info] create table configurations firezone-firezone-1 | 12:43:13.188 [info] execute "INSERT INTO configurations (id, inserted_at, updated_at)\nVALUES (gen_random_uuid(), '2022-11-24 12:43:13.183763Z', '2022-11-24 12:43:13.183763Z')\n" firezone-firezone-1 | 12:43:13.189 [info] == Migrated 20220713050742 in 0.0s firezone-firezone-1 | 12:43:13.192 [info] == Running 20220719014442 FzHttp.Repo.Migrations.AddAuthConfigs.change/0 forward firezone-firezone-1 | 12:43:13.192 [info] alter table configurations firezone-firezone-1 | 12:43:13.193 [info] == Migrated 20220719014442 in 0.0s firezone-firezone-1 | 12:43:13.196 [info] == Running 20220721164925 FzHttp.Repo.Migrations.AddDeviceRuleUserNotifyTriggers.change/0 forward firezone-firezone-1 | 12:43:13.196 [info] execute "CREATE OR REPLACE FUNCTION notify_device_changes()\nRETURNS trigger AS $$\nDECLARE\n row record;\nBEGIN\n row := NEW;\n\n IF (TG_OP = 'DELETE') THEN\n row := OLD;\n END IF;\n\n PERFORM pg_notify(\n 'devices_changed',\n json_build_object(\n 'op', TG_OP,\n 'row', row_to_json(row)\n )::text\n );\n\n RETURN row;\nEND;\n$$ LANGUAGE plpgsql;\n" firezone-firezone-1 | 12:43:13.199 [info] execute "CREATE CONSTRAINT TRIGGER devices_changed\nAFTER INSERT OR DELETE ON devices\nDEFERRABLE\nFOR EACH ROW EXECUTE PROCEDURE notify_device_changes()\n" firezone-firezone-1 | 12:43:13.200 [info] execute "CREATE OR REPLACE FUNCTION notify_rule_changes()\nRETURNS trigger AS $$\nDECLARE\n row record;\nBEGIN\n row := NEW;\n\n IF (TG_OP = 'DELETE') THEN\n row := OLD;\n END IF;\n\n PERFORM pg_notify(\n 'rules_changed',\n json_build_object(\n 'op', TG_OP,\n 'row', row_to_json(row)\n )::text\n );\n\n RETURN row;\nEND;\n$$ LANGUAGE plpgsql;\n" firezone-firezone-1 | 12:43:13.200 [info] execute "CREATE CONSTRAINT TRIGGER rules_changed\nAFTER INSERT OR DELETE ON rules\nDEFERRABLE\nFOR EACH ROW EXECUTE PROCEDURE notify_rule_changes()\n" firezone-firezone-1 | 12:43:13.201 [info] execute "CREATE OR REPLACE FUNCTION notify_user_changes()\nRETURNS trigger AS $$\nDECLARE\n row record;\nBEGIN\n row := NEW;\n\n IF (TG_OP = 'DELETE') THEN\n row := OLD;\n END IF;\n\n PERFORM pg_notify(\n 'users_changed',\n json_build_object(\n 'op', TG_OP,\n 'row', row_to_json(row)\n )::text\n );\n\n RETURN row;\nEND;\n$$ LANGUAGE plpgsql;\n" firezone-firezone-1 | 12:43:13.202 [info] execute "CREATE CONSTRAINT TRIGGER users_changed\nAFTER INSERT OR DELETE ON users\nDEFERRABLE\nFOR EACH ROW EXECUTE PROCEDURE notify_user_changes()\n" firezone-firezone-1 | 12:43:13.202 [info] == Migrated 20220721164925 in 0.0s firezone-firezone-1 | 12:43:13.205 [info] == Running 20220726205646 FzHttp.Repo.Migrations.AddRulePortRange.change/0 forward firezone-firezone-1 | 12:43:13.206 [info] execute "ALTER TABLE rules DROP CONSTRAINT destination_overlap_excl_usr_rule" firezone-firezone-1 | 12:43:13.206 [info] execute "ALTER TABLE rules DROP CONSTRAINT destination_overlap_excl" firezone-firezone-1 | 12:43:13.207 [info] execute "CREATE TYPE port_type_enum AS ENUM ('tcp', 'udp')" firezone-firezone-1 | 12:43:13.208 [info] alter table rules firezone-firezone-1 | 12:43:13.209 [info] create check constraint port_range_needs_type on table rules firezone-firezone-1 | 12:43:13.209 [info] create check constraint port_range_is_within_valid_values on table rules firezone-firezone-1 | 12:43:13.210 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl EXCLUDE USING gist (destination inet_ops WITH &&, action WITH =) WHERE (user_id IS NULL AND port_range IS NULL)" firezone-firezone-1 | 12:43:13.211 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_usr_rule EXCLUDE USING gist (destination inet_ops WITH &&, user_id WITH =, action WITH =) WHERE (user_id IS NOT NULL AND port_range IS NULL)" firezone-firezone-1 | 12:43:13.212 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_port EXCLUDE USING gist (destination inet_ops WITH &&, action WITH =, port_range WITH &&, port_type WITH =) WHERE (user_id IS NULL AND port_range IS NOT NULL)" firezone-firezone-1 | 12:43:13.214 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_usr_rule_port EXCLUDE USING gist (destination inet_ops WITH &&, user_id WITH =, action WITH =, port_range WITH &&, port_type WITH =) WHERE (user_id IS NOT NULL AND port_range IS NOT NULL)" firezone-firezone-1 | 12:43:13.215 [info] == Migrated 20220726205646 in 0.0s firezone-firezone-1 | 12:43:13.220 [info] == Running 20220810002432 FzHttp.Repo.Migrations.AddUnprivilegedDeviceConfiguration.change/0 forward firezone-firezone-1 | 12:43:13.220 [info] alter table configurations firezone-firezone-1 | 12:43:13.221 [info] == Migrated 20220810002432 in 0.0s firezone-firezone-1 | 12:43:13.223 [info] == Running 20220831060724 FzHttp.Repo.Migrations.AddSamlIdentityProvidersToConfiguration.change/0 forward firezone-firezone-1 | 12:43:13.224 [info] alter table configurations firezone-firezone-1 | 12:43:13.224 [info] == Migrated 20220831060724 in 0.0s firezone-firezone-1 | 12:43:13.227 [info] == Running 20221012123308 FzHttp.Repo.Migrations.MoveAutoCreateUsersToProviders.change/0 forward firezone-firezone-1 | 12:43:13.230 [info] alter table configurations firezone-firezone-1 | 12:43:13.230 [info] == Migrated 20221012123308 in 0.0s firezone-firezone-1 | 12:43:14.733 [info] Running FzHttpWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:13000 (http) firezone-firezone-1 | 12:43:14.736 [info] Access FzHttpWeb.Endpoint at https://firezone.domain.name firezone-firezone-1 exited with code 0 firezone-firezone-1 | Generating a RSA private key firezone-firezone-1 | ......................+++++ firezone-firezone-1 | .........................................................+++++ firezone-firezone-1 | writing new private key to '/var/firezone/saml.key' firezone-firezone-1 | ----- firezone-firezone-1 | 12:43:12.809 [info] == Running 20200225005454 FzHttp.Repo.Migrations.CreateUsers.change/0 forward firezone-firezone-1 | 12:43:12.812 [info] create table users firezone-firezone-1 | 12:43:12.821 [info] create index users_email_index firezone-firezone-1 | 12:43:12.824 [info] create index users_sign_in_token_sign_in_token_created_at_index firezone-firezone-1 | 12:43:12.829 [info] == Migrated 20200225005454 in 0.0s firezone-firezone-1 | 12:43:12.850 [info] == Running 20200228145810 FzHttp.Repo.Migrations.CreateDevices.change/0 forward firezone-firezone-1 | 12:43:12.851 [info] create table devices firezone-firezone-1 | 12:43:12.859 [info] execute "CREATE SEQUENCE address_sequence AS SMALLINT MINVALUE 2 MAXVALUE 254 START 2 CYCLE OWNED BY devices.address " firezone-firezone-1 | 12:43:12.860 [info] execute "ALTER TABLE devices ALTER COLUMN address SET DEFAULT NEXTVAL('address_sequence')" firezone-firezone-1 | 12:43:12.860 [info] create index devices_user_id_index firezone-firezone-1 | 12:43:12.863 [info] create index devices_public_key_index firezone-firezone-1 | 12:43:12.866 [info] create index devices_private_key_index firezone-firezone-1 | 12:43:12.869 [info] create index devices_user_id_name_index firezone-firezone-1 | 12:43:12.872 [info] create index devices_address_index firezone-firezone-1 | 12:43:12.875 [info] == Migrated 20200228145810 in 0.0s firezone-firezone-1 | 12:43:12.879 [info] == Running 20200228154815 FzHttp.Repo.Migrations.CreateRules.change/0 forward firezone-firezone-1 | 12:43:12.879 [info] execute "CREATE TYPE action_enum AS ENUM ('drop', 'accept')" firezone-firezone-1 | 12:43:12.880 [info] create table rules firezone-firezone-1 | 12:43:12.886 [info] create index rules_destination_action_index firezone-firezone-1 | 12:43:12.889 [info] == Migrated 20200228154815 in 0.0s firezone-firezone-1 | 12:43:12.892 [info] == Running 20210929172417 FzHttp.Repo.Migrations.AddDnsServersToDevices.change/0 forward firezone-firezone-1 | 12:43:12.892 [info] alter table devices firezone-firezone-1 | 12:43:12.893 [info] == Migrated 20210929172417 in 0.0s firezone-firezone-1 | 12:43:12.896 [info] == Running 20211116172808 FzHttp.Repo.Migrations.CreateConnectivityChecks.change/0 forward firezone-firezone-1 | 12:43:12.896 [info] create table connectivity_checks firezone-firezone-1 | 12:43:12.902 [info] create index connectivity_checks_inserted_at_index firezone-firezone-1 | 12:43:12.905 [info] == Migrated 20211116172808 in 0.0s firezone-firezone-1 | 12:43:12.908 [info] == Running 20211116173236 FzHttp.Repo.Migrations.CreateSettings.change/0 forward firezone-firezone-1 | 12:43:12.909 [info] create table settings firezone-firezone-1 | 12:43:12.914 [info] create index settings_key_index firezone-firezone-1 | 12:43:12.918 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('default.device.dns_servers', null, '2022-11-24 12:43:12.917368Z', '2022-11-24 12:43:12.917368Z'),\n('default.device.allowed_ips', null, '2022-11-24 12:43:12.917368Z', '2022-11-24 12:43:12.917368Z'),\n('default.device.endpoint', null, '2022-11-24 12:43:12.917368Z', '2022-11-24 12:43:12.917368Z')\n" firezone-firezone-1 | 12:43:12.919 [info] == Migrated 20211116173236 in 0.0s firezone-firezone-1 | 12:43:12.923 [info] == Running 20211203012238 FzHttp.Repo.Migrations.ChangeDeviceColumnDefaults.change/0 forward firezone-firezone-1 | 12:43:12.923 [info] alter table devices firezone-firezone-1 | 12:43:12.926 [info] == Migrated 20211203012238 in 0.0s firezone-firezone-1 | 12:43:12.928 [info] == Running 20211216155557 FzHttp.Repo.Migrations.AddConfigTokenToDevices.change/0 forward firezone-firezone-1 | 12:43:12.929 [info] alter table devices firezone-firezone-1 | 12:43:12.929 [info] create index devices_config_token_index firezone-firezone-1 | 12:43:12.932 [info] == Migrated 20211216155557 in 0.0s firezone-firezone-1 | 12:43:12.935 [info] == Running 20211217003247 FzHttp.Repo.Migrations.AddPersistentKeepalives.change/0 forward firezone-firezone-1 | 12:43:12.935 [info] alter table devices firezone-firezone-1 | 12:43:12.936 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('default.device.persistent_keepalives', null, '2022-11-24 12:43:12.935804Z', '2022-11-24 12:43:12.935804Z')\n" firezone-firezone-1 | 12:43:12.937 [info] == Migrated 20211217003247 in 0.0s firezone-firezone-1 | 12:43:12.940 [info] == Running 20211221183311 FzHttp.Repo.Migrations.AddRoleToUsers.change/0 forward firezone-firezone-1 | 12:43:12.940 [info] execute "CREATE TYPE role_enum AS ENUM ('unprivileged', 'admin')" firezone-firezone-1 | 12:43:12.940 [info] alter table users firezone-firezone-1 | 12:43:12.941 [info] execute "UPDATE users SET role = 'admin' WHERE email = 'teknisk@digiserv.no'" firezone-firezone-1 | 12:43:12.942 [info] == Migrated 20211221183311 in 0.0s firezone-firezone-1 | 12:43:12.945 [info] == Running 20211223161545 FzHttp.Repo.Migrations.AddRequireAuthForVpnSetting.change/0 forward firezone-firezone-1 | 12:43:12.946 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('security.require_auth_for_vpn_frequency', '0', '2022-11-24 12:43:12.945766Z', '2022-11-24 12:43:12.945766Z')\n" firezone-firezone-1 | 12:43:12.946 [info] == Migrated 20211223161545 in 0.0s firezone-firezone-1 | 12:43:12.949 [info] == Running 20220103175026 FzHttp.Repo.Migrations.AddInetsToDevices.change/0 forward firezone-firezone-1 | 12:43:12.949 [info] alter table devices firezone-firezone-1 | 12:43:12.950 [info] create index devices_ipv4_index firezone-firezone-1 | 12:43:12.953 [info] create index devices_ipv6_index firezone-firezone-1 | 12:43:12.956 [info] execute "UPDATE devices\nSET ipv4 = ('10.3.2.' || address)::INET, ipv6 = ('fd00::3:2:' || address)::INET;\n" firezone-firezone-1 | 12:43:12.958 [info] alter table devices firezone-firezone-1 | 12:43:12.959 [info] == Migrated 20220103175026 in 0.0s firezone-firezone-1 | 12:43:12.962 [info] == Running 20220111004847 FzHttp.Repo.Migrations.AddMtuToDevices.change/0 forwardfirezone-firezone-1 | 12:43:12.963 [info] alter table devices firezone-firezone-1 | 12:43:12.964 [info] execute "INSERT INTO settings (key, value, inserted_at, updated_at) VALUES ('default.device.mtu', null, '2022-11-24 12:43:12.963106Z', '2022-11-24 12:43:12.963106Z')\n" firezone-firezone-1 | 12:43:12.964 [info] == Migrated 20220111004847 in 0.0s firezone-firezone-1 | 12:43:12.967 [info] == Running 20220124162404 FzHttp.Repo.Migrations.AddUuids.change/0 forward firezone-firezone-1 | 12:43:12.967 [info] execute "CREATE EXTENSION IF NOT EXISTS pgcrypto" firezone-firezone-1 | 12:43:12.972 [info] execute "ALTER TABLE rules ADD COLUMN uuid uuid DEFAULT gen_random_uuid() NOT NULL" firezone-firezone-1 | 12:43:12.981 [info] execute "ALTER TABLE devices ADD COLUMN uuid uuid DEFAULT gen_random_uuid() NOT NULL" firezone-firezone-1 | 12:43:13.003 [info] execute "ALTER TABLE users ADD COLUMN uuid uuid DEFAULT gen_random_uuid() NOT NULL" firezone-firezone-1 | 12:43:13.018 [info] create index rules_uuid_index firezone-firezone-1 | 12:43:13.022 [info] create index devices_uuid_index firezone-firezone-1 | 12:43:13.025 [info] create index users_uuid_index firezone-firezone-1 | 12:43:13.027 [info] == Migrated 20220124162404 in 0.0s firezone-firezone-1 | 12:43:13.033 [info] == Running 20220127021835 FzHttp.Repo.Migrations.RenamePersistentKeepalives.change/0 forward firezone-firezone-1 | 12:43:13.033 [info] execute "UPDATE settings\nSET key = 'default.device.persistent_keepalive'\nWHERE key = 'default.device.persistent_keepalives'\n" firezone-firezone-1 | 12:43:13.034 [info] rename column persistent_keepalives to persistent_keepalive on table devices firezone-firezone-1 | 12:43:13.035 [info] rename column use_default_persistent_keepalives to use_default_persistent_keepalive on table devices firezone-firezone-1 | 12:43:13.035 [info] == Migrated 20220127021835 in 0.0s firezone-firezone-1 | 12:43:13.038 [info] == Running 20220127191440 FzHttp.Repo.Migrations.RenameDnsServersToDns.change/0 forward firezone-firezone-1 | 12:43:13.039 [info] execute "UPDATE settings\nSET key = 'default.device.dns'\nWHERE key = 'default.device.dns_servers'\n" firezone-firezone-1 | 12:43:13.039 [info] rename column dns_servers to dns on table devices firezone-firezone-1 | 12:43:13.040 [info] rename column use_default_dns_servers to use_default_dns on table devices firezone-firezone-1 | 12:43:13.041 [info] == Migrated 20220127191440 in 0.0s firezone-firezone-1 | 12:43:13.044 [info] == Running 20220208184257 FzHttp.Repo.Migrations.SettingsToSites.change/0 forwardfirezone-firezone-1 | 12:43:13.045 [info] create table sites firezone-firezone-1 | 12:43:13.051 [info] execute "INSERT INTO sites (id, name, inserted_at, updated_at)\nVALUES (gen_random_uuid(), 'default', '2022-11-24 12:43:13.044896Z', '2022-11-24 12:43:13.044896Z')\n" firezone-firezone-1 | 12:43:13.052 [info] execute " UPDATE sites\n SET dns = (\n SELECT value\n FROM settings\n WHERE key = 'default.device.dns'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.053 [info] execute " UPDATE sites\n SET allowed_ips = (\n SELECT value\n FROM settings\n WHERE key = 'default.device.allowed_ips'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.053 [info] execute " UPDATE sites\n SET endpoint = (\n SELECT value\n FROM settings\n WHERE key = 'default.device.endpoint'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.054 [info] execute " UPDATE sites\n SET persistent_keepalive = (\n SELECT value::INTEGER\n FROM settings\n WHERE key = 'default.device.persistent_keepalive'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.054 [info] execute " UPDATE sites\n SET mtu = (\n SELECT value::INTEGER\n FROM settings\n WHERE key = 'default.device.mtu'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.055 [info] execute " UPDATE sites\n SET vpn_session_duration = (\n SELECT value::INTEGER\n FROM settings\n WHERE key = 'security.require_auth_for_vpn_frequency'\n )\n WHERE sites.name = 'default'\n" firezone-firezone-1 | 12:43:13.056 [info] drop table settings firezone-firezone-1 | 12:43:13.057 [info] create index sites_name_index firezone-firezone-1 | 12:43:13.059 [info] == Migrated 20220208184257 in 0.0s firezone-firezone-1 | 12:43:13.065 [info] == Running 20220209005201 FzHttp.Repo.Migrations.RenameUseDefaultToUseSite.change/0 forward firezone-firezone-1 | 12:43:13.065 [info] rename column use_default_allowed_ips to use_site_allowed_ips on table devices firezone-firezone-1 | 12:43:13.066 [info] rename column use_default_dns to use_site_dns on table devices firezone-firezone-1 | 12:43:13.066 [info] rename column use_default_endpoint to use_site_endpoint on table devices firezone-firezone-1 | 12:43:13.067 [info] rename column use_default_persistent_keepalive to use_site_persistent_keepalive on table devices firezone-firezone-1 | 12:43:13.067 [info] rename column use_default_mtu to use_site_mtu on table devices firezone-firezone-1 | 12:43:13.068 [info] == Migrated 20220209005201 in 0.0s firezone-firezone-1 | 12:43:13.071 [info] == Running 20220211201727 FzHttp.Repo.Migrations.RemovePrivateKeys.change/0 forward firezone-firezone-1 | 12:43:13.071 [info] alter table devices firezone-firezone-1 | 12:43:13.072 [info] == Migrated 20220211201727 in 0.0s firezone-firezone-1 | 12:43:13.075 [info] == Running 20220219165023 FzHttp.Repo.Migrations.AddKeyRegeneratedAt.change/0 forward firezone-firezone-1 | 12:43:13.075 [info] alter table devices firezone-firezone-1 | 12:43:13.076 [info] == Migrated 20220219165023 in 0.0s firezone-firezone-1 | 12:43:13.078 [info] == Running 20220227215313 FzHttp.Repo.Migrations.AddLastSignedInMethodToUser.change/0 forward firezone-firezone-1 | 12:43:13.079 [info] alter table users firezone-firezone-1 | 12:43:13.079 [info] == Migrated 20220227215313 in 0.0s firezone-firezone-1 | 12:43:13.082 [info] == Running 20220412144151 FzHttp.Repo.Migrations.AddPskToDevices.change/0 forwardfirezone-firezone-1 | 12:43:13.082 [info] alter table devices firezone-firezone-1 | 12:43:13.083 [info] == Migrated 20220412144151 in 0.0s firezone-firezone-1 | 12:43:13.086 [info] == Running 20220419172036 FzHttp.Repo.Migrations.AddStatsToDevices.change/0 forward firezone-firezone-1 | 12:43:13.086 [info] alter table devices firezone-firezone-1 | 12:43:13.087 [info] rename column last_seen_at to latest_handshake on table devices firezone-firezone-1 | 12:43:13.087 [info] == Migrated 20220419172036 in 0.0s firezone-firezone-1 | 12:43:13.090 [info] == Running 20220427140943 FzHttp.Repo.Migrations.AddDescriptionToDevices.change/0 forward firezone-firezone-1 | 12:43:13.090 [info] alter table devices firezone-firezone-1 | 12:43:13.091 [info] == Migrated 20220427140943 in 0.0s firezone-firezone-1 | 12:43:13.093 [info] == Running 20220516063916 FzHttp.Repo.Migrations.ChangeAllowedIpsToText.up/0 forward firezone-firezone-1 | 12:43:13.093 [info] alter table devices firezone-firezone-1 | 12:43:13.094 [info] alter table sites firezone-firezone-1 | 12:43:13.095 [info] == Migrated 20220516063916 in 0.0s firezone-firezone-1 | 12:43:13.098 [info] == Running 20220519034545 FzHttp.Repo.Migrations.CreateOidcConnections.change/0 forward firezone-firezone-1 | 12:43:13.098 [info] create table oidc_connections firezone-firezone-1 | 12:43:13.105 [info] create index oidc_connections_user_id_provider_index firezone-firezone-1 | 12:43:13.108 [info] == Migrated 20220519034545 in 0.0s firezone-firezone-1 | 12:43:13.111 [info] == Running 20220520072323 FzHttp.Repo.Migrations.AddDisabledAtToUser.change/0 forward firezone-firezone-1 | 12:43:13.111 [info] alter table users firezone-firezone-1 | 12:43:13.112 [info] == Migrated 20220520072323 in 0.0s firezone-firezone-1 | 12:43:13.115 [info] == Running 20220530073152 FzHttp.Repo.Migrations.CreateMfaMethods.change/0 forward firezone-firezone-1 | 12:43:13.116 [info] execute "CREATE TYPE mfa_type_enum AS ENUM ('totp', 'native', 'portable')" firezone-firezone-1 | 12:43:13.116 [info] create table mfa_methods firezone-firezone-1 | 12:43:13.122 [info] create index mfa_methods_user_id_index firezone-firezone-1 | 12:43:13.125 [info] create index mfa_methods_credential_id_index firezone-firezone-1 | 12:43:13.129 [info] == Migrated 20220530073152 in 0.0s firezone-firezone-1 | 12:43:13.132 [info] == Running 20220609232854 FzHttp.Repo.Migrations.ChangeRefreshTokenToText.change/0 forward firezone-firezone-1 | 12:43:13.132 [info] alter table oidc_connections firezone-firezone-1 | 12:43:13.133 [info] == Migrated 20220609232854 in 0.0s firezone-firezone-1 | 12:43:13.135 [info] == Running 20220614192937 FzHttp.Repo.Migrations.AddUserIdToRules.change/0 forward firezone-firezone-1 | 12:43:13.136 [info] drop index rules_destination_action_index firezone-firezone-1 | 12:43:13.136 [info] alter table rules firezone-firezone-1 | 12:43:13.138 [info] execute "\n DELETE FROM rules r1\n USING rules r2\n WHERE r2.destination >> r1.destination\n AND r2.action = r1.action\n AND r1.user_id IS NULL\n AND r2.user_id IS NULL\n "firezone-firezone-1 | 12:43:13.139 [info] execute "\n DELETE FROM rules r1\n USING rules r2\n WHERE r2.destination >> r1.destination\n AND r2.action = r1.action\n AND r2.user_id = r1.user_id\n " firezone-firezone-1 | 12:43:13.140 [info] execute "CREATE EXTENSION btree_gist" firezone-firezone-1 | 12:43:13.173 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_usr_rule EXCLUDE USING gist (destination inet_ops WITH &&, user_id WITH =, action WITH =) WHERE (user_id IS NOT NULL)" firezone-firezone-1 | 12:43:13.175 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl EXCLUDE USING gist (destination inet_ops WITH &&, action WITH =) WHERE (user_id IS NULL)" firezone-firezone-1 | 12:43:13.176 [info] == Migrated 20220614192937 in 0.0s firezone-firezone-1 | 12:43:13.183 [info] == Running 20220713050742 FzHttp.Repo.Migrations.CreateConfigurations.change/0 forward firezone-firezone-1 | 12:43:13.183 [info] create table configurations firezone-firezone-1 | 12:43:13.188 [info] execute "INSERT INTO configurations (id, inserted_at, updated_at)\nVALUES (gen_random_uuid(), '2022-11-24 12:43:13.183763Z', '2022-11-24 12:43:13.183763Z')\n" firezone-firezone-1 | 12:43:13.189 [info] == Migrated 20220713050742 in 0.0s firezone-firezone-1 | 12:43:13.192 [info] == Running 20220719014442 FzHttp.Repo.Migrations.AddAuthConfigs.change/0 forward firezone-firezone-1 | 12:43:13.192 [info] alter table configurations firezone-firezone-1 | 12:43:13.193 [info] == Migrated 20220719014442 in 0.0s firezone-firezone-1 | 12:43:13.196 [info] == Running 20220721164925 FzHttp.Repo.Migrations.AddDeviceRuleUserNotifyTriggers.change/0 forward firezone-firezone-1 | 12:43:13.196 [info] execute "CREATE OR REPLACE FUNCTION notify_device_changes()\nRETURNS trigger AS $$\nDECLARE\n row record;\nBEGIN\n row := NEW;\n\n IF (TG_OP = 'DELETE') THEN\n row := OLD;\n END IF;\n\n PERFORM pg_notify(\n 'devices_changed',\n json_build_object(\n 'op', TG_OP,\n 'row', row_to_json(row)\n )::text\n );\n\n RETURN row;\nEND;\n$$ LANGUAGE plpgsql;\n" firezone-firezone-1 | 12:43:13.199 [info] execute "CREATE CONSTRAINT TRIGGER devices_changed\nAFTER INSERT OR DELETE ON devices\nDEFERRABLE\nFOR EACH ROW EXECUTE PROCEDURE notify_device_changes()\n" firezone-firezone-1 | 12:43:13.200 [info] execute "CREATE OR REPLACE FUNCTION notify_rule_changes()\nRETURNS trigger AS $$\nDECLARE\n row record;\nBEGIN\n row := NEW;\n\n IF (TG_OP = 'DELETE') THEN\n row := OLD;\n END IF;\n\n PERFORM pg_notify(\n 'rules_changed',\n json_build_object(\n 'op', TG_OP,\n 'row', row_to_json(row)\n )::text\n );\n\n RETURN row;\nEND;\n$$ LANGUAGE plpgsql;\n" firezone-firezone-1 | 12:43:13.200 [info] execute "CREATE CONSTRAINT TRIGGER rules_changed\nAFTER INSERT OR DELETE ON rules\nDEFERRABLE\nFOR EACH ROW EXECUTE PROCEDURE notify_rule_changes()\n" firezone-firezone-1 | 12:43:13.201 [info] execute "CREATE OR REPLACE FUNCTION notify_user_changes()\nRETURNS trigger AS $$\nDECLARE\n row record;\nBEGIN\n row := NEW;\n\n IF (TG_OP = 'DELETE') THEN\n row := OLD;\n END IF;\n\n PERFORM pg_notify(\n 'users_changed',\n json_build_object(\n 'op', TG_OP,\n 'row', row_to_json(row)\n )::text\n );\n\n RETURN row;\nEND;\n$$ LANGUAGE plpgsql;\n" firezone-firezone-1 | 12:43:13.202 [info] execute "CREATE CONSTRAINT TRIGGER users_changed\nAFTER INSERT OR DELETE ON users\nDEFERRABLE\nFOR EACH ROW EXECUTE PROCEDURE notify_user_changes()\n" firezone-firezone-1 | 12:43:13.202 [info] == Migrated 20220721164925 in 0.0s firezone-firezone-1 | 12:43:13.205 [info] == Running 20220726205646 FzHttp.Repo.Migrations.AddRulePortRange.change/0 forward firezone-firezone-1 | 12:43:13.206 [info] execute "ALTER TABLE rules DROP CONSTRAINT destination_overlap_excl_usr_rule" firezone-firezone-1 | 12:43:13.206 [info] execute "ALTER TABLE rules DROP CONSTRAINT destination_overlap_excl" firezone-firezone-1 | 12:43:13.207 [info] execute "CREATE TYPE port_type_enum AS ENUM ('tcp', 'udp')" firezone-firezone-1 | 12:43:13.208 [info] alter table rules firezone-firezone-1 | 12:43:13.209 [info] create check constraint port_range_needs_type on table rules firezone-firezone-1 | 12:43:13.209 [info] create check constraint port_range_is_within_valid_values on table rules firezone-firezone-1 | 12:43:13.210 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl EXCLUDE USING gist (destination inet_ops WITH &&, action WITH =) WHERE (user_id IS NULL AND port_range IS NULL)" firezone-firezone-1 | 12:43:13.211 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_usr_rule EXCLUDE USING gist (destination inet_ops WITH &&, user_id WITH =, action WITH =) WHERE (user_id IS NOT NULL AND port_range IS NULL)" firezone-firezone-1 | 12:43:13.212 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_port EXCLUDE USING gist (destination inet_ops WITH &&, action WITH =, port_range WITH &&, port_type WITH =) WHERE (user_id IS NULL AND port_range IS NOT NULL)" firezone-firezone-1 | 12:43:13.214 [info] execute "ALTER TABLE rules\n ADD CONSTRAINT destination_overlap_excl_usr_rule_port EXCLUDE USING gist (destination inet_ops WITH &&, user_id WITH =, action WITH =, port_range WITH &&, port_type WITH =) WHERE (user_id IS NOT NULL AND port_range IS NOT NULL)" firezone-firezone-1 | 12:43:13.215 [info] == Migrated 20220726205646 in 0.0s firezone-firezone-1 | 12:43:13.220 [info] == Running 20220810002432 FzHttp.Repo.Migrations.AddUnprivilegedDeviceConfiguration.change/0 forward firezone-firezone-1 | 12:43:13.220 [info] alter table configurations firezone-firezone-1 | 12:43:13.221 [info] == Migrated 20220810002432 in 0.0s firezone-firezone-1 | 12:43:13.223 [info] == Running 20220831060724 FzHttp.Repo.Migrations.AddSamlIdentityProvidersToConfiguration.change/0 forward firezone-firezone-1 | 12:43:13.224 [info] alter table configurations firezone-firezone-1 | 12:43:13.224 [info] == Migrated 20220831060724 in 0.0s firezone-firezone-1 | 12:43:13.227 [info] == Running 20221012123308 FzHttp.Repo.Migrations.MoveAutoCreateUsersToProviders.change/0 forward firezone-firezone-1 | 12:43:13.230 [info] alter table configurations firezone-firezone-1 | 12:43:13.230 [info] == Migrated 20221012123308 in 0.0s firezone-firezone-1 | 12:43:14.733 [info] Running FzHttpWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:13000 (http) firezone-firezone-1 | 12:43:14.736 [info] Access FzHttpWeb.Endpoint at https://heimdall.digiserv.no firezone-firezone-1 | 12:43:29.939 [info] Migrations already up firezone-firezone-1 | 12:43:31.675 [info] Running FzHttpWeb.Endpoint with cowboy 2.9.0 at 0.0.0.0:13000 (http) firezone-firezone-1 | 12:43:31.684 [info] Access FzHttpWeb.Endpoint at https://heimdall.digiserv.no