Jump to content

Photo

How to open db files?


  • Please log in to reply
34 replies to this topic

#1
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
I'm now trying to figure out what she did. I don't know how to open the messages.db file. There are several files with db at the end. I need to open them. Is there any software that could open it?

#2
Aperson

Aperson

    Superstar

  • VIP
  • Posts491
  • iDeviceiPod Touch 4
  • Firmware5.0.1
Offline
Since it says in your profile your on 4.2.1 you need to find someone with an ios 5 idevice to put that into. Then that person can swap her db with theirs and they can then read the messages.
Edit, also im pretty sure the name of the db is actually sms.db located in /var/mobile/Library/SMS/sms.db
Edit2: also, is this the stock messages.app? not a 3rd party one like textfree or textplus?
Posted Image

#3
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
It is called that. it would make my life easier if there is a certain software that could open those type of files.

#4
Aperson

Aperson

    Superstar

  • VIP
  • Posts491
  • iDeviceiPod Touch 4
  • Firmware5.0.1
Offline
See if this works:
http://sourceforge.n...latest/download
If it doesn't, tell me what app this *.db file is from.
Posted Image

#5
brc0703

brc0703

    The Hat Club

  • Platinum
    Submitter
  • Posts2,340
  • iDeviceiPhone 5S
  • Firmware8.1.2
Offline
if the file is from a 4.x device it can be read on a 4.x or 5.x device.. havent tried to see a 5.x db on a 4.x device but it probably wouldnt work.. theres a program called tansee (i think) that can open them but it reads it from your device so im not sure if it would work by just putting the file on ur phone and trying it without launching the sms app so it doesnt reset the file.. also this was on 4.x i did this... not sure if its been updated for 5.x..
Posted Image





if this helped hit the + ------------------------->


#6
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
It somewhat works. It does not show the messages though. I even tried on Safari history. Nothing.

#7
Aperson

Aperson

    Superstar

  • VIP
  • Posts491
  • iDeviceiPod Touch 4
  • Firmware5.0.1
Offline
You still didnt answer my question, what app is messages.db from?
Posted Image

#8
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
Wait up... Is there a way to change the applications to names in WinSCP? I'm getting tired of clicking each folder. @brc - im going to use my lil bro ipod. the sms is the messages app, right? lol I haven't used an ipod touch 4g for a long time.

#9
Aperson

Aperson

    Superstar

  • VIP
  • Posts491
  • iDeviceiPod Touch 4
  • Firmware5.0.1
Offline
sms.db is what is used by the stock Messages app (SMS.app). messages.db is from a third party app and i need to know which one it is.
Posted Image

#10
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
@Aperson - That was an example. lol

Theres an app that says unlimitedsms.app. What app is that? I can't find it on the app store.

#11
brc0703

brc0703

    The Hat Club

  • Platinum
    Submitter
  • Posts2,340
  • iDeviceiPhone 5S
  • Firmware8.1.2
Offline
the original sms.db is /var/mobile/Library/SMS/sms.db and in IOS5 it also has 2 other file sms.db-wal and sms.db-shm and then the Parts (mms) and Drafts directory's.. copy only the sms.db and delete anything else so thats the only file in SMS.. set permissions mobile:mobile 0700 and reboot the device.. for me when i put a 4.x sms.db on a 5.x device its unresponsive for a min or two then it resprings.. i cheked and the log reads its because the sms.db is an 11 format database and expected format 19.. rebuilding.. takes a while but after the respring its just like normal
Posted Image





if this helped hit the + ------------------------->


#12
Aperson

Aperson

    Superstar

  • VIP
  • Posts491
  • iDeviceiPod Touch 4
  • Firmware5.0.1
Offline
UnlimitedSms.app is known as "TextNow" on the appstore.
Posted Image

#13
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
There is also a messenger app, but it's call messenger.app. Can't find that on the App Store.

#14
brc0703

brc0703

    The Hat Club

  • Platinum
    Submitter
  • Posts2,340
  • iDeviceiPhone 5S
  • Firmware8.1.2
Offline
try 'sb -0 SBDeviceLockBlocked' from a terminal prompt.. if u can winscp u can use putty..
Posted Image





if this helped hit the + ------------------------->


#15
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline

try 'sb -0 SBDeviceLockBlocked' from a terminal prompt.. if u can winscp u can use putty..

For what?

#16
Aperson

Aperson

    Superstar

  • VIP
  • Posts491
  • iDeviceiPod Touch 4
  • Firmware5.0.1
Offline
1Hero can you just send me the .db files?
Posted Image

#17
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
That I can't do. Those db might contain personal information.

#18
RypeDub

RypeDub

    Banned

  • Banned
  • Posts2,525
Offline
Did you try MySQL?

It's time!


#19
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline

the original sms.db is /var/mobile/Library/SMS/sms.db and in IOS5 it also has 2 other file sms.db-wal and sms.db-shm and then the Parts (mms) and Drafts directory's.. copy only the sms.db and delete anything else so thats the only file in SMS.. set permissions mobile:mobile 0700 and reboot the device.. for me when i put a 4.x sms.db on a 5.x device its unresponsive for a min or two then it resprings.. i cheked and the log reads its because the sms.db is an 11 format database and expected format 19.. rebuilding.. takes a while but after the respring its just like normal

So sms.db ownership has to be set to mobile and I need to delete sms-db-shm and sms.db-wal?

How about the Drafts folder with the messages.plist?

#20
1Hero

1Hero

    Elite

  • VIP
  • Posts1,065
  • iDeviceiPod Touch 2G
  • Firmware4.2.1
Offline
Also would her account be automatically set or do I have use my account to view her messages?