Rev 2026-06-25
TCEC Access Control System Documentation
CHAPTER 08Quick Reference
Key credentials, commands, and contacts — printable single-page reference.
8.1 Key Credentials & IDs
| Item | Value |
|---|
| ElevenLabs voice ID (Sigma Centauri) | bAq8AI9QURijOtmeFFqT |
| ElevenLabs TTS model | eleven_turbo_v2_5 |
| Nest Mini HA entity | media_player.therese_office_122a |
| MQTT topic | woodhaven/prox/scan |
| AppDaemon addon ID | a0d7b954_appdaemon |
| HA backup SMB share | \\192.168.191.10\ha_backups_pi5 |
| Viking strike release (tenant phone) | 36 |
| Viking LOG BUS baud rate | 1200 baud ASCII |
| Jim Miles card number | 752519 (facility 11, card 31623, printed 011:31623) |
| Pi 5 SSH user | oracle |
| Pi 4 kiosk MAC | 88:a2:9e:4c:87:a9 |
| Nest Mini MAC | 14:c1:4e:36:a6:9f |
8.2 Common Admin Commands
ssh oracle@192.168.191.121
# Tail AppDaemon log
tail -f /addon_configs/a0d7b954_appdaemon/logs/appdaemon.log
# Open access database
sqlite3 /config/prox_cards.db
# List tenants and cards
SELECT t.name, c.card_number, c.active FROM tenants t JOIN cards c ON c.tenant_id = t.id;
# Last 10 access log entries
SELECT timestamp, door_id, display_result FROM access_log ORDER BY id DESC LIMIT 10;
# Hot-reload an app
touch /addon_configs/a0d7b954_appdaemon/apps/prox_card.py
# Verify ElevenLabs keys
grep elevenlabs /addon_configs/a0d7b954_appdaemon/apps/apps.yaml
# Manual DB backup
sqlite3 /config/prox_cards.db .dump > /config/prox_cards_backup_$(date +%Y%m%d).sql
# Deactivate a card
sqlite3 /config/prox_cards.db "UPDATE cards SET active = 0 WHERE card_number = 752519;"
8.3 File Path Cheat Sheet
| What | Path |
|---|
| apps.yaml | /addon_configs/a0d7b954_appdaemon/apps/apps.yaml |
| prox_card.py | /addon_configs/a0d7b954_appdaemon/apps/prox_card.py |
| prox_ui.py | /addon_configs/a0d7b954_appdaemon/apps/prox_ui.py |
| prox_ui.html | /addon_configs/a0d7b954_appdaemon/apps/prox_ui.html |
| appdaemon.yaml | /addon_configs/a0d7b954_appdaemon/appdaemon.yaml |
| AppDaemon log | /addon_configs/a0d7b954_appdaemon/logs/appdaemon.log |
| SQLite DB | /config/prox_cards.db |
| Snapshots / TTS | /homeassistant/www/snapshots/ |
| Manual HTML files | /homeassistant/www/manual/ |
| ESPHome configs | /config/esphome/ |
| Kiosk watchdog | /home/oracle/kiosk-watchdog.sh (on Pi 4) |
8.4 Contacts
| Role | Name | Contact |
|---|
| System Administrator | Jim Miles (oracle) | SSH · HA UI · Nabu Casa |
| Building Manager | Martin Chettle | tcec.manager@gmail.com |
| On-site wiring | Martin Chettle | Physical wiring, Cat5, cabinet, DIN rail |