Record a Screencast on Mac OS X using QuickTime X

QuickTimeA lot of the top bloggers have been using video as a medium to illustrate their posts for a long time now. Some of them use proprietary software to make screencasts and some of them just use digital cameras to shoot videos.

With Mac OS X latest incarnation, 10.6 Snow Leopard, however Apple has given everyone a chance to be in the select club of screencasting bloggers.

QuickTime X released with Snow Leopard contains a built-in feature for creating screencasts and uploading them to YouTube. Read on to find out how to make use of this awesome new capability.

Continue reading “Record a Screencast on Mac OS X using QuickTime X”

Gruml brings Google Reader to the Desktop [Mac]

GrumlRSS has changed the way content is consumed on the web. Almost every website worth it’s salt, and all blogs, including Geeky Ninja, use an RSS feed to distribute their content to the readers. Using an RSS reader

Google Reader is arguably the best and the most famous RSS reader around. The only problem is that it is a web based application. That wouldn’t really be a problem if everyone was connected 24×7 to the Internet, but if you’re not then you’re out of luck, since Google Reader doesn’t offer an offline mode, yet.

An offline mode isn’t the only thing that’s missing from Google Reader, though. A web based application run through a browser can generally not provide all the features that a desktop application can. Also, desktop applications generally are better integrated with the OS interface and thus, are easier to blend in with your workflow.

Gruml is one such Desktop application. It is a Desktop based Google Reader client that syncs with Google Reader and lets you read your RSS feeds offline.

Continue reading “Gruml brings Google Reader to the Desktop [Mac]”

How To connect to a Cisco VPN using Mac OS X 10.6

Snow LeopardCisco’s VPN solution are quite popular in the enterprise market and a lot of companies use them to provide their employees access to the company’s networks and resources when the employees are not onsite.

Most of these companies use the default Cisco client which Cisco supplies with a couple of modifications to suit their particular needs. More specifically, the configuration of this client involves creating a .pcf file which the client uses to read the settings for the specific network.

The .pcf file is a plain text only file which a couple of config options, the important of which are the VPN server address, the encrypted group password and the group name.

Mac OS X, since the last few version came with the ability to connect to L2TP and IPSec based VPNs out of the box but lacked the ability to connect to Cisco’s implementation. That has now changed with the release of Mac OS X 10.6 aka. Snow Leopard. OS X now ships with the ability to connect to Cisco based VPNs out of the box.

The only problem is that the configuration of the built in client requires a little bit of “homework” and in this post today I’ll be taking you through just that.

Continue reading “How To connect to a Cisco VPN using Mac OS X 10.6”

How to read HFS+ volumes on Windows

HFS Explorer I’ve been using an OS X Leopard (That’s 10.5) machine at work since the last few days for a project that I’m working on. I’ve been a Unix user for a long time so I’m pretty comfortable with the Unix side of OS X including the file system and the BSD underpinnings.

For those who haven’t used OS X, it uses a proprietary file system called HFS+ as the default file system. Because it is a proprietary file system and Apple hasn’t really released any specs for it yet, there aren’t too many utilities to read or write to HFS+ volumes (That’s what Apple calls their partitions) from operating systems other than Apple’s own.

Why would I want to do that ? Well, I normally wouldn’t … but yesterday I was in a hurry to get back home from work and needed to copy some files from the OS X machine so that I could work on them at home. What I forgot in a hurry was that the USB stick that I was using had been formatted as an HFS+ volume. I came home and plugged in the USB stick to my home PC and waited and waited for it to get recognized. Windows recognized the stick but refused to read it. That is when I realized my mistake.

I searched online for tools which would let me get my data off the flash drive and let me work on it from my Windows machine.

HFSExplorer is one such small utility designed to do  that.

You can choose to download either the Windows based Installer or the standalone zip file. I chose the zip file, downloaded and extracted the contents to a folder on my PC and plugged in the flash drive that I wanted to read the data from.


Continue reading “How to read HFS+ volumes on Windows”

How To Recover data from an iPhone backup

My sister lost her iPhone a couple of days back and with that all her contacts, notes and calender entries that she had painstakingly stored on the device.


Her only hope of getting all that important data back was the backup that she had taken a couple of days earlier and she asked me to help her out.

This was my first time dealing with an iPhone backup and I didn’t know where to get started trying to recover data from the backup.

Well, truth be told. The iPhone is not the most open among gadgets. And it isn’t easy to get your data off it. Apple has tried it’s best to hide any iPhone related information from the user’s view. And they have succeeded to an extent, atleast the primary consumers of Apple’s goods don’t really care where (or more importantly, how) the data is stored, as long as Apple provides an application to access it.

