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>
scanner/scan_disc.py:
- Inventory disc into video files + photo folders (grouped by directory)
- Photo extensions: jpg/jpeg/png/gif/tiff/bmp/heic/heif/webp + raw formats
(cr2 cr3 nef arw dng orf rw2 raf)
- Video disc → 1 record per disc with video file list
- Photo disc → 1 record per gallery folder with photo list
- Mixed disc → both: 1 video record + 1 record per photo folder
- Unknown disc → 1 fallback record with total file count
- Folder title format: "DISC_LABEL — Folder / Subfolder"
videodb/api_ingest.php:
- Add subtitle field (gallery folder path)
- Add plot field (TEXT — full filename list, no 255-char limit)
- Add custom3 field (content type: video | photo | mixed | data)
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Dockerfile: add libonig-dev (oniguruma) — required by mbstring extension
scanner/scan_disc.py:
- Treat all discs as data discs (mp4/mkv/etc), no VIDEO_TS/BDMV logic
- List video files by extension (.mp4 .mkv .avi .mov .m4v .ts .m2ts …)
- Infer media type from drutil type string, fall back to used_gb capacity
(>8 GB → Blu-ray, >0.68 GB → DVD, smaller → CD)
- Store video file names in comment field, count in custom2
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
- 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>
- 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>
