[B! æ–‡å—ã‚³ãƒ¼ãƒ‰] kgbuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kgbu id:kgbu

æ–‡å—ã‚³ãƒ¼ãƒ‰ã«é–¢ã™ã‚‹kgbuã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{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}}

æ–‡å—ã‚³ãƒ¼ãƒ‰ã«èµ·å› ã™ã‚‹è„†å¼±æ€§ã‚’é˜²ãã€Œã‚„ã‚„å®‰å…¨ãªã€php.iniè¨å®š
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ï¼ˆå…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ï¼‰ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2010å¹´9æœˆ27æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2010ã«ã¦ã€Œæ–‡å—ã‚³ãƒ¼ãƒ‰ã«èµ·å› ã™ã‚‹è„†å¼±æ€§ã¨ãã®å¯¾ç–ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§å–‹ã‚‰ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‚’PDFå½¢å¼ã¨slideshare.netã§å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ æ–‡å—ã‚³ãƒ¼ãƒ‰ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã¨ã„ã†ã¨ã€ã‚„ã‚„ã“ã—ã„ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒå¼·ãã¦ã€ã‚¹ãƒ”ãƒ¼ã‚«ãƒ¼ã®å‰å¤œç¥ã§ã‚‚ã€Œè´è¡†ã®åŠåˆ†ã¯ç½®ã„ã¦ãã¼ã‚Šã«ãªã‚‹ã‹ã‚‚ãã€ã¿ãŸã„ãªè©±ã‚’ã—ã¦ã„ãŸã®ã§ã™ãŒã€æ„å¤–ã«ã‚‚ã€Œåˆ†ã‹ã‚Šã‚„ã™ã‹ã£ãŸã€ç‰ã®å¥½æ„çš„ãªåå¿œã‚’twitterç‰ã§ã„ãŸã ãã€é©šãã¨å…±ã«å–œã‚“ã§ã„ã¾ã™ã€‚åœŸæ›œã«PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«æ¥ã‚‰ã‚Œã‚‹ã‚ˆã†ãªæ–¹ã¯æ„è˜ãŒé«˜ã„ã¨ã„ã†ã®
kgbu 2010/09/27
php

security

knowhow

ã‚ã¨ã§èªã‚€

ã‚ã¨ã§èª¿ã¹ãŸã„

ã¾ã¨ã‚

vulnerability

webåˆ¶ä½œ

programming

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
ã¼ããŒPDOã‚’æŽ¡ç”¨ã—ãªã‹ã£ãŸã‚ã‘(Shift_JISã«ã‚ˆã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³)
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ã€‚å…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2010å¹´7æœˆ1æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š PHPã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚¢ã‚¯ã‚»ã‚¹ãƒ»ãƒ©ã‚¤ãƒ–ãƒ©ãƒªPDOã¯ã€DBæŽ¥ç¶šæ™‚ã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°æŒ‡å®šãŒã§ããªã„ãŸã‚ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®é¸æŠžã«ã‚ˆã£ã¦ã¯ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã‚’ä½¿ã£ã¦ã„ã¦ã‚‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒç™ºç”Ÿã—ã¾ã™ã€‚ è¿½è¨˜(2011/06/19) ã“ã“ã«æ¥ã¦æ€¥ã«ãƒ–ã‚¯ãƒžãŒè¿½åŠ ã•ã‚Œã¯ã˜ã‚ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã‹ã‚‰çŠ¶æ³ãŒæ”¹å–„ã—ã¦ã„ã¾ã™ã€‚PHP5.3.6(2011/03/17)ã«ã¦ã€PDOã§ã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æŽ¥ç¶šã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’æŒ‡å®šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã“ã®ç‰ˆã§ã€UNIXç‰ˆã®PHPã§ã¯è§£æ±ºã—ã¾ã—ãŸãŒã€Win
kgbu 2010/09/27
php

bad knowhow

security

library

db

sqlã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

æ–‡å—ã‚³ãƒ¼ãƒ‰

programming

