This week Facebook open sourced a project called osquery, which offers the ability to access low-level operating system information through simple SQL queries (more precisely SQL as understood by SQLite). More information for how to navigate through the tables can be found in the github page.

Installing/building osquery in Linux (in my case Ubuntu 14.04 LTS) is as follows:

git clone https://github.com/facebook/osquery
cd osquery
make deps

Testing the project:   make test

Deploying and running it:  make install

make deps will take care of installing everything you need to compile osquery.

If you have any errors in your source list make deps will end with errors and osquery will not be installed, because the used packages are not available. Therefore make sure that you have the latest packages and don’t get any errors in the source.list:  sudo apt-get update  (also  sudo apt-get upgrade).  In case of errors, you can fix the source.list by editing:  sudo gedit /etc/apt/sources.list

Here is another good tutorial on installing and using osquery.

Upgrade VMware vSphere

I just managed to upgrade VMware vSphere 5.1 to 5.5. It was really easy and very effective process. First I upgraded the vCenter Server by downloading the latest vCenter Server Appliance and exchanging it with the old one. The step by step process is described here. Then I upgraded the ESXi Server 5.1 to 5.5 from the console by just following the few steps described here. After dowloading the update in zip file, copy it to the ESXi host, connect through sshand execute in the console :

esxcli software vib install -d /vmfs/volumes/<your_volume>/update-from-esxi5.5-5.5_update01.zip

Webinars & Lectures

SDSC is hosting a series of webinars on various interesting topics here. My favourite till now is

Similarly UCSD CSE are providing recordings of distinguished lectures (DLS) here.