You will probably need to clear the retained messages in mqtt broker. The first ones you created will have been created incorrectly because you didn’t have a connection to the inverter. It picks up the serial number incorrectly without an inverter connection.
You can use mqtt Explorer to do that.
If you don’t already have it installed, this addon is available. Or you can download it directly and install on your PC.
Clear the messages under topics HAOS-SBFspot and Homeassistant/sensor/sbfspot
Then create the sensors again.
It will make the sensors in the list under mqtt_data(mqtt sensor items)
I’m new to HA and a little bit blocked
I’m working on raspberry 4
HA version 9.2
HAOS-SBFspot - Current version: 2022.10.3
MariaDB - Current version: 2.5.1
Questions :
1- I have this error msg in mariadb which I don’t understand.
[15:09:12] ERROR: Got unexpected response from the API: There is already a MySQL service in use from core_mariadb
2 - in the habuild/hassio-addons there is a sql creation file for the DB…
How/Where do I apply this file on mariadb ?
3 - HAOS-SBFspot is connecting successfully to one inverter but is there a way to put 2 ?
What’s the syntax ?
hmm ok so for a quickfix…
I updated the test version I already had in the repo with HAOS-SBFspot.
So if you install MultiINV-SBFspot you should be able to run them concurrently.
This one has a 5 second offset to avoid BT hardware interference, hopefully.
You should just need to change your BT address and Plantname accordingly for the second inverter.
You can still use secrets if you name them as for example !secret BTaddress_2 and !secret SBFplantname_2
You need to manually enter that into options or else it will try and use the first inverter defaults.
The other settings like mqtt, mariadb, pvoutput should be the same as the first inverter connection wise.
I am not sure how mariadb will handle the second inverter and consequent pvoutput upload…
Let me know.
You may need to use a second DB and pvoutput account. Not sure. It should in theory combine both inverters into the one DB and upload a merged/combined figure to pvoutput.
The plantname and serial number should be enough to make unique mqtt messages.
(I had to manually test that seeing as I don’t have 2 inverters, so not 100% it will work.)
All addons are containers. > I’m learning everyday
Can you open an issue at the repo here > DONE
Rebooting maria and HA didn’t remove the ERROR : Got unexpected response from the API: There is already a MySQL service in use from core_mariadb
I’ll try MultiINV-SBFspot as soon as I have the full process working with one inverter already.
Full process not working atm.
Mariadb SBFspot tables seems updated…I see my inverter SN and monthdata filled.
I see no error in SBFspot logs.
but still not updloading to PVoutput.
Where/What should I look at in the logs/config for that process ?
Client null sending CONNECT … DISCONNECT > does that part refer to DB connect of PVoutput connect ?
in the sbfspot config, I have my API Key and SID defined (uploadlog level stayed to info)
I haven’t updated any yaml… that might be the problem.
I’ve installed file editor (as visual studio doesn’t seem supported in raspbery)
I can only access /config… when i log in SSH i see (addons backup config media share ssl)
my /config/configuration.yaml
I don’t see any sbf files
You won’t need to put anything in configuration.yaml.
Unless you really want to make the mqtt sensors by hand.
Mqtt and maria/pvoutput are unrelated.
Mqtt will work without mariadb being installed.
Client null etc is mqtt related. Connect and disconnect is normal. You can create the auto discovery sensors now if you like. Just set the options from No to create.
Set it back to No after you make then(not really necessary, just a good habit)
MariaDB and pvoutput are related. Pvoutput relies on a db to send the data from. So if you are still having issues with mariadb, that could be related. You have done a host reboot right? Not just restarted HA and the mariadb addon.
Settings > system >hardware > 3dots top right > reboot host
Don’t forget to open the port in mariadb 3306
The very bottom log setting in HAOS-SBFspot options is for pvoutput logs, set it to debug until you get pvoutput working.
Make sure your SID includes your inverter serial number.
Thx for the container explaination
I discovered the command :
docker container ls
docker caintainer diff CONTAINER
Helps understanding what you’ve said
Is there a ‘easy’ way to browse those files ?
Reboot :
Thx I indeed was doing HA reboot and addon restart.
Don’t forget to open the port in mariadb 3306 >> done
ERROR: Got unexpected response from the API: There is already a MySQL service in use from core_mariadb > indeed only appears after mariadb restart
Make sure your SID includes your inverter serial number.
indeed this was not the case. Now corrected …
And tadammm Working !!
Thx a lot
Still have a lot to learn but it’s a every day chalenge
For the most part you can’t break much, that isn’t fixed by restart or reinstall of the addon.
You can check the Sbfspot and sbfspotUpload cfg files in there if you like to make sure they are correct.
the command to log into haos-sbfspot is… you need the slug name of the addon.
MultiINV will be similar.
The problem is I created a bug trying to sign the addon with codenotary. It doesn’t seem to like multi layer addons.
If you had it installed, it updated the previous version, however I had to remove the signing to allow new installs… Which means you can’t update from signed to unsigned…
I have a question, I actually use Modbus but somehow I’m interested in realizing it with SBFspot. For me, however, only the Lan veriante would come into consideration. Does this work or not?
Believe so. I had a report of it working over lan on github. You would be Ethernet user no2 as far as I know.
To clarify, this addon basically just sets up the cfg files for the underlying sbfspot binaries to use… So if sbfspot works for you elsewhere, it should also work here.
Could you give me the link for it if there is one, I’m not that much of a programming specialist. I tried it via the configuration page with Ethernet, but I always get an error that the program wants a BT address and BT password from me.
So I found something, the BT data are required. Now, however, the question arises where to get it from, because the SMA instructions indicate that BT should be deactivated as soon as a Speedwire is available.
tought mariadb had a interface of it own. I’ll try phpmyadmin.
