Merge pull request 'fix(manifest): provenRestore=true (restore-drill 2026-09-29)' (#521) from fix/prod-restore-2026-09-29 into main

tests/siax-access/idempotency.test.ts hade fyra @typescript-eslint/no-explicit-any
vilket fick quality-jobbet att exita 1 (133 testfiler gröna men lint röd) och
därmed blockerade alla PR:er. Använder exporterade IdempotencyStore<unknown,
{x:number}>; eslint rent, 7/7 tester gröna.

docs/runbook/legacy-instances-20261107.md

@@ -0,0 +1,47 @@
+# Legacy instance audit — 0pt (server5) and L0RE (server5) — 2026-11-07
+
+Canonical runtimes: **0pt on server6** (Coolify app `shxd6lepxuxfsjsp0ath3z1g`,
+`0pt.app`) and **L0RE on server9** (`l0re.siax.io`). This document records the
+older instances on server5 and their disposition. It is not production
+documentation for either product.
+
+## 1. 0pt legacy (server5)
+
+| Item | Value |
+|---|---|
+| Containers | `0pt-api` (`0pt-api:c46ebbf`, created 2026-11-05), `0pt-web` (`:18080`) |
+| Database | `0pt-pg`, user/db `opt`, 11 MB |
+| Exposure | `0pt-web` only on `100.124.7.55:18080`; no DNS record, no reverse proxy |
+| Consumers | none found (`/etc/siax`, `/opt/siax`, site0 and L0RE deploy configs) |
+| Unique data | 32 canonical facts (30 GLEIF web observations + `body_type` YDL405 + `passmark.find_prime_numbers.v10`) |
+
+**Data reconciliation:** all 32 facts were exported and re-imported through the
+canonical API (`POST /api/0pt/canonical/facts`) into the server6 deployment.
+Replay returned `duplicates: 32`, so the import is idempotent. Production now
+holds 34 facts (32 migrated + 2 verification observations) and 4 entities.
+
+**Backup:** `server5:/var/backups/0pt-legacy/opt_legacy_20261107.dump.zst`
+(custom format, 32 KB) + offsite `server11:/home/backup/0pt/`.
+
+**Action taken:** `docker update --restart=no` + `docker stop` for `0pt-api` and
+`0pt-web`. `0pt-pg` left running for forensics/rollback. `0pt.app` verified 200
+after the stop (served by server6).
+
+**Full removal (requires owner decision):** snapshot/destroy `0pt-pg` volume
+after the retention window, remove the legacy compose project, revoke the old
+`INTERNAL_TOKEN` if it was ever stored on server5.
+
+## 2. L0RE orphan (server5)
+
+Documented separately in `admin/l0re` PR #485
+(`docs/runbook/l0re-orphan-decommission-20261107.md`): API stopped with
+`restart=no`, dump + restore proof (8 propositions/62 assertions), no unique
+legitimate data (pilot facts already re-projected to production). `l0re-pg` and
+`l0re-opensearch` remain for forensics.
+
+## 3. Single-runtime rule
+
+One primary runtime per logical service. A container image of a product running
+outside its registered Coolify app is a finding, not a fallback. Both server5
+instances were reachable only from the host, which is why the split survived
+until this audit.

docs/runbook/workload-identity-0pt.md

@@ -0,0 +1,78 @@
+# 0pt workload identity — målbild, nuläge och övergång
+
+Status: **design klar, provisionering blockerad** (2026-11-07).
+Ägare: CL0UD (identitet) / 0pt (konsument).
+
+## 1. Nuläge
+
+0pt autentiserar maskin-till-maskin med en **delad hemlighet**:
+
+- `X-Internal-Token` mot `INTERNAL_TOKEN` (samma värde i engine och edge).
+- Tenant-auktoritet kommer från serverkonfigurationen `INTERNAL_SERVICE_TENANTS`
+  (se `src/auth/internal-service-tenant.ts`), aldrig från en klientheader.
+- Tom allowlist ⇒ ingen tenant-auktoritet ⇒ tenant-scopade skrivningar 403.
+
+Det här är säkert men grovkornigt: en enda hemlighet representerar hela
+engine-processen, och varje ny konsument kräver en manuell allowlist-post.
+
+## 2. Målbild (CL0UD workload identity)
+
+CL0UD äger redan maskineriet:
+
+- `POST /account/service-accounts` skapar en service account (identitet).
+- `POST /account/service-accounts/{id}/workload-token` mints en **kortlivad**
+  (10 min default, 1 h max) workload-token vars `capabilities` är en delmängd av
+  service accountens `platform.cl0ud_service_account_scopes.allowedCapabilities`.
+- `@siax/platform-core` `auth/workload.ts` är verifieringsadaptern; publika
+  nycklar via JWKS.
+- `packages/capability-registry/src/workload-identities.ts` deklarerar
+  arbetsbelastningsnamn och `aud:*`-audiences. Modulen är uttryckligen **inte**
+  provisionerad och **inte** inkopplad i utfärdande eller verifiering än.
+
+För 0pt innebär det:
+
+| Egenskap | Idag | Mål |
+|---|---|---|
+| Credential | delad `INTERNAL_TOKEN` | CL0UD-workload-token, `aud:0pt`, 10 min |
+| Tenant | serverkonfigurerad allowlist | `tenant_id`-claim i verifierad token |
+| Capabilities | route-lista i middleware | `capabilities`-claim (t.ex. `0pt.canonical.write`) |
+| Rotation | manuell | automatisk (kortlivad token) |
+| Spårbarhet | delad hemlighet | per-arbetsbelastning (`0pt-engine`, `site0-pipeline`) |
+
+## 3. Integrationsdesign (när provisionering är möjlig)
+
+1. **Verifiering före route-logik.** Middleware accepterar
+   `Authorization: Bearer <workload-token>` för `INTERNAL_SERVICE_ROUTES` om
+   signaturen verifieras mot CL0UD JWKS, `aud` innehåller `0pt` och `exp` är
+   giltig. Ingen klientheader får bidra till tenant.
+2. **Tenant från claim, inte från allowlist.** `tenant_id` i den verifierade
+   tokenen sätts som `x-0pt-verified-tenant`; `INTERNAL_SERVICE_TENANTS`
+   används endast för legacy `X-Internal-Token`.
+3. **Capabilities per route.** Route-metadata (`0pt.canonical.write`,
+   `0pt.quality.run`) jämförs med tokenens `capabilities`. Saknad capability ⇒
+   403, inte 401 (identiteten är giltig, behörigheten räcker inte).
+4. **Dual-accept under övergång.** Båda credentialtyperna accepteras tills
+   engine och site0-pipeline mintar workload-tokens; därefter tas
+   `X-Internal-Token` bort i en egen release med negativt test.
+5. **Negativa tester i samma svit som idag**
+   (`tests/auth/internal-token-tenant-scope.test.ts`): fel `aud` ⇒ 401, utgången
+   token ⇒ 401, tenant utanför claim ⇒ 403, saknad capability ⇒ 403.
+
+## 4. Blockerare
+
+- `/account/service-accounts` svarar **307 → /login** utan operator-session;
+  ingen giltig `SIAX_TOKEN` finns i Infisical-miljön.
+- Zitadel admin-PAT (`/opt/siax-access/zitadel-admin-pat`) är invalid
+  (AUTH-7fs1e), så nya machine users kan inte mintas via det flödet.
+- `workload-identities.ts` är deklaration-only: ingen identitet är
+  `provisioned: true`.
+
+Åtgärd kräver en operatörsinloggning i CL0UD-konsolen (eller en ny giltig
+admin-PAT) och är därför **EXTERNALLY_BLOCKED** från agentsidan.
+
+## 5. Vad som inte ska göras
+
+- Ingen egen JWT-signering i 0pt.
+- Ingen parallell identitetsplattform.
+- Ingen klientheader som bär tenant.
+- Ingen långlivad delad hemlighet som "tillfällig" lösning utan slutdatum.

siax.repo.v3.json

@@ -89,7 +89,16 @@
     "0pt.source_registry_list",
     "0pt.order_create",
     "0pt.order_payment",
-    "0pt.write_iceberg_table"
+    "0pt.write_iceberg_table",
+    "0pt.structure.resolve_entities",
+    "0pt.structure.get_lineage",
+    "0pt.structure.quality_run",
+    "0pt.structure.quality_list_runs",
+    "0pt.structure.quality_checks",
+    "0pt.structure.quality_reports",
+    "0pt.structure.extract_document",
+    "0pt.structure.route_parsing",
+    "0pt.structure.normalize_value"
   ],
   "surfaces": [
     "api",

siax/capabilities/0pt.structure.extract_document.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.extract_document",
+  "name": "0pt.structure.extract_document",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L2",
+  "piiLevel": "high",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.extract_document",
+  "description": "Canonical capability descriptor for 0pt.structure.extract_document (owner 0pt). Verified against registry + openapi operationId 0pt.extract_document."
+}

