jbroo Posted December 11, 2023 Share Posted December 11, 2023 (edited) So, after various DIY attempts to monitor my Axpert inverter, I settled on using SolPipLog, which is great for monitoring live data via MQTT, using a Raspberry Pi. I use that in conjunction with the HomeHabit app on my Android device. It allows me to monitor various inverter stats in real time, and also to control some functions (such as charge profile, equalization on demand, etc.). However, the one thing that neither SolPipLog or HomeHabit offer is historical data via graphs/charts. Although SolPipLog does export to EMONCMS, this is no longer free and setting up a self-hosted instance is quite painful. I really wanted to have some sort of historical data available, so I could see trends (or check why the fans are running - did we have load shedding or is it just hot? ). This prompted me to write my own software, which logs the MQTT topic data to a SQLite database, and fetches it into a Highcharts graph on demand. I got it working but got a lot more involved than I expected, so the end result is MQTT DB Logger Grapher, which is reasonably customizable, and while it's developed for inverter and power monitoring, it can be configured to log and graph any MQTT data. Feel free to download and use with SolPipLog or any other MQTT device monitoring software. Desktop web view: Mobile web widget in HomeHabit: Edited December 11, 2023 by jbroo HedgeSlammer, JaseZA and system32 3 Quote Link to comment Share on other sites More sharing options...
jbroo Posted December 20, 2023 Author Share Posted December 20, 2023 Version 1.1.0 now available. Quote Link to comment Share on other sites More sharing options...
system32 Posted December 20, 2023 Share Posted December 20, 2023 (edited) Nice. Once the mqtt data is in SQLite , you should be able to graph the data with Grafana. telegraf is also able to persist mqtt data to a database. In my case, I also used a python app to save mqtt to a database. I did try telegraf, but the python code was already written. I found that using Docker really helps to run the services. Edited December 20, 2023 by system32 jbroo and iiznh 2 Quote Link to comment Share on other sites More sharing options...
jbroo Posted December 20, 2023 Author Share Posted December 20, 2023 (edited) Thanks. I had tried the Grafana route but also found it tedious and complicated to get working. I settled on Highcharts since it basically runs itself. The end user needs to do minimal configuration, which was part of my goal. Edited December 20, 2023 by jbroo Quote Link to comment Share on other sites More sharing options...
jbroo Posted December 21, 2023 Author Share Posted December 21, 2023 13 hours ago, system32 said: Nice to see some familiar software there I also run Pihole on the same Pi to keep my network clean. Why not add Zerotier, then you can use your Pi as your DNS server wherever you are (and access your LAN remotely)? system32 1 Quote Link to comment Share on other sites More sharing options...
system32 Posted December 21, 2023 Share Posted December 21, 2023 I use wireguard for VPN. Pihole does the dns, dhcp jbroo 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.