[B! Kazuho] elfã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

elf id:elf

Kazuhoã«é–¢ã™ã‚‹elfã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒæ¼æ´©ã—ãªã„ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã®ä½œã‚Šæ–¹ ã€œ ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã§æº€è¶³ã™ã‚‹å‰ã«è€ƒãˆã‚‹ã¹ãã“ã¨
â– â– åºè«– å¾³ä¸¸ã•ã‚“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã€Œã„ã¾ã•ã‚‰èžã‘ãªã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®å–ã‚Šæ‰±ã„æ–¹ã€ã«è¦‹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã€æ˜¨ä»Šã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨è¨ˆè¦ä»¶ã¨ã—ã¦ã€ã‚µãƒ¼ãƒå†…ã«ä¾µå…¥ã•ã‚ŒãŸå ´åˆã§ã‚‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ã§ãã‚‹ã ã‘ä¿è·ã™ã¹ãã¨ã„ã†è«–èª¿ãŒè¦‹å—ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã—ãŸã€‚ ä¸ŠæŽ²ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã¯ã€ãã®æ‰‹æ³•ã¨ã—ã¦ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥åŒ–ã‚’å‹§ã‚ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã‚¹ãƒ©ã‚¤ãƒ‰ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ã¨ãŠã‚Šã€ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã«ã¯ã€è¤‡é›‘ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®è§£èªã¯å›°é›£ã«ãªã‚‹ã‚‚ã®ã®ã€å˜ç´”ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã—ã¦ã—ã¾ã£ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã«ã¤ã„ã¦ã¯ååˆ†ãªä¿è·ã‚’æä¾›ã§ããªã„ã¨ã„ã†å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯é©åˆ‡ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰é‹ç”¨ãŒã§ããªã„ã€ã¨ã„ã†ã®ãŒæ‚²ã—ã„ç¾å®Ÿã§ã™ã€‚ ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥ã‚’ä½¿ã£ãŸæ‰‹æ³•ã§ã“ã®ã‚ˆã†ãªå•é¡ŒãŒæ®‹ã‚‹ã®ã¯ã€ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã«ä¾µå…¥ã—ãŸæ”»æ’ƒè€…ãŒãƒ¦ãƒ¼ã‚¶ãƒ¼ã®èªè¨¼æƒ…å ±ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã€èªè¨¼æƒ…å ±ã‚’ã‚ªãƒ•ãƒ©ã‚¤ãƒ³æ”»æ’ƒã™ã‚‹ã“
elf 2013/11/22
å¥½ã¿ã ã‘ã©ä¸€èˆ¬çš„ãªã‚¦ã‚§ãƒ–ç•Œéšˆã§ã‚„ã‚‹ã®ã¯å¤§å¤‰ãã†ï¼ˆè‹¦ç¬‘ #kazuhooku #security #password

Kazuho

Security

Password
ãƒªãƒ³ã‚¯
ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ã‚½ãƒ«ãƒˆã¤ããƒãƒƒã‚·ãƒ¥åŒ–ã—ã¦DBã«ä¿å˜ã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹â€¦ã¨ã¯é™ã‚‰ãªã„ã¨ã„ã†è©± - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®è²¬å‹™ã¨ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ - MugeSoã®æ—¥è¨˜ã«ã¤ã„ã¦ã®æ„Ÿæƒ³æ–‡ã§ã™ã€‚ ä¸–ã®ä¸ã«ã¯ãŸãã•ã‚“ã®é€šä¿¡ãƒ—ãƒãƒˆã‚³ãƒ«ãŒå˜åœ¨ã—ã€ä¸ã«ã¯ã€ç‰¹å®šã®æ¡ä»¶ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å«ã‚€æ–‡å—åˆ—ã‚’ãƒãƒƒã‚·ãƒ¥åŒ–ã—ãŸå€¤ã‚’æ¤œè¨¼ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‚‚ã®ã‚‚å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ ä¾‹ãˆã°ã€HTTP Digestèªè¨¼ã®å ´åˆã¯ã€MD5("realm:user:password")ã‚’ä¿å˜ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã—ã€APOPã®å ´åˆã¯ç”Ÿã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ã€CRAM-MD5ã®å ´åˆã¯MD5("password")ã‚’ä¿å˜ã—ã¦ãŠãå¿…è¦ãŒã‚ã£ãŸã¯ãšã€‚ ã§ã€ã“ã†ã„ã£ãŸæ§˜ã€…ãªãƒ—ãƒãƒˆã‚³ãƒ«ã«å¯¾å¿œå¯èƒ½ãªèªè¨¼ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æº–å‚™ã—ã‚ˆã†ã¨ã™ã‚‹ã¨ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¾©å·å¯èƒ½ãªæ–¹å¼ã§ä¿å˜ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™*1ã€‚ ãŸã ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å¾©å·å¯èƒ½ãªæ–¹å¼ã§ä¿å˜ã™ã‚‹ã¨ã‹ã€é–‹ç™ºè€…ã‚ã‚‹ã„ã¯ç®¡ç†è€…ã¨ã—ã¦ã‚„ã‚ŠãŸããªã„ã¨ã„ã†ã®ã¯ã‚‚ã¡ã‚ã‚“ãã†ãªã®ã§ã€‚ã§ã€é•·æœŸçš„ã«ã¯ä¸–ã®ä¸ã©ã“ã¸å‘ã‹ã£ã¦ã‚‹ã‹ã¨ã„ã†ã¨ï¼š é¸æŠžè‚¢a
elf 2013/11/22
#kazuhooku #security #password

Kazuho

Security

Password
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹ã”ã¨ã«ç•°ãªã‚‹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’ä½¿ã„åˆ†ã‘ã‚‹æ–¹æ³• - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
æœ€è¿‘ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®ä½¿ã„å›žã—ã‚’ã—ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«å¯¾ã™ã‚‹æ”»æ’ƒãŒå‡ºå›žã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¦ã„ã¾ã™ (å‚ç…§: ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰æ”»æ’ƒã«å¯¾æŠ—ã™ã‚‹Webã‚µã‚¤ãƒˆå´ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¼·åŒ–ç– | å¾³ä¸¸æµ©ã®æ—¥è¨˜) ãŒã€ãƒžã‚¹ã‚¿ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‹ã‚‰ã‚µãƒ¼ãƒ“ã‚¹ã”ã¨ã«ç•°ãªã‚‹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹ã®ãŒç°¡å˜ãªå¯¾ç–ã§ã™ã‚ˆãã€‚ ãƒ—ãƒã‚°ãƒ©ãƒžãªã‚‰ï¼ˆã‚‚ã—ãã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³æ“ä½œã«æ…£ã‚Œã¦ã„ã‚‹ã®ãªã‚‰ï¼‰ã€ã“ã‚“ãªæ„Ÿã˜ã§ã§ãã‚‹ã‹ãªãƒ¼ã¨æ€ã„ã¾ã™ã€‚ $ perl -MDigest::HMAC_SHA1 -wle 'print Digest::HMAC_SHA1->new($ARGV[0])->add($ARGV[1])->b64digest' "my-master-password" example.com Mau83v+ml6dRViOZhcRdHM0NXzY $HMAC é–¢æ•°ã«ãƒžã‚¹ã‚¿ãƒ¼ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã¨ã‚µãƒ¼ãƒ“ã‚¹ã®ãƒ‰ãƒ¡ã‚¤ãƒ³åã‚’é£Ÿã‚ã›ã¦ã€ãã®å‡ºåŠ›ã‚’ã‚µãƒ¼ãƒ“ã‚¹å°‚ç”¨ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã«ã™
elf 2013/10/02
æ˜”ã“ã†ã„ã†ã®ã‚„ã£ã¦ãŸã‚“ã ã‘ã©ãƒ‰ãƒ¡ã‚¤ãƒ³å¤‰ã‚ã£ã¦æ³£ã„ãŸã“ã¨ãŒã‚ã‚‹ï¼Žã‚ã¨ä½¿ãˆã‚‹andorå¿…é ˆã®æ–‡å—ç¨®ï¼Œæ–‡å—æ•°ã§NGã ã£ãŸã‚Šï¼Œã©ã®ãƒ¬ãƒ™ãƒ«ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¾ã§å¯¾è±¡ã«ã™ã‚‹ã‹ã¨ã‹è‡ªåˆ†ã§ã‚ã„ã¾ã„ã«ãªã£ãŸã‚Šã§ã„ã¾ã¯KeePassã•ã¾ã®ç”Ÿæˆã«ä»»

Security

Password

