Recover SMS iPhone - Paul Courbis


   

CAUTION !

Please read this...



You'll fin below this text a semi-automated translation of the original website. Texts will be gradually reviewed to make them as accurate as possible but it's strongly recommanded to read the original page (preview on the right side of this text) :

Link to the original article


(if this link is broken, please go to the original website's root page and look for wanted data. Sorry about that).


Some parts of this website will never be translated to English. Part of them are user's comments that are not transfered from the French (original) version to this version. Obvously, you can leave your own comments here but they wont be transfered to the French version.

You can send comments or suggestions to the webmaster.

   
Paul Courbis


Recover SMS iPhone

Monday 13 September 2010, by Paul Courbis

Prerequisites

- A jailbroken iPhone;

- Sftp access to the iPhone (you must install the OpenSSH package in Cydia, have an sftp client on your desktop machine and connect the two on the same network) or a tool for transferring files as iphonefolders;

- A tool that can read files of databases Sqlite (included in Cygwin as the sqlite3.exe).

Method

Simply retrieve the files sms.db in the directory /private/var/mobile/Library/SMS/ on the iPhone that contains, in particular, the table message :

  • ROWID unique identifier of the message
  • address Phone number of the issuer knew SMS
  • date date of the message (GMT) in seconds since 1 January 1970. You can easily convert this time to Unix in a readable format using the command date -u -R --date "1970-01-01 XXXXXXXX seconds" or XXXXXXXX is the number of seconds in question.
  • text Message Content
  • flags
  • replace
  • svc_center
  • group_id
  • association_id
  • height
  • UIFlags
  • version
  • subject
  • country
  • headers
  • recipients
  • read
  • smsc_ref
  • dr_date

It is possible to export the data file more easily usable by using the following commands (in bold what to type):

sqlite3 sms.db
SQLite version 3.6.21
Enter. "Help" for instructions
Enter SQL statements terminated With A ";"
sqlite>. html mode
sqlite>. messages.html output
sqlite> select * from message
sqlite>. quit

This produces a segment of html file in UTF-8. To open a Web browser (or Excel to edit easily), we must add the following code at the beginning of the file:

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

This produces a complete HTML file, easily editable ...

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

ROWID address date text flags replace svc_center group_id association_id height UIFlags version subject country headers recipients read smsc_ref dr_date texte_10 Rajouter aussi, en fin de fichier : texte_11 <code>

Comment on this article