Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Errors when running mvt-ios check-backup #434

Closed
mikesimonetti opened this issue Dec 5, 2023 · 21 comments · Fixed by #442
Closed

Errors when running mvt-ios check-backup #434

mikesimonetti opened this issue Dec 5, 2023 · 21 comments · Fixed by #442
Labels
bug Something isn't working ios

Comments

@mikesimonetti
Copy link

mikesimonetti commented Dec 5, 2023 •
edited by Te-k
Loading

Hello, I keep getting various errors when trying to extract the Json files, I don't also get all the json files I'm supposed to. I have decrypted the backup

INFO     [mvt.ios.modules.backup.configuration_profiles] Running module
                  ConfigurationProfiles...                                      
         ERROR    [mvt.ios.modules.backup.configuration_profiles] The           
                  ConfigurationProfiles module database seems to be corrupted:  
                  failed to query Manifest.db: unable to open database file     
         INFO     [mvt.ios.modules.backup.manifest] Running module Manifest...  
         INFO     [mvt.ios.modules.backup.manifest] Found Manifest.db database  
                  at path: /Users/mike/Documents/backup                         
                  /MVT/00008120-001C254C3EC0C01E/Manifest.db                    
         ERROR    [mvt.ios.modules.backup.manifest] Error in running extraction 
                  from module Manifest: unable to open database file            
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/backup/manifest.py", line  
                  126, in run                                                   
                      conn = self._open_sqlite_db(manifest_db_path)             
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^             
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.backup.profile_events] Running module        
                  ProfileEvents...                                              
         ERROR    [mvt.ios.modules.backup.profile_events] The ProfileEvents     
                  module database seems to be corrupted: failed to query        
                  Manifest.db: unable to open database file                     
         INFO     [mvt.ios.modules.mixed.calls] Running module Calls...         
         ERROR    [mvt.ios.modules.mixed.calls] Error in running extraction from
                  module Calls: unable to open database file                    
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/calls.py", line 50,  
                  in run                                                        
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.chrome_favicon] Running module         
                  ChromeFavicon...                                              
         INFO     [mvt.ios.modules.mixed.chrome_favicon] There might be no data 
                  to extract by module ChromeFavicon: unable to find the        
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.chrome_history] Running module         
                  ChromeHistory...                                              
         INFO     [mvt.ios.modules.mixed.chrome_history] There might be no data 
                  to extract by module ChromeHistory: unable to find the        
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.contacts] Running module Contacts...   
         ERROR    [mvt.ios.modules.mixed.contacts] Error in running extraction  
                  from module Contacts: unable to open database file            
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/contacts.py", line   
                  42, in run                                                    
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.firefox_favicon] Running module        
                  FirefoxFavicon...                                             
         INFO     [mvt.ios.modules.mixed.firefox_favicon] There might be no data
                  to extract by module FirefoxFavicon: unable to find the       
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.firefox_history] Running module        
                  FirefoxHistory...                                             
         INFO     [mvt.ios.modules.mixed.firefox_history] There might be no data
                  to extract by module FirefoxHistory: unable to find the       
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.idstatuscache] Running module          
                  IDStatusCache...                                              
         ERROR    [mvt.ios.modules.mixed.idstatuscache] Error in running        
                  extraction from module IDStatusCache: unable to open database 
                  file                                                          
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/idstatuscache.py",   
                  line 109, in run                                              
                      self._find_ios_database(backup_ids=IDSTATUSCACHE_BACKUP_ID
                  S)                                                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.interactionc] Running module           
                  InteractionC...                                               
         ERROR    [mvt.ios.modules.mixed.interactionc] Error in running         
                  extraction from module InteractionC: unable to open database  
                  file                                                          
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/interactionc.py",    
                  line 278, in run                                              
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.locationd] Running module              
                  LocationdClients...                                           
         ERROR    [mvt.ios.modules.mixed.locationd] Error in running extraction 
                  from module LocationdClients: unable to open database file    
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/locationd.py", line  
                  159, in run                                                   
                      self._find_ios_database(backup_ids=LOCATIOND_BACKUP_IDS)  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.osanalytics_addaily] Running module    
                  OSAnalyticsADDaily...                                         
         ERROR    [mvt.ios.modules.mixed.osanalytics_addaily] Error in running  
                  extraction from module OSAnalyticsADDaily: unable to open     
                  database file                                                 
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/osanalytics_addaily.p
                  y", line 66, in run                                           
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.net_datausage] Running module          
                  Datausage...                                                  
         ERROR    [mvt.ios.modules.mixed.net_datausage] Error in running        
                  extraction from module Datausage: unable to open database file
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/net_datausage.py",   
                  line 45, in run                                               
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.safari_browserstate] Running module    
                  SafariBrowserState...                                         
         ERROR    [mvt.ios.modules.mixed.safari_browserstate] The               
                  SafariBrowserState module database seems to be corrupted:     
                  failed to query Manifest.db: unable to open database file     
         INFO     [mvt.ios.modules.mixed.safari_history] Running module         
                  SafariHistory...                                              
         ERROR    [mvt.ios.modules.mixed.safari_history] The SafariHistory      
                  module database seems to be corrupted: failed to query        
                  Manifest.db: unable to open database file                     
         INFO     [mvt.ios.modules.mixed.tcc] Running module TCC...             
         ERROR    [mvt.ios.modules.mixed.tcc] Error in running extraction from  
                  module TCC: unable to open database file                      
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/tcc.py", line 219, in
                  run                                                           
                      self._find_ios_database(backup_ids=TCC_BACKUP_IDS,        
                  root_paths=TCC_ROOT_PATHS)                                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.sms] Running module SMS...             
         ERROR    [mvt.ios.modules.mixed.sms] Error in running extraction from  
                  module SMS: unable to open database file                      
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/sms.py", line 85, in 
                  run                                                           
                      self._find_ios_database(backup_ids=SMS_BACKUP_IDS,        
                  root_paths=SMS_ROOT_PATHS)                                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.sms_attachments] Running module        
                  SMSAttachments...                                             
         ERROR    [mvt.ios.modules.mixed.sms_attachments] Error in running      
                  extraction from module SMSAttachments: unable to open database
                  file                                                          
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/sms_attachments.py", 
                  line 71, in run                                               
                      self._find_ios_database(backup_ids=SMS_BACKUP_IDS,        
                  root_paths=SMS_ROOT_PATHS)                                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.webkit_resource_load_statistics]       
                  Running module WebkitResourceLoadStatistics...                
         INFO     [mvt.ios.modules.mixed.webkit_resource_load_statistics] Unable
                  to find WebKit observations.db: failed to query Manifest.db:  
                  unable to open database file                                  
         INFO     [mvt.ios.modules.mixed.webkit_resource_load_statistics] The   
                  WebkitResourceLoadStatistics module produced no detections!   
         INFO     [mvt.ios.modules.mixed.webkit_session_resource_log] Running   
                  module WebkitSessionResourceLog...                            
         ERROR    [mvt.ios.modules.mixed.webkit_session_resource_log] The       
                  WebkitSessionResourceLog module database seems to be          
                  corrupted: failed to query Manifest.db: unable to open        
                  database file                                                 
         INFO     [mvt.ios.modules.mixed.whatsapp] Running module Whatsapp...   
         INFO     [mvt.ios.modules.mixed.whatsapp] There might be no data to    
                  extract by module Whatsapp: unable to find the module's       
                  database file                                                 
         INFO     [mvt.ios.modules.mixed.shortcuts] Running module Shortcuts... 
         ERROR    [mvt.ios.modules.mixed.shortcuts] Error in running extraction 
                  from module Shortcuts: unable to open database file           
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/shortcuts.py", line  
                  81, in run                                                    
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.applications] Running module           
                  Applications...                                               
         INFO     [mvt.ios.modules.mixed.applications] Extracted a total of 167 
                  applications                                                  
         INFO     [mvt.ios.modules.mixed.applications] The Applications module  
                  produced no detections!                                       
         INFO     [mvt.ios.modules.mixed.calendar] Running module Calendar...   
         ERROR    [mvt.ios.modules.mixed.calendar] Error in running extraction  
                  from module Calendar: unable to open database file            
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/calendar.py", line   
                  136, in run                                                   
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.global_preferences] Running module     
                  GlobalPreferences...                                          
         ERROR    [mvt.ios.modules.mixed.global_preferences] Error in running   
                  extraction from module GlobalPreferences: unable to open      
                  database file                                                 
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/global_preferences.py
                  ", line 55, in run                                            
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file
@Te-k Te-k added bug Something isn't working ios labels Dec 5, 2023
@Te-k
Copy link
Contributor