In the iPhone’s case, the application is iTunes and the only way to put this data back on to the device is to use iTunes … unless you know where to look for it.

On a computer running windows vista, the data backup is stored in the following location:

C:\Documents and Settings\USERNAME\Application Data\Apple Computer\MobileSync\Backup

Under the backup directory, you will see a directory which looks like a unique ID. This is the directory in which the backup is created, everytime you backup your iPhone using iTunes.

In this directory, you will see a number of files with the *.mdbackup extension.

The .mdbackup files are the actual backups of all the applications and settings of your iPhone. So, the first thing you should be doing is, make a backup of these files :-)

If you use an editor to view these files right now, all you’ll see is garbage, cause these are not text files. They are what Apple calls Binary plists. And to decrypt them, you ideally need a Mac and this utility.

I used the command line version of the utility since I only had console access to a mac and that worked for me.

I first copied all the *.mdbackup files, that I had collected from the iTunes backup folder, to the Mac and ran the following command to zero in on the files that actually had any useful data. I was the most interested in the Contacts data, so that’s what I searched for first.

grep ‘AddressBook’ *.mdbackup

AddressBook is the name of the application which stores, well, address book data on an iPhone. It is only named Contacts in the interface. The actual application name is AddressBook and when I searched for that string in the backup files, I got three files as a result.

I opened the first file using a text editor and it turned out to be the one I was interested in. The word AddressBook is in the beginning of this binary file and it also mentions the database name, where all the data is stored. Yay !

iphone backup

So, now to get to that data base file, we need to use the decoding utility that we downloaded earlier.

decode iphone

So, we’ve got our database file. The decode iphone utility will put it in the following folder structure


Open the database with the following command:

sqlite3 AddressBook.sqlite

and you’ll be dropped to the sqlite prompt. At this point, you need to understand the schema of this database a bit before you can proceed further. Give “.tables” command and you should see the following output.

iphone backup database tables

At this point, I had to use a bit of trial and error to figure out which table holds what data. To view the schema of a particular table you can use the following command.

.schema <table name>

Using this command on the ABPerson table gave me the following result.

iphone schema

There was other information also, but this is basically what I was interested in. So, this particular table was all the information about the a Person, except the phone number. To look for the phone number, I had to look at another table – ABMultiValue. And the two tables are linked through the ROWID and record_id fields in the ABPerson and ABMultiValue tables respectively.

It turns out that the ABMultiValue tables lists all the phone numbers and a quick “select * from ABMultiValue” gave me the answer I was looking for. So, now I finally know where all the data is. To collect all the data in a single place, I used the following SQL query.

select ABPerson.first,ABPerson.last,ABMultiValue.value from ABPerson,ABMultiValue where ABMultiValue.record_id=ABPerson.ROWID

Once I’d confirmed that this was indeed the correct data, I gave the following command on the sqlite prompt

.output backup.txt

That made sqlite put all output into the backup.txt text file rather than the console. And I was set. Ran the above select statement once again and I had all the phone numbers in a nice text file.

How was that for a weekend project, eh ?

In a future post, we’ll talk about taking out the notes and Calender entries from a backup file. The procedure is almost the same, so if you guys can figure it out yourself till then, post the solution in the comments.

Control firefox with the keyboard using ubiquity

UbiquityWell, actually, Ubiquity can do a lot more.

Ubiquity is a firefox extesion that is can really only be described as a launcher for the Internet, integrated with the web browser, which in this case is Firefox. Confused ?

Well, Let me explain. Ubiquity allows you to use your keyboard to give commands to the browser that’ll let you do anything that you would otherwise use the mouse for. So, for example, if you want to search for something using google. You can Just use the keyboard to instruct ubiquity to do that for you. If you want to search amazon for the latest gadgets, Ubiquity can do that too.

Ubiquity is like Quicksilver (or GNOME Do, if you’re so inclined) for the Internet browser.

To get started with Ubiquity, Install it from this location.

Continue reading “Control firefox with the keyboard using ubiquity”

Convert videos for your iPhone with free tools

ffmpegThe iPhone is a wonderful device to watch videos thanks to it’s big and bright screen. The only problem I have with it is the limited number of video formats that it supports.

Most videos that I download from the net are in formats that the iPhone refuses to understand and play. I’ve tried searching online for utilities to convert videos for the iPhone, but it looks like almost all software available for this purpose online is either free or doesn’t do a good job. While freeware is almost non-existant (or of bad quality), a lot of shareware that is available insist on acting nasty and adding watermarks and other DRM to my videos.

Continue reading “Convert videos for your iPhone with free tools”