MQTT, Node-RED, Linux, Apache2, MySQL, PHP, Telegram, ESP32, ESP8266, Arduino

Thread Tools Search this Thread
The Lounge What is on Your Mind? MQTT, Node-RED, Linux, Apache2, MySQL, PHP, Telegram, ESP32, ESP8266, Arduino
# 1  
Old 02-24-2020
MQTT, Node-RED, Linux, Apache2, MySQL, PHP, Telegram, ESP32, ESP8266, Arduino

I have just completed the first phase of integrating all these devices and technologies:

MQTT, Node-RED, Linux, Apache2, MySQL, PHP, Telegram, ESP32, ESP8266, and the Arduino Uno

The glue that binds all this together is MQTT. In fact, MQTT makes this kind of integration nearly trivial to do.

The "control glue' which makes all this fun, easy and fast to integrate is Node-RED (on top of MQTT). On YT, many excited people call Node-RED a "life changing technology". Well, that sound quite dramatic to me (I have seen a lot of technology come and go over the years); but on the other hand, combined with programming knowledge and MQTT, Node-RED is a bit like standing at the helm of the Starship Enterprise. It's that good.

Here is my high level "working" diagram of my current working project, which I will provide the details in subsequent post and hopefully a few YT videos.

MQTT, Node-RED, Linux, Apache2, MySQL, PHP, Telegram, ESP32, ESP8266, Arduino-mqtt_node_red_telegram_1024jpg

I am currently using this setup as follows (at a high level):
  • Monitor the health and performance of three Linux Ubuntu servers remotely (on the other side of the planet).
  • Monitor, display and act on sensor information from at least three Arduino / ESP devices (IoT devices, as some call them).
  • Display selected subsets of all those devices, the server applications and network management information as required on various quick-to-build, custom dashboards.
  • Change various LAMP application configurations (update the MySQL databases for example) using visual sliders on my iPhone (like you would when adjusting the brightness of a light).
  • Get real-time alerts on my two iPhones and also on my desktop Macs using Telegram when any "situation of interest" arises on any of the servers or IoT devices.

It works very well, and so far, nearly flawlessly. I just finished testing the core system integration today.

Unfortunately, I have some very boring non-technical paperwork which I must do, before I spend more time on this fun project, including any tech write-ups and new YT videos.

Node-RED has changed my view toward "visual programming tools" because the way I use Node-RED permits me to program in PHP, Python and bash as required on the servers, and at the same time, I can program in Javascript in Node-RED; and at the same time yet again, I can also connect all the moving parts of the system together with Node-RED.

In addition, Node-RED allows me to add and test different APIs very quickly, much more quickly than programming in IDEs or "on bare metal".

More on this later....... stay tuned.
These 2 Users Gave Thanks to Neo For This Post:
# 2  
Old 02-24-2020
Update (v0.12):
  • Added missing Node-RED development node.
  • Added missing Arduino-UNO serial node.
  • Fixed order of LAMP bullets

MQTT, Node-RED, Linux, Apache2, MySQL, PHP, Telegram, ESP32, ESP8266, Arduino-mqtt_node_red_telegram_2001jpeg
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Programming

Node-RED: Writing MQTT Messages to MySQL DB with UNIX timestamp

First, I want to thank Neo (LOL) for this post from 2018, Node.js and mysql - ER_ACCESS_DENIED_ERROR I could not get the Node-RED mysql module to work and searched Google until all my links were purple! I kept getting ER_ACCESS_DENIED_ERROR with the right credentials. Nothing on the web was... (0 Replies)
Discussion started by: Neo
0 Replies

2. Programming

Publish and Subscribe to AES-256 Encrypted MQTT Messages to Node-RED from PHP Scripts

Various Node-Red crypto modules do not work with PHP, so to send an encrypted message from a PHP script (in this case from a Ubuntu server) to Node-RED we need our own code. After a few hours of searching, testing various libs, more testing and debugging, I got this PHP to Node-RED code... (0 Replies)
Discussion started by: Neo
0 Replies

3. Infrastructure Monitoring

Using Node-RED and MQTT to Monitor Server and Application Stats

After setting up MQTT and testing some ESP8266 and ESP32 modules, where I noted that testing in Programming ESP32 (ESP-WROOM-32) as an MQTT Client Subscribed to Linux Server Load Average Messages, I was so impressed with MQTT that I installed MQTT on three different computers, instantly and... (2 Replies)
Discussion started by: Neo
2 Replies

4. Programming

ESP32 (ESP-WROOM-32) as an MQTT Client Subscribed to Linux Server Load Average Messages

Here we go.... Preface: ..... so in a galaxy far, far, far away from commercial, data sharing corporations..... For this project, I used the ESP-WROOM-32 as an MQTT (publish / subscribe) client which receives Linux server "load averages" as messages published as MQTT pub/sub messages.... (6 Replies)
Discussion started by: Neo
6 Replies

5. Programming

NodeMCU ESP8266 Blynk SSL Application for Linux Server Load Averages

Here is a useful SSL (HTTPS) application for anyone with a remote Linux server they want to keep an eye on using Blynk and the NodeMCU ESP8266. This little app also works (have tested as well) on the WeMos D1 ESP8266 Arduino board. The NodeMCU setup could not be easier, just find a... (8 Replies)
Discussion started by: Neo
8 Replies

6. Programming

Arduino-cli - Uploading to Unknown Chinese Arduino Boards using the Arduino Command Line Interface

In my further exploration of Arduino, today I decided to install the arduino-cli on my mac today. I followed the instructions for macOS but when I got to this part: arduino-cli board list I got the dreaded "Unknown" Fully Qualified Board Name... (1 Reply)
Discussion started by: Neo
1 Replies

7. Web Development

Node.js and mysql - ER_ACCESS_DENIED_ERROR

This problem has been killing me all day, and I cannot solve it. Basically, I am using node.js with the mysql module and it will not connect to the database. Here is the JS code snippet in node.js: app.get("/test", function(req, res) { var mysql = require("mysql"); var con =... (4 Replies)
Discussion started by: Neo
4 Replies

8. Web Development

about php.ini and mysql linux

I can't use mysql .How should i config the file of php.ini . the message: Fatal error: Call to undefined function mysql_errno() in /var/www/html/inc/dv_clssql.php on line 129 how should i do? please help me (2 Replies)
Discussion started by: fang_xiaoan
2 Replies
Login or Register to Ask a Question

Featured Tech Videos