Author: linuxgeek

Getting Started With The Kankun Small K / KK-SP3

Out of the box I recently purchased a couple of wifi switches. Specifically the Kankun Small K. Very reasonable, compared to others out there, for dipping your toes into the “smart home” world. Once they...

Kankun KK-SP3 Wi-Fi Smart Socket Hacked

Kankun KK-SP3 is a $20 Wi-Fi smart socket that can be controlled via iOS and Android app. But one person created a Kankun community on Google+ to try to hack the device and control...

How to Find Default Gateway in Linux

A gateway is a node or a router that acts as an access point to passes network data from local networks to remote networks. There are many ways to find out your gateway in...

MySQL – Get all sundays in a month

To  get all the Sundays or Saturdays or Mondays you can use the following MySQL code Sunday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL ROW DAY))=1 Monday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL ROW DAY))=2 Tuesday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL ROW DAY))=3 Thursday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL...