MQTT Mysql script

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

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

Project ID: #15788898

About the project

3 proposals Remote project Active 6 years ago

3 freelancers are bidding on average $37 for this job

tarunwadhwa85

Hello, I have worked on a lot of projects involving MQTT. I have done similar projects like sending data from Nodemcu to Mysql database. Please have a look at my profile. Relevant Skills and Experience MQTT Python Pr More

$55 USD in 1 day
(5 Reviews)
4.3