ããã«ã¡ã¯ã
ãã®ã«ããŽãªãŒã®èšäºã¯ããèªäœããããã¹ãã§ãããå€ãã®äººã«ãšã£ãŠè峿·±ããã®ã«ãªããšæããŸãã
ããã¯ãxlsx-fileã䜿çšããŠPHPã§äœæ¥ããå¿
èŠããããšããäºå®ããå§ãŸããŸããããã®ãã¡ã€ã«ã¯ãå®éã«ã¯zipãšããååã«å€æŽãããŸããã ãããŠãã©ãããããããç§ã¯PHPã®åŠç¿ã®æåãããã³ããŒã奜ãã§ã¯ãªãã£ãããšãèµ·ãããŸããã ç§ã¯åœŒããŸã£ãã奜ãã§ã¯ãªãã£ãããã§ã¯ãããŸããããç§ã¯ã»ãšãã©ã®æéãšwin_userã§ãããããŸããŸãããã©ã®ããã«æ©èœããããçè§£ããèªåã§ãããèšå®ã§ããããã«ãªããŸããã ãã®ãããApache + PHP + MySQLã¯Windowsäžã§åç¬ã§æ§æãããŸããã æåã¯exeãã¡ã€ã«ãšmsiãã¡ã€ã«ã®ãã¹ãŠãé
眮ããŠãããã©ããããããzipããã±ãŒãžã«åãæ¿ããããã«confãã¡ã€ã«ãšiniãã¡ã€ã«ã§æžããŠããããšãçè§£ãå§ããŸããã ããããWindowsã®zipã¯åäœããŸããã§ããããUbuntuã§å®å
šã«åäœããŸããã ããããã®ã€ã³ã¿ãŒãããããããããšãWindowsã§ã®zipã¯éåžžã«éå±ã§ããããšãæããã«ãªããŸããã ã©ããããããã¥ã¢ã«ã«èšèŒãããŠããã¢ã¯ã·ã§ã³ãçè§£ããããPHPã§æ¢è£œã®ã¯ã©ã¹ã䜿çšãããããã®ã«ãŸã æçããŠããªãããã§ããããã¯ããã¹ãŠãã¹ã ãŒãºã§ã¯ãããŸããã
çµè«ã¯æããã§ã-ç§ãã¡ã¯Ubuntuã眮ããLAMPãæã¡äžããŠæ²ãéããŸãã Windows以å€ã®è»žã§äœæ¥ããçµéšãããããã«èŠããŸããããã€ãã®ããã«ãããã€ãã®ãããããããããŸãã ãããŠããã®å Žåãããã¯ç§ãæ¬åœã«ã奜ãããªãã®ã§ã-Windows 8ã
2ã€ã®ã·ã¹ãã ãã€ã³ã¹ããŒã«ããã®ã¯é£ãããªãããã§ãããæ¯ååèµ·åããå¿
èŠããããŸãã ãŸããã³ã³ãã¥ãŒã¿ãŒã®é»æºãåãã®ã¯å¥œãã§ã¯ãããŸãããã©ãããããã§ã¯ã¹ãªãŒãã¢ãŒããç
é¢ã§ã¯å¬ç ãæå€§ã§ãã
2çªç®ã®ãªãã·ã§ã³ã¯ãUbuntuãVirtualBoxã«ã€ã³ã¹ããŒã«ããå¿
èŠã«å¿ããŠãä»®æ³ãã·ã³ã§ãŠã£ã³ããŠãæå°åããããšã§ãã ã»ãŒå®ç§ã ãã¡ããã8ã³ã¢ã®ç
é¢ã§ã¯ãã¹ãŠåé¡ãããŸãããã第2äžä»£ã®ã³ã¢i3ãš1300 MHzã®åšæ³¢æ°ãåãããŠã«ãã©ããã¯ã§ã¯ããã¹ãŠãããã»ã©ããŸããããŸããã
ã¯ãããããŠç§ã¯çŽç²ã«èŠèŠçã«ãWindowsçšã®Sublime Textãã¯ããã«å¥œãã§ãã
ãããã£ãŠãcãªèšç»ãç»å ŽããŸããïŒ
1. VirtualBoxã«UbuntuãµãŒããŒãã€ã³ã¹ããŒã«ããŸã
2. sambaã®ãµã€ãã§ãã©ã«ããŒãæ§æãã
3. Windowsã§ã¯ãUbuntuã®ãã©ã«ããŒããããã¯ãŒã¯ãã©ã€ããšããŠæ¥ç¶ããŸã
Google Yandexã§èª¿ã¹ããšãããå¿
èŠãªæ
å ±ã¯ãã¹ãŠåãã§ããã ãããŠãäžæ¹ã§ã¯ãã¹ãŠãæ©èœãããã¹ãŠãããŸããããŸããã仿¹ã§ã¯çªç¶åã€ã³ã¹ããŒã«ãå¿
èŠã«ãªããã誰ããåãããšãããããšæãã§ãããã äžè¬çã«ãç§ã¯ãã¹ãŠã1ã€ã®èšäºã«ãŸãšããŠã人ã
ãšå
±æããããšã«ããŸããã
VirtualBoxã¯ãã§ã«ã€ã³ã¹ããŒã«ãããŠããã¯ãã§ãã äžèšã®é³å£°ä»ããŠã«ãã©ããã¯ã§äœ¿çšããä»®æ³ãã·ã³ã®æ§æã«ã€ããŠå°ã説æããŸãã
- ããã»ããµãŒ-1ã³ã¢
- RAM-512Mbãã...ã«å²ãåœãŠãŸãããã·ã³ã®èœåã«åºã¥ããŠã12Gbãããããã2Gbã䜿çšã§ããŸãã
- ããŒããã©ã€ã-80Gbã§ãã€ãããã¯ã«ããŸãã
- ãããŠããããã¯ãŒã¯ã®ããã«ç§ã¯æ¬¡ãéžæããŸãã

