10 Commits
Author SHA1 Message Date
derekcandClaude Opus 5.5 896be8fbe9 Extend MySQL healthcheck start_period to 180s
The in-place upgrade from MySQL 8.0 to 8.4 took ~90s, longer than the
previous 30s start_period plus retries, so Compose marked the db unhealthy
and never started the API. The healthcheck still passes as soon as MySQL
is ready, so normal startups are not slowed.

Co-Authored-By: Claude Opus 5.5 <[email protected]>
2026-10-27 23:17:42 -07:00
derekcandClaude Opus 5.5 2382289484 Major dependency upgrades: Python 3.14, FastAPI, SQLAlchemy 2.1, PyJWT, MySQL 8.4
- Python base image 3.12-slim -> 3.14-slim
- fastapi 0.136.3 -> 0.162.0, sqlalchemy 2.0.50 -> 2.1.6
- Replace unmaintained python-jose with PyJWT 2.15.1; tokens issued by
  python-jose remain valid, so existing sessions are not logged out
- MySQL 8.0.46 (EOL) -> 8.4.13 LTS; in-place data dictionary upgrade runs
  automatically on first start

Co-Authored-By: Claude Opus 5.5 <[email protected]>
2026-10-27 23:02:45 -07:00
derekcandClaude Opus 5.5 8f32a395a1 Bump low-risk dependencies: uvicorn, pymysql, cryptography, pydantic, nginx, Chart.js
- uvicorn 0.54.0, pymysql 1.2.3, cryptography 50.0.2, pydantic 2.14.1
- nginx 1.30.6-alpine
- Chart.js CDN 4.6.1 with updated SRI hash; add missing SRI to summary.html

Co-Authored-By: Claude Opus 5.5 <[email protected]>
2026-10-27 22:55:01 -07:00
derekcandClaude Sonnet 4.6 977d225166 Bump Docker base images: MySQL 8.0.46, nginx 1.30.2-alpine
Also moves nginx from mainline (1.29.x) to the stable branch (1.30.x).

Co-Authored-By: Claude Sonnet 4.6 <[email protected]>
2026-05-25 01:45:53 -07:00
derekcandClaude Sonnet 4.6 7cd2dfb710 Add ntfy push notifications for security-relevant events
Sends alerts on admin login, new registrations, user disable/delete, and
impersonation. NTFY_URL and NTFY_TOKEN are optional — leave blank to disable.

Co-Authored-By: Claude Sonnet 4.6 <[email protected]>
2026-03-23 23:01:13 -07:00
derekcandClaude Sonnet 4.6 392a48dfb9 Go-live hardening: server_tokens, resource limits, pinned images, CVE fixes
- Add server_tokens off to nginx (suppress version leakage)
- Add deploy.resources.limits to all containers (db: 512M, api: 256M, nginx: 64M)
- Pin image tags: mysql:8.0 → 8.0.45, nginx:alpine → 1.29.6-alpine
- Fix CVEs: cryptography 43.0.3 → 46.0.5 (HIGH), python-jose 3.3.0 → 3.4.0 (CRITICAL)
- Add .limit(500) to GET /api/flock and GET /api/admin/users

Co-Authored-By: Claude Sonnet 4.6 <[email protected]>
2026-03-20 00:16:28 -07:00
derekcandClaude Sonnet 4.6 9709283d7a Fix remaining code quality and infrastructure items
- admin.py: remove unused get_current_user import
- feed.py, flock.py, other.py: add IntegrityError handling on POST/PUT
  endpoints; duplicate submissions now return 409 instead of crashing with
  a 500 error
- stats.py: extract magic numbers into named module-level constants
  (DAYS_ROLLING, DAYS_SHORT, PRECISION_AVG, PRECISION_HEN, PRECISION_COST);
  add return type annotations to _total_feed_cost and _total_other_cost;
  normalize both helpers to always return Decimal so budget_stats no longer
  needs Decimal(str(...)) workarounds; simplify _cpe/_cpd helpers
- dashboard.js: read --green CSS variable at runtime instead of hardcoding
  the hex value so chart color stays in sync with the stylesheet
- docker-compose.yml: add healthcheck to api service (polls /api/health
  every 30s) so Docker knows when the API is unhealthy; add password
  strength guidance comment above the db service

Co-Authored-By: Claude Sonnet 4.6 <[email protected]>
2026-03-18 00:18:58 -07:00
derekcandClaude Sonnet 4.6 37f19a83ed Implement security hardening across frontend, backend, and infrastructure
- nginx: add X-Content-Type-Options, X-Frame-Options, X-XSS-Protection,
  and Referrer-Policy headers on all responses; rate limit /api/auth/login
  to 5 req/min per IP (burst 3) to prevent brute force
- frontend: add escHtml() utility to api.js; use it on all notes fields
  across dashboard, log, history, flock, and budget pages to prevent XSS
- log.js: fix broken loadRecent() call referencing removed #recent-body
  element; replaced with loadHistory() from history.js
- schemas.py: raise minimum password length from 6 to 10 characters
- admin.py: add audit logging for password reset, disable, delete, and
  impersonate actions; fix impersonate to use named admin param for logging
- main.py: add startup env validation — exits with clear error if any
  required env var is missing; configure structured logging to stdout
- docker-compose.yml: add log rotation (10 MB / 3 files) to all services

Co-Authored-By: Claude Sonnet 4.6 <[email protected]>
2026-03-17 23:55:08 -07:00
derekcandClaude Sonnet 4.6 aa12648228 Add multi-user auth, admin panel, and timezone support; rename to Yolkbook
- Rename app from Eggtracker to Yolkbook throughout
- Add JWT-based authentication (python-jose, passlib/bcrypt)
- Add users table; all data tables gain user_id FK for full data isolation
- Super admin credentials sourced from ADMIN_USERNAME/ADMIN_PASSWORD env vars,
  synced on every startup; orphaned rows auto-assigned to admin post-migration
- Login page with self-registration; JWT stored in localStorage (30-day expiry)
- Admin panel (/admin): list users, reset passwords, disable/enable, delete,
  and impersonate (Login As) with Return to Admin banner
- Settings modal (gear icon in nav): timezone selector and change password
- Timezone stored per-user; stats date windows computed in user's timezone;
  date input setToday() respects user timezone via Intl API
- migrate_v2.sql for existing single-user installs
- Auto-migration adds timezone column to users on startup
- Updated README with full setup, auth, admin, and migration docs

Co-Authored-By: Claude Sonnet 4.6 <[email protected]>
2026-03-17 23:19:29 -07:00
derekcandClaude Sonnet 4.6 492e1fd68f Initial commit
Co-Authored-By: Claude Sonnet 4.6 <[email protected]>
2026-02-26 22:27:58 -08:00