Jonathan.VC

I often have the need to encrypt my traffic when using a public Internet wifi, like at a university or a coffee shop. After scouring the web, I tried a few different tunnels, but this one really worked.

This tutorial is aimed at people using OS X on a Mac, but could easily work for any other operating system.

ssh -D 8080 -f -C -q -N username@serverIP

If you have a non-standard SSH port, just add -p to the end of the command.

First, I setup this command as a /usr/bin command so I don’t have to remember it.

sudo nano -w /usr/bin/createtunnel


This will allow you to just enter “createtunnel” at the command line on your computer and it will start the process.

After you run the command it will prompt you for your SSH password so you can login to your server. This is the first part of the process.

The second part is ensuring that your wifi device is using the proxy port that you just setup.

Next, go to your device and then go to Proxies. Then select SOCKS Proxy and enter the 8080 port which is part of the command above. You can adjust this port to be whatever you want it to be, I just use 8080 for simplicity.

After you click OK, your connection will now be tunneling your traffic through your encrypted SSH connection.

If you have any comments or suggestions, please let me know in the comments below.

I recently had the need to get all the unique values in cells within a column, by comma delimited.

Here’s the function I used:

=query(index(unique(trim(transpose(split(join(" ",A1:A&","),","))))),"select* where Col1 <>'' ")

I put his in B1 and it listed all the unique values from A:A and it automatically updates as you change the data in A:A

Klout is a transformational service. It’s helped people get jobs, but it’s also worked against people when applying for a job. Klout has helped people get cool perks, and it’s helped brands connect with their most influential users.

While this is all pretty cool, I find that it doesn’t understand language intent very well.

I signed into Klout today to see that Klout had added about 15 new topics for me. The last one was GoDaddy.

Hold up. I’ve said nothing positive about GoDaddy … ever. Everything I’ve posted about GoDaddy has been negative. Why would Klout think I’m influential about GoDaddy?
[Read more...]

I saw this posted on Facebook and felt so compelled to share it, here it is.

Robert recently posted on Google+ about his photowalk with the Lytro camera. It’s amazing to finally see true innovation taking place in digital cameras.