ã€ã³ã¹ããŒã«ã«ã¯ãUbuntu-server 13.04ãéžæããŸããã ã€ã³ã¹ããŒã«ã¯æšæºã§ããããã€ãã®ç¹ã«ã®ã¿çŠç¹ãåœãŠãŸãã

ãã£ã¹ã¯ã¯ããã«LVMãšããŠæ§æãããŸããã å°æ¥ã容éãå¢ããå¿
èŠãããå Žåããã®ãªãã·ã§ã³ã¯éåžžã«äŸ¿å©ã§ãã
åŸã§æåã§æ§æããªãããã«ãå¿
èŠãªã³ã³ããŒãã³ããããã«éžæããŸãã

ããã§ãç§ãã¡ã¯åããŠã·ã¹ãã ã«å
¥ããŸããã æåã®ç»é¢ã§ã¯ãã·ã¹ãã ãåä¿¡ããIPã«èå³ããããŸãã

ç§ã®å Žåã192.168.31.111ã§ãã
ããã§ã
SSHã¯ã©ã€ã¢ã³ããå®è¡ããŠãæ°ããã€ã³ã¹ããŒã«ããã·ã¹ãã ã«æ¥ç¶
ã§ããŸã ã ä»åŸã®äœæ¥ã¯ãã¹ãŠSSHã§è¡ãããŸãã
æåã«ãæŽæ°ã確èªããŸãã
sudo apt-get update sudo apt-get upgrade
質åã«æ©ããŸã§ããã¹ãŠãã¯ãããšçããŸãã
次ã«ãwebminãã€ã³ã¹ããŒã«ããŸãã debããã±ãŒãžã¯ãµã€ãããç°¡åã«ããŠã³ããŒãã§ããŸãããäŸåé¢ä¿ãæåã§ã€ã³ã¹ããŒã«ããå¿
èŠãããããäžäŸ¿ã§ããå¿
èŠãªãªããžããªãæ¥ç¶ããŸãã
ããŒãååŸããŠã€ã³ã¹ããŒã«ããŸãã
wget http://www.webmin.com/jcameron-key.asc sudo apt-key add jcameron-key.asc
ãœãŒã¹ã远å ïŒ
sudo nano /etc/apt/sources.list deb http://download.webmin.com/download/repository sarge contrib ( )
<Ctrl + Oããã³Enter>ãä¿åãã<Ctrl + X>ãçµäºããŸãã
æŽæ°ãããïŒ
sudo apt-get update
ãããŠã€ã³ã¹ããŒã«ïŒ
sudo apt-get install webmin
ã€ã³ã¹ããŒã«èªäœããã¹ãŠã®äŸåé¢ä¿ãåŒãäžããŸããåæããã ãã§ãã
ã€ã³ã¹ããŒã«ãæåããWindowsãã©ãŠã¶ãŒã§ãµãŒããŒãéãããšãã§ããããã«ãªããŸããã ã¢ãã¬ã¹ããŒã«192.168.31.111:10000ãšå
¥åããŸãã ãã©ãŠã¶ã¯ãå®å
šãªæ¥ç¶ïŒhttpsïŒã«è»¢éããŸãã




