title: Opening/decrypting Webex Connect db3 file
body: <p>So I have a lot of instant message logs/history that I want to back up from my chat client, Cisco WebEx Connect in Windows 7. These are stored under <em>C:\Users\\AppData\Local\WebEx Connect\Archive</em> and the file is called "myemailaddress".db3</p>
  
  <p>After downloading SQLiteBrowser to open this file, I get the error:</p>
  
  <blockquote>
    <p>SQLiteManager: Error in opening file "myfile".db3 - either the file is encrypted or corrupt
    Exception Name: NS_ERROR_FILE_CORRUPTED
    Exception Message: Component returned failure code: 0x8052000b (NS_ERROR_FILE_CORRUPTED) [mozIStorageService.openUnsharedDatabase]</p>
  </blockquote>
  
  <p>The file isn't corrupted so I'm thinking perhaps it is encrypted in some way - opening the file in Notepad displays random characters like the following, with no recognisable text:</p>
  
  <blockquote>
    <p>=¢^£ÍV¶»ñû‡«–
    `×ÚµÏýº°ÎîÎL</p>
  </blockquote>
  
  <p>Besides that file which contains the actual messages, there is another small 20kb file under the folder ConnectDB that has various config settings (such as create CacheTable) and it says on the first line (when opened in Notepad): "SQLite format 3" - so clearly this one isn't encrypted. </p>
  
  <p>Is there any way to extract the data from the first file to something readable (ie, text)? It's only around 5MB in size so shouldn't be causing any memory issues.</p>