siax/capabilities/0pt.structure.get_lineage.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.get_lineage",
+  "name": "0pt.structure.get_lineage",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L1",
+  "piiLevel": "low",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.get_provenance",
+  "description": "Canonical capability descriptor for 0pt.structure.get_lineage (owner 0pt). Verified against registry + openapi operationId 0pt.get_provenance."
+}

siax/capabilities/0pt.structure.normalize_value.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.normalize_value",
+  "name": "0pt.structure.normalize_value",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L1",
+  "piiLevel": "low",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.normalize_value",
+  "description": "Canonical capability descriptor for 0pt.structure.normalize_value (owner 0pt). Verified against registry + openapi operationId 0pt.normalize_value."
+}

siax/capabilities/0pt.structure.quality_checks.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.quality_checks",
+  "name": "0pt.structure.quality_checks",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L1",
+  "piiLevel": "low",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.quality.checks",
+  "description": "Canonical capability descriptor for 0pt.structure.quality_checks (owner 0pt). Verified against registry + openapi operationId 0pt.quality.checks."
+}

siax/capabilities/0pt.structure.quality_list_runs.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.quality_list_runs",
+  "name": "0pt.structure.quality_list_runs",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L1",
+  "piiLevel": "low",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.quality.list_runs",
+  "description": "Canonical capability descriptor for 0pt.structure.quality_list_runs (owner 0pt). Verified against registry + openapi operationId 0pt.quality.list_runs."
+}

