Issue with sbfspot-config

Will test now

Install finished but I think sqlite is stuffed…

pi@pi:~ $ sudo /usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv
SBFspot V3.5.0
Yet another tool to read power production of SMA solar inverters
© 2012-2018, 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’
Thu Nov 1 20:36:41 2018: INFO: Starting…
sunrise: 05:56
sunset : 19:21
Connecting to Local Network…
Initializing…
SUSyID: 125 - SessionID: 833679268 (0x31B0EFA4)
Inverter IP address: 192.168.1.35 found via broadcastidentification
Logon OK
SUSyID: 181 - SN: 304963383
Device Name: STP 5000TL-20 383
Device Class: Solar Inverters
Device Type: STP 5000TL-20
Software Version: 02.55.03.R
Serial number: 304963383
SUSyID: 181 - SN: 304963383
Device Status: Ok
SUSyID: 181 - SN: 304963383
Device Temperature: 0.0°C
SUSyID: 181 - SN: 304963383
GridRelay Status: Information not available
SUSyID: 181 - SN: 304963383
Pac max phase 1: 5000W
Pac max phase 2: 5000W
Pac max phase 3: 5000W
SUSyID: 181 - SN: 304963383
Energy Production:
EToday: 29.779kWh
ETotal: 32684.883kWh
Operation Time: 18434.29h
Feed-In Time : 18088.25h
SUSyID: 181 - SN: 304963383
DC Spot Data:
String 1 Pdc: 0.000kW - Udc: 0.00V - Idc: 0.000A
String 2 Pdc: 0.000kW - Udc: 0.00V - Idc: 0.000A
SUSyID: 181 - SN: 304963383
AC Spot Data:
Phase 1 Pac : 0.000kW - Uac: 0.00V - Iac: 0.000A
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.000kW
SUSyID: 181 - SN: 304963383
Grid Freq. : 0.00Hz
SUSyID: 181 - SN: 304963383
Current Inverter Time: 01/11/2018 20:36:42
Inverter Wake-Up Time: 01/11/2018 06:00:58
Inverter Sleep Time : 01/11/2018 19:24:36
[2018-11-01 20:36:42.287] Error: Can’t open SQLite db [/home/pi/smadata/SBFspot. db]: ‘unable to open database file’


  • ArchiveDayData() *

startTime = 5BD9A750 -> 01/11/2018 00:00:00


  • ArchiveMonthData() *

startTime = 5BDA5E20 -> 01/11/2018 13:00:00


  • ArchiveMonthData() *

startTime = 5BB17190 -> 01/10/2018 11:00:00
Reading events: 2018-Nov-01
Thu Nov 1 20:36:42 2018: INFO: Done.

In the /home/pi/smadata folder there is no DB. Wondering if I should edit the db location in usr/local/bin/sbfspot.3/sbfspot.cfg?

Strange… in a previous post I see

Copying files…
SBFspot.db exists
Checking database…
Schema Version=1
Can’t open SQLite db [/home/pi/smadata/SBFspot. db]: ‘unable to open database file’

There is a space between SBFspot. and db – Can you check this?

I think that’s my copy and paste…

I noticed the .DB file was sitting in the /usr/local/bin/sbfspot.3 folder. I moved it to the location in the .cfg file and the error has gone away.

Was that the wrong thing to do?

No, that’s OK.
It should be there automatically. Have to recheck it.
Does it upload now?

Yep. Brilliant. Thank you so so much!!!

Just trying to work out if inverter temp and voltage should be coming through…

Since you have a lot of missing data and you’re a pvoutput donator you can upload older data (SMA inverter holds around 60 days of history)
Run SBFspot once manually:

/usr/local/bin/sbfspot.3/SBFspot -v -ad62 -am12 -ae12 -sp0 -nocsv -finq

The upload daemon will send it automatically (will take some time)

Your a legend!! Thanks so much!!

Hi guys,

I have the same error during installation of sbfspot.
My sbfspot was not running for almost two month and now I want to get it back up again.
Already did the upload of the old data, but always get the “‘different number of SID/Serial” error at the end of the installation.
Any more recommendations?

Thank you very much!

digiveit

@digiveit
While running SBFspot, the configurator detects an unequal number of serial numbers (inverters) and PVO systems. For each inverter you need one PVO system ID

I have only one inverter.

OK, and one SystemID?
What do you fill in for “PVoutput Configuration”?
Please post the log file

Here is the log after running sudo curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config | sudo

