SMA Adapter und sbfspot

[pjo123456]

Moin!

Ich versuche hier gerade oben genannten Adapter zum Laufen zu bringen. Oder besser gesagt Daten vom Wechselrichter zu bekommen.
Der Adapter ist installiert. Unter Objekten sieht es so aus:

Danach habe ich sbfspot konfiguriert mit dem entsprechenden Tool bzw. Script:

curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config | sudo bash

Die sqlite DB habe ich unter /opt/iobroker/ angelegt.

Im Protokoll sehe ich diese Fehlermeldung:

sbfspot.0 2022-07-03 23:24:01.755	info	Terminated (ADAPTER_REQUESTED_TERMINATION): Without reason
sbfspot.0 2022-07-03 23:24:01.754	info	all done ...
sbfspot.0 2022-07-03 23:24:01.752	error	exception in DB_AddDummyData [SqliteError: no such column: SN: 1234567]
sbfspot.0 2022-07-03 23:24:01.751	error	no inverter data found, adding dummy data...
sbfspot.0 2022-07-03 23:24:01.724	info	start with sqlite
sbfspot.0 2022-07-03 23:24:01.689	info	starting. Version 4.0.8 in /opt/iobroker/node_modules/iobroker.sbfspot, node: v14.19.3, js-controller: 4.0.23

Irgendetwas stimmt noch nicht. Jemand eine Idee? Danke

[x2on]

@pjo123456 Hast du SBFSpot den eingerichtet, bzw. läuft das und schreibt Daten in die SQLite?
Am besten mal SBFSpot vom Terminal aufrufen und testen. Das Plugin liest ja nur die Daten aus.

[pjo123456]

@x2on Moin!

Sorry für die späte Rückmeldung. Bin unterwegs.

SBFSpot eingerichtet denke ich ja. Zumindest habe ich ja diese Konfiguration mit

curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config | sudo bash

erstellt.

Wenn ich SBFspot teste mit

/usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv

Dann bekomme ich diese Ausgabe (am Ende mit Fehlermeldungen):

