3 Commits

Author SHA1 Message Date
a9d550ba1d fix: replace mysqladmin with PHP mysqlnd for MySQL 8 compatibility
The MariaDB CLI client (default-mysql-client on Debian) cannot complete
the caching_sha2_password handshake used by MySQL 8.0, so the entrypoint
wait loop never exited.

- Dockerfile: remove default-mysql-client (no longer needed)
- docker-entrypoint.sh: wait loop now uses a PHP one-liner via mysqli_connect
  (same mysqlnd driver the app uses — if it connects, the app will too)
- docker-compose.yml: health check pings via local socket without credentials
  (mysqladmin ping -h localhost --silent works inside the DB container)

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-11 10:59:39 +02:00
6002fc6e58 feat: add macOS disc scanner + API ingest endpoint
- scanner/scan_disc.py: polls optical drive via drutil, detects disc type
  (DVD/Blu-ray/Audio CD/Data CD), reads volume label, file/track count,
  posts to remote API, auto-ejects. Pure Python + requests, no drivers.
- scanner/requirements.txt + README.md: setup and usage docs
- videodb/api_ingest.php: authenticated POST endpoint that writes disc
  records directly into the videoDB MySQL schema; token stored in config
- docker-compose.yml: adds INGEST_API_TOKEN env var
- docker-entrypoint.sh: writes ingest_api_token into config.inc.php

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-11 09:58:11 +02:00
f55c91276e feat: add videodb media index with Docker stack
- Add videodb PHP/MySQL media collection manager (Blu-ray, DVD, CD)
- Dockerfile: PHP 8.1 + Apache with GD/mysqli/exif extensions
- docker-compose.yml: app on port 6761 + MySQL 8.0 with health checks
- docker-entrypoint.sh: auto-generates config.inc.php from env vars,
  waits for MySQL, initializes DB schema idempotently
- init-db.php: CLI schema installer using app's own prefix_query() logic
- Persistent volumes for DB, cache, and cover images

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-05-11 09:49:52 +02:00