iMessage database format

[perteghella]

Anyone know how to read the iMessage stored in the sms SQL lite database ?

Reading /Users/user/Library/Application\ Support/MobileSync/Backup/really_long_number/3d0d7e5fb2ce288813306e4d4636395e047a3d28 as a text file show that include sms and iMessage

Exploring via SQL lite show only sms.

 

[perteghella]

I'm manually compare the iMessage on iphone and text on file but non more then garbage...

Any SQL black belt can decode the file ?

Anyone know how to read the iMessage stored in the sms SQL lite database ?

Reading /Users/user/Library/Application\ Support/MobileSync/Backup/really_long_number/3d0d7e5fb2ce288813306e4d4636395e047a3d28 as a text file show that include sms and iMessage

Exploring via SQL lite show only sms.

 

[pcunite]

Are they perhaps encrypted? Is it the actual message data or only a hash pointer?

 

[perteghella]

Are they perhaps encrypted? Is it the actual message data or only a hash pointer?

The file is readable in clear text, sms and iMessage, the database schema included don't fit for iMessage...

Try on your backup file and see it