ãããŠãã°ã€ã³/ãã¹ã¯ãŒãå
¥åããŒãžã«è¡ããŸãã

SSHã«æ»ããŸãã ããã§ãããšãã°pure-ftpdãªã©ã®ftpãµãŒããŒãã€ã³ã¹ããŒã«ã§ããŸãã
sudo apt-get install pure-ftpd
ãã©ãŠã¶ã§å
¥åãããš
192.168.31.111
192.168.31.111
ããã°ã€ã³/ãã¹ã¯ãŒãèŠæ±ã®ãŠã£ã³ããŠã衚瀺ãããŸãã

䜿çšã§ããftpãµãŒããŒã¯ããã ãã§ãã

å®éããã§ã«PHPã§ããã°ã©ãã³ã°ãéå§ã§ããŸãããæ¯åFTPçµç±ã§ãã¡ã€ã«ãã¢ããããŒãããããšã¯ããŸã䟿å©ã§ã¯ãããŸããã
ãããã£ãŠãSambaãµãŒããŒãã»ããã¢ãããããã©ã«ããŒãubuntuããWindowsãã·ã³ã«éåžžã®ãããã¯ãŒã¯ãã©ã€ããšããŠæ¥ç¶ããããšããå§ãããŸãã webminã«å
¥ãããµãŒããŒ-> Samba Windowsãã¡ã€ã«å
±æãéããŸãã

Windowsãããã¯ãŒã¯ãéžæããŸãã

ãã£ãŒã«ãã«å
¥åããŸãã
- ã¯ãŒã¯ã°ã«ãŒã
- ãµãŒããŒå-ãã®ååã«ãããã³ã³ãã¥ãŒã¿ãŒã¯Windowsãããã¯ãŒã¯ã«è¡šç€ºãããŸã
- ã»ãã¥ãªãã£ã¯ã»ãã¥ãªãã£ã¬ãã«ã§ããããŠãŒã¶ãŒã¬ãã«ã«èšå®ããŸã

ä¿åããŸããã
次ã«ã[æ°ãããã¡ã€ã«å
±æã®äœæ]ãªã³ã¯ãã¯ãªãã¯ããŠãæ°ãããã¡ã€ã«ãªãœãŒã¹ãäœæããŸãã

ããã§ã次ã®ãã£ãŒã«ãã«å
¥åããå¿
èŠããããŸãã
- å
±æå-ããã¯ãããã¯ãŒã¯ãã©ã«ããŒã®ååã«ãªããŸã
- å
±æãããã£ã¬ã¯ããª-å
±æãããã£ã¬ã¯ããªãå
¥åããŸã
- æš©éã§äœæ-æš©éã®ã¬ãã«ãèšå®ããŸãããŸã æ°ã«ããã«æå€§ã¬ãã«ïŒ777ïŒãèšå®ããããšããå§ãããŸã
- Browseable-yesã«èšå®ãããšãå
±æãªãœãŒã¹ã衚瀺ã§ããããã«ãªããŸããããããªããšããã©ã«ããŒãžã®ãã¹ããã³ãã«ã§æå®ããå¿
èŠããããŸãïŒ\\ samba \ãµã€ããªã©ïŒã

