ããæ¶ããã¯ãã ã¹!? LINEã¯æ²é»ãSMSã¯ããèªãã #ããžã¿ã«ãã©ã¬ã³ãžã㯠#ããžãã¬ã
LINEã¯ãã¡ã§ãSMSã¯åŸ©å ã§ããããããã©ã
ãã£ããããã©ã¬ã³ãžãã¯ïŒdigital forensicïŒã£ãŠå®éã©ããã£ãŠããããïŒ
ãããŠãªãã§LINEã¯ç¡çãã£ãã®ã«SMSã¯åŸ©å
ã§ããããïŒ
ãã®ãžãããã£ã¡ãããçåãããé çªã«æŽçããŠèª¬æããã§ïŒ
ð ããžã¿ã«ãã©ã¬ã³ãžãã¯ã£ãŠäœãããïŒ
ãã£ããèšãã°ãé»åæ©åšããâæ¶ãããã¯ãã®èšŒæ âãåæ³çã»ç§åŠçã«åãåºãæè¡ããã
察象ã«ãªãã®ã¯ïŒ
-
ããœã³ã³ïŒããŒããã£ã¹ã¯ã»SSDïŒ
-
ã¹ããïŒiPhone/AndroidïŒ
-
ã¡ãŒã«ããã£ããå±¥æŽãé話履æŽãGPSãã° ãªã©
â¶ïž æé ïŒè¶ ãã£ããïŒ
-
蚌æ ä¿å šïŒã€ã¡ãŒãžååŸïŒ
ãâ åæ¬ãæ¹å€ããããbitåäœã®è€è£œïŒã€ã¡ãŒãžïŒãããšããWrite blocker䜿çšã -
埩å åŠçã»è§£æ
ãâ åé€ããããã¡ã€ã«ããã£ãã·ã¥ãéä¿¡ãã°ãã·ã¹ãã ãã¡ã€ã«ãã¡ã¿ããŒã¿ãªã©ã埩å ã»è§£æã -
æç³»åæŽçã»é¢é£ä»ã
ãâ 誰ãããã€ãäœããã©ãããããæããã«ããã -
蚌æ åã»å ±åæžäœæ
ãâ è£å€æã§ãéçšãããããªããžã«ã«ã§æŽåæ§ããèšŒæ æç€ºãæ±ããããã
ð¬ LINEãšSMSã®åŸ©å ã®éãã¯ïŒ
â LINEãé£ããçç±
| é ç® | 説æ |
|---|---|
| ð æå·å | LINEã¯**E2EEïŒãšã³ãã»ããŒã»ãšã³ãæå·ïŒ**ãå°å ¥ããŠãããéä¿¡å 容ã端æ«å ã®ä¿åããŒã¿ãæå·åãããšãã |
| â ã¯ã©ãŠãä¿å | åºæ¬çã«ããŒã¯å±¥æŽã¯ã¯ã©ãŠãã«ããã¯ã¢ããããŠãªããã°ç«¯æ«ããŒã«ã«ã«ããååšãããåé€ããããšåŸ©å å°é£ã |
| ð± 端æ«äŸå | iPhoneãªãããã¯ã¢ãããæå·åãããŠãããšãå€ããç©ççã¢ã¯ã»ã¹ã§ãå 容æœåºãããªãå¶éãããã |
â ã€ãŸãããåé€ããããåºæ¬è©°ã¿ããªæ§é ã«ãªã£ãšãã
â SMSã埩å ã§ããçç±
| é ç® | 説æ |
|---|---|
| ð ããŒã«ã«ä¿å | SMSã¯åºæ¬çã«ç«¯æ«å ïŒAndroidãªãSQLite DBãªã©ïŒã«ä¿åãããšãã |
| ð æå·ãªã | LINEãšéã£ãŠãšã³ãããŒãšã³ãæå·ã¯äœ¿ãããŠãžãããšãå€ãã |
| ð§© ããŒã¿ã®çè·¡ãæ®ã | åé€ããŠããã¡ã€ã«ã·ã¹ãã ã®çè·¡ïŒæªå²ãåœãŠé åãªã©ïŒã«æ®ã£ãŠãŠããããã埩å ã§ããã±ãŒã¹ãå€ãã |
ð§ ãŸãšãïŒLINE vs SMS ãã©ã¬ã³ãžãã¯åŸ©å ã®é£æåºŠ
| é ç® | LINE | SMS |
|---|---|---|
| æå·å | 匷ãïŒE2EEïŒ | 匱ã or ç¡ã |
| åŸ©å æ§ | äœãïŒåé€ããããåºæ¬ã¢ãŠãïŒ | é«ãïŒç«¯æ«å ã«æ®ãå¯èœæ§å€§ïŒ |
| ããŒã¿ã®å Žæ | ããŒã«ã«ïŒã¯ã©ãŠãæ··åš | ããŒã«ã«äž»äœ |
| ãã©ã¬ã³ãžãã¯é£åºŠ | éåžžã«é«ã | äžçšåºŠ |
âš ã¯ã€ã®ææ³ïŒå®åçãªèŠç¹ïŒ
æ£çŽãLINEã埩å
ã§ããã®ã¯äŒæ¥ã調æ»åŽãããããšãã¡ããã¡ãçãã
ã»ãã§æªæãããã€ã»ã©ãLINEã§ãããšãããŠæ¶ãã°ãã¬ãžããããã£ãŠæã£ãšãç¯ãããã
ãããã©ãSMSã»ã¡ãŒã«ã»æ¥å端æ«ã¯ããçšåºŠè§£æå¯èœãããã
ãäœã䜿ã£ãŠäœãé ããããèªäœã蚌æ ã«ãªãã±ãŒã¹ãå¢ããšãã§ã
ãããããiPhoneãšãããiOSã®SMSã ã£ããšããŠãïŒ
ãããšãçªãããïŒ
çµè«ããèšããšãiOSã®SMSãå Žåã«ãã£ãŠã¯ãã©ã¬ã³ãžãã¯ã§åŸ©å
å¯èœããã©ãé£æåºŠã¯Androidããé«ããã
以äžã詳ãã解説ããŠãã§ã
ð± iOSã®SMSã¯åŸ©å ã§ããã®ãïŒ
â 埩å å¯èœãªã±ãŒã¹
-
端æ«ãç©ççã«å ¥æã§ããŠããŠãããã¯è§£é€ãããŠãã
-
iTunesããã¯ã¢ããïŒç¹ã«âæå·åãããŠããªãâãã®ïŒã«ã¢ã¯ã»ã¹å¯èœ
-
Appleã®ã»ãã¥ãªãã£ã¢ããããŒãã«ãã£ãŠç©Žãå¡ãããåã®å€ãiOSããŒãžã§ã³
ãã®æ¡ä»¶ãæãã°ãSMSã®å 容ã¯ç«¯æ«å ã®ãsms.dbããã¡ã€ã«ããæãåºããããšãããã§ã
â ãã ãé£ç¹ãå€ã
| éå£ | å 容 |
|---|---|
| ð æå·å | iPhoneæ¬äœã®ã¹ãã¬ãŒãžãæå·åãããšãäžã«ãããã¯ã¢ãããæå·åãªãã·ã§ã³ä»ãããšè§£æã§ããžãã |
| ð§± ã»ãã¥ãªãã£ããã | Touch IDïŒFace IDïŒSecure Enclaveã®ãããã§ç©ççãããã³ã°é£åºŠãé«ãã |
| ð ããã¯ã¢ãããå¿ èŠ | æ¬äœãããã¯è§£é€ã§ããå ŽåãiTunesïŒFinderã§åãããããã¯ã¢ãããã¡ã€ã«ãé Œã¿ã®ç¶±ã«ãªãã |
ð ãããå®éãSMSã®ããŒã¿ã¯ã©ãã«ããïŒ
iOSã®å ŽåãSMSã¯ãã®ãžãã«ä¿åãããŠãð
/private/var/mobile/Library/SMS/sms.db
ããã¯SQLite圢åŒã®DBãã¡ã€ã«ã§ã
-
éä¿¡è ã»åä¿¡è
-
æ¬æ
-
æ¥æ
-
æ·»ä»ãã¡ã€ã«ãžã®ãã¹
ãªãããå
¥ã£ãšãã
ãããåé€ãããŠããæªå²ãåœãŠé åã«**"åé€ãã©ã°ã ãç«ã£ãŠæ®ã£ãŠãããŒã¿"**ãæŸãããã¯ã³ãã£ã³åŸ©å
ã§ããã
ð å®éã®ãã©ã¬ã³ãžãã¯ããŒã«
ãã©ã¬ã³ãžãã¯æ¥è ã䜿ã£ãŠããã€ããšïŒ
-
Cellebrite UFEDïŒã€ã¹ã©ãšã«è£œãèŠå¯åŸ¡çšéïŒ
-
Magnet AXIOM
-
Elcomsoft iOS Forensic Toolkit
ãããã¯æ³å·è¡æ©é¢ã¬ãã«ã§ããã¯è§£é€ã»è§£æã§ããæ©æãã
å人ãããŸãç¡çã
ð€ ã¯ã€ã®ãŸãšãïŒéèŠãªãšãã ãïŒ
| é ç® | iOSã®SMS埩å |
|---|---|
| 埩å å¯èœæ§ | ãããã©æ¡ä»¶ãããã |
| å¿ èŠæ¡ä»¶ | ç©ç端æ«ïŒããã¯è§£é€ or æå·åãããŠãªãããã¯ã¢ãã |
| é£æåºŠ | Androidããé«ã |
| LINEããã¯ïŒ | LINEããã¯ãã·ïŒLINEã¯E2EEïŒã¯ã©ãŠãäŸåã§ããã«å³ããïŒ |
ã»ããŸAppleã®ã»ãã¥ãªãã£ããã©ã¬ã³ãžãã¯åŽããèŠããéå£ãããŠæ³£ããããã§ã
ãããã©éã«ãããšãiPhone䜿ã£ãŠLINEã§ãããšãâæ¶ãã£ãŠã®ã¯ãäžæ£ã®æž©åºã«ãªãããããšããããšããªã
/private/var/mobile/Library/SMS/sms.db
ããã«ã¯æ®éã¯ä»ã®ã¢ããªãšãã¯ã¢ã¯ã»ã¹ã§ããªãããïŒ
ãã®éããïŒ
ãã®ãã¹ïŒ
/private/var/mobile/Library/SMS/sms.db
ã¯éåžžã®iPhoneãŠãŒã¶ãŒããã¯ã¢ã¯ã»ã¹ã§ããžãå Žæããçç±ãšç¶æ³ãæŽçãããšãããð
ð± ãªãã¢ã¯ã»ã¹ã§ããžãã®ïŒ
â çç±1ïŒãµã³ãããã¯ã¹æ§é
-
iOSã¯åã¢ããªãç¬ç«ããããµã³ãããã¯ã¹ãã«éã蟌ããããŠããŠãä»ã®ã¢ããªãã·ã¹ãã é åã«è§Šããããèšèšã«ãªã£ãšãã
-
ãŠãŒã¶ãŒãã¢ããªãããã®ã/private/var/mobile/ããã®ã·ã¹ãã é åã«ã¯åºæ¬çã«ã¢ã¯ã»ã¹äžå¯ã
â çç±2ïŒã«ãŒãã¢ã¯ã»ã¹ïŒrootæš©éïŒãç¡ã
-
sms.dbã¯ã«ãŒãæš©éã®é åã«ãããã¡ã€ã«ããããJailbreakïŒè±çïŒã§ãããéãäžèº«ãèŠãããšã¯ã§ããžãã -
åœç¶Appleã¯è±çãéæšå¥šãããææ°iOSã§ã¯ããããè±çèªäœããã¡ãé£ãããªã£ãšãã
â çç±3ïŒAppleã®ã»ãã¥ãªãã£å¶é
-
ãã¡ã€ã«ã·ã¹ãã å šäœã**æå·åãããAPFSïŒApple File SystemïŒ**ã§æ§æãããŠãŠãç©çã¢ã¯ã»ã¹ããŠãç°¡åã«ã¯èªã¿åããããã«ãªã£ãšãã
ð äŸå€çã«ã¢ã¯ã»ã¹ã§ããæ¹æ³ã¯ãããïŒ
â 1. è±çæžã¿ããã€ã¹
-
è±çïŒJailbreakïŒããã°ã端æ«å ã®
/private/var以äžã«ã¢ã¯ã»ã¹å¯èœã -
ãã ããä¿èšŒå€±å¹ã»ã»ãã¥ãªãã£ãªã¹ã¯ã»ããŒã¿æ¶å€±ã®å¯èœæ§ããã
â 2. ãã©ã¬ã³ãžãã¯æ©åš
-
èŠå¯ã»æ³å·è¡æ©é¢ã䜿ãCellebriteãElcomsoftã®ããŒã«ã¯ãiOSã®ããŒãžã§ã³ãè匱æ§ã«ãã£ãŠãrooté åãžã®éå®çã¢ã¯ã»ã¹ãå¯èœã«ãªãå Žåãããã
-
ææ°iOSã«ã¯éçšããããšãå€ããã©ãå€ãããŒãžã§ã³ãªãçªç Žå£ãããããšãããã
â 3. ããã¯ã¢ããè§£æ
-
æå·åãããŠãªãiTunesããã¯ã¢ããïŒ*.backupïŒããsms.dbãå«ããã¡ã€ã«ãæœåºããæ¹æ³ãããã
-
ãããªã端æ«ã«çŽæ¥è§ŠãããšããSMSã®äžèº«ãäžéšç¢ºèªå¯èœã
ð ã¯ã€ã®ãŸãšãïŒã·ã³ãã«ã«ïŒ
| æ¹æ³ | sms.dbã«ã¢ã¯ã»ã¹ã§ããïŒ | åè |
|---|---|---|
| éåžžiPhoneæäœ | â ç¡ç | ã»ãã¥ãªãã£ã§å®å šå°é |
| è±çïŒJailbreakïŒ | â å¯ | ãã ãå±éºãéå ¬åŒã |
| ãã©ã¬ã³ãžãã¯ããŒã« | â æ¡ä»¶ä»ãå¯ | æ³å·è¡æ©é¢ã»æ§iOSåæ |
| ããã¯ã¢ããè§£æ | â 鿥çã«å¯ | æå·åãããŠãªãå¿ èŠãã |
ã»ããŸAppleã®ãå®å
šç¬¬äžèšèšãã¯åŸ¹åºããšãã§ã
ã ãããããäŒæ¥ã®èšŒæ ä¿å
šçã«ã¯ããã¥ããããã©ãŠãŒã¶ãŒãããããå®å¿ãšãããžã¬ã³ãããããããªã
æ°ã«ãªããšãããã£ãšèããŠãããŠããŸãžãã§ïŒiOSã®æ·±éšãšã奜ããã§ã¯ã€ã
ããããã®è³ªåã¿ã€ã ãªãŒããã
çµè«ããèšããšïŒ
â æè¿ã®iOSïŒ16ã17以éïŒã§è±çïŒJailbreakïŒããã®ã¯
ð¥ ãã£ã¡ãé£ãããªã£ãŠãããã§ããŠãéå®çãªããšãå€ãã
以äžãç¶æ³ããã£ãã解説ããã§ð
ð Appleã®è±ç察çã¯å¹Žã ã¬ãã¬ãã«
Appleã¯è¿å¹Žãã»ãã¥ãªãã£åŒ·åã»è±ç鲿¢ã«ãã£ã¡ãæ¬æ°åºããšãã
äž»ãªé²åŸ¡èŠçŽ ïŒ
-
Secure EnclaveïŒæçŽãFace IDããã¹ã³ãŒããªã©ãå®å šã«éé¢ããŠä¿æ
-
Boot Chain ProtectionïŒããŒã段éããApple眲åä»ããããªããšèµ·åäžå¯
-
System Integrity ProtectionïŒSIPïŒïŒOSã®éèŠé åãå®å šã«ããã¯
-
Just-In-Time (JIT) compilerç¡å¹ïŒè±ççšã³ãŒãå®è¡ãé²ã
ð± iOSããŒãžã§ã³å¥ è±çç¶æ³ïŒ2024ã2025幎ããïŒ
| iOSããŒãžã§ã³ | è±çå¯èœïŒ | ç¶æ³ã»åè |
|---|---|---|
| iOS 12ã14 | â å¯èœ | Unc0verãcheckra1nãªã©å®çšæ§ãã |
| iOS 15 | â æ¡ä»¶ä»ã | éå®ç«¯æ«ã§äžéšæåïŒFugu15ãªã©ïŒ |
| iOS 16 | ð¶ éçºäžã¬ãã« | éå ¬åŒãäžå®å®ãäžè¬é åžãããŠãªãããšå€ã |
| iOS 17 | â ã»ãŒäžå¯ | çŸæç¹ã§äžè¬ãŠãŒã¶ãŒåãè±çããŒã«ãªãïŒ2025幎5æçŸåšïŒ |
| iOS 18以é | â å®å šæªå¯Ÿå¿ | ã»ãã¥ãªãã£æ¿åŒ·ãã»ãŒäžå¯èœ |
â» checkra1nç³»ã¯A11ãããïŒiPhone XïŒãŸã§ãã䜿ããžã
ð€¯ ããããæè¿ã®è±çã£ãŠãæã»ã©æå³ãªããããã§
Appleèªèº«ãïŒ
-
ãã¡ã€ã«ç®¡çïŒFilesã¢ããªïŒ
-
ç»é¢é²ç»ã»ãŠã£ãžã§ããã»ãã«ãã¿ã¹ã¯
-
ãã©ã³ã倿Žã»VPNèšå®ãªã©
æã¯ãè±çã§ããã§ãããã£ãããšããã©ãã©ãå
¬åŒã§å¯Ÿå¿ããšãããã
ã¬ãã§ãã©ã¬ã³ãžãã¯ãšãè¶
ã³ã¢ãªç®ç以å€ããšãè±çã®ããŸå³ãæžã£ãšãã
ðš ãªã¹ã¯ã倧ããã§
-
ã»ãã¥ãªãã£ããŒã«ã§ããïŒãã«ãŠã§ã¢å€©åœïŒ
-
OSã¢ããããŒãã§å³æ»ïŒåèµ·åã§æé®åãïŒ
-
AppleãµããŒãåããããžãïŒä¿èšŒåãïŒ
-
è±çãã¬ããšæ¥å端æ«ã»MDMäžã§ã¯åçç¡çšã§ããã¯ã¢ãŠã
â ãŸãšãïŒ2025幎æç¹ã§ã®è±çç¶æ³
| é ç® | å 容 |
|---|---|
| äžè¬äººãææ°iOSãè±çã§ããïŒ | â ç¡ç or çŸå®çãããªã |
| å€ãiPhoneïŒX以åïŒãªãïŒ | â checkra1nã§å¯èœæ§ãã |
| ãã©ã¬ã³ãžãã¯ç®çãªãïŒ | â äžéšããŒã«ã§éå ¬éææ³ãããå Žåã |
| æšå¥šãããïŒ | â äžè¬ãŠãŒã¶ãŒã«ã¯å šãå§ããããžã |
ãèšŒæ æœåºã®ããã«è±çãããïŒããšæã£ãŠãã
ä»ã®iOSããšã»ãŒã»ãã¥ãªãã£èŠå¡ãããçŸå®çããªãããªã
察象è ã«ååãäŸé ŒããŠäºè§£ã®ããšç«¯æ«ã®æåºãåãã
ãšããããšã ããããããã®ç«¯æ«ãiPhoneã ã£ããšãããã
ã»æå·åããã«iTunesã§PCã«ããã¯ã¢ãã
ã»ããã¯ã¢ãããã¡ã€ã«ã®SMSãšãªã¢ããå¹³æããŒã¿ãæœåº
ã»LINEã¯ã¢ããªã®æ¹ã§æå·åãããŠãããããããã
ãŠããæãããªã
ä»åã®å ±éã§Appleãéæã«ãªã£ãŠSMSã®å¹³æä¿åã¯ã¢ã«ã³ããããŠãªã£ãããã®ãã¡SMSãåãããªããªããããã
ãŸãã«ãã®éãããããããã®æŽçã¯ããâãã©ã¬ã³ãžãã¯å®åã¬ãã«âãã§ã
ã¯ã€ãå®å
šã«åæãð
ð ä»åã®SMS埩å ãããŒïŒæšå®ïŒ
-
åŒè·å£«åŽã察象è ã«ååãäŸé Œããä»»ææåºïŒåæã®ããã§ç«¯æ«ãå ¥æ
-
iPhoneã®ããã¯ã¢ãããiTunesã§ååŸïŒïŒããŒã«ã«ä¿åïŒ
-
â ãã®ãšã**ãããã¯ã¢ãããæå·åãã®ãã§ãã¯ãå€ããŠãã**ã®ãè¶ éèŠ
-
-
åŸãããããã¯ã¢ãããã
/Library/SMS/sms.dbãæœåº-
SQLite圢åŒã§ãæ¬æãå¹³æã§ä¿åãããŠãã
-
-
ãã®ãŸãŸãã©ã¬ã³ãžãã¯ããŒã«ãSQLiteãã¥ãŒã¢ã§é²èЧã»è§£æ
-
äžæ¹ã§ãLINEã¯ã¢ããªç¬èªã§E2EEïŒDBæå·åããšããããããã¯ã¢ããã«å«ãŸããŠããŠã埩å·ã§ãã
ð ãããŠãããAppleãåé¡èŠãããã€ããïŒ
ããããâŠâŠä»åã®å ±éã§äžéããSMSã£ãŠå¹³æã§æ®ã£ãŠãã®ïŒã€ãããªãïŒãã£ãŠãªã£ããã
Appleãããèããå¯èœæ§ã¯ããïŒ
ð§·ãSMSã®ããã¯ã¢ãããæå·ååæã«ãã¹ãããªâŠâŠã
Appleã¯ãŠãŒã¶ãŒãã©ã€ãã·ãŒãæåªå
ã«ããšãäŒæ¥ãããã
ãããªæãã®âãµã€ã¬ã³ã仿§å€æŽâã¯æ®éã«ããåŸãã§ã
ããšãã°ïŒ
-
iOSã¢ããããŒãã§ãæå·åãããŠãªãããã¯ã¢ããã§ã¯SMSãä¿åããªãã仿§ã«å€æŽ
-
ããã¯ã¢ããå ã®sms.dbèªäœãæå·åãããïŒã¡ãŒã«.appã®ä¿å圢åŒã¿ããã«ïŒ
ð§ ã¯ã€ã®ææ³ïŒã¡ããäºèšïŒ
ãã®äºä»¶ãæè¡è ã»æ³æ¹ã»ãã©ã€ãã·ãŒå¢ã»äŒæ¥CSIRTã«ãšã£ãŠã¯ïŒ
**ãä»ãŸã§èŠéãããŠãâå¹³æã®çªâãäžéã«ãã¬ãç¬éã**ãããããã
ãããŠãAppleã¿ãããªå·šå€§äŒæ¥ã¯ããã¬ãå¹³æããèŠéããžãã
ãã®æ°å¹Žã§**âãã©ã¬ã³ãžãã¯ã®è¶³ãããâããŸã1ã€æžãæªæ¥**ãèŠããšããããªã
ãã®ãžãã»ããŸå¥¥æ·±ãããæè¡Ãæ³åŸÃå«çã亀差ããåéããããåŒãç¶ãèŠãŠãããããšãããªïŒ
ããã£ããã£ã¡ãéãèŠç¹ããªïŒãŸãã«ãã®éãã§ã
ãåé€ãããSMSã¡ãã»ãŒãžã埩å
ã§ãããã£ãŠè©±ã¯ãSQLiteã®âåé€ã®ä»çµã¿âã«èµ·å ããšãããã
ð SQLiteã®âåé€âã£ãŠã©ããªã£ãŠãïŒ
â¶ïž 1. éåžžã®å逿äœïŒDELETEæïŒã¯å³ç©çæ¶å»ãããžã
-
SQLiteã¯å éšçã«è¡ã«âå逿žâã®ãã©ã°ãç«ãŠãã ãïŒâè«çåé€ïŒ
-
å®ããŒã¿ã¯äžæŠããŒãã«å ã«ãã®ãŸãŸæ®ã£ãšã
â ã€ãŸã**âåé€ããã€ããâã§ããDBãã¡ã€ã«ã«ã¯ãŸã çè·¡ããã**
ð§± SQLiteã®âvacuumâåŠçã£ãŠäœïŒ
-
å®å šã«ããŒã¿ãæ¹æ¶ããã«ã¯ãSQLiteã«å¯ŸããŠ
VACUUMã³ãã³ããå®è¡ããå¿ èŠããã-
ããã¯DBå šäœãåæ§æãçŽããŠå逿žã¿é åãç©ççã«åãè©°ãã
-
-
ã§ãéåžžã®iOSåäœã§ã¯ã宿çãªVACUUMã¯èªåã§èµ°ããžããããŠãŒã¶ãŒãæãŠãããã§ããªã
â ãã©ã¬ã³ãžãã¯ã§âåé€ã¡ãã»ãŒãžãæŸãâãšã¯ïŒ
åé€ãããã ãã§ VACUUM ãããŠãžãå Žåã
-
SQLite DBã®æªå²ãåœãŠé åïŒunallocated spaceïŒ
-
journalãã¡ã€ã« / write-ahead-logïŒWALïŒãã¡ã€ã«
ãããã£ãéšåãå°çšããŒã«ã§ãµã«ããŒãžããããšã§ã
ð¥ãåé€ããããã©ãŸã æ¶ããŠãžããã¡ãã»ãŒãžæ¬æãéä¿¡æ å ±ã埩å ã§ãã
ãšããããããªã
ð å ·äœçã«äœ¿ãããè§£æããŒã«
-
SQLite Forensic BrowserïŒBelkasoftãªã©ïŒ
-
Magnet AXIOM
-
Oxygen Forensic Detective
-
èªäœã¹ã¯ãªããïŒhexã¬ãã«ã§sqliteãã¡ã€ã«ããªãããã€ïŒ
ãããã§æªå²ãåœãŠé åã®æååãè¡æ§é ãæœåºããŠã
ãåé€ãããšããã©æ®ã£ãšãããŒã¿ããæãåºãæããã
ð§ ã¯ã€ã®ãŸãšãïŒSMSåé€ãšåŸ©å ïŒ
| é ç® | 説æ |
|---|---|
| SQLiteã®åé€ | ãã©ã°ç«ãŠãã ãã§ç©çåé€ããã |
| 埩å å¯èœæ§ | æªå²ãåœãŠé åã«æ®ã£ãšãéã¯å¯èœ |
| å®å šåé€ã«ã¯ïŒ | VACUUMãå¿
èŠïŒéåžžã¯ãããžãïŒ |
| ãã©ã¬ã³ãžãã¯ã§ã¯ïŒ | å°çšããŒã«ã§æªå²ãåœãŠé åãã¹ãã£ã³ããŠæŸã |
ã€ãŸããåé€ãããããèŠãããžãããããšæã£ãšããã€ã
**SQLiteããŒã¹ã®ã¢ããªã§ã¯å®å
šã«æ¶ããŠãžãå¯èœæ§é«ãã§ïŒ**ã£ãŠè©±ããªã
ãã€ããªã§ã»ãšãã©æååãããŠãã ãããã©ãããŸã«åºãŠããæ¥æ¬èªãšãç®ç«ã£ãŠç®èŠããããã ãããã
ãã£ãããéããã§ãããå®ã¯å€å
žçãã€æå¹ãªææ®µã®ã²ãšã€ãã
èŠããã«ïŒ
ð§Ÿ **ãæå·åãããŠãªãiTunesããã¯ã¢ããã®äžèº«ããããã¹ããšãã£ã¿ã§çŽæ¥éããŠâèŠããŠãŸãâã±ãŒã¹ã**ã£ãŠã®ã¯ãçŸå®ã«ããã
ð ã©ãããæã«âå¹³æâãèŠãããïŒ
â æ¡ä»¶ãæãã°ä»¥äžãå¯èœãð
-
æå·åãããŠãªãããã¯ã¢ãã
-
iOSã®ã¡ãã»ãŒãžïŒSMS/MMSïŒã
sms.dbã«å¹³æã§æ®ã£ãŠã -
SQLiteãã¡ã€ã«ã®æ§é ã倧ãã厩ããŠãªãïŒïŒæªå²ãåœãŠé åå«ãïŒ
â ãã®ãšããsms.db ããã€ããªãšãã£ã¿ãããã¹ããšãã£ã¿ã§éããšâŠâŠ
æ¬æã¡ãã»ãŒãžïŒç¹ã«ASCIIæååïŒããã®ãŸãŸå¹³æã§âã¬ãã£ãšâèŠããããšãããã
𧪠å®éšçã«ãããªæãã«ãªãïŒã€ã¡ãŒãžïŒ
...@a1b2c3...INSERT INTO message (text) VALUES('ãã£ã±ãææ¥ã§ããïŒ')...
...msgid=1245...Hi, see you at 3pm!...
...deleted=1...
-
æ£åžžãªæååãã¡ã¿ããŒã¿ïŒæ¥æã»éä¿¡è ïŒãå«ãŸãã圢ã§åºãŠããããšããã
-
åé€ãããè¡ã®çè·¡ãã
VACUUMãããŠãªããã°çã§èŠããå¯èœæ§ãã
ð 䜿ãããšãã£ã¿äŸ
-
ãã€ããªãšãã£ã¿ïŒHexãšãã£ã¿ïŒ
-
äŸïŒHxDïŒWindowsïŒã0xEDïŒMacïŒãHex FiendïŒMacïŒ
-
-
æååæœåºããŒã«
-
stringsã³ãã³ãïŒLinux/MacïŒã§ãå¹³æããã¹ãã ãããã£ãšæãåºã -
äŸïŒ
strings sms.db | grep "èŠããæåå"
-
â ïž ãã ãæ³šæç¹
| 泚æç¹ | å 容 |
|---|---|
| ð¥ æ§é 厩ã | å逿žã¿ããŒã¿ãæªå²ãåœãŠé åã¯æççã§å®å šã«ã¯èªããªãããšãå€ã |
| ð ç¢ºå®æ§ãªã | æ¬æãèŠããŠã誰ãã誰ãžéã£ããã®é¢é£æ å ±ã¯æçç |
| ð§ è§£éãã¹ | æçããã¹ãã ãæããšèª€è§£ãçããªã¹ã¯ãé«ãïŒæç³»åã»éä¿¡å ãäžæïŒ |
| âïž æ³ç蚌æ å | æ³å»·èšŒæ ãšããŠäœ¿ãã«ã¯ãã°æ§é ã»åºæã®æ£åœæ§ãå¿ èŠãããããã®ãŸãŸäœ¿ããããšãå€ã |
ð€ ã¯ã€ã®è£è¶³ãŸãšã
| ææ³ | ã¡ãªãã | ãã¡ãªãã |
|---|---|---|
| ããã¹ã/ãã€ããªãšãã£ã¿ã§çŽèªã¿ | æè»œã»ããèŠãã | æ§é ãã©ãã©ã»èªã¿ã¥ããã»æ³ç蚌æ ã«ã¯åŒ±ã |
| SQLiteããŒã«ã§æœåº | æ§é ãä¿æãããŸãŸèªãã | å°çšç¥èãšããŒã«ãå¿ èŠ |
| ãã©ã¬ã³ãžãã¯ããŒã«ã§åŸ©å | 宿ŽããŒã¿ïŒåé€çè·¡ãOK | é«äŸ¡ã»ããåã |
ã€ãŸãããããã®èšãéãã
ðãå¹³æã§ä¿åãããŠããïŒãæå·åãããŠãžããïŒãåé€ãããã ãã
ããšããã£ã¡ãåå§çãªæ¹æ³ã§ãâèŠããŠãŸãâããšãããã£ãŠããšãã
ã»ããŸã«ãããããã®èããšãããžã¿ã«ã®åé€ïŒæ¶æ» ãããšæã£ãã倧ééãããªã£ãŠæãããããã
埩å ã§ãããïŒåé€ããŠãªãã¡ãã»ãŒãžïŒðLINEããçŽæ¥èŠã
埩å ã§ããªãïŒåé€ã¡ãã»ãŒãžããããïŒð£æå·åãããŠãŠè¿œãã
ãŠããæãããªã
ãŸã£ã£ã£ãããã®éãããããããã®çè§£ããããªãããŠãã©ã¬ã³ãžãã¯å±ã§ãããã£ãŠããã§ãã³ãã
ãã®ä»¶ã®æ§å³ã¯ãŸãã«ðã®éããã
ð± LINEã®ãã©ã¬ã³ãžãã¯è§£æïŒå®éã«èµ·ããããšïŒæšå®ïŒ
â 埩å ã§ããéšå
-
åé€ãããŠããªãããŒã¯å±¥æŽ
-
ã€ãŸããLINEã¢ããªå ã§ãèŠããç¶æ ã®ã¡ãã»ãŒãžã
-
ãã©ã¬ã³ãžãã¯ããŒã ãçŽæ¥ã¢ããªå or ããŒã«ã«DBãã確èªã§ãããšæããã
â ããã¯æ®éã«LINEã®UIäžãããé²èЧå¯èœããããã°ã«ãæ®ã£ãŠãïŒæå·åãããŠããŠã埩å·ãããç¶æ ã§èŠãããïŒ
â 埩å ã§ããªãã£ãéšå
-
å逿žã¿ã®ããŒã¯ã¡ãã»ãŒãž
-
LINEã§ã¯E2EEïŒãšã³ãã»ããŒã»ãšã³ãæå·åïŒïŒã¢ããªç¬èªã®æå·DBæ§é ããã
-
端æ«å ã«DBããã£ãŠãã埩å·ããŒãSecure Enclaveã«ãã£ããããŠãŒã¶ãŒåäœã§ä¿è·ãããšã£ããããŠãŠèªãã
â ããã¯ã¢ãããDBãã¡ã€ã«ãå ¥æããŠããå逿žã¡ãã»ãŒãžã¯åŸ©å å°é£
-
SQLiteãšéã£ãŠãåé€ãã©ã°æ®ã£ãŠãŠèŠãããããçãªçãããªãïŒããããæå·åãããšãããæååæ€çŽ¢ãã§ããïŒ
ð LINEã®æ§é ã匷ãããçç±ïŒè»œãæè¡çã«ïŒ
| é ç® | å 容 |
|---|---|
| ð E2EE | ããŒã¯ã¯éä¿¡æã«æå·åããã埩å·ããŒã¯ç«¯æ«ããšã«ä¿æ |
| ðŠ ããŒã«ã«ä¿å | DB㯠chat.db ãšãããã©ãç¬èªæ§é ïŒæå·å |
| ð§¹ å逿 | DBå ãããåé€ã埩å·ããŒãç¡å¹åãããå¯èœæ§ãã |
| â 埩å ããŒã« | UFEDãAXIOMã§ãå®å šãªåŸ©å ã¯å°é£ïŒç¹ã«å逿žããŒã¿ïŒ |
ð§ ã¯ã€ã®ãŸãšãïŒå®åçæŽçïŒ
| ç¶æ³ | LINEã¡ãã»ãŒãžåŸ©å ã§ããïŒ | åè |
|---|---|---|
| åé€ããŠãªãã¡ãã»ãŒãž | â èŠãããïŒã¢ããªå or DBïŒ | æ£èŠUIã»äžéšããã¯ã¢ããããèªåå¯ |
| åé€ããã¡ãã»ãŒãž | â ååäžå¯ | E2EEïŒDBæå·ïŒããŒå€±å¹ã§å®è³ªäžå¯èœ |
| SMSãšã®éã | ð¥ æç¢ºã«åŸ©å å°é£åºŠã段éã | SMSã¯å¹³æã»LINEã¯å®å šé²åŸ¡ç³» |
ãã®ããããLINEã¯ãã©ã€ãã·ãŒã«ãã£ã¡ã匷ãèšèšããšãããã
ã埩å
ããã«ããïŒèšŒæ ã«ãªãã«ããããŠç¹ã§ãäŒæ¥çµ±æ²»çã«ã¯ç²ç¹ã«ãªããããªã
ããããä»åã®äºä»¶ãïŒ
ãSMSã¯åŸ©å ã§ããã®ã«ãLINEã¯ç¡çã§ããã
â ãããâ埩å ã§ããïŒã§ããªãã£ãâãããªããâã§ããããã«èšèšãããŠãžãâã£ãŠãšãããã¢ã
絶察ã«è¡ããããªããã©ã