Te-k commented Dec 5, 2023

It looks like your data are corrupted, can you check what kind of file your Manifest.db is using the file command?
Also what is your operating system?

@mikesimonetti
Copy link
Author

how do I check the Manifest.db?

I'm running Ventura 13.3.1 on the Mac and iOS 17.1.2

Can the corruption be caused by spyware?

@Te-k
Copy link
Contributor

Te-k commented Dec 5, 2023

No it can't, and you can use the file command to check what kind of file it is

@mikesimonetti
Copy link
Author

The file command returned this:

/MVT/decription/Manifest.db: SQLite 3.x database, user version 2, last written using SQLite version 3039005, writer version 2, read version 2, file counter 17, database pages 45188, 1st free page 3110, free pages 42, cookie 0x5, schema 4, largest root page 9, UTF-8, vacuum mode 1, version-valid-for 17

@roaree
Copy link
Contributor

roaree commented Dec 6, 2023

Can you try installing version 2.4.3 and run again? It would help us narrow down if the cause is a change introduced in #430.

@mikesimonetti
Copy link
Author

Sure as soon as I get home I’ll try that.
do I also have to uninstall the current version? If so do I do it through brew?

@roaree
Copy link
Contributor

roaree commented Dec 6, 2023

Sure as soon as I get home I’ll try that. do I also have to uninstall the current version? If so do I do it through brew?

