16 ms·
Your Mac Keeps A Log Of Your Downloads
- deleted 14y ago[deleted]
- afandian 14y agoProbably not, no.
- barista 14y ago"You should not be downloading anything that you don't want anybody else to know" Eric Schmidt would say
- fcukdigg 14y agohahaha, good ole' Schmidt. What a gem.
- w1ntermute 14y agoHe's created many a Schmidtstorm with his off-the-cuff remarks.
- cryptoz 14y agoNo, he wouldn't. "If you don't want Google to tell the government you've been searching for illegal things, you shouldn't tell Google you've been searching for illegal things" is what he'd try to say. But he'd mince the words and make himself sound evil, somehow. So maybe you're right.
- drivebyacct2 14y agoLeave it to (taligent|barista) to turn an informational post about Apple into some off topic bitch about Google.
- abrowne 14y agoI hope he made this point clear to the North Korean people when he visited them.
- losvedir 14y agoWhat? I doubt it. I was pissed when I heard the full context of the quote you're referring to and saw what he actually meant. Here's what everyone likes to quote: > "If you have something that you don’t want anyone to know, maybe you shouldn’t be doing it in the first place" Here's the quote in full context: "I think judgment matters. If you have something that you don’t want anyone to know, maybe you shouldn’t be doing it in the first place, but if you really need that kind of privacy, the reality is that search engines including Google do retain this information for some time, and it’s important, for example, that we are all subject in the United States to the Patriot Act. It is possible that, that information could be made available to the authorities."
- binarycrusader 14y agoAnd I suspect that if you had a virus scanner installed on windows every file it scanned would be logged somewhere depending on settings. This post also fails to mention that this is specific to Safari at last check. I don't think Google Chrome integrates with this functionality.
- swang 14y agoI don't use Safari and it has all my downloads from Google Chrome.
- jlkinsel 14y agoI use a safari/firefox mix, all that's in that db for me is a short list of things I don't care about...
- ehamberg 14y agoIt does now: $ sqlite3 ~/Library/Preferences/com.apple.LaunchServices.QuarantineEventsV* 'select LSQuarantineAgentName from LSQuarantineEvent'|grep 'Google Chrome'|wc -l 35
- varikin 14y agoBut firefox doesn't seem to be in the list, though I am using the Firefox Nightly so that has something to do with it. I have Adium (lot of sparkle update checks), Chrome (just used for testing), iChat and a couple other random one-offs.
- 0x0 14y agoFirefox seems to be "blacklisted" by Apple, see /System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/Exceptions.plist : <key>org.mozilla.firefox</key> <dict> <key>LSFileQuarantineEnabled</key> <true/>
- 14y ago
- ehamberg 14y agoThis is used to show where a program came from the first time you run it. For example, if I download iTerm 2 and then run it, I get the following warning: http://i.imgur.com/IbUWj.png http://i.imgur.com/IbUWj.png
- danso 14y agoKind of brilliant, actually. Not the fix or the tracking method...just that I knew subconsciously that if OSX could know to warn me that I'm trying to open up a file downloaded from the internet (and which webpage it came from), then it must have some way of tracking it that supersedes the standard browser wipe. But I just never thought to look around for it.
- axusgrad 14y agoWindows will warn you about files downloaded from the internet, too. It uses "Alternate Data Streams" feature of NTFS to mark the file. I suppose once you delete the file, the alternate data stream is gone as well. From what I read, alternate data streams were made for compatibility with a Mac filesystem!
- mhurron 14y agoAnd OS X could do the same thing with the resource fork if they wanted to instead of never forgetting. Seems to me this would be a better way to do it, you're reading the resource fork for the file anyway, why also make a sqlite query as well?
- klodolph 14y agoNo, the resource fork is dead for good reasons. (1) The resource fork is fragile and easily corrupted, like the Windows registry in the bad old days. (2) Four-character namespaces suck. (3) 24 MB limits suck. (4) Extended attributes and bundles are better in every conceivable way. The resource fork was designed for a different world. (A) In the old days, there was a blurry line between OS and app, so there was no reason to make the resource fork "opaque". Without opacity, there is no graceful way to use it in a preemptive multitasking environment. (B) In the old days, pointers were 24 bits. The high 8 bits didn't go anywhere, so people used these high bits to store extra data. Resource forks make use of 24-bit quantities for this reason — which went out of favor when Macs with the 68020 were introduced in 1987. (C) The real feature of resource forks was to reduce the disk space usage and load times when you have lots of small pieces of data, but — data is bigger and we have better archive formats. So yeah, extended attributes are the way to go.
- julien_p 14y agoFiles get a "quarantine flag" set on them as metadata when downloaded on OS X. Gatekeeper uses this (along with the developer signature) to check if an app is "safe" to open or not. Not sure where this sqlite database fits in, but it's very likely related to that. See also https://support.apple.com/kb/HT3662 https://support.apple.com/kb/HT3662
- sp332 14y agoThe why is the Mac App Store exempt?
- deleted 14y ago[deleted]
- deleted 14y ago[deleted]
- nextstep 14y agoAt the end of the post, the author mentions using Automator to run a script to delete this frequently. Alternatively, you can use launchd to run scripts on a Mac. http://nb.nathanamy.org/2012/07/schedule-jobs-using-launchd/ http://nb.nathanamy.org/2012/07/schedule-jobs-using-launchd/
- Evbn 14y agoGuys, guys, watch out, I just noticed that my computer has a copy of all my files on it. Who gave Apple permission to do that? Privacy is dead!
- johnbender 14y agoFacts about files on disk that do not apply to the database entries described in the article: 1. A file on disk is the intended result of a download 2. A file is readily visible/alterable in a user interface provided for consumption of the same by the operating system 3. Removing a file means that, without serious effort, the information contained therein is gone
- gyardley 14y agoFunny, but sometimes you do want to clean up your laptop - for example, before crossing the US border. I would be irked if I had taken steps to remove a downloaded file from my laptop, including secure deletion, only to leave evidence that I'd downloaded it in a sqlite database.
- SoftwareMaven 14y agoIf you are worried about that kind of thing, I'd recommend doing that stuff in a VM with an encrypted file system. Then, when you delete it, you know everything is gone.
- esolyt 14y agoThe article isn't even accusing Apple. Why do you feel the need to defend them? I think this really can be a potential privacy issue. "Your computer having your files on it" is quite different: a) You know that your files are on your computer b) You know how to delete one of them in case you need to hide them from someone
- mhandley 14y agoWhat's perhaps more concerning is that Safari enters URLs in this database, even when Private Browsing is enabled. When you enable private browsing, Safari states: "Safari can keep your browsing history private. When you turn on private browsing, Safari doesn’t remember the pages you visit, your search history, or your AutoFill information." Well it does remember files you downloaded, even if you subsequently delete them.
- hoov 14y agoAm I the only one that disables this behavior by default? defaults write com.apple.LaunchServices LSQuarantine -bool NO Works like a charm...
- mesm 14y agoIt's also included in this sane defaults dotfile https://github.com/mathiasbynens/dotfiles/blob/master/.osx#L57 https://github.com/mathiasbynens/dotfiles/blob/master/.osx#L...
- DHowett 14y agoThat's not so much a "sane defaults dotfile" as a highly-opinionated personal defaults dotfile. I don't consider that a bad thing, but do at least give it the deserved appellation.
- Camillo 14y agoWords can have different meanings in a jargon than they do in the dictionary, but that does not make those meanings invalid. For instance, in computing "sane" means "I'm an overly opinionated git and everyone who disagrees with me is wrong."
- mirkules 14y agoThat's brilliant -- I always wanted to remove this behavior, but didn't know where to start. Thank you.
- INTPenis 14y agoAm I the only one who had nothing but updates for Adium Transmission and the occasional hot news rss from Apple in that file? Not exactly shocking material. But thanks to OP for the heads up.
- deleted 14y ago[deleted]
- schluete 14y agoNice article, but unless the database is "VACUUM"ed after the "DELETE" the rows are still readable in the database file. This kinda defeats the purpose of the whole article b/c the user didn't gain any more privacy than he had before the deletion :)
- vinhboy 14y agocan you share the command to do this?
- schluete 14y agosqlite3 ~/Library/Preferences/com.apple.LaunchServices.QuarantineEventsV* 'vacuum'
- geuis 14y agoTried this, but I still see all of the files in the list.
- toyg 14y agoThe idea is that first you run the DELETE statement from TFA, which marks the records as deleted and "hides" them but doesn't completely "forget" them, then you run the VACUUM one, which should basically erase any trace of those records ever existing in the sqlite db.
- phwd 14y agoThis is amazing, whoever feels comfortable about it should band together and see what files are in common, or domains. I want to delete this yet I don't. This contains all (most?) of the files I have ever downloaded, those I thought I lost when clearing browsing data from 2008. My first few files * Symantec_Antivirus_Mac.dmg * http://msdn01.e-academy.com|http://download.e-academy.com/download/DeliveryClientBuilder.aspx http://msdn01.e-academy.com|http://download.e-academy.com/do... (MSDN Alliance: Free Microsoft Software for Students) * http://download2.vmware.com/software/fusion/VMware-Fusion-1.1.3-94249.dmg http://download2.vmware.com/software/fusion/VMware-Fusion-1.... * http://download.skype.com/macosx/Skype_2.7.0.330.dmg http://download.skype.com/macosx/Skype_2.7.0.330.dmg Scary yes (The torrent files) but so much history to look at. sqlite3 ~/Library/Preferences/com.apple.LaunchServices.QuarantineEvents 'SELECT datetime(LSQuarantineTimeStamp + 978307200, "unixepoch") as LSQuarantineTimeStamp, LSQuarantineAgentName, LSQuarantineOriginURLString, LSQuarantineDataURLString from LSQuarantineEvent' | sort Ordered by date
- danso 14y agoThat's actually how I felt about the iPhone coordinates database (also in SQLite I believe)...I saved a copy of it before upgrading to the iOS that didn't have that "feature"
- wildranter 14y agoI guess this should help disabling. But I can't confirm as I'm not near my Mac test this. sudo launchctl -w com.apple.LaunchServices.QuarantineEvents[.plist]
- JC001 14y agoStrange, on my machine this file only contains the URL from when I installed Firefox and a bunch of URLs for Adium updates. Not any of the many other things I've downloaded... Is it only listing things downloaded through Safari?
- johnpowell 14y agoSame here. The only thing it shows I downloaded is Firefox.
- Volpe 14y agoIt show's all mine, I use Chrome for everything. Maybe Firefox downloads aren't included? Maybe it's watching the ~/Downloads folder? Can you confirm either?
- gavinlynch 14y agoI'm experiencing pretty much the exact same thing, with a few minor additions to your items: I also have iTerm2 in my list, some ADC files, and strangely some RSS xml files I have downloaded ages ago.
- tripzilch 14y agoHm, they could also have tagged the file as "came from the Internet" in the filesystem metadata associated with the file itself. That way, the "came from the Internet" tag is only around as long as it needs to: for the lifetime of the file. Avoiding the privacy problem, but also more sensible for another reason: If you'd rename or copy the file, the "came form the Internet" tag will remain or be copied with the file. With the sqlite database approach, either this association breaks, or you need to check the database every time a file is copied, moved or renamed and if it's in there, update the database, if you want to be able to track a file when it's copied or renamed. I don't know if OSX has extra logic for this, or if they just allow the association to break. But with the metadata tagging approach, you only have to run the tagging logic when the file is downloaded (to set the tag) and when it's about to be executed (to check the tag), not with every other file-operation. A strange choice, IMO: the sqlite approach makes it harder to achieve the intended goal because you need extra effort/logic required to track a file as it's copied, renamed or moved, while at the same time it makes it easier for an unintended goal: tracking users by keeping the information about the file around even when it's deleted and the "came from the Internet" warning is no longer useful.
- vicaya 14y agoAs I mentioned in another comment, apple do tag "com.apple.quarantine" as an extended attribute on the program folder/zip itself. The download log has nothing to do with the warning dialog.
- tehwalrus 14y agoI can't see any of my downloads, the database exists but is empty on my system (10.6.8). (and I've sure downloaded a lot of files...)
- jqqqz 14y agoInstall GNU+Linux, problem solved.
- sbuk 14y agoOnly if you are paranoid enough to think that this is a problem. Of course, there are other problems with installing Linux that are ignored, but that's a topic for another discussion.
- newman314 14y agoActually, there are 2 versions of this file. Depending on how long you have had your Mac, you will have both com.apple.LaunchServices.QuarantineEvents and com.apple.LaunchServices.QuarantineEventsV2 Naturally, both files will have to be cleansed.
- atomical 14y agoI get 'Error: no such table: LSQuarantineEvent'
- addandsubtract 14y agoSame here. OSX 10.6.8
- atomical 14y agoDitto.
- martinced 14y ago"Your Mac Keeps A Log Of Your Downloads"... In your user account. There's quite a difference right there. I thought it was some kind of "hidden" file (not unlike the GPS location which was saved by default on any iPhone with a GPS -- up to the latest iPhone!?) which had now been discovered. It's just in your user account so it's no big deal.
- buster 14y agoWhy is it different just because it's in your user account? Everyone with access to your Mac can access it just as well, i assume. I guess it can also be read by applications, uploaded to the internet? I don't have a Mac so i don't know the restrictions but i would consider it privacy information that i would like to know if and where it's stored. There is a reason you can delete your browser history. Or your recently accessed files list.
- fredsted 14y ago> Everyone with access to your Mac can access it just as well, i assume If they're logged on to your account, but not if they are using a different account. >I guess it can also be read by applications, uploaded to the internet? Not Mac App Store apps - they're quarantined.
- g_lined 14y agoIt's more than 'no big deal' because it does it irrespective of the Safari 'Private Browsing' feature.
- Camillo 14y agoFiles that aren't quarantines don't seem to end up in that log, unsurprisingly. No images, audio or video files, but applications and archives.
- cynwoody 14y agoYou could try something like: $ sqlite3 -column ~/Library/Preferences/com.apple.LaunchServices.QuarantineEvents <<END|pbcopy > .mode tabs > .headers on > SELECT strftime('%Y-%m-%d %H:%M:%S', LSQuarantineTimestamp+ 978307200, 'unixepoch', 'localtime') as date, > LSQuarantineAgentName as App, > LSQuarantineDataURLString as URL > FROM LSQuarantineEvent > --where LSQuarantineDataURLString like '%bankofamerica%' > order by LSQuarantineTimestamp; > END $ Then open your favorite spreadsheet program and paste in the results. The 978307200 number corrects for the fact that Apple is using 2001-01-01, the year OS 10.0 was released, as its epoch. I got way fewer rows than expected. Apparently, downloads by Firefox are not logged. When I screened for B of A downloads, I was puzzled to see only downloads in the past year or so. That's because I only recently started using Chrome to access that site.