ã„ã¾ã•ã‚‰è¨Šã‘ãªã„

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
Unicode ã®é›ªã ã‚‹ã¾ - bkãƒ–ãƒã‚°
Unicode ã®é›ªã ã‚‹ã¾ Unicode Snowman for You ã¨ã„ã†ã‚µã‚¤ãƒˆã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚Unicode ã®é›ªã ã‚‹ã¾ (U+2603 SNOWMAN â˜ƒ) ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã ã‘ã®ã‚µã‚¤ãƒˆã§ã™ã€‚ãŒã€ã‚½ãƒ¼ã‚¹ã‚’è¦‹ã‚‹ã¨ font-face ã§ EOT å½¢å¼ã®ã‚¦ã‚§ãƒ–ãƒ•ã‚©ãƒ³ãƒˆãŒä½¿ã‚ã‚Œã¦ã„ã‚‹ã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚ ã“ã® EOT (Embedded Open Type) å½¢å¼ã®ã‚¦ã‚§ãƒ–ãƒ•ã‚©ãƒ³ãƒˆã¯ IE ã—ã‹å¯¾å¿œã—ã¦ã„ãªã„ã‚ˆã†ã§ã™ã€‚IE ã§è¡¨ç¤ºã™ã‚‹ã¨ã“ã®ã‚ˆã†ãªé›ªã ã‚‹ã¾ãŒè¡¨ç¤ºã•ã‚Œã¾ã—ãŸã€‚ã“ã‚Œã¯ãŠãã‚‰ã Arial Unicode MS ã®é›ªã ã‚‹ã¾ã§ã™ã€‚ã¡ã‚‡ã£ã¨ã“ã‚ã„ã‚ˆã†ãªã€‚ã€‚ ä¸€æ–¹ã€ä»–ã®ãƒ–ãƒ©ã‚¦ã‚¶ã§è¡¨ç¤ºã™ã‚‹ã¨ã€ã“ã®ã‚ˆã†ãªé›ªã ã‚‹ã¾ãŒè¡¨ç¤ºã•ã‚Œã¾ã—ãŸã€‚ã“ã‚Œã¯ç§ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ãƒ•ã‚©ãƒ³ãƒˆã«è¨å®šã—ã¦ã„ã‚‹ãƒ¡ã‚¤ãƒªã‚ªã®é›ªã ã‚‹ã¾ã§ã™ã€‚ã“ã‚Œã¯ã‹ã‚ã„ã„ã€‚æ„å¤–ãªã¨ã“ã‚ã«ã‚‚åŠ›ãŒå…¥ã£ã¦ã„ã¾ã™ã€‚
kgbu 2009/12/25
ãƒã‚¿

xmas

æ–‡å—ã‚³ãƒ¼ãƒ‰

font
ãƒªãƒ³ã‚¯
ä½•æ•…ã‹ã‚ãŸã‚Šå‰ã«ãªã‚‰ãªã„æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³
(Last Updated On: 2018å¹´8æœˆ8æ—¥)ç§ãŒ4å¹´å‰ï¼ˆ2005å¹´ï¼‰ã«ã€ŒWebã‚¢ãƒ—ãƒªã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¯¾ç–å…¥é–€ã€ã‚’åŸ·ç†ã—ã¦ã„ãŸæ™‚ã«ã¯ã€æ—¢ã«å£Šã‚ŒãŸæ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãªã©ã®ä¸æ£ãªæ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’åˆ©ç”¨ã—ãŸJavaScriptã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã¯æ¯”è¼ƒçš„åºƒãçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚ã“ã®å•é¡Œã¯å½“æ™‚ã®ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ãƒ‰ãƒƒãƒˆã‚¸ãƒ£ãƒ‘ãƒ³ã§ã‚‚å–ã‚Šä¸Šã’ã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚/.ã§å–ã‚Šä¸Šã’ã‚‰ã‚ŒãŸã®ã§ã€ãã“ã‚‰ä¸ã®Webã‚µã‚¤ãƒˆã¨ãƒ¦ãƒ¼ã‚¶ãŒè¢«å®³ã«åˆã†ã®ã§ã¯ï¼Ÿã¨ãƒ’ãƒ¤ãƒ’ãƒ¤ã—ãŸã®ã§è‰¯ãè¦šãˆã¦ã„ã¾ã™ã€‚ ä¸æ£ãªæ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’åˆ©ç”¨ã—ãŸæ”»æ’ƒã¯ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’åŽ³æ ¼ã«å–ã‚Šæ‰±ã„ã€æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚Œã°ç„¡ããªã‚Šã¾ã™ã€‚ã“ã‚Œã‚’æ€ ã‚‹ã¨ã€ã‚·ã‚¹ãƒ†ãƒ ã®ã©ã“ã§å•é¡ŒãŒç™ºç”Ÿã™ã‚‹ã‹äºˆæƒ³ã§ããªããªã‚Šã¾ã™ã€‚ã¤ã¾ã‚Šã€ã„ã„åŠ æ¸›ã«æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å–ã‚Šæ‰±ã†ã¨å®‰å…¨ãªã‚·ã‚¹ãƒ†ãƒ ã¯ä½œã‚Œãªã„ã®ã§ã™ã€‚ å‚è€ƒï¼šã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«
kgbu 2009/09/11
è€³ã‚¤ã‚¿ã™ãŽã€‚ã‚ãŸã‚Šã¾ãˆã«ãªã‚‰ãªã„ã‹ã‚‰ã¨ã„ã£ã¦æ‰‹ã‚’æŠœãç†ç”±ã«ãªã‚‰ã‚“ãœï¼žè‡ªåˆ†