Did you install from brew? I think you probably installed from pip, changes from 2.4.4 are visible in the tracebacks.

If installing from pip you can try pip install mvt==2.4.3

@mikesimonetti
Copy link
Author

Sorry you are right I’ve used brew to install libimobiledevice.

When I’ll get home I’ll try to run the pip command

@roaree
Copy link
Contributor

roaree commented Dec 6, 2023

I suspect this is a file permissions problem - I'm able to reproduce this sqlite3.OperationalError: unable to open database file exception if I chown a backup folder as root, then try to run mvt-ios check-backup on the folder as a normal user.

When you get a chance, can you check the permissions on the decrypted backup folder? I suspect it might be owned by root or another user (maybe you ran sudo mvt-ios decrypt-backup instead of mvt-ios decrypt-backup)?

@mikesimonetti
Copy link
Author

So I have installed versione 2.4.3 with pip install mvt==2.4.3. I am now running the description again with sudo mvt-ios decrypt-backup. but it's running on version 2.4.4. As soon as it's done I'll try to do the mvt-ios check-backup and post the updates.

@mikesimonetti
Copy link
Author

mikesimonetti commented Dec 6, 2023 •
edited by roaree
Loading

Nope keep gettin the same errors even if running with sudo both description and check

INFO     [mvt.ios.modules.backup.backup_info] The BackupInfo module    
                  does not support checking for indicators                      
         INFO     [mvt.ios.modules.backup.configuration_profiles] Running module
                  ConfigurationProfiles...                                      
         ERROR    [mvt.ios.modules.backup.configuration_profiles] The           
                  ConfigurationProfiles module database seems to be corrupted:  
                  failed to query Manifest.db: unable to open database file     
         INFO     [mvt.ios.modules.backup.manifest] Running module Manifest...  
         INFO     [mvt.ios.modules.backup.manifest] Found Manifest.db database  
                  at path: /Users/mike/Documents/backup /MVT/sudo decription    
                  /Manifest.db                                                  
         ERROR    [mvt.ios.modules.backup.manifest] Error in running extraction 
                  from module Manifest: unable to open database file            
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/backup/manifest.py", line  
                  126, in run                                                   
                      conn = self._open_sqlite_db(manifest_db_path)             
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^             
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.backup.profile_events] Running module        
                  ProfileEvents...                                              
         ERROR    [mvt.ios.modules.backup.profile_events] The ProfileEvents     
                  module database seems to be corrupted: failed to query        
                  Manifest.db: unable to open database file                     
         INFO     [mvt.ios.modules.mixed.calls] Running module Calls...         
         ERROR    [mvt.ios.modules.mixed.calls] Error in running extraction from
                  module Calls: unable to open database file                    
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/calls.py", line 50,  
                  in run                                                        
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.chrome_favicon] Running module         
                  ChromeFavicon...                                              
         INFO     [mvt.ios.modules.mixed.chrome_favicon] There might be no data 
                  to extract by module ChromeFavicon: unable to find the        
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.chrome_history] Running module         
                  ChromeHistory...                                              
         INFO     [mvt.ios.modules.mixed.chrome_history] There might be no data 
                  to extract by module ChromeHistory: unable to find the        
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.contacts] Running module Contacts...   
         ERROR    [mvt.ios.modules.mixed.contacts] Error in running extraction  
                  from module Contacts: unable to open database file            
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/contacts.py", line   
                  42, in run                                                    
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.firefox_favicon] Running module        
                  FirefoxFavicon...                                             
         INFO     [mvt.ios.modules.mixed.firefox_favicon] There might be no data
                  to extract by module FirefoxFavicon: unable to find the       
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.firefox_history] Running module        
                  FirefoxHistory...                                             
         INFO     [mvt.ios.modules.mixed.firefox_history] There might be no data
                  to extract by module FirefoxHistory: unable to find the       
                  module's database file                                        
         INFO     [mvt.ios.modules.mixed.idstatuscache] Running module          
                  IDStatusCache...                                              
         ERROR    [mvt.ios.modules.mixed.idstatuscache] Error in running        
                  extraction from module IDStatusCache: unable to open database 
                  file                                                          
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/idstatuscache.py",   
                  line 109, in run                                              
                      self._find_ios_database(backup_ids=IDSTATUSCACHE_BACKUP_ID
                  S)                                                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.interactionc] Running module           
                  InteractionC...                                               
         ERROR    [mvt.ios.modules.mixed.interactionc] Error in running         
                  extraction from module InteractionC: unable to open database  
                  file                                                          
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/interactionc.py",    
                  line 278, in run                                              
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.locationd] Running module              
                  LocationdClients...                                           
         ERROR    [mvt.ios.modules.mixed.locationd] Error in running extraction 
                  from module LocationdClients: unable to open database file    
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/locationd.py", line  
                  159, in run                                                   
                      self._find_ios_database(backup_ids=LOCATIOND_BACKUP_IDS)  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.osanalytics_addaily] Running module    
                  OSAnalyticsADDaily...                                         
         ERROR    [mvt.ios.modules.mixed.osanalytics_addaily] Error in running  
                  extraction from module OSAnalyticsADDaily: unable to open     
                  database file                                                 
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/osanalytics_addaily.p
                  y", line 66, in run                                           
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.net_datausage] Running module          
                  Datausage...                                                  
         ERROR    [mvt.ios.modules.mixed.net_datausage] Error in running        
                  extraction from module Datausage: unable to open database file
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/net_datausage.py",   
                  line 45, in run                                               
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.safari_browserstate] Running module    
                  SafariBrowserState...                                         
         ERROR    [mvt.ios.modules.mixed.safari_browserstate] The               
                  SafariBrowserState module database seems to be corrupted:     
                  failed to query Manifest.db: unable to open database file     
         INFO     [mvt.ios.modules.mixed.safari_history] Running module         
                  SafariHistory...                                              
         ERROR    [mvt.ios.modules.mixed.safari_history] The SafariHistory      
                  module database seems to be corrupted: failed to query        
                  Manifest.db: unable to open database file                     
         INFO     [mvt.ios.modules.mixed.tcc] Running module TCC...             
         ERROR    [mvt.ios.modules.mixed.tcc] Error in running extraction from  
                  module TCC: unable to open database file                      
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/tcc.py", line 219, in
                  run                                                           
                      self._find_ios_database(backup_ids=TCC_BACKUP_IDS,        
                  root_paths=TCC_ROOT_PATHS)                                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.sms] Running module SMS...             
         ERROR    [mvt.ios.modules.mixed.sms] Error in running extraction from  
                  module SMS: unable to open database file                      
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/sms.py", line 85, in 
                  run                                                           
                      self._find_ios_database(backup_ids=SMS_BACKUP_IDS,        
                  root_paths=SMS_ROOT_PATHS)                                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.sms_attachments] Running module        
                  SMSAttachments...                                             
         ERROR    [mvt.ios.modules.mixed.sms_attachments] Error in running      
                  extraction from module SMSAttachments: unable to open database
                  file                                                          
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/sms_attachments.py", 
                  line 71, in run                                               
                      self._find_ios_database(backup_ids=SMS_BACKUP_IDS,        
                  root_paths=SMS_ROOT_PATHS)                                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.webkit_resource_load_statistics]       
                  Running module WebkitResourceLoadStatistics...                
         INFO     [mvt.ios.modules.mixed.webkit_resource_load_statistics] Unable
                  to find WebKit observations.db: failed to query Manifest.db:  
                  unable to open database file                                  
         INFO     [mvt.ios.modules.mixed.webkit_resource_load_statistics] The   
                  WebkitResourceLoadStatistics module produced no detections!   
         INFO     [mvt.ios.modules.mixed.webkit_session_resource_log] Running   
                  module WebkitSessionResourceLog...                            
         ERROR    [mvt.ios.modules.mixed.webkit_session_resource_log] The       
                  WebkitSessionResourceLog module database seems to be          
                  corrupted: failed to query Manifest.db: unable to open        
                  database file                                                 
         INFO     [mvt.ios.modules.mixed.whatsapp] Running module Whatsapp...   
         INFO     [mvt.ios.modules.mixed.whatsapp] There might be no data to    
                  extract by module Whatsapp: unable to find the module's       
                  database file                                                 
         INFO     [mvt.ios.modules.mixed.shortcuts] Running module Shortcuts... 
         ERROR    [mvt.ios.modules.mixed.shortcuts] Error in running extraction 
                  from module Shortcuts: unable to open database file           
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/shortcuts.py", line  
                  81, in run                                                    
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.applications] Running module           
                  Applications...                                               
         INFO     [mvt.ios.modules.mixed.applications] Extracted a total of 167 
                  applications                                                  
         INFO     [mvt.ios.modules.mixed.applications] The Applications module  
                  produced no detections!                                       
         INFO     [mvt.ios.modules.mixed.calendar] Running module Calendar...   
         ERROR    [mvt.ios.modules.mixed.calendar] Error in running extraction  
                  from module Calendar: unable to open database file            
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/calendar.py", line   
                  136, in run                                                   
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file        
         INFO     [mvt.ios.modules.mixed.global_preferences] Running module     
                  GlobalPreferences...                                          
         ERROR    [mvt.ios.modules.mixed.global_preferences] Error in running   
                  extraction from module GlobalPreferences: unable to open      
                  database file                                                 
                  Traceback (most recent call last):                            
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/module.py", line 167, in        
                  run_module                                                    
                      exec_or_profile("module.run()", globals(), locals())      
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/common/utils.py", line 259, in         
                  exec_or_profile                                               
                      exec(module, globals, locals)                             
                    File "<string>", line 1, in <module>                        
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/mixed/global_preferences.py
                  ", line 55, in run                                            
                      self._find_ios_database(                                  
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 200, in     
                  _find_ios_database                                            
                      self._recover_sqlite_db_if_needed(self.file_path)         
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 52, in      
                  _recover_sqlite_db_if_needed                                  
                      conn = self._open_sqlite_db(file_path)                    
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^                    
                    File                                                        
                  "/Library/Frameworks/Python.framework/Versions/3.11/lib/python
                  3.11/site-packages/mvt/ios/modules/base.py", line 95, in      
                  _open_sqlite_db                                               
                      return sqlite3.connect(f"file:{file_path}?immutable=1")   
                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^   
                  sqlite3.OperationalError: unable to open database file

@mikesimonetti
Copy link
Author

mikesimonetti commented Dec 6, 2023 •
edited by Te-k
Loading

I've tried running iMazing which claims to run using mvt, and the report came back giving 11 warnings which are the same errors that mvt is giving back when I run the check backup. But the iMazing log is saying that these .dbs are missing from backup as follow:

'HomeDomain/Library/SMS/sms.db' (File not found in the backup)
'HomeDomain/Library/SMS/sms.db' (File not found in the backup)
'HomeDomain/Library/Calendar/Calendar.sqlitedb' (File not found in the backup)
'WirelessDomain/Library/CallHistory/call_history.db' (File not found in the backup).
'AppDomain-com.apple.mobilesafari/Library/Safari/History.db' (File not found in the backup)
'AppDomain-com.apple.mobilesafari/Library/Safari/BrowserState.db' (File not found in the backup)
'HomeDomain/Library/Preferences/com.apple.identityservices.idstatuscache.plist' (File not found in the backup)
'HomeDomain/Library/CoreDuet/People/interactionC.db' (File not found in the backup)
'HomeDomain/Library/CoreDuet/People/interactionC.db' (File not found in the backup)
'WirelessDomain/Library/Databases/DataUsage.sqlite' (File not found in the backup)
'HomeDomain/Library/Preferences/com.apple.osanalytics.addaily.plist' (File not found in the backup)

@mikesimonetti
Copy link
Author

Hi does someone have a suggestion for this?

@roaree
Copy link
Contributor

roaree commented Dec 14, 2023

Hey @mikesimonetti, the only way I can seem to reproduce this is by making the backup file permissions incorrect. Can you ensure that the backup folder and all containing files are owned by the same user as you run mvt-ios with? chown -R may help here.

It would also be very helpful if you could try again 2.4.3 to help us rule out the change in #430 as being the cause (from your tracebacks it seems like you're still running 2.4.4 due to multiple install locations).

One other possibility to look into is I think you have a folder name with a trailing space in the provided path: /Users/mike/Documents/backup /MVT/? Does renaming that change anything?

@Shellcat-Zero
Copy link

I have this same error with mvt == 2.4.5 and python 3.11.5. Is there a python version issue? I checked file ownership and ran chown -R to ensure everything was owned by the same user. My package was installed by cloning the repo, installing dependencies, and then pip install ..

It throws sqlite3 errors specifically for modules Manifest, Calls, Contacts, IDStatusCache, InteractionC, LocationdClients, OSAnalyticsADDaily, Datausage, TCC, SMS, SMSAttachments, Whatsapp, Shortcuts, Calendar, and GlobalPreferences.

The command used was:
mvt-ios check-backup --output ./backup_check decrypted_backup/

Help is very much appreciated.

@Shellcat-Zero
Copy link

I tested with 2.4.3 and it completed without error, so I'm guessing the issue likely lies in #430 as mentioned by @roaree.

@msx98
Copy link
Contributor

msx98 commented Dec 28, 2023

Hi, I managed to resolve this in the latest commit (013282d) by adding uri=True to mvt/ios/modules/base.py:95

    def _open_sqlite_db(self, file_path: str) -> sqlite3.Connection:
        return sqlite3.connect(f"file:{file_path}?immutable=1", uri=True)

python3.11.6 on Linux, not sure what version of sqlite3

@msx98 msx98 mentioned this issue Dec 28, 2023
Merged
@roaree roaree reopened this Dec 28, 2023
@Shellcat-Zero
Copy link

Hi, I managed to resolve this in the latest commit (013282d) by adding uri=True to mvt/ios/modules/base.py:95

    def _open_sqlite_db(self, file_path: str) -> sqlite3.Connection:
        return sqlite3.connect(f"file:{file_path}?immutable=1", uri=True)

python3.11.6 on Linux, not sure what version of sqlite3

Thanks, this fixed the issue for me in 2.4.5 after pulling the commit. I get a circular reference error in the SMS module now, though, which appears to have something to do the json encoder. I will open another issue for that error.

@Shellcat-Zero Shellcat-Zero mentioned this issue Dec 28, 2023
Closed
@roaree
Copy link
Contributor

roaree commented Jan 4, 2024

The possible fix in #442 has been released to PyPI as part of 2.5.0 - let us know if it works for you :)

@roaree
Copy link
Contributor

roaree commented Jan 17, 2024

Closing, feel free to reopen if still needed.

@roaree roaree closed this as completed Jan 17, 2024
@dirtydevious
Copy link

Having this same problem with 2.5.4 and I have checked mvt/ios/modules/base.py:95 and it is indeed set to uri=True

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working ios
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add uri=True in mvt/ios/modules/base.py msx98/mvt
6 participants
@Shellcat-Zero @Te-k @dirtydevious @mikesimonetti @roaree @msx98