• https://immich.app/ - photo
• https://wiki.servarr.com/prowlarr - Lidarr, Prowlarr, Radarr, Readarr, Sonarr, and Whisparr docker

• у павла http://psenyukov.ru/ https://t.me/ypavla
• своими руками https://dzen.ru/media/smart_home_russia/
• Умный дом с Alex Kvazis - https://t.me/smarthomesell https://www.youtube.com/channel/UCcq9onYHbs6go3kDpfBoqhg
• https://www.smarthomebeginner.com/home-server/
• https://habr.com/ru/articles/799957/ - esphome датчик тепла, учета энергии, импульсов

• Считывание аналоговых счетчиков

• https://habr.com/ru/articles/817001/ Резервный мониторинг послушного дома

• https://github.com/to4ko/myconfig/
• https://github.com/avbor/HomeAssistantConfig

#TODO sensors with battery list - https://simple-ha.ru/posts/468

• Good channel and video

1. database of zigbee devices https://zigbee.blakadder.com/all.html

1. * Run Zigbee2MQTT on Tuya T6E Android Smart Home Panels - https://blakadder.com/t6e-z2m/
2. * start with debug ZIGBEE2MQTT_DATA=/etc/zigbee2mqtt/ ; DEBUG=zigbee-herdsman* ; node –inspect=0.0.0.0:5858 cli.js

https://www.awesome-ha.com/ config energy
https://wiki.ip2u.ru/smart-home#home_assistant - multiroom

HAAS HAOS install on armbian additional HAAS addons repository
in docker HA right docker old Smart home Russia HA on armbian in docker
in proxmox HA in proxmox 8
in openwrt install HA on openwrt https://github.com/openlumi/homeassistant_on_openwrt

открываем домофон https://habr.com/ru/articles/533812/

https://www.home-assistant.io/integrations/ubus/

Xiaomi - 
>>> Solution >>>
I have create via ES-FileExplorer a file /config/wifi/mac.txt with the wish MAC-Adress with chmod 444 permissions and it works !!!!
<<<Solution <<<

10A2ABxxxxxx - without double point

https://docs.scrypted.app/installation.html – scrypted install docker
https://www.homeautomationguy.io/blog/running-frigate-on-proxmox – frigate install docker on proxmox
https://coral.googlesource.com/webcoral/ - TPU accelerator coral start

example http://kvazis.link/hassos
icons https://pictogrammers.com/library/mdi/ https://mdi.bessarabov.com/icon/memory

https://www.youtube.com/watch?v=MCNxgb0mrSA

https://sprut.ai/user/AlexAz/contents/articles

Get stats of mysql - where data located

-- get count of state entity and count of history data
SELECT 
    states_meta.entity_id,
    COUNT(*),
   -- states.state,
    from_unixtime(MIN(states.last_updated_ts)) AS last_updated_ts,
    from_unixtime(MIN(IF(states.last_changed_ts IS NULL,
        states.last_updated_ts,
        states.last_changed_ts))) AS last_changed_ts
FROM
    states
        LEFT JOIN
    states_meta ON (states.metadata_id = states_meta.metadata_id)
GROUP BY states_meta.entity_id
ORDER BY 2 DESC;
 
