Hi, I am running SBFSpot for some years now and works perfectly. A few days ago I downloaded old data from my inverter. After that No new data is comming in PVOutput. Please help.
Systemtime checked with Sunny Explorer.
sudo systemctl status SBFspotUpload
ā SBFspotUpload.service - SBFspot Upload Daemon
Loaded: loaded (/usr/local/bin/sbfspot.3/SBFspotUpload.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2022-10-27 14:17:13 CEST; 1 weeks 6 days ago
Main PID: 290 (SBFspotUploadDa)
CGroup: /system.slice/SBFspotUpload.service
āā290 /usr/local/bin/sbfspot.3/SBFspotUploadDaemon
okt 27 14:17:13 raspberrypi systemd[1]: Started SBFspot Upload Daemon.
journalctl|grep SBFspotUpload
nov 09 18:49:23 raspberrypi sudo[15250]: pi : TTY=pts/0 ; PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
nov 09 19:17:58 raspberrypi sudo[15513]: pi : TTY=pts/0 ; PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
pi@raspberrypi:/ $ cd /home/pi/smadata/logs
But how do i read my logfile?
With the command ls nothing showes up
See LogDir variable in SBFspotUpload.cfg
Do i Understand right, I type: LogDir In folder /home/pi/smadata/logs/ ?
No, LogDir shows where logfiles are storedā¦
cat /usr/local/bin/sbfspot.3/SBFspotUpload.cfg|grep LogDir
LogDir=/var/log/sbfspot.3After journalctl|grep SBFspotUpload
I Get:
nov 15 21:21:03 raspberrypi sudo[3088]: pi : TTY=pts/0 ; PWD=/home/pi ; USER=root ; COMMAND=/bin/systemctl status SBFspotUpload
Where SBFspotUpload is in RED
In the logs dir are the folowing files:
Desktop Downloads Music Public sbfspot.3 scripts Templates V3.4.0.tar.gz
Documents MagPi Pictures SBFspot SBFspot.cfg smadata udo systemctl status SBFspotUpload Videos
The only line in SBFspot.cfg is:
BTAddress=00:80:25:A4:52:A5
What can I try next?
Please help me?
Thatās almost impossibleā¦ and if it is, your config is messed up.
The logfiles should be in this folder
Iām a noob with raspberry. This is what i get with what you wrote above:
pi@raspberrypi:~ $ cat /usr/local/bin/sbfspot.3/SBFspotUpload.cfg|grep LogDir
LogDir=/var/log/sbfspot.3
pi@raspberrypi:~ $ ls
Desktop Music sbfspot.3 Templates
Documents Pictures SBFspot.cfg udo systemctl status SBFspotUpload
Downloads Public scripts V3.4.0.tar.gz
MagPi SBFspot smadata Videos
pi@raspberrypi:~ $ cd /usr/local/bin/sbfspot.3/ls
-bash: cd: /usr/local/bin/sbfspot.3/ls: Bestand of map bestaat niet
pi@raspberrypi:~ $ cd /var/log/sbfspot.3
pi@raspberrypi:/var/log/sbfspot.3 $ ls
BergaandeMaas_20181203.log BergaandeMaas_202210.log
BergaandeMaas_20181204.log BergaandeMaas_20221101.log
BergaandeMaas_20181205.log BergaandeMaas_20221102.log
BergaandeMaas_20181206.log BergaandeMaas_20221103.log
BergaandeMaas_20181207.log BergaandeMaas_20221104.log
Until:
BergaandeMaas_20221027.log then it stopped.
What do I need to do now?
The logfiles are old ones, so SBFspot is not running every 5min. Run it manually to see what happens:
/usr/local/bin/sbfspot.3/SBFspot -v5 -finq -nocsv -nosqlGood Idea, thanks. The result is below.
pi@raspberrypi:~ $ /usr/local/bin/sbfspot.3/SBFspot -v5 -finq -nocsv -nosql
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: -v5 -finq -nocsv -nosql
Reading config ā/usr/local/bin/sbfspot.3/SBFspot.cfgā
Configuration settings:
BTAddress=00:80:25:A4:52:A5
Password=
MIS_Enabled=0
Plantname=BergaandeMaas
OutputPath=/home/pi/smadata/%Y
OutputPathEvents=/home/pi/smadata/%Y/Events
Latitude=52.37
Longitude=4.9
Timezone=Europe/Amsterdam
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=0
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
Sat Nov 26 10:35:10 2022: INFO: Startingā¦
sunrise: 08:21
sunset : 16:33
Connecting to 00:80:25:A4:52:A5 (1/10)
Initializingā¦
SUSyID: 125 - SessionID: 832223463 (0x319AB8E7)
SMA netID=01
Serial Nr: 7EF5DEC0 (2130042560)
BT Signal=71.4%
Sat Nov 26 10:35:11 2022: CRITICAL: Logon failed. Check āUSERā Password
pi@raspberrypi:~ $
And I forgot to thank you for helping: So many thanks for you time and help!
I have an idea: I also installed a newer version of Sunny Explorer on the windows pc that I used to read the old data. With this new version I needed to change the standard password 0000 to a new one.
Seeing the last line, I think that could be the reason. What do you think? And if it is how can I change the user password in SBFspot?
Thatās indeed your problem: you changed the inverter password without changing it in /usr/local/bin/sbfspot.3/SBFspot.cfg
Youāll need admin rights to change it:
sudo nano /usr/local/bin/sbfspot.3/SBFspot.cfg
Look for the line Password=0000
Change it to the new password, save the file and exit (ctrl-O ctrl-X)
Then you can get the missing data with
/usr/local/bin/sbfspot.3/SBFspot -v5 -finq -ad30 -am2 -ae2
The uploader will do the rest (but only for the last 14 days, unless youāre a PVoutput donator)
Glad to help make it working again.
Thanks, did all these things and donated haha. Now it seems to function again.
Many thanks.
1 Like