vulnerability

æ–‡å—ã‚³ãƒ¼ãƒ‰

security hole

security

webåˆ¶ä½œ

ãã‚ã°ã‚‰ãã‚ã°ã‚‰

ã„ã¾ã•ã‚‰è¨Šã‘ãªã„

ã¾ã¨ã‚

ã‚ã‚‹ã‚ã‚‹

programming
ãƒªãƒ³ã‚¯
Mojibake - Wikipedia
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources:Â "Mojibake"Â â€“Â newsÂ Â· newspapersÂ Â· booksÂ Â· scholarÂ Â· JSTOR (March 2023) (Learn how and when to remove this message) The UTF-8-encoded Japanese Wikipedia article for Mojibake displayed as if interpreted as W
kgbu 2009/07/31
ãã®ã¾ã‚“ã¾ã˜ã‚ƒé€šã˜ãªã•ã’

ãƒã‚¿

æ–‡å—ã‚³ãƒ¼ãƒ‰

trouble

i18n

è¨€èªž

ã„ã¾ã•ã‚‰è¨Šã‘ãªã„
ãƒªãƒ³ã‚¯
HTTPè¦æ±‚çµŒç”±ã®ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚° - Scrapcode@ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
Google Maps APIã¨LWPã‚’ä½¿ã£ã¦ã€åœ°åã‚„ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‹ã‚‰ä½æ‰€ã‚’å–å¾—(ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°)ã—ã¦ã„ã¾ã—ãŸã€‚ãŒã€ã„ã¤ã‹ã‚‰ã‹å–å¾—ãƒ‡ãƒ¼ã‚¿ãŒè‹±èªžè¡¨è¨˜ã«ãªã£ã¦ã„ã‚‹ã“ã¨ã«æ°—ä»˜ãã¾ã—ãŸã€‚ ã—ã‹ã—ã€ãƒ–ãƒ©ã‚¦ã‚¶ã®URLæ¬„ã«ç›´æŽ¥ãƒ‡ãƒ¼ã‚¿å–å¾—ã®URLã‚’æ›¸ã„ã¦ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã‚‚ã€æ—¥æœ¬èªžã§è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ ç°¡å˜ãªã‚‚ã®ã§ãƒ†ã‚¹ãƒˆã€‚ #!/usr/bin/env perl use strict; use warnings; use utf8; use LWP::UserAgent; use URI::QueryParam; my $uri = URI->new( 'http://maps.google.com/maps/geo' ); $uri->query_form_hash( q => 'å¤§é˜ªå¸‚', output => 'xml', key => 'APIã‚ãƒ¼', ); my $ua = LWP::UserAgent->
kgbu 2009/07/11
hl,ie,oeã‚’æŒ‡å®šã—ã¦ãŠãã®ãŒç¢ºå®Ÿã ãã†