-- size of all tables
SELECT table_schema AS `DB`, TABLE_NAME AS `Table`,TABLE_ROWS, 
  ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` 
  FROM information_schema.TABLES 
  ORDER BY (data_length + index_length) DESC;

# home assistant - executing in day 24h
01h 	24
10m 	144
05m 	288
01m 	1440
05s	17280
01s	86400
 
{% set result = namespace(sensors=[]) %}
{% set exclude = [] %}
{% set hours = 1 %}
{% for state in states.sensor | rejectattr('attributes.device_class', 'undefined') | selectattr('attributes.device_class', '==', 'timestamp') %}
    {{state}}
    {% if 'last_seen' in state.entity_id and not state.entity_id in exclude.entity_id and (states(state.entity_id) == 'unavailable' or ((as_timestamp(now()) - as_timestamp(states(state.entity_id))) > ((hours | int) * 60 * 60))) %}
     {% set result.sensors = result.sensors + [state.name | regex_replace(find=' last seen', replace='') ~ ' (' ~ relative_time(strptime(states(state.entity_id), '%Y-%m-%dT%H:%M:%S%z', 'unavailable')) ~ ')'] %}
    {% endif %}
 {% endfor %}
 {{ result.sensors | join(', ') }}

• OpenHAB

• telegram channel
• 4pda mi home - version from VEVs
• Site with pathced verion mi home

• https://github.com/AlexxIT/XiaomiGateway3
• https://simple-ha.ru/posts/261
• https://habr.com/ru/post/535660/

Xiaomi Gateway 2 - DGNWG05LM - get root for my gateway

• install HA on openwrt https://github.com/openlumi/homeassistant_on_openwrt
• https://openlumi.github.io/ https://github.com/DivanX10/Openwrt-scripts-for-gateway-zhwg11lm - scripts example
• https://github.com/Alx2000y/lumimqttd
• 
• https://4pda.to/forum/index.php?showtopic=1002710&st=100
• ZESP - https://github.com/openlumi/openlumi.github.io#working-with-zigbee

Настройка DGNWG05LM - owrt OpenLumi 21.02.5 - ZigBee ZESP

1. <https://openlumi.github.io/> делаем backup и шьем owrt OpenLumi 21.02.5 - по инструкции , настриваем wifi
2. <https://openlumi.github.io/zesp32.html> ставим packages , но не ставим старый zesp
3. ставим zesp Code

   $cd /tmp && wget http://82.146.46.112/fw/zesp.tar.gz && tar -xzvf zesp.tar.gz -C / 
   копируем bindings 
   $cp /opt/zesp/ini/build/Release/bindings.node.21  /opt/zesp/build/Release/bindings.node
   $cp /opt/zesp/ini/build/Release/bindings1.node  /opt/zesp/build/Release/bindings1.node
    
   $killall start.sh
   $killall node
   $cd /opt/zesp
    
   $node index

4. настраиваем zesp - zigbee
   1. cfg → zigbee → modeRouter (alert need reflash) → жмем по wirte zCoordinator
   2. при необходимости настриваем mqtt - mqttEnable=1 , Home_Assistant=1 при необхожимости
   3. save → restart
   4. переходим dashboard → device list → раскрываем шлюз жмем init zigbee Screen
   5. добавляем устройства zigbee
   6. настриваем automatization - script → save → restart
5. автозапуск code

   cp /opt/zesp/ini/package.json /opt/zesp
   cat << EOF > /etc/init.d/zesp32
   #!/bin/sh /etc/rc.common
    
   START=99
   USE_PROCD=1
    
   start_service()
   {
           procd_open_instance
           procd_set_param command /usr/bin/npm start --prefix /opt/zesp
           procd_set_param respawn ${respawn_threshold:-3600} ${respawn_timeout:-5} ${respawn_retry:-0}
           procd_set_param pidfile /var/run/zesp32.pid
           procd_set_param stdout 1
           procd_set_param stderr 1
           procd_close_instance
   }
   EOF
    
   chmod o+wx /etc/init.d/zesp32
    
   /etc/init.d/zesp32 enable

• sensor Sonoff panel <https://habr.com/ru/articles/777376/>

• https://valetudo.cloud/pages/companion_apps/valetudo_companion.html

• root android https://www.youtube.com/watch?v=PO1WWv6YU6E

••••••••••

помни про EU.......9

• 4pda - Sonoff Прошивка
• https://tasmota.github.io/docs/Components/#tasmota32 - firmware universal *
• https://www.esphome-devices.com/devices/Sonoff-BASIC-R2-v1.4
• https://esphome.io/ - another firmware

• * scheme and start https://tasmota.github.io/docs/ADC/#adc_ct-circuit
• calculation https://docs.openenergymonitor.org/electricity-monitoring/ct-sensors/interface-with-arduino.html
• adc scheme and code https://www.electronicshub.org/nodemcu-esp8266-adc-tutorial/ https://randomnerdtutorials.com/esp8266-adc-reading-analog-values-with-nodemcu/
• energy meter project https://how2electronics.com/iot-based-electricity-energy-meter-using-esp32-blynk/
• esp 32 , android software - project https://hackaday.com/2019/07/27/building-a-safe-esp32-home-energy-monitor/, https://savjee.be/blog/Home-Energy-Monitor-ESP32-CT-Sensor-Emonlib/,https://www.youtube.com/watch?v=H6wmBGExMJg

• instruction firmware - https://www.youtube.com/watch?v=KBAGWBWBATg
• drivers and python script - drivers need to work software for rewrite https://github.com/JelmerT/cc2538-bsl/pull/114 - • instruction comment Hedda commented on Nov 29, 2021
• firmware - https://github.com/Koenkk/Z-Stack-firmware/tree/master/coordinator/Z-Stack_3.x.0/bin

• firmware zigbee thread metter - https://smarthomescene.com/guides/how-to-enable-thread-and-matter-support-on-sonoff-zbdongle-e/

• https://www.reddit.com/r/sonoff/comments/mq1c7k/sonoff_sv_full_pinout/

1. automatic zigbee sensor https://blakadder.com/sonoff-th-custom-firmware/

• https://tasmota.github.io/docs/Getting-Started/#serial-connection

• cheatsheet armbian https://bva.dyndns.info/wiki/os/armbian https://bva.dyndns.info/page:4
• install docker https://seraf.dev/install-docker-on-armbian/
• Пример запуска Armbian https://habr.com/ru/articles/767336/
• Превращаем TV-box в мини-компьютер https://habr.com/ru/articles/765280/
• SD performance https://forum.armbian.com/topic/954-sd-card-performance/
• using infrared - https://www.sigmdel.ca/michel/ha/opi/ir_01_en.html
• UBOOT - https://habr.com/ru/articles/765280/

1. Support kernels for rk3188 https://github.com/ophub https://github.com/paolosabatino/
2. Amlogic eMMC Partition Tool - https://github.com/7Ji/ampart
3. armbian на русском https://dzen.ru/a/YmecohTy_0Ic0iv3?referrer_clid=1400&
4. main thread https://forum.armbian.com/topic/26978-csc-armbian-for-rk3318rk3328-tv-box-boards/
5. https://4pda.to/forum/index.php?showtopic=1005934
6. install armbian https://www.hyperhdr.eu/2022/01/tv-box-mania-i-part-x88-pro-10.html
7. debricking https://www.youtube.com/watch?v=9bW9fGokyLE
8. платная замена памяти wifi https://www.youtube.com/watch?v=9yBMO1m6qgY

https://mysku.club/blog/aliexpress/52206.html
https://4pda.to/forum/index.php?showtopic=872563&st=7880

identification помни про EU……….
••••••••••
“Energy in” - key : @dm<'e4Q29|#N0/_