Is there a way to store Mosquitto payload into an MySQL database for history purpose?
I am using Mosquitto MQTT broker and I would like to store every published message into a MySQL database without creating a client and subscribing to # wildcard.
I am using Mosquitto MQTT broker and I would like to store every published message into a MySQL database without creating a client and subscribing to # wildcard.
I’m kinda new to react and trying to understand how to make MQTT work with it.
I am creating a project using node.js with mqtt.js and mosquitto broker.
In mosquitto config file, I have setup a pwfile, aclfile to control which topic can be accessed by which user.