[äœæ]ãã¿ã³ãã¯ãªãã¯ããŸãã
ãªãœãŒã¹ã®ãªã¹ãã§ãæ°ããäœæãããã®ãéžæããŸãã

[ã»ãã¥ãªãã£ãšã¢ã¯ã»ã¹å¶åŸ¡]ãéžæããŸãã

æžã蟌ã¿å¯èœãªãã©ã¡ãŒã¿ãŒ-yesã«èšå®ããŸããããã«ãããããŒã«ã«ãã¡ã€ã«ãæžã蟌ãããšãã§ããŸãã

ä¿åããŸãã
[ãµãŒããŒ]-> [Samba Windowsãã¡ã€ã«å
±æ]ã«æ»ãã[SambaãµãŒããŒã®åèµ·å]ãã¯ãªãã¯ããŸãã

ãããã¯ãŒã¯ãã©ã€ãã䜿çšã§ããŸãã
<Win + E>ãšã¯ã¹ãããŒã©ãŒãéãã
ãããã¯ãŒã¯æ¥ç¶ãéžæã
ãŸã ã

ãµãŒããŒãéžæããŠãã ããã

å
±æãã©ã«ããŒãéžæããŸãã

ã·ã¹ãã ã¯ãŠãŒã¶ãŒå/ãã¹ã¯ãŒããèŠæ±ããŸãã ãããã玹ä»ããŸããã·ã¹ãã ãç§ãã¡ãèšæ¶ããåæ§ã®è³ªåã§ç§ãã¡ãèŠãããªãããã«ãããã¯ã¹ããã§ãã¯ããããšãå¿ããªãã§ãã ããã

ããã§çµããå¯èœæ§ããããŸãããWindowsã§ã¯ãååã§ãã£ã¹ã¯ã«ã¢ã¯ã»ã¹ããã®ãäžè¬çã§ãããã®ãããã¹ãããã«æ»ããŸãããã

次ã«ãå³ãã¿ã³ã§ãããã¯ãŒã¯ãã©ã«ããéžæããŸãã 衚瀺ããããªã¹ããããããããã¯ãŒã¯ãã©ã€ããæ¥ç¶ããããéžæããŸãã

ããã©ã«ãã§ã¯ãã·ã¹ãã ã¯ã¢ã«ãã¡ãããã®æåŸããæåã®ç¡æã®æåãæäŸããŸãããããŒã«ã«ãã©ã€ããæã€ãã®ãé€ãã奜ããªãã®ãéžæã§ããŸãïŒãã ãããªã¹ãã«ã¯å«ãŸããŸããïŒã ãã®æåãAãããããŸãã

ãããã£ãŠãExplorer <Ctrl + E>ãå床éããšããã£ã¹ã¯ãæåã®ãªã¹ããmy computerãã«è¡šç€ºãããæåã衚瀺ãããŸãã