bash
SBFspot Configuration Tool V1.2.1
Running on Raspberry Pi 4 Model B Rev 1.1
Checking whiptail… Installed.
architecture=armhf
Raspbian GNU/Linux 10 (buster)
username=pi
userhome=/home/pi
Minimum SBFspot version supported by this tool is 3.5.0
Request to install latest version (3.9.3)
Searching for existing configuration(s)…
Creating new config…
Scanning for Bluetooth devices, please wait…
Saving defaults to /var/tmp/sbfspot.3/sbfspot.defaults… Done
Performing some checks before installation… Done
Downloading https://github.com/sbfspot/sbfspot/releases/download/V3.9.3/sbfspot-mariadb-arm-linux-buster.tar.gz
Copying files…
Checking database…
Schema Version=1
Configuring SBFspot… Done
Running SBFspot…
SetPlantTime returned an error: -1
getSoftwareVersion returned an error: -1
getTypeLabel returned an error: -1
Creating cron jobs…

SBFspot

*/5 6-22 * * * /usr/local/bin/sbfspot.3/daydata
55 05 * * * /usr/local/bin/sbfspot.3/monthdata
NetID=02
PVO enabled, configuring upload daemon…
Device Serial(s):
Copying daemon…
Different number of SID/Serial
Found 1 SIDS
Found 0 S/N

It seems like the serial no. can´t be received from the inverter.
I checked the password for user and installer with Sunny Explorer and it´s ok.

Run SBFspot in debug mode:
/usr/local/bin/sbfspot.3/SBFspot -d5 -v5 -nocsv -nosql

Hi,
I’ve the same problem as digiveit. I have 2 inverters. During the setup of pvoutput, sbfspot is unable to detect the serial of the inverter(s). I also tried the setup with only one inverter but i gives me the same error.

This is my output (for 2 inverters)
curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config | sudo bash
SBFspot Configuration Tool V1.2.1
Running on Raspberry Pi 3 Model B Plus Rev 1.3
Checking whiptail… Installed.
architecture=armhf
Raspbian GNU/Linux 11 (bullseye)
username=pi
userhome=/home/pi
Minimum SBFspot version supported by this tool is 3.5.0
Request to install latest version (3.9.5)
Searching for existing configuration(s)…
Reading defaults from /var/tmp/sbfspot.3/sbfspot.defaults… Done
Saving defaults to /var/tmp/sbfspot.3/sbfspot.defaults… Done
Performing some checks before installation… Done
Downloading https://github.com/sbfspot/sbfspot/releases/download/V3.9.5/sbfspot-sqlite-arm-linux-bullseye.tar.gz
Copying files…
SBFspot.db exists
Checking database…
Schema Version=1
Saving existing SBFspot.cfg… Done
Configuring SBFspot… Done
Running SBFspot…
Creating cron jobs…

SBFspot

*/5 6-22 * * * /usr/local/bin/sbfspot.3/daydata
55 05 * * * /usr/local/bin/sbfspot.3/monthdata
NetID=03
PVO enabled, configuring upload daemon…
Device Serial(s):
Not replacing daemon (unchanged)
Different number of SID/Serial
Found 2 SIDS
Found 0 S/N

This is the output for : sudo /usr/local/bin/sbfspot.3/SBFspot -v -finq -nocsv
Then sbfspot is able to find the serials

SBFspot V3.9.5
Yet another tool to read power production of SMA solar inverters
© 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’
Wed Jun 15 21:13:49 2022: INFO: Starting…
sunrise: 05:29
sunset : 21:56
Connecting to 00:80:25:A4:9D:DE (1/10)
Initialising…
SUSyID: 125 - SessionID: 829937949
SMA netID=03
SUSyID: 131 - SN: 2120194911
SUSyID: 99 - SN: 2003606913
BT Signal=0.0%
Logon OK
SUSyID: 99 - SN: 2003606913
Device Name: SN: 2003606913
Device Class: Solar Inverters
Device Type: SB 2100TL
Software Version: 12.12.205.R
SUSyID: 131 - SN: 2120194911
Device Name: SN: 2120194911
Device Class: Solar Inverters
Device Type: SB 2500HF-30
Software Version: 02.30.07.R
Packet status: 21
Packet status: 21
SUSyID: 99 - SN: 2003606913
Device Status: Ok
SUSyID: 131 - SN: 2120194911

Any idea’s?

It’s a confirmed bug

V3.9.4 is not impacted. Install with:
curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config | sudo bash -s 3.9.4

1 Like

Thanks!!! Now he’s uploading. :grinning: