Posts Tagged ‘iPhone’

iDevice tracking.

April 27th, 2011 Comments off
Reading Time: 4 minutes

I’m a little late wading into this but I thought it worth looking at based on my last post.

If you’ve been hiding under a rock; Apple tracks where you have been (regardless of your location tracking selection) in a file called consolidated.db.


This was originally discovered by Alex Levinson back in 2010 when he was researching the iPad.

Long story short there is s SQLite Database on both the iDevice (/private/var/root/Library/Caches/locationd/consolidated.db) and stored on your sync machine (/Users/<your user name>/Library/Application Support/MobileSync/Backup/). It uses cell tower triangulation, as opposed to GPS, to track your location (so accuracy isn’t always bang on, but pretty close in most cases).

Recently a couple of researchers from O’Reilly (Alasdair Allan and Pete Warden) wrote an OSX application that allows the visualisation of the stored data and bringing this out from the deep dark recesses of computer forensics to the mainstream, sparking outrage and cries of foul. This in turn forcing Apple to respond to these concerns.

You can see in the image “Tracked!” that it has tracked my movements throughout NSW and Canberra. So I decided to have a play myself to see what is all captured (instructions on how to find the consolidated.db file are on Pete Warden’s site). With the help of an SQLite viewer I opened up the file to see what all was there (see image below):

SQLite file opened

The second table is the interesting one that contains the location tracking data that everyone is interested in. A view into that table shows exactly what can be found in there:

CellLocation Table Contents

I’ve condensed the columns for Longitude and Latitude, mostly because I don’t want everyone knowing EXACTLY where I’ve been 😉

The interesting thing seems to be that there is also similar information being stored for WiFi locations though I’ll need some time playing about to understand how relevant the information stored is, but based on an initial pass it seems to capture any AP that my phone sees. I’ve tested this by pluging random MAC addresses into the Google to check against it’s wireless AP DB and sure enough, these are APs I’ve not connected to but are pretty close to some of the ones I do.

Given the high profile of this, now, and the ease in which the necessary scripts can be located online to grab this information. I suspect that it won’t be long before you see some exploits in the wild and high profile people start finding that their movements are published.

I hope Apple move to remedy this soon.

UPDATE: I forgot to add that Google also track phones and seem to track similar information on WiFi locations picked up by Android devices. I suspect that Apple is doing similar things with the information for their own reasons.

UPDATE2: Apple have released their latest IOS (4.3.3) that addresses some of the issues.

I’ve yet to run it up and review myself but it looks like they have made good. Now to see what happens with Google and Microsoft.

iPhone and our reliance on technology

June 15th, 2009 Comments off
Reading Time: 3 minutes


I have recently started taking an interest in the writings of Chris Hoff and James Urquhart. Both of them, despite being Cisco employees (sorry that is tongue in cheek), have pragmatic view towards the “cloud computing” phenomenon. The recent posts from both of them on using the iPhone as an analogy of cloud computing got me thinking about a couple of things:

iPhone as a technology enabler: Fact is that now a days people expect that services are always available and that information is always at their finger tips.

Personal even business related information readily available at your first whim. Supports the need, almost the requirement for, ubiquitous applications and data.

People today rely less and less on their ability to remember things and more and more on technology to do it for them. Perfect example;

last night at dinner the waitress came over, sans notepad, and took all our orders. Some were stunned, not by her ability to repeat the orders back to us, but that there was the chance that something might go wrong in the process, between repeating the order to us and  eventually having our meals delivered. As we had two developers at the table comments turned to how easy it would be to churn out a simple iphone/ipod touch app that would allow the orders to be entered into the system, how they could be tracked and we would be safe in knowing that there couldn’t be a breakdown in process. This led to talk about having ability to order straight from a touch screen imbedded in the table, all so we knew the accuracey of the orders being entered, etc… Can you say Xerts?!?

I think about how life was when I was growing up and that memorising great swarths of information (learning by rote) was just how it was done and look to how we function today, it’s less about knowing everything and more about knowing how to get access to the relevant pieces of information we need when we need them. I look at my son and think in wonderment at how he will access and use information as he grows up.

More and more, I think the technologies and gadgets that we cling to and get emotional about, they are the ones that give us access or are enablers.

Categories: iPhone Tags: ,