masanoreã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ - ã¯ã¦ãªãƒ

masanore id:masanore

masanoreã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (291)

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

ç¤¾å“¡ã®æ„è˜æ”¹é©ã‚’å®Ÿç¾ã•ã›ã‚‹æ–¹æ³•
ï¼‘ï¼Žãªãœç¤¾å“¡ã®æ„è˜ã‚’å¤‰ãˆã‚‰ã‚Œãªã„ã®ã‹ï¼Ÿ ã‚ã‚‹è·å ´ã®ç¾å®Ÿ ä½•äº‹ã«ã‚‚å‚åŠ æ„å¿—ã‚„ãƒ¢ãƒãƒ™ãƒ¼ã‚·ãƒ§ãƒ³ã¯ãªãã€é™°ã§ä¸å¹³ä¸æº€ã‚’ã‚‚ã‚‰ã™ç¤¾å“¡ãŸã¡ã€‚èª¹è¬—ä¸å‚·ã°ã‹ã‚Šã§ã€æ…‹åº¦ã®æ‚ªã„ç¤¾å“¡ãŒã‚„ã‘ã«ç›®ã«ã¤ãã€‚ ã‚µãƒãƒ¼ãƒˆã‚„å”åŠ›ä½“åˆ¶ã‚‚ãªãã€ãŠäº’ã„ã«ä¿¡é ¼é–¢ä¿‚ãŒç”Ÿã¾ã‚Œãšã«ã€ãƒãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®æ‚ªã•ã¯ä¸ã€…æ”¹å–„ã•ã‚Œãªã„ã€‚ã ã‹ã‚‰ã€ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä¸è¶³ã‚„å”åŠ›é–¢ä¿‚ã®ã”ãŸã”ãŸã§ç¤¾å†…ã®é›°å›²æ°—ã¯æ‚ªã„ã€‚ ç„¡æ°—åŠ›ã§å…ƒæ°—ã‚‚ã‚„ã‚‹æ°—ã‚‚ãªãã€è‡ªç™ºçš„ã«è¡Œå‹•ã™ã‚‹ç¤¾å“¡ã¯ã„ãªã„ã€‚è²¬ä»»æ„Ÿã¯ãªãã€è¨€ã„è¨³ã°ã‹ã‚Šã§å•é¡Œã¯å…ˆé€ã‚Šã•ã‚Œã€é¢å€’ãã•ã„ã“ã¨ã¯ã€èª°ã‚‚ã‚„ã‚ŠãŸãŒã‚‰ãªã„ã€‚ ä¸Šå¸ãŒè¦‹ã¦ã„ã‚‹ã¨ãã«ã¯ä»•äº‹ã—ã¦ã„ã‚‹ãµã‚Šã¯ã™ã‚‹ã‘ã‚Œã©ã€è¦‹ã¦ã„ãªã„ã¨ãã«ã¯ä½•ã‚‚ã‚„ã‚‰ãªã„éƒ¨ä¸‹ã€‚ã‚¹ãƒˆãƒ¬ã‚¹ã‚’æŠ±ãˆç¶šã‘ãŸçµæžœã€ãƒ¡ãƒ³ã‚¿ãƒ«ã‚’ã‚„ã‚‰ã‚Œã¦ã—ã¾ã†ç¤¾å“¡ã‚‚ã„ã‚‹ã€‚ çµæžœã€ä½œæ¥åŠ¹çŽ‡ã¯ä¸ŠãŒã‚‰ãšã€ã‚³ã‚¹ãƒˆã¯ä¸ŠãŒã‚‹ãŒã€æˆæžœã¯å½“ç„¶ä¸ŠãŒã‚‰ãªã„ã€‚ ã‚ã‚‹ç¤¾é•·ã®æ€ã„ ä¼šç¤¾ã®é›°å›²æ°—ã‚’ã‚ˆãã—ãŸã„ã—ã€ç¤¾å“¡åŒå£«ã®äººé–“é–¢ä¿‚ã‚’è‰¯ãã—ãŸã„ã€‚ç„¡é–¢å¿ƒãªã®ã‹ã€
masanore 2017/09/28
ãƒªãƒ³ã‚¯
ITæ¥ç•Œã«ãŠã‘ã‚‹SESå¥‘ç´„ã¨ãƒ¡ãƒªãƒƒãƒˆã€ãƒ‡ãƒ¡ãƒªãƒƒãƒˆï¼ ï½žã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¼·åŒ–ã®é‡è¦æ€§ï½žï½œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†ãƒ»å·¥æ•°ç®¡ç†ã€Œã‚¯ãƒ©ã‚¦ãƒ‰ãƒã‚°ã€
ãƒ“ã‚¸ãƒã‚¹ å…¬é–‹æ—¥ 2016/06/14æœ€çµ‚æ›´æ–°æ—¥ 2016/06/14 ITæ¥ç•Œã«ãŠã‘ã‚‹SESå¥‘ç´„ã¨ãƒ¡ãƒªãƒƒãƒˆã€ãƒ‡ãƒ¡ãƒªãƒƒãƒˆï¼ ï½žã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£å¼·åŒ–ã®é‡è¦æ€§ï½ž Share ITæ¥ç•Œã§å¾“äº‹ã—ãŸçµŒé¨“ã®ã‚ã‚‹æ–¹ãªã‚‰ã€SESå¥‘ç´„ã¨ã„ã†è¨€è‘‰ã‚’ä¸€åº¦ã¯èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ æ´¾é£å¥‘ç´„ã‚„è«‹è² å¥‘ç´„ãªã©ã¨ã®åŒºåˆ¥ãŒé›£ã—ã„ç‚¹ã‚‚ã‚ã‚‹SESå¥‘ç´„ã¨ã„ã†å¥‘ç´„å½¢æ…‹ã«ã¤ã„ã¦ã€ãã®æ¦‚è¦ã‚„ã€ãƒ¡ãƒªãƒƒãƒˆã€ãƒ‡ãƒ¡ãƒªãƒƒãƒˆãªã©ã‚’ã”ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ ã„ã‚ã‚†ã‚‹ãã®äººã®æŒã¤èƒ½åŠ›ã‚„ã€å·¥æ•°ã«å¯¾ã—ã¦å¯¾ä¾¡ã‚’æ”¯æ‰•ã†SESå¥‘ç´„ã§ã™ãŒã€æŒ‡æ®å‘½ä»¤ç³»çµ±ãŒè«‹è² ã¨ã¯ç•°ãªã‚‹ãŸã‚ã€ç®¡ç†æ‰‹æ³•ã‚’é–“é•ãˆã‚‹ã¨å½è£…è«‹è² ãªã©ã®ç–‘å¿µã‚’æŠ±ã‹ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ SESå¥‘ç´„ã‚’è¡Œã†ä¼æ¥ã®æ‹…å½“è€…ã§ã‚ã‚Œã°ã€æ¦‚è¦ã‚’ã—ã£ã‹ã‚Šã¨ç†è§£ã—ã¦ã€ã©ã“ã‹ã‚‰ãŒã‚°ãƒ¬ãƒ¼ã‚¾ãƒ¼ãƒ³ãªã®ã‹ã‚‚é©åˆ‡ã«æŠŠæ¡ã—ã¦ãŠãã“ã¨ãŒæ±‚ã‚ã‚‰ã‚Œã‚‹ã§ã—ã‚‡ã†ã€‚ æœ¬è¨˜äº‹ã‚’å‚è€ƒã«ã€æ”¹ã‚ã¦SESå¥‘ç´„ã«ã¤ã„ã¦ã®ç†è§£ã‚’æ·±ã‚ã¦ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ 1ï¼ŽS
masanore 2017/06/02
SESå¥‘ç´„
ãƒªãƒ³ã‚¯
AppTest | Remote TestKit
ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ãƒ†ã‚¹ãƒˆæŠ€æ³•ã®ä¸ã®ã€ç¶²ç¾…åž‹ã®æŠ€æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ å‰å›žã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ãƒ†ã‚¹ãƒˆã®å°Ž [â€¦]
masanore 2017/04/27
ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ†ã‚¹ãƒˆ

ãƒ†ã‚¹ãƒˆ

ãƒ¦ãƒ‹ãƒƒãƒˆãƒ†ã‚¹ãƒˆ

Jenkins
ãƒªãƒ³ã‚¯
Windows 10ï¼šä¼æ¥å‘ã‘ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—æ–¹æ³• - ä¸–ã®ä¸ã¯ä¸æ€è°ãªã“ã¨ã ã‚‰ã‘
ä¼šç¤¾ã§Windows 10æè¼‰æ©Ÿã‚’æ–°ãŸã«è³¼å…¥ã—ã¾ã—ãŸã€‚ã©ã®ã‚ˆã†ã«ã—ã¦ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã‚’ã™ã‚‹ã¨ã„ã„ã®ã§ã—ã‚‡ã†ï¼Ÿ ä»Šå›žã¯ã€Windows 10 Proã‚’ä½¿ã£ã¦ã”ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ Windows 10ã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ä¸ã€ã€Œã“ã®PCã¯èª°ãŒæ‰€æœ‰ã—ã¦ã„ã¾ã™ã‹ï¼Ÿã€ã¨è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ï¼ˆWindows 10 Home ã¯ã€ä¸€èˆ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼å‘ã‘ã®ãƒ‘ã‚½ã‚³ãƒ³ã®ãŸã‚ã“ã®è¡¨ç¤ºãŒå‡ºã¾ã›ã‚“ã€‚ä¼æ¥ç”¨ãƒ‘ã‚½ã‚³ãƒ³ã«ã¯é©ã—ã¦ã„ã¾ã›ã‚“ã®ã§ã€Windows 10ã®ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã¯ã€Proã‚’é¸æŠžã™ã‚‹ã‚ˆã†ãŠå‹§ã‚ã—ã¾ã™ï¼‰ ã“ã®ã¨ãã€ã€Œè‡ªåˆ†ã®çµ„ç¹”ã€ã‚’é¸æŠžã—ã¾ã™ã€‚ãªãŠã€ã“ã®è¨å®šã¯å¾Œã‹ã‚‰å¤‰æ›´ã™ã‚‹ã“ã¨ãŒé›£ã—ã„ã®ã§ã€é–“é•ãˆãªã„ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚ æŽ¥ç¶šæ–¹æ³•ã‚’é¸æŠžã—ã¾ã™ã€‚ ãã‚Œãžã‚Œã€é¸æŠžã™ã‚‹ã¨èª¬æ˜Žæ–‡ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ Azure ADã«å‚åŠ ã™ã‚‹ï¼šæ‰€å±žçµ„ç¹”ãŒOffice 365 ã¾ãŸã¯ Microsoft ã®ä»–ã®ãƒ“ã‚¸ãƒã‚¹ ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã¯ã€ã“ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’é¸
masanore 2017/02/27
Windows10
ãƒªãƒ³ã‚¯
Qt ã«ã‚ˆã‚‹ GUI ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆ
Qt ã¨ã¯ã€ã‚¯ãƒã‚¹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãª C++ ãƒ„ãƒ¼ãƒ«ã‚ãƒƒãƒˆã§ã™ã€‚Google Earth ã‚„ Operaã€KDE ãªã©ã§åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€Qt Designer ã‚’ç”¨ã„ãŸã€GUI ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½œæˆæ–¹æ³•ã«ã¤ã„ã¦ç°¡å˜ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã“ã“ã§æ‰±ã£ã¦ã„ã‚‹ã®ã¯ã€Qt 4.1 ã§ã™ã€‚Qt 3 ã¨ Qt 4 ã¨ã¯ã‚½ãƒ¼ã‚¹äº’æ›æ€§ãŒãªã„ãŸã‚ã€Qt 3 ã®ã‚³ãƒ¼ãƒ‰ã¯ãã®ã¾ã¾ã§ã¯ä½¿ãˆã¾ã›ã‚“ã€‚qt3to4 ã‚„ uic3 ãªã©ã®ãƒ„ãƒ¼ãƒ«ã¯ã‚ã‚‹ã‚‚ã®ã®åˆ¶ç´„ãŒã‚ã‚Šã€ã©ã†ã—ã¦ã‚‚æ‰‹å‹•ã§ Qt 4 ç”¨ã«ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãç›´ã™éƒ¨åˆ†ãŒå‡ºã¦ãã¾ã™ã€‚ï¼ˆå‚è€ƒï¼šPorting to Qt 4ï¼‰ ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€èƒŒæ™¯è‰²ãŒé»’ã„éƒ¨åˆ†ã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰ã®å…¥åŠ›ã‚’æ„å‘³ã—ã¾ã™ã€‚ã¾ãŸã€å„å…¥åŠ›ã«å¯¾ã™ã‚‹èª¬æ˜Žã‚’ä¸‹ã«æ›¸ãã€å„æ®µéšŽã§å˜åœ¨ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚’åˆ—æŒ™ã—ã¾ã—ãŸã€‚ ã¾ãšã€Qt Designer ã§ ui ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ã“ã“ã§ã¯ã€ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã«
masanore 2017/01/31
qt

windows
ãƒªãƒ³ã‚¯
CentOSã§Qtã®ç’°å¢ƒã‚’ä½œã£ã¦ã¿ã‚‹Â |Â ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãƒ»è‡ªå®…ã‚µãƒ¼ãƒãƒ¼è¨å®šãƒ»æ§‹ç¯‰ã®ãƒ’ãƒ³ãƒˆ
CentOSã§Qtã®ç’°å¢ƒã‚’ä½œã£ã¦ã¿ã‚‹
masanore 2017/01/31
qt

CentOS

centos
ãƒªãƒ³ã‚¯
TCPViewãƒ„ãƒ¼ãƒ«ã§ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã®é€šä¿¡çŠ¶æ…‹ã‚’ãƒ¢ãƒ‹ã‚¿ã™ã‚‹ ï¼ ï¼ IT
ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã§ã¯ã€é€šä¿¡çŠ¶æ…‹ï¼ˆç‰¹ã«TCPã®é€šä¿¡çŠ¶æ…‹ï¼‰ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒã‚ˆãè¡Œã‚ã‚Œã‚‹ã€‚ç›®çš„ã®ã‚µãƒ¼ãƒã‚„ã‚µãƒ¼ãƒ“ã‚¹ã¨æ£ã—ãé€šä¿¡ã§ãã¦ã„ã‚‹ã‹ã©ã†ã‹ã‚’èª¿æŸ»ã™ã‚‹ãŸã‚ã ã€‚ã‚³ãƒžãƒ³ãƒ‰ãƒ»ãƒ—ãƒãƒ³ãƒ—ãƒˆä¸Šã§netstatã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€TCPã®é€šä¿¡çŠ¶æ…‹ã®ã»ã‹ã€ä¾‹ãˆã°æŽ¥ç¶šè¦æ±‚ãŒæ‹’å¦ã•ã‚Œã¦ã„ã‚‹ã¨ã‹ï¼ˆSYN_SENTã§æ¢ã¾ã£ã¦ã„ã‚‹ï¼‰ã€ã™ãã«æŽ¥ç¶šãŒçµ‚äº†ã—ã¦ã—ã¾ã£ã¦ã„ã‚‹ï¼ˆCLOSE_WAITã‚„TIME_WAITã§æ¢ã¾ã£ã¦ã„ã‚‹ï¼‰ã€ãªã©ã®çŠ¶æ³ãŒç¢ºèªã§ãã‚‹ï¼ˆTIPSã€Œnetstatã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã„ã“ãªã™ã€å‚ç…§ï¼‰ã€‚ netstatã¯ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã«ã¯å¿…é ˆã®åŸºæœ¬ãƒ„ãƒ¼ãƒ«ã ãŒã€ã‚³ãƒžãƒ³ãƒ‰ãƒ»ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã—ã‹åˆ©ç”¨ã§ããªã„ã®ã§ã€GUIæ“ä½œã«æ…£ã‚ŒãŸç®¡ç†è€…ã«ã¨ã£ã¦ã¯ã‚„ã‚„ä½¿ã„ã¥ã‚‰ã„ã‹ã‚‚ã—ã‚Œãªã„ã€‚ã“ã®ã‚ˆã†ãªå ´åˆã¯ã€Sysinternalsã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹TCPViewãƒ„ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ã¨ã‚ˆã„ã€‚æ©Ÿèƒ½çš„ã«ã¯ã»ã¼netst
masanore 2017/01/31
ãƒ„ãƒ¼ãƒ«

Tool

Windows

TCPView
ãƒªãƒ³ã‚¯
ã‚³ãƒ©ãƒ |å°‚é–€å®¶ç´¹ä»‹ã‚µã‚¤ãƒˆã€€ãƒžã‚¤ã‚¢ãƒ‰ãƒã‚¤ã‚¶ãƒ¼.jpã€€è¬›æ¼”ãƒ»è¬›ç¾©ãƒ»åŸ·ç†ãƒ»ç›¸è«‡
masanore 2017/01/31
ä½å®…ãƒãƒ¼ãƒ³

ä½å®…

ãƒãƒ¼ãƒ³
ãƒªãƒ³ã‚¯
PMOï¼ˆãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã‚ªãƒ•ã‚£ã‚¹ï¼‰ã‚’ç”Ÿã‹ã™
æœ€è¿‘è©±é¡Œã®PMOï¼ˆãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã‚ªãƒ•ã‚£ã‚¹ï¼‰ã¨ã¯ã€ä¸€ä½“ã©ã‚“ãªå½¹å‰²ã‚’æžœãŸã™ã¹ãçµ„ç¹”ãªã®ã‹ã€‚ã“ã®ç‚¹ã‚’è¦‹å¤±ã†ã¨ã€PMOã¯ç°¡å˜ã«æ©Ÿèƒ½ä¸å…¨ã«é™¥ã£ã¦ã—ã¾ã†ã ã‚ã†ã€‚æœ¬é€£è¼‰ã¯ã€ã€Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã‚’çµ„ç¹”çš„ã«å®Ÿæ–½ã™ã‚‹ã€ã€Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒžãƒã‚¸ãƒ£ã‚’ç…©é›‘ãªç®¡ç†ä½œæ¥ã‹ã‚‰è§£æ”¾ã™ã‚‹ã€ã€Œãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®æ½¤æ»‘æ²¹ã¨ã—ã¦ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å††æ»‘ã«ã™ã‚‹ã€ã¨ã„ã£ãŸPMOã®å®Ÿå‹™ã«é–¢ã™ã‚‹çŸ¥è¦‹ã‚’ç´¹ä»‹ã—ã¦ã„ãã€‚ ç›®æ¬¡
masanore 2017/01/31
PMO

ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†