geo

http

GoogleMap

API

knowhow

bad knowhow

æ–‡å—ã‚³ãƒ¼ãƒ‰

æ—¥æœ¬èªž
ãƒªãƒ³ã‚¯
æœ¬å½“ã¯æ€–ã„æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è©± è¨˜äº‹ä¸€è¦§ | gihyo.jp
é‹å–¶å…ƒã®ãƒã‚´ Copyright Â© 2007-2024 All Rights Reserved by Gijutsu-Hyoron Co., Ltd. ãƒšãƒ¼ã‚¸å†…å®¹ã®å…¨éƒ¨ã‚ã‚‹ã„ã¯ä¸€éƒ¨ã‚’ç„¡æ–ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚’ç¦æ¢ã—ã¾ã™â ã€‚å€‹åˆ¥ã«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹è¨˜äº‹ç‰ã¯ãã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«å¾“ã„ã¾ã™ã€‚
kgbu 2009/07/07
æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è§£é‡ˆã‚’ã‚ãã‚‹èª¤å‹•ä½œã€æœªå®šç¾©å‹•ä½œã€ã‚¨ãƒ©ãƒ¼å‡¦ç†ã‚’åˆ©ç”¨ã—ãŸæ”»æ’ƒãªã©ã‚’ã¾ã¨ã‚ã¦ã‚ã‚‹ã€‚

security

knowhow

æ–‡å—ã‚³ãƒ¼ãƒ‰

browser

WAF

ã¾ã¨ã‚ã‚µã‚¤ãƒˆ

programming
ãƒªãƒ³ã‚¯
MySQL4.1 ã§ dump ãƒ•ã‚¡ã‚¤ãƒ«ãŒæ–‡å—åŒ–ã‘ã—ãŸéš›ã®å¯¾å‡¦æ³• | ãƒã‚·ãƒ£ãƒã‚°ã€‚
å…ˆæ—¥ã€ã‚·ãƒ¼ãƒ–ãƒ¬ã‚¤ãƒ³ã®ã‚µã‚¤ãƒˆã‚’ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã„ãŸã—ã¾ã—ãŸã€‚ è¦‹ãŸç›®ã®å¤‰æ›´ã‚‚ã•ã‚‹ã“ã¨ãªãŒã‚‰ã€ å†…éƒ¨çš„ã«ã¯ MT ã‚’éšæ‰€ã«çµ„ã¿è¾¼ã¿ã€ æ›´æ–°ã®ã—æ˜“ã„ã‚µã‚¤ãƒˆã¸ã¨å¤‰è²Œã‚’é‚ã’ã¾ã—ãŸã€‚ ãœã²ä¸€åº¦ã”è¨ªå•ãã ã•ã„ã€‚ãœã²ãœã²ã€‚ãœã²ã€‚ ã•ã¦ã€‚ MT ã‚’ä½¿ã†éš›ã«ã€MySQL ã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚ MySQL ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 4.1ã€‚ ã“ã“ã§ãƒ”ãƒ³ã¨ããŸæ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ãŒã€ MySQL ã® 4.1 ã¯æ–‡å—ã‚³ãƒ¼ãƒ‰é–¢ä¿‚ã§ã„ã‚ã„ã‚ã¨å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã„ã‚ã„ã‚ã¨è‹¦åŠ´ã—ãŸã®ã§ãã®æ—¨ã‚’æ›¸ãè¨˜ã—ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã•ã¾ã® DB ã¯ãã¡ã‚“ã¨è¨å®šã—ã¦ä½¿ã£ã¦ã„ã¾ã—ãŸãŒã€ è‡ªåˆ†ã®æ‰€ã® DB ã¯ç‰¹ã«ä½•ã‚‚ã›ãšãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã¾ã¾ã§ä½¿ç”¨ã—ã¦ã„ã¾ã—ãŸã€‚ MySQL ã® 4.1 ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ä½¿ç”¨ã™ã‚‹ã¨ã€ ã»ã¨ã‚“ã©å…¨ã¦ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒã€Œlatin1ã€ã¨ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ãã®çŠ¶æ…‹ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã¨ã‚ã†ã¨ mysqldump ã‚’è¡Œã†ã¨ã€ ã€Œlat
kgbu 2008/12/25
mysqldumpã§utf8ã«å¤‰æ›ã•ã‚Œã¦åŒ–ã‘ã¦ã—ã¾ã£ã¦ã‚‚ã€æˆ»ã›ã‚‹å ´åˆãŒã‚ã‚‹ã‚ˆã†ã ã€‚

