[B! linux][db] daikichi_blueã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

daikichi_blue id:daikichi_blue

linuxã¨dbã«é–¢ã™ã‚‹daikichi_blueã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

pam-mysqlã‚’ä½¿ã£ã¦ä»®æƒ³FTPã‚µãƒ¼ãƒã‚’æ§‹ç¯‰ã™ã‚‹ | OSDN Magazine
ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æŒã¤ä»®æƒ³FTPï¼ˆFile Transfer Protocolï¼‰ã‚µãƒ¼ãƒã‚’æ§‹ç¯‰ã™ã‚‹ã“ã¨ã«ã¯å¤šãã®åˆ©ç‚¹ãŒã‚ã‚‹ã€‚ä¾‹ãˆã°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦å¤§é‡ã®ãƒ¦ãƒ¼ã‚¶æƒ…å ±ã‚’ä¸€ç®‡æ‰€ã«ã¾ã¨ã‚ã¦ä¿å˜ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ç®¡ç†ãŒæ¥½ã«ãªã‚‹ã€‚ã¾ãŸä»®æƒ³ã‚µãƒ¼ãƒã®ãƒ¦ãƒ¼ã‚¶ã¯FTPã‚µãƒ¼ãƒã®ãƒªã‚½ãƒ¼ã‚¹ã®ã¿ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§OSã®ãƒªã‚½ãƒ¼ã‚¹ã«ã¯ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ãŸã‚ã€å¾“æ¥ã®Unix OSã®ãƒ¦ãƒ¼ã‚¶èªè¨¼æ–¹æ³•ã‚ˆã‚Šã‚‚ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’é«˜ã‚ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã€‚ã•ã‚‰ã«ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç°¡å˜ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«/è¨å®š/ç®¡ç†ã™ã‚‹ãŸã‚ã®æ•°å¤šãã®ã‚¦ã‚§ãƒ–ãƒ„ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã€‚ã¾ãŸä»®æƒ³FTPã‚µãƒ¼ãƒã¯FTPè‡ªä½“ãŒã‚µãƒãƒ¼ãƒˆã—ã¦ã„ãªã„ã€Œ@ã€ã‚’å«ã‚€ã„ãã¤ã‹ã®ç‰¹æ®Šæ–‡å—ã‚‚ã‚µãƒãƒ¼ãƒˆã™ã‚‹ã®ã§ã€ä¾‹ãˆã°ç¤¾å“¡ã®é›»åãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’ãƒ¦ãƒ¼ã‚¶èªè¨¼ã«ä½¿ç”¨ã™ã‚‹å ´åˆãªã©ã«ä¾¿åˆ©ã ã€‚ pam-mysqlã¯åºƒãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹PAMï¼ˆPluggable Au
daikichi_blue 2008/02/26
linux

service

ftp

db

ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸

é€šä¿¡
ãƒªãƒ³ã‚¯
PostgreSQLã¸ã‚»ã‚ãƒ¥ã‚¢ã«æŽ¥ç¶šã™ã‚‹æ–¹æ³• - builder by ZDNet Japan
ã‚‚ã®ã¥ãã‚Šç¾å ´ã®æƒ…å ±ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ ã‚¤ãƒ³ãƒ€ã‚¹ãƒˆãƒªãƒ¼4.0ã¯è£½é€ æ¥ã®å¤‰é©æœŸ å·¥å ´ã®ãƒ‡ã‚¸ã‚¿ãƒ«åŒ–ã«ã‚ˆã‚‹ãƒªã‚¹ã‚¯ã¸ã®å¯¾å¿œ ç¾å ´ã®ãŸã‚ã®æ¥å‹™ã‚«ã‚¤ã‚¼ãƒ³ 30å¹´ä»¥ä¸Šã®æ´å²ã‚’ã‚‚ã¤DXãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ é€²åŒ–ã‚’ç¶šã‘ã‚‹Notes/Dominoã®ã„ã¾ ãƒ‡ã‚¸ã‚¿ãƒ«æ™‚ä»£ã®ITã‚¤ãƒ³ãƒ•ãƒ©æ§‹ç¯‰è¡“ ä»®æƒ³åŒ–çµ±åˆã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚’çµŒã¦ä»Šã€Œãƒžãƒ«ãƒã€ã¸ ITã‚¤ãƒ³ãƒ•ãƒ©ã®æœ€é©åŒ–ã¨ç¶™ç¶šçš„é€²åŒ–ã¸ã®é“ç‹ ã¿ã‚“ãªãŒä½¿ã†MySQLã®ä¼æ¥æ´»ç”¨ ãªãœæœ‰å„Ÿã‚µãƒãƒ¼ãƒˆãŒã‚ã£ãŸã»ã†ãŒè‰¯ã„ã®ã‹ï¼Ÿ æœ‰åãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ä¼æ¥ã‚‚Oracleã«é ¼ã‚€ç†ç”± å†…é–£å®˜æˆ¿ã‚„ãƒ©ãƒƒã‚¯ãŒç™»å£‡ ã‚¼ãƒãƒˆãƒ©ã‚¹ãƒˆãŒå®˜æ°‘ä¸€ä½“ã§ ã‚µã‚¤ãƒãƒ¼ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’å®šç¾©ã™ã‚‹ AI/IoTã®æ™‚ä»£ã‚’è¦‹æ®ãˆãŸæŒ‘æˆ¦ ãƒ‡ãƒ«ãƒ»ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ã‚º PowerEdge ã‚·ãƒªãƒ¼ã‚º ãã®è¨è¨ˆæ€æƒ³ã¨ç‰¹é•·ã«è¿«ã‚‹ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¢ãƒ€ãƒŠã‚¤ã‚º æ±‚ã‚ã‚‰ã‚Œã¦ã„ã‚‹èƒŒæ™¯ã«ã‚ã‚‹ãƒ“ã‚¸ãƒã‚¹ã®ä»Š ãã—ã¦ã€æˆåŠŸã®éµã‚’æ¡ã‚‹DevOpsã®çœŸã®æ„å‘³ ç‰¹é›†ï¼šITæœ€é©åŒ–ã¸ã®é“ æˆåŠŸã®
daikichi_blue 2008/01/30
db

