Files
warmbly/internal/models/credentials.go
Matthew Meszaros 261cc439ad feat(admin): manage worker fleet from dashboard with encrypted credentials and GitHub release auto-update
Workers are no longer curl|sh-only. Admins add and manage them from the
dashboard over SSH, with all runtime config (Kafka, Schema Registry,
Redis, AWS keys) stored encrypted via the existing KMS-envelope cipher
service.

Worker lifecycle:
  1. Admin POSTs host/port/user. Backend generates an ed25519 keypair,
     encrypts the private key under uuid.Nil (platform identity), and
     stores the row in 'pending' state.
  2. Admin pastes the returned public key into the VPS's authorized_keys.
  3. Test connection — runs `true` over SSH, pins the host SHA256
     fingerprint on first success (TOFU).
  4. Install — backend scp's install-worker.sh + a per-worker env file
     and runs it. State moves pending → provisioning → installed.
  5. From then on: restart, update image, apply config, uninstall,
     rotate keys, tail logs, live status, OS package update, reboot —
     all dashboard buttons backed by SSH operations.

Credentials are reusable entities:
  - aws_credentials: named keypair, secret encrypted at rest
  - worker_profiles: bundles Kafka + Schema Registry + Redis + image +
    release channel, references one AWS credentials row
  - workers.profile_id links a worker to a profile; many workers can
    share one profile

Saving a profile doesn't restart anything. The dashboard compares
profile.updated_at to each worker's config_applied_at and shows a
"stale config" badge; Apply rewrites /etc/warmbly/worker.env over SSH
and restarts the unit.

Auto-update on GitHub release:
  - profile.release_channel ∈ {pinned, stable, dev}
  - profile.auto_update toggles automatic rollout
  - Trigger model is push, not poll: one check on backend boot, then
    the /webhooks/github/releases endpoint (HMAC-validated with
    RELEASES_WEBHOOK_SECRET) on every release event. Manual "Check now"
    button as fallback.
  - When a new tag resolves, the orchestrator SSHes into each assigned
    worker, runs install-worker.sh --update --image <new>, which now
    rewrites the systemd unit (not just `docker pull`) so the image
    actually changes. workers.image_version captures the running tag
    for the UI's "v1.2.3 → v1.2.4" diff.

Self-hostable: every release knob is env-driven —
RELEASES_GITHUB_REPO, RELEASES_WORKER_IMAGE_REPO,
RELEASES_WEBHOOK_SECRET, RELEASES_GITHUB_TOKEN, RELEASES_ENABLED. Set
RELEASES_ENABLED=false to disable the feature entirely.

OS-level updates and reboot are also exposed: detect apt / dnf / yum /
pacman / apk, run the right upgrade noninteractively, return the full
output and a reboot-required flag. Reboots are never automatic.

Migrations:
  000028_worker_ssh        — ssh fields, install_state enum, last_seen,
                              host fingerprint
  000029_worker_credentials — aws_credentials + worker_profiles +
                              workers.profile_id + workers.config_applied_at
  000030_worker_releases   — release_channel enum, auto_update,
                              resolved_image_tag, workers.image_version

Endpoints added:
  POST   /admin/workers                        (create + keypair)
  GET    /admin/workers/managed
  GET    /admin/workers/:id/managed
  POST   /admin/workers/:id/{test,install,restart,upgrade,uninstall,rotate-keys,apply,system-update,reboot}
  PUT    /admin/workers/:id/profile
  GET    /admin/workers/:id/{live-status,logs}
  DELETE /admin/workers/:id
  GET    /admin/aws-credentials                CRUD
  GET    /admin/worker-profiles                CRUD + /workers + /apply + /release
  GET    /admin/releases/state
  POST   /admin/releases/check
  POST   /webhooks/github/releases             public, HMAC-validated

Admin UI:
  /app/admin/workers           list with status + version columns
  /app/admin/workers/new       add form with profile dropdown
  /app/admin/workers/:id       detail with all actions + logs + system update
  /app/admin/credentials       tabs: AWS credentials + worker profiles,
                                Releases panel, channel selector +
                                auto-update toggle in profile form
2026-05-18 13:09:11 +00:00

72 lines
2.3 KiB
Go

package models
import (
"time"
"github.com/google/uuid"
)
// AWSCredentials is a named, reusable AWS keypair that one or more worker
// profiles can point at. The secret access key is stored encrypted; this
// struct never carries plaintext beyond the orchestrator's in-memory render.
type AWSCredentials struct {
ID uuid.UUID `json:"id"`
Name string `json:"name"`
Description string `json:"description"`
Region string `json:"region"`
AccessKeyID string `json:"access_key_id"`
// Hidden from JSON: this is ciphertext meant for the cipher service.
SecretAccessKeyEncrypted string `json:"-"`
// HasSecret is the dashboard-friendly signal that a secret is set,
// without leaking the value. UI shows "••••••" when true.
HasSecret bool `json:"has_secret"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
// WorkerProfile bundles everything a worker container needs at runtime
// besides its own identity. Many workers can share one profile.
type WorkerProfile struct {
ID uuid.UUID `json:"id"`
Name string `json:"name"`
Description string `json:"description"`
AppEnv string `json:"app_env"`
WorkerImage string `json:"worker_image"`
KafkaBootstrapServers string `json:"kafka_bootstrap_servers"`
KafkaSASLUsername string `json:"kafka_sasl_username"`
KafkaSASLPasswordEnc string `json:"-"`
HasKafkaPassword bool `json:"has_kafka_password"`
SchemaRegistryURL string `json:"schema_registry_url"`
SchemaRegistryKey string `json:"schema_registry_key"`
SchemaRegistrySecEnc string `json:"-"`
HasSchemaSecret bool `json:"has_schema_secret"`
RedisURLEnc string `json:"-"`
HasRedisURL bool `json:"has_redis_url"`
AWSCredentialID *uuid.UUID `json:"aws_credential_id,omitempty"`
// Release tracking
ReleaseChannel ReleaseChannel `json:"release_channel"`
AutoUpdate bool `json:"auto_update"`
ResolvedImageTag string `json:"resolved_image_tag"`
LastReleaseCheckAt *time.Time `json:"last_release_check_at,omitempty"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
type ReleaseChannel string
const (
ReleaseChannelPinned ReleaseChannel = "pinned"
ReleaseChannelStable ReleaseChannel = "stable"
ReleaseChannelDev ReleaseChannel = "dev"
)