ããã§ããã©ã«ãã¯ãã¹ãŠã®ããã°ã©ã ã§éåžžã®ããŒããã©ã€ããšããŠäœ¿çšã§ããããã«ãªããŸãã
ããã ãã¹ãŠã¯æ©èœããŸããããµã€ãäžã®ãã¡ã€ã«ã¯ã©ãã«ãããŸããïŒ ããã¯ãèšäºã®æåŸã®éšåã§ä¿®æ£ããŸãã
ãŸããphpMyAdminãã€ã³ã¹ããŒã«ããŸãã ãããè¡ãã«ã¯2ã€ã®æ¹æ³ããããŸãã
2çªç®ã®æ¹æ³ã§ã€ã³ã¹ããŒã«ããŸãã ãµã€ãã ãããè¡ãã«ã¯ããŸã ãŠã£ã³ããŠã«ããéã«ãªã³ã¯ãã¯ãªãã¯ããŸã
www.phpmyadmin.net/home_page/index.php
www.phpmyadmin.net/home_page/index.php
ããææ°ããŒãžã§ã³ïŒ
4.0.4.1 ïŒãããŠã³ããŒãããŸãã æ¬¡ã«ããããã¯ãŒã¯ãã©ã€ãã«ç§»åããããŠã³ããŒãããã¢ãŒã«ã€ããè§£åããŸãã 䟿å®äžããã©ã«ããŒã®ååã
phpmyadminãªã©ã®çãååã«å€æŽããããšããå§ãããŸãã
SSHã«æ»ãæãæ¥ãŸããã
sudo nano /etc/apache2/sites-available/phpmyadmin.dev
ããã¹ããšãã£ã¿ãŒã§ç©ºçœã®ã·ãŒããéããŸããã ç§ãã¡ã¯ããã«ä»¥äžãæžããŸãïŒ
<VirtualHost *:80> ServerName phpmyadmin.dev ServerAlias www.phpmyadmin.dev DocumentRoot /home/%USER%/phpmyadmin </VirtualHost>
ããã§ãïŒ
USERïŒ
ã¯ãŠãŒã¶ãŒåã«çœ®ãæãããã
phpmyadmin.devã¯æ°ãããµã€ãã®ååã§ãããå®éã«ã¯phpmyadminãæ©èœããŸãã åœç¶ããµã€ãã«ã¯ä»ã®ååã䜿çšã§ããŸãã
ãã¡ã€ã«ãä¿åããŠçµäºããæ°ããäœæããããµã€ãã«ã€ããŠApacheã«éç¥ããŸãã
sudo a2ensite phpmyadmin.dev
Ubuntuã¯ãèšå®ãé©çšããããã«apacheãåèµ·åããå¿
èŠããããšèšã£ãŠããŸãã
sudo service apache2 reload
次ã«ãæ°ãããµã€ãã«ã€ããŠã·ã¹ãã ã«éç¥ããå¿
èŠããããŸãããã®ãããhostsãã¡ã€ã«ã«å€æŽãå ããŸãã
sudo nano /etc/hosts
éãããã¡ã€ã«ã®æåã®è¡ã«ã¯ãã»ãšãã©ã®å Žå衚瀺ãããŸã
127.0.0.1 localhost
è¡ã®æåŸã«ãã¹ããŒã¹ã§åºåã£ãŠãµã€ãã®ååã远å ããŸãã ãã®çµæãæåã®è¡ã¯æ¬¡ã®ããã«ãªããŸãã
127.0.0.1 localhost phpmyadmin.dev
ä¿åããŠçµäºããŸãã
ããã ãã§ã ãµã€ãã®æºåã¯æŽã£ãŠããŸããããããŸã§ã®ãšããUbuntuã ããããã«ã€ããŠç¥ã£ãŠããŸãã Windowsã®
ã»ããã¢ããã«é²ãåã« ãå¥ã®ãµã€ããããšãã°
test.devãäœæããŸãããã
ãã®ããã«ããµã€ããã£ã¬ã¯ããªãäœæããããšããå§ãããŸãã
mkdir sites
æ¢ã«test.devã«ãããŸãïŒ
mkdir sites/test.dev
phpmyadminã®æé ãç¹°ãè¿ããŸãïŒ
phpmyadminã®ã¿ã
test.devã«çœ®ãæã
ãŸã ïŒã
sudo nano /etc/apache2/sites-available/test.dev
<VirtualHost *:80> ServerName test.dev ServerAlias www.test.dev DocumentRoot /home/%USER%/sites/test.dev </VirtualHost>
ä¿åããŠçµäºããŸãã
sudo a2ensite test.dev sudo service apache2 reload sudo nano /etc/hosts
127.0.0.1 localhost phpmyadmin.dev test.dev
ä¿åããŠçµäºããŸãã
ãµã€ãã®ååšã«ã€ããŠãŠã£ã³ããŠã説æããã«ã¯ãhostsãã¡ã€ã«ã«ç»é²ããã ãã§ååã§ãïŒã¯ããã¯ããWindowsã«ããã®ãããªãã¡ã€ã«ããããŸãïŒã Windowsãã¡ã€ã«ã®æ§æã¯ãUbuntuã®æ§æãšãŸã£ããåãã§ãã Windows / System32 / Drivers /ãªã©ã®ãã©ã«ãã«ãããŸãã ä»»æã®ããã¹ããšãã£ã¿ã§éããŸãïŒã»ãšãã©ã®å Žåããšãã£ã¿ã¯ç®¡çè
æš©éã§éãå¿
èŠããããŸãïŒã ãããŠæ¬¡ã®è¡ã远å ããŸãã
192.168.31.111 phpmyadmin.dev test.dev
ãã¡ã€ã«ã®ä»»æã®éšåã«å
¥åã§ããŸãïŒéå§/çµäº-ããã¯ä»»æã§ãïŒã ãŸããUbuntuã«å²ãåœãŠãããŠããIPãå
¥åããå¿
èŠãããããšãå¿ããªãã§ãã ããã
ä¿åããŠéããŸãã
DNSã®æŽæ°ã¯æ®ããŸãã 管çè
ãšããŠã³ãã³ãã©ã€ã³ãéããæ¬¡ãå®è¡ããŸãã
ipconfig /flushdns
ããã ãã§ã ãã©ãŠã¶ã«æ°ãã远å ãããµã€ãåãå
¥åããŠãçµæãæ¥œãã¿ãŸãã
CNCãµããŒããæå¹ã«ããã ãã§ãããã®ãããwebminããã«ã«æ»ããŸãã
[ãµãŒããŒ]-> [Apache Webserver]ã¡ãã¥ãŒãéãã[ã°ããŒãã«æ§æ]ã¿ãã«åãæ¿ããŸãã

