iOS SMS database schema whack-a-mole

If you have been using my sms-backup-iphone.pl script, you'll be wanting to upgrade that before you upgrade to iOS 6.0.

Previously, previously.

Tags: , , , , ,

5 Responses:

  1. Lasar Liepins says:

    Just tried the script for the first time. At first I had two error messages because I did not have the directories ~/Library/Application Support/AddressBook/Sources and ~/Documents/SMS Backup. After creating both manually everything worked fine. The error messages the script threw were only half helpful here. Not sure if you care.

    And then I think I found an error in line 316: my $timestr = strftime ("%a %b %d %I:%m %p", @lt);
    %m is numerical month, not minute, which is %M.

  2. Phill says:

    Took me a minute before I figured out that you were purposefully blocking my wget/curl actions while I tried to dump it into my home dir.

  3. Bill Weiss says:

    Goofy question: can this work with an encrypted backup? I don't see a way now, and I'd believe the answer is "no, Apple does some undocumented bullshit^Wmagic to keep me from seeing that", but it's worth a question.

    • Bill Weiss says:

      Specifically, I get this after it says "sms-backup-iphone.pl: SMS DBs:" and decides to open the first file:
      bweiss@bweiss ~/bin % ll ~/Library/Application\ Support/MobileSync/Backup/4722763fff7614cef18da80acc522861060dc8ba/3d0d7e5fb2ce288813306e4d4636395e047a3d28
      -rw-r--r-- 1 bweiss staff 122896 Oct 3 09:46 /Users/bweiss/Library/Application Support/MobileSync/Backup/4722763fff7614cef18da80acc522861060dc8ba/3d0d7e5fb2ce288813306e4d4636395e047a3d28
      bweiss@bweiss ~/bin % sqlite3 !$
      bweiss@bweiss ~/bin % sqlite3 ~/Library/Application\ Support/MobileSync/Backup/4722763fff7614cef18da80acc522861060dc8ba/3d0d7e5fb2ce288813306e4d4636395e047a3d28
      SQLite version 3.7.7 2011-06-25 16:35:41
      Enter ".help" for instructions
      Enter SQL statements terminated with a ";"
      sqlite> .tables
      Error: file is encrypted or is not a database