14 Commits

Author SHA1 Message Date
bf4c0dbbbd feat: apikey alias/renewal + markdown/patch authorship
- APIKey.alias (unique, required). Creating with an existing alias
  renews that key: same key string kept, validity reset to 15d,
  reactivated, name/roles updated (response has renewed=true).
- get_actor(): X-API-Key -> key alias, Bearer -> 'admin'.
- markdown & patch create/update record author / created_at /
  updated_at / last_modified_by from the actor.
- Idempotent run_migrations() (information_schema-guarded ALTERs +
  backfill) so existing tables/data gain the new columns on startup;
  create_all still covers fresh DBs.

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-16 22:51:40 +01:00
58f23ddcb8 Security hardening: fix RCE, auth and SSRF issues
Critical:
- backup: prevent Zip Slip path traversal and zip bombs in restore/convert
  via safe_extract(); serialize get_backup() with backup_lock and always
  restore CWD so concurrent requests can't corrupt the os.chdir state
- app: only enable the Werkzeug debugger/reloader when ENVIRONMENT=dev;
  always init rate limits (also under WSGI), not just under __main__
- apikey: fix create_key never committing (session.commit -> commit()),
  validate roles against an allowlist, and fix revoke_key/update_last_used
  operating on detached instances so revocation actually persists
- env_provider: redact DB_PASSWORD and SESSION_SECRET_KEY in summerize()

High:
- markdown: filter private/protected docs for non-admins in the listing,
  get_home, get_index and search endpoints (was an anonymous data leak);
  escape LIKE metacharacters and cap search results
- webhooks: validate target URL to block SSRF (loopback/private/link-local/
  metadata IPs), disable redirects, safely parse additional_header
- auth: validate JWT issuer and require exp/iat; add timeout to JWKS fetch;
  harden Authorization header parsing against malformed values
- log: require admin for GET /api/log and auth for POST; bound entry size

Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
2026-05-16 16:12:43 +01:00
1a160c9415 add: backend api auth by apikey/apikey gen/apikey revoke 2025-05-06 18:54:10 +01:00
35c8934963 add: markdown permission setting
improve: template
2025-04-25 00:39:01 +01:00
fa855bc7bb add: template editor 2025-04-14 17:02:22 +01:00
864b78641b add: webhook 2025-03-17 13:54:53 +00:00
038efb745a add: etag support 2024-12-09 08:00:25 +00:00
eaa2350b72 add: api for rate control 2024-12-06 16:12:44 +00:00
48dd59f8e4 kc token public key/token issue, path root set to 1 2024-12-06 10:04:03 +00:00
178219f097 read configs from env 2024-12-05 13:39:08 +00:00
9d0fd5b33c config for oauth 2024-12-04 14:06:30 +00:00
e929f67f4e api limiter & auto bp register 2024-12-03 11:28:40 +00:00
a93bd5d870 resource impl 2024-12-03 00:10:47 +00:00
83c5662fcb api impl 2024-12-02 18:33:39 +00:00