Hello. I am new to the world of Node-Red and could use some help setting it up for our facility. From what I have read so far it seems like it should work for this application. I have approx 40 machines I need to collect various points of data from through out the day. Some Data points include: […

I highly recommend taking a look at Mosquitto then. If all of your machines submit essentially the same data, including the press ID, and a well chosen MQTT topic, you may only need a single MQTT node, a fairly simple function to construct your SQL query and a single db access node [image]

[image] kwalt: I have Mosquitto running in linux but Im not seeing it show up on the manage pallet so I can add it to Node-red. If you have a mosquitto broker on the same machine as Node-red you can connect to it using the standard mqtt-in and mqtt-out nodes. If it's on another machine in you…

Hi @kwalt , if you're looking to implement Node-RED at scale, FlowFuse may be worth looking into. We were founded by the creators of Node-RED to address needs like security, scalability, reliability, etc. when using Node-RED in production. I'd be happy to see where we can potentially add value to y…

Thanks for the link. Im going to be running some test back and forth on connectivity at least to see if this even works. Ill reach out if FlowFuse is a route I want to try and take!

I now have the MQTT form the PLC and the MQTT node communicating with each other. I can send some test data from the PLC to the MQTT in node and see it on the debug, but all the data points need to be sent in 3 separate payloads from the PLC because there are only so many lines available per payload…

Here is a pic of the PLC MQTT Client properties page [MQTT prop]

[image] kwalt: combine the three payloads into one did you try the join node ?

I did but either it didnt work or I didnt set it up properly. But I want to say the join node would be for if I had three separate mqtt nodes each sending a payload. Then the join would be able to combine them, rather than one node sending three payloads. I could be mistaken though

Feed the output of the MQTT node into a debug node and show us what the three messages look like.

[image] kwalt: one node sending three payloads if they had their own unique 'topics' it should work, share the output of MQTT node as @Colin requested. there is a screenshot in your post, but difficult to read. I see that three messages are coming a second apart, (is it possible to attach a …

Node-RED

Node-RED Forum

PLC machine data sent Via MQTT to Node Red Then to SQL Database

General

Colin 1 October 2024 12:16 26

Add an MQTT In node subscribing to the message coming in on MQTT, then use that message to trigger a mysql node to run the appropriate SELECT query.

Topic		Replies	Views
Input multiple sensor outputs into mysql General	13	1977	16 November 2020
Read from mysql db Dashboard	54	17580	23 December 2018
MQTT data to a mySQL to display data on public website General	14	3582	20 March 2022
Could not save PLC output data from mqtt node to MySQL Industrial	14	305	31 May 2024
Node and MySQL data logging General	17	1669	7 May 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

PLC machine data sent Via MQTT to Node Red Then to SQL Database

Related topics