Web\u4e0a\u3067\u516c\u958b\u3057\u3066\u3044\u308b CGI\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u4e2d\u306b\u306f\u3001\u51e6\u7406\u304c\u91cd\u305f\u3044\u3082\u306e\u3082\u3042\u308b\u3002<\/p>\n
\u3053\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u9ad8\u983b\u5ea6\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u304c\u5c4a\u304f\u3068\u30b5\u30fc\u30d0\u8ca0\u8377\u304c\u4e0a\u304c\u308a\u30fb\u30fb\u30fb
\n\u5171\u7528\u30b5\u30fc\u30d0\u3067\u3042\u308c\u3070\u30a2\u30ab\u30a6\u30f3\u30c8\u304cBAN\u3055\u308c\u308b\u6050\u308c\u304c\u3042\u308b\u3002<\/p>\n
\u3088\u3063\u3066\u3001 IP\u30a2\u30c9\u30ec\u30b9\u306b\u3088\u308b\u30d6\u30ed\u30c3\u30af\u51e6\u7406\u3092\u5b9f\u88c5\u3057\u3001\u3053\u308c\u3092 CGI\u306e\u5148\u982d\u3067\u5b9f\u884c\u3059\u308b\u3002 \u30101\u3011\u3084\u308a\u305f\u3044\u3053\u3068 Web\u4e0a\u3067\u516c\u958b\u3057\u3066\u3044\u308b CGI\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u4e2d\u306b\u306f\u3001\u51e6\u7406\u304c\u91cd\u305f\u3044\u3082\u306e\u3082\u3042\u308b\u3002 \u3053\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306b\u9ad8\u983b\u5ea6\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u304c\u5c4a\u304f\u3068\u30b5\u30fc\u30d0\u8ca0\u8377\u304c\u4e0a\u304c\u308a\u30fb\u30fb\u30fb \u5171\u7528\u30b5\u30fc\u30d0\u3067\u3042\u308c\u3070\u30a2\u30ab\u30a6\u30f3\u30c8\u304cBAN\u3055\u308c\u308b\u6050\u308c\u304c\u3042\u308b\u3002 \u2026 \u7d9a\u304d\u3092\u8aad\u3080 »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48,26],"tags":[],"class_list":["post-3619","post","type-post","status-publish","format-standard","hentry","category-cgi","category-web"],"views":723,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/3619","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/comments?post=3619"}],"version-history":[{"count":16,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/3619\/revisions"}],"predecessor-version":[{"id":3637,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/posts\/3619\/revisions\/3637"}],"wp:attachment":[{"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/media?parent=3619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/categories?post=3619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dogrow.net\/python\/wp-json\/wp\/v2\/tags?post=3619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\u540c\u3058IP\u30a2\u30c9\u30ec\u30b9\u304b\u3089\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u4e00\u5b9a\u6642\u9593\u62d2\u5426\u3059\u308b\u5b9f\u88c5\u3092\u52a0\u3048\u305f\u3044\u3002<\/span><\/p>\n\u30102\u3011\u3084\u3063\u3066\u307f\u308b<\/h1>\n
\n\u30a2\u30af\u30bb\u30b9\u5c65\u6b74\u306e\u7ba1\u7406\u306b\u306f\u3001\u7c21\u6613DB\u3067\u3042\u308b SQLite3<\/span> \u3092\u4f7f\u3046\u3053\u3068\u306b\u3057\u305f\u3002<\/p>\n\r\nimport os\r\nimport time\r\nimport sqlite3\r\n\r\nclass IPBlocker:\r\n def __init__(self, db_path='\/home\/hoge\/ip_access_log.db', block_seconds=10):\r\n self.db_path = db_path\r\n self.block_seconds = block_seconds\r\n self._init_db()\r\n\r\n # \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30c6\u30fc\u30d6\u30eb\u3092\u521d\u671f\u5316\r\n def _init_db(self):\r\n conn = sqlite3.connect(self.db_path)\r\n cur = conn.cursor()\r\n cur.execute('CREATE TABLE IF NOT EXISTS ip_access (ip TEXT PRIMARY KEY, last_access INTEGER)')\r\n conn.commit()\r\n conn.close()\r\n\r\n def check_ip(self):\r\n remote_ip = os.environ.get('REMOTE_ADDR', '')\r\n now = int(time.time())\r\n\r\n conn = sqlite3.connect(self.db_path)\r\n cur = conn.cursor()\r\n\r\n # \u53e4\u3044\u30ec\u30b3\u30fc\u30c9\u524a\u9664\r\n cutoff_time = now - self.block_seconds\r\n cur.execute('DELETE FROM ip_access WHERE last_access < ?', (cutoff_time,))\r\n\r\n # \u73fe\u5728\u306eIP\u306e\u6700\u7d42\u30a2\u30af\u30bb\u30b9\u78ba\u8a8d\r\n cur.execute('SELECT last_access FROM ip_access WHERE ip = ?', (remote_ip,))\r\n row = cur.fetchone()\r\n\r\n # \u30ec\u30b3\u30fc\u30c9\u304c\u5b58\u5728 \u2192 block_seconds\u4ee5\u5185\u306b\u30a2\u30af\u30bb\u30b9\u3042\u308a \u2192 \u30a2\u30af\u30bb\u30b9\u62d2\u5426\r\n if row:\r\n conn.close()\r\n print("Status: 429 Too Many Requests")\r\n print("Content-Type: text\/plain\\n")\r\n print("Too many requests. Please wait a few seconds.")\r\n exit(0)\r\n\r\n # \u4eca\u56de\u306e\u30a2\u30af\u30bb\u30b9\u3092\u8a18\u9332\uff08INSERT OR REPLACE\uff09\r\n cur.execute('REPLACE INTO ip_access (ip, last_access) VALUES (?, ?)', (remote_ip, now))\r\n conn.commit()\r\n conn.close()\r\n<\/pre>\n\r\n#!\/usr\/bin\/python\r\n# -*- coding: utf-8 -*-\r\n\r\n#-------------------------------->>> IP\u30a2\u30c9\u30ec\u30b9\u306b\u3088\u308b\u983b\u5ea6\u5236\u9650\r\nfrom ip_blocker import IPBlocker\r\nIPBlocker().check_ip()\r\n#--------------------------------<<< IP\u30a2\u30c9\u30ec\u30b9\u306b\u3088\u308b\u983b\u5ea6\u5236\u9650\r\n\r\nprint("Content-Type: text\/html; charset=utf-8\\n")\r\n\u3000\uff1a\r\n\u4ee5\u4e0b\u306b CGI\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u66f8\u304f\u3002\r\n\u3000\uff1a\r\n<\/pre>\n
\n","protected":false},"excerpt":{"rendered":"