Kazuho
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: PostgreSQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
å…ˆæ—¥æ›¸ã„ãŸã€ŒMySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•ã€ã«ã¤ã„ã¦ã€PostgreSQL ã§ã‚‚ pg_stat_activity ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ã£ã¦å®Ÿè¡Œä¸ã®ã‚¯ã‚¨ãƒªä¸€è¦§ã‚’å–å¾—ã§ãã‚‹ã¨ higepon ã•ã‚“ã«æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ % ppdump > ppdump.txt ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã‚’ã‚µãƒ³ãƒ—ãƒªãƒ³ã‚° (ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§100ç§’é–“ç¨‹åº¦) ã—ã¦ã€ % ppfilter < ppdump.txt | ppreport ã®ã‚ˆã†ã«ã™ã‚‹ã¨ã€å¹³å‡è² è·ã®é«˜ã„ã‚¯ã‚¨ãƒªã‹ã‚‰é †ã«ã‚½ãƒ¼ãƒˆã•ã‚Œã¦è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚è©³ã—ã„ä½¿ã„æ–¹ã‚„è€ƒãˆæ–¹ã«ã¤ã„ã¦ã¯ã€mprofile ã®ã‚¨ãƒ³ãƒˆãƒªã‚’ã”å‚ç…§ãã ã•ã„ã€‚ pprofile ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã€/platform/postgresql/pprofile â€“ CodeRepos::Share â€“ Tracã«ç½®ã„ã¦ã‚ã‚Šã¾ã™ã€‚è² è·ãŒé«˜ã„ PostgreSQL ç’°å¢ƒãŒæ‰‹å…ƒã«ãªã„ã®
elf 2013/09/06
PostgreSQL

Analyze

Kazuho
ãƒªãƒ³ã‚¯
Re: @kazuho: handlersocket plugin ã‚„ mycached ã‚’ä½¿ãˆã° memcached ã¯ä¸è¦ã‹ã€ãã‚Œã¨ã‚‚ä½¿ã†ã¹ãã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã‹ã€‚è€ƒå¯Ÿã›ã‚ˆ [10ç‚¹] - blog.nomadscafe.jp
handlersocket plugin ã‚„ mycached ã‚’ä½¿ãˆã° memcached ã¯ä¸è¦ã‹ã€ãã‚Œã¨ã‚‚ä½¿ã†ã¹ãã‚±ãƒ¼ã‚¹ãŒã‚ã‚‹ã‹ã€‚è€ƒå¯Ÿã›ã‚ˆ [10ç‚¹] kazuho (Kazuho Oku) http://twitter.com/kazuho/status/21477219149 è€ƒãˆã¦ç”ãˆã¦ã¿ã‚‹ã€‚ HandlerSocketã‚„mycachedã‚’åˆ©ç”¨ã—ã€MySQLã¸ã®æŽ¥ç¶šæ•°ãŒæ•°ä¸‡å˜ä½ã§è¡Œãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã‚Šã€ã‚ˆã‚Šå¤šãã®ã‚¯ã‚¨ãƒªæ•°ãŒç™ºè¡Œã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã‚‚ã€memcachedã¯ä¸è¦ã§ã¯ãªã„ã—ã€ä½¿ã†ã¹ãã‚±ãƒ¼ã‚¹ã‚‚ã‚ã‚Šã¾ã™ã€‚ memcachedã¯å˜ãªã‚‹KVSã§ã¯ãªãã€Expiresã¨LRUãŒã¤ã„ãŸã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã§ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«ã¯æœŸé™ã‚’ä»˜ã‘ã‚‹äº‹ãŒã§ãã€æœŸé™ãŒéŽãŽãŸã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯ç„¡åŠ¹ã«ã•ã‚Œã€ã¾ãŸã‚¢ã‚¯ã‚»ã‚¹ãŒã•ã‚Œã¦ã„ãªã„ä¸è¦ã«ãªã£ãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¯å‰Šé™¤ã•ã‚Œã€ç©ºã„ãŸã‚¹ãƒšãƒ¼ã‚¹ã¯æ–°ã—ã„ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚ª
elf 2010/08/20
MySQL

memcache

handlersocket

kazeburo

Kazuho

Think
ãƒªãƒ³ã‚¯
Google ã®å„å›½ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚’ä¸€è¦§ã«ã™ã‚‹ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
$ curl http://www.google.com/language_tools 2> /dev/null | perl -MList::MoreUtils=apply -le 'apply { s{a\s+href="http://(?:www\.|)(google\.[a-z\.]+)/?"}{print $1}eg } (<STDIN>)' | sort | uniq google.ad google.ae google.am ...id:kdaiba++
elf 2009/01/28
Perl

Google

Country

Kazuho

One liner
ãƒªãƒ³ã‚¯
1