diff --git a/10-systems/services/gnexus-creds.md b/10-systems/services/gnexus-creds.md index 7c6b09d..222ae9f 100644 --- a/10-systems/services/gnexus-creds.md +++ b/10-systems/services/gnexus-creds.md @@ -19,11 +19,15 @@ - **Repository**: https://git.gnexus.space/git/root/gnexus-creds.git (branch master) - **Current version**: 543d6ae (2026-10-02, updated by rei; splash on sign-in, logout to internal sign-in without SSO auto-login, extension 0.2.1; previous 3b5a00d: extension 0.2.0 builds on download page; 02a2441: en/uk/ru localization, mobile UX fixes; 4c6a4f7 2026-10-01: PWA shell, biometric reveal gate, ui-kit 1.0) +## Users (verified 2026-10-02) +- Two accounts exist: goldmikki@gmail.com (Eugene Sukhodolskiy, owns ALL secrets) and lnikita2o1o@gmail.com (Popelous, registered 2026-09-18 via SSO, owns 0 secrets, 1 session + 1 encryption key). +- Secrets are per-user (`secrets.user_id` → users, ON DELETE CASCADE); users cannot see each other's secrets. + ## Visibility semantics (important, caused a false "data loss" alarm 2026-10-02) - MCP `search_secrets` returns ONLY secrets with `allow_mcp=true` (by design, commit 2082db2: secrets created via MCP always get allow_mcp=true; secrets created via UI/extension default to allow_mcp=false). - MCP search default limit is 20 (max 50, paginate with offset). - Web UI lists 20 secrets per page with pagination (since commit aae771f, predates 2026-10 updates). -- As of 2026-10-02: 70 secrets total (68 actual + 2 archived), 20 with allow_mcp=true, 48 with allow_mcp=false (mostly personal logins created via extension since May 2026). All owned by goldmikki@gmail.com. Nothing was lost during the 2026-10-01/02 updates: .env byte-identical to pre-update backup, zero app errors, only 2 deletions ever (2026-05-28). +- As of 2026-10-02 (later count): 71 secrets total (69 actual + 2 archived), all owned by goldmikki@gmail.com; 20 actual with allow_mcp=true, 49 with allow_mcp=false (mostly personal logins created via extension since May 2026). Nothing was lost during the 2026-10-01/02 updates: .env byte-identical to pre-update backup, zero app errors, only 2 deletions ever (2026-05-28). ## Audit semantics (verified 2026-10-02, resolved a second false alarm) - Audit events keep a `metadata` snapshot (title, tags, category) forever, including after deletion — deleted secrets remain visible in the audit log under their last known title. Deletion code: `gnexus_creds/services.py` (`audit(..., action="secret.deleted", metadata={"snapshot": ...})`). diff --git a/90-maintenance/pending-changes/20261002120252-58599fa8.json b/90-maintenance/pending-changes/20261002120252-58599fa8.json new file mode 100644 index 0000000..1f8d9ad --- /dev/null +++ b/90-maintenance/pending-changes/20261002120252-58599fa8.json @@ -0,0 +1,19 @@ +{ + "id": "20261002120252-58599fa8", + "kind": "doc", + "target": "10-systems/services/gnexus-creds.md", + "summary": "Add users section (2 accounts, all secrets owned by goldmikki), correct secret counts to 71 (69+2, 20/49 allow_mcp)", + "reason": "Live DB check 2026-10-02: secrets.user_id join shows all 71 secrets owned by goldmikki@gmail.com; second account lnikita2o1o@gmail.com (Popelous, SSO 2026-09-18) owns 0 secrets. Corrected counts: 69 actual + 2 archived, 20/49 allow_mcp split.", + "payload": { + "content": "---\nowner: gmikcon\nstatus: active\nlast_reviewed: 2026-10-02\nreview_interval: 90d\nconfidence: high\nsource_of_truth: deployment-verified\n---\n\n# gnexus-creds\n\nPersonal secret storage service with REST API, MCP HTTP/SSE adapter, and Vue UI.\n\n## Deployment\n- **Host**: [[gnexus-creds-host]] (192.168.1.173)\n- **Method**: Docker Compose\n- **Port**: 80 (External) $\\to$ 8000 (Internal)\n- **Database**: PostgreSQL 17 (Containerized)\n- **Repository**: https://git.gnexus.space/git/root/gnexus-creds.git (branch master)\n- **Current version**: 543d6ae (2026-10-02, updated by rei; splash on sign-in, logout to internal sign-in without SSO auto-login, extension 0.2.1; previous 3b5a00d: extension 0.2.0 builds on download page; 02a2441: en/uk/ru localization, mobile UX fixes; 4c6a4f7 2026-10-01: PWA shell, biometric reveal gate, ui-kit 1.0)\n\n## Users (verified 2026-10-02)\n- Two accounts exist: goldmikki@gmail.com (Eugene Sukhodolskiy, owns ALL secrets) and lnikita2o1o@gmail.com (Popelous, registered 2026-09-18 via SSO, owns 0 secrets, 1 session + 1 encryption key).\n- Secrets are per-user (`secrets.user_id` → users, ON DELETE CASCADE); users cannot see each other's secrets.\n\n## Visibility semantics (important, caused a false \"data loss\" alarm 2026-10-02)\n- MCP `search_secrets` returns ONLY secrets with `allow_mcp=true` (by design, commit 2082db2: secrets created via MCP always get allow_mcp=true; secrets created via UI/extension default to allow_mcp=false).\n- MCP search default limit is 20 (max 50, paginate with offset).\n- Web UI lists 20 secrets per page with pagination (since commit aae771f, predates 2026-10 updates).\n- As of 2026-10-02 (later count): 71 secrets total (69 actual + 2 archived), all owned by goldmikki@gmail.com; 20 actual with allow_mcp=true, 49 with allow_mcp=false (mostly personal logins created via extension since May 2026). Nothing was lost during the 2026-10-01/02 updates: .env byte-identical to pre-update backup, zero app errors, only 2 deletions ever (2026-05-28).\n\n## Audit semantics (verified 2026-10-02, resolved a second false alarm)\n- Audit events keep a `metadata` snapshot (title, tags, category) forever, including after deletion — deleted secrets remain visible in the audit log under their last known title. Deletion code: `gnexus_creds/services.py` (`audit(..., action=\"secret.deleted\", metadata={\"snapshot\": ...})`).\n- Renaming a secret does NOT rewrite old audit metadata — each event shows the title as of that moment.\n- Archiving hides a secret from the default UI list, but it stays in the DB (`archived=true`) and its audit history remains.\n- `ip_address` in audit for UI traffic via https://creds.gnexus.space shows the internal reverse-proxy IP (192.168.1.226, [[internal-proxy-vps]]), not the real client IP — attribute by `user_agent`, not by IP.\n- Full reconciliation 2026-10-02: exactly 2 audit titles reference secrets absent from the DB — \"git.gnexus.space — root\" and \"git.gnexus.space — testing\", both deleted 2026-05-28 via UI (Chrome/Linux, through the proxy). \"gntodo SSO client + MCP token (tasks.gnexus.space)\" audit title refers to a since-renamed/split secret (now \"gntodo SSO client + webhook secret\" + \"gntodo MCP token\"). No phantom reveals, no unexplained deletions.\n\n## Configuration\n- Environment variables are managed via `.env` file in `/home/ubuntu/gnexus-creds`.\n- Production mode enabled (`GNEXUS_CREDS_ENV=production`).\n- Secrets (`SECRET_KEY`, `MCP_TOKEN`) are randomly generated.\n\n## Local runtime adaptation (do not overwrite)\n`docker-compose.yml` has an uncommitted local modification that matches the live stack:\n- service renamed `postgres` $\\to$ `db` (container names gnexus-creds-db-1 / app-1 depend on it);\n- port mapping `80:8000` (upstream default is `8000:8000`);\n- app healthcheck uses python urllib instead of curl (curl not in image);\n- `restart: unless-stopped` on both services.\nPreserve it across updates: `git stash push docker-compose.yml` $\\to$ pull $\\to$ `git stash pop`.\n\n## Operations\n- **Health Check**: `GET /health`\n- **Readiness Check**: `GET /ready`\n- **Migrations**: `docker compose run --rm app alembic upgrade head`\n- **Logs**: `docker compose logs -f app`\n- **Update procedure** (verified 2026-10-01 ×1 and 2026-10-02 ×3): backup `.env` + `docker-compose.yml` to `~/backups/` $\\to$ stash compose $\\to$ `git pull --ff-only origin master` $\\to$ stash pop $\\to$ `sudo docker compose up -d --build` $\\to$ `alembic upgrade head` $\\to$ check `/health`, `/ready` and https://creds.gnexus.space/health.\n- **SSH access**: ubuntu@192.168.1.173, password same as navi swarm password (see gnexus-creds secret \"navi (192.168.1.168) — SSH ubuntu\"); sudo same password. No dedicated secret for this host yet." + }, + "status": "applied", + "created_at": "2026-10-02T12:02:52Z", + "updated_at": "2026-10-02T12:02:53Z", + "applied_at": "2026-10-02T12:02:53Z", + "validation": { + "status": "ok", + "issue_count": 0, + "issues": [] + } +}