Beispiele: openWB Integration an Node-Red

[LutzB]

Generell sollte man immer an die Last der Systeme denken. Bei MQTT ist es best practice, nur das zu abonnieren, was man auch verarbeiten will. Macht ja auch keinen Sinn, alles zu empfangen und dann mit noch mehr Rechenzeit wieder 80% zu verwerfen.

[hominidae]

Eine MQTT-Message hat inklusive Header nur ein paar Bytes.
Ich verteile über einen Flow, die Messages auch wieder an Andere Flows weiter....will Änderungen nur an einer Stelle pflegen.
So behalte ich besser die Übersicht.
Wer will, kann natürlich auch jeweils nur Teilbäume abonnieren...leider braucht man in einem Flow immer von allem ein Bischen (PV, EVU, LP1, ..).

Mein NAS hat aber auch genug Bumms....und die Verbindung bleibt quasi Monatelang bestehen (Stichwort retain), also kommt gar nicht viel mehr, als eh benötigt würde....typisch sind 14-21 msgs ...telegraf, das parallel zu NR mithört, sendet diese in ca. 6ms an meine influxDB.

[aiole]

Interessante Standpunkte!

Ich hab's erstmal klassisch einzeln zusammengebaut. Screenshots und flow stelle ich morgen ein.
Die EVU-topics funktionieren alle, bis auf die phasenbezogenen
openWB/set/evu/WPhase1 bis 3.
Wisst Ihr, warum die nicht von oWB übernommen werden (1.9.250 nightly)?

Den MQTT-Explorer habe ich jetzt zum Überprüfen dieser topics schnell noch installiert, aber irgendwie lässt der mich nicht verbinden. Kann da etwas blockieren?

Bis morgen.

[hominidae]

...im gleichen LAN, Protokoll "mqtt" und Port 1883, kein User, kein PWD...sollte sofort gehen

[hhoefling]

Wisst Ihr, warum die nicht von oWB übernommen werden (1.9.250 nightly)?

Ja.

Die Bezug_x Scripte schreiben diese Werte in die Ramdisk
Vom dort werden sie für die Anzeige auf dem Webseiten ins MQTT übertragen
Aber nicht per "/set/.." sondern direkt in die normalen Read-Only Topics.

[aiole]

Hammer. Ihr seid echt fit. Läuft mit

Code: Alles auswählen

openWB/evu/WPhaseN

N=1...3

MQTT-Expl. teste ich morgen/heute. Ich glaube, ich Nuss wollte mich mit dem Pi-user einloggen .
GN8

[aiole]

Moin, moin,

anbei das aktuelle Ergebnis des EVU/PV-Simulators. Bitte bedenkt - ich entwickle Hardware und es ist mein erster, produktiv genutzter NR-Flow .
Der MQTT-Server muss dann noch auf die individuell geltende oWB-IP umgestellt werden.

Über VPN bekomme ich gerade die phasenbezogenen Wattwerte nicht in der Statusseite von oWB angezeigt, aber lokal ging das gestern Nacht.
update: Kommen jetzt auch. Brauchen wahrscheinlich länger.

noch offene Punkte
Die Rückkopplung (Schleife) der Slider zu den "Zählwerken" funktioniert bei meinem NR nicht, ist aber aktuell kein Drama. Ev. findet Ihr da noch eine Lösung.
Den i-Punkt würde noch eine Wh-Ermittlung, also eigenständige Integration der Gesamtleistungen von EVU und PV über die Zeit, darstellen. Da NR eventbasiert arbeitet, muss da sicher ein timer-Node eingebaut werden. Das feature wäre nur zur Demonstration des Loggingbereiches von oWB hilfreich und drängt auch nicht.

Also bis jetzt bin ich hochzufrieden und ich muss Gero zustimmen. Mit etwas Anfangssupport bietet NR eine wirklich steile Lernkurve.

VG

Code: Alles auswählen