linux

ã‚ã¨ã§èªã‚€

server

security

ä»•æ§˜

å‚è€ƒ

é€šä¿¡
ãƒªãƒ³ã‚¯
mysqlã‚³ãƒžãƒ³ãƒ‰ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ã‹ã‚«ãƒ©ãƒ åã®è£œå®Œ(completion)ã‚’ã™ã‚‹æ–¹æ³• - (ã²)ãƒ¡ãƒ¢
è¿½è¨˜: rehash(auto-rehashã‚‚å«ã‚€)ã™ã‚‹ã¨ã€SQLæ–‡ã®è£œå®Œ(seleã§ã‚¿ãƒ–æ‰“éµã¨ã‹)ãŒåŠ¹ã‹ãªããªã‚‹ã‚ˆã¨ã€ã¯ã™å‘ã‹ã„ã®äººã«æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ å€‹äººçš„ã«ã¯ã€SQLã¯ã€Œmysql> help selectã€ã¨ã‹ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ˜ãƒ«ãƒ—ãŒã³ã‚‡ã£ã¨å‡ºã‚‹ã®ã§ã€ã‚¹ã‚ãƒ¼ãƒžã®è£œå®ŒãŒã§ãã‚‹ã‚“ãªã‚‰SQLã®è£œå®Œã¯ã¨ã‚Šã‚ãˆãšã‚ãã‚‰ã‚ã¦ã‚‚ã„ã„ã‹ãªã¨æ€ã£ã¦ã„ã¾ã™ã€‚ å¸¸ã€…ã€ãƒ†ãƒ¼ãƒ–ãƒ«åã¨ã‹è£œå®Œã§ãã‚‹ã¨ã„ã„ãªãƒ¼ã¨æ€ã£ã¦ã„ãŸã®ã§ã€ãƒœãƒã£ã¨ãã„ã¦ã¿ãŸã‚‰æ•™ãˆã¦ã‚‚ã‚‰ã„ã¾ã—ãŸã€‚ã‚ã–ãƒ¼ãƒ¼ãƒ¼ãƒ¼ã£ã™ï¼ id:mikihoshi++ id:tokuhirom++ id:precuredaisuki++ ãŠã‹ã’ã§åŠ¹çŽ‡ãŒ300%ä¸ŠãŒã‚Šã¾ã—ãŸã€‚(Benchmark::Stopwatchã§è¨ˆæ¸¬) http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option
daikichi_blue 2008/01/22
db

linux

tips

ã“ã‚Œã¯ä¾¿åˆ©