mysql

bad knowhow

æ–‡å—ã‚³ãƒ¼ãƒ‰

ã„ã¾ã•ã‚‰è¨Šã‘ãªã„

ã‚ã¨ã§è©¦ã™
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
kgbu 2008/12/25
mysql

bad knowhow

æ–‡å—ã‚³ãƒ¼ãƒ‰

ã„ã¾ã•ã‚‰è¨Šã‘ãªã„
ãƒªãƒ³ã‚¯
MySQLã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ãƒ¼ã‚»ãƒƒãƒˆ - Ogawa::Memoranda
Posted by: Hirotaka Ogawa @ July 04, 2006 05:53 PM | ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’èªã¾ãªã„ç§ãŒã€ã„ã¾ã•ã‚‰MySQLã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ãƒ¼ã‚»ãƒƒãƒˆã§çµæ§‹é¢å€’ãªä½œæ¥ã‚’ã•ã›ã‚‰ã‚ŒãŸã®ã§ãã®è¨˜éŒ²ã€‚ ã‚‚ã¨ã‚‚ã¨MySQL 4.0.xã‚’ä½¿ã£ã¦ã„ãŸã€‚ ã€Œskip-character-set-client-handshakeã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒå°Žå…¥ã•ã‚ŒãŸ4.1.15ãŒå‡ºãŸã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã€4.1.15ã«ç§»è¡Œã—ãŸã€‚ ã“ã®ã¨ãã€ã€Œ--with-charset=latin1ã€ã§ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã•ã‚Œã€ã‹ã¤my.cnfãªã©ã§default-character-setã‚’ç‰¹ã«æŒ‡å®šã—ã¦ã„ãªã„MySQL 4.1.15ã§ã€4.0ã‹ã‚‰ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ãŸã€‚ã—ãŸãŒã£ã¦å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯ã€ã€ŒDEFAULT CHARSET=latin1ã€ãŒä»˜ä¸Žã•ã‚ŒãŸã€‚ ã€Œskip-character-set-client-hands
kgbu 2008/12/25
mysql

bad knowhow

æ–‡å—ã‚³ãƒ¼ãƒ‰

ã„ã¾ã•ã‚‰è¨Šã‘ãªã„

tips
ãƒªãƒ³ã‚¯
SET NAMESã¯ç¦æ¢
(Last Updated On: 2018å¹´8æœˆ13æ—¥)MySQLã«ã¯æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹ã€ŒSET NAMESã€SQLæ–‡ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆPostgreSQLã‚‚åŒæ§˜ã®SQLæ–‡ã€SET CLIENT_ENCODINGãŒã‚ã‚Šã¾ã™ï¼‰ã“ã®æ©Ÿèƒ½ã¯SQLã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰ã¯ä½¿ã£ã¦ã‚ˆã„æ©Ÿèƒ½ã§ã™ãŒã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„æ©Ÿèƒ½ã§ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«è„†å¼±ã«ãªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ Ruby on Railsã®æœ¬ã‚’èªã‚“ã§ã„ã¦ã€ActiveRecordã‚’èª¬æ˜Žã—ã¦ã„ã‚‹éƒ¨åˆ†ã«MySQLã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹å ´åˆã®ä¾‹ã¨ã—ã¦SET NAMESãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯SET NAMESã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„äº‹ã‚’å‘¨çŸ¥ã•ã›ã‚‹ã®ã¯çµæ§‹æ™‚é–“ãŒå¿…è¦ã‹ãªã¨æ€ã„ã¾ã—ãŸã€‚ PHPã‚‚5.2ã®é€”ä¸ã‹ã‚‰MySQLãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«libmysqlã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¨å®šAPIã®ãƒ©ãƒƒãƒ‘ãƒ¼é–¢æ•°ãŒ
kgbu 2008/10/02
phpãªã©ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§ã®æ–‡å—encodingã¨ã€ï¼¤ï¼¢ã®æ–‡å—encodingã®ä¸æ•´åˆã‚’å¼•ãèµ·ã“ã™ã‹ã‚‰ãƒ€ãƒ¡ã€‚ä¸æ•´åˆãŒã‚ã‚‹ã¨ã€injectionæ”»æ’ƒã«å¯¾å‡¦ã—ãšã‚‰ããªã‚‹ã—ã€ç¬¬ä¸€ãƒ‡ãƒ¼ã‚¿ãŒä¸æ£ã«ãªã‚‹ã€‚æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è¨å®šã¨æ¤œå‡ºãŒåŸºæœ¬ã€‚

