## Grafana / InfluxDB BrewTV Project — Day 1 (Paused)### What We Accomplished- Set up InfluxDB add-on with brewery database, Brewer user (iamtheclaw)- Set up Grafana add-on (accessible via HA Ingress)- Configured HA InfluxDB integration to stream TILT data- Data flowing: sensor.tilt_white_specific_gravity, sensor.tilt_pro_green_specific_gravity, dBm- Created dashboard JSON files (v1, v2, v3) — stored in workspace and BrewBusiness Drive folder### The Problem (Not Solved)- Temperature data went into corrupted measurement name (°F → °F double UTF-8 encoding)- Grafana couldn't auto-populate FROM/WHERE dropdowns because measurement names were garbled- This made manual query setup required for every panel — tedious- Result: HA BrewTV dashboard works fine; Grafana is painful due to encoding issue### What Works- SG data (sensor.tilt_white_specific_gravity, sensor.tilt_pro_green_specific_gravity) — queries work perfectly- Signal strength (dBm measurement, entity_id filter) — works- Temperature ONLY works through HA dashboard, not Grafana### Key Technical Notes- InfluxDB data source URL (Grafana → InfluxDB): `http://a0d7b954-influxdb:8086` (NOT https, SSL must be OFF)- Grafana query language: InfluxQL (NOT Flux)- Dashboard JSON files: /home/HHS/.openclaw/workspace-psb-gemma/psb_brewery_dashboard_v*.json- Drive folder: BrewBusiness (1-A-bgZGKhdKgiRxJmBzF584jW2MprIMG)- HA Fermentation Dashboard: http://100.126.129.57:8123/dashboard-brewery/brewtv### Next Steps (For When We Come Back)1. Clear corrupted Influx measurements: DROP MEASUREMENT for garbled °F entries2. Let HA send fresh temp readings — they'll re-populate with clean names3. Rebuild Grafana dashboard — queries will auto-populate from dropdowns4. Consider branding: PSB logo, color scheme, stacked tank pairs layout5. Alternative: Use Grafana for SG + trends only, HA dashboard for temp### Credentials (HA at brewery)- Token: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...- URL: http://100.126.129.57:8123