{"id":35,"date":"2022-11-06T13:23:11","date_gmt":"2022-11-06T12:23:11","guid":{"rendered":"https:\/\/www.zecevic-ninja.com\/?p=35"},"modified":"2022-11-06T13:25:12","modified_gmt":"2022-11-06T12:25:12","slug":"storing-opendtu-data-in-influx-db","status":"publish","type":"post","link":"https:\/\/www.zecevic-ninja.com\/?p=35","title":{"rendered":"Storing OpenDTU data in Influx DB"},"content":{"rendered":"\n

Motivation<\/h1>\n\n\n\n

I just bought Solar panel set. And i wanted to monitor everything, but looking at prices of monitoring equipment costs 150 or more \u20ac i decided to look up for cheaper solution. So everything i needed costed me around 20\u20ac.<\/p>\n\n\n\n

How to connect everything<\/h1>\n\n\n\n

To star this i would like to say that I am using my infrastructure, and everything is self hosted in my network. So there are maybe some security issues and some similar things, but to be honest there are only inside network, and as it is not available from outside, and guests uses other network that can not communicate with my own network i have decided to ignore this for now.<\/p>\n\n\n\n

My network is based on Mikrotik Routers and APs, configured with CAPsMAN. And server is inside network, connected with cable. Basic hardware is Celeron J1900 with 4 GB RAM. There are more stuff running on that machine. CPU is around 0.20 and Ram about 1.5 GB used. So hardware requirements are really small. And everything is running on Docker Containers.<\/p>\n\n\n\n

OpenDTU<\/h2>\n\n\n\n

Introduction<\/h3>\n\n\n\n

I am using Firmware Version \/ Git Hash: 13b22de<\/p>\n\n\n\n

I will not write here much. You can read here everything: https:\/\/github.com\/tbnobody\/OpenDTU<\/a><\/p>\n\n\n\n

Basically i build the hardware, purchased ESP32 board and NRF24L01+ radio board from links on GitHub. Wired everything and flashed ESP32, had some issues, had to change some board config. In My case i had to change IRQ pin to 2. You can see this directly on board.<\/p>\n\n\n\n

[env:generic]\nboard = esp32dev\nbuild_flags = ${env.build_flags}\n    -DHOYMILES_PIN_MISO=19\n    -DHOYMILES_PIN_MOSI=23\n    -DHOYMILES_PIN_SCLK=18\n    -DHOYMILES_PIN_IRQ=2\n    -DHOYMILES_PIN_CE=4\n    -DHOYMILES_PIN_CS=5\n<\/code><\/pre>\n\n\n\n
After that I was able to connect to Inverter and i got data.<\/p>\n\n\n\n
Configuration to send data to mosquitto<\/h3>\n\n\n\n
This can work after you have installed and configured mosquitto<\/p>\n\n\n\n
You have to enable MqTT<\/p>\n\n\n\n
You need to enter hostname where the data is send to, and port.<\/p>\n\n\n\n
Should look something like this:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
mosquitto<\/h2>\n\n\n\n
I used mosquitto as MQTT broker. In my case i used it as container. As i like to use containers i configured evertything using contaners on my server. <\/p>\n\n\n\n
I used version 2.0.15<\/p>\n\n\n\n
Path i have used are:<\/p>\n\n\n\n