Store messages from Mosquitto MQTT broker into SQL Database
I need a server which is able to setup the Mosquitto MQTT Broker, this server have to be handle MQTT connections with clients and capable to save MQTT data (payload) into database.
The server also act as a File Server and Web Server where I can upload photos via HTTP Post.
After reading some posts and research, it looks like the Synology NAS having all the features for me to setup the said server. Therefore I decided to choose the Synology DS216j NAS for this project.
How to create webpages & setup website using the CMS
This is my experience about how to create webpages & setup my personal website using the CMS (Content Management System) software. My website is 4 years old now, during this time, I learn how to upgrade my website, improve the webpages loading speed, remove virus/malware from website, and a lot more.....SEO, Google Analytic, Google Adsense, Google Captcha, Google PageSpeed Insights, Google Search Console.
Makeblock 3-in-1 mBot Ranger Robot Kit
Makeblock 3 in 1 mBot Ranger Robot Kit is a three-in-one STEM (Science, Technology, Engineering & Mathematics) Educational robot kit which offers the ability to create a Robot Tank, Three-Wheeled Racing Car and a Self-Balance Car. You can program and control the mBot Ranger via iPad, tablets or laptop.
I get my mBot Ranger Robot Kit from GearBest, the price of the kit is $134.87.
Lua_2W_Motor: 2 wheel motor library for Lua running on wireless router
This is a motor library for Lua running on wireless router which flashed with OpenWrt firmware. It allows a wireless router control the motors without using micro-controller. This library works on any dual-full-bridge driver such as L298.
Each motor require two GPIOs for controlling, therefore 2 motors will use up 4 GPIOs. Most of the wireless router may not have enough GPIO to control the motors, but you can use other pin on the router such as the LED pin, this require to unload the leds_gpio module.
Compiling OpenWrt from source
To compile OpenWrt from source, you need a computer running Linux such as Ubuntu. If you are like me and don't have a Linux computer, you can still use your Windows computer to compile OpenWrt.
In order to run Linux on a Windows, you must install virtual machine on you computer. Virtual machines allow you to run any operating system in a window on your desktop, I'm using the free VirtualBox for my case, please read here for details.
Running Ubuntu On Windows
I'm a Windows user and I always play with Linux on embedded system. Therefore I need a computer which is effective exchange of information between Windows OS & Linux OS.
This article provides information on how to install Ubuntu on Oracle VirtualBox with the following features:
- Run both Linux(Ubuntu) and Windows together.
- Sharing clipboard content between OS
- File sharing between OS
- Internet connection sharing
Lua_GPIO: GPIO Read/Write Functions for Lua
This is a very simple GPIO read/write functions for Lua running on linux-based embedded system, it is based on Arduino digital input/output syntax.
Only four functions are available: pinMode, digitalWrite, digitalRead & delay
Update: Added pin_direction_status() function on 16 Oct 2015
Ubidots-Lua: OpenWRT router + Ubidots = Real-time data monitoring
In my projects I needed a tool to monitor data in real time, the data is captured by a microcontroller and uploaded to the web using a wireless router. Initially I was trying to use yeelink since it is in chinese langguage and yet I'm a Malaysian Chinese.
One month ago, I have tried with Ubidots, there were a few things that caught my eye.
BASH Dropbox Uploader on OpenWRT
This guide is to provide detailed information on how install BASH Dropbox Uploader to a wireless router flashed with OpenWRT. Dropbox Uploader is a BASH script written by Andred Fabriz that allows you to upload, download, delete files (and more) from Dropbox.
Setup a Raspberry Pi PHP web server

- Raspberry pi running Raspbian OS
- SSH client such as PuTTy
- If you like to use GUI ( Graphical User Interface), WinSCP is preferred
- Netscanner software for IP address searching