SBFspot V3.9.5
Yet another tool to read power production of SMA solar inverters
(c) 2012-2022, SBF (https://github.com/SBFspot/SBFspot)
Compiled for Linux (LE) 32 bit with SQLite support
Commandline Args: -v -finq -nocsv
Reading config '/usr/local/bin/sbfspot.3/SBFspot.cfg'
Sun Jul 24 19:43:12 2022: INFO: Starting...
sunrise: 05:15
sunset : 21:10
Connecting to 00:80:25:2E:6A:E8 (1/10)
Initialising...
SUSyID: 125 - SessionID: 934213796
SMA netID=02
Serial Nr: 7EFA0B16 (2130316054)
BT Signal=7.8%
Logon OK
Local Host Time: 24/07/2022 19:43:22
Plant Time     : 24/07/2022 19:43:23 (+1 sec)
TZ offset      : 3600 sec - DST: On
Last Time Set  : 24/07/2022 10:04:21
SUSyID: 138 - SN: 2130316054
Device Name:      SB 3000TL-21 054
Device Class:     Solar Inverters
Device Type:      SB 3000TL-21
Software Version: 02.81.01.R
Packet status: 21
SUSyID: 138 - SN: 2130316054
Device Status:      Ok
SUSyID: 138 - SN: 2130316054
Device Temperature: 43.8°C
SUSyID: 138 - SN: 2130316054
GridRelay Status:      Closed
SUSyID: 138 - SN: 2130316054
Energy Production:
        EToday: 21.444kWh
        ETotal: 30157.295kWh
        Operation Time: 34572.43h
        Feed-In Time  : 33116.65h
SUSyID: 138 - SN: 2130316054
DC Spot Data:
        MPPT 1 Pdc:   0.108kW - Udc: 293.15V - Idc:  0.370A
        MPPT 2 Pdc:   0.044kW - Udc: 157.62V - Idc:  0.283A
        Calculated Total Pdc:   0.152kW
AC Spot Data:
        Phase 1 Pac :   0.127kW - Uac: 232.48V - Iac:  0.547A
        Phase 2 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
        Phase 3 Pac :   0.000kW - Uac:   0.00V - Iac:  0.000A
        Total Pac   :   0.127kW - Calculated Pac:   0.127kW
        Efficiency  :   83.55%
SUSyID: 138 - SN: 2130316054
Grid Freq. : 49.98Hz
SUSyID: 138 - SN: 2130316054
Current Inverter Time: 24/07/2022 19:43:22
Inverter Wake-Up Time: 24/07/2022 05:11:03
Inverter Sleep Time  : 24/07/2022 19:43:23
[2022-07-24 19:43:24.192] Error: sqlite3_exec() returned: 'attempt to write a readonly database' while executing
INSERT OR IGNORE INTO Inverters VALUES(2130316054,'SB 3000TL-21 054','SB 3000TL-21','02.81.01.R',0,0,0,0,0,0,'','',0)
[2022-07-24 19:43:24.192] Error: exec_query() returned: 'attempt to write a readonly database' while executing
INSERT OR IGNORE INTO Inverters VALUES(2130316054,'SB 3000TL-21 054','SB 3000TL-21','02.81.01.R',0,0,0,0,0,0,'','',0)
[2022-07-24 19:43:24.192] Error: sqlite3_exec() returned: 'attempt to write a readonly database' while executing
UPDATE Inverters SET Name='SB 3000TL-21 054',Type='SB 3000TL-21',SW_Version='02.81.01.R' WHERE Serial=2130316054
[2022-07-24 19:43:24.192] Error: exec_query() returned: 'attempt to write a readonly database' while executing
UPDATE Inverters SET Name='SB 3000TL-21 054',Type='SB 3000TL-21',SW_Version='02.81.01.R' WHERE Serial=2130316054
[2022-07-24 19:43:24.193] Error: sqlite3_exec() returned: 'attempt to write a readonly database' while executing
UPDATE Inverters SET TimeStamp=1658684604,TotalPac=127,EToday=21444,ETotal=30157295,OperatingTime=34572.4,FeedInTime=33116.6,Status='OK',GridRelay='Closed',Temperature=43.83 WHERE Serial=2130316054
[2022-07-24 19:43:24.193] Error: exec_query() returned: 'attempt to write a readonly database' while executing
UPDATE Inverters SET TimeStamp=1658684604,TotalPac=127,EToday=21444,ETotal=30157295,OperatingTime=34572.4,FeedInTime=33116.6,Status='OK',GridRelay='Closed',Temperature=43.83 WHERE Serial=2130316054
[2022-07-24 19:43:24.193] Error: sqlite3_exec() returned: 'attempt to write a readonly database' while executing
INSERT INTO SpotData VALUES(1658684604,2130316054,108,44,0.37,0.283,293.15,157.62,127,0,0,0.547,0,0,232.48,0,0,21444,30157295,49.98,34572.4,33116.6,7.84314,'OK','Closed',43.83)
[2022-07-24 19:43:24.193] Error: [spot_data]exec_query() returned: 'attempt to write a readonly database' while executing
INSERT INTO SpotData VALUES(1658684604,2130316054,108,44,0.37,0.283,293.15,157.62,127,0,0,0.547,0,0,232.48,0,0,21444,30157295,49.98,34572.4,33116.6,7.84314,'OK','Closed',43.83)
********************
* ArchiveDayData() *
********************
startTime: 24/07/2022 00:00:00
[2022-07-24 19:43:24.638] Error: [day_data]sqlite3_step() returned: 'attempt to write a readonly database'
[2022-07-24 19:43:24.638] Error: [day_data]Transaction failed. Rolling back now...: 'attempt to write a readonly database'
**********************
* ArchiveMonthData() *
**********************
startTime: 01/07/2022 13:00:00
[2022-07-24 19:43:24.852] Error: sqlite3_exec() returned: 'attempt to write a readonly database' while executing
DELETE FROM MonthData WHERE Serial=2130316054 AND strftime('%Y-%m',datetime(TimeStamp, 'unixepoch'))='2022-07';
[2022-07-24 19:43:24.852] Error: [month_data]sqlite3_exec() returned: 'attempt to write a readonly database'
[2022-07-24 19:43:24.852] Error: [month_data]Transaction failed. Rolling back now...: 'attempt to write a readonly database'
Reading events: 2022-Jul-01
ExportEventsToCSV()
[2022-07-24 19:43:25.360] Error: [event_data]sqlite3_step() returned: 'attempt to write a readonly database'
[2022-07-24 19:43:25.360] Error: [event_data]Transaction failed. Rolling back now...: 'attempt to write a readonly database'
Sun Jul 24 19:43:25 2022: INFO: Done.

Sagt dir das was?