+ Reply
Page 2 of 3 FirstFirst 123 LastLast
Results 21 to 40 of 43

Your favorite Apple, iPhone, iPad, iOS, Jailbreak, and Cydia site.


Thread: Addressbook.sqlitedb and sms.db on iOS 5. Upgrading problems.

is a discussion within the

General

forums, a part of the

Jailbreak / Downgrading / Upgrading

section;
Originally Posted by codvisp When the owner is root, effectively you prevent any (but root) from changing the file. Naturally, when you set it to mobile, changes are allowed to
...
  1. #21
    iPhone? More like MyPhone DaMan05's Avatar
    Join Date
    Apr 2008
    Location
    Home of the HABS
    Posts
    150
    Thanks
    16
    Thanked 8 Times in 8 Posts

    Quote Originally Posted by codvisp View Post
    When the owner is root, effectively you prevent any (but root) from changing the file. Naturally, when you set it to mobile, changes are allowed to the file by any...
    To clarify further, all saves or changes (as an example of a save game file) has to be set as mobile to have access to the read & write...
    Do your received iMessages have a timestamp of the year 2042, by any chance?

  2. #22
    What's Jailbreak? anhvinhbeo's Avatar
    Join Date
    Sep 2007
    Posts
    1
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Just did with my 4.3.3 ==> 5.0.1
    how to do it:
    1. Delete everything from Addressbook/SMS
    2. Copy over the old database
    3. Change owner from "root" to "mobile"
    4. Respring or reboot

  3. #23
    What's Jailbreak?
    Join Date
    Aug 2010
    Location
    BAY AREA....
    Posts
    12
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by gusutabo View Post
    Hi,

    Yesterday I just tried to update my iPhone 4 4.3.3 (jailbroken with Jailbreakme) to iOS 5 but had some problems with corrupt iTunes backup and couldn't restore my old data back into iOS 5. Thankfully I had a manual backup of some of the most important files I had on the phone (address book and sms data) which I'm trying restore to iOS 5 now.

    When I migrated from iPhone 3G 3.1.2 to iPhone 4 4.1 I had a similar problem and just cutting and pasting the old files to the new OS (on /var/root/library/addressbook and /sms respectively) worked just fine.

    However, address book data used to consist of only two files: AddressBook.sqlitedb and AddressBookImages.sqlitedb. And SMS had only sms.db. However on iOS 5 there are three "versions" for each of those file (AddressBook.sqlitedb, AddressBook.sqlitedb-shm, AddressBook.sqlitedb-wal, AddressBookImages.sqlitedb, AddressBookImages.sqlitedb-shm, AddressBookImages.sqlitedb-wal, sms.sqlitedb, sms.sqlitedb-shm, sms.sqlitedb-wal)
    It seems the actual contacts/sms are storred on the .sqlitedb-wal files and not the .sqlitedb ones.

    Trying to replace the .sqlitedb files or renaming them to sqlitedb-wal and replacing doesn't work.

    Does anyone have any clues on how to proceed on this?
    Thanks!
    You should check out a tool called iPhone Backup Extractor, it's incredibly useful if you're having trouble restoring your iPhone content (like contacts, sms, photos, etc) using an Itunes backup. It will simply extract all of the files for all those things, which you can then take and manually install into your newly updated iphone using winscp or iphonebrowser. Unfortunately, it costs money, though I believe they offer a free trial as well.
    Another tool I'd suggest for people to checkout if they are looking for a good iphone explorer is a program called iSpirit. iSpirit accesses iDevices via USB, and has all the caveats that are available to WinSCP users. It's not a very widely known tool, but it is probably the best one i have used thus far.

    It's a shame there still isn't a viable backup/restore tool to use when updating iOS firmware.

  4. #24
    What's Jailbreak?
    Join Date
    Jul 2011
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Address Book database iOS 5.0.1
    Hey guys,

    I tried the same way you said and I still can't import my backup of address book, at least I managed Notes, SMS, calendar and photos

    Please help me as the contacts are the most important

    Thanks

  5. #25
    iPhone? More like MyPhone DaMan05's Avatar
    Join Date
    Apr 2008
    Location
    Home of the HABS
    Posts
    150
    Thanks
    16
    Thanked 8 Times in 8 Posts

    I can't help you with your problem, but in the future, wouldn't it just be easier to use iCloud, sync with your desktop, an Exchange server, Gmail or any of the other billion services there are that can backup your contacts?

    Personally, I use my school's exchange server for syncing contacts, calendars and tasks/Reminders. I dunno what I would do if my laptop and phone didn't stay in sync constantly... especially the tasks.

  6. #26
    What's Jailbreak?
    Join Date
    Nov 2009
    Posts
    29
    Thanks
    8
    Thanked 5 Times in 1 Post
    Quote Originally Posted by DaMan05 View Post
    Do your received iMessages have a timestamp of the year 2042, by any chance?
    Nope all is well & 100% working with a correct date...

  7. #27
    What's Jailbreak?
    Join Date
    Nov 2009
    Posts
    29
    Thanks
    8
    Thanked 5 Times in 1 Post
    Quote Originally Posted by benkapel View Post
    Can i just add a couple things

    - If you are stuck in the cycle where it keeps respringing automatically. Just delete the contents of SMS/ and then start the above process once booted AND BEFORE ANY APPS ARE LOADED

    - In my particular situation, i could restore the SMS database fine, and see all the messages, but when i tried to send one, or receive one, the phone would crash and wipe the database again. There is a point above that rebooting fixed this. However, my situation is also this, once restored, if i re-boot, the phone hangs on the lock screen, and then refreshes, with no SMS. So rebooting in my case, no matter what sequence i tried, with all the correct permissions, my database just wanted to wipe!

    If you find yourself in my situation, i used this free tool at iPhone SMS Database Merger for iOS 3.x and 4.x to merge my database to itself (i.e. used the same file for both). There were no duplicates, and it essentially re-wrote the database from scratch. As mentioned, group messages no longer appear as groups but as individual items, but ONLY for the group messages in the file. If you send a group message AFTER this process, it still does it, just the re-write merge process splits them up into individual conversations. (i can't see this being even a minute problem for anyone...can you??)

    Once the process was complete, i immediately backed up to iTunes, and now I can now restore from iTunes to any iPhone (4.x and 5.x JB or non JB) and it's perfectly fine.

    Obviously some people are having success with just dropping the old sms.db in, and that's good, but for anyone who's just, won't, work. Try the merger. I'm very happy that 4 years of SMS are still accessible by the phone.
    No need to man, if you're having this problem, just turn off iCloud! :P

  8. #28
    What's Jailbreak?
    Join Date
    Jan 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by codvisp View Post

    1.Upon rebooting your iOS, don't open any app, especially the phone or contacts apps.
    2. Copy into /var/mobile/addressbook your AddressBook.sqlitedb and AddressBookImages.sqlitedb using iFile (since your using it...) and set the permissions of "Owner" for both of the copied files to "mobile" if it's set as "root".
    3. Respring
    Hi codvisp,

    I've followed carefully and exactly what you've mention. still no luck.
    I'm running on ios 5. last updated from ios 4.3.3.

    extracted AddressBook.sqlitedb from ios 4.3.3

    jailbroken using redsn0w_win_0.9.10b3.

    ssh into folders using ifunbox.

    permission all set to "mobile"

    tried a few permutations as follows:

    1) as I do not have the folder "/var/mobile/addressbook", hence I created /addressbook folder and added in the 2 files. but alas, no sign of my old contacts.

    2) tried copying AddressBook.sqlitedb and AddressBookImages.sqlitedb into addressbook that is found in /var/mobile/library/addressbook, respring, with apple loading screen, apparently, rebuilding the original files that have been overwritten.

    3) tried deleting everything inside /var/mobile/library/addressbook, then copy the 2 old files into this folder, respring, no sign of my contacts.

    4) using search, locate whatever /addressbook folder inside iphone, copy and paste the 2 old files into all the folders. still no sign of my contacts!!

    I even went crazily googling and found this advise http://blog.lincomatic.com/?p=384, is it valid? as the date of the post seemed outdated given the fact that the current version of ios was released in november.


    Should i do a clean restore and jailbreak, start all over again?
    please help!!
    Last edited by Pr0ph3ts2; 01-16-2012 at 05:32 AM.

  9. #29
    What's Jailbreak?
    Join Date
    Nov 2009
    Posts
    29
    Thanks
    8
    Thanked 5 Times in 1 Post
    Quote Originally Posted by Pr0ph3ts2 View Post
    Hi codvisp,

    I've followed carefully and exactly what you've mention. still no luck.
    I'm running on ios 5. last updated from ios 4.3.3.

    extracted AddressBook.sqlitedb from ios 4.3.3

    jailbroken using redsn0w_win_0.9.10b3.

    ssh into folders using ifunbox.

    permission all set to "mobile"

    tried a few permutations as follows:

    1) as I do not have the folder "/var/mobile/addressbook", hence I created /addressbook folder and added in the 2 files. but alas, no sign of my old contacts.

    2) tried copying AddressBook.sqlitedb and AddressBookImages.sqlitedb into addressbook that is found in /var/mobile/library/addressbook, respring, with apple loading screen, apparently, rebuilding the original files that have been overwritten.

    3) tried deleting everything inside /var/mobile/library/addressbook, then copy the 2 old files into this folder, respring, no sign of my contacts.

    4) using search, locate whatever /addressbook folder inside iphone, copy and paste the 2 old files into all the folders. still no sign of my contacts!!

    I even went crazily googling and found this advise Lincomatic's Blog | electronics, hacking, etc, is it valid? as the date of the post seemed outdated given the fact that the current version of ios was released in november.


    Should i do a clean restore and jailbreak, start all over again?
    please help!!


    The correct address is /Var/Mobile/Library/Addressbook and before you replace the files don't forget to TURN OFF iCloud...

  10. #30
    LHW
    LHW is offline
    What's Jailbreak?
    Join Date
    Apr 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by codvisp View Post
    No need to man, if you're having this problem, just turn off iCloud! :P
    Hi codvisp,
    I've been trying to solve the problem of missing SMSes using the methods you posted, but none of them helped.
    I have an iPhone 3GS on iOS 5.0.0, jailbroken.
    The problem started when i was trying to edit the sms.db using iFile, but I didn't save it though, I cancelled the changes. When I went back to the Messages app, all the messages disappeared.
    I have tried your methods, other ppl's method but they all did not work. However, despite the fact that the messages are "missing" from the messages app, they can still be found when I used spotlight search.
    btw, I have already turned off iCloud.

    Do you know of any methods to help fix this problem?
    Thx

  11. #31
    What's Jailbreak?
    Join Date
    Jun 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by codvisp View Post
    No need to man, if you're having this problem, just turn off iCloud! :P
    Can you turn on icloud back later on?

  12. #32
    What's Jailbreak?
    Join Date
    Nov 2009
    Posts
    29
    Thanks
    8
    Thanked 5 Times in 1 Post
    Quote Originally Posted by minek View Post
    Can you turn on icloud back later on?
    Yes of course, as soon as the restore is complete

    By the way, you can also backup/restore all iMessages on 5.1.1 including all media if anyone is interested... (Whatsapp, Viber, etc. also work...)
    Last edited by codvisp; 07-04-2012 at 01:44 AM.

  13. #33
    What's Jailbreak?
    Join Date
    Jun 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quote Originally Posted by codvisp View Post
    Yes of course, as soon as the restore is complete

    By the way, you can also backup/restore all iMessages on 5.1.1 including all media if anyone is interested... (Whatsapp, Viber, etc. also work...)
    That's what I would like to achieve Isn't it enough to just copy all subfolders from /var/mobile/Library/SMS (Attachments, Drafts, Parts)? I thought that SMS and iMessage data is is one place? Also I'm on 5.0.1 and would like to do a clean restore to 5.1.1 - do you think this may cause issues?

  14. #34
    What's Jailbreak?
    Join Date
    Nov 2009
    Posts
    29
    Thanks
    8
    Thanked 5 Times in 1 Post
    Quote Originally Posted by minek View Post
    That's what I would like to achieve Isn't it enough to just copy all subfolders from /var/mobile/Library/SMS (Attachments, Drafts, Parts)? I thought that SMS and iMessage data is is one place? Also I'm on 5.0.1 and would like to do a clean restore to 5.1.1 - do you think this may cause issues?
    yes in one place, but u have to set the right permissions for iMessage in order to function properly:

    Using iFile or any other app go to /var/mobile/Library/SMS:

    1. As always, for the 3 files sms.db, sms.db-shm and sms.db-wal:
    Set the "Ownership" of Owner to mobile and Group to mobile. Also, "Access Permissions" of User: Read, Write - Group: Read and World: Read.

    2. For the Attachments folder: Set the "Ownership" of Owner to mobile and Group to mobile. Also, "Access Permissions" of User: Read, Write, Execute - Group: Read, Execute and World: Read, Execute.

    3. Go to /var/mobile/Library/SMS/Attachments, you will see plenty of folders and in each folder 2 image files, so apply the following for each and every file:
    a. the named IMG_xxxx.jpg (which is the actual image): set the "Ownership" of Group to wheel
    b. the named IMG_xxxx-preview-left.jpg (which is the thumbnail) should not be changed as it has to be mobile,mobile - Read, Write - Read - Read.

    Hope this helps,
    if you need any further help contact me directly through my twitter account: @codvisp
    Last edited by codvisp; 07-09-2012 at 01:05 AM.

  15. #35
    iPhone? More like MyPhone
    Join Date
    Jul 2011
    Posts
    102
    Thanks
    9
    Thanked 1 Time in 1 Post
    Quote Originally Posted by codvisp View Post
    yes in one place, but u have to set the right permissions for iMessage in order to function properly:

    Using iFile or any other app go to /var/mobile/Library/SMS:

    1. As always, for the 3 files sms.db, sms.db-shm and sms.db-wal:
    Set the "Ownership" of Owner to mobile and Group to mobile. Also, "Access Permissions" of User: Read, Write - Group: Read and World: Read.

    2. For the Attachments folder: Set the "Ownership" of Owner to mobile and Group to mobile. Also, "Access Permissions" of User: Read, Write, Execute - Group: Read, Execute and World: Read, Execute.

    3. Go to /var/mobile/Library/SMS/Attachments, you will see plenty of folders and in each folder 2 image files, so apply the following for each and every file:
    a. the named IMG_xxxx.jpg (which is the actual image): set the "Ownership" of Group to wheel
    b. the named IMG_xxxx-preview-left.jpg (which is the thumbnail) should not be changed as it has to be mobile,mobile - Read, Write - Read - Read.

    Hope this helps,
    if you need any further help contact me directly through my twitter account: @codvisp

    I really need some help, and I apologize for hi-jacking a thread but it relates to this and seeing as you are offering. I hope you can help me. I have followed instructions to the T in backing up and restoring my SMS via SSH. I have set the correct permissions for all the files via iFile. Yet I am still running into issues. Everything works with the SMS app as it should, aside from one major issue. I cannot send or receive pictures since restoring my SMS via SSH.

    Any help would be greatly appreciated, this is a huge problem for me. haha

  16. #36
    What's Jailbreak?
    Join Date
    May 2010
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I wish I had known this earlier. I just updated from 4.2.3 on my 3GS to 6.1.2 and the evasi0n jailbreak worked perfectly. That was, of course, until I deleted the 6 empty Address Book files that come with iOS 6 and replaced them with the 2 Address Book files from iOS 4 and didn't change the permissions to "Mobile" before I opened the Address Book app.

    Now, no matter what I do, I'm getting a black screen with the Apple logo and a progress bar that goes to 90% and gets stuck. Then, once it boots up, it flickers, and I can see the normal home screen in the background, and I can get into apps if I tap on it in a certain way, but's crazy annoying and time consuming.

    I tried deleting the files and rebooting it to see if it would just populate the default Address Book files for iOS 6, but to no avail. It still gave me the same crazy screen.

    I then tried to restore via the same 6.1.2 IPSW that I successfully restored it with the first time, but the fix that I used to fix the error I got when I tried to restore it the first time did not work the second time.

    Here was the fix that worked for me the first time when I got the error: "This Device Isn't Eligible For The Requested Build":

    Fix iTunes Error "This Device Isn't Eligible For The Requested Build" Restoring iPhone 3G, 3GS, 4 - YouTube

    I can't upgrade to 6.1.3 for obvious reasons (evasi0n does not work on 6.1.3), and that's what is coming up for me in iTunes as of this afternoon.

    Any ideas?

  17. #37
    What's Jailbreak?
    Join Date
    May 2010
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I was able to upgrade to successfully to 6.1.2 via Sn0wbreeze in expert mode (NOT using hactivation) and iTunes.

    Now I just need to get the raw iOS 4 files for Contacts/Address Book, Notes, SMS, Call History and Calendar converted to iOS 6. Does the above method that worked for iOS 5 also work for iOS 6?

    If not, what method would you suggest for doing this? Please explain it in a step-by-step process.

    Thanks!

  18. #38
    iPhone? More like MyPhone
    Join Date
    May 2008
    Posts
    124
    Thanks
    78
    Thanked 0 Times in 0 Posts

    Weird: Auto-Recurring Resprings and Reboot result in Contacts AddressBook lost blank gone - Help!

    Quote Originally Posted by gerstemann View Post
    Hi Folks,

    got it working. My Adressbook is back !

    How did I got it working? Just use ifunbox and search for the adressbook sql database. There are 2 or 3 different locations. just copy your copy to all locations and reboot. Works for me like a charm. The other ways didnt work so far !

    This was the only thread that had something relevant to what I am looking for.

    This weird thing happened:

    - I was at a cafe working on something and since my iPhone 4 iOS 5.1.1b + Jailbreak was working a little slow I did a RESPRING.
    - The damn thing kept on respringing and would not stop
    i.e. I'd get the slide to open screen and once I'd slide it in a short time it would respring
    - All attempts to shut it down etc or REBOOT failed

    Then I remembered the way to hard boot using both Buttons (Home + Power) - Now when it came back up it was without SBSettings etc.

    - I did a respring in hopes of having the SBSettings etc back and it it went back into respring loop
    - Another hard reboot and I have it running

    - Now when I open my Phone | Contacts they are all gone!

    - The messages, Favorites, Recent calls with the numbers are all there - But the corresponding NAMES to those numbers are gone.

    DAMN!!!

    So next thing I did a Manual Backup - From the AddressBook folder using iFunbox
    Code:
    AddressBook.sqlitedb [4 KB]
    AddressBook.sqlitedb-shm
    AddressBook.sqlitedb-wal [262 KB]
    AddressBookImages.sqlitedb [38,352 KB]
    AddressBookImages.sqlitedb-shm 
    AddressBookImages.sqlitedb-wal [3868 KB]
    PS: But this AddressBook DB is SMALL - Possibly the empty one - Where can I find the other locations where my "PREVIOUS" BIG ADDRESS BOOK with all CONTACTS might be sitting? Some kind of INTERNAL BACKUP on the iPhone?

    So in such a desperate space I tried to use similar tools -
    - DiskAid - After a long wait, opened the Messages A
    - After selecting CONTACTS it another long wait - It showed all the contacts - Damn! I was happy.. But when I did an export of ALL CONTACTS from DiskAid it crashed at some point.

    So, apparently it was on the phone somewhere? Where?

    How do I FIND and get that SQL DB copy for RESTORING my Contacts and AddressBook ??

    Thoughts and ideas?

    PS:
    Other Facilities:
    iCloud - I dont really use it - i.e. The only thing enabled on my iCloud account is "FindMyIphone"

    iTunes Backup - I use this regularly but my last Backup is 34 days old and I'd like try and get back the AddressBook SQL DB before trying a Sync/ Restore from the iTunes Backup. (PS: If/ when I do go there, what steps should I take to sync)
    Last edited by crashnburn_in; 04-07-2013 at 04:19 PM.

  19. #39
    What's Jailbreak?
    Join Date
    Apr 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hi, I was redirected to this thread by Apple Community forums. I am looking for a way to back up and if possible restore my iPhone text messages (sms and imessage) from my current jailbroken iphone 4s to a jailbroken iphone 5. I'd not resort to using itunes as this will remove the jailbreak from both devices i understand?

  20. #40
    Green Apple Wyman's Avatar
    Join Date
    Jan 2012
    Posts
    90
    Thanks
    1
    Thanked 6 Times in 6 Posts

    Quote Originally Posted by frogreg View Post
    Hi, I was redirected to this thread by Apple Community forums. I am looking for a way to back up and if possible restore my iPhone text messages (sms and imessage) from my current jailbroken iphone 4s to a jailbroken iphone 5. I'd not resort to using itunes as this will remove the jailbreak from both devices i understand?
    Why not use iCloud backup instead of iTunes?

LinkBacks (?)

  1. 07-02-2014, 04:58 AM
  2. 04-24-2014, 02:27 AM
  3. 02-14-2014, 01:58 AM
  4. 11-12-2013, 06:26 AM
  5. 06-03-2013, 09:41 AM
  6. 04-13-2013, 09:33 AM
  7. 04-01-2013, 04:12 PM
  8. 04-01-2013, 03:49 PM
  9. 03-29-2013, 09:38 AM
  10. 03-24-2013, 07:23 PM
  11. 03-07-2013, 05:55 AM
  12. 02-05-2013, 01:02 PM
  13. 02-05-2013, 11:54 AM
  14. 02-01-2013, 01:40 AM
  15. 01-30-2013, 10:06 PM
  16. 01-30-2013, 09:24 AM
  17. 01-03-2013, 09:22 PM
  18. 08-07-2012, 11:16 AM
  19. 07-21-2012, 07:51 AM
  20. 06-03-2012, 05:39 PM
  21. 05-26-2012, 01:59 AM
  22. 05-25-2012, 12:29 PM
  23. 05-01-2012, 06:47 PM
  24. 04-19-2012, 06:56 PM
  25. 03-12-2012, 12:24 AM
  26. 02-20-2012, 01:25 AM
  27. 01-31-2012, 12:56 PM
  28. 01-24-2012, 06:17 AM
  29. 01-22-2012, 04:23 PM
  30. 01-21-2012, 04:55 PM
  31. 01-05-2012, 11:13 AM
  32. 01-05-2012, 10:47 AM
  33. 01-05-2012, 07:23 AM
  34. 12-30-2011, 03:06 AM

Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts