TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Your Mac Keeps A Log Of Your Downloads

243 点作者 fcukdigg超过 12 年前

18 条评论

ehamberg超过 12 年前
This 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:<p><a href="http://i.imgur.com/IbUWj.png" rel="nofollow">http://i.imgur.com/IbUWj.png</a>
评论 #5081299 未加载
评论 #5080517 未加载
评论 #5080778 未加载
评论 #5080470 未加载
phwd超过 12 年前
This 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.<p>My first few files<p>* Symantec_Antivirus_Mac.dmg<p>* <a href="http://msdn01.e-academy.com|http://download.e-academy.com/download/DeliveryClientBuilder.aspx" rel="nofollow">http://msdn01.e-academy.com|http://download.e-academy.com/do...</a> (MSDN Alliance: Free Microsoft Software for Students)<p>* <a href="http://download2.vmware.com/software/fusion/VMware-Fusion-1.1.3-94249.dmg" rel="nofollow">http://download2.vmware.com/software/fusion/VMware-Fusion-1....</a><p>* <a href="http://download.skype.com/macosx/Skype_2.7.0.330.dmg" rel="nofollow">http://download.skype.com/macosx/Skype_2.7.0.330.dmg</a><p>Scary yes (The torrent files) but so much history to look at.<p><pre><code> sqlite3 ~/Library/Preferences/com.apple.LaunchServices.QuarantineEvents 'SELECT datetime(LSQuarantineTimeStamp + 978307200, "unixepoch") as LSQuarantineTimeStamp, LSQuarantineAgentName, LSQuarantineOriginURLString, LSQuarantineDataURLString from LSQuarantineEvent' | sort </code></pre> Ordered by date
评论 #5081036 未加载
评论 #5081135 未加载
schluete超过 12 年前
Nice 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 :)
评论 #5080893 未加载
tripzilch超过 12 年前
Hm, 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:<p>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.<p>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.<p>A strange choice, IMO: the sqlite approach makes it <i>harder</i> 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 <i>easier</i> 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.
评论 #5081308 未加载
hoov超过 12 年前
Am I the only one that disables this behavior by default?<p>defaults write com.apple.LaunchServices LSQuarantine -bool NO<p>Works like a charm...
评论 #5080886 未加载
评论 #5081206 未加载
评论 #5081312 未加载
julien_p超过 12 年前
Files 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.<p>See also <a href="https://support.apple.com/kb/HT3662" rel="nofollow">https://support.apple.com/kb/HT3662</a>
评论 #5080569 未加载
JC001超过 12 年前
Strange, 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...<p>Is it only listing things downloaded through Safari?
评论 #5081498 未加载
评论 #5081253 未加载
tehwalrus超过 12 年前
I 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...)
cynwoody超过 12 年前
You could try something like:<p><pre><code> $ sqlite3 -column ~/Library/Preferences/com.apple.LaunchServices.QuarantineEvents &#60;&#60;END|pbcopy &#62; .mode tabs &#62; .headers on &#62; SELECT strftime('%Y-%m-%d %H:%M:%S', LSQuarantineTimestamp+ 978307200, 'unixepoch', 'localtime') as date, &#62; LSQuarantineAgentName as App, &#62; LSQuarantineDataURLString as URL &#62; FROM LSQuarantineEvent &#62; --where LSQuarantineDataURLString like '%bankofamerica%' &#62; order by LSQuarantineTimestamp; &#62; END $ </code></pre> Then open your favorite spreadsheet program and paste in the results.<p>The 978307200 number corrects for the fact that Apple is using 2001-01-01, the year OS 10.0 was released, as its epoch.<p>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.
binarycrusader超过 12 年前
And I suspect that if you had a virus scanner installed on windows every file it scanned would be logged somewhere depending on settings.<p>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.
评论 #5080509 未加载
评论 #5080466 未加载
评论 #5080459 未加载
Camillo超过 12 年前
Files that aren't quarantines don't seem to end up in that log, unsurprisingly. No images, audio or video files, but applications and archives.
nextstep超过 12 年前
At 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. <a href="http://nb.nathanamy.org/2012/07/schedule-jobs-using-launchd/" rel="nofollow">http://nb.nathanamy.org/2012/07/schedule-jobs-using-launchd/</a>
newman314超过 12 年前
Actually, there are 2 versions of this file.<p>Depending on how long you have had your Mac, you will have both com.apple.LaunchServices.QuarantineEvents and com.apple.LaunchServices.QuarantineEventsV2<p>Naturally, both files will have to be cleansed.
atomical超过 12 年前
I get 'Error: no such table: LSQuarantineEvent'
评论 #5083244 未加载
jqqqz超过 12 年前
Install GNU+Linux, problem solved.
评论 #5082920 未加载
Evbn超过 12 年前
Guys, guys, watch out, I just noticed that my computer has a copy of <i>all</i> my files on it. Who gave Apple permission to do that? Privacy is dead!
评论 #5080815 未加载
评论 #5080728 未加载
评论 #5080750 未加载
评论 #5081540 未加载
评论 #5083900 未加载
martinced超过 12 年前
<i>"Your Mac Keeps A Log Of Your Downloads"</i>...<p>In your user account.<p>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.<p>It's just in your user account so it's no big deal.
评论 #5083120 未加载
评论 #5085212 未加载
barista超过 12 年前
"You should not be downloading anything that you don't want anybody else to know" Eric Schmidt would say
评论 #5080681 未加载
评论 #5083282 未加载
评论 #5082088 未加载
评论 #5080504 未加载
评论 #5082022 未加载