json-scada
json-scada copied to clipboard
riclolsen
ESP32-MQTT-JSONSCADA- MONGODB flow
Dear companion,
Here am working on project , My Sensor data (Temperature and Speed ) get from module and its connected through mqtt protocol. now so I want to see that data on JSON-SCADA Display Viewer which is in .SVG file .
In SVG file I created my Own layout Shape and also i done Tag . Now the
Que 1. how my .svg file and inside Tag will communicate to my Real time Data with help of MQTT Protocol Driver.
Que 2 : I need some details about Json-Scada and MQTT protocol connection. below i attached image reference
que 3 : How to set configuration between MongoDB , MQTT Protocol Connection and tag ID
Que 4: Should i add MongoDB Library In my Arduino Code or Not for storing data ? Or only Mqtt config is Enough ? Like just giving mqtt broker details in my arduino code as im getting my data in mqtt broker frome there I'm confused about sending data to json scada
hope i explained you as much understandable if not pls excuse and am expecting your valid reply...:)
First try to connect the device to a MQTT broker and then JSON-SCADA to the broker. After configuring connection, restart the service JSON_SCADA_mqttsparkplugclient. If you do not see data, check logs.
To see mqtt logs do this: Go to windows services and stop JSON_SCADA_mqttsparkplugclient Or do in cmd as admin net stop JSON_SCADA_mqttsparkplugclient cd C:\json-scada\src\mqtt-sparkplug \json-scada\platform-windows\nodejs-runtime\node.exe index.js 1 3
Does your device has Sparkplug B? If not do not use spBv1.0 topics.
My device(esp32) is connected to Mqtt broker and then broker is receiving the data.From there to how to connect with json scada?
https://github.com/riclolsen/json-scada/blob/master/src/mqtt-sparkplug/README.md
Basically put the broker address in endpointURLs, and list topics in topics parameter. Username and password if necessary.
Restart the service JSON_SCADA_mqttsparkplugclient.
Given like that only what u mentioned, now If json scada is connected to mqtt broker where have to see that ? In MongoDB vice should i do any Configuration ??
Better look first at the logs.
To see mqtt logs do this: Go to windows services and stop JSON_SCADA_mqttsparkplugclient Or do in cmd as admin net stop JSON_SCADA_mqttsparkplugclient cd C:\json-scada\src\mqtt-sparkplug \json-scada\platform-windows\nodejs-runtime\node.exe index.js 1 3
Odd unexpected error on MongoBD changestream! I am not sure what can be the problem. Please retry. Uninstall/Reinstall JSON-SCADA if necessary. If possible, post your protocolConnections contents from mongodb.
The log should be something like this C:\json-scada\src\mqtt-sparkplug>\json-scada\platform-windows\nodejs-runtime\node.exe index.js 1 3 2023-08-08T21:44:28.792Z - Config - Config File: ../../conf/json-scada.json 2023-08-08T21:44:28.797Z - Config - {json:scada} - MQTT-Sparkplug-B Client Driver Version 0.1.5 2023-08-08T21:44:28.798Z - Config - Instance: 1 2023-08-08T21:44:28.798Z - Config - Log level: 3 2023-08-08T21:44:28.799Z - MongoDB - Connecting to MongoDB server... 2023-08-08T21:44:28.838Z - MongoDB - Connected correctly to MongoDB server 2023-08-08T21:44:28.854Z - Connection - Connection Number: 1200 2023-08-08T21:44:28.859Z - Auto Key - Initial value: 1200000022 2023-08-08T21:44:28.859Z - Redundancy - Process Inactive 2023-08-08T21:44:28.865Z - Redundancy - Node activated! 2023-08-08T21:44:33.874Z - Redundancy - Process Active 2023-08-08T21:44:33.886Z - MQTT Client - Creating client... 2023-08-08T21:44:33.887Z - MQTT Client - Try connecting to mqtt://test.mosquitto.org:1883 2023-08-08T21:44:34.629Z - SparkplugClientLib - packetreceive: {"cmd":"connack","retain":false,"qos":0,"dup":false,"length":2,"topic":null,"payload":null,"sessionPresent":false,"returnCode":0} 2023-08-08T21:44:34.632Z - SparkplugClientLib - Client has connected 2023-08-08T21:44:34.632Z - MQTT Client - Event: Connected to broker 2023-08-08T21:44:34.632Z - MQTT Client - Subscribing topic: spBv1.0/Edge Nodes/#
Getting like this.
Now where to see the data coming from my device in json scada?
Connection to mongo and broker are ok now. Remove spBv1.0 from topics list. Put there your topic filter (or # for all topics). Leave publishTopicRoot and groupId empty or it will publish JSON-SCADA data to the broker.
here im getting data from mqtt broker to mongodb so , do i need postgres or can i directly send these json payload to display viewer to observe changes in svg file?
You have to use the tags created in mongodb by the MQTT driver. Use the tags to markup objects in the SVG files. See example SVG files and demo tags.
Demo Tags in admin page and MongoDB real-time data ID , all related to opc-UA only. Is there any example tag for Mqtt (spark plug) ? If mean can u please share example!! Also still not clear about MongoDB data how to Fetch in json Scada !!
One more doubt , We need just 12 set of parameters only , so can we edit the schema as per our customise or we have use as per demo only ???
When the data is already loaded by the protocol driver to MongoDB it doesn't matter the protocol anymore, values acquired will flow to SVG as requested identified by the "tag" field from the mongo document. In fact, the demo SVG presents IEC-104 data only, not OPC. So, it is just a matter of studying the demo SVG files. I didn't quite get your last question. You can use JSON-PATH syntax to extract properties in the "topics" parameter or use "topicsScripted" to extract the data from a topic with a script. Each individual data value must be in a distinct tag to be displayed in the SVG. See https://github.com/riclolsen/json-scada/blob/master/src/mqtt-sparkplug/README.md
This is specific to displays created for the Brazilian SCADA SAGE. It is possible to convert those displays to SVG and animate in JSON-SCADA.
I have detected problems with the MQTT driver in version 0.29, now fixed in version 0.30!