[Apacheã¢ãžã¥ãŒã«ã®æ§æ]ãéžæããŸã

ãããŠãæžãæãã®å察åŽã®ããã¯ã¹ããã§ãã¯ããŸã

ãã¿ã³ïŒäžïŒãã¯ãªãã¯ããŠãéžæããã¢ãžã¥ãŒã«ãæå¹ã«ããŸã
å³äžã§ãé çªã«ã¯ãªãã¯ããŸãã
- 倿Žãé©çš
- Apacheã忢

ãããŠåã³éå§ããŸã-Apacheãèµ·åããŸãã

ãããŠæåŸã«ãäœæ¥ã®å©äŸ¿æ§ã®ããã®ããã€ãã®ããªãã¯ïŒ
Denwerã¯ããã©ã«ãã§ãã©ãŠã¶ã«PHPãšã©ãŒã衚瀺ããããã«èšå®ãããŠããããããããã°ã®æ®µéã§ã¯ãããéåžžã«å¿
èŠãªæ
å ±ã§ãããããphp.iniã®èšå®ã«ç
©ããããããšã¯ãå§ãããŸãã
php_flag display_errors on php_flag display_startup_errors on
ä»ã®PHPãªãã·ã§ã³ãåãæ¹æ³ã§å«ããããšãã§ããŸãã
ãã®ãããªãµãŒããŒã¯ãå®å
šã«ããŒããããŠããªãéã匱ããŠã«ãã©ããããŒã³ã¢i3ã§ãå¿«é©ã§ãã ç§ã®ãŠã«ãã©ããã¯ã§ã¯ãphpmyadminã§äœæ¥ãããšããã»ããµã®è² è·ã5ïŒ
ã«äžæããŸãã
æ
å ±ã¯GoogleãšYandexã®èŠè«ã§åéãããŸãããããããã®ã»ãšãã©ã¯Habrã«ã€ãªãããŸããã
UPDã ãã®æç€ºã誰ã«ãšã£ãŠã圹ç«ã€å Žåã¯ãUbuntu-server 13.10ã¢ã»ã³ããªã«åé¡ãããããšãèæ
®ããŠãã ããã å°ãåŸã«ã/ç§ããããèŠã€ããå Žåãå¥ã®UPDã远å ããŸãã