Files
Homelab-manager/server/drizzle/0058_flippant_sasquatch.sql
bobbanandClaude Sonnet 5.5 aebe98bf15 Authentik: know when the front door is about to shut
New Authentik integration (read-only, every 5 minutes): version, workers,
outposts and their health, certificates and API tokens that expire, failed
sign-ins and configuration errors. Monitoring -> Authentik page.

Alerts: an outpost that serves apps has gone quiet (critical), certificate or
token about to run out (critical close to it), no worker, failed sign-ins,
configuration errors. Held by maintenance, held when unreadable, in /metrics.

Co-Authored-By: Claude Sonnet 5.5 <noreply@anthropic.com>
2026-10-24 22:09:38 +02:00

16 lines
529 B
SQL

CREATE TABLE `authentik_state` (
`integration_id` integer PRIMARY KEY NOT NULL,
`version` text,
`latest_version` text,
`outdated` integer DEFAULT false NOT NULL,
`workers` integer,
`outposts` text DEFAULT '[]' NOT NULL,
`certificates` text DEFAULT '[]' NOT NULL,
`tokens` text DEFAULT '[]' NOT NULL,
`failed_logins_24h` integer,
`config_errors_24h` integer,
`last_config_error` text,
`updated_at` text NOT NULL,
FOREIGN KEY (`integration_id`) REFERENCES `integrations`(`id`) ON UPDATE no action ON DELETE cascade
);