MQTT Mysql script

The current setup is as follows

Linux ubuntu (lamp)

Mosquitto mqtt broker is installed

Mysql with tables already there

What i need is some code, that can act as a bridge and take values sent from a unit over mqtt and put in a mysql database, and the other way around as well, meaning when a command is sent over mqtt from a unit, it should pull values of this unit from the database and put it in a reply on the same topic.

This must be setup on a live server, and has to be relatively easy to configure, regarding topics to listen etc.

This should be fairly simple to do if you know what you are doing, this should really be a 2-5 hour job max, since there is a lot of examples of this on the internet, and you are more than welcome to use any of them.

Some examples:

Data from mqtt to mysql:

[login to view URL]

Pull data from mysql and sent over mqtt:

[login to view URL]

Main requirement:

Solid knowledge of MQTT and Mysql

You are able to start RIGHT NOW! if you are not simply dont bid.

Apache Linux MQTT MySQL Shell Script

Prosjekt-ID: #15788898

Om prosjektet