Difference between pages "Mac OS X" and "Google Chrome"

From ForensicsWiki
(Difference between pages)
Jump to: navigation, search
 
(Disk Cache)
 
Line 1: Line 1:
{{Expand}}
+
Google Chrome is a [[Web Browser|web browser]] developed by Google Inc.
  
Apple Inc.'s Macintosh OS X (pronounced "'''OS Ten'''") is the operating system distributed with Apple computers. It includes heavily used several programs by default, including [[Apple Mail]], a web browser called [[Apple Safari | Safari]], and an [[Apple Address Book]], and [[iCal]].  
+
== Configuration ==
 +
The Google Chrome configuration can be found in the '''Preferences''' file.
  
== Disk image types ==
+
On Linux
 +
<pre>
 +
/home/$USER/.config/google-chrome/Default/Preferences
 +
</pre>
  
Mac OS X has support for various disk image types build-in, some of which are:
+
On MacOS-X
* read-write disk image (.dmg) some of which use the [[Raw Image Format]]
+
<pre>
* [[Sparse Image format|Sparse disk image (.spareimage)]]
+
/Users/$USER/Library/Application Support/Google/Chrome/Default/Preferences
* [[Sparse Bundle Image format|Sparse bundle disk image (.sparsebundle)]]
+
</pre>
  
== Burn Folder ==
+
On Windows XP
 +
<pre>
 +
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Default\Preferences
 +
</pre>
  
Mac OS X Burn Folder:
+
On Windows Vista and later
 
<pre>
 
<pre>
$NAME.fpbf
+
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\Default\Preferences
 
</pre>
 
</pre>
  
This folder normally contains [[Mac OS X Alias Files|alias files]] (similar to LNK files under Windows). Which should have the following signature.
+
Or for '''Chrome SxS''' (Chrome side-by-side)
 +
 
 
<pre>
 
<pre>
00000000  62 6f 6f 6b 00 00 00 00  6d 61 72 6b 00 00 00 00  |book....mark....|
+
C:\Users\%USERNAME%\AppData\Local\Google\Chrome SxS\User Data\Default\Preferences
 
</pre>
 
</pre>
  
These [[Mac OS X Alias Files|alias files]] contain additional date and time values.
+
Or for '''Chromium'''
  
Also check the following files for references to deleted .fpbf paths:
+
On Linux
 
<pre>
 
<pre>
/Users/$USERNAME/Library/Preferences/com.apple.finder.plist
+
/home/$USER/.config/chromium/Default/Preferences
/Users/$USERNAME/Library/Preferences/com.apple.sidebarlists.plist
+
 
</pre>
 
</pre>
  
Actual burning of optical media is logged in:
+
On MacOS-X
 
<pre>
 
<pre>
/var/log/system.log
+
/Users/$USER/Library/Application Support/Chromium/Default/Preferences
/Users/$USERNAME/Library/Logs/DiscRecording.log
+
/private/var/.logs_exporter/cache/Users/$USERNAME/Library/Logs/DiscRecording.log
+
 
</pre>
 
</pre>
  
== HFS/HFS+ date and time values ==
+
On Windows XP
 +
<pre>
 +
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Default\Preferences
 +
</pre>
  
In HFS+ date and time values are stored in an unsigned 32-bit integer containing the number of seconds since January 1, 1904 at 00:00:00 (midnight) UTC (GMT). This is slightly different from HFS where the date and time value are stored using the local time. The maximum representable date is February 6, 2040 at 06:28:15 UTC (GMT). The date values do not account for leap seconds. They do include a leap day in every year that is evenly divisible by four. This is sufficient given that the range of representable dates does not contain 1900 or 2100, neither of which have leap days. Also see: [http://web.archive.org/web/20090214212148/http://developer.apple.com/technotes/tn/tn1150.html Technical Note TN1150 - HFS Plus Volume Format]
+
On Windows Vista and later
 +
<pre>
 +
C:\Users\%USERNAME%\AppData\Local\Chromium\User Data\Default\Preferences
 +
</pre>
  
Converting HFS/HFS+ date and time values with Python:
+
=== Plugins ===
 +
 
 +
Information about plugins can be found under the "plugins section" of the Preferences file.
 +
 
 +
=== DNS Prefetching ===
 +
 
 +
DNS is prefetched for related sites, e.g. links on the page.
 +
This behavior is controlled by the setting "Predict network actions to improve page load performance", which is enabled by default.
 +
 
 +
If enabled the Preferences file contains:
 
<pre>
 
<pre>
import datetime
+
  "dns_prefetching": {
 +
      "enabled": true,
 +
</pre>
  
print datetime.datetime( 1904, 1, 1 ) + datetime.timedelta( seconds=0xCBDAF25B )
+
If disabled the Preferences file contains:
 +
<pre>
 +
  "dns_prefetching": {
 +
      "enabled": false,
 
</pre>
 
</pre>
  
== Launch Agents ==
+
== Start-up DNS queries ==
System-wide:
+
 
 +
When Chrome starts it queries for several non-existing hostnames that consists of a 10 random characters, E.g.
 
<pre>
 
<pre>
/Library/LaunchAgents
+
ttrgoiknff.mydomain.com
/System/Library/LaunchAgents
+
bxjhgftsyu.mydomain.com
 +
yokjbjiagd.mydomain.com
 
</pre>
 
</pre>
  
Per user:
+
This is used to determine if your ISP is hijacking NXDOMAIN results [http://www.google.com/support/forum/p/Chrome/thread?tid=3511015c72a7b314&hl=en].
 +
 
 +
== Disk Cache ==
 +
Google Chrome uses multiple caches, from [http://src.chromium.org/viewvc/chrome/trunk/src/net/base/cache_type.h?view=markup]:
 
<pre>
 
<pre>
/Users/$USERNAME/Library/LaunchAgents
+
// The types of caches that can be created.
 +
enum CacheType {
 +
    DISK_CACHE,  // Disk is used as the backing storage.
 +
    MEMORY_CACHE,  // Data is stored only in memory.
 +
    MEDIA_CACHE,  // Optimized to handle media files.
 +
    APP_CACHE,  // Backing store for an AppCache.
 +
    SHADER_CACHE, // Backing store for the GL shader cache.
 +
    PNACL_CACHE, // Backing store the PNaCl translation cache
 +
};
 
</pre>
 
</pre>
  
These directories contain  [[Property list (plist)]] files.
+
<b>Note that $PROFILE (or %PROFILE%) the paths below is the profile dependent subdirectory which is normally Default but also could be Profile1, Profile2, etc.</b>
 +
 
 +
The Google Chrome disk cache can be found in:
 +
 
 +
On Linux
  
== Launch Daemons ==
 
System-wide:
 
 
<pre>
 
<pre>
/Library/LaunchDaemons
+
/home/$USER/.cache/chromium/$PROFILE/Cache/
/System/Library/LaunchDaemons
+
/home/$USER/.cache/google-chrome/$PROFILE/Cache/
 +
/home/$USER/.config/chromium/$PROFILE/Cache/
 +
/home/$USER/.config/google-chrome/$PROFILE/Cache/
 
</pre>
 
</pre>
  
These directories contain [[Property list (plist)]] files.
+
<pre>
 +
/home/$USER/.cache/chromium/$PROFILE/Media Cache/
 +
/home/$USER/.cache/google-chrome/$PROFILE/Media Cache/
 +
/home/$USER/.config/chromium/$PROFILE/Media Cache/
 +
/home/$USER/.config/google-chrome/$PROFILE/Media Cache/
 +
</pre>
  
== Startup Items ==
 
 
<pre>
 
<pre>
/Library/StartupItems/
+
/home/$USER/.config/chromium/$PROFILE/Application Cache/Cache/
/System/Library/StartupItems/
+
/home/$USER/.config/google-chrome/$PROFILE/Application Cache/Cache/
 
</pre>
 
</pre>
  
== Crash Reporter ==
 
 
<pre>
 
<pre>
/Library/Application Support/CrashReporter
+
/home/$USER/.config/chromium/$PROFILE/GPUCache/
 +
/home/$USER/.config/google-chrome/$PROFILE/GPUCache/
 
</pre>
 
</pre>
  
Contains text files named .crash, .diag, .spin
+
<pre>
 +
/home/$USER/.cache/chromium/PnaclTranslationCache/
 +
/home/$USER/.cache/google-chrome/PnaclTranslationCache/
 +
</pre>
  
== Diagnostic Reports ==
+
On MacOS-X
 
<pre>
 
<pre>
/Library/Logs/DiagnosticReports
+
/Users/$USER/Library/Caches/Chromium/$PROFILE/Cache
 +
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Cache
 
</pre>
 
</pre>
  
== Internet Plug-Ins ==
+
<b>TODO confirm the following paths</b>
System-wide:
+
 
<pre>
 
<pre>
/Library/Internet Plug-Ins
+
/Users/$USER/Caches/Chromium/$PROFILE/Cache/
 +
/Users/$USER/Caches/Google/Chrome/$PROFILE/Cache/
 
</pre>
 
</pre>
  
Per user:
 
 
<pre>
 
<pre>
/Users/$USERNAME/Library/Internet Plug-Ins
+
/Users/$USER/Library/Caches/Chromium/$PROFILE/Media Cache
 +
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Media Cache
 
</pre>
 
</pre>
  
== Quarantine event database ==
+
<pre>
See [http://menial.co.uk/blog/2011/06/16/mac-quarantine-event-database/]
+
/Users/$USER/Library/Application Support/Chromium/$PROFILE/Application Cache/Cache/
 +
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/Application Cache/Cache/
 +
</pre>
  
Snow Leopard and earlier
 
 
<pre>
 
<pre>
/Users/$USER/Library/Preferences/com.apple.LaunchServices.QuarantineEvents
+
/Users/$USER/Library/Application Support/Chromium/$PROFILE/GPUCache/
 +
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/GPUCache/
 
</pre>
 
</pre>
  
 
<pre>
 
<pre>
SELECT datetime(LSQuarantineTimeStamp + 978307200, "unixepoch") as LSQuarantineTimeStamp, LSQuarantineAgentName, LSQuarantineOriginURLString, LSQuarantineDataURLString from LSQuarantineEvent;
+
/Users/$USER/Library/Caches/Chromium/PnaclTranslationCache/
 +
/Users/$USER/Library/Caches/Google/Chrome/PnaclTranslationCache/
 
</pre>
 
</pre>
  
Lion and later
+
On Windows XP
 +
 
 +
<b>TODO confirm the following paths</b>
 
<pre>
 
<pre>
/Users/$USER/Library/Preferences/com.apple.LaunchServices.QuarantineEventsV2
+
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Cache\
 +
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Cache\
 
</pre>
 
</pre>
  
== sleepimage ==
+
On Windows Vista and later
This file is similar to the hibernation file on Windows.
+
 
<pre>
 
<pre>
/private/var/vm/sleepimage
+
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Cache\
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Cache\
 
</pre>
 
</pre>
  
Also see: [http://osxdaily.com/2010/10/11/sleepimage-mac/]
+
<pre>
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Application Cache\Cache\
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Application Cache\Cache\
 +
</pre>
  
= Last shutdown logs =
 
 
<pre>
 
<pre>
/private/var/log/com.apple.launchd/launchd-shutdown.system.log
+
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Media Cache\
/private/var/log/com.apple.launchd/launchd-shutdown.system.log.1
+
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Media Cache\
 
</pre>
 
</pre>
  
== Package Files (.PKG) ==
+
<pre>
Package Files (.PKG) are XAR archives [http://en.wikipedia.org/wiki/Xar_(archiver)] that contain a cpio archive and metadata [http://s.sudre.free.fr/Stuff/Ivanhoe/FLAT.html].
+
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\GPUCache\
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\GPUCache\
 +
</pre>
  
== Also see ==
+
The Chrome Cache contains different files with the following file names:
* [[MacOS Process Monitoring]]
+
* index
* [[Acquiring a MacOS System with Target Disk Mode]]
+
* data_#; where # contains a decimal digit.
* [[Converting Binary Plists]]
+
* f_######; where # contains a hexadecimal digit.
* [[FileVault Disk Encryption]]
+
* [[File Vault]]
+
  
=== Formats ===
+
For more info see [[Chrome Disk Cache Format]].
* [[Basic Security Module (BSM) file format]]
+
* [[Property list (plist)]]
+
  
== External Links ==
+
== History ==
* [http://www.apple.com/macosx/ Official website]
+
Chrome stores the history of visited sites in a file named '''History'''. This file uses the [[SQLite database format]].
* [http://en.wikipedia.org/wiki/OS_X Wikipedia entry on OS X]
+
* [http://menial.co.uk/blog/2011/06/16/mac-quarantine-event-database/ Quarantine event database]
+
* [http://www2.tech.purdue.edu/cit/Courses/cit556/readings/MacForensicsCraiger.pdf Mac Forensics: Mac OS X and the HFS+ File System] by P. Craiger
+
* [http://web.me.com/driley/iWeb/Previous_files/Directory_Services_Overview.pdf Mac OS X Directory Services Integration including Active Directory]
+
* [http://digitalinvestigation.wordpress.com/2012/04/04/geek-post-nskeyedarchiver-files-what-are-they-and-how-can-i-use-them/ NSKeyedArchiver files – what are they, and how can I use them?]
+
* [http://krypted.com/mac-os-x/command-line-alf-on-mac-os-x/ Command Line ALF on Mac OS X]
+
* [http://newosxbook.com/DMG.html Demystifying the DMG File Format]
+
* [https://code.google.com/p/mac-security-tips/wiki/ALL_THE_TIPS mac-security-tips]
+
  
=== Apple Examiner ===
+
The '''History''' file can be found in same location as the '''Preferences''' file.
* [http://www.appleexaminer.com/ The Apple Examiner]
+
 
* [http://www.appleexaminer.com/MacsAndOS/Analysis/USBOSX/USBOSX.html USB Entries on OS X]
+
There is also '''Archived History''' that predates information in the '''History''' file.
* [http://www.appleexaminer.com/Downloads/MacForensics.pdf Macintosh Forensics - A Guide for the Forensically Sound Examination of a Macintosh Computer] by Ryan R. Kubasiak
+
Note that the '''Archived History''' only contains visits.
 +
 
 +
=== Timestamps ===
 +
The '''History''' file uses the different timestamps.
 +
 
 +
==== visits.visit_time ====
 +
 
 +
The '''visits.visit_time''' is in (the number of) microseconds since January 1, 1601 UTC
 +
 
 +
Some Python code to do the conversion into human readable format:
 +
<pre>
 +
date_string = datetime.datetime( 1601, 1, 1 )
 +
            + datetime.timedelta( microseconds=timestamp )
 +
</pre>
 +
 
 +
Note that this timestamp is not the same as a Windows filetime which is (the number of) 100 nanoseconds since January 1, 1601 UTC
 +
 
 +
==== downloads.start_time ====
 +
 
 +
The '''downloads.start_time''' is in (the number of) seconds since January 1, 1970 UTC
 +
 
 +
Some Python code to do the conversion into human readable format:
 +
<pre>
 +
date_string = datetime.datetime( 1970, 1, 1 )
 +
            + datetime.timedelta( seconds=timestamp )
 +
</pre>
 +
 
 +
=== Example queries ===
 +
Some example queries:
 +
 
 +
To get an overview of the visited sites:
 +
<pre>
 +
SELECT datetime(((visits.visit_time/1000000)-11644473600), "unixepoch"), urls.url, urls.title FROM urls, visits WHERE urls.id = visits.url;
 +
</pre>
 +
 
 +
Note that the visit_time conversion looses precision.
 +
 
 +
To get an overview of the downloaded files:
 +
<pre>
 +
SELECT datetime(downloads.start_time, "unixepoch"), downloads.url, downloads.full_path, downloads.received_bytes, downloads.total_bytes FROM downloads;
 +
</pre>
 +
 
 +
How the information of the downloaded files is stored in the database can vary per version of Chrome as of version 26:
 +
<pre>
 +
SELECT datetime(((downloads.start_time/1000000)-11644473600), "unixepoch"), downloads.target_path, downloads_url_chains.url, downloads.received_bytes, downloads.total_bytes \
 +
FROM downloads, downloads_url_chains WHERE downloads.id = downloads_url_chains.id;
 +
</pre>
 +
 
 +
== Cookies ==
 +
Chrome stores the cookies in a file named '''Cookies'''. This file uses the [[SQLite database format]].
 +
 
 +
=== Extension Cookies ===
 +
Chrome stores the cookies used by extensions in a file named '''Extension Cookies'''. This file uses the [[SQLite database format]].
 +
 
 +
<pre>
 +
SELECT datetime(((cookies.creation_utc/1000000)-11644473600), "unixepoch"), cookies.host_key, cookies.name, cookies.value, cookies.path, \
 +
datetime(((cookies.expires_utc/1000000)-11644473600), "unixepoch"), cookies.secure, cookies.httponly, datetime(((cookies.last_access_utc/1000000)-11644473600), "unixepoch"), \
 +
cookies.has_expires, cookies.persistent, cookies.priority FROM cookies;
 +
</pre>
 +
 
 +
== See Also ==
 +
 
 +
* [[SQLite database format]]
 +
 
 +
== External Links ==
 +
* [http://en.wikipedia.org/wiki/Google_Chrome Wikipedia article on Google Chrome]
 +
* [http://www.chromium.org/user-experience/user-data-directory The Chromium Projects - User Data Directory]
 +
* [http://www.chromium.org/developers/design-documents/network-stack/disk-cache Chrome Disk Cache]
 +
* [http://www.google.com/support/forum/p/Chrome/thread?tid=3511015c72a7b314&hl=en Chrome support forum article random 10 character hostnames on startup]
 +
* [http://www.useragentstring.com/pages/Chrome/ Chrome User Agent strings]
 +
* [http://computer-forensics.sans.org/blog/2010/01/21/google-chrome-forensics/ Google Chrome Forensics] by [[Kristinn Guðjónsson]], January 21, 2010
 +
* [http://linuxsleuthing.blogspot.ch/2013/02/cashing-in-on-google-chrome-cache.html?m=1 Cashing in on the Google Chrome Cache], [[John Lehr]], February 24, 2013
 +
* [http://www.obsidianforensics.com/blog/history-index-files-removed-from-chrome/ History Index files removed from Chrome v30], by Ryan Benson, October 2, 2013
 +
* [https://hindsight-internet-history.googlecode.com/files/Evolution_of_Chrome_Databases.png Evolution of Chrome Databases], by Ryan Benson, November 12, 2013
  
=== iCloud ===
+
== Tools ==
* [http://support.apple.com/kb/HT4865?viewlocale=en_US&locale=en_US iCloud: iCloud security and privacy overview]
+
=== Open Source ===
 +
* [https://code.google.com/p/hindsight-internet-history/ hindsight-internet-history]
  
[[Category:Mac OS X]]
+
[[Category:Applications]]
[[Category:Operating systems]]
+
[[Category:Web Browsers]]

Revision as of 04:42, 22 June 2014

Google Chrome is a web browser developed by Google Inc.

Configuration

The Google Chrome configuration can be found in the Preferences file.

On Linux

/home/$USER/.config/google-chrome/Default/Preferences

On MacOS-X

/Users/$USER/Library/Application Support/Google/Chrome/Default/Preferences

On Windows XP

C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Default\Preferences

On Windows Vista and later

C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\Default\Preferences

Or for Chrome SxS (Chrome side-by-side)

C:\Users\%USERNAME%\AppData\Local\Google\Chrome SxS\User Data\Default\Preferences

Or for Chromium

On Linux

/home/$USER/.config/chromium/Default/Preferences

On MacOS-X

/Users/$USER/Library/Application Support/Chromium/Default/Preferences

On Windows XP

C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Default\Preferences

On Windows Vista and later

C:\Users\%USERNAME%\AppData\Local\Chromium\User Data\Default\Preferences

Plugins

Information about plugins can be found under the "plugins section" of the Preferences file.

DNS Prefetching

DNS is prefetched for related sites, e.g. links on the page. This behavior is controlled by the setting "Predict network actions to improve page load performance", which is enabled by default.

If enabled the Preferences file contains:

   "dns_prefetching": {
      "enabled": true,

If disabled the Preferences file contains:

   "dns_prefetching": {
      "enabled": false,

Start-up DNS queries

When Chrome starts it queries for several non-existing hostnames that consists of a 10 random characters, E.g.

ttrgoiknff.mydomain.com
bxjhgftsyu.mydomain.com
yokjbjiagd.mydomain.com

This is used to determine if your ISP is hijacking NXDOMAIN results [1].

Disk Cache

Google Chrome uses multiple caches, from [2]:

// The types of caches that can be created.
enum CacheType {
    DISK_CACHE,  // Disk is used as the backing storage.
    MEMORY_CACHE,  // Data is stored only in memory.
    MEDIA_CACHE,  // Optimized to handle media files.
    APP_CACHE,  // Backing store for an AppCache.
    SHADER_CACHE, // Backing store for the GL shader cache.
    PNACL_CACHE, // Backing store the PNaCl translation cache
};

Note that $PROFILE (or %PROFILE%) the paths below is the profile dependent subdirectory which is normally Default but also could be Profile1, Profile2, etc.

The Google Chrome disk cache can be found in:

On Linux

/home/$USER/.cache/chromium/$PROFILE/Cache/
/home/$USER/.cache/google-chrome/$PROFILE/Cache/
/home/$USER/.config/chromium/$PROFILE/Cache/
/home/$USER/.config/google-chrome/$PROFILE/Cache/
/home/$USER/.cache/chromium/$PROFILE/Media Cache/
/home/$USER/.cache/google-chrome/$PROFILE/Media Cache/
/home/$USER/.config/chromium/$PROFILE/Media Cache/
/home/$USER/.config/google-chrome/$PROFILE/Media Cache/
/home/$USER/.config/chromium/$PROFILE/Application Cache/Cache/
/home/$USER/.config/google-chrome/$PROFILE/Application Cache/Cache/
/home/$USER/.config/chromium/$PROFILE/GPUCache/
/home/$USER/.config/google-chrome/$PROFILE/GPUCache/
/home/$USER/.cache/chromium/PnaclTranslationCache/
/home/$USER/.cache/google-chrome/PnaclTranslationCache/

On MacOS-X

/Users/$USER/Library/Caches/Chromium/$PROFILE/Cache
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Cache

TODO confirm the following paths

/Users/$USER/Caches/Chromium/$PROFILE/Cache/
/Users/$USER/Caches/Google/Chrome/$PROFILE/Cache/
/Users/$USER/Library/Caches/Chromium/$PROFILE/Media Cache
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Media Cache
/Users/$USER/Library/Application Support/Chromium/$PROFILE/Application Cache/Cache/
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/Application Cache/Cache/
/Users/$USER/Library/Application Support/Chromium/$PROFILE/GPUCache/
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/GPUCache/
/Users/$USER/Library/Caches/Chromium/PnaclTranslationCache/
/Users/$USER/Library/Caches/Google/Chrome/PnaclTranslationCache/

On Windows XP

TODO confirm the following paths

C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Cache\
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Cache\

On Windows Vista and later

C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Application Cache\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Application Cache\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Media Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Media Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\GPUCache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\GPUCache\

The Chrome Cache contains different files with the following file names:

  • index
  • data_#; where # contains a decimal digit.
  • f_######; where # contains a hexadecimal digit.

For more info see Chrome Disk Cache Format.

History

Chrome stores the history of visited sites in a file named History. This file uses the SQLite database format.

The History file can be found in same location as the Preferences file.

There is also Archived History that predates information in the History file. Note that the Archived History only contains visits.

Timestamps

The History file uses the different timestamps.

visits.visit_time

The visits.visit_time is in (the number of) microseconds since January 1, 1601 UTC

Some Python code to do the conversion into human readable format:

date_string = datetime.datetime( 1601, 1, 1 )
            + datetime.timedelta( microseconds=timestamp )

Note that this timestamp is not the same as a Windows filetime which is (the number of) 100 nanoseconds since January 1, 1601 UTC

downloads.start_time

The downloads.start_time is in (the number of) seconds since January 1, 1970 UTC

Some Python code to do the conversion into human readable format:

date_string = datetime.datetime( 1970, 1, 1 )
            + datetime.timedelta( seconds=timestamp )

Example queries

Some example queries:

To get an overview of the visited sites:

SELECT datetime(((visits.visit_time/1000000)-11644473600), "unixepoch"), urls.url, urls.title FROM urls, visits WHERE urls.id = visits.url;

Note that the visit_time conversion looses precision.

To get an overview of the downloaded files:

SELECT datetime(downloads.start_time, "unixepoch"), downloads.url, downloads.full_path, downloads.received_bytes, downloads.total_bytes FROM downloads;

How the information of the downloaded files is stored in the database can vary per version of Chrome as of version 26:

SELECT datetime(((downloads.start_time/1000000)-11644473600), "unixepoch"), downloads.target_path, downloads_url_chains.url, downloads.received_bytes, downloads.total_bytes \
FROM downloads, downloads_url_chains WHERE downloads.id = downloads_url_chains.id;

Cookies

Chrome stores the cookies in a file named Cookies. This file uses the SQLite database format.

Extension Cookies

Chrome stores the cookies used by extensions in a file named Extension Cookies. This file uses the SQLite database format.

SELECT datetime(((cookies.creation_utc/1000000)-11644473600), "unixepoch"), cookies.host_key, cookies.name, cookies.value, cookies.path, \
datetime(((cookies.expires_utc/1000000)-11644473600), "unixepoch"), cookies.secure, cookies.httponly, datetime(((cookies.last_access_utc/1000000)-11644473600), "unixepoch"), \
cookies.has_expires, cookies.persistent, cookies.priority FROM cookies;

See Also

External Links

Tools

Open Source