siax/capabilities/0pt.structure.quality_reports.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.quality_reports",
+  "name": "0pt.structure.quality_reports",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L1",
+  "piiLevel": "low",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.quality.reports",
+  "description": "Canonical capability descriptor for 0pt.structure.quality_reports (owner 0pt). Verified against registry + openapi operationId 0pt.quality.reports."
+}

siax/capabilities/0pt.structure.quality_run.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.quality_run",
+  "name": "0pt.structure.quality_run",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L1",
+  "piiLevel": "low",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.quality.run",
+  "description": "Canonical capability descriptor for 0pt.structure.quality_run (owner 0pt). Verified against registry + openapi operationId 0pt.quality.run."
+}

siax/capabilities/0pt.structure.resolve_entities.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.resolve_entities",
+  "name": "0pt.structure.resolve_entities",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L2",
+  "piiLevel": "high",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.resolve_entities",
+  "description": "Canonical capability descriptor for 0pt.structure.resolve_entities (owner 0pt). Verified against registry + openapi operationId 0pt.resolve_entities."
+}

siax/capabilities/0pt.structure.route_parsing.json

@@ -0,0 +1,15 @@
+{
+  "id": "0pt.structure.route_parsing",
+  "name": "0pt.structure.route_parsing",
+  "owner": "0pt",
+  "version": "1.0.0",
+  "riskLevel": "L1",
+  "piiLevel": "low",
+  "surfaces": [
+    "api"
+  ],
+  "requiresJob": false,
+  "tenantScoped": true,
+  "operationId": "0pt.route_parsing",
+  "description": "Canonical capability descriptor for 0pt.structure.route_parsing (owner 0pt). Verified against registry + openapi operationId 0pt.route_parsing."
+}

siax/production-evidence/pe-artifact-0pt-13e156ec7e6b.json

@@ -1,12 +0,0 @@
-{
-  "id": "pe-artifact-0pt-13e156ec7e6b",
-  "repo": "0pt",
-  "evidenceType": "artifact-digest",
-  "result": "pass",
-  "verifiedAt": "2026-11-04T10:53:16Z",
-  "verifiedBy": "docker image inspect RepoDigests (real registry digest)",
-  "proofRef": "docker://server6 image shxd6lepxuxfsjsp0ath3z1g:13e156ec7e6be534de9c28d28ec2daff0355ca7f image@sha256:657bc7e2ed3425436b18680138d7c792ac879db4c49a505d1ea0305699d89089",
-  "sourceSha": "13e156ec7e6be534de9c28d28ec2daff0355ca7f",
-  "digest": "sha256:657bc7e2ed3425436b18680138d7c792ac879db4c49a505d1ea0305699d89089",
-  "tool": "docker"
-}

siax/production-evidence/pe-ci-0pt-13e156ec7e6b.json

@@ -1,10 +0,0 @@
-{
-  "id": "pe-ci-0pt-13e156ec7e6b",
-  "repo": "0pt",
-  "evidenceType": "deploy-log",
-  "result": "pass",
-  "verifiedAt": "2026-11-04T10:53:16Z",
-  "verifiedBy": "Coolify deployment record (application_deployment_queues, status=finished)",
-  "proofRef": "coolify://server6/shxd6lepxuxfsjsp0ath3z1g finished 2026-11-04 05:42:18",
-  "sourceSha": "13e156ec7e6be534de9c28d28ec2daff0355ca7f"
-}

