Ukufumana kwakhona imiyalezo yobungqina evela kwifowuni eyonakeleyo okanye i-backup yengxoxo eyonakele¶
Amanani kaxakeka ayohluka ngokwamazwe. Eli phepha lisebenzisa u-911, inani laseMelika naseKhanada. Amanye amazwe amaninzi asebenzisa i-112, 999, okanye elinye inani. Fumana inombolo yelizwe lakho.
Xa ityala lembambano elibalulekileyo, idabi lenkundla yosapho, ukuvalelwa komyalelo wothintelo, isikhalazo soxhatshazo emsebenzini, ingxabano yobuqhophololo bokontraka, okanye ukhuselo lolwaphulo-mthetho luxhomekeke kwimiyalezo ebhaliweyo, iincoko ze-WhatsApp, ii-iMessages, okanye imisonto yeSiginali evaleleke ngaphakathi kwefowuni eyaphukileyo okanye ifayile yogcino eyonakeleyo, ukucofa okukodwa okungalunganga kunokutshabalalisa ngokusisigxina ubungqina bakho obusemthethweni. Oovimba bemiyalezo banamhlanje abayigcini imiyalezo njengeefayile ezibhaliweyo ezilula; bazigcina ngaphakathi kobudlelwane SQLite yogcino-lwazi (sms.db kwi-iOS, mmssms.db / bugle_db kwi-Android, msgstore.db.crypt14 / crypt15 kuWhatsApp, kunye noovimba beenkcukacha zeSQLCipher kwiSiginali) ehamba nethutyana Bhala-Phambili Log (.db-wal) iifayile zejenali.
Ukuba ngempazamo uvumela ifowuni entsha ibhale ngaphezulu ilifu lakho elinye eligciniweyo ngesiseko sedatha esingenanto, okanye ukuba uvula isiseko sedatha eyonakalisiweyo yeSQLite ngaphandle kokukopa efihliweyo. -wal ifayile kuqala, okanye ukuba ungenisa izikrini ezisikiweyo, ezingangqinisiswanga elichaswa ligqwetha elichasayo njengenkohliso, unokuphulukana nedatha kunye netyala lenkundla.
Esi sikhokelo sibonelela ngenyathelo ngenyathelo lokutsalwa kwengxoxo engonakalisi, ukulungiswa kwesiseko sedatha yeSQLite, ukubuyiselwa kokugcinwa kwe-cryptographic, kunye neeprothokholi zokugcinwa kwenkundla ezivunyiweyo ezisekelwe kwiNational Institute of Standards and Technology (NIST) Ushicilelo oluKhethekileyo 800-101 Rev. 1 (Izikhokelo kwiForensics yeSixhobo seMobile), iFederal Rules of Evidence (9RE) (9REB) (9REB) (9) I-902 (14) (UbuQinisekisa boBungqina be-Electronic nge-SHA-256 Hash Certification), kunye neenkcukacha ezisemthethweni zeSQLite / SQLCipher recovery.
Yenza oku ngoku¶
Ukuba ufuna ukuhlangula isicatshulwa esibalulekileyo okanye imiyalezo yencoko kwifowuni eyonakeleyo, umsonto ocinywe ngengozi, okanye ukugcinwa kwe-backups engaphumeleliyo:
- Beka ifowuni kwiMowudi yeNqwelomoya ngoko nangoko kwaye Ucime iCloud ngokuzenzekelayo / i-Google Drive Backup. Lo ngumthetho we-#1 we-forensics ephathwayo. Ngoba? Okokuqala, xa ucima umyalezo kwiMessage (
sms.db), WhatsApp (msgstore.db), okanye iMiyalezo ye-Android, okubhaliweyo akucinywanga kwangoko kwi-flash drive, kuhlala ngaphakathi kwedathabheyisi yeSQLite "Uluhlu lwasimahla / lwamaphepha angabiwanga" okanye ngaphakathi kwethutyana Bhala-Phambili Log (.db-wal) de idatabase iqhube imvelaphiVACUUMcoca okanye enze imiyalezo emitsha ngaphezulu kwayo. Okwesibini, ukuba umyalezo ucinyiwe kwifowuni yakho namhlanje, **ugcino lwakho lokugqibela lwe-02:00 AM iCloud Backup okanye i-Google Drive WhatsApp Backup isenomyalezo opheleleyo **, de i-Wi-Fi yanamhlanje igcina i-backup. Ukuvula iMowudi yeNqwelomoya kumisa ukubhala ngaphezulu kweSQLite yasekhaya kunye nokubhala ngaphezulu kogcino lwamafu ngoko nangoko. Ukuba usengozini ngoko nangoko evela kumxhaphazi wasekhaya okanye umntu ochwechwelayo onemiyalezo oyigcinayo, yiya kwindawo yokhuseleko kuqala kwaye utsalele umnxeba kwinombolo yakho yexesha likaxakeka (911 eUnited States naseKhanada, 112 ngapha kweEuropean Union, 999 eUnited Kingdom) okanye ujonge amanani kaxakeka. - ** Ungaze ufake okanye ungene kwi-WhatsApp okanye iSiginali kwifowuni entsha kwaye ucofe u- "Back Up Ngoku" ngaphambi kokubuyisela i-archive yakho endala.** Izigidi zabasebenzisi zilahlekelwa yiminyaka yobungqina be-WhatsApp xa ubeka ifowuni yokubuyisela: ukuba utsiba i-prompt yokuqala yokubuyisela (okanye ukuba ukubuyisela kuyasilela kwiipesenti ezingama-99) kunye nofakelo olutsha olungenanto lwe-WhatsApp luqhuba i-backup ngokuzenzekelayo kwi-Google Drive okanye iCloud, i-multi-kilogigayidi yembali ugcino olungenanto**.
- Ukuba isikrini sefowuni simnyama okanye saphukile (i-digitizer yokuchukumisa yaphukile) kodwa ifowuni isangcangcazela okanye i-chimes, UNGAYAYI ukuphinda uyiqalise. Kuzo zombini ii-iOS kunye ne-Android (I-File-Based Encryption / Phambi kokuVula kokuQala - BFU vs Emva kokuVulwa kokuQala - AFU), okoko nje ifowuni ivulwe kanye ukusukela oko yaqalayo kwakhona.
AFUurhulumente), izitshixo ze-cryptographic ezikhusela i-database yomyalezo wakho zihleli zikhutshiwe kwi-RAM, ekuvumela ukuba uplage $15 USB-C / Umbane hub enentambo USB mouse mouse kunye HDMI esweni ukucofa."Trust This Computer"kwaye utsale i-backup epheleleyo yendawo. Ukuba unyanzelisa-ukuqalisa kwakhona ifowuni ngesikrini esaphukileyo, iyangenaBFUindawo etshixekileyo apho kungekho mouse ye-USB okanye ikhomputha enokuyivula ngaphandle kokulungisa isikrini kuqala (bona isikhokelo sethu ukubuyiswa kwefowuni ephukile okanye eyonakaliswe ngamanzi). - Nanini na ukhuphela idatabase yeSQLite ekrwada (
sms.dbokanyemsgstore.db), HLALA ukhuphela iifayile ezintathu zabantwana kunye (.db,.db-wal, kwaye.db-shm). Yonke idatabase yemiyalezo yangoku ehambahambayo isebenza kwimowudi SQLite WAL (Bhala-Ngaphambili). Iintsuku zakho zamva nje okanye iiveki zemiyalezo zihlala zihleli ngaphakathi kwiqabanesms.db-walokanyemsgstore.db-walifayile, HAYI ngaphakathi kwengundoqo.dbifayile okwangoku. Ukuba ukhuphela kuphelasms.dbkwaye uhambesms.db-walngasemva, eyona miyalezo yamva nje iyanyamalala okanye ugcino lwedatha luvula njengokonakala. - Bala kwaye urekhode i-cryptographic SHA-256 hash yayo nayiphi na i-backup ethunyelwe ngaphandle okanye ifayile yedatabase ngokukhawuleza. Phambi kokuba uvavanye okanye uguqule nayiphi na ifayile egciniweyo efunyenweyo, sebenzisa
sha256sum(Linux/macOS) okanyeGet-FileHash -Algorithm SHA256(Windows PowerShell) kwindawo yokugcina yokugcina kwaye ugcine umtya we-hash onamagama angama-64. Ngaphantsi kwe-Federal Rule yoBungqina 902(14), ixabiso le-SHA-256 le-hash ngumgangatho wegolide wobungqina enkundleni ukuba umyalezo wakho wedijithali awuzange uguqulwe okanye ufotwe.
flowchart TD
A["Isidingo esiNgxamisekileyo sokuBuyisa kwakhona kwaye ugcine iMiyalezo yoBungqina (iSMS, iMessage, WhatsApp, Signal)"] --> B["UKUZENZA NGOKUKHAWULEZA: Yenza iMowudi yeNqwelomoya kwifowuni kwaye ucime i-auto-cloud backup kwezinye izixhobo"]
B --> C{"Ithini imeko yangoku yefowuni kunye nemiyalezo?"}
C -->|"1. Ifowuni iyasebenza, kodwa imiyalezo icinywe ngempazamo"| D["Khangela ukuba i-Cloud Backup (iCloud / Google Drive) okanye i-WhatsApp yasekuhlaleni '/IiDatabases' ifolda ine-snapshot yokucinywa kwangaphambili"]
D --> E["Ngaphambi kokubuyisela ngefowuni ephilayo: Okokuqala thatha i-Encrypted Backup yasekhaya egcweleyo kwiPC/Mac (`idevicebackup2` / iTunes / Finder / ADB) ukugcina uluhlu lwasimahla lweSQLite WAL"]
C -->|"2. Isikrini sefowuni saphukile / simnyama, kodwa ibhodi isenamandla"| F["Sukuphinda uqalise (Gcina kwimo 'emva kokuvula kokuQala'); qhagamshela i-USB-C/Ihubhu yoMbane + Imowuzi eneNcingo ye-USB + Isiboniso se-HDMI ukuze uvule kwaye ugunyazise ugcino lwePC"]
C -->|"3. Ncokola ifayile yogcino okanye idatabase yeSQLite (`sms.db`, `msgstore.db`, Signal) yonakele / ayibuyi umva"| G["Khuphela ZONKE iifayile EZINTATHU (`.db`, `.db-wal`, `.db-shm`) kulawulo olusebenzayo kwiPC/Mac"]
G --> H{"Ngaba idatabase ifihliwe (`crypt14/crypt15` okanye SQLCipher) okanye iSQLite eqhelekileyo?"}
H -->|"I-WhatsApp Efihliweyo / Umqondiso"| I["Decrypted usebenzisa i-64-char E2EE Iqhosha / `/data/data/com.whatsapp/files/key` (`wa-crypt-tools`) okanye uMqondiso webinzana lokugqithisa elinamanani angama-30 (`izixhobo zogcino-zomqondiso`)"]
H -->|"Idecrypted / iSQLite esemgangathweni"| J["Lungisa amaphepha omthi we-B awonakeleyo usebenzisa `sqlite3 .ubuyise` okanye uqingqe iirekhodi ezicinyiweyo kuLuhlu olukhululekileyo kunye nezakhelo ze-WAL"]
E --> K["Qinisekisa ngeNkundla: Yenza i-SHA-256 Hash + I-PDF enemisonto egcweleyo enee-CDR ze-Carrier + FRE 902(14) isiBhengezo"]
I --> K
J --> K
Uyilo lokugcinwa komyalezo ophathwayo: Apho imiyalezo yakho ihlala khona¶
Ukufumana kwakhona imiyalezo ecinyiweyo okanye eyonakeleyo ngaphandle kokuyitshabalalisa, kuya kufuneka uqonde apho inkqubo nganye yokusebenza kunye neqonga lokuthumela imiyalezo ligcina isiseko sayo sedatha ephilayo, izitshixo zayo zoguqulelo oluntsonkothileyo, kunye nee-backups zasekhaya eziqengqelekayo:
| Usetyenziso lwemiyalezo / OS | Indlela yeFayile yeDatabase yaNgaphakathi | Encryption Architecture | Apho iNdawo efihliweyo okanye i-Cloud Backups ikhona |
|---|---|---|---|
| ** Apple iOS: iMessage & SMS / MMS / RCS ** | /HomeDomain/Library/SMS/sms.db (kunye sms.db-wal kwaye sms.db-shm)Izihlomelo zeMedia: /HomeDomain/Library/SMS/Attachments/(Ngaphakathi kwe-Finder/iTunes i-backup yasekhaya, sms.db isoloko igcinwe phantsi kwe SHA-1 igama lefayile 3d0d7e5fb2ce288813306e4d4636395e047a3d28) |
Standard SQLite 3 database (ekhuselwe kwidiski yi-iOS Data Protection Class C, kwaye ezifihliweyo ngaphakathi PC/Mac yasekhaya backups ukuba "Encrypt local backup" Igama lokugqitha lenziwe). |
1. Local Mac/PC Finder/iTunes Backup (-/Library/Application Support/MobileSync/Backup/ okanye %APPDATA%\Apple Computer\MobileSync\Backup\).2. iCloud Device Backup (ukuba "Messages in iCloud" icimile, izifinyezo ezipheleleyo ze sms.db zingaphakathi iCloud yogcino mihla).3. i-iOS "isandula ukucinywa" Isiqulathi seefayili ngaphakathi kwiMiyalezo app ( Edit -> Show Recently Deleted, igcina iitekisi ezicinyiweyo **30 kwiintsuku ezingama-40 **). |
| I-Android: IMiyalezo kaGoogle (SMS / MMS / RCS) | /data/data/com.google.android.apps.messaging/databases/bugle_db (kunye nomboneleli womnxeba wenkqubo /data/user_de/0/com.android.providers.telephony/databases/mmssms.db) |
Standard SQLite 3 database ngaphakathi hardware-backed Android File-Based Encryption (FBE) umsebenzisi credential partition. | IGoogle One / i-Android Cloud Backup (igcina ngokuzenzekelayo imiyalezo yeSMS kunye neMMS/RCS encanyathiselwe kwiAkhawunti yakho kaGoogle). |
| ** WhatsApp kwi Android ** | Live Internal DB (Ingcambu/Isitshixo siyafuneka): /data/data/com.whatsapp/databases/msgstore.db + /data/data/com.whatsapp/files/keyUgcino lweNdawo oluFikelelwa ngumsebenzisi: /sdcard/Android/media/com.whatsapp/WhatsApp/Databases/msgstore.db.crypt14 (okanye .crypt15) |
.crypt14: AES-256-GCM efihliweyo kusetyenziswa i-158-byte key ifayile egcinwe kuyo /data/data/com.whatsapp/files/key..crypt15: Ugcino oluFihliweyo lokuya ekupheleni ukuya esiphelweni lukhuselwe **iqhosha le-hexadecimal elineedijithi ezingama-64 okanye igama lokugqitha. |
** Iintsuku ezisi-7 zeMbali yeNdawo:** Rhoqo ebusuku nge-02:00 AM, i-WhatsApp kwi-Android igcina ukuya kuthi ga kwii-* iintsuku ezisi-7 zeefayile zogcino zembali** ngqo kwindawo yokugcina yangaphakathi yefowuni yakho (msgstore-YYYY-MM-DD.1.db.crypt14), PLUS ugcino lwamva nje kwi-Google Drive*. |
| WhatsApp kwi iPhone (iOS) | /AppDomainGroup-group.net.whatsapp.WhatsApp.shared/ChatStorage.sqlite (kunye .sqlite-wal)(Ngaphakathi iTunes/Finder backup, ChatStorage.sqlite ikhawuleza ngathi 7c7fba66680ef796b916b067077cc246adacf01d) |
Standard SQLite 3 ngaphakathi iOS App Group isikhongozeli (ukufikeleleka kuyo nayiphi na elufihliweyo okanye igama lokugqitha-decrypted yasekuhlaleni iMac/PC iPhone backup). | ** iCloud Drive WhatsApp Backup ** plus ** Local Mac / PC Finder / iTunes Full Device Backups **. |
| Umqondiso waBucala woMthunywa (i-Android kunye ne-iOS) | Ifayile Yogcino lweNdawo yeAndroid: signal-YYYY-MM-DD-HH-MM-SS.backup** Usetyenziso lweDesktop (iWindows/Mac/Linux):** -/.config/Signal/sql/db.sqlite + config.json (okanye iqhosha le-OS Keychain ekhuselekileyo yokuGcina) |
I-Android .backup: Iguqulelwe ngokuntsonkothileyo nge30 ibinzana logqitho lamanani eliboniswe xa ubuvula ii-backups.I-Desktop yoMqondiso: Iguqulelwe ngokuntsonkothileyo nge-SQLCipher 4; iqhosha le decryption ligcinwe ngaphakathi config.json / OS Keychain kwilaptop yakho. |
I-Critical Forensic Bypass: Nokuba ifowuni yeSiginali isaphukile okanye ilahleke (kwaye iSiginali ye-iOS ayiboneleli ngee-backups zamafu), ukuba ukhe waqhagamshela "I-Signal Desktop" kwi-Windows, Mac, okanye kwi-laptop ye-Linux, imbali yakho yomyalezo ofihliweyo opheleleyo uhleli ngaphakathi kwilaptop. -/.config/Signal/sql/db.sqlite database. |
Imeko 1: Ukufumana kwakhona imiyalezo ecinyiweyo okanye eyonakeleyo ye-iPhone (sms.db & ChatStorage.sqlite)¶
Ukuba i-iMessages ebaluleke kakhulu, iitekisi zeSMS, okanye imiyalezo ye-WhatsApp yacinywa kwi-iPhone, okanye ukuba i-iPhone yonakele, landela la manyathelo ngokuthe ngqo ngokulandelelana okuphambili:
Inyathelo 1: Jonga i-iOS eyakhelwe-ngaphakathi "Esanda kucinywa" ivault (ientsuku zokuqala ezingama-30 ukuya kwezingama-40)¶
Kwi-iOS 16, i-iOS 17, i-iOS 18, kunye nentsha, ukucima isicatshulwa okanye i-iMessage intambo ayifuni ** ayishukumisi ngokukhawuleza kwisithuba soluhlu lwasimahla lweSQLite; iyishenxisa kwisiqulathi seefayili esifihlakeleyo senkunkuma ientsuku ezingama-30 (ukuya kuthi ga kwiintsuku ezingama-40 phambi kokucocwa ngokusisigxina): 1. Vula i **Imiyalezo ** app kwi iPhone. 2. Cofa Hlela (okanye Amacebo) kwikona ephezulu ekhohlo. 3. Cofa Bonisa esandula kucinywa. 4. Khetha incoko kwaye ucofe Buyisa.
Inyathelo lesi-2: Khupha sms.db kwaye ChatStorage.sqlite ukusuka kwi-Local Mac / Windows Backup ngaphandle kokubhala ngaphezulu nantoni na¶
Ukuba umyalezo ucinywe ngokusisigxina ku-"Kutsha nje ukucinywa" (okanye ukuba ufuna ukukhupha imiyalezo yenkundla okanye ukrole imiqolo ecinyiweyo yeSQLite), ** yenza ugcino olupheleleyo lwendawo kwikhompyuter ngokukhawuleza ngelixa ifowuni ikwiMowudi yenqwelomoya**:
- Qhagamshela i-iPhone ngentambo ye-USB kwiMac (Finder) okanye kwiWindows PC (izixhobo zeApple / iTunes) okanye kwiLinux (
libimobiledevice): - Khangela ibhokisi ethi "Shicilela ugcino lwangaphakathi" kwaye usete igama eligqithisiweyo elilula ongayi kulilibala (njenge
Evidence1234). (Kutheni uvule ufihlo olugcinwayo? Ugcino olufihliweyo lwasekhaya lwe-iOS luquka izinto zakudala ezongezelelweyo, idatha yezempilo, imbali yomnxeba, kunye nezinto ezizitshixo ezihluthwa ngu-Apple kwiikopi ezingafihlwanga). - Cofa u-Back Up Ngoku* kwaye ulinde ukuba igqibe.
- ** Fumana ifolda yokugcina ekrwada kwikhompyuter yakho: **
- macOS:
-/Library/Application Support/MobileSync/Backup/<UDID>/ - IiWindows:
%APPDATA%\Apple Computer\MobileSync\Backup\<UDID>\okanye%USERPROFILE%\Apple\MobileSync\Backup\<UDID>\ - ** Khuphela yonke loo nto
<UDID>ifolda ukuya kwiDrive yangaphandle eyohlukileyo ngoko nangoko kwaye ubale i-SHA-256 hash** yayo ukuze umfanekiso wakho woqobo we-forensic ungaze uguqulwe. - ** Fumana eyona datha yedatha yemiyalezo ngaphakathi kwe-iOS Backup usebenzisa i-Apple's SHA-1 Domain Hashes:**
- I-Apple ithiya ngokutsha yonke ifayile ngaphakathi kwe-iOS yogcino kwi SHA-1 hash yayo
Domain-RelativePath, ihlelwe yaba ngabalawuli abancinci ababini:- ** Apple SMS / iMessage Database (
HomeDomain-Library/SMS/sms.db):** Ifumaneka kwisiqulathi seefayili3d/-> ifayile3d0d7e5fb2ce288813306e4d4636395e047a3d28 - ** WhatsApp iOS Database (
AppDomainGroup-group.net.whatsapp.WhatsApp.shared-ChatStorage.sqlite):** Ifumaneka kwisiqulathi seefayili7c/-> ifayile7c7fba66680ef796b916b067077cc246adacf01d - Ugcino lweFayile yesalathiso (
Manifest.db): Isalathiso esikhulu seSQLite esenza imephu yonke ifoto enye, imemo yelizwi, kunye nehashi yokuncamathela kwigama layo lokwenyani lefayileSMS/Attachments/.
- ** Apple SMS / iMessage Database (
- (Ukuba wenze ufihlo olugcinakeleyo, cima ikopi esebenzayo yogcino kwifolda efundekayo usebenzisa izixhobo ezivulelekileyo ezifana
iphone-backup-decryptkwiPython okanye ababukeli abahloniphekileyo basekhaya bathandaiMazingokanyeiBackup Viewer).
Imeko 2: Ukubuyisela kwakhona i-Android WhatsApp .crypt14 / .crypt15 kunye noMqondiso .backup oovimba¶
1. Ukuhlangula i-backup ye-WhatsApp endala ngaphambi kokuba i-7-day rolling window iphelelwe lixesha¶
Kuthekani ukuba umntu ucime incoko ka-WhatsApp ebambekayo kwifowuni yakho ye-Android kwiintsuku ezi-3 ezidlulileyo, kwaye phezolo ngo-02:00 AM I-backup kaGoogle Drive sele iyibhalile ikopi yelifu? - Qhagamshela ifowuni yakho ye-Android kwikhompyuter nge-USB (kwi-Fayile yokuGqithisela / imowudi ye-MTP) okanye uvule i-Android Iifayile app kwaye uye ku:
(okanye kwiinguqulelo ezindala ze-Android:Internal Storage/WhatsApp/Databases/).
- Ngaphakathi kweso siqulathi seefayili, uya kubona ukuya kuthi ga kwiifayile ezisi-7 ezahlukeneyo:
- msgstore.db.crypt14 (I-backup yaphezolo, ilahlekile imiyalezo ecinyiweyo)
- msgstore-2026-10-30.1.db.crypt14 (Ugcino lwayizolo)
- msgstore-2026-10-28.1.db.crypt14 (** Ugcino olusuka kwiintsuku ezi-3 ezidlulileyo, PHAMBI kokuba imiyalezo icinywe **)
- Uyibuyisela njani i-backup yeentsuku ezi-3 kwifowuni yakho ngokukhuselekileyo:
1. Khuphela yonke Databases/ kwaye Media/ Iifolda kwikhompyuter yakho kuqala ukuze kungabikho nto inokulahleka.
2. Phinda unike igama langoku msgstore.db.crypt14 ukuya msgstore-CURRENT-NEW.db.crypt14.bak.
3. Yithiya kwakhona ifayile endala yokucima msgstore-2026-10-28.1.db.crypt14 kwelona gama lefayile esebenzayo msgstore.db.crypt14.
4. Vula Imo yenqwelomoya (okanye urhoxise imvume kaGoogle yeDrayivu kaGoogle okwethutyana ukuze uWhatsApp angatsali ugcino lwelifu elitsha endaweni yoko), yikhuphe kwaye uyifake kwakhona i-WhatsApp, qinisekisa inombolo yakho, kwaye xa uWhatsApp ebhaqa indawo yalapha. msgstore.db.crypt14 ifayile, cinezela Buyisela. Wonke umyalezo osuka kwiintsuku ezi-3 ezidlulileyo uzakuphinda uvele unjalo.
2. Ukucima ukuntsonkotha konakele .crypt14 / .crypt15 WhatsApp backups kwikhompyuter (wa-crypt-tools)¶
Kuthekani ukuba ifayile yogcino lwe-WhatsApp iphazamiseka kwiipesenti ze-95 ngexesha lokubuyiswa kwefowuni kuba i-database ye-SQLite ngaphakathi kwe-wrapper efihliweyo yonakaliswa kancinci? Uyakwazi ukususa uguqulelo oluntsonkothileyo kwi .crypt14 okanye .crypt15 isikhongozeli ngqo kwikhompyuter yakho, lungisa idatabase yeSQLite, kwaye ufunde wonke umyalezo:
- Ukuba unayo .crypt15 Ukuphela-ukuya-ekuMphelweni okuKhuselweyo okuKhuselweyo kwaye ugcine isitshixo se-hexadecimal enamanani angama-64 (okanye ukuba ulukhuphile /data/data/com.whatsapp/files/key okanye encrypted_backup.key), faka i-open-source Python forensic tool wa-crypt-tools (wagolek):
# Install wa-crypt-tools on Linux, macOS, or Windows Python:
python3 -m pip install wa-crypt-tools
# Decrypt a WhatsApp .crypt15 backup using your 64-character hex key:
wadecrypt <your_64_character_hex_key> msgstore.db.crypt15 msgstore.db
# Or decrypt a .crypt14 backup using the extracted 158-byte key file:
wadecrypt key msgstore.db.crypt14 msgstore.db
wadecrypt ivelisa ekrwada msgstore.db Ifayile yeSQLite, ungalungisa nawaphi na amaphepha awonakeleyo omthi we-B usebenzisa iSQLite esemthethweni .recover injini kwiCandelo lesi-3 ngezantsi.
3. Ukukhupha kunye nokulungiswa kweSiqondiso esonakeleyo .backup okanye iDatabase yeDesktop yoMqondiso¶
- Ye Android
signal-YYYY-MM-DD.backupiifayile: Ukuba ifowuni entsha iyala ukurhweba ngaphandle ifayile enkulu yokugcina uMqondiso (okanye ukuba ifayile yanqunyulwa xa kukhutshelwa ikhadi le-SD elifayo), sebenzisa isixhobo esivulelekileyo senkundlasignalbackup-tools(github.com/bepaald/signalbackup-tools) nge30 ibinzana logqitho lamanani eligcinwayo ukukhupha izakhelo ezingonakaliswanga, thumela ngaphandle ugcino lwedatha ekrwada yeSQLite, kwaye wenze incoko yeHTML ecocekileyo, ephendlayo yogcino oluneenkcukacha ezincamatheleyo zingaguquki: - YeDesktop yoMqondiso (
-/.config/Signal/sql/db.sqlite): Nokuba i-smartphone yakho yatyunyuzwa kwingozi yemoto okanye yaphoswa echibini kwaye awunazo ii-backups zefowuni, ukuba ilaptop yakho yakha yaba ne-Signal Desktop* eqhagamshelwe, khuphela lonke uxwebhu lwesicelo soMqondiso (%APPDATA%\SignalkwiWindows,-/Library/Application Support/Signalkwi-macOS, okanye-/.config/SignalkwiLinux) phambi kokuvula usetyenziso, kwaye ukhuphele ngaphandle isiseko sedatha seSQLCipher usebenzisasignalbackup-toolsokanyesqlcipher.
Imeko 3: Ukulungisa isiseko sedatha yengxoxo yeSQLite eyonakeleyo (database disk image is malformed) kunye nokukrola imiqolo ecinyiweyo¶
Xa ifowuni ilahlekelwa amandla ebhetri phakathi-bhala okanye ubandezeleka iimpazamo zokugcina flash, ukuvula sms.db, ChatStorage.sqlite, okanye msgstore.db iphosa impazamo ebulalayo yeSQLite:
Error: database disk image is malformed (SQLITE_CORRUPT)
Ungaze usebenzise i-shareware eyonakalisayo umntu wesithathu "ihlawulwe iSQLite fixer" kwisiseko sedatha sakho sokuqala. Sebenzisa esemthethweni SQLite .recover umyalelo eyakhelwe ngqo kwi sqlite3 (uguqulelo 3.29.0+), oluskena i-4-kilobyte ekrwada kumaphepha edatha enye enye ngokugqitha ezaphukileyo izikhombisi zesalathiso somthi we-B:
Inyathelo ngenyathelo SQLite .recover kunye nokulungiswa kwendawo yokuhlola i-WAL¶
- Yenza ikopi esebenzayo yazo zontathu iifayile zedatha (
.db,.db-wal,.db-shm) kwisiqulathi seefayili esitsha: - Sebenzisa iSQLite esemthethweni
.recoverumyalelo wokwakha kwakhona isiseko sedatha esicocekileyo (kwaye ubambe iirowu ezilahlekileyo/zoluhlu lwasimahla):# Standard recovery of all intact tables and rows into a brand-new healthy database: sqlite3 sms.db ".recover" | sqlite3 sms_repaired.db # FORENSIC DELETED-ROW RECOVERY: Add the --ignore-freelist flag so SQLite ALSO recovers # deleted message fragments still sitting inside unallocated freelist pages into a 'lost_and_found' table: sqlite3 sms.db ".recover --ignore-freelist" | sqlite3 sms_forensic_with_deleted.db - Thumela ngaphandle umbhalo ofundeka ngumntu, wolandelelwano lwe-CSV/HTML ukusuka kuvimba olungisiweyo:
- ** Kuba Apple iOS
sms.db(Ukuguqula i-Apple's CoreData Nanosecond Timestamp ukusukela nge-1 Jan, 2001 ukuya kwi-UTC/Umhla weNdawo):**sqlite3 -header -csv sms_repaired.db " SELECT m.ROWID AS MsgID, datetime(m.date / 1000000000 + 978307200, 'unixepoch', 'localtime') AS Timestamp_Local, CASE WHEN m.is_from_me = 1 THEN 'SENT BY ME' ELSE 'RECEIVED' END AS Direction, h.id AS Contact_Phone_Or_Email, m.service AS Service_Type, m.text AS Message_Body, a.filename AS Attachment_Path FROM message m LEFT JOIN handle h ON m.handle_id = h.ROWID LEFT JOIN message_attachment_join maj ON m.ROWID = maj.message_id LEFT JOIN attachment a ON maj.attachment_id = a.ROWID ORDER BY m.date ASC; " > recovered_imessage_transcript.csv - KuWhatsApp Android
msgstore.db(Yale mihlamessageiskimu setafile):sqlite3 -header -csv msgstore_repaired.db " SELECT m._id AS MsgID, datetime(m.timestamp / 1000, 'unixepoch', 'localtime') AS Timestamp_Local, CASE WHEN m.from_me = 1 THEN 'SENT BY ME' ELSE 'RECEIVED' END AS Direction, jid.raw_string AS Chat_Or_Sender_JID, m.text_data AS Message_Body FROM message m LEFT JOIN chat c ON m.chat_row_id = c._id LEFT JOIN jid ON c.jid_row_id = jid._id ORDER BY m.timestamp ASC; " > recovered_whatsapp_transcript.csv
Ukwenza imiyalezo yakho efunyenweyo 100% ivunywe enkundleni (Ukunqanda ukuchaswa kwe "Fake Screenshot")¶
Rhoqo ngeveki kwinkundla yosapho, inkundla yamatyala amancinci, amatyala othintelo, kunye namatyala oluntu, abantu baya ejajini bephethe izikrini ze-smartphone ezikhululekileyo, apho i-header ephezulu yomfowunelwa ithetha nje igama lesiqhulo. "Ex-Husband" okanye "Landlord Mike" kungekho nombolo yefowuni kwaye akukho mihla epheleleyo. Abameli abachasayo bachasa ngokukhawuleza phantsi kwe-** Federal Rule of Evidence 901 (Lack of Authentication)** kunye Umthetho we-106 (uMthetho wokuGqibela), bephikisana ukuba nabani na unokuthiya ngokutsha ifowuni yesibini ehlawulwa ngaphambili. "Landlord Mike" kwi-app yabo yoqhagamshelwano kwaye babhale imiyalezo yobuxoki kwimizuzwana engama-30.
Warning
Uwenza njani umbhalo wakho kunye nencoko yobungqina obungangenwa bulletproof ngokuchasene nemingeni eyenziweyo yenkundla: Landela la manyathelo mahlanu ongqinisiso lwasenkundleni phambi kokuba ushicilele umboniso wakho wejaji:
I-5-Point Courtroom Authentication Checklist for Text & Chat ubungqina¶
- Cima okwethutyana okanye uQambe ngokutsha iSiteketiso soMfowunelwa phambi kokuba uThunyelelwe ngaphandle/uJonga umfanekiso-skrini ukuze iNombolo yeFowuni ekrwada (
+1-555-019-2834) okanye I-imeyile Ivela kuyo yonke imibhalo engasentla: - Ngaphambi kokuthatha i-screenshots ye-backup (okanye ngcono okwangoku, sebenzisa isixhobo esipheleleyo sokuthumela ngaphandle kwePDF njenge
iMazing,Decipher TextMessage, okanye umbuzo weSQLite CSV ongentla oprinta zombini igama elibonisiweyo KUNYE nekrwadahandle.idinombolo yefowuni kwiqamza ngalinye lomyalezo), qinisekisa ukuba inombolo yefowuni enamanani ali-10 yokwenyani okanye i-imeyile ye-ID ye-Apple yomthumeli ibonakala phezulu komsonto, hayi nje isiqhulo somfowunelwa owenzekayo. - ** Tsala iiNgcaciso zeNgcaciso zeNgcaciso zeNgcaciso zeSelfowuni (CDRs) kunye ne-SMS/MMS yeSitampu seTimesi eLokhu njengeNgcaciso yeQela leSithathu eliZimeleyo:**
- Ngelixa umnikezeli wakho weselula (AT&T, Verizon, T-Mobile, EE, Vodafone, Rogers, Telstra) engawugcini umxholo wombhalo wemiyalezo yeSMS ixesha elide (kwaye akazange abone iMessage/i-WhatsApp umxholo ofihliweyo), isitatimenti sakho senyanga okanye i-akhawunti ye-akhawunti ye-intanethi ibonelela nge- **Iqela lesithathu lokungena elizimeleyo loMhla ngokuthe ngqo, iMizuzu, iNombolo yokuNgena, iSMS kunye neNombolo yeSMS umyalezo kunye nefowuni yelizwi **.
- Ukuncamathisela esemthethweni AT&T / Verizon / T-Mobile yokuSetyenziswa kweLog ngasemva kokuprintwa komyalezo wakho obhaliweyo ingqina ukuba inombolo yefowuni yomnye umntu ithumele iSMS kwifowuni yakho.
14:22:09 on October 12, utshabalalisa naliphi na ibango ozenzileyo umfanekiso wekhusi. - Thumela ngaphandle UMsonto weNgxoxo WOWONKE ONGAHLANGANISWAYO (UMthetho wokuGqibela - UMTHETHO WOKUPHELA 106):
- Ungaze ukhethe ii-screenshots ezizimeleyo okanye ukhuphe ezakho iimpendulo. Ngaphantsi kwe-Federal Rule of Evidence 106, ukuba unikezela ngenxalenye yencoko erekhodiweyo, iqela elichasayo lingafuna wonke umsonto ojikelezileyo, kwaye abagwebi abayithembi imifanekiso eqingqiweyo eshiya izitampu zexesha okanye imiyalezo yangaphambili. Shicilela incoko epheleleyo ngolandelelwano lwamaxesha.
- Gcina iSixhobo sokuqala KUNYE neFayile ye-SHA-256 Hashed Backup (Owona Mthetho woBungqina ogqwesileyo - FRE Rule 1002 kunye noZiqinisekiso-FRE Rule 902(14)):
- Yiza neyona fowuni yokwenyani (ehlawuliweyo yaza yavulwa) kwitafile yenkundla yokumamela ukuze ukuba igqwetha elichasayo licel’ umngeni oko kushicilelweyo, uxelele ijaji: “Mhlonitshwa, ndinesixhobo sokuqala kanye apha kwitafile yabacebisi sokuhlolwa kweNkundla ngokungqinelana nowona Mthetho woBungqina obugqwesileyo.”
- Ukongeza, phantsi kwe-Federal Rule of Evidence 902(14) (kunye nelizwe elilinganayo elamkelwa kulo lonke elase-US), idatha ekhutshelwe kwisixhobo sombane iyaziqinisekisa ngokwayo xa ikhatshwa sisiqinisekiso esibhaliweyo esichaza SHA-256 yexabiso le-hashi yedijithali yotsalo wokuqala kunye nekopi.
- Qhoboshela "Isibhengezo esiSayiniweyo sokuQinisekisa iSibhalo se-Eletroniki/Imiyalezo yeNcoko" (Kopisha-uncamathisele itemplate engezantsi):
DECLARATION AUTHENTICATING ELECTRONIC MESSAGE EVIDENCE
(Pursuant to Federal Rules of Evidence 901(b)(1), 901(b)(4), and 902(14) / State Equivalents)
I, [YOUR FULL LEGAL NAME], declare under penalty of perjury under the laws of the State of [STATE] and the United States of America that the following is true and correct:
1. I am the [Plaintiff / Defendant / Petitioner / Respondent] in this action and have personal knowledge of the facts set forth herein.
2. I am the sole owner and user of the [Apple iPhone / Android Smartphone], assigned telephone number [YOUR 10-DIGIT PHONE NUMBER].
3. Attached hereto as EXHIBIT A is a true, complete, and unedited chronological transcript and printout of [SMS / iMessage / WhatsApp / Signal] messages exchanged between my telephone number ([YOUR NUMBER]) and [NAME OF OTHER PARTY] at telephone number [OTHER PARTY'S 10-DIGIT PHONE NUMBER] between [START DATE] and [END DATE].
4. I personally know that telephone number [OTHER PARTY'S NUMBER] belongs to and is used by [NAME OF OTHER PARTY] because: (a) we have communicated at that number regularly since [YEAR]; (b) I have spoken to [NAME OF OTHER PARTY] by voice call at that exact number and recognized their voice; and (c) the messages inside Exhibit A contain distinctive personal facts, photographs, and references known uniquely to [NAME OF OTHER PARTY] (pursuant to FRE Rule 901(b)(4) Distinctive Characteristics).
5. Not a single message, timestamp, or attachment in Exhibit A has been altered, deleted, or modified in any way. On [DATE OF EXTRACTION], a complete forensic backup of the original messaging database (`[FILENAME, e.g., sms.db / msgstore.db]`) was preserved prior to printing Exhibit A, yielding the following cryptographic SHA-256 hash fingerprint:
SHA-256 Hash: [INSERT 64-CHARACTER HEXADECIMAL SHA-256 HASH FROM sha256sum / Get-FileHash]
6. Attached hereto as EXHIBIT B are true and correct copies of my official mobile carrier call/message detail records from [NAME OF CARRIER] independently corroborating the dates, times, and telephone numbers of the communications.
7. The original smartphone device and the SHA-256 verified backup archive remain in my secure custody and are available for immediate inspection by the Court.
Executed on [DATE] at [CITY, STATE].
____________________________________
[YOUR SIGNATURE]
[YOUR PRINTED NAME]
Imibuzo edla ngokubuzwa¶
Ngaba umphathi wam weselula (AT&T, Verizon, T-Mobile, Vodafone) ungandinika ushicilelo lomyalezo obhaliweyo ocinyiweyo ukuba ndifowunela inkonzo yabathengi?
Hayi, hayi ngenkonzo yabathengi eqhelekileyo, kwaye ayiqhelekanga kwaphela kumxholo womyalezo. Okokuqala, abathwali UNGAZE bafikelele kumxholo we-iMessages, imiyalezo ye-WhatsApp, imiyalezo yeSignali, okanye izingxoxo ze-RCS ezifihliweyo ekupheleni ukuya ekupheleni ngenxa yokuba ezo zidlula kwi-intanethi ngefom efihliweyo, kungekhona ngeeseva ze-SMS ze-Carrier. Okwesibini, nakwimiyalezo ebhaliweyo yeSMS eneqamza eliluhlaza, abathwali abakhulu bakhusela kuphela isiqu esibhaliweyo kwiiseva zabo zokutshintsha umyalezo kangangeentsuku ezi-3 ukuya kwezi-7 (i-Verizon ibamba umxholo we-SMS kangangeentsuku ezi-3 ukuya kwezi-5; I-AT&T kunye ne-T-Mobile zilahla umxholo womyalezo we-SMS ngokukhawuleza emva kokuhanjiswa okanye kwiiyure ezingama-72), kwaye baya kukhulula KUPHELA ukukhulula umxholo we-buffered yenkundla okanye i-SMS esemthethweni yokukhangela. efowunini. Yiyo loo nto ukubuyisela imiyalezo ecinyiweyo ngokuthe ngqo kwisiseko sedatha yeSQLite yefowuni yakho (`sms.db` / `bugle_db`) okanye iCloud/Google Drive backup phantse isoloko ikuphela kwendlela yakho yokubuyisela amagama okwenyani.
Kwenzeka ntoni ukuba omnye umntu kuWhatsApp, Umqondiso, okanye iMessage usebenzisa "Cima wonke umntu" okanye "Ukunyamalala kweMiyalezo" ukucima izoyikiso zabo?
Xa umthumeli ecofa "Cima wonke umntu" (okanye "SukuThumela" kwi-iOS iMessage) ngelixa ifowuni yakho iqhagamshelwe kwi-intanethi, i-app ifumana umyalelo wokucinywa okude osusa umyalezo kwiscreen sakho esibonakalayo. Nangona kunjalo, iindlela ezintathu zokubuyiswa kwe-forensic zisenokuyibamba: (1) Ukuba ubeka ifowuni yakho kwiNdlela yeNqwelo-moya PHAMBI kokuba umthumeli abethe "Cima wonke umntu," umyalelo wokucima ukude awukwazi ukufikelela kwifowuni yakho de ube ufota kwaye ugcine isikrini; (2) Kwiifowuni ze-Android ezine "Mbali yeSaziso" enikwe amandla (`Settings -> Notifications -> Advanced settings -> Notification history`), inkqubo yokusebenza ye-Android igcina isicatshulwa esipheleleyo sayo yonke i-WhatsApp engenayo, iSiginali, kunye nebhena yesaziso se-SMS kwiiyure ze-24, kwaye "Cima wonke umntu" AYIKWAZI ukucima i-log yeMbali yeSaziso se-Android; kunye (3) Kuzo zombini i-iOS kunye ne-Android, umqolo ocinyiweyo uhlala ushiya amaqhekeza okubhaliweyo okushiyekileyo ngaphakathi kweSQLite engacocwanga. `.db-wal` Bhala-Phambili ifayile ye-Log ukuba wenza umfanekiso wefowuni ngoko nangoko kwiMowudi yenqwelomoya.
Kutheni ukuthunyelwa kwam ngaphandle `sms.db` okanye `msgstore.db` uvimba wedatha uphose iintsuku ezi-3 zokugqibela zemiyalezo xa ndiyivula kwi-DB Isikhangeli seSQLite?
Kuba ukhuphele kuphela i `.db` ifayile kwaye ushiye ngasemva kwe `.db-wal` (Bhala-Phambili Log) ifayile kuvimba weefayili. I-iOS yangoku kunye noovimba beenkcukacha be-Android basebenzisa imowudi ye-SQLite WAL, apho yonke imiyalezo esandula ukuthunyelwa nefunyenweyo ihlonyelwa kwiqabane. `.db-wal` ifayile kuqala kwaye zidityaniswa kuphela ("checkpointed") kwengundoqo `.db` ifayile ngamaxesha. Nanini na ukhupha `sms.db`, `ChatStorage.sqlite`, `msgstore.db`, okanye `bugle_db`, KUFUNEKA ukhuphele zontathu iifayile (`filename.db`, `filename.db-wal`, kwaye `filename.db-shm`) kulawulo oluchanekileyo phambi kokuvula idatabase kwiSQLite, eya kuthi emva koko idibanise ngokuzenzekelayo intengiselwano ye-WAL kwaye ibonise umyalezo ngamnye wamva nje.
Ngaba ndingayifumana ilebhu ye-forensics ehambayo yokukhupha iitekisi ezicinyiweyo kwifowuni yam ndisebenzisa i-Cellebrite okanye i-Oxygen Forensics kwityala lenkundla?
Ewe. Ngokungafaniyo hard drive cleanroom recovery, uvumelekile ngokusemthethweni ukuba uqeshe yabucala Certified Digital Forensics Examiner (ubambe iziqinisekiso ezifana asiacis CFCE, GIAC GCFE / GASF, okanye Cellebrite CCO/CCPA) ukwenza imvume yokutsalwa esemthethweni ye-smartphone yakho usebenzisa Cellebrite UFED, okanye i-Magnet AXIOM, okanye i-Magnet AXIOM. Uvavanyo olugunyazisiweyo lwedijithali luhlawulisa umrhumo othe tyaba we-400 yeedola ukuya kwi-1,200 yeedola ngesixhobo ngasinye ukwenza iNdlela ePhambili yokuQondwayo okanye iFayile yokutsalwa, ukukrola uluhlu lwasimahla lweSQLite olucinyiweyo kunye nezinto zakudala ze-WAL, ukuvelisa ingxelo yePDF egxininisiweyo ye-Bates kunye ne-SHA-256 hashes, kwaye usayine umgaqo osemthethweni weSiqinisekiso soBungqina902 (4). ukuziqinisekisa enkundleni ngaphandle kokufuna ingcali ukuba inike ubungqina ngobuqu.
Imithombo ijongiwe¶
- Iziko leSizwe leMigangatho kunye neTeknoloji (i-NIST, eUnited States): * I-NIST Special Publication 800-101 Rev. 1: Izikhokelo kwi-Forensics yeDivaysi ye-Mobile (Ukugcinwa, i-Airplane Mode RF Isolation, i-SQLite Database Artifacts, kunye noQinisekiso lweHash) *.
- I-Ofisi yoLawulo lweeNkundla zase-United States: * Imithetho ye-Federal yoBungqina (FRE) Rule 106 (Intsalela okanye iZibhalo eziNxulumeneyo okanye iiNkcazo eziRekhodiweyo), uMthetho we-901 (b) (1), (b) (4), kunye (b) (9) (Ukuqinisekisa ubungqina be-Electronic), uMthetho we-902 (02) ovela kwi-Data eqinisekisiweyo (i-149) kunye ne-Code 14 Isixhobo ngeHash Value), kunye neRule 1002 (Imfuno yeyoqobo)*.
- I-SQLite Consortium: UXwebhu olusemthethweni lweSQLite ngokuLonwa ngokuBhala-Phambili (iNdlela ye-WAL), iFomethi yeFayile yeeDatha zoBuqhophololo, amaPhepha oLuhlu lwasimahla, kunye
.recoverUmyalelo we-CLI. - I-Apple Inc.: IsiKhokelo soKhuseleko seQonga le-Apple (Iiklasi zoKhuseleko lweDatha, phambi kokuVula kokuQala vs Emva kokuVula kokuQala koLawulo lweSitshixo, kunye ne-iTunes/Finder Backup Manifest Structure).
- IQela eliSebenzayo leNzululwazi kuBungqina beDijithali (SWGDE): *Iindlela ezigqwesileyo zeFowuni yeForensics kunye noVavanyo lweDatabase yeSQLite *.
Izikhokelo ezinxulumeneyo¶
- Ifowuni ephukile okanye eyonakaliswe ngamanzi: ukuhlangula idatha engxamisekileyo
- Ucimo lwefayile ngengozi, idrayivu efomathiweyo, kunye nokubuyisela ifoto
- ILizwi elonakeleyo, i-Excel, iPDF, okanye ukubuyiswa kwefayile yedatha
- I-subpoena yokunika ubungqina, ukufakwa kweisamani, kunye nemihla yokugqibela yokuvelisa amaxwebhu
- Imiyalelo yokuthintela, imiyalelo yokukhusela, kunye nezithintelo ezingxamisekileyo
- Iinombolo zikaxakeka zehlabathi