mvt-project / mvt

MVT (Mobile Verification Toolkit) helps with conducting forensics of mobile devices in order to find signs of a potential compromise.
https://mvt.re
Other
10.35k stars 969 forks source link

no tables in SMS database #537

Open besendorf opened 1 week ago

besendorf commented 1 week ago

Sometimes I encounter the following sqlite errors. The tables for the SMS are not present in the backup.

ERROR    - Error in running extraction from module SMS: no such table: message
║ Traceback (most recent call last):
║   File "/usr/local/lib/python3.11/site-packages/mvt/common/module.py", line 167, in run_module
║     exec_or_profile("module.run()", globals(), locals())
║   File "/usr/local/lib/python3.11/site-packages/mvt/common/utils.py", line 262, in exec_or_profile
║     exec(module, globals, locals)
║   File "<string>", line 1, in <module>
║   File "/usr/local/lib/python3.11/site-packages/mvt/ios/modules/mixed/sms.py", line 127, in run
║     raise exc
║   File "/usr/local/lib/python3.11/site-packages/mvt/ios/modules/mixed/sms.py", line 99, in run
║     cur.execute(
║ sqlite3.OperationalError: no such table: message
ERROR    - Error in running extraction from module SMSAttachments: no such table: attachment
║ Traceback (most recent call last):
║   File "/usr/local/lib/python3.11/site-packages/mvt/common/module.py", line 167, in run_module
║     exec_or_profile("module.run()", globals(), locals())
║   File "/usr/local/lib/python3.11/site-packages/mvt/common/utils.py", line 262, in exec_or_profile
║     exec(module, globals, locals)
║   File "<string>", line 1, in <module>
║   File "/usr/local/lib/python3.11/site-packages/mvt/ios/modules/mixed/sms_attachments.py", line 82, in run
║     cur.execute(
║ sqlite3.OperationalError: no such table: attachment
Te-k commented 3 days ago

Hi, thanks for reporting that. Could you check if the file is actually a sqlite database? Sometimes the file is just empty and that's the error you get. We could try to improve the error message tho