{"id":3982,"date":"2012-03-11T21:11:05","date_gmt":"2012-03-11T12:11:05","guid":{"rendered":"http:\/\/mimumimu.net\/blog\/?p=3982"},"modified":"2013-02-07T01:01:18","modified_gmt":"2013-02-06T16:01:18","slug":"geoiplookup-%e3%81%a7%e7%99%ba%e4%bf%a1%e5%85%83%e3%82%92%e3%81%bf%e3%82%8b%e3%80%82","status":"publish","type":"post","link":"https:\/\/mimumimu.net\/blog\/2012\/03\/11\/geoiplookup-%e3%81%a7%e7%99%ba%e4%bf%a1%e5%85%83%e3%82%92%e3%81%bf%e3%82%8b%e3%80%82\/","title":{"rendered":"geoiplookup \u3067\u767a\u4fe1\u5143\u3092\u307f\u308b\u3002"},"content":{"rendered":"

\u306a\u3093\u3068\u306a\u304f\u3001\u30b5\u30fc\u30d0\u7ba1\u7406\u3092\u3057\u3066\u3044\u308b\u4eba\u306a\u3089\u3001
\u3069\u3053\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3055\u308c\u3066\u304d\u305f\u3093\u3060\u308d\u3046\u3068\u304b\u6c17\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308b\u306f\u305a\u3002<\/p>\n

\u3068\u3044\u3046\u308f\u3051\u3067\u3001 GeoIP \u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3063\u3066\u3001\u3069\u3053\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3057\u3066\u304d\u305f\u304b\u3092\u898b\u3066\u307f\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\uff11\uff0e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/h3>\n

CentOS \u3068\u304b Fedora \u3060\u3068\u3001 geoip<\/strong><\/u> \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308c\u3070\u5165\u308a\u307e\u3059\u3002<\/p>\n

\n
# yum install geoip<\/pre>\n<\/div>\n
Ubuntu \u3055\u3093\u3068\u304b LinuxMint \u3055\u3093\u3082\u540c\u3058\u306a\u3093\u3058\u3083\u306a\u3044\u304b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n
 <\/p>\n
\uff12\uff0e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u66f4\u65b0\u3059\u308b\u3002<\/h3>\n
MaxMind GeoIP Country Database<\/p>\n
http:\/\/www.maxmind.com\/app\/geolitecountry<\/a><\/p>\n
MaxMind GeoIP City Database<\/p>\n
http:\/\/www.maxmind.com\/app\/geolitecity<\/a><\/p>\n
\u3053\u306e\uff12\u3064\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n
http:\/\/www.maxmind.com\/app\/installation?city=1<\/a><\/p>\n
\u3053\u306e\u30da\u30fc\u30b8\u306b\u5f93\u3044\u307e\u3059\u3068\u3001<\/p>\n
\n
# wget http:\/\/geolite.maxmind.com\/download\/geoip\/database\/GeoLiteCity.dat.gz\n# wget http:\/\/geolite.maxmind.com\/download\/geoip\/database\/GeoLiteCountry\/GeoIP.dat.gz\n# gzip -d GeoLiteCity.dat.gz\n# gzip -d GeoIP.dat.gz\n# mv GeoIP.dat \/usr\/share\/GeoIP\/\n# mv GeoLiteCity.dat \/usr\/share\/GeoIP\/GeoIPCity.dat<\/pre>\n<\/div>\n
\u3068\u3044\u3046\u611f\u3058\u3067\u3057\u3087\u3046\u304b\uff57<\/p>\n
 <\/p>\n
\uff13\uff0e\u4f7f\u3046\u3002<\/h3>\n
\n
$ geoiplookup 111.89.178.190\nGeoIP Country Edition: JP, Japan\nGeoIP City Edition, Rev 1: JP, 40, Tokyo, N\/A, 35.685001, 139.751404, 0, 0\nGeoIP City Edition, Rev 0: JP, 40, Tokyo, N\/A, 35.685001, 139.751404<\/pre>\n<\/div>\n
\u3053\u3093\u306a\u611f\u3058\u3002<\/p>\n
\"image\"<\/a><\/p>\n
\u3061\u306a\u307f\u306b\u5730\u56f3\u306f\u3053\u3093\u306a\u6240\u51fa\u3057\u3066\u307e\u3059\u304c\u3001<\/p>\n
\n
$ nslookup sony.ne.jp\nServer:         192.168.1.3\nAddress:        192.168.1.3#53\n\nNon-authoritative answer:\nName:   sony.ne.jp\nAddress: 111.89.178.190<\/pre>\n<\/div>\n
\u3053\u306e\u5834\u6240\u306b\u6c11\u9593\u4f01\u696d\u304c\u3042\u308b\u3068\u306f\u601d\u3048\u306a\u3044\u306e\u3067\u3001<\/p>\n
\u4f4d\u7f6e\u306e\u305a\u308c\u3092\u611f\u3058\u308b\u308f\u3051\u3067\u3059\u304c\u3002<\/p>\n
\uff08\u3053\u306e\u4f01\u696d\u3055\u3093\u306b\u306f\u3001\u30ce\u30fc\u30c8\u30d1\u30bd\u30b3\u30f3\u3067\u4e3b\u306b\u304a\u4e16\u8a71\u306b\u306a\u3063\u3066\u304a\u308a\u307e\u3059\u308b\uff09<\/p>\n
 <\/p>\n
\u3067\u3082\u3001\u56fd\u306e\u5224\u5b9a\u3068\u304b\u305d\u308c\u3050\u3089\u3044\u306b\u306f\u4f7f\u3048\u305d\u3046\u3002<\/p>\n
\u3042\u304f\u307e\u3067\u3082\u6c17\u4f11\u3081\u30fb\u30fb\u3067\u3059\u304c\uff57<\/p>\n
 <\/p>\n
\uff14\uff0e\u9069\u5f53\u306b\u4f7f\u3063\u3066\u307f\u308b\u3002<\/h3>\n
\n
$ cat access.log* | cut -f1 -d" " | sort | uniq | awk '{ print system("geoiplookup " $1) }'<\/pre>\n<\/div>\n
\u305f\u3068\u3048\u3070\u3053\u3093\u306a\u611f\u3058\u3002<\/p>\n
Apache \u306e\u30ed\u30b0\u304b\u3089IP \u30a2\u30c9\u30ec\u30b9\u51fa\u3057\u3066\u304d\u3066\u3001geoiplookup \u306b\u639b\u3051\u307e\u304f\u308a\u307e\u3059\u3002<\/p>\n
\u52d5\u4f5c\u30b5\u30f3\u30d7\u30eb\u306f\u500b\u4eba\u60c5\u5831\u304c\u3082\u308d\u3082\u308d\u5165\u3063\u3066\u3044\u308b\u306e\u3067\u6b62\u3081\u307e\u3059\u304c\u3002<\/p>\n
\u3067\u3042\u3067\u3042\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u306a\u3093\u3068\u306a\u304f\u3001\u30b5\u30fc\u30d0\u7ba1\u7406\u3092\u3057\u3066\u3044\u308b\u4eba\u306a\u3089\u3001 \u3069\u3053\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3055\u308c\u3066\u304d\u305f\u3093\u3060\u308d\u3046\u3068\u304b\u6c17\u306b\u306a\u308b\u3053\u3068\u304c\u3042\u308b\u306f\u305a\u3002 \u3068\u3044\u3046\u308f\u3051\u3067\u3001 GeoIP \u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3063\u3066\u3001\u3069\u3053\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3057\u3066\u304d\u305f\u304b\u3092\u898b\u3066\u307f\u307e\u3059\u3002   \uff11\uff0e\u30a4 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,12],"tags":[28,29],"class_list":["post-3982","post","type-post","status-publish","format-standard","hentry","category-unix-linux","category-software","tag-geoiplookup","tag-29"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t