vulnerability

security

security hole

æ–‡å—ã‚³ãƒ¼ãƒ‰

db

WAF

php
ãƒªãƒ³ã‚¯
PalmGate
â– PalmGateã¨ã¯ PalmGateã¨ã¯ã€PalmOS5.4ä»¥é™ã®ãƒžã‚·ãƒ³ã«æ¨™æº–æè¼‰ã•ã‚ŒãŸBlazerã«ãŠã‘ã‚‹ã€ æ—¥æœ¬èªžã‚µã‚¤ãƒˆæ–‡å—åŒ–ã‘å•é¡Œã‚’è§£æ±ºã™ã‚‹ç‚ºã®æ–‡å—ã‚³ãƒ¼ãƒ‰å¤‰æ›ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ æœ¬ã‚µãƒ¼ãƒ“ã‚¹ã¯PalmOSç«¯æœ«ã«ç‰¹åŒ–ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚Šã€è©²å½“æ©Ÿç¨®ã‚’ãŠæŒã¡ã®Palmãƒ¦ãƒ¼ã‚¶ã®æ–¹ãªã‚‰ã€ã©ãªãŸæ§˜ã§ã‚‚ç„¡æ–™ã§ã”åˆ©ç”¨é ‚ã‘ã¾ã™ã€‚ â– PalmGateã‚¢ãƒ—ãƒªã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« PalmGateã‚’ã”åˆ©ç”¨é ‚ãã«ã¯ã€ãƒžã‚·ãƒ³æœ¬ä½“ã«PalmGateã‚¢ãƒ—ãƒªã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ PalmGateã‚¢ãƒ—ãƒªã¯ã€ä»¥ä¸‹ã‚ˆã‚Šãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€è§£å‡å¾Œãƒžã‚·ãƒ³æœ¬ä½“ã¸å°Žå…¥ã—ã¦ãã ã•ã„ã€‚ æœ¬ã‚¢ãƒ—ãƒªã«ã‚ˆã‚Šç«¯æœ«ã‚’PalmOSã«é™å®šã™ã‚‹äº‹ã§ã€ã‚µãƒ¼ãƒãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŠ‘ãˆã€å¿«é©ã«ã”åˆ©ç”¨é ‚ã‘ã‚‹ã‚ˆã†é…æ…®ã„ãŸã—ã¾ã—ãŸã€‚ â– ãƒ‘ã‚¹ãƒãƒ¼ãƒˆã®å–å¾— PalmGateã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯ãƒ‘ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ã§ã™ã€‚ PalmGateã‚¢ãƒ—ãƒªã‚’èµ·å‹•ã—ã¦é ‚ãã¾ã™ã¨ã€ã¾ãšä»¥ä¸‹
kgbu 2007/08/07
æ–‡å—å¤‰æ›ãƒ—ãƒã‚ã‚·ã‚µãƒ¼ãƒ“ã‚¹ã€‚Palmç«¯æœ«é™å®šã‚µãƒ¼ãƒ“ã‚¹ã¨ã„ã†ã¨ã“ã‚ãŒæ³£ã‹ã›ã‚‹ã€‚

palm

proxy

æ–‡å—ã‚³ãƒ¼ãƒ‰

mobile
ãƒªãƒ³ã‚¯
1