ä»•æ§˜
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®å¤‰æ›´ - ã‚·ãƒªã‚³ãƒ³ã®è°·ã®ã‚¾ãƒ³ãƒ“
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æŒ¿å…¥ãŒæ¢ã¾ã£ãŸï¼Ÿ ã¨æ€ã„ãã‚„ï¼Œä¿å˜å…ˆã®/varãŒã„ã£ã±ã„ã«ãªã£ã¦ã—ã¾ã£ãŸã¨ã„ã†ã‚ªãƒ FreeBSDã§ã¯Portsã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§/var/db/mysqlã«è¨å®šã•ã‚Œã‚‹ï¼Ž /varã¯ãƒã‚°ç”¨ï¼Œã¨æ€ã£ã¦å®¹é‡ã‚’å‰²ã‚Šå½“ã¦ã¦ã„ã‚‹ãŸã‚ï¼Œã‚ã£ã¨ã„ã†é–“ã«ã„ã£ã±ã„ã«ãªã£ã¦ã—ã¾ã†ï¼Ž å¤‰æ›´ã™ã‚‹æ–¹æ³• mysqldã‚’æ¢ã‚ã‚‹ # mysqladmin -p shutdown æ–°ã—ããƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œæˆã—ï¼Œ/var/db/mysqlã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ å¿µã®ãŸã‚ï¼Œå¤ã„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ãƒªãƒãƒ¼ãƒ # mkdir /usr/local/db # cp -Rp /var/db/mysql /usr/local/db/mysql # mv /var/db/mysql /var/db/mysql.old /etc/rc.confã«ä»¥ä¸‹ã®è¡Œã‚’è¿½åŠ mysql_dbdir="/usr/local/db/mysql"
daikichi_blue 2007/11/12
linux

db

tips

ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘PostgreSQLã®é«˜é€ŸåŒ–ã¨é«˜ä¿¡é ¼åŒ–ã‚’å®Ÿç¾ã™ã‚‹ã€Œpgpool-IIã€ã‚’ä½¿ã£ã¦ã¿ã‚‹ (1) pgpool-IIã®æ¦‚è¦ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
pgpool-IIã®æ¦‚è¦ ã€Œpgpool-IIã€ã¨ã¯ã€PostgreSQLã®é«˜é€ŸåŒ–ã¨é«˜ä¿¡é ¼åŒ–ã‚’ç›®çš„ã¨ã—ãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§ã‚ã‚‹ã€‚pgpool-IIã¯ã€ä¸‹å›³ã®ã‚ˆã†ã«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨PostgreSQLã®é–“ã«å…¥ã‚‹å½¢(ãƒ—ãƒã‚ã‚·å½¢å¼)ã§å‹•ä½œã™ã‚‹ã€‚ãªãŠã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¯PostgreSQLã‚µãƒ¼ãƒã¸æŽ¥ç¶šã™ã‚‹ã®ã§ã¯ãªãã€pgpool-IIã¸æŽ¥ç¶šã™ã‚‹ã“ã¨ã«ãªã‚‹ã€‚ pgpool-IIã¯ç¾åœ¨ã€pgpool Development Groupã«ã‚ˆã‚Šé–‹ç™ºãŒç¶™ç¶šã•ã‚Œã¦ã„ã‚‹ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«ã¯ä¿®æ£BSDãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã‚’æŽ¡ç”¨ã—ã¦ãŠã‚Šã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã§è‡ªç”±ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯http://pgfoundry.org/projects/pgpoolã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ãªãŠã€2007å¹´10æœˆ1æ—¥ç¾åœ¨ã®pgpool-IIã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯1.2.1ã§ã‚ã‚‹ã€‚ pgpool-IIã¯ã•ã¾ã–
daikichi_blue 2007/11/08
linux

db

ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸

ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹

software
ãƒªãƒ³ã‚¯
Fake Cake Cafe MySQL åˆæœŸè¨å®š
ç®¡ç†è€…ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰è¨å®šã‚’è©¦ã¿ã‚‹ãŒã€ã•ã£ããæ‹’å¦ã•ã‚ŒãŸã€‚ # mysql -uroot ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ã§ã¯ã€MySQL ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«å‡ºãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«å¾“ã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã‚ˆã†ã€‚ã€‚ã€‚ PLEASE REM EMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdo
daikichi_blue 2007/10/24
linux

ãƒˆãƒ©ãƒ–ãƒ«

db

ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸
ãƒªãƒ³ã‚¯
Can't connect to local MySQL server through socket (ãƒšãƒ¼ã‚¸ 1) / è³ªå•ã‚³ãƒ¼ãƒŠãƒ¼ / Nucleus(JP)ãƒ•ã‚©ãƒ¼ãƒ©ãƒ
daikichi_blue 2007/10/24
linux

ãƒˆãƒ©ãƒ–ãƒ«

db
ãƒªãƒ³ã‚¯
1