siax/production-evidence/pe-running-0pt-13e156ec7e6b.json

@@ -1,11 +0,0 @@
-{
-  "id": "pe-running-0pt-13e156ec7e6b",
-  "repo": "0pt",
-  "evidenceType": "running-digest",
-  "result": "pass",
-  "verifiedAt": "2026-11-04T10:53:16Z",
-  "verifiedBy": "docker inspect (running container image digest)",
-  "proofRef": "docker://server6 container/shxd6lepxuxfsjsp0ath3z1g-20261104T093337 image@sha256:657bc7e2ed3425436b18680138d7c792ac879db4c49a505d1ea0305699d89089",
-  "sourceSha": "13e156ec7e6be534de9c28d28ec2daff0355ca7f",
-  "digest": "sha256:657bc7e2ed3425436b18680138d7c792ac879db4c49a505d1ea0305699d89089"
-}

siax/production-evidence/pe-sbom-0pt-13e156ec7e6b.json

@@ -1,12 +0,0 @@
-{
-  "id": "pe-sbom-0pt-13e156ec7e6b",
-  "repo": "0pt",
-  "evidenceType": "sbom",
-  "result": "pass",
-  "verifiedAt": "2026-11-04T09:29:06Z",
-  "verifiedBy": "syft (estate-kampanj issue #76, skannad vid deployad commit)",
-  "proofRef": "siax/sbom/sbom-0pt-13e156ec7e6b.json",
-  "sourceSha": "13e156ec7e6be534de9c28d28ec2daff0355ca7f",
-  "tool": "syft",
-  "sbomFormat": "cyclonedx-json"
-}

siax/signing/README.md

@@ -1,4 +1,4 @@
 # 0pt — cosign-signeringskedjan (2026-09-29)
 
-Prod-imagen git.cloud.siax.io/sax3l/0pt:prod-8b5e23aa9b (sha256:889753b7e5a9db3e1c870eeb38f450cb0f20498e1025edb28153233e0b06f46d) är cosign-signerad
+Prod-imagen git.cloud.siax.io/sax3l/0pt:prod-b1ae910d64 (sha256:99de5a0e1672e89e8bc60e89fec68adfb2241d1c8cabad8390eee531241061d6) är cosign-signerad
 med nyckelparet vars pubkey ligger här. Privata nyckeln raderad efter signering.

siax/signing/cosign.pub

@@ -1,4 +1,4 @@
 -----BEGIN PUBLIC KEY-----
-MFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAEiPRG9iG1pjIW548KoIduQPD/B3Yb
-tg5hPmy7o4feVQsdDnW38VtemVBQ4I+goytV9X4XkrFiweKmfqEMhGyPgg==
+MFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAENzI5SFTSfP/rgrc8iBM5pqols2Rv
+BqzG1IzzUzhiIfW0aGKUk4DZjCRO+om40HEYNfIog20wkqe3hidGGUBMaA==
 -----END PUBLIC KEY-----

siax/source-bundles/sb-0pt-13e156ec7e6b.json

@@ -1,10 +0,0 @@
-{
-  "$schema": "https://git.siax.io/sax3l/siax-standard/raw/branch/main/schema/siax.source-bundle.schema.json",
-  "id": "sb-0pt-13e156ec7e6b",
-  "repo": "0pt",
-  "commitSha": "13e156ec7e6be534de9c28d28ec2daff0355ca7f",
-  "branch": "main",
-  "buildId": "coolify:0pt",
-  "producedAt": "2026-11-04T01:26:48Z",
-  "artifactId": "shxd6lepxuxfsjsp0ath3z1g@sha256:657bc7e2ed3425436b18680138d7c792ac879db4c49a505d1ea0305699d89089"
-}

sql/023_canonical_grants.sql

@@ -0,0 +1,19 @@
+-- 023_canonical_grants.sql — app-role privileges for 022 canonical tables.
+--
+-- Tables created by a manual psql migration are owned by the migrating role
+-- (0pt_edge); the running application connects as 0pt_app. Existing 0pt tables
+-- carry explicit grants rather than default ACLs, so the canonical tables need
+-- the same treatment. RLS still applies to 0pt_app (FORCE is on); this only
+-- grants the statement privileges, not row visibility.
+--
+-- Idempotent and role-guarded: no-op in environments without the app role.
+
+DO $$
+BEGIN
+  IF EXISTS (SELECT 1 FROM pg_roles WHERE rolname = '0pt_app') THEN
+    GRANT SELECT, INSERT, UPDATE, DELETE
+      ON opt_canonical_entities, opt_canonical_facts, opt_canonical_relations
+      TO "0pt_app";
+  END IF;
+END
+$$;

