{"id":23875,"date":"2016-07-06T02:02:27","date_gmt":"2016-07-05T19:02:27","guid":{"rendered":"http:\/\/deepquest.code511.com\/blog\/2016\/07\/sqlite-tempdir-selection\/"},"modified":"2016-07-06T02:02:27","modified_gmt":"2016-07-05T19:02:27","slug":"sqlite-tempdir-selection","status":"publish","type":"post","link":"https:\/\/deepquest.code511.com\/blog\/2016\/07\/sqlite-tempdir-selection\/","title":{"rendered":"SQLite Tempdir Selection"},"content":{"rendered":"<p>Usually processes writing to temporary directories do not need to perform readdir() because they control the filenames they create, so setting \/tmp\/ , \/var\/tmp\/ , etc. to be mode 1733 is a not uncommon UNIX hardening practice. Affected versions of SQLite reject potential tempdir locations if they are not readable, falling back to &#8216;.&#8217;. Thus, SQLite will favor e.g. using cwd for tempfiles on such a system, even if cwd is an unsafe location. Notably, SQLite also checks the permissions of &#8216;.&#8217;, but ignores the results of that check. All versions of SQLite prior to 3.13.0 are affected.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Usually processes writing to temporary directories do not need to perform readdir() because they control the filenames they create, so setting \/tmp\/ , \/var\/tmp\/ , etc. to be mode 1733&#8230;<\/p>\n","protected":false},"author":439,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[43],"tags":[],"class_list":["post-23875","post","type-post","status-publish","format-standard","hentry","category-exploit"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4bBYZ-6d5","_links":{"self":[{"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/posts\/23875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/users\/439"}],"replies":[{"embeddable":true,"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/comments?post=23875"}],"version-history":[{"count":0,"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/posts\/23875\/revisions"}],"wp:attachment":[{"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/media?parent=23875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/categories?post=23875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/deepquest.code511.com\/blog\/wp-json\/wp\/v2\/tags?post=23875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}