Open Source SCADA: Node-RED, OPC UA & MySQL on Raspberry Pi 

Tks !!!

Thanks man, that one got me. More than one object same name, different group.

Yes, the 750 PFC & couplers are very easy to communicate with rPi & Node RED using modbusTCP if you don't want to use OPC.

hello Kurt has a tutorial for this? communicate with rPi & Node RED using modbusTCP

Thanks for asking, I posted the parts list in the description. The PFC100 is a new model in three configuratons; 750-8100, 750-8101 & 750-8102. Here is a brochure: www.wago.com/infomaterial/pdf/60277522.pdf

No

Hello Juan, One way, is you can add an ui template node with embedded php & js which queries the db and puts it in a table. If you want to graph this data, check out jQuery. Maybe I will do a video on this at some point, it's a common question.

many thanks Kurt, I will try. great videos you have, I will try with OPC server too. Regards

Hello Kurt, I'm also looking for the same, I like your video, I do suggest to add a link to your code that you used to setup your flow.

node-red-dashboard

add "npm install node-red-dashboard " to linux command

The OPC Server is actually on the WAGO PLC. This eliminates running an IO server like in the old days.

Hello, Sometimes it is helpful to test the insert message with some fake data so that you can verify the statement and database is correct. Once you can insert some data, then you know your table is setup correctly to receive actual data. I hope this makes sense! I try to be methodical when working through setting up a system, so I do that out of habit.

I did not notice those errors, but it still worked for me.

1: In [1:17] how does it find the ip address. For me, the Endpoint field does not show the ip address. 2: How do you connect to raspberry from your pc? if the raspbeery ethernet connection is already connected to PLC? Is it through wireless adapter? It doesn't seem that there is any wireless adapter connected to raspberry.

The rPi connection is through Ethernet. Node RED is running on the rPi's web server, and the OPC-UA is using the same ethernet connection. Sounds like you might have two different subnets.. make sure all devices are on the same subnet. For example 192.168.1.xxx

Thank you for your reply. I am aware that between RPi and PLC is the ethernet connection. But how do you access RPi from your PC. How do you set up the configurations on the RPi, in terminal. From what I know, you have to be connected to your RPi either wireless or ethernet in order to access the RPi with Putty. Is it Wireless connection between PC and RPi? Have you turned RPi to wireless AccessPoint? Or the RPi is connected to network wirelessly, and that's how you connect to it from your PC?

If you type raspi-config on the rPi and in the menu's enable SSH, they you can use putty to connect to it. This is the easiest way to work with the Pi over a network (headless). You can watch this video to see how this is done. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vflPGqcXJkY.html

-- Objects Root -- Press to update: Browse {{items.item.displayName.text}}: {{items.item.nodeId}}

Yes, you are right to point that out, thanks for commenting. NoSQL databases like MongoDB would be a better option for large datasets & better performance. I show SQL here because a lot of applications are already using and are familiar with them as a point of reference. I plan on doing more video's showing database integration soon.

[{"id":"a81bdd10.44b31","type":"OpcUa-Browser","z":"7b2dca67.ca8aa4","endpoint":"84ef077e.612178","item":"","datatype":"","topic":"","items":[],"x":337,"y":155,"wires":[["643cf4a5.245ddc"]]},{"id":"643cf4a5.245ddc","type":"ui_template","z":"7b2dca67.ca8aa4","tab":"f54a6156.a82de","name":"","group":"OPC","order":1,"format":" -- Objects Root -- Browse {{items.item.displayName.text}}: {{items.item.nodeId}} ","storeOutMessages":false,"fwdInMessages":false,"x":332,"y":74,"wires":[["a81bdd10.44b31"]]},{"id":"5ad77031.ac7e6","type":"OpcUa-Client","z":"7b2dca67.ca8aa4","endpoint":"84ef077e.612178","action":"read","time":10,"timeUnit":"s","name":"","x":588,"y":298,"wires":[["aabffab1.1142a8"]]},{"id":"3d62fcad.5b9ab4","type":"OpcUa-Item","z":"7b2dca67.ca8aa4","item":"ns=4;s=|var|WAGO 750-8202 PFC200 CS 2ETH RS.Application.GVL.wtest","datatype":"String","value":"","name":"","x":338,"y":300,"wires":[["5ad77031.ac7e6"]]},{"id":"4009b83f.1f4888","type":"inject","z":"7b2dca67.ca8aa4","name":"","topic":"","payload":"true","payloadType":"bool","repeat":"","crontab":"","once":false,"x":120,"y":300,"wires":[["3d62fcad.5b9ab4"]]},{"id":"aabffab1.1142a8","type":"debug","z":"7b2dca67.ca8aa4","name":"","active":true,"console":"false","complete":"true","x":818,"y":297,"wires":[]},{"id":"84ef077e.612178","type":"OpcUa-Endpoint","z":"7b2dca67.ca8aa4","endpoint":"opc.tcp://192.168.4.20:4840","login":false},{"id":"f54a6156.a82de","type":"ui_tab","z":"7b2dca67.ca8aa4","name":"Home","icon":"dashboard","order":"1"}]

Much obliged!

Kurt Braun ä

sql injection will never die

You raise a valid concern regarding SQL injection attacks. You might be surprised to know that many commercial SCADA systems also use SQL for the historian! This is probably why it is very common that these are secured behind a firewall and/or a VPN.

at least he's trying to get the concepts over ( at Mach 5 though ). Fair criticism, but it can be made without all the exclamation marks.

Are you using a WAGO PFC with UPC/UA enabled?

No I am using a PLC X20CP1382 from B&R Automation. And yes I have enabled the OPC UA on the PLC

By the way, after inserting the code into template and by pressing deploy, a error box pops up saying that there is an error in the code. I checked every character four times, but is looks exactly the same as your code:

-Objects root - Press to Update: Browse {{items.item.displayName.text}}: {{items.item.nodeId}}

You misspelled align on line 12, try this: -- Objects Root -- Browse {{items.item.displayName.text}}: {{items.item.nodeId}}