CODEWITHSUNDEEP
mysqlpluginsmqttmosquitto
Phoste
Phoste

Reputation: 1209

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 found this https://github.com/jpmens/mosquitto-auth-plug but my english is not good enough to understand it thoroughly... I think it is only to store persistent message for the broker to resend them later. Am I right ?

Thanks

Upvotes: 4

Views: 19416

Answers (1)

hardillb
hardillb

Reputation: 59608

The mosquitto-auth-plugin uses the database to store username/password and ACL information, not message content.

Writing some code to store messages in a database from any MQTT broker is relatively simple.

There are several approaches:

  1. You could write a small java/python/nodejs application to do it using one of the MQTT libraries for a given language.
  2. You could use something like Node-RED to create a flow that will write messages to the database.
  3. You could use the HiveMQ broker instead of Mosquitto which has a plugin mechanism that supports storing messages in a database.

Upvotes: 9

Related Questions