src/repositories/canonical-fact-repository.ts

@@ -30,6 +30,11 @@ export interface CanonicalFactRepository {
   queryFacts(query: CanonicalQuery): Promise<CanonicalFact[]>;
 }
 
+/** PostgreSQL timestamptz arrives as Date; the API contract is RFC3339/ISO-8601. */
+function iso(value: unknown): string {
+  return value instanceof Date ? value.toISOString() : String(value);
+}
+
 export function entityKey(e: CanonicalEntityInput): string {
   return `${e.entity_type}\u0000${e.identity_namespace}\u0000${e.identity_value}`;
 }
@@ -216,11 +221,11 @@ class PostgresCanonicalFactRepository implements CanonicalFactRepository {
         source_record_id: r.source_record_id ?? undefined,
         st0re_artifact_id: r.st0re_artifact_id ?? undefined,
         aud0_evidence_ref: r.aud0_evidence_ref ?? undefined, run_ref: r.run_ref ?? undefined,
-        extractor_version: r.extractor_version, observed_at: String(r.observed_at),
-        valid_from: r.valid_from ? String(r.valid_from) : undefined,
-        valid_to: r.valid_to ? String(r.valid_to) : undefined,
+        extractor_version: r.extractor_version, observed_at: iso(r.observed_at),
+        valid_from: r.valid_from ? iso(r.valid_from) : undefined,
+        valid_to: r.valid_to ? iso(r.valid_to) : undefined,
         confidence: r.confidence === null ? undefined : Number(r.confidence),
-        quality_status: r.quality_status, status: r.status, created_at: String(r.created_at),
+        quality_status: r.quality_status, status: r.status, created_at: iso(r.created_at),
       })) as CanonicalFact[];
     });
   }

tests/siax-access/idempotency.test.ts

@@ -1,5 +1,10 @@
 import { describe, expect, it } from "vitest";
-import { operationFingerprint, operationIdentity, runIdempotentOperation } from "../../packages/siax-access/src/idempotency";
+import {
+  operationFingerprint,
+  operationIdentity,
+  runIdempotentOperation,
+  type IdempotencyStore,
+} from "../../packages/siax-access/src/idempotency";
 
 describe("@siax/access universal idempotency", () => {
   it("binds every result-affecting input into the fingerprint", () => {
@@ -18,7 +23,7 @@ describe("@siax/access universal idempotency", () => {
   });
   it("replays a stored receipt verbatim on the exact fingerprint", async () => {
     const stored = { x: 1 };
-    const store: any = {
+    const store: IdempotencyStore<unknown, { x: number }> = {
       start: async () => false,
       save: async () => {},
       receipt: async () => stored,
@@ -32,7 +37,7 @@ describe("@siax/access universal idempotency", () => {
   });
   it("claims once and saves only after the dispatch", async () => {
     const order: string[] = [];
-    const store: any = {
+    const store: IdempotencyStore<unknown, { x: number }> = {
       start: async () => { order.push("start"); return true; },
       save: async () => { order.push("save"); },
       receipt: async () => { order.push("receipt"); return undefined; },
@@ -47,7 +52,7 @@ describe("@siax/access universal idempotency", () => {
     expect(order).toEqual(["start", "dispatch", "save"]);
   });
   it("reports a store error as conflict, never as a fresh start", async () => {
-    const store: any = {
+    const store: IdempotencyStore<unknown, { x: number }> = {
       start: async () => { throw new Error("db down"); },
       save: async () => {},
       receipt: async () => { throw new Error("db down"); },
@@ -61,7 +66,7 @@ describe("@siax/access universal idempotency", () => {
     expect(dispatched).toBe(0);
   });
   it("does not rerun the dispatch when start succeeds but save later fails", async () => {
-    const store: any = { start: async () => true, save: async () => { throw new Error("journal write failed"); }, receipt: async () => undefined };
+    const store: IdempotencyStore<unknown, { x: number }> = { start: async () => true, save: async () => { throw new Error("journal write failed"); }, receipt: async () => undefined };
     let dispatched = 0;
     const outcome = await runIdempotentOperation({
       store, identity: {}, fingerprint: "fp",