This is the output from inverters:
2100250486|SN: 2100250486|SB 3000TL-20|02.08.01.R|1563537333|1647|4912|26296142|38331.2|36741.5|OK|Closed|55.78
No data is returned on the other two tables.
This is the output from inverters:
2100250486|SN: 2100250486|SB 3000TL-20|02.08.01.R|1563537333|1647|4912|26296142|38331.2|36741.5|OK|Closed|55.78
No data is returned on the other two tables.
So it seems SBFspot is not running correctly…
When running this command, do you see any errors related to sql db?
/usr/local/bin/sbfspot.3/SBFspot -finq -v5 -d
The only noticeable things here are following error messages:
Failed to get current plant time (0)
No data!
getSoftwareVersion returned an error: -1
getInverterData(512)
Here is the full output:
SBFspot V3.5.2
Yet another tool to read power production of SMA solar inverters
(c) 2012-2018, SBF (https://github.com/SBFspot/SBFspot)
Compiled for Linux (LE) 32 bit with SQLite support
Commandline Args: -finq -v5 -d
Reading config '/usr/local/bin/sbfspot.3/SBFspot.cfg'
Configuration settings:
BTAddress=00:80:25:15:F5:5C
Password=<undisclosed>
MIS_Enabled=1
Plantname=SoolwegPV
OutputPath=/home/pi/smadata/%Y
OutputPathEvents=/home/pi/smadata/%Y/Events
Latitude=47.6126
Longitude=8.29317
Timezone=Europe/London
CalculateMissingSpotValues=0
DateTimeFormat=%d/%m/%Y %H:%M:%S
DateFormat=%d/%m/%Y
TimeFormat=%H:%M:%S
SynchTime=1
SynchTimeLow=1
SynchTimeHigh=3600
SunRSOffset=900
DecimalPoint=comma
CSV_Delimiter=semicolon
Precision=3
CSV_Export=1
CSV_ExtendedHeader=1
CSV_Header=1
CSV_SaveZeroPower=1
CSV_Spot_TimeSource=0
CSV_Spot_WebboxHeader=0
Locale=en-US
BTConnectRetries=10
SQL_Database=/home/pi/smadata/SBFspot.db
### End of Config ###
Fri Jul 19 17:29:52 2019: INFO: Starting...
sunrise: 05:49
sunset : 21:16
Connecting to 00:80:25:15:F5:5C (1/10)
Initializing...
SUSyID: 125 - SessionID: 922802333 (0x3700D89D)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 17 00 69 00 00 00 00 00 00
00000010: 01 00 00 00 00 00 01 02 76 65
00000020: 72 0D 0A
23 Bytes sent
getPacket(2)
MAX_CommBuf is now 18 bytes
Received 18 bytes
Received 13 bytes
cmd=2
SMA netID=01
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 1F 00 61 00 00 00 00 00 00
00000010: 5C F5 15 25 80 00 02 00 00 04
00000020: 70 00 01 00 00 00 00 01 00 00
00000030: 00
31 Bytes sent
getPacket(10)
Received 18 bytes
Received 13 bytes
cmd=10
Root device address: 00:80:25:15:F5:5C
Local BT address: 00:1A:7D:DA:71:03
getPacket(5)
Received 18 bytes
Received 2 bytes
cmd=12
Received 18 bytes
Received 16 bytes
cmd=5
Device 0: 00:80:25:15:F5:5C -> Inverter
Device 1: 00:1A:7D:DA:71:03 -> Local BT Address
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 3F 00 41 03 71 DA 7D 1A 00
00000010: FF FF FF FF FF FF 01 00 7E FF
00000020: 03 60 65 09 A0 FF FF FF FF FF
00000030: FF 00 00 7D 5D 00 9D D8 00 37
00000040: 00 00 00 00 00 00 02 80 00 02
00000050: 00 00 00 00 00 00 00 00 00 00
00000060: 1B FD 7E
63 Bytes sent
getPacket(1)
Received 18 bytes
MAX_CommBuf is now 88 bytes
Received 88 bytes
cmd=1
PacketLength=106
SUSyID: 113 - SN: 2100250486
logoffSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 3B 00 45 03 71 DA 7D 1A 00
00000010: FF FF FF FF FF FF 01 00 7E FF
00000020: 03 60 65 08 A0 FF FF FF FF FF
00000030: FF 00 03 7D 5D 00 9D D8 00 37
00000040: 00 03 00 00 00 00 03 80 0E 01
00000050: FD FF FF FF FF FF B8 61 7E
59 Bytes sent
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 14 00 6A 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 03 00 05 00
20 Bytes sent
getPacket(4)
Received 18 bytes
Received 6 bytes
cmd=4
BT Signal=70.6%
logonSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 53 00 2D 03 71 DA 7D 1A 00
00000010: FF FF FF FF FF FF 01 00 7E FF
00000020: 03 60 65 0E A0 FF FF FF FF FF
00000030: FF 00 01 7D 5D 00 9D D8 00 37
00000040: 00 01 00 00 00 00 04 80 0C 04
00000050: FD FF 07 00 00 00 84 03 00 00
00000060: F1 E1 31 5D 00 00 00 00 B8 B8
00000070: B8 B8 88 88 88 88 88 88 88 88
00000080: 9D 87 7E
83 Bytes sent
getPacket(1)
Received 18 bytes
Received 66 bytes
cmd=1
PacketLength=84
Logon OK
SetPlantTime()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 5B 00 25 03 71 DA 7D 1A 00
00000010: FF FF FF FF FF FF 01 00 7E FF
00000020: 03 60 65 10 A0 FF FF FF FF FF
00000030: FF 00 00 7D 5D 00 9D D8 00 37
00000040: 00 00 00 00 00 00 05 80 0A 02
00000050: 00 F0 00 6D 23 00 00 6D 23 00
00000060: 00 6D 23 00 00 00 00 00 00 00
00000070: 00 00 00 00 00 00 00 00 00 00
00000080: 01 00 00 00 01 00 00 00 07 21
00000090: 7E
91 Bytes sent
getPacket(1)
Received 18 bytes
Received 66 bytes
cmd=1
PacketLength=84
Failed to get current plant time (0)
getInverterData(2048)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 06 80 00
00000050: 02 00 58 00 34 82 00 FF 34 82
00000060: 00 AB EE 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 66 bytes
cmd=1
PacketLength=84
getPacket(1)
No data!
getSoftwareVersion returned an error: -1
getInverterData(512)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 07 80 00
00000050: 02 00 58 00 1E 82 00 FF 20 82
00000060: 00 61 FC 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 87 bytes
cmd=1
PacketLength=105
getPacket(1)
Received 18 bytes
MAX_CommBuf is now 91 bytes
Received 91 bytes
cmd=8
PacketLength=109
Received 18 bytes
Received 75 bytes
cmd=1
PacketLength=93
INV_NAME : 'SN: 2100250486' Thu Jan 21 18:42:37 2010
INV_CLASS : 'Solar Inverters' Thu Jan 21 18:42:37 2010
INV_TYPE : 'SB 3000TL-20' Thu Jan 21 18:42:37 2010
SUSyID: 113 - SN: 2100250486
Device Name: SN: 2100250486
Device Class: Solar Inverters
Device Type: SB 3000TL-20
Software Version:
Serial number: 2100250486
getInverterData(4096)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 08 80 00
00000050: 02 80 51 00 48 21 00 FF 48 21
00000060: 00 E1 13 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 87 bytes
cmd=1
PacketLength=105
INV_STATUS : 'Ok' Fri Jan 22 06:11:21 2010
SUSyID: 113 - SN: 2100250486
Device Status: Ok
getInverterData(65536)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 09 80 00
00000050: 02 00 52 00 77 23 00 FF 77 23
00000060: 00 CB 21 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 74 bytes
cmd=1
PacketLength=92
SUSyID: 113 - SN: 2100250486
Device Temperature: 57.2°C
getInverterData(8192)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 0A 80 00
00000050: 02 80 51 00 64 41 00 FF 64 41
00000060: 00 50 78 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 87 bytes
cmd=1
PacketLength=105
INV_GRIDRELAY: 'Closed' Fri Jan 22 06:11:24 2010
SUSyID: 113 - SN: 2100250486
GridRelay Status: Closed
getInverterData(64)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 0B 80 00
00000050: 02 00 51 00 1E 41 00 FF 20 41
00000060: 00 40 39 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 91 bytes
cmd=8
PacketLength=109
Received 18 bytes
Received 39 bytes
cmd=1
PacketLength=57
INV_PACMAX1 : 3000 (W) Fri Jan 22 06:11:21 2010
INV_PACMAX2 : 3000 (W) Fri Jan 22 06:11:21 2010
INV_PACMAX3 : 3000 (W) Fri Jan 22 06:11:21 2010
SUSyID: 113 - SN: 2100250486
Pac max phase 1: 3000W
Pac max phase 2: 3000W
Pac max phase 3: 3000W
getInverterData(1)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 0C 80 00
00000050: 02 00 54 00 01 26 00 FF 22 26
00000060: 00 67 91 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 79 bytes
cmd=1
PacketLength=97
SPOT_ETOTAL : 26302.342 (kWh) Fri Jan 22 06:11:23 2010
SPOT_ETODAY : 11.114 (kWh) Fri Jan 22 06:11:21 2010
getInverterData(1024)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 0D 80 00
00000050: 02 00 54 00 2E 46 00 FF 2F 46
00000060: 00 61 88 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 79 bytes
cmd=1
PacketLength=97
SPOT_OPERTM : 38334.742 (h) Fri Jan 22 06:11:23 2010
SPOT_FEEDTM : 36745.090 (h) Fri Jan 22 06:11:23 2010
SUSyID: 113 - SN: 2100250486
Energy Production:
EToday: 11.114kWh
ETotal: 26302.342kWh
Operation Time: 38334.74h
Feed-In Time : 36745.09h
getInverterData(2)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 0E 80 00
00000050: 02 80 53 00 1E 25 00 FF 1E 25
00000060: 00 82 8E 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 74 bytes
cmd=1
PacketLength=92
SPOT_PDC1 : 1888 (W) Fri Jan 22 06:11:24 2010
getInverterData(4)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 0F 80 00
00000050: 02 80 53 00 1F 45 00 FF 21 45
00000060: 00 30 41 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 91 bytes
cmd=8
PacketLength=109
Received 18 bytes
Received 11 bytes
cmd=1
PacketLength=29
SPOT_UDC1 : 146.26 (V) Fri Jan 22 06:11:24 2010
SPOT_IDC1 : 12.914 (A) Fri Jan 22 06:11:24 2010
SUSyID: 113 - SN: 2100250486
DC Spot Data:
String 1 Pdc: 1.888kW - Udc: 146.26V - Idc: 12.914A
String 2 Pdc: 0.000kW - Udc: 0.00V - Idc: 0.000A
getInverterData(8)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 10 80 00
00000050: 02 00 51 00 40 46 00 FF 42 46
00000060: 00 08 96 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 91 bytes
cmd=8
PacketLength=109
Received 18 bytes
Received 43 bytes
cmd=1
PacketLength=61
SPOT_PAC1 : 1809 (W) Fri Jan 22 06:11:24 2010
SPOT_PAC2 : 0 (W) Fri Jan 22 06:11:24 2010
SPOT_PAC3 : 0 (W) Fri Jan 22 06:11:24 2010
getInverterData(16)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 41 00 3F 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 7D 31 80
00000050: 00 02 00 51 00 48 46 00 FF 55
00000060: 46 00 9E 3F 7E
65 Bytes sent
getPacket(1)
Received 18 bytes
Received 91 bytes
cmd=8
PacketLength=109
Received 18 bytes
Received 91 bytes
cmd=8
PacketLength=109
Received 18 bytes
Received 33 bytes
cmd=1
PacketLength=51
SPOT_UAC1 : 230.41 (V) Fri Jan 22 06:11:24 2010
SPOT_UAC2 : 0.00 (V) Fri Jan 22 06:11:24 2010
SPOT_UAC3 : 0.00 (V) Fri Jan 22 06:11:24 2010
SPOT_IAC1 : 7.853 (A) Fri Jan 22 06:11:24 2010
SPOT_IAC2 : 0.000 (A) Fri Jan 22 06:11:24 2010
SPOT_IAC3 : 0.000 (A) Fri Jan 22 06:11:24 2010
getInverterData(256)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 41 00 3F 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 7D 32 80
00000050: 00 02 00 51 00 3F 26 00 FF 3F
00000060: 26 00 27 FE 7E
65 Bytes sent
getPacket(1)
Received 18 bytes
Received 79 bytes
cmd=1
PacketLength=97
SPOT_PACTOT : 1809 (W) Fri Jan 22 06:11:24 2010
SUSyID: 113 - SN: 2100250486
AC Spot Data:
Phase 1 Pac : 1.809kW - Uac: 230.41V - Iac: 7.853A
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.809kW
getInverterData(32)
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 41 00 3F 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 A0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 7D 33 80
00000050: 00 02 00 51 00 57 46 00 FF 57
00000060: 46 00 CF DB 7E
65 Bytes sent
getPacket(1)
Received 18 bytes
Received 79 bytes
cmd=1
PacketLength=97
SPOT_FREQ : 49.99 (Hz) Fri Jan 22 06:11:24 2010
SUSyID: 113 - SN: 2100250486
Grid Freq. : 49.99Hz
SUSyID: 113 - SN: 2100250486
Current Inverter Time: 22/01/2010 06:11:21
Inverter Wake-Up Time: 21/01/2010 18:42:37
Inverter Sleep Time : 22/01/2010 06:11:24
ExportSpotDataToCSV()
********************
* ArchiveDayData() *
********************
startTime = 5D30EBE0 -> 19/07/2019 00:00:00
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 E0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 14 80 00
00000050: 02 00 70 B4 EA 30 5D 34 3C 32
00000060: 5D 5D 14 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 46 bytes
cmd=1
PacketLength=64
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 E0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 15 80 00
00000050: 02 20 70 B0 44 17 5D B0 17 44
00000060: 5D D9 FB 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 46 bytes
cmd=1
PacketLength=64
**********************
* ArchiveMonthData() *
**********************
startTime = 5D19E7B0 -> 01/07/2019 13:00:00
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 E0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 16 80 00
00000050: 02 20 70 B0 44 17 5D B0 17 44
00000060: 5D E7 78 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 46 bytes
cmd=1
PacketLength=64
SUSyID: 113 - SN: 2100250486
======
ExportMonthDataToCSV()
There is no data to export!
Reading events: 2019-Jul-01
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 40 00 3E 03 71 DA 7D 1A 00
00000010: 5C F5 15 25 80 00 01 00 7E FF
00000020: 03 60 65 09 E0 71 00 76 47 2F
00000030: 7D 5D 00 00 7D 5D 00 9D D8 00
00000040: 37 00 00 00 00 00 00 17 80 00
00000050: 02 10 70 00 4D 19 5D 80 2B 42
00000060: 5D 34 1D 7E
64 Bytes sent
getPacket(1)
Received 18 bytes
Received 46 bytes
cmd=1
PacketLength=64
ExportEventsToCSV()
logoffSMAInverter()
--------: 00 01 02 03 04 05 06 07 08 09
00000000: 7E 3B 00 45 03 71 DA 7D 1A 00
00000010: FF FF FF FF FF FF 01 00 7E FF
00000020: 03 60 65 08 A0 FF FF FF FF FF
00000030: FF 00 03 7D 5D 00 9D D8 00 37
00000040: 00 03 00 00 00 00 18 80 0E 01
00000050: FD FF FF FF FF FF AA AE 7E
59 Bytes sent
Fri Jul 19 17:30:25 2019: INFO: Done.
The issue here is the time of your inverter:
Current Inverter Time: 22/01/2010 06:11:21
You can try to adjust it with SBFspot -settime
Unfortunately this doesn’t always work. In that case you will need Sunny Explorer for this task
When the time is correct, PVO upload will work instantly.
Ok thanks a lot! I think this might be the last few meters before the long-desired goal…
EDIT:
I finally managed to change the inverter time using Sunny Explorer:
Current Inverter Time: 20/07/2019 17:50:50
Still it’s not uploading anything!!!
Here is the new output from your last command (too large text had to paste somewhere else):
EDIT2:
YES!! It worked.
Forgot to mention that I had to run sbfspot-config again, because I thought I was using the wrong inverter (I have 2 inverters which are connected via BT with each other). Then after updating that config plus changing the inverter time with the Explorer, I had to again replace the upload daemon with your new compiled one. Maybe this wrong inverter plus wrong inverter time caused all this trouble…
Now its finally working:
[18:07:50] INFO: Uploading 30 datapoints, starting with 20190720,06:10,36485803,0 => OK (200)
[18:08:30] INFO: Uploading 30 datapoints, starting with 20190720,08:40,36486209,312 => OK (200)
[18:09:30] INFO: Uploading 30 datapoints, starting with 20190720,11:10,36487629,720 => OK (200)
[18:10:30] INFO: Uploading 30 datapoints, starting with 20190720,13:40,36492108,2532 => OK (200)
[18:11:31] INFO: Uploading 24 datapoints, starting with 20190720,16:10,36497609,1752 => OK (200)
Perfect!
Maybe SBFspot should stop when the inverter time is way out of sync.
Apparently the data seems to miss half of the output I believe. The daily outputs do not come near the peak of my system. I maybe think that he is really just taking the data from one inverter only and not from both.
I always thought with the NetID that both inverters are always connected and merge their data.
How can I check that?
And is there an option in sbfspot to get data from both inverters and merge them into one system here on pvoutput?
Cheers
Data gets never merged, but will be stored in the db as separate data for each inverter.
Two important things to collect data coming from 2 inverters (See also explanation in SBFspot.cfg)
NetID should be higher than 1 (According to your logfile, yours is at 1 - SMA netID=01)
In SBFspot.cfg, MIS_Enabled=1 (This is for Bluetooth only)
So at least the NetID is wrong (You’ll have to open the 2 inverters to change the NetID)
At PVoutput side you should have 2 systems defined, 1 for each inverter (You can do it with 1 system but you’ll have to merge the data at your side when uploading. This is not recommended, PVoutput can do that for you with a 3th parent system. See data aggregation
At last, configure SBFspotUploadDaemon to map each inverter serial number with a PVO child system
PVoutput_SID=SerialNmbrInverter_1:PVoutput_System_ID_1,SerialNmbrInverter_2:PVoutput_System_ID_2
Success!
Hoi,
Het lijkt er op dat de SBFSpotUploadDaemon speciaal voor buster niet gedownload kan worden. De link leidt nergens naartoe…
Ik heb de RPI4 met Buster opnieuw geïnstalleerd en krijg de UploadDaemon niet aan depraat vanwege CURL_OPENSSL_3 fout.
Hoop dat je me kunt helpen.
Groet,
Adri
I’m running Buster on my raspberry and installed SBFspot 3.5.2 via the installer script. I get the error shown above:
Jan 18 11:47:34 uthus SBFspotUploadDaemon[16066]: /usr/local/bin/sbfspot.3/SBFspotUploadDaemon: /usr/lib/arm-linux-gnueabihf/libcurl.so.4: version `CURL_OPENSSL_3' not found (required by /usr/local/bin/sbfspot.3/SBFspotUploadDaemon)
I saw the link to the new updated uploader deamon but I’m already running 3.5.2. Should I still download the new version linked above?
Yes, the precompiled binaries are for stretch with curl 3
Thanks!
Works great now. First data uploaded.
I too have exactly the same problem.
I have Raspberry Buster freshly installed on a Model 1 Rev. B board. I ran sbfspot-config without error which installed SBFspot 3.5.2 and it runs OK. When I start the UploadDaemon I get the message below
/usr/local/bin/sbfspot.3/SBFspotUploadDaemon: /usr/lib/arm-linux-gnueabihf/libcurl.so.4: version `CURL_OPENSSL_3’ not found (required by /usr/local/bin/sbfspot.3/SBFspotUploadDaemon)
After this I tried sudo apt-get install libcurl3-dev
but this made no difference. Reading this post I notice for others with the same problem SBF has “recompiled the daemon for Raspbian - Buster” and put it in the following location -
Is this URL still supposed to be available because I can’t locate it in GITHUB?
Thanks
Downloaded it using wget, copied it into the same dir as the spotupload daemon and did chmod +x 33 on the file and it gave the following error -
/usr/local/bin/sbfspot.3/33: line 1: syntax error near unexpected token newline' /usr/local/bin/sbfspot.3/33: line 1:
<!DOCTYPE html>’
Thanks
You downloaded some HTML code instead of daemon executable. Are you logged on at github?
I originally tried to use wget to transfer the file direct to the raspberry because when I open the browser in the gui the box grinds to a halt. When that didn’t work I downloaded the file to Windows, put it on a usb stick, plugged it into the raspberry and copied it over.
It all now works fine.
Thank You
Hi there,
Same problem for me - also on Buster.
Have followed a couple of threads from above:
Any clues guys? - got a feeling I’m really close (but not quite!!
pi@raspberrypi:/usr/local/bin/sbfspot.3 $ ls -al
total 1912
drwxr-xr-x 2 root root 4096 Apr 18 10:49 .
drwxr-xr-x 3 root root 4096 Apr 17 19:58 …
-rw-r–r-- 1 root root 35855 Apr 17 19:58 date_time_zonespec.csv
-rwxr-xr-x 1 root root 184 Apr 17 19:58 daydata
-rwxr-xr-x 1 root root 193 Apr 17 19:58 monthdata
-rwxr-xr-x 1 root root 371176 Apr 17 19:58 SBFspot
-rw-r–r-- 1 root root 2444 Apr 17 19:58 SBFspot.cfg
-rw-r–r-- 1 root root 1530 Apr 17 19:58 SBFspotUpload.cfg
-rwxr-xr-x 1 root root 108572 Apr 18 10:49 SBFspotUploadDaemon
-rw-r–r-- 1 pi pi 108572 Apr 18 2020 SBFspotUploadDaemon_buster
-rwxr-xr-x 1 root root 116824 Apr 17 19:58 SBFspotUploadDaemon.old
-rw-r–r-- 1 root root 265 Apr 17 19:58 SBFspotUpload.service
-rw-r–r-- 1 root root 195494 Apr 17 19:58 TagListDE-DE.txt
-rw-r–r-- 1 root root 187635 Apr 17 19:58 TagListEN-US.txt
-rw-r–r-- 1 root root 197938 Apr 17 19:58 TagListES-ES.txt
-rw-r–r-- 1 root root 201422 Apr 17 19:58 TagListFR-FR.txt
-rw-r–r-- 1 root root 196124 Apr 17 19:58 TagListIT-IT.txt
-rw-r–r-- 1 root root 190204 Apr 17 19:58 TagListNL-NL.txt
pi@raspberrypi:/usr/local/bin/sbfspot.3 $ sudo systemctl status SBFspotUpload
● SBFspotUpload.service - SBFspot Upload Daemon
Loaded: loaded (/usr/local/bin/sbfspot.3/SBFspotUpload.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Sat 2020-04-18 10:52:29 AEST; 3min 42s ago
Process: 451 ExecStart=/usr/local/bin/sbfspot.3/SBFspotUploadDaemon (code=exited, status=203/EXEC)
Main PID: 451 (code=exited, status=203/EXEC)
Apr 18 10:52:29 raspberrypi systemd[1]: Started SBFspot Upload Daemon.
Apr 18 10:52:29 raspberrypi systemd[451]: SBFspotUpload.service: Failed to execute command: Permission denied
Apr 18 10:52:29 raspberrypi systemd[451]: SBFspotUpload.service: Failed at step EXEC spawning /usr/local/bin/sbfspot.3/SBFspotUploadDaemon: Permission denied
Apr 18 10:52:29 raspberrypi systemd[1]: SBFspotUpload.service: Main process exited, code=exited, status=203/EXEC
Apr 18 10:52:29 raspberrypi systemd[1]: SBFspotUpload.service: Failed with result ‘exit-code’.
pi@raspberrypi:/usr/local/bin/sbfspot.3 $
I guess you need to stop/disable the service frist.
doh - perfect, thanks for that!