api service when i run …/balena-cli/balena os configure …/openbalenaimage/balena-cloud-intel-nuc-2.50.1+rev1-dev-v11.4.10.img --app test10 --version 2.50.1+rev1-dev
Jun 17 15:40:02 d6617561938b api[1465]: Running PATCH /resin/service_instance(2)
Jun 17 15:40:02 d6617561938b api[1465]: UPDATE "service instance"
Jun 17 15:40:02 d6617561938b api[1465]: SET "last heartbeat" = $1
Jun 17 15:40:02 d6617561938b api[1465]: WHERE "service instance"."id" = $2 [ 2020-06-17T15:40:02.608Z, 2 ]
Jun 17 15:40:05 d6617561938b kernel: [UFW BLOCK] IN=ens3 OUT= MAC=56:00:02:d6:66:92:fe:00:02:d6:66:92:08:00 SRC=180.111.3.48 DST=136.244.108.255 LEN=40 TOS=0x00 PREC=0x00 TTL=52 ID=56521 PROTO=TCP SPT=2378 DPT=23 WINDOW=27682 RES=0x00 SYN URGP=0
Jun 17 15:40:12 d6617561938b api[1465]: Parsing PATCH /resin/service_instance(2)
Jun 17 15:40:12 d6617561938b api[1465]: Running PATCH /resin/service_instance(2)
Jun 17 15:40:12 d6617561938b api[1465]: UPDATE "service instance"
Jun 17 15:40:12 d6617561938b api[1465]: SET "last heartbeat" = $1
Jun 17 15:40:12 d6617561938b api[1465]: WHERE "service instance"."id" = $2 [ 2020-06-17T15:40:12.635Z, 2 ]
Jun 17 15:40:22 d6617561938b api[1465]: Parsing PATCH /resin/service_instance(2)
Jun 17 15:40:22 d6617561938b api[1465]: Running PATCH /resin/service_instance(2)
Jun 17 15:40:22 d6617561938b api[1465]: UPDATE "service instance"
Jun 17 15:40:22 d6617561938b api[1465]: SET "last heartbeat" = $1
Jun 17 15:40:22 d6617561938b api[1465]: WHERE "service instance"."id" = $2 [ 2020-06-17T15:40:22.665Z, 2 ]
Jun 17 15:40:28 d6617561938b api[1465]: Parsing GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:28 d6617561938b api[1465]: Running GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:28 d6617561938b api[1465]: SELECT "user"."actor", "user"."jwt secret" AS "jwt_secret"
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "user"."id" = $1 [ 2 ]
Jun 17 15:40:28 d6617561938b api[1465]: Parsing GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:28 d6617561938b api[1465]: Parsing GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:28 d6617561938b api[1465]: Running GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:28 d6617561938b api[1465]: SELECT "permission"."name"
Jun 17 15:40:28 d6617561938b api[1465]: FROM "permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE (EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user-has-permission" AS "permission.user-has-permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission"."id" = "permission.user-has-permission"."permission"
Jun 17 15:40:28 d6617561938b api[1465]: AND "permission.user-has-permission"."user" = $1
Jun 17 15:40:28 d6617561938b api[1465]: AND ("permission.user-has-permission"."expiry date" IS NULL
Jun 17 15:40:28 d6617561938b api[1465]: OR "permission.user-has-permission"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: OR EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "role-has-permission" AS "permission.role-has-permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission"."id" = "permission.role-has-permission"."permission"
Jun 17 15:40:28 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "role" AS "permission.role-has-permission.role"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission.role-has-permission"."role" = "permission.role-has-permission.role"."id"
Jun 17 15:40:28 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user-has-role" AS "permission.role-has-permission.role.user-has-role"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission.role-has-permission.role"."id" = "permission.role-has-permission.role.user-has-role"."role"
Jun 17 15:40:28 d6617561938b api[1465]: AND "permission.role-has-permission.role.user-has-role"."user" = $1
Jun 17 15:40:28 d6617561938b api[1465]: AND ("permission.role-has-permission.role.user-has-role"."expiry date" IS NULL
Jun 17 15:40:28 d6617561938b api[1465]: OR "permission.role-has-permission.role.user-has-role"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: ))
Jun 17 15:40:28 d6617561938b api[1465]: ORDER BY "permission"."name" ASC [ 2 ]
Jun 17 15:40:28 d6617561938b api[1465]: Running GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:28 d6617561938b api[1465]: SELECT "user"."actor", "user"."jwt secret" AS "jwt_secret"
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "user"."id" = $1 [ 2 ]
Jun 17 15:40:28 d6617561938b api[1465]: Parsing GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:28 d6617561938b api[1465]: Running GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:28 d6617561938b api[1465]: SELECT "permission"."name"
Jun 17 15:40:28 d6617561938b api[1465]: FROM "permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE (EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user-has-permission" AS "permission.user-has-permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission"."id" = "permission.user-has-permission"."permission"
Jun 17 15:40:28 d6617561938b api[1465]: AND "permission.user-has-permission"."user" = $1
Jun 17 15:40:28 d6617561938b api[1465]: AND ("permission.user-has-permission"."expiry date" IS NULL
Jun 17 15:40:28 d6617561938b api[1465]: OR "permission.user-has-permission"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: OR EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "role-has-permission" AS "permission.role-has-permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission"."id" = "permission.role-has-permission"."permission"
Jun 17 15:40:28 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "role" AS "permission.role-has-permission.role"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission.role-has-permission"."role" = "permission.role-has-permission.role"."id"
Jun 17 15:40:28 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user-has-role" AS "permission.role-has-permission.role.user-has-role"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission.role-has-permission.role"."id" = "permission.role-has-permission.role.user-has-role"."role"
Jun 17 15:40:28 d6617561938b api[1465]: AND "permission.role-has-permission.role.user-has-role"."user" = $1
Jun 17 15:40:28 d6617561938b api[1465]: AND ("permission.role-has-permission.role.user-has-role"."expiry date" IS NULL
Jun 17 15:40:28 d6617561938b api[1465]: OR "permission.role-has-permission.role.user-has-role"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: ))
Jun 17 15:40:28 d6617561938b api[1465]: ORDER BY "permission"."name" ASC [ 2 ]
Jun 17 15:40:28 d6617561938b api[1465]: Parsing GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:28 d6617561938b api[1465]: Running GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:28 d6617561938b api[1465]: SELECT "user"."actor", "user"."jwt secret" AS "jwt_secret"
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "user"."id" = $1 [ 2 ]
Jun 17 15:40:28 d6617561938b api[1465]: Parsing GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:28 d6617561938b api[1465]: Running GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:28 d6617561938b api[1465]: SELECT "permission"."name"
Jun 17 15:40:28 d6617561938b api[1465]: FROM "permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE (EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user-has-permission" AS "permission.user-has-permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission"."id" = "permission.user-has-permission"."permission"
Jun 17 15:40:28 d6617561938b api[1465]: AND "permission.user-has-permission"."user" = $1
Jun 17 15:40:28 d6617561938b api[1465]: AND ("permission.user-has-permission"."expiry date" IS NULL
Jun 17 15:40:28 d6617561938b api[1465]: OR "permission.user-has-permission"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: OR EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "role-has-permission" AS "permission.role-has-permission"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission"."id" = "permission.role-has-permission"."permission"
Jun 17 15:40:28 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "role" AS "permission.role-has-permission.role"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission.role-has-permission"."role" = "permission.role-has-permission.role"."id"
Jun 17 15:40:28 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:28 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:28 d6617561938b api[1465]: FROM "user-has-role" AS "permission.role-has-permission.role.user-has-role"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE "permission.role-has-permission.role"."id" = "permission.role-has-permission.role.user-has-role"."role"
Jun 17 15:40:28 d6617561938b api[1465]: AND "permission.role-has-permission.role.user-has-role"."user" = $1
Jun 17 15:40:28 d6617561938b api[1465]: AND ("permission.role-has-permission.role.user-has-role"."expiry date" IS NULL
Jun 17 15:40:28 d6617561938b api[1465]: OR "permission.role-has-permission.role.user-has-role"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: )
Jun 17 15:40:28 d6617561938b api[1465]: ))
Jun 17 15:40:28 d6617561938b api[1465]: ORDER BY "permission"."name" ASC [ 2 ]
Jun 17 15:40:28 d6617561938b api[1465]: Parsing GET /resin/application?$filter=(app_name%20eq%20%27test10%27)%20or%20(slug%20eq%20%27test10%27)
Jun 17 15:40:28 d6617561938b api[1465]: Running GET /resin/application?$filter=(app_name%20eq%20%27test10%27)%20or%20(slug%20eq%20%27test10%27)
Jun 17 15:40:28 d6617561938b api[1465]: SELECT "application"."created at" AS "created_at", "application"."id", "application"."actor", "application"."should track latest release" AS "should_track_latest_release", "application"."app name" AS "app_name", "application"."slug", "application"."device type" AS "device_type", "application"."VPN host" AS "VPN_host", "application"."VPN port" AS "VPN_port", "application"."commit", "application"."depends on-application" AS "depends_on__application", "application"."application type" AS "application_type"
Jun 17 15:40:28 d6617561938b api[1465]: FROM "application"
Jun 17 15:40:28 d6617561938b api[1465]: WHERE ("application"."app name" = $1
Jun 17 15:40:28 d6617561938b api[1465]: OR "application"."slug" = $2) [ 'test10', 'test10' ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "user"."actor", "user"."jwt secret" AS "jwt_secret"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "user"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "user"."id" = $1 [ 2 ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "permission"."name"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "permission"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE (EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "user-has-permission" AS "permission.user-has-permission"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission"."id" = "permission.user-has-permission"."permission"
Jun 17 15:40:29 d6617561938b api[1465]: AND "permission.user-has-permission"."user" = $1
Jun 17 15:40:29 d6617561938b api[1465]: AND ("permission.user-has-permission"."expiry date" IS NULL
Jun 17 15:40:29 d6617561938b api[1465]: OR "permission.user-has-permission"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:29 d6617561938b api[1465]: )
Jun 17 15:40:29 d6617561938b api[1465]: OR EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "role-has-permission" AS "permission.role-has-permission"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission"."id" = "permission.role-has-permission"."permission"
Jun 17 15:40:29 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "role" AS "permission.role-has-permission.role"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission.role-has-permission"."role" = "permission.role-has-permission.role"."id"
Jun 17 15:40:29 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "user-has-role" AS "permission.role-has-permission.role.user-has-role"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission.role-has-permission.role"."id" = "permission.role-has-permission.role.user-has-role"."role"
Jun 17 15:40:29 d6617561938b api[1465]: AND "permission.role-has-permission.role.user-has-role"."user" = $1
Jun 17 15:40:29 d6617561938b api[1465]: AND ("permission.role-has-permission.role.user-has-role"."expiry date" IS NULL
Jun 17 15:40:29 d6617561938b api[1465]: OR "permission.role-has-permission.role.user-has-role"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:29 d6617561938b api[1465]: )
Jun 17 15:40:29 d6617561938b api[1465]: )
Jun 17 15:40:29 d6617561938b api[1465]: ))
Jun 17 15:40:29 d6617561938b api[1465]: ORDER BY "permission"."name" ASC [ 2 ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /resin/application?$filter=(app_name%20eq%20%27test10%27)%20or%20(slug%20eq%20%27test10%27)&$select=id
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /resin/application?$filter=(app_name%20eq%20%27test10%27)%20or%20(slug%20eq%20%27test10%27)&$select=id
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "application"."id"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "application"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE ("application"."app name" = $1
Jun 17 15:40:29 d6617561938b api[1465]: OR "application"."slug" = $2) [ 'test10', 'test10' ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "user"."actor", "user"."jwt secret" AS "jwt_secret"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "user"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "user"."id" = $1 [ 2 ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "permission"."name"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "permission"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE (EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "user-has-permission" AS "permission.user-has-permission"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission"."id" = "permission.user-has-permission"."permission"
Jun 17 15:40:29 d6617561938b api[1465]: AND "permission.user-has-permission"."user" = $1
Jun 17 15:40:29 d6617561938b api[1465]: AND ("permission.user-has-permission"."expiry date" IS NULL
Jun 17 15:40:29 d6617561938b api[1465]: OR "permission.user-has-permission"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:29 d6617561938b api[1465]: )
Jun 17 15:40:29 d6617561938b api[1465]: OR EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "role-has-permission" AS "permission.role-has-permission"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission"."id" = "permission.role-has-permission"."permission"
Jun 17 15:40:29 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "role" AS "permission.role-has-permission.role"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission.role-has-permission"."role" = "permission.role-has-permission.role"."id"
Jun 17 15:40:29 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:29 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:29 d6617561938b api[1465]: FROM "user-has-role" AS "permission.role-has-permission.role.user-has-role"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "permission.role-has-permission.role"."id" = "permission.role-has-permission.role.user-has-role"."role"
Jun 17 15:40:29 d6617561938b api[1465]: AND "permission.role-has-permission.role.user-has-role"."user" = $1
Jun 17 15:40:29 d6617561938b api[1465]: AND ("permission.role-has-permission.role.user-has-role"."expiry date" IS NULL
Jun 17 15:40:29 d6617561938b api[1465]: OR "permission.role-has-permission.role.user-has-role"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:29 d6617561938b api[1465]: )
Jun 17 15:40:29 d6617561938b api[1465]: )
Jun 17 15:40:29 d6617561938b api[1465]: ))
Jun 17 15:40:29 d6617561938b api[1465]: ORDER BY "permission"."name" ASC [ 2 ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /resin/application(3)?$select=id,app_name,device_type
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /resin/application(3)?$select=id,app_name,device_type
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "application"."id", "application"."app name" AS "app_name", "application"."device type" AS "device_type"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "application"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "application"."id" = $1 [ 3 ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /resin/application(3)?$select=actor
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /resin/application(3)?$select=actor
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "application"."actor"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "application"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "application"."id" = $1 [ 3 ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing POST /resin/application(3)/canAccess
Jun 17 15:40:29 d6617561938b api[1465]: Running POST /resin/application(3)/canAccess
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "application"."id"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "application"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "application"."id" = $1
Jun 17 15:40:29 d6617561938b api[1465]: LIMIT 1 [ 3 ]
Jun 17 15:40:29 d6617561938b api[1465]: Parsing POST /Auth/api_key?returnResource=false
Jun 17 15:40:29 d6617561938b api[1465]: Parsing GET /Auth/role?$select=id&$filter=name eq 'provisioning-api-key'
Jun 17 15:40:29 d6617561938b api[1465]: Running POST /Auth/api_key?returnResource=false
Jun 17 15:40:29 d6617561938b api[1465]: Running GET /Auth/role?$select=id&$filter=name eq 'provisioning-api-key'
Jun 17 15:40:29 d6617561938b api[1465]: INSERT INTO "api key" ("key", "is of-actor")
Jun 17 15:40:29 d6617561938b api[1465]: VALUES ($1, $2) [ 'EChhH8iwXHzcrxux2GYtldcRI5wz4uKf', 5 ]
Jun 17 15:40:29 d6617561938b api[1465]: SELECT "role"."id"
Jun 17 15:40:29 d6617561938b api[1465]: FROM "role"
Jun 17 15:40:29 d6617561938b api[1465]: WHERE "role"."name" = $1 [ 'provisioning-api-key' ]
Jun 17 15:40:29 d6617561938b api[1465]: Insert ID: api_key 17
Jun 17 15:40:29 d6617561938b api[1465]: Parsing POST /Auth/api_key__has__role?returnResource=false
Jun 17 15:40:29 d6617561938b api[1465]: Running POST /Auth/api_key__has__role?returnResource=false
Jun 17 15:40:29 d6617561938b api[1465]: INSERT INTO "api key-has-role" ("api key", "role")
Jun 17 15:40:29 d6617561938b api[1465]: VALUES ($1, $2) [ 17, 1 ]
Jun 17 15:40:29 d6617561938b api[1465]: Insert ID: api_key__has__role 17
Jun 17 15:40:30 d6617561938b api[1465]: Parsing GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:30 d6617561938b api[1465]: Running GET /resin/user(2)?$select=actor,jwt_secret
Jun 17 15:40:30 d6617561938b api[1465]: SELECT "user"."actor", "user"."jwt secret" AS "jwt_secret"
Jun 17 15:40:30 d6617561938b api[1465]: FROM "user"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "user"."id" = $1 [ 2 ]
Jun 17 15:40:30 d6617561938b api[1465]: Parsing GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:30 d6617561938b api[1465]: Running GET /Auth/permission?$select=name&$filter=(is_of__user/any(uhp:(uhp/user eq @userId) and ((uhp/expiry_date eq null) or (uhp/expiry_date gt now())))) or (is_of__role/any(rhp:rhp/role/any(r:r/is_of__user/any(uhr:(uhr/user eq @userId) and ((uhr/expiry_date eq null) or (uhr/expiry_date gt now()))))))&$orderby=name asc&@userId=2
Jun 17 15:40:30 d6617561938b api[1465]: SELECT "permission"."name"
Jun 17 15:40:30 d6617561938b api[1465]: FROM "permission"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE (EXISTS (
Jun 17 15:40:30 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:30 d6617561938b api[1465]: FROM "user-has-permission" AS "permission.user-has-permission"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "permission"."id" = "permission.user-has-permission"."permission"
Jun 17 15:40:30 d6617561938b api[1465]: AND "permission.user-has-permission"."user" = $1
Jun 17 15:40:30 d6617561938b api[1465]: AND ("permission.user-has-permission"."expiry date" IS NULL
Jun 17 15:40:30 d6617561938b api[1465]: OR "permission.user-has-permission"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:30 d6617561938b api[1465]: )
Jun 17 15:40:30 d6617561938b api[1465]: OR EXISTS (
Jun 17 15:40:30 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:30 d6617561938b api[1465]: FROM "role-has-permission" AS "permission.role-has-permission"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "permission"."id" = "permission.role-has-permission"."permission"
Jun 17 15:40:30 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:30 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:30 d6617561938b api[1465]: FROM "role" AS "permission.role-has-permission.role"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "permission.role-has-permission"."role" = "permission.role-has-permission.role"."id"
Jun 17 15:40:30 d6617561938b api[1465]: AND EXISTS (
Jun 17 15:40:30 d6617561938b api[1465]: SELECT 1
Jun 17 15:40:30 d6617561938b api[1465]: FROM "user-has-role" AS "permission.role-has-permission.role.user-has-role"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "permission.role-has-permission.role"."id" = "permission.role-has-permission.role.user-has-role"."role"
Jun 17 15:40:30 d6617561938b api[1465]: AND "permission.role-has-permission.role.user-has-role"."user" = $1
Jun 17 15:40:30 d6617561938b api[1465]: AND ("permission.role-has-permission.role.user-has-role"."expiry date" IS NULL
Jun 17 15:40:30 d6617561938b api[1465]: OR "permission.role-has-permission.role.user-has-role"."expiry date" > CURRENT_TIMESTAMP)
Jun 17 15:40:30 d6617561938b api[1465]: )
Jun 17 15:40:30 d6617561938b api[1465]: )
Jun 17 15:40:30 d6617561938b api[1465]: ))
Jun 17 15:40:30 d6617561938b api[1465]: ORDER BY "permission"."name" ASC [ 2 ]
Jun 17 15:40:30 d6617561938b api[1465]: Parsing GET /resin/application(3)?$select=actor
Jun 17 15:40:30 d6617561938b api[1465]: Running GET /resin/application(3)?$select=actor
Jun 17 15:40:30 d6617561938b api[1465]: SELECT "application"."actor"
Jun 17 15:40:30 d6617561938b api[1465]: FROM "application"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "application"."id" = $1 [ 3 ]
Jun 17 15:40:30 d6617561938b api[1465]: Parsing POST /resin/application(3)/canAccess
Jun 17 15:40:30 d6617561938b api[1465]: Running POST /resin/application(3)/canAccess
Jun 17 15:40:30 d6617561938b api[1465]: SELECT "application"."id"
Jun 17 15:40:30 d6617561938b api[1465]: FROM "application"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "application"."id" = $1
Jun 17 15:40:30 d6617561938b api[1465]: LIMIT 1 [ 3 ]
Jun 17 15:40:30 d6617561938b api[1465]: Parsing POST /Auth/api_key?returnResource=false
Jun 17 15:40:30 d6617561938b api[1465]: Parsing GET /Auth/role?$select=id&$filter=name eq 'provisioning-api-key'
Jun 17 15:40:30 d6617561938b api[1465]: Running POST /Auth/api_key?returnResource=false
Jun 17 15:40:30 d6617561938b api[1465]: Running GET /Auth/role?$select=id&$filter=name eq 'provisioning-api-key'
Jun 17 15:40:30 d6617561938b api[1465]: INSERT INTO "api key" ("key", "is of-actor")
Jun 17 15:40:30 d6617561938b api[1465]: VALUES ($1, $2) [ 'p9mrepDmkWcfYRQ5cCumwfzqexmCWIEN', 5 ]
Jun 17 15:40:30 d6617561938b api[1465]: SELECT "role"."id"
Jun 17 15:40:30 d6617561938b api[1465]: FROM "role"
Jun 17 15:40:30 d6617561938b api[1465]: WHERE "role"."name" = $1 [ 'provisioning-api-key' ]
Jun 17 15:40:30 d6617561938b api[1465]: Insert ID: api_key 18
Jun 17 15:40:30 d6617561938b api[1465]: Parsing POST /Auth/api_key__has__role?returnResource=false
Jun 17 15:40:30 d6617561938b api[1465]: Running POST /Auth/api_key__has__role?returnResource=false
Jun 17 15:40:30 d6617561938b api[1465]: INSERT INTO "api key-has-role" ("api key", "role")
Jun 17 15:40:30 d6617561938b api[1465]: VALUES ($1, $2) [ 18, 1 ]
Jun 17 15:40:30 d6617561938b api[1465]: Insert ID: api_key__has__role 18