TFM IOT – Home automation. Part 1 . Introduction

A project with simple requirements is beautiful . However simple requirements might turn into hard to achieve implementations . This is the case in this home automation project.
Requirement for this project is simple … automate everything
in the house

  • Lights
  • Shades
  • Music and video
  • Heating / ventilation
  • Air quality
  • Security

What exactly we are trying to achieve :

  • Control any device in the house remotely
  • Monitor and graph all sensors
  • Take action if events are happening in t
    he house
  • Have a secure, simple and  beautiful user interface so anyone can use
  • WIFI everything
  • Take action by using scenarios

So in this article series we will try to come up with a complete solution that will fulfill all requirements. And we will take it one device at a time

TFM IOT Home automation Part 2 – How smart a lamp can be ?

A simple lamp. How much intelligence can we add to a simple lamp  ? Well that depends …

What we can control?

  • We can power on and power off the lamp.

What we can measure?

  • Power consumption
  • Check if the light bulb needs to be replaced

On first iteration we will power on and power off.

The results:

To put things one step forward we need to be have all the controls from all the devices across the house in one single place ( a central hub for the house and be able to control it from anywhere )


Cloudera CDH5 adding mysql drivers to sqoop

I installed a Cloudera hadoop CDH5 cluster ( 4 mchines )  and started to play with it .

However soon i ran into a weird problem. When i tried to import some data from mysql using sqoop i realized that the mysql drivers weren’t installed .

Installation was done using parcels . So i after reading a lot of documentation i realized that the directory where i was supposed to put the mysql jar is:


I used mysql-connector-java-5.1.30-bin.jar .

If the file is not there … It wont be deployed .

How to reset a error in bind zone serial number

If you misstype the serial number in a bind zone file you might be in a lot of trouble . Especially if you misstype it like this:
2014300101 instead of 2014030101 . Yet there is a way to fix it:

According to the docs :
Add to the current serial number 2147483647 and rndc reload, then put the correct serial and rndc reload again.

About events

How NOT to take part in the events:

  1. If you want to win, don’t bother.
  2. If you think events are something you should get, because you are kewl, don’t bother.
  3. If you think that prizes in events are for free, you’re wrong and don’t bother.
  4. If you want to take part in event just to bitch at prizes, DO NOT bother.
  5. If you think that the hints should give you precise walkthrough, guess what? – don’t bother!
  6. If you are not used to use the content of you head to the purposes Mother Nature created it – don’t bother!
  7. If you’re not able to read and understand hints – don’t bother!
  8. If you think you’re too 1337 for events, don’t bother!

How NOT to host an event:

  1. If you think that everything will go as you planned, you’re wrong.
  2. If you think that everybody will be happy with prizez, you’re wrong.
  3. If you think contesters will understand your hints and follow them, you’re wrong.
  4. If you hope to hear a ‘thank you’, you’re optimists.
  5. If you are not ready to read complaints, bitching and ‘This should be done this way, not as it was’, contests are not for you.

How to take part in the events:

  1. If you want to take part in the event for fun, not prizes. You’re precious, hope you will do it each time.
  2. If you do use your brain, read hints and do not whine – hope you will take part in all events.
  3. If you’re able to have fun without getting prize – :thumbs up:
  4. If you are able to give sensible critic with good arguments, I bet contest holders will love you.

How to host an event:

  1. Be ready for frustration.
  2. Be ready for bitching.
  3. Be ready for disappointment.
  4. Be ready for nobody understanding your hints.
  5. Be ready for huge costs.
  6. Be ready for everything going wrong.
  7. You know what? SCREW it, go and have a beer with friends. It’s surelly better idea.