[{"id":"893d7c73ec1062bb","type":"tab","label":"Haussimulation","disabled":false,"info":""},{"id":"a1f0aee2c57caf19","type":"ui_slider","z":"893d7c73ec1062bb","name":"","label":"HV1","tooltip":"","group":"a93f1d9ae8183a76","order":2,"width":4,"height":1,"passthru":true,"outs":"all","topic":"HV1","topicType":"str","min":0,"max":"20","step":1,"className":"","x":271,"y":102,"wires":[["a54e5917874fb4a7"]]},{"id":"dc676be568fa7f65","type":"ui_slider","z":"893d7c73ec1062bb","name":"","label":"HV2","tooltip":"","group":"a93f1d9ae8183a76","order":5,"width":4,"height":1,"passthru":true,"outs":"all","topic":"HV2","topicType":"str","min":0,"max":"20","step":1,"className":"","x":271,"y":182,"wires":[["20d2107485787090"]]},{"id":"20d2107485787090","type":"ui_numeric","z":"893d7c73ec1062bb","name":"n2","label":"","tooltip":"","group":"a93f1d9ae8183a76","order":6,"width":2,"height":1,"wrap":false,"passthru":true,"topic":"HV2","topicType":"str","format":"{{value}}","min":0,"max":"20","step":1,"className":"","x":411,"y":182,"wires":[["5e62ee48903952b6","7d96b0d7fcb863dc"]]},{"id":"a54e5917874fb4a7","type":"ui_numeric","z":"893d7c73ec1062bb","name":"n1","label":"","tooltip":"","group":"a93f1d9ae8183a76","order":3,"width":2,"height":1,"wrap":false,"passthru":true,"topic":"HV1","topicType":"str","format":"{{value}}","min":0,"max":"20","step":1,"className":"","x":411,"y":102,"wires":[["5e62ee48903952b6","341773f6c407369b"]]},{"id":"69cf50bf7a78cb0d","type":"ui_slider","z":"893d7c73ec1062bb","name":"","label":"HV3","tooltip":"","group":"a93f1d9ae8183a76","order":8,"width":4,"height":1,"passthru":true,"outs":"all","topic":"HV3","topicType":"str","min":0,"max":"20","step":1,"className":"","x":271,"y":262,"wires":[["3d68a72776b8a948"]]},{"id":"3d68a72776b8a948","type":"ui_numeric","z":"893d7c73ec1062bb","name":"n3","label":"","tooltip":"","group":"a93f1d9ae8183a76","order":9,"width":2,"height":1,"wrap":false,"passthru":true,"topic":"HV3","topicType":"str","format":"{{value}}","min":0,"max":"20","step":1,"className":"","x":411,"y":262,"wires":[["5e62ee48903952b6","b0bb0d171dc0e503"]]},{"id":"4c074778d96cca63","type":"inject","z":"893d7c73ec1062bb","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":"0.1","topic":"HV","payload":"0","payloadType":"num","x":91,"y":182,"wires":[["a1f0aee2c57caf19","dc676be568fa7f65","69cf50bf7a78cb0d","b8104298fa534818"]]},{"id":"9ef516ad0d97c733","type":"ui_slider","z":"893d7c73ec1062bb","name":"","label":"PV","tooltip":"","group":"1de0097c.41aea7","order":2,"width":4,"height":1,"passthru":true,"outs":"all","topic":"PV","topicType":"str","min":0,"max":"10000","step":"100","className":"","x":270,"y":1000,"wires":[["b1413c181f7feb40"]]},{"id":"b1413c181f7feb40","type":"ui_numeric","z":"893d7c73ec1062bb","name":"PVn","label":"","tooltip":"","group":"1de0097c.41aea7","order":3,"width":3,"height":1,"wrap":false,"passthru":true,"topic":"PV","topicType":"str","format":"{{value}}","min":0,"max":"13000","step":"100","className":"","x":410,"y":1000,"wires":[["b8104298fa534818","98d3ba873e677b62","ca5aeec98e9bf5a2","82471b486413251c"]]},{"id":"98d3ba873e677b62","type":"ui_gauge","z":"893d7c73ec1062bb","name":"","group":"1de0097c.41aea7","order":1,"width":0,"height":0,"gtype":"gage","title":"Sum PV-Leistung [W]","label":"Watt","format":"{{value}}","min":0,"max":"10000","colors":["#e6e600","#e6e600","#e6e600"],"seg1":"","seg2":"","className":"","x":1200,"y":1000,"wires":[]},{"id":"b9b122116f122c9b","type":"ui_gauge","z":"893d7c73ec1062bb","name":"","group":"0f7979aef0213eea","order":1,"width":0,"height":0,"gtype":"gage","title":"EVU Überschuss (-) / Bezug (+) [W]","label":"Watt","format":"{{value}}","min":"-13800","max":"13800","colors":["#00f900","#00f900","#ff2600"],"seg1":"100","seg2":"100","className":"","x":1240,"y":820,"wires":[]},{"id":"5e62ee48903952b6","type":"combine-statistic","z":"893d7c73ec1062bb","name":"Sum HV [A]","topic":"HV","operator":"sum","falsy":"include","defer":250,"timeout":0,"distinction":"topic","x":671,"y":182,"wires":[["66a4b6b2d48ab8de"]]},{"id":"b8104298fa534818","type":"combine-delta","z":"893d7c73ec1062bb","topic":"","topicA":"HV","topicB":"PV","name":"PV - Sum HV [W]","x":690,"y":880,"wires":[["b9b122116f122c9b","f871e67dac362860","b928ec6151731c84"]]},{"id":"66a4b6b2d48ab8de","type":"function","z":"893d7c73ec1062bb","name":"Sum HV * 230V [W]","func":"msg.payload = msg.payload * 230;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":871,"y":182,"wires":[["b8104298fa534818","2fad855ab60a8252"]]},{"id":"70df950fea525102","type":"inject","z":"893d7c73ec1062bb","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"PV","payload":"0","payloadType":"num","x":90,"y":1000,"wires":[["9ef516ad0d97c733","b8104298fa534818","341773f6c407369b","7d96b0d7fcb863dc","b0bb0d171dc0e503"]]},{"id":"f871e67dac362860","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/W","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1350,"y":760,"wires":[]},{"id":"341773f6c407369b","type":"combine-delta","z":"893d7c73ec1062bb","topic":"","topicA":"HV1","topicB":"PV","name":"PV je Phase - HV1 [A]","x":701,"y":382,"wires":[["5b8a65c32b855ccd","bd50008843ad334a"]]},{"id":"ca5aeec98e9bf5a2","type":"function","z":"893d7c73ec1062bb","name":"PV je Phase [A]","func":"msg.payload = msg.payload / 690;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":200,"y":540,"wires":[["341773f6c407369b","7d96b0d7fcb863dc","b0bb0d171dc0e503"]]},{"id":"7394e47c53a45f0b","type":"ui_text","z":"893d7c73ec1062bb","group":"0f7979aef0213eea","order":5,"width":"2","height":"1","name":"APhase1","label":"L1 [A]","format":"{{msg.payload}}","layout":"row-left","className":"","x":1161,"y":382,"wires":[]},{"id":"7d96b0d7fcb863dc","type":"combine-delta","z":"893d7c73ec1062bb","topic":"","topicA":"HV2","topicB":"PV","name":"PV je Phase - HV2 [A]","x":700,"y":540,"wires":[["b13cd30b38902fdb","de4a0ca62c4fb84b"]]},{"id":"460325faeda70ba9","type":"ui_text","z":"893d7c73ec1062bb","group":"0f7979aef0213eea","order":6,"width":"2","height":"1","name":"APhase2","label":"L2 [A]","format":"{{msg.payload}}","layout":"row-center","className":"","x":1160,"y":540,"wires":[]},{"id":"b0bb0d171dc0e503","type":"combine-delta","z":"893d7c73ec1062bb","topic":"","topicA":"HV3","topicB":"PV","name":"PV je Phase - HV3 [A]","x":700,"y":680,"wires":[["40d0239e0cb9bff8","b824e8a0886aa02d"]]},{"id":"7bfe1b699736ce34","type":"ui_text","z":"893d7c73ec1062bb","group":"0f7979aef0213eea","order":7,"width":"2","height":"1","name":"APhase3","label":"L3 [A]","format":"{{msg.payload}}","layout":"row-right","className":"","x":1160,"y":680,"wires":[]},{"id":"5b8a65c32b855ccd","type":"function","z":"893d7c73ec1062bb","name":"EVU1 [A]","func":"msg.payload = msg.payload.toFixed(2);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":921,"y":382,"wires":[["7394e47c53a45f0b","efab248c4a92106e"]]},{"id":"40d0239e0cb9bff8","type":"function","z":"893d7c73ec1062bb","name":"EVU3 [A]","func":"msg.payload = msg.payload.toFixed(2);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":920,"y":680,"wires":[["7bfe1b699736ce34","a7a90e0fb1dabbdc"]]},{"id":"b13cd30b38902fdb","type":"function","z":"893d7c73ec1062bb","name":"EVU2 [A]","func":"msg.payload = msg.payload.toFixed(2);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":920,"y":540,"wires":[["460325faeda70ba9","ed2a41d3a1404d9b"]]},{"id":"efab248c4a92106e","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/APhase1","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1381,"y":342,"wires":[]},{"id":"ed2a41d3a1404d9b","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/APhase2","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1380,"y":500,"wires":[]},{"id":"a7a90e0fb1dabbdc","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/APhase3","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1380,"y":640,"wires":[]},{"id":"b928ec6151731c84","type":"function","z":"893d7c73ec1062bb","name":"Sum EVU / 230V [A]","func":"msg.payload = msg.payload / 230;\nmsg.payload = msg.payload.toFixed(2);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":960,"y":880,"wires":[["e2f0eee128b990a1"]]},{"id":"532ee9b866c72733","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/VPhase1","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1380,"y":1080,"wires":[]},{"id":"aeb1a424aeea264b","type":"inject","z":"893d7c73ec1062bb","name":"Spannung","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"U","payload":"230","payloadType":"num","x":1070,"y":1080,"wires":[["532ee9b866c72733","bbfd1a2bdb1e9b2f","75308536b4090022"]]},{"id":"bbfd1a2bdb1e9b2f","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/VPhase2","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1380,"y":1140,"wires":[]},{"id":"75308536b4090022","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/VPhase3","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1380,"y":1200,"wires":[]},{"id":"4645a40edc232df3","type":"inject","z":"893d7c73ec1062bb","name":"Frequenz","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"f","payload":"50","payloadType":"num","x":1060,"y":1260,"wires":[["2735d00f8b4f375b"]]},{"id":"2735d00f8b4f375b","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/evu/HzFrequenz","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1380,"y":1260,"wires":[]},{"id":"2fad855ab60a8252","type":"ui_gauge","z":"893d7c73ec1062bb","name":"","group":"a93f1d9ae8183a76","order":1,"width":0,"height":0,"gtype":"gage","title":"Sum Hausverbrauch [W]","label":"Watt","format":"{{value}}","min":0,"max":"13800","colors":["#00b500","#e6e600","#ca3838"],"seg1":"","seg2":"","className":"","x":1210,"y":180,"wires":[]},{"id":"82471b486413251c","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/set/pv/1/W","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1360,"y":940,"wires":[]},{"id":"bd50008843ad334a","type":"function","z":"893d7c73ec1062bb","name":"EVU1 [W]","func":"msg.payload = msg.payload *230;\nmsg.payload = msg.payload.toFixed(0);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":921,"y":322,"wires":[["4276d881cb393384","10dbd3a6eb60449d"]]},{"id":"4276d881cb393384","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/evu/WPhase1","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1370,"y":280,"wires":[]},{"id":"10dbd3a6eb60449d","type":"ui_text","z":"893d7c73ec1062bb","group":"0f7979aef0213eea","order":2,"width":"2","height":"1","name":"WPhase1","label":"L1 [W]","format":"{{msg.payload}}","layout":"row-left","className":"","x":1160,"y":320,"wires":[]},{"id":"de4a0ca62c4fb84b","type":"function","z":"893d7c73ec1062bb","name":"EVU2 [W]","func":"msg.payload = msg.payload *230;\nmsg.payload = msg.payload.toFixed(0);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":920,"y":480,"wires":[["514904b0957664aa","b0407aae17aa7098"]]},{"id":"514904b0957664aa","type":"ui_text","z":"893d7c73ec1062bb","group":"0f7979aef0213eea","order":3,"width":"2","height":"1","name":"WPhase2","label":"L2 [W]","format":"{{msg.payload}}","layout":"row-center","className":"","x":1159,"y":478,"wires":[]},{"id":"b824e8a0886aa02d","type":"function","z":"893d7c73ec1062bb","name":"EVU3 [W]","func":"msg.payload = msg.payload *230;\nmsg.payload = msg.payload.toFixed(0);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":920,"y":620,"wires":[["fefcb20f2071a86d","85fa0da7797f1c98"]]},{"id":"fefcb20f2071a86d","type":"ui_text","z":"893d7c73ec1062bb","group":"0f7979aef0213eea","order":4,"width":"2","height":"1","name":"WPhase3","label":"L3 [W]","format":"{{msg.payload}}","layout":"row-right","className":"","x":1159,"y":618,"wires":[]},{"id":"e2f0eee128b990a1","type":"ui_text","z":"893d7c73ec1062bb","group":"0f7979aef0213eea","order":8,"width":"6","height":"1","name":"","label":"Summe EVU-Punkt [A]","format":"{{msg.payload}}","layout":"row-center","className":"","x":1200,"y":880,"wires":[]},{"id":"b0407aae17aa7098","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/evu/WPhase2","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1370,"y":440,"wires":[]},{"id":"85fa0da7797f1c98","type":"mqtt out","z":"893d7c73ec1062bb","name":"","topic":"openWB/evu/WPhase3","qos":"0","retain":"","respTopic":"","contentType":"","userProps":"","correl":"","expiry":"","broker":"c4cb83c8.1bd0c","x":1370,"y":580,"wires":[]},{"id":"a93f1d9ae8183a76","type":"ui_group","name":"Haushalt","tab":"744b5117.d18b28","order":1,"disp":true,"width":"7","collapse":false,"className":""},{"id":"1de0097c.41aea7","type":"ui_group","name":"PVA","tab":"744b5117.d18b28","order":2,"disp":true,"width":7,"collapse":false,"className":""},{"id":"0f7979aef0213eea","type":"ui_group","name":"EVU-Punkt","tab":"744b5117.d18b28","order":3,"disp":true,"width":"7","collapse":false,"className":""},{"id":"c4cb83c8.1bd0c","type":"mqtt-broker","name":"OpenWB_aiole","broker":"192.168.110.51","port":"1883","clientid":"","autoConnect":true,"usetls":false,"compatmode":false,"protocolVersion":"4","keepalive":"30","cleansession":true,"birthTopic":"","birthQos":"0","birthRetain":"false","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closeRetain":"false","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willRetain":"false","willPayload":"","willMsg":{},"sessionExpiry":""},{"id":"744b5117.d18b28","type":"ui_tab","name":"Sim Hausverbrauch / PV-Erzeug.","icon":"dashboard","disabled":false,"hidden":false}]

zu installierende Node-Red-Module:

[aiole]

Der MQTT-Explorer läuft auch Dank hominidae's-Hinweis.
Ein sehr empfehlenswertes Tool.
https://mqtt-explorer.com/

[hominidae]

...der MQTT Explorer kann auch auf die Daten der "externen" openWB, also bei in der openWB aktivierter MQTT Brücke, auf web.openwb.de zugreifen.

Protokoll: mqtt
Host: web.openwb.de
Port: 1883
encryption (tls): EIN
User / PWD: ...Login/pwd des Web-Accounts

...ein NodeRed MQTT-Node kann das natürlich auch...also kann man eine entfernte openWB auch darüber fernsteuern, zumindest überwachen.

[aiole]

Moin,
hat jemand eine Idee, weshalb bestimmte Topics nur stark verzögert von oWB übernommen werden?
Ich tippe darauf, dass sich die Festwerte VPhase1...3 und Frequenz in diesem Flow viewtopic.php?p=51188#p51188 nicht ändern und deshalb keine neuen Werte kommen. Sollte man einen zusätzlichen timer einsetzen, der den flow zu einem Event "zwingt"?
VG