Tuesday, August 20, 2019

Penang Smart Parking Project

Penang Smartparking project fails:

https://www.malaymail.com/news/malaysia/2019/08/20/penangs-rm115m-smart-parking-system-hits-snag-contractor-told-to-show-cause/1782368

https://www.malaysiakini.com/news/488714


The sensors:
http://www.turboes.com/en/h-col-123.html

http://www.reallin.com/iot-technology/iot-device/magnetism-detector-with-lora-technology.html

https://www.thethingsnetwork.org/marketplace/product/tbs-200


The IOT technology:
https://www.youtube.com/watch?v=6WMzRrmMjQU


My initial impression:
It uses proprietary devices and proprietary standards. Needs to lay down its own LoraWAN network for the TBS-200 sensors to connect. Uses its own proprietary long range radio networks. Uses apps for mobile phones. Google Play has apparently rejected the app. Only iOS is available. That all adds up to the high implementation costs of RM115 million.

Should use:
Internet which is already available and wifi hotspots for long range communication. Also, should build mobile phone browser apps - to avoid the hassle of getting Google and Apple's approval.

Monday, August 5, 2019

Camera projects


Visual Capturing with OV7670 on Arduino :

https://create.arduino.cc/projecthub/techmirtz/visual-capturing-with-ov7670-on-arduino-069ebb


Lelong STElectronics : Arduino OV7670 VGA Camera Module


Cytron:

Instructables:
https://www.instructables.com/id/OV7670-Without-FIFO-Very-Simple-Framecapture-With-/

ESP-32
https://www.youtube.com/watch?v=U5uvl6kDFJY


Nodemcu with ESP32-cam:

https://www.youtube.com/watch?v=FkTg-Nm2LQc   [ building the car ]
https://www.youtube.com/watch?v=HedMwVT6J3M   [ adding the ESP-32 cam ]

https://blog.naver.com/renucs/221440067950   [ building the car ]

https://blog.naver.com/renucs/221393078919   [ adding the ESP-32 cam ]

https://www.lelong.com.my/esp32-cam-wifi-bluetooth-development-board-ov2640-camera-module-sgrobot-208732495-2020-10-Sale-P.htm   [ SGrobot selling ]

USB connect to ESP32-Cam
https://www.youtube.com/watch?v=U5uvl6kDFJY

https://www.lelong.com.my/cp2102-usb-2-0-to-ttl-uart-module-serial-converter-stelectronics-214438917-2020-08-Sale-P.htm   [ Lelong selling CP2102 ]


ESP32-Cam surveillance camera project
https://www.youtube.com/watch?v=36p9To2hfak

Bare conductive

https://www.bareconductive.com/make/building-a-capacitive-proximity-sensor-using-electric-paint/

Sunday, August 4, 2019

(HY000/1130): Host 'localhost' is not allowed to connect to this MariaDB server

When phpmyadmin cannot connect:



How to fix:

https://www.youtube.com/watch?v=NSX-ib2aMDQ

edit file:

C:\xampp\mysql\bin\my.ini

by adding:

skip-grant-tables

to [ mysqld ]  as follows:


# The MySQL server
[mysqld]
skip-grant-tables
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql

Saturday, August 3, 2019