Hello community,
I think I’m too dump for home assistant. It takes me so long to get things up and running.
My setup is:
- haos virtualised with 2 Cores, 4GB RAM and 64GB nvme on FreeBSD with bhyve.
- WiFi and Bluetooth integrated by passthru.
I have successful integrated the sbfspot HA to get the Data from my SB 4000TL-20 ## Software Version: 03.01.05.R via Bluetooth.
I used the Dokumentation to install MariaDB, phpmyadmin, MQTT Mosquito and so far the Data is stored in the Database. I can see the entries in the Tables of the Database. Here is the Log of sbfspot for one entry:
********************
* ArchiveDayData() *
********************
startTime: 06/01/2026 00:00:00
Tue Jan 6 13:45:05 2026: INFO: Done.
[13:45:45] INFO: [SBFspot Upload Log Latest]
SBFspot V3.9.12
Yet another tool to read power production of SMA solar inverters
(c) 2012-2025, SBF (https://github.com/SBFspot/SBFspot)
Compiled for Linux (LE) 64 bit with MySQL support
Commandline Args: -v -ad1 -am0 -ae0 -mqtt
Reading config '/usr/bin/sbfspot/SBFspot.cfg'
Tue Jan 6 13:50:00 2026: INFO: Starting...
sunrise: 08:03
sunset : 16:33
Connecting to 00:80:25:0A:17:DD (1/10)
Initialising...
SUSyID: 125 - SessionID: 838290180
SMA netID=03
Serial Nr: 7D2C203E (2100043838)
BT Signal=72.5%
Logon OK
SUSyID: 78 - SN: 2100043838
Device Name: SN: 2100043838
Device Class: Solar-Wechselrichter
Device Type: SB 4000TL-20
Software Version: 03.01.05.R
Packet status: 21
SUSyID: 78 - SN: 2100043838
Device Status: Ok
SUSyID: 78 - SN: 2100043838
Device Temperature: 44.4°C
SUSyID: 78 - SN: 2100043838
GridRelay Status: Geschlossen
SUSyID: 78 - SN: 2100043838
Energy Production:
EToday: 8.493kWh
ETotal: 70020.056kWh
Operation Time: 64071.99h
Feed-In Time : 62377.38h
SUSyID: 78 - SN: 2100043838
DC Spot Data:
MPPT 1 Pdc: 0.877kW - Udc: 260.29V - Idc: 3.372A
MPPT 2 Pdc: 0.731kW - Udc: 403.26V - Idc: 1.815A
Calculated Total Pdc: 1.608kW
AC Spot Data:
Phase 1 Pac : 1.597kW - Uac: 232.57V - Iac: 6.869A
Phase 2 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Phase 3 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
Total Pac : 1.597kW - Calculated Pac: 1.597kW
Efficiency : 99.32%
SUSyID: 78 - SN: 2100043838
Grid Freq. : 50.00Hz
SUSyID: 78 - SN: 2100043838
Current Inverter Time: 2026-01-06T13:50:24+0100
Inverter Wake-Up Time: 2026-01-06T08:09:24+0100
Inverter Sleep Time : 2026-01-06T13:50:27+0100
MQTT: Publishing (homeassistant/sbfspot_SunnyBoy/sbfspot_2100043838),"PrgVersion": "3.9.12","Plantname": "SunnyBoy","Timestamp": "2026-01-06T13:50:04+0100","SunRise": "2026-01-06T08:03:00+0100","SunSet": "2026-01-06T16:33:00+0100","InvSerial": 2100043838,"InvName": "SN: 2100043838","InvTime": "2026-01-06T13:50:24+0100","InvStatus": "Ok","InvSwVer": "03.01.05.R","InvClass": "Solar-Wechselrichter","InvType": "SB 4000TL-20","InvTemperature": 44.440,"InvGridRelay": "Geschlossen","EToday": 8.493,"ETotal": 70020.056,"GridFreq": 50.000,"PACTot": 1597.000,"PAC1": 1597.000,"UAC1": 232.570,"IAC1": 6.869,"OperTm": 64071.990,"FeedTm": 62377.383,"PDCTot": 1608.000,"UDC1": 260.290,"UDC2": 403.260,"IDC1": 3.372,"IDC2": 1.815,"PDC1": 877.000,"PDC2": 731.000,"BTSignal": 72.549,"InvWakeupTm": "2026-01-06T08:09:24+0100","InvSleepTm": "2026-01-06T13:50:27+0100"
Client null sending CONNECT
Client null received CONNACK (0)
Client null sending PUBLISH (d0, q0, r0, m1, 'homeassistant/sbfspot_SunnyBoy/sbfspot_2100043838', ... (786 bytes))
Client null sending DISCONNECT
********************
* ArchiveDayData() *
********************
startTime: 06/01/2026 00:00:00
Tue Jan 6 13:50:05 2026: INFO: Done.
[13:50:45] INFO: [SBFspot Upload Log Latest]
When I go the the devices, I have one Device and the entities are generated, but at all Entities is the Status"unknown", see german screenshot.
Can anyone explain to me why the data in in the database but can not be shown in Home Assistant?
Have I missed something in the documentation, why the data is not shown in Home Assistant?
Thank you very much.
Robert