PM
ãƒªãƒ³ã‚¯
SIOS Tech. Lab - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã«ãªã‚‹æŠ€è¡“ãƒˆãƒ”ãƒƒã‚¯ã‚¹
2024-11-13 RAGã¯ã©ã®ã‚ˆã†ã«é€²åŒ–ã—ã¦ã„ã‚‹ã®ã‹ï¼ŸRAGã®ãƒ‘ãƒ©ãƒ€ã‚¤ãƒ ã¨æ”¹å–„æ‰‹æ³•ã‚’ä½“ç³»çš„ã«ã”ç´¹ä»‹ï¼
masanore 2016/09/29
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

CVE

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æƒ…å ±

security

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
SELECTæ–‡ã®ç™ºè¡Œçµæžœã‚’ã•ã‚‰ã«WHEREå¥ã«æŒ‡å®šã—ã¦SELECTã™ã‚‹ã€ã¿ãŸã„ãªã“ã¨ã¯ã§ãã¾ã™ã‹ï¼Ÿ - åˆå¿ƒè€…ã§å›°ã£ã¦ã„ã¾ã™ã€‚SEL... - Yahoo!çŸ¥æµè¢‹
SELECTæ–‡ã®ç™ºè¡Œçµæžœã‚’ã•ã‚‰ã«WHEREå¥ã«æŒ‡å®šã—ã¦SELECTã™ã‚‹ã€ã¿ãŸã„ãªã“ã¨ã¯ã§ãã¾ã™ã‹ï¼Ÿ åˆå¿ƒè€…ã§å›°ã£ã¦ã„ã¾ã™ã€‚ SELECTæ–‡ã®çµæžœã‚’WHEREå¥ã«æŒ‡å®šã—ã¦ã•ã‚‰ã«SELECTã™ã‚‹ã€ã¿ãŸã„ãªã“ã¨ã¯ã§ãã¾ã™ã‹ï¼Ÿ ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«Aã®ã‚«ãƒ©ãƒ ï¼‘ã®å€¤ï¼‰ ï¼ ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«Bã®ã‚«ãƒ©ãƒ ï¼’ã®æ¡ä»¶ã‹ã‚‰å–å¾—ã—ãŸã‚«ãƒ©ãƒ ï¼“ã®å€¤ï¼‰ select * from ãƒ†ãƒ¼ãƒ–ãƒ«A where ã‚«ãƒ©ãƒ ï¼‘= (SELECT ã‚«ãƒ©ãƒ ï¼“ FROM ãƒ†ãƒ¼ãƒ–ãƒ«B where ã‚«ãƒ©ãƒ ï¼’='aaa'ï¼‰; ã¿ãŸã„ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã§ã™ã€‚ å®œã—ããŠé¡˜ã„ã—ã¾ã™ã€‚
masanore 2016/08/22
SELECT

ãƒ†ãƒ¼ãƒ–ãƒ«

postgres
ãƒªãƒ³ã‚¯
JOINã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’SELECTã®çµæžœã‚»ãƒƒãƒˆã«ã™ã‚‹ã€‚ | MyTips
JOINã§ã‚ã¦ãŒã†ï¾ƒï½°ï¾Œï¾žï¾™ã‚’SELECTã®çµæžœï½¾ï½¯ï¾„ã«ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ SELECT * FROM [ï¾ƒï½°ï¾Œï¾žï¾™A] INNER JOIN (SELECT [é …ç›®B] FROM XX WHERE XX )AS [çµæžœï½¾ï½¯ï¾„C] ON [ï¾ƒï½°ï¾Œï¾žï¾™A].[é …ç›®C] = [çµæžœï½¾ï½¯ï¾„C].[é …ç›®B] WHERE [ï¾ƒï½°ï¾Œï¾žï¾™A].[é …ç›®D] = 'XX'
masanore 2016/08/22
postgres

SELECT

ãƒ†ãƒ¼ãƒ–ãƒ«
ãƒªãƒ³ã‚¯
PostgreSQLã§selectçµæžœã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã™ã‚‹ : ã¾ãã€ãƒ¢ã‚«ã§ã‚‚ç‰‡æ‰‹ã«ã€‚
ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰å‡ºåŠ›ã€€ï¼ˆ-A æ¡ãã‚ãˆã‚’ã—ãªã„ã€åˆ—åŒºåˆ‡ã‚Šã¯ã‚¿ãƒ–ï¼‰ $ psql db_name -c 'SELECT id FROM users;' -A -F \t psqlã‹ã‚‰å‡ºåŠ› å…¨ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å‡ºåŠ› (åˆ—åŒºåˆ‡ã‚Šã¯ã‚¿ãƒ–ï¼‰ psql# COPY table_name TO '/home/tmp/data.txt' DELIMITERS '\t'; â€»COPYã‚³ãƒžãƒ³ãƒ‰ã¯importã«ã‚‚ä½¿ãˆã‚‹ã‚ˆã†ã€‚ COPY table_name FROM ''/home/tmp/data.csv' DELIMITER ',' selectæ–‡çµæžœã‚’å‡ºåŠ› psql# \o /home/tmp/data.txtã€€ã€€ã€€ã€€â€¦å‡ºåŠ›å…ˆã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã« psql# \aã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€â€¦æ¡ãã‚ãˆã‚’ã—ãªã„ Output format is unaligned. psql# \pset fieldsep
masanore 2016/08/22
postgres

SELECT

ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›
ãƒªãƒ³ã‚¯
å†…éƒ¨çµåˆ(INNER JOINå¥)
2 ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆã—ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ã®ä¸ã§ã€æŒ‡å®šã—ãŸãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ ã®å€¤ãŒä¸€è‡´ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã ã‘ã‚’å–å¾—ã™ã‚‹æ–¹æ³•ãŒå†…éƒ¨çµåˆã§ã™ã€‚ã“ã“ã§ã¯ SQLite ã§å†…éƒ¨çµåˆã‚’è¡Œã†ãŸã‚ã® INNER JOIN å¥ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ å†…éƒ¨çµåˆã¨ã¯ æœ€åˆã«å†…éƒ¨çµåˆã«ã¤ã„ã¦ç°¡å˜ã«èª¬æ˜Žã—ã¦ãŠãã¾ã™ã€‚å†…éƒ¨çµåˆã¨ã¯2ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã§ãã‚Œãžã‚Œçµåˆã®å¯¾è±¡ã¨ãªã‚‹ã‚«ãƒ©ãƒ ã‚’æŒ‡å®šã—ã€ãã‚Œãžã‚Œã®ã‚«ãƒ©ãƒ ã«åŒã˜å€¤ãŒæ ¼ç´ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’çµåˆã—ã¦å–å¾—ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ æ¬¡ã®å›³ã‚’è¦‹ã¦ä¸‹ã•ã„ã€‚å·¦å´ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨å³å´ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å†…éƒ¨çµåˆã—ã¾ã™ã€‚çµåˆã®å¯¾è±¡ã¨ãªã‚‹ã‚«ãƒ©ãƒ ã¯å·¦å´ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã€Œéƒ¨ç½²IDã€ã€å³å´ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã€ŒIDã€ã§ã™ã€‚ã“ã®2ã¤ã®ã‚«ãƒ©ãƒ ã®å€¤ãŒåŒã˜ãƒ‡ãƒ¼ã‚¿åŒå£«ã‚’çµåˆã—å–å¾—ã—ã¾ã™ã€‚ å·¦å´ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã®ä¸ã§ã€Œéƒ¨ç½²IDã€ã‚«ãƒ©ãƒ ã®å€¤ãŒå³å´ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã€ŒIDã€ã‚«ãƒ©ãƒ ã®å€¤ã®ä¸ã«ãªã„å ´åˆã«ã¯ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ã¾ã›ã‚“ã€‚ INNER J
masanore 2016/08/22
postgres

ãƒ†ãƒ¼ãƒ–ãƒ«
ãƒªãƒ³ã‚¯
PostgreSQL ã®ã‚µãƒ¼ãƒãƒ¼å´ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’åˆ‡æ–ã™ã‚‹æ–¹æ³• - Qiita
ã‚µãƒ¼ãƒãƒ¼å´ã§ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œã‚’ä¸æ–ã™ã‚‹ã«ã¯ SIGINT ã‚’å½“è©²ãƒ—ãƒã‚»ã‚¹ï¼ˆ ps ã‚„ pg_stat_activity ã‹ã‚‰æŽ¢ã™ï¼‰ã«é€ã‚Šã¾ã™ï¼ˆkill -INT PIDï¼‰ãŒã€ã“ã‚Œã§ã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯åˆ‡æ–ã•ã‚Œã¾ã›ã‚“ã€‚ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãªã©ã§åˆ‡æ–ã—ã¦æ¬²ã—ã„å ´åˆã«ã¯ pg_terminate_backend(procpid) ã‚’ä½¿ã„ã¾ã™ã€‚ å½“è©²ã® PID ãŒã‚ã‹ã£ã¦ã„ã‚‹å ´åˆã«ã¯
masanore 2016/08/22
postgresql

pt-kill

åˆ‡æ–

postgres
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã«å«ã¾ã‚Œã‚‹ã‚«ãƒ©ãƒ ã®æƒ…å ±ã‚’å–å¾—
bookmark ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã¯ id ã‚«ãƒ©ãƒ ã« NOT NULL åˆ¶ç´„ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ã“ã¨ã€ãã—ã¦ name ã‚«ãƒ©ãƒ ã«ã¯ DEFAULT åˆ¶ç´„ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ã“ã¨ãŒç¢ºèªã§ãã¾ã™ã€‚ã¾ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æœ‰ç„¡ã‚‚è¡¨ç¤ºã•ã‚Œã¾ã—ãŸã€‚ -- -- ã‚¹ã‚ãƒ¼ãƒžæ¤œç´¢ãƒ‘ã‚¹ã«è¨å®šã•ã‚Œã¦ã„ã‚‹ã‚¹ã‚ãƒ¼ãƒžä»¥å¤–ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«é–¢ã—ã¦ã¯ ã‚¹ã‚ãƒ¼ãƒžå.ã‚¿ãƒ¼ãƒ–ãƒ«å ã®å½¢å¼ã§ãƒ†ãƒ¼ãƒ–ãƒ«åã‚’æŒ‡å®šã—ã¦å®Ÿè¡Œã—ã¾ã™ã€‚(ã‚¹ã‚ãƒ¼ãƒžæ¤œç´¢ãƒ‘ã‚¹ã«ã¤ã„ã¦ã¯ã€Œã‚¹ã‚ãƒ¼ãƒžæ¤œç´¢ãƒ‘ã‚¹ã‚’è¨å®šã™ã‚‹ã€ã‚’å‚ç…§ã•ã‚Œã¦ãã ã•ã„)ã€‚ ãã‚Œã§ã¯ myschema ã‚¹ã‚ãƒ¼ãƒžã®ä¸ã«ä½œæˆã—ãŸ friends ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ ã®æƒ…å ±ã‚’å–å¾—ã—ã¾ã™ã€‚ æŒ‡å®šã—ãŸã‚¹ã‚ãƒ¼ãƒžã®ä¸ã«ä½œæˆã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ æƒ…å ±ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ãŸæ™‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å–å¾—ã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ãŸæ™‚ã®å®šç¾©ã‚’ç¢ºèªã™ã‚‹ãŸã‚èª¿ã¹ãŸã„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã™ã‚‹æ™‚ã«å®Ÿè¡Œã•ã‚ŒãŸ CREATE TABLE
masanore 2016/08/22
postgres

ãƒ†ãƒ¼ãƒ–ãƒ«
ãƒªãƒ³ã‚¯
PostgreSQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆ | setup | OSS Fan
æ¦‚è¦ PostgreSQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ æ§‹æˆ ã‚µãƒ¼ãƒæ§‹æˆ OSãƒãƒ¼ã‚¸ãƒ§ãƒ³ Red Hat Enterprise Linux 5.9 x86_64 ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ä¸€è¦§ postgresql90-9.0.8-1PGDG.rhel6.x86_64.rpm postgresql90-libs-9.0.8-1PGDG.rhel6.x86_64.rpm postgresql90-server-9.0.8-1PGDG.rhel6.x86_64.rpm æ‰‹é † ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆå‰ã®ç¢ºèª ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ¦ãƒ¼ã‚¶ user1 ãŒæ‰€æœ‰è€…ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ testdb1 ã«ãƒ†ãƒ¼ãƒ–ãƒ« tbl1 ã‚’ä½œæˆã—ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã™ã‚‹å‰ã«ãƒ¡ã‚¿ã‚³ãƒžãƒ³ãƒ‰ã§ç¾çŠ¶ã®ãƒ†ãƒ¼ãƒ–ãƒ«ä¸€è¦§ã‚’ç¢ºèªã—ã¾ã™ã€‚ ã¾ã ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¦ã„ãªã„ã®ã§ã€ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ã€ã¨è¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ -bash-3.2$ psql -U user
masanore 2016/08/22
PostgreSQL

ãƒ†ãƒ¼ãƒ–ãƒ«
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹(CREATE INDEX)
PostgreSQL ã§ã¯æ–°ã—ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹ãŸã‚ã« CREATE INDEX ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ã“ã“ã§ã¯ PostgreSQL ã§æ–°ã—ã„ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚
masanore 2016/08/22
PostgreSQL

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹
ãƒªãƒ³ã‚¯
centos,bashç’°å¢ƒã§pecoã‚’å°Žå…¥ã—ã¦ã‚³ãƒžãƒ³ãƒ‰å±¥æ´ã‚’ä¾¿åˆ©ã«ã™ã‚‹ã¾ã§ã€‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
masanore 2016/08/16
centos

ä¾¿åˆ©

ã‚³ãƒžãƒ³ãƒ‰

Linux

peco
ãƒªãƒ³ã‚¯
Ordinary Least Squares regression (OLS)
masanore 2016/08/16
ç·šå½¢å›žå¸°ã€€çµ±è¨ˆè§£æžã€€è§£æž
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