|
|
|
17Àå apache+php+mysql |
||
|
ÇÑ µ¿ ÈÆ |
1 °³¿ä
2 °¢ ÇÁ·Î±×·¥ÀÇ °£´ÜÇÑ ¼Ò°³
2-1 apache
2-2 php3
2-3 mysql
3 ¼³Ä¡
3-1 quick install outline
3-2 mysql
3-3 php3
3-4 apache
4 Å×½ºÆ®
µé¾î°¡±â¿¡ ¾Õ¼...
ÀÌ ±ÛÀº linux ¿î¿µÃ¼Á¦¿¡¼ web °ú database°¡ ¿¬µ¿ÇÏ¿© ÀÛµ¿ÇÏ´Â ¼¹ö¸¦ ±¸ÃàÇÏ´Â ³»¿ëÀ» ´Ù·é ±ÛÀÔ´Ï´Ù.
ÀÌ·¯ÇÑ ¼¹ö¸¦ ±¸ÃàÇϱâ À§Çؼ´Â ¿ì¼± web ¼¹ö¿Í db ¼¹ö°¡ ÇÊ¿äÇϰí web»ó¿¡¼ client°¡ ¿äûÇÑ ³»¿ëÀ» ó¸®ÇØÁÖ´Â ¿ÜºÎÇÁ·Î±×·¥ÀÌ ÇÊ¿äÇÕ´Ï´Ù. ÀÌ ¿ÜºÎÇÁ·Î±×·¥ÀÇ ¿ªÇÒÀ» ÇÏ´Â °ÍÀÌ php3ÀÔ´Ï´Ù. php3´Â ¼¹öÃø html¿¡ ³»Æ÷µÇ´Â ½ºÅ©¸³Æ® ¾ð¾î·Î ms»çÀÇ active server page¿Í °°ÀÌ ¼¹ö¿¡¼ ¸ðµç 󸮰¡ ÀÌ·ç¾î Áý´Ï´Ù. µû¶ó¼ °£ÆíÇÑ ÄÚµùÀ¸·Î ÈǸ¢ÇÑ db¿¬µ¿ ÇÁ·Î±×·¥À» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÆíÀÇ»ó °æ¾î´Â »ý·«ÇÒ °ÍÀÌ¸ç ³»¿ëÁß Àǹ®À̳ª À߸øµÈ ºÎºÐÀÌ ÀÖÀ¸¸é ÁÖÀúÇÏÁö ¸¶½Ã°í ¸ÞÀÏÀ» º¸³» ÁֽʽÿÀ
1 °³ ¿ä
º¸Åë ÀÎÅͳÝÀ» Ç×ÇØÇÑ´Ù´Â °ÍÀº À¥ ÆäÀÌÁö¸¦ °Ë»öÇϰí ÇÊ¿äÇÑ Á¤º¸¸¦ ã´Â °ÍÀ» ÀǹÌÇÑ´Ù. webÀº http(hypertext transfer protocol) ±Ô¾àÀ» µû¸¥´Ù. ÀÌ ÇÁ·ÎÅäÄÝÀº clientÀÇ ¿ä±¸ ¸Þ½ÃÁö¿Í serverÀÇ ÀÀ´ä¸Þ½ÃÁö¸¦ ÁÖ°í ¹Þ´Â Çü½ÄÀÌ´Ù. À̰ÍÀº º¸Åë ÅØ½ºÆ®±â¹ÝÀÇ ¹®¼¸¦ »ç¿ëÀÚÀÇ ¿äû¿¡ ´ëÇØ¼ ÀÀ´äÇÏ´Â Çü½ÄÀ¸·Î µÇ¾îÀÖ´Ù. µû¶ó¼ µ¿ÀûÀÎ ÇÁ·Î±×·¥À» web »ó¿¡¼ ½ÇÇà½Ãų¶§´Â º°µµÀÇ ¿ÜºÎ ÇÁ·Î±×·¥ÀÌ ÇÊ¿äÇÏ´Ù ¿ì¸®°¡ À¥ »ó¿¡ ÀڷḦ ¿Ã¸®°í ÀÚ½ÅÀÇ Á¤º¸¸¦ ÀÔ·ÂÇÏ°í º¯°æÇÏ´Â ÀϵéÀ̳ª ½Ç½Ã°£À¸·Î »çÀ̹ö ¼îÇÎÀ» ÇÏ´Â ÀϵîÀº ÀÌ·¯ÇÑ ±â¹Ý¿¡¼ ÀÌ·ç¾îÁø´Ù.
Áö±ÝºÎÅÍ linux ¿î¿µÃ¼Á¦¸¦ ÀÌ¿ëÇÏ¿© ¾î¶°ÇÑ ¶óÀ̼¾½º³ª ºñ¿ëÀÌ ÇÊ¿ä¾øÀÌ °·ÂÇÑ web-db ¿¬µ¿ ¼¹ö¸¦ ±¸ÃàÇÏ´Â ¹æ¹ýÀ» ¼Ò°³ ÇÑ´Ù.
À̰ÍÀ» ÀÌ¿ëÇϸé À¥»óÀÇ °¢Á¾ »ó¾÷»çÀÌÆ®³ª ¼îÇθôµîÀ» ±¸ÃàÇÒ ¼ö ÀÖ´Ù.
À¥¼¹ö·Î´Â apache ¼¹ö¸¦ »ç¿ëÇÏ°í ¼Óµµ°¡ ºü¸£±â·Î À¯¸íÇÑ mysqlÀ» db ¼¹ö·Î »ç¿ëÇÒ °ÍÀÌ´Ù. µÎ ¼¹ö°£ÀÇ ¿¬µ¿Àº web ¼¹ö¿¡ ¸ðµâ·Î ÄÄÆÄÀÏµÇ¾î °·ÂÇÑ ¼º´ÉÀ» ¹ßÈÖÇÏ´Â php3¸¦ ÀÌ¿ëÇÑ´Ù.
2 °¢ ÇÁ·Î±×·¥ÀÇ °£´ÜÇÑ ¼Ò°³
2-1 mysql
mysqlÀº sql(structured query language : ±¸Á¶Àû ÁúÀǾî) database ¼¹öÀÌ´Ù.
mysqlÀº ´ÙÀ½ÀÇ os¿¡¼ ½ÇÇà°¡´ÉÇÏ´Ù.
linux 2.0.x & 2.2.x
sco
solaris 2.x
sunos 4.x
hpux1020
bsdi 2.x
aix 4.x
freebsd 2.x & 3.x
sgi irix 6.x
dec unix 4.x
netbsd 1.3
windows 9x & nt
mysqlÀº gnu Çü½ÄÀÇ ¶óÀ̼¾½º¸¦ °¡Áö°í ÀÖÁö ¾Ê±â ¶§¹®¿¡ º¸Åë linuxÀÇ ¹èÆ÷ÆÇ¿¡´Â Æ÷ÇԵǾî ÀÖÁö ¾Ê´Ù. °ø°³¹öÀüÀº michael windenis°¡ ¸¸µé¾úÀ¸¸ç »ó¿ë¹öÀüÀº tcx datakonsulter ab ¿¡ÀÇÇØ ¹èÆ÷µÈ´Ù.
mysql ÀÇ ÀϹÝÀûÀΠƯ¡
mysqlÀÇ ±âº» ¸ñÇ¥´Â ¼Óµµ¿Í ¾ÈÁ¤¼ºÀÌ´Ù.
c, c++ ·Î ÀÛ¼ºµÇ¾ú´Ù.
c, c++, java, perl, tcl ·Î Ŭ¶óÀÌ¾ðÆ®¸¦ ¸¸µé ¼ö ÀÖ´Ù.
¸ÖƼÇÁ·Î¼¼½º¿Í smp(symmetric multiproccessor)¸¦ Áö¿øÇÑ´Ù.
mysql ÀÚüÀÇ Å×À̺í ÃÖ´ëÅ©±â´Â 4gb ÀÌ´Ù.
¹®ÀÚ¼ÂÀº ±âº»ÀûÀ¸·Î iso-8859-1 (latin 1)À» »ç¿ëÇÑ´Ù.
mysqlÀº ´Ù¸¥ µ¿±ÞÀÇ ¼¹ö¿¡ ºñÇØ µ¥ÀÌÅÍ Ã³¸®ÀÇ ¼Óµµ°¡ ¹«Ã´ ºü¸£´Ù. À̰ÍÀº Æ®¸®°Å³ª Æ®·£Á§¼Çµî ÀÏ¹Ý db¼¹öÀÇ ¸î°¡Áö Ư¡À» ±¸ÇöÇÏÁö ¾Ê¾Ò±â ¶§¹®ÀÌ´Ù. ¹°·Ð ÀÌ·¯ÇÑ °ÍÀ» ±¸ÇöÇÏÁö ¾ÊÀº ÀÌÀ¯´Â 󸮼ӵµÀÇ Çâ»óÀ» À§ÇؼÀÌ´Ù. µû¶ó¼ µ¥ÀÌÅÍÀÇ ¾ÈÁ¤¼º ¹× ¹«°á¼º Ãø¸é¿¡¼ ´Ù¸¥ »ó¿ë db ¼¹öº¸´Ù ¶³¾îÁöÁö¸¸ °ü¸®¸¸ Àß ÇÑ´Ù¸é ¸Å¿ì ¾ÈÁ¤ÀûÀ̸ç ÇÁ·Î±×·¥¿¡µµ ¿ëÀÌÇÏ´Ù°í º¼ ¼ö ÀÖ´Ù.
ÇöÀç °¡Àå ÃÖ½ÅÀÇ ¹öÀüÀ¸·Î´Â 3.22.22 °¡ ÀÖÀ¸¸ç
mysql ÀÇ °ø½Ä ȨÆäÀÌÁö´Â http://www.tcx.se ÀÌ´Ù.
2-2 php3
php´Â ¼¹öÃø html¿¡ ³»Æ÷µÇ´Â ½ºÅ©¸³Æ® ¾ð¾îÀÌ´Ù : server-side html-embedded script language. ms ÀÇ active server page ó·³ ¼¹ö¿¡¼ ¸ðµç 󸮰¡ ÀÌ·ç¾îÁö´Â ½ºÅ©¸³Æ® ¾ð¾îÀÎ php´Â apache¿Í °°Àº web ¼¹ö¿¡ ¸ðµâ·Î ÄÄÆÄÀÏ µÇ¾î »ç¿ëµÈ´Ù.
php´Â 1994³â rasmus lerdorf °¡ ÀÚ½ÅÀÇ È¨ÆäÀÌÁö¿¡ óÀ½À¸·Î ÀÛ¼ºÇÏ¿´À¸¸ç 1995³â ÃÊ ¸î °³ÀÇ ¸ÅÅ©·Îµé°ú ´ç½Ã ȨÆäÀÌÁö¿¡¼ ¸¹ÀÌ »ç¿ëµÇ´ø ¸î°¡Áö À¯Æ¿¸®Æ¼µéÀ» ÀÌÇØÇÒ ¼ö ÀÖ´Â ´Ü¼øÇÑ ÇüÅÂÀÇ ÆÄ½Ì¿£ÁøÀ¸·Î ±¸¼ºµÈ personal homepage tool ÀÌ °ø°³µÇ¸é¼ ÀϹÝÀο¡°Ô ¾Ë·ÁÁö°Ô µÇ¾ú´Ù. ÀÌÈÄ ¿©·¯ »ç¶÷µéÀÇ ¼öÁ¤À» ÅëÇØ ÀçÀÛ¼º µÇ¾úÀ¸¸ç ÇöÀç °¡Àå ÃÖ½ÅÀÇ ÆÄ¼´Â php 3.0.x ÀÌ´Ù.
php´Â c¿Í ¸Å¿ì À¯»çÇÑ ÇüŸ¦ °¡Áö°í ÀÖÀ¸¸ç ÁøÁ¤ÇÑ ÈûÀº db¿ÍÀÇ ¿¬µ¿ ºÎºÐ¿¡¼ ³ª¿Â´Ù. À̸¦ ÀÌ¿ëÇÏ¿© web ÆäÀÌÁö ³»ºÎ¿¡¼ db¸¦ ¼Õ½±°Ô ÅëÇÕÇÒ ¼ö ÀÖ´Ù.
´ÙÀ½Àº php¿Í ÇÔ²² »ç¿ëÇÒ ¼ö ÀÖ´Â database ¼¹öÀÌ´Ù.
oracle
adabas d
sybase
filepro
velocis
mysql
informix
solid
dbase
generic odbc
unix dbm
posqgresql
msql
ÇöÀç php¸¦ ÀÌ¿ëÇÑ »çÀÌÆ®°¡ ´Ã°í ÀÖÀ¸¸ç radhat linux 6.0 ¹èÆ÷ÆÇ¿¡ Æ÷ÇԵǾî ÀÖ´Ù.
phpÀÇ °ø½Ä »çÀÌÆ®´Â http://www.php.net ÀÌ´Ù.
2-3 apache
apache´Â 1995³â ncsa httpd 1.3À» ±â¹ÝÀ¸·Î ź»ýÇÏ¿´´Ù. apache ¶õ ¸»Àº ncsa httpd¿¡ ÆÐÄ¡ÆÄÀÏÀ» Á¦°øÇß´ø »ç¶÷µéÀÌ ¸ð¿© ±¸¼ºÇÑ ¾ÆÆÄÄ¡ Á¶ÇÕ¿¡¼ a patch server ÀÇ Á¶ÇÕÀ¸·Î ±¸¼ºÇÑ ¸»ÀÌ´Ù. ¾î·µç ÇöÀç apache´Â ¼¼»ó¿¡¼ °¡Àå Àß³ª°¡´Â web¼¹öÁßÀÇ Çϳª°¡ µÇ¾ú´Ù. ¹«·á·Î Á¦°øµÈ´Ù´Â °Í À̿ܿ¡µµ Áö¼ÓÀûÀÎ ÆÐÄ¡ÆÄÀÏ Á¦°ø°ú ÃÖ°íÀÇ ÆÛÆ÷¸Õ½º¸¦ ¹ßÈÖÇϰí ÀÖÀ¸¸ç ¾ÈÁ¤¼º ¶ÇÇÑ ¶Ù¾î³ª±â ¶§¹®ÀÌ´Ù. Åë°è»óÀ¸·Î´Â Àü¼¼°è web¼¹öÁßÀÇ 50%ÀÌ»óÀÌ apache¸¦ »ç¿ëÇÑ´Ù°í Çϴµ¥.. ¹Ï°Å³ª ¸»°Å³ª.
apache ¼¹ö´Â ´Ù¸¥ »ó¿ë ¼¹ö¿¡ ºñÇØ ¼º´ÉÀÌ ±×¸® ¶³¾îÁöÁö´Â ¾ÊÀ¸³ª °¡Àå Ãë¾àÇÑ Á¡À̶ó¸é ¸ÖƼ¾²·¹µå°¡ Áö¿øÀÌ ¾ÈµÈ´Ù´Â °ÍÀÌ´Ù. Àü¿¡ Á÷Á¢ ½ÇÇè(?)À» ÇØºÃ´Ù´Â ºÐÀÇ ¸»À» ºôÀÚ¸é µ¿½Ã¿¡ Á¢¼ÓÇϴ Ŭ¶óÀ̾ðÆ®ÀÇ ¼ö°¡ 500 ¿¡ À̸£¸é ¼¹ö°¡ ´Ù¿îµÈ´Ù´Â °ÍÀÌ´Ù.
¿©±â¼ µ¿½Ã¶ó´Â °ÍÀº °ÅÀÇ 0.1ÃÊÀÇ ½Ã°£³»¿¡ µ¿½ÃÁ¢¼ÓÀ» ÇÏ´Â °ÍÀ» ¸»ÇÑ´Ù. µû¶ó¼ ±× ÀÌ»óÀÇ ½ÃÂ÷¸¦ µÎ°í Á¢¼ÓÇÑ´Ù¸é ±× ÀÌ»óÀÇ ¼ýÀÚ¿¡µµ ±× ´É·ÂÀ» ÃæºÐÈ÷ ¹ßÈÖÇÑ´Ù´Â °ÍÀÌ µÈ´Ù ^^
apache ¼¹ö´Â ¿©·¯ °¡Áö ÇÁ·Î±×·¥À» ¸ðµâ·Î ÇÔ²² ÄÄÆÄÀÏ ÇÏ¿© »ç¿ëÇÒ ¼ö ÀÖ´Ù. odbc´Â ¹°·Ð javaservletÀ» »ç¿ëÇÒ ¼öµµ ÀÖ´Ù.
apache ÀÇ °ø½ÄȨÆäÀÌÁö´Â http://www.apache.org À̸ç
ÇöÀç °¡Àå ÃֽŹöÀüÀ¸·Î 1.3.6 ¹öÀüÀÌ ÀÖ´Ù.
3 ¼³ Ä¡
3-1 install outline
php3¸¦ ÀÌ¿ëÇÑ web-db ¿¬µ¿¼¹ö¸¦ ±¸ÃàÇϱâ À§Çؼ´Â ¿©·¯ °¡ÁöÀÇ ÇÁ·Î±×·¥À» ¼ø¼¿¡ ¸Â°Ô Â÷±ÙÂ÷±Ù ¼³Ä¡ÇØ ³ª°¡¾ß ÇÑ´Ù.
¸¸ÀÏ php¿¡¼ gif À̹ÌÁö¸¦ ´Ù·ç±æ ¿øÇÑ´Ù¸é gd ¶óÀ̺귯¸®¸¦ ¼³Ä¡ÇÏ¸é µÈ´Ù.
µû¶ó¼ mysql, gd, php3 apache ÀÇ ÃÑ ³×°¡Áö ÇÁ·Î±×·¥À» ¼³Ä¡ÇÏ¿©¾ß ÇÑ´Ù.
¿ì¼±, database ¼¹ö¿Í gd ¶óÀ̺귯¸®°¡ ¼³Ä¡ µÇ¾î ÀÖ¾î¾ß Çϸç php3ÀÌ database ¼¹ö¿Í gd ¶óÀ̺귯¸®, web ¼¹ö¸¦ ÀνÄÇÑ »óÅ¿¡¼ ¼³Ä¡°¡ µÇ¾î¾ß ÇÑ´Ù. ±× ´ÙÀ½ apache ¼¹ö¿¡ php3¸¦ ¸ðµâ·Î Ãß°¡ÇÏ¿© ¼³Ä¡ÇÏ¸é ¸ðµç ¼³Ä¡°¡ ¿Ï·áµÇ´Â °ÍÀÌ´Ù.
¼³Ä¡ÀÇ ¹æ¹ýÀº ¹ÙÀ̳ʸ®·Î ¼³Ä¡, radhat ÀÇ °æ¿ì rpm ¼³Ä¡ µîÀÌ ÀÖÀ¸³ª ¿©±â¼´Â ¹ÙÀ̳ʸ®³ª rpm ¼³Ä¡´Â Áö¾çÇϰí Á÷Á¢ ÄÄÆÄÀÏ ÇÏ¿© ¼³Ä¡ÇÏ´Â °ÍÀ¸·Î ¼³¸íÇϱâ·Î ÇÑ´Ù.
¾îÂ¸é Á» Áö·çÇϱ⵵ ÇÏÁö¸¸ Â÷±ÙÂ÷±Ù ^^
´ÙÀ½ÀÇ »ç¾ç¿¡¼ Å×½ºÆ® µÇ¾ú´Ù.
intel pentium ii 350
hdd 6.4 gb
128 ram
ÀÌ ¹®¼¿¡ ÀÖ´Â ¼³Ä¡ °úÁ¤Àº ´ÙÀ½ »ç¾çÀ» µû¸¥´Ù.
cyrix 6x86
hdd 1.2 gb
32 ram
quick install (¸ðµç ÀÛ¾÷Àº root ·Î ÇÑ´Ù.)
mysql ÀÇ ´Ù¿î·Îµå¿Í ¾ÐÃàÇØÁ¦
mysqlÀÇ ¼³Ä¡
gd ¶óÀ̺귯¸®ÀÇ ¼³Ä¡
apache configure
php3 ¼³Ä¡
apache ¼³Ä¡
3-2 mysql ÀÇ ¼³Ä¡
ÀÌÁ¦ºÎÅÍ º»°ÝÀûÀÎ ¼³Ä¡·Î µé¾î°£´Ù.
mysqlÀº c¿Í c++·Î Â¥¿©Á³±â ¶§¹®¿¡ gcc ÄÄÆÄÀÏ·¯¿Í ansi c++ ÄÄÆÄÀÏ·¯°¡ ÀÖ¾î¾ßÇÑ´Ù.
Ç㳪 ¸¸ÀÏ ¿©·¯ºÐÀÇ ¸®´ª½º¹Ú½º¿¡ c++ ÄÄÆÄÀÏ·¯°¡ ¾øÀ» °æ¿ì¿¡´Â gcc ÄÄÆÄÀÏ·¯¸¸ °¡Áö°íµµ ÄÄÆÄÀÏÀ» ÇÒ ¼ö ÀÖ´Ù. gcc ÄÄÆÄÀÏ·¯ÀÇ ¹öÀüÀº 2.7.x ¹öÀü¿¡¼ ¸î °¡Áö ¿À·ù°¡ ¹ß°ßµÇ±â ¶§¹®¿¡ 2.8.x ¹öÀüÀ» »ç¿ëÇÏ´Â °ÍÀÌ ÁÁ´Ù.
¿ì¼± mysql ÀÇ È¨ÆäÀÌÁöÀÎ http://www.tcx.se ¿¡ °¡¼ mysql-version.tar.gzÀ» ´Ù¿î·Îµå ¹Þ´Â´Ù. ±× ÈÄ Àû´çÇÑ µð·ºÅ丮¿¡ ¾ÐÃàµÈ ÆÄÀÏÀ» Ǭ´Ù.
'#' Àº rootÀÇ ÇÁ·ÒÇÁÆ®ÀÌ´Ù.
# tar -xvzf mysql-version.tar.gz
º¸Åë ¼Ò½ºÆÄÀϵéÀº È®ÀåÀÚ°¡ .tar.gz ÀÎ °æ¿ì¿¡ gnu tar·Î ¾ÐÃàµÈ °ÍÀ̶ó tarÀÇ ¿É¼ÇÀÎ 'x'¿Í 'z'¸¦ ÀÌ¿ëÇØ¼ ¾ÆÄ«À̺ê¿Í ¾ÐÃàÀ» µ¿½Ã¿¡ Ç® ¼ö ÀÖ´Ù.
¸¸ÀÏ ¾È Ç®¸°´Ù¸é, ´ÙÀ½ÀÇ ¸í·ÉÀ» ¼ø¼´ë·Î ½ÇÇàÇÑ´Ù.
¿ì¼± ¾ÐÃàÀ» Ǭ´Ù.
# gnuzip -dfv mysql-verion.tar.gz
´ÙÀ½¿¡ ¾ÆÄ«À̺êµÈ ÆÄÀÏÀ» Ǭ´Ù.
# tar -xvf mysql-version.tar
¸¸ÀÏ /usr/local¿¡¼ ¾ÐÃàÀ» Ç®¾ú´Ù¸é ´ÙÀ½°ú °°Àº µð·ºÅ丮°¡ »ý¼ºµÇ¾úÀ» °ÍÀÌ´Ù.
/usr/local/mysql-version
»ý¼ºµÈ µð·ºÅ丮·Î À̵¿ÇÑ´Ù.
# cd /usr/local/mysql-version
ÀÌ µð·ºÅ丮¿¡´Â ´ÙÀ½°ú °°Àº ÆÄÀÏÀÌ ÀÖÀ» °ÍÀÌ´Ù.
# ls -al [enter]
total 691
drwxr-xr-x 21 510 101 1024 jul 1 01:40 ./
drwxr-xr-x 4 root root 1024 jul 1 01:10 ../
drwxr-xr-x 3 510 104 1024 apr 29 10:25 docs/
-rw-r--r-- 1 510 101 146330 apr 25 20:24 install-source
-rw-r--r-- 1 510 101 7831 feb 7 1997 install-source-generic
-rw-r--r-- 1 505 101 0 apr 25 20:24 mirrors
-rw-r-xr-- 1 505 101 770 dec 28 1998 makefile.am*
-rw-r--r-- 1 510 104 11987 apr 29 10:25 makefile.in
-rw-r--r-- 1 510 101 10215 apr 25 20:24 public
-rw-r--r-- 1 510 101 1967 mar 13 1998 readme
-rw-r-xr-- 1 505 101 4071 apr 20 20:27 acconfig.h*
-rw-r--r-- 1 510 101 14302 nov 13 1998 acinclude.m4
-rw-r-xr-- 1 510 101 25266 apr 29 10:03 aclocal.m4*
drwxr-xr-x 7 510 104 1024 apr 29 10:27 bench/
drwxr-xr-x 2 510 104 1024 apr 29 10:25 client/
-rw-r--r-- 1 root root 4811 jul 1 01:12 con-help.mysql
-rwxr-xr-x 1 505 101 26643 dec 11 1998 config.guess*
-rw-r--r-- 1 510 101 14773 apr 27 08:46 config.h.in
-rwxr-xr-x 1 505 101 20598 dec 7 1998 config.sub*
-rwxr-xr-x 1 510 101 211062 apr 29 10:03 configure*
-rw-r--r-- 1 506 101 33826 apr 27 21:12 configure.in
drwxr-xr-x 2 510 104 1024 apr 29 10:26 dbug/
drwxr-xr-x 2 510 104 1024 apr 29 10:26 extra/
drwxr-xr-x 2 510 104 1024 apr 29 10:26 heap/
drwxr-xr-x 2 510 104 1024 apr 29 10:27 include/
-rwxr-xr-x 1 510 101 5585 nov 21 1996 install-sh*
drwxr-xr-x 2 510 104 1024 apr 29 10:26 isam/
-rw-r--r-- 1 root root 0 jul 1 01:40 ls.mysql
-rw-r--r-- 1 root root 414 jul 1 01:11 lsmysql.txt
-rwxr-xr-x 1 505 101 43323 apr 19 06:46 ltconfig*
-rw-r--r-- 1 510 101 70979 mar 21 1998 ltmain.sh
drwxr-xr-x 2 510 104 1024 apr 29 10:27 man/
drwxr-xr-x 2 510 104 1024 apr 29 10:26 merge/
-rwxr-xr-x 1 510 101 6274 sep 7 1998 missing*
drwxr-sr-x 18 510 101 1024 apr 29 10:26 mit-pthreads/
-rwxr-xr-x 1 510 101 729 oct 7 1997 mkinstalldirs*
drwxr-xr-x 2 510 104 2048 apr 29 10:26 mysys/
drwxr-xr-x 2 510 104 1024 apr 29 10:25 readline/
drwxr-xr-x 2 510 104 1024 apr 29 10:26 regex/
drwxr-xr-x 2 510 104 1024 apr 29 10:27 scripts/
drwxr-xr-x 3 510 104 2048 apr 29 10:26 sql/
-rw-r-xr-- 1 510 101 10 apr 29 10:25 stamp-h.in*
drwxr-xr-x 2 510 104 2048 apr 29 10:26 strings/
drwxr-xr-x 2 510 104 1024 apr 29 10:27 support-files/
drwxr-xr-x 2 510 104 1024 apr 29 10:27 tests/
ȯ°æ¼³Á¤À» ÇÑ´Ù. À̶§ »ç¿ë °¡´ÉÇÑ ¿É¼ÇÀ» ¾Ë¾Æº¸±â À§ÇØ --help¸¦ ½ÇÇàÇÏ¿© º» ÈÄ Àڽſ¡°Ô ¸Â°Ô²û ¼³Á¤ÇÏ¸é µÈ´Ù.
# ./configure --help [enter]
usage: configure [options] [host]
options: [defaults in brackets after descriptions]
configuration:
--cache-file=file cache test results in file
--help print this message
--no-create do not create output files
......
¸î °¡Áö ¿É¼ÇÀ» ¾Ë¾Æº¸ÀÚ.
--prefix=prefix prefix ´Â ¼³Ä¡µÉ µð·ºÅ丮ÀÇ °æ·ÎÀÌ´Ù.
--localstatedir=dir data µð·ºÅ丮ÀÇ À§Ä¡¸¦ ÁöÁ¤ÇÑ´Ù.
--with-charset=charset
¼³Ä¡ÇÒ ¹®ÀÚ¼ÂÀ» ÁöÁ¤ÇÑ´Ù. µðÆúÆ®´Â latin1 ÀÌ´Ù. ´ÙÀ½Àº »ç¿ë°¡´ÉÇÑ ¹®ÀÚ¼ÂÀÌ´Ù.
big5 danish cp1251 cp1257 czech dec8 dos euc_kr german1 hebrew hp8 hungarian koi8_ru koi8_ukr latin1 latin2 swe7 usa7 win1251 win1251_ukr ujis sjis tis620
¸¸ÀÏ ¿©·¯ºÐÀÇ ¸®´ª½º ¹Ú½º¿¡ c++ ÄÄÆÄÀÏ·¯°¡ ¾øÀ» °æ¿ì makefileÀ» ¼öÁ¤ÇØÁÖ¸é µÈ´Ù.
makefile¿¡´Â ÄÄÆÄÀÏ·¯¸¦ ÁöÁ¤ÇÑ ºÎºÐÀÌ Àִµ¥ 'cc= ' À̺κÐÀÌ cÄÄÆÄÀÏ·¯¸¦ ÁöÁ¤ÇÑ °÷À̸ç 'cxx= ' ÀÌ ºÎºÐÀÌ c++ ÄÄÆÄÀÏ·¯¸¦ ÁöÁ¤ÇÑ °÷ÀÌ´Ù.
ÀÌ´Â configure ÇÒ ¶§ ÀÎÀÚ·Î ³Ö¾î Á൵ µÇ´Âµ¥ ±× ¹æ¹ýÀº ´ÙÀ½°ú °°´Ù.
# cc=gcc cxx=gcc ./configure --¿É¼Ç [enter]
À̰ÍÀº c++ ÄÄÆÄÀÏ·¯¸¦ gcc·Î »ç¿ëÇϰڴٴ ÀǹÌÀÌ´Ù.
±×·³ ȯ°æ¼³Á¤À» ÇÑ´Ù.
# ./configure --¿É¼Ç [enter]
creating cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking target system type... i586-pc-linux-gnu
checking build system type... i586-pc-linux-gnu
checking for a bsd compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${make}... yes
checking for working aclocal... found
.......
checking whether build environment is sane... yes
checking whether make sets ${make}... (cached) yes
checking for gcc... gcc
checking whether the c compiler (gcc ) works... yes
checking whether the c compiler (gcc ) is a cross-compiler... no
checking whether we are using gnu c... yes
checking whether gcc accepts -g... yes
checking for c++... c++
checking whether the c++ compiler (c++ ) works... yes
checking whether the c++ compiler (c++ ) is a cross-compiler... no
checking whether we are using gnu c++... yes
checking whether c++ accepts -g... yes
checking how to run the c preprocessor... gcc -e
.....
ÀÌÁ¦ ÄÄÆÄÀÏÀ» ÇÏÀÚ. ´ÙÀ½ÀÇ ¸í·ÉÀ» ½ÇÇàÇÑ´Ù.
# make [enter]
cd client; make link_sources
make[1]: entering directory `/root/temp/mysql-3.22.22/client'
set -x; \
.........
gcc -dundef_threads_hack -dhave_config_h -i./../include -i./.. -i.. -o6 -ddbug_off -c readline.c
gcc -dundef_threads_hack -dhave_config_h -i./../include -i./.. -i.. -o6 -ddbug_off -c funmap.c
gcc -dundef_threads_hack -dhave_config_h -i./../include -i./.. -i.. -o6 -ddbug_off -c keymaps.c
gcc -dundef_threads_hack -dhave_config_h -i./../include -i./.. -i.. -o6 -ddbug_off -c vi_mode.c
gcc -dundef_threads_hack -dhave_config_h -i./../include -i./.. -i.. -o6 -ddbug_off -c parens.c
........
¾ÕÀ¸·Î ÄÄÆÄÀÏ ÇÒ ¼Ò½º ÆÄÀÏÁß¿¡ °¡Àå ±ä½Ã°£ÀÌ °É¸°´Ù. ¾î´À ¹®¼¿¡´Â 486-66¿¡¼ 8¸Þ°¡ ¸Þ¸ð¸®·Î ÄÄÆÄÀÏ Çß´õ´Ï 15½Ã°£ÀÌ °É·È´Ù°í ÇÑ´Ù. ÇÊÀÚÀÇ °æ¿ì Á¤È®È÷´Â ¸ð¸£°ÚÀ¸³ª 20ºÐ ¾È¿¡ ÄÄÆÄÀÏÀÌ µÇ¾ú´Ù.
ÄÄÆÄÀÏÀÌ ´Ù µÇ¾úÀ¸¸é ÀÌÁ¦ ¼³Ä¡¸¦ ÇÏ¸é µÈ´Ù.
# make install [enter]
making install in docs
make[1]: entering directory `/root/temp/mysql-3.22.22/docs'
/bin/sh ../mkinstalldirs /usr/local/mysql/info
/usr/bin/install -c -m 644 ./mysql.info /usr/local/mysql/info/mysql.info
install-info --info-dir=/usr/local/mysql/info /usr/local/mysql/info/mysql.info
make[1]: leaving directory `/root/temp/mysql-3.22.22/docs'
making install in readline
.......
¼³Ä¡°¡ ³¡ÀÌ ³ª¸é db¸¦ install ½ÃÄѾßÇÑ´Ù. ÀÌ ¸í·ÉÀº script µð·ºÅ丮¾È¿¡ ÀÖ´Â
mysql_install_db½ºÅ©¸³Æ®¸¦ ½ÇÇà ½ÃŰ´Â °ÍÀ¸·Î mysqlÀÇ ±âÃÊÅ×À̺í°ú admin À¯Àú¸¦ ¼³Ä¡ÇÏ´Â °ÍÀÌ´Ù. ÀÌ ¸í·ÉÀº ¼³Ä¡ÈÄ Çѹø¸¸ ÇÏ´Â °ÍÀ¸·Î µÎ ¹ø ÇÏÁö ¾Êµµ·Ï ÇÑ´Ù.
µð·ºÅ丮 º¯µ¿ÀÌ ¾ø¾ú´Ù¸é,
# ./script/mysql_install_db [enter]
creating db table
creating host table
creating user table
creating func table
creating tables_priv table
creating columns_priv table
to start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
please remember to set a password for the mysql root user !
this is done with:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
see the manual for more instructions.
please report any problems with the /usr/local/mysql/bin/mysqlbug script!
the latest information about mysql is available on the web at http://www.mysql.com
support mysql by buying support/licenses at http://www.tcx.se/license.htmy.
mysql 3.22.10 ÀÌÀüÀÇ ¹öÀü¿¡¼´Â À§ÀÇ ¸í·ÉÀ¸·Î mysql ¼¹ö°¡ ½ÃÀÛ µÇ¾úÀ¸³ª ±× ´ÙÀ½ ¹öÀüºÎÅÍ´Â mysql ÀÌ ¼³Ä¡µÈ µð·ºÅ丮¾ÈÀÇ binµð·ºÅ丮¿¡ ÀÖ´Â safe_mysqld ½ºÅ©¸³Æ®¸¦ ½ÇÇà½ÃÄѾ߸¸ ¼¹ö°¡ ÀÛµ¿µÈ´Ù.
ÀÌÁ¦ ¼³Ä¡´Â ³¡À̳µ´Ù. mysqlÀÌ ¼³Ä¡µÈ µð·ºÅ丮·Î °¡¼ ±× ³»¿ëÀ» º¸¸é ´ÙÀ½°ú °°´Ù.
/usr/local¿¡ ¼³Ä¡Çß´Ù¸é,
# cd /usr/local/mysql [enter]
# ls -al [enter]
total 11
drwxr-xr-x 11 root root 1024 jul 1 02:58 ./
drwxr-xr-x 12 root root 1024 jul 1 02:10 ../
drwxr-xr-x 2 root root 1024 jul 1 02:11 bin/
drwxr-xr-x 3 root root 1024 jul 1 02:10 include/
drwxr-xr-x 2 root root 1024 jul 1 02:10 info/
-rw-r--r-- 1 root root 0 jul 1 02:58 ins_ls.mysql
drwxr-xr-x 3 root root 1024 jul 1 02:10 lib/
drwxr-xr-x 2 root root 1024 jul 1 02:11 libexec/
drwxr-xr-x 3 root root 1024 jul 1 02:11 man/
drwxr-xr-x 3 root root 1024 jul 1 02:10 share/
drwxr-xr-x 7 root root 1024 jul 1 02:11 sql-bench/
drwxr-xr-x 4 root root 1024 jul 1 02:13 var/
ÀÌÁ¦ mysql µ¥¸óÀ» ½ÇÇà½Ã۸é mysql db¸¦ »ç¿ëÇÒ ¼ö ÀÖ°Ô µÈ´Ù.
µ¥¸óÀ» ½ÇÇà½ÃŰ´Â ¸í·ÉÀº bin µð·ºÅ丮 ¾È¿¡ ÀÖÀ¸¸ç ´ÙÀ½°ú °°´Ù.
# cd bin [enter]
# ls -al [enter]
total 845
drwxr-xr-x 2 root root 1024 jul 1 02:59 ./
drwxr-xr-x 11 root root 1024 jul 1 02:58 ../
-rwxr-xr-x 1 root root 32795 jul 1 02:10 comp_err*
-rw-r--r-- 1 root root 0 jul 1 02:59 ins_lsbin.mysql
-rwxr-xr-x 1 root root 160024 jul 1 02:10 isamchk*
-rwxr-xr-x 1 root root 120185 jul 1 02:10 isamlog*
-rwxr-xr-x 1 root root 1474 jul 1 02:11 msql2mysql*
-rwxr-xr-x 1 root root 182698 jul 1 02:10 mysql*
-rwxr-xr-x 1 root root 4400 jul 1 02:11 mysql_fix_privilege_tables*
-rwxr-xr-x 1 root root 11026 jul 1 02:11 mysql_install_db*
-rwxr-xr-x 1 root root 15260 jul 1 02:11 mysql_setpermission*
-rwxr-xr-x 1 root root 3020 jul 1 02:11 mysql_zap*
-rwxr-xr-x 1 root root 105578 jul 1 02:11 mysqlaccess*
-rwxr-xr-x 1 root root 22255 jul 1 02:10 mysqladmin*
-rwxr-xr-x 1 root root 9043 jul 1 02:11 mysqlbug*
-rwxr-xr-x 1 root root 27961 jul 1 02:10 mysqldump*
-rwxr-xr-x 1 root root 18753 jul 1 02:10 mysqlimport*
-rwxr-xr-x 1 root root 16492 jul 1 02:10 mysqlshow*
-rwxr-xr-x 1 root root 30089 jul 1 02:10 perror*
-rwxr-xr-x 1 root root 43099 jul 1 02:10 replace*
-rwxr-xr-x 1 root root 30320 jul 1 02:10 resolveip*
-rwxr-xr-x 1 root root 4417 jul 1 02:11 safe_mysqld*
ÀÌÁ¦ ½ÇÇà½ÃÄÑ º¸ÀÚ
# ./safe_mysqld & [enter]
¹é±×¶ó¿îµå·Î ½ÇÇà½ÃŰÁö ¾ÊÀ¸¸é ÇÁ·ÒÇÁÆ®°¡ ¶³¾îÁöÁö ¾ÊÀ» °ÍÀÌ´Ù. ÇÁ·ÒÇÁÆ®°¡ ¶³¾îÁö¸é mysql µ¥¸óÀÌ Á¤»óÀûÀ¸·Î ½ÇÇàµÈ °ÍÀÌ´Ù.
À§ÀÇ bin µð·ºÅ丮¿¡´Â Áß¿äÇϸ鼵µ ¸¹ÀÌ ¾²ÀÌ´Â ¸í·ÉµéÀÌ ÀÖ´Ù.
¸î°¡Áö¸¸ »ìÆìº¸¸é ´ÙÀ½°ú °°´Ù.
mysql sql ¹®ÀåÀ» ¼öÇàÇÏ´Â Å͹̳ÎÀÌ´Ù.
mysqlaccess È£½ºÆ®¿Í »ç¿ëÀÚ µ¥ÀÌÅͺ£À̽ºÀÇ ¿¬°áÀ» üũÇÏ´Â ½ºÅ©¸³Æ®ÀÌ´Ù.
mysaladmin mysqlÀ» °ü¸®ÇÏ´Â ½ºÅ©¸³Æ®ÀÌ´Ù. databaseÀÇ »ý¼º, Á¦°Å, reload, refresh µî À» ÇÑ´Ù.
mysqlshow database¿Í Å×À̺í, column, index¿¡ ´ëÇÑ Á¤º¸¸¦ º¸¿©ÁØ´Ù.
3-3 php3
ÀÌÁ¦ php3¸¦ ¼³Ä¡ÇÑ´Ù. À̰ÍÀ» ¼³Ä¡Çϱ⿡ ¾Õ¼ gif À̹ÌÁö¸¦ ó¸®Çϱ⸦ ¿øÇÑ´Ù¸é gd ¶óÀ̺귯¸®¸¦ ¼³Ä¡ÇØ¾ß ÇÑ´Ù. gd ¶óÀ̺귯¸®´Â graphics ¶óÀ̺귯¸®·Î ¼±, µµÇü, ÅØ½ºÆ®, ´ÙÁß»ö±ò, À̹ÌÁöÀÇ cut paste, ä¿ì±â µîÀÇ À̹ÌÁö 󸮱â´É°ú ÀÌ °á°ú¸¦ gif ÆÄÀÏ·Î ÀúÀåÇÏ´Â ±â´ÉÀ» Á¦°øÇÑ´Ù. radhat ¸®´ª½º 5.2 ÀÌ»óÀÇ ¹èÆ÷ÆÇ¿¡ Æ÷ÇԵǾî ÀÖÀ¸³ª ¾øÀ»°æ¿ì´Â ´ÙÀ½ÀÇ »çÀÌÆ®¿¡¼ ´Ù¿î·Îµå ¹Þ¾Æ ¼³Ä¡¸¦ ÇÑ´Ù. http://www.boutell.com/gd
ÇöÀç °¡Àå ÃֽŹöÀüÀº 1.3 ÀÌ´Ù.
/usr/local ¿¡¼ ¾ÐÃàµÈ ÆÄÀÏÀ» Ç®¸é ´ÙÀ½°ú °°Àº µð·ºÅ丮°¡ »ý¼ºµÈ´Ù.
# /usr/local/gd1.3
±× ¾È¿¡´Â ´ÙÀ½°ú °°Àº ÆÄÀÏÀÌ ÀÖ´Ù.
# ls -al [enter]
total 555
drwxr-xr-x 2 200 users 1024 jul 1 15:47 ./
drwxr-xr-x 6 root root 1024 jul 1 15:47 ../
-rw------- 1 200 users 883 aug 8 1995 makefile
-rwxr-xr-x 1 200 users 3680 mar 14 1998 bdftogd*
-rw-r--r-- 1 200 users 11449 aug 8 1995 demoin.gif
-rw-r--r-- 1 200 users 63352 jun 13 1998 gd.c
-rw-r--r-- 1 200 users 5404 mar 14 1998 gd.h
-rw------- 1 200 users 2894 aug 8 1995 gddemo.c
-rw-r--r-- 1 200 users 77471 mar 14 1998 gdfontg.c
-rw-r--r-- 1 200 users 421 mar 14 1998 gdfontg.h
-rw------- 1 200 users 74141 mar 14 1998 gdfontl.c
-rw-r--r-- 1 200 users 419 mar 14 1998 gdfontl.h
-rw-r--r-- 1 200 users 54411 mar 14 1998 gdfontmb.c
-rw-r--r-- 1 200 users 382 mar 14 1998 gdfontmb.h
-rw------- 1 200 users 47737 mar 14 1998 gdfonts.c
-rw-r--r-- 1 200 users 383 mar 14 1998 gdfonts.h
-rw-r--r-- 1 200 users 27028 mar 14 1998 gdfontt.c
-rw-r--r-- 1 200 users 415 mar 14 1998 gdfontt.h
-rw------- 1 200 users 855 aug 8 1995 giftogd.c
-rw------- 1 200 users 84854 mar 14 1998 index.html
-rw-r--r-- 1 root root 0 jul 1 15:47 ls.gd
-rw------- 1 200 users 883 aug 8 1995 mathmake.c
-rw-r--r-- 1 200 users 5530 aug 8 1995 mtables.c
-rw-r--r-- 1 200 users 80487 mar 14 1998 readme.txt
-rw-r--r-- 1 200 users 4768 mar 14 1998 webgif.c
makefileÀÌ Çϳª ÀÖ´Ù. ±×³É gcc·Î ÄÄÆÄÀÏ ÇÏ¸é µÈ´Ù.
# make all [enter]
.....
ÄÄÆÄÀÏÀ» ¿Ï·áÇÑ ÈÄ ±× µð·ºÅ丮³»¿¡ libgd.a ¶ó´Â ¶óÀ̺귯¸®°¡ »ý¼ºµÇ¾úÀ¸¸é ¼³Ä¡°¡ ³¡³ °ÍÀÌ´Ù.
ÀÌÁ¦ php3¸¦ ¼³Ä¡ÇÏÀÚ. ¾Õ¿¡¼ ¾ê±âÇßµíÀÌ php3´Â apache ¼¹öÀÇ ¸ðµâ·Î ÄÄÆÄÀÏ µÈ´Ù. µû¶ó¼ php3¸¦ ÇϳªÀÇ ¸ðµâ·Î¼ ÀÌÇØÇϵµ·Ï ÇÑ´Ù. php3¸ðµâÀº gif À̹ÌÁö¸¦ ó¸®Çϱâ À§ÇÑ ¶óÀ̺귯¸®¿Í ÇöÀç ½Ã½ºÅÛ¿¡ Á¸ÀçÇϰí ÀÖ´Â db¼¹ö¸¦ ÇÔ²² Æ÷ÇÔÇÑ ¸ðµâ·Î apache¿¡ Ãß°¡µÈ´Ù. Áï php3ÀÇ ´Üµ¶ ¼³Ä¡¶ó±â º¸´Ù´Â apache ¼¹öÀÇ ¼³Ä¡°úÁ¤ Áß¿¡ ¸¸µé¾îÁö´Â ¸ðµâ·Î ÀÌÇØÇÏ¸é µÈ´Ù. ÀÌÂë¿¡¼ '¾ÆÇÏ' ÇÏ´Â ºÐµµ °è½ÇÁö ¸ð¸£°ÚÀ¸³ª ÇÊÀÚ°¡ »ý°¢Çصµ ÂüÀ¸·Î ¾Æ¸®¼ÛÇÏ°Ô ¾ê±â¸¦ Çß´Ù. °á±¹ ÀÌ ¸»Àº php3¸¦ ¼³Ä¡Çϱ⿡ ¾Õ¼ apacheÀÇ È¯°æ¼³Á¤À» ¸ÕÀú ÇØ¾ß¸¸ ÇÏ´Â °Í¿¡ ´ëÇÑ ¼³¸íÀÌ´Ù.
±×·³ ÇÊ¿äÇÑ ¼Ò½º´Â php3¿Í apache ÀÌ´Ù ÀÌ µÑÀ» ´Ù¿î·Îµå ¹Þµµ·Ï ÇÏÀÚ.
php3´Â http://www.php3.net ¿¡¼,
apache´Â http://www.apache.org ¿¡¼ ´Ù¿î·Îµå ¹Þ´Â´Ù.
µÎ ÆÄÀÏÀ» Àû´çÇÑ µð·ºÅ丮¿¡´Ù ¿Å°Ü ³õ°í ÆÄÀÏÀÇ ¾ÐÃàÀ» Ǭ´Ù.
# tar -xvzf php-version.tgz (ȤÀº tar.gz) [enter]
# tar -xvzf apache-version.tar.gz [enter]
(µÎ °¡Áö ¼Ò½º ¸ðµÎ /usr/src µð·ºÅ丮¿¡¼ Ç®¾ú´Ù°í °¡Á¤ÇÑ´Ù.)
¿ì¼± apache ¼Ò½º¸¦ Ǭ ÈÄ »ý¼ºµÈ µð·ºÅ丮·Î °¡¼ ±× ³»¿ëÀ» º¸¸é ´ÙÀ½°ú °°´Ù.
# cd /usr/src/apache-version [enter]
# ls -al [enter]
total 178
drwxr-xr-x 8 220 games 1024 jul 1 02:14 ./
drwxr-xr-x 4 root root 1024 jul 1 01:10 ../
-rw-r--r-- 1 220 games 12975 feb 14 11:30 about_apache
-rw-r--r-- 1 220 games 3679 mar 23 08:38 announcement
-rw-r--r-- 1 220 games 26891 mar 10 20:52 install
-rw-r--r-- 1 220 games 24456 jan 12 06:44 keys
-rw-r--r-- 1 220 games 2848 jan 2 04:04 license
-rw-r--r-- 1 220 games 22724 mar 16 09:38 makefile.tmpl
-rw-r--r-- 1 220 games 2046 apr 1 1998 readme
-rw-r--r-- 1 220 games 3132 mar 20 00:55 readme.nt
-rw-r--r-- 1 220 games 11687 feb 8 03:05 readme.configure
-rw-r--r-- 1 220 games 331 sep 22 1998 warning-nt.txt
drwxr-xr-x 2 220 games 1024 mar 23 09:15 cgi-bin/
drwxr-xr-x 2 220 games 1024 mar 23 09:17 conf/
-rw-r--r-- 1 220 games 2459 mar 9 06:06 config.layout
-rwxr-xr-x 1 220 games 49001 mar 10 20:53 configure*
drwxr-xr-x 3 220 games 1024 mar 23 09:17 htdocs/
drwxr-xr-x 3 220 games 2048 mar 23 09:15 icons/
drwxr-xr-x 2 220 games 1024 mar 23 09:17 logs/
-rw-r--r-- 1 root root 0 jul 1 02:14 ls.apache
drwxr-xr-x 10 220 games 1024 mar 23 09:17 src/
º¸Åë apache ¼¹öÀÇ ¼³Ä¡°úÁ¤Àº ¼¹öÀÇ ¼³Ä¡°æ·Î¸¦ ¼³Á¤ÇÏ´Â °Í¿¡¼ºÎÅÍ ½ÃÀÛÇÑ´Ù.
# ./configure --prefix=prefix (¾Æ½ÃÁÒ?) [enter]
configuring for apache, version 1.3.6
+ using installation path layout: apache (config.layout)
creating makefile
creating configuration.apaci in src
creating makefile in src
+ configured for linux platform
+ setting c compiler to gcc
+ setting c pre-processor to gcc -e
+ checking for system header files
+ adding selected modules
+ doing sanity check on compiler and options
creating makefile in src/support
creating makefile in src/main
creating makefile in src/ap
creating makefile in src/regex
creating makefile in src/os/unix
creating makefile in src/modules/standard
apache ȯ°æ¼³Á¤ÀÌ ³¡³µÀ¸¸é ÀÌÁ¦ php3¸¦ ¼³Ä¡ÇÑ´Ù.
php3ÀÇ ¾ÐÃàÀ» Ǭ ÈÄ »ý¼ºµÈ µð·ºÅ丮·Î À̵¿ÇÑ´Ù.
# cd /usr/src/php-version [enter]
# ls -al [enter]
total 2020
drwxr-xr-x 16 root bin 4096 jul 1 02:38 ./
drwxr-xr-x 5 root root 1024 jul 1 02:37 ../
-rw-r--r-- 1 root bin 436 sep 20 1998 bugs
-rw-r--r-- 1 root bin 20150 jun 7 1998 changes
.....
-rw-r--r-- 1 root bin 6156 dec 16 1998 install
-rw-r--r-- 1 root bin 3057 jun 19 1998 license
-rw-r--r-- 1 root bin 36702 dec 20 1998 makefile.in
-rw-r--r-- 1 root bin 2112 jul 19 1998 readme.qnx
-rw-r--r-- 1 root bin 2378 may 23 1998 readme.win32
.....
drwxr-xr-x 2 root bin 1024 dec 24 1998 win32/
-rw-r--r-- 1 root bin 1782 oct 18 1998 win95nt.h
.....
ÆÄÀÏÀÌ »ó´çÈ÷ ¸¹´Ù.
ȯ°æ¼³Á¤À» À§ÇÑ ¿É¼ÇÀ» º¸ÀÚ.
# ./configure --help [enter]
usage: configure [options] [host]
options: [defaults in brackets after descriptions]
configuration:
--cache-file=file cache test results in file
--help print this message
--no-create do not create output files
--quiet, --silent do not print `checking...' messages
--version print the version of autoconf that created configure
directory and file names:
--prefix=prefix install architecture-independent files in prefix
[/usr/local]
.....
¸î°¡Áö ¿É¼ÇÀ» »ìÆìº¸ÀÚ.
--prefix=prefix ¼³Ä¡ÇÒ µð·ºÅ丮.
--with-apache=dir apache Áö¿ø(¼Ò½ºÆÄÀÏÀÇ °æ·Î)
--with-mysql=dir mysql Áö¿ø(¼³Ä¡µÈ °æ·Î) ±×¿Ü ´Ù¼ö db Áö¿ø
--with-gd=dir gd ¶óÀ̺귯¸® Áö¿ø
--enable-track-vars À¥¼¹öÀÇ http_get(post/cookies)_vars¹è¿¿¡ µé¾î
ÀÖ´Â get/post/cookies¿¡ »ç¿ëµÇ´Â º¯¼ö¸¦ php ³»ºÎ¿¡¼
º¯¼ö·Î »ç¿ë °¡´ÉÇϵµ·Ï ÁöÁ¤ÇÑ´Ù.
--enable-force-cgi-redirect ³»ºÎÀû ¼¹ö ¸®µð·ºÆ®½Ã¿¡ º¸¾È°Ë»ç¸¦ Çϵµ·Ï ÇÑ´Ù.
¿ì¼± apache¿Í mysql, gd ¶óÀ̺귯¸®¸¦ Áö¿øÇϱâ À§ÇÑ È¯°æ¼³Á¤À» ÇÑ´Ù.
´Ù¸¥ ¿É¼ÇÀº ÇØµµ±×¸¸ ¾ÈÇØµµ±×¸¸ÀÌÁö¸¸ --with-apache¿Í --with-mysqlÀº ¹Ýµå½Ã ÇØÁØ´Ù.
# ./configure --¿É¼Ç [enter]
creating cache ./config.cache
checking whether build environment is sane... yes
checking whether to enable maintainer-specific portions of makefiles... no
checking for bison... bison -y
checking bison version... 1.25 (ok)
checking for gcc... gcc
checking whether the c compiler (gcc ) works... yes
..........
checking for apache module support... yes - apache 1.3.x
...........
checking whether to include gd support... yes
..........
checking for mysql support... yes
checking for errmsg.h... yes
checking for mysql.h... yes
...........
updating cache ./config.cache
creating ./config.status
creating makefile
creating build-defs.h
creating stamp-h
creating libphp3.module
creating doc/makefile
creating doc/version.ent
creating doc/checkdoc
creating extra/gd/bdf2gdfont
creating regex/makefile
creating dbase/makefile
creating config.h
ÀÌÁ¦ ȯ°æ¼³Á¤ÀÌ ³¡³µ´Ù.
°úÁ¤Áß¿¡ ¿©·¯ºÐÀÌ ³Ö¾îÁØ ¿É¼ÇÀ» üũÇÏ´Â ºÎºÐÀ» º¸¾Æ¼ yes·Î µÇ¾î ÀÖ´ÂÁö È®ÀÎÇÑ´Ù.
ÀÌÁ¦ makefileÀÌ »ý¼ºµÇ¾úÀ¸´Ï ÄÄÆÄÀÏÀ» ÇÑ´Ù.
# make [enter]
gcc -g -o2 -o2 -i. -i. -i/root/temp/apache_1.3.6/src/include -i/root/temp/apache_1.3.6/src/os/unix -i/usr/local/mysql/include/mysql -c language-parser.tab.c -o language-parser.tab.o
gcc -g -o2 -o2 -i. -i. -i/root/temp/apache_1.3.6/src/include -i/root/temp/apache_1.3.6/src/os/unix -i/usr/local/mysql/include/mysql -w -c language-scanner.c
gcc -g -o2 -o2 -i. -i. -i/root/temp/apache_1.3.6/src/include -i/root/temp/apache_1.3.6/src/os/unix -i/usr/local/mysql/include/mysql -c main.c -o main.o
.......
¼³Ä¡¸¦ ÇÑ´Ù.
# make install [enter]
mkdir -p /root/temp/apache_1.3.6/src/modules/php3;
cp libmodphp3.a ./mod_php3.* ./php_version.h /root/temp/apache_1.3.6/src/modules/php3; cp ./apmakefile.tmpl /root/temp/apache_1.3.6/src/modules/php3/makefile.tmpl;
cp ./apmakefile.libdir /root/temp/apache_1.3.6/src/modules/php3/makefile.libdir;
cp libphp3.module /root/temp/apache_1.3.6/src/modules/php3
ÀÌÁ¦ apache ¼¹öÀÇ ¸ðµâ·Î »ç¿ëµÇ´Â libmodphp3.a °¡ »ý¼º µÇ¾ú´Ù. À̰ÍÀÌ »ý¼ºµÇ¾ú´Ù¸é Á¤»óÀûÀ¸·Î ¼³Ä¡°¡ ¿Ï·áµÈ °ÍÀÌ´Ù.
´ÙÀ½Àº apache ¼¹ö¸¦ ¼³Ä¡Çϱ⸸ ÇÏ¸é ¸ðµç ¼³Ä¡°¡ ¿Ï·áµÈ °ÍÀÌ´Ù.^^
3-4 apache
ÀÌÁ¦ ¸¶Áö¸· ÇÁ·Î±×·¥ÀÌ ³²¾Ò´Ù. À§¿¡¼ ȯ°æ¼³Á¤ configure ¸¸ ÇØµÐ apache ÀÇ ¼Ò½º ÆÄÀÏÀÌ ÀÖ´Â °÷À¸·Î °¡ÀÚ. (/usr/src ¿¡ Ç®¾ú´Ù °¡Á¤ÇßÀ¸¹Ç·Î..)
ÀÌ µð·ºÅ丮¾ÈÀÇ src/modules ¾ÈÀ» º¸¸é php3¶ó´Â µð·ºÅ丮°¡ »ý¼ºµÇ¾úÀ»°ÍÀÌ´Ù.
# cd /usr/src/apache-version [enter]
# cd src/modules [enter]
# ls -al [enter]
total 11
drwxr-xr-x 8 220 games 1024 jul 1 02:49 ./
drwxr-xr-x 10 220 games 1024 jul 1 02:37 ../
-rw-r--r-- 1 root root 1162 jul 1 02:37 makefile
-rw-r--r-- 1 220 games 861 may 28 1998 readme
drwxr-xr-x 2 220 games 1024 mar 23 09:17 example/
drwxr-xr-x 2 220 games 1024 mar 23 09:17 experimental/
drwxr-xr-x 2 220 games 1024 mar 23 09:17 extra/
-rw-r--r-- 1 root root 0 jul 1 02:49 modules.apache
drwxr-xr-x 2 root root 1024 jul 1 02:47 php3/
drwxr-xr-x 2 220 games 1024 mar 23 09:17 proxy/
drwxr-xr-x 2 220 games 1024 jul 1 02:37 standard/
php3 µð·ºÅ丮¾È¿¡´Â ÄÄÆÄÀÏ¿¡ ¾²ÀÌ´Â ¸ðµâÀÌ ÀÖ´Ù.
# cd php3 [enter]
# ls -al [enter]
total 3609
drwxr-xr-x 2 root root 1024 jul 1 02:49 ./
drwxr-xr-x 8 220 games 1024 jul 1 02:49 ../
-rw-r--r-- 1 root root 252 jul 1 02:47 makefile.libdir
-rw-r--r-- 1 root root 2246 jul 1 02:47 makefile.tmpl
-rw-r--r-- 1 root root 3644774 jul 1 02:47 libmodphp3.a
-rw-r--r-- 1 root root 308 jul 1 02:47 libphp3.module
-rw-r--r-- 1 root root 0 jul 1 02:49 mod_php3.apache
-rw-r--r-- 1 root root 21194 jul 1 02:47 mod_php3.c
-rw-r--r-- 1 root root 3688 jul 1 02:47 mod_php3.h
-rw-r--r-- 1 root root 28 jul 1 02:47 php_version.h
ÀÌÁ¦ ¿ø·¡ apache ¼Ò½ºÆÄÀÏÀÌ Ç®¸° ÃÖ»óÀ§ µð·ºÅ丮·Î °¡¼ ȯ°æ¼³Á¤°ú ÄÄÆÄÀÏÀ» ÇÏÀÚ.
ȯ°æ¼³Á¤À» ´Ù½Ã ÇÏ´Â ÀÌÀ¯´Â ¾Õ¼ »ý¼ºµÈ php3 ¸ðµâÀ» ÁöÁ¤Çϱâ À§ÇؼÀÌ´Ù.
# cd /usr/src/apache-version [enter]
configure ¿É¼ÇÀº --help ¸í·ÉÀ¸·Î ¾Ë¸ÂÀº ¿É¼ÇÀ» ¾Ë¾Æº» ÈÄ È¯°æ¼³Á¤À» ½ÃÀÛÇÑ´Ù.
# ./configure --help [enter]
usage: configure [options]
options: [defaults in brackets after descriptions]
general options:
--quiet, --silent do not print messages
--verbose, -v print even more messages
--shadow[=dir] switch to a shadow tree (under dir) for building
stand-alone options:
--help, -h print this message
--show-layout print installation path layout (check and debug)
installation layout options:
--prefix=prefix install architecture-independent files in prefix
........
--logfiledir=dir install logfile data in dir
--proxycachedir=dir install proxy cache data in dir
........
--add-module=file on-the-fly copy & activate a 3rd-party module
--activate-module=file on-the-fly activate existing 3rd-party module
--permute-module=n1:n2 on-the-fly permute module 'n1' with module 'n2'
--enable-module=name enable a particular module named 'name'
--disable-module=name disable a particular module named 'name'
¿©±â¼ ´Ù¸¥ °ÍÀº »ó°ü¾øÀ¸³ª php3¸ðµâÀ» Ãß°¡ÇÏ´Â ¿É¼ÇÀº ¹Ýµå½Ã ÁÖ¾î¾ß ÇÑ´Ù.
¿©±â¼ php3ÀÇ ÆÄÀϸíÀ¸·Î ´ÙÀ½°ú °°ÀÌ ÇöÀç µð·ºÅ丮·ÎºÎÅÍ ½ÃÀ۵Ǵ Àý´ë°æ·Î¸¦ Æ÷ÇÔÇÏ¿© ³Ö¾îÁÖ¾î¾ß ÇÑ´Ù.
¿Ã¹Ù¸¥ ¿¹) --activate-module=src/modules/php3/libphp3.a
¿©±â¼ ÁÖÀÇ ±íÀº »ç¶÷Àº ¾Ë ¼ö°¡ ÀÖÀ» °ÍÀÌ´Ù. php3 µð·ºÅ丮¿¡´Â libphp3.a ¶ó´Â ¶óÀ̺귯¸®°¡ Á¸ÀçÇÏÁö ¾Ê´Â´Ù´Â °ÍÀ»... ÀÌ ÆÄÀÏÀº ÄÄÆÄÀÏÀÌ µÇ¸é¼ »ý¼ºµÇ´Â ÆÄÀÏÀÌ´Ù.
php3ÀÇ install ÆÄÀÏÀ» º¸¸é...
'... the above line is correct! yes, we know libphp3.a does not exist at this stage.
it isn't supposed to. it will be created. ....' ^^;
ȯ°æ¼³Á¤À» ÇÑ´Ù.
# ./configure --prefix=prefix --activate-module=php3¶óÀ̺귯¸®ÀÇ ÆÄÀϸí
configuring for apache, version 1.3.6
+ using installation path layout: apache (config.layout)
+ activated php3 module (modules/php3/libphp3.a)
creating makefile
creating configuration.apaci in src
creating makefile in src
+ configured for linux platform
+ setting c compiler to gcc
+ setting c pre-processor to gcc -e
+ checking for system header files
+ adding selected modules
o php3_module uses configstart/end
+ doing sanity check on compiler and options
creating makefile in src/support
creating makefile in src/main
creating makefile in src/ap
creating makefile in src/regex
creating makefile in src/os/unix
creating makefile in src/modules/standard
creating makefile in src/modules/php3
¾Õ¿¡¼ óÀ½¿¡ configure ÇßÀ» ¶§¿Í ´Þ¸® php3¸ðµâ¿¡ ´ëÇÑ ¼³Á¤ÀÌ Ãß°¡µÇ¾ú´Ù.
ÀÌÁ¦ ÄÄÆÄÀÏÀ» ÇÏÀÚ.
#make [enter]
===> src
make[1]: entering directory `/root/temp/apache_1.3.6'
make[2]: entering directory `/root/temp/apache_1.3.6/src'
===> src/regex
sh ./mkh -i _regex_h_ regex2.h regcomp.c regerror.c regexec.c regfree.c > ../include/hsregex.h
sh ./mkh -p regcomp.c >regcomp.ih
gcc -i. -i../os/unix -i../include -dlinux=2 -duse_hsregex `../apaci` -dposix_mistake -c regcomp.c -o regcomp.o
........
-wl,-rpath,/usr/local/mysql/lib/mysql -l/usr/local/mysql/lib/mysql -lmysqlclient -lm -ldl -lcrypt -lnsl -lresolv -lm -lcrypt
sed <apxs.pl >apxs \
-e 's%@target@%httpd%g' \
-e 's%@cc@%gcc%g' \
-e 's%@cflags@% -dlinux=2 -duse_hsregex `../apaci`%g' \
-e 's%@cflags_shlib@%%g' \
-e 's%@ld_shlib@%%g' \
-e 's%@ldflags_shlib@%%g' \
-e 's%@libs_shlib@%%g' && chmod a+x apxs
make[2]: leaving directory `/root/temp/apache_1.3.6/src/support'
<=== src/support
make[1]: leaving directory `/root/temp/apache_1.3.6'
<=== src
¿©±â±îÁö µÇ¾úÀ¸¸é ÄÄÆÄÀÏÀÌ ¼º°øÀûÀ¸·Î ³¡³ °ÍÀÌ´Ù. ¸¸ÀÏ Áß°£¿¡ ¿¡·¯°¡ ³ª¿À¸é¼ ÄÄÆÄÀÏÀÌ ¾ÈµÇ¾ú´Ù¸é Áö±Ý±îÁöÀÇ °úÁ¤À» ²Ä²ÄÈ÷ Ã¼Å©ÇØº¸¶ó. ¿¡·¯¸Þ½ÃÁö¸¦ º¸¸é Àý¹Ý ÀÌ»óÀº ±× ¿øÀÎÀ» ¾Ë ¼ö°¡ ÀÖÀ» °ÍÀÌ´Ù.
ÀÌÁ¦ ¼³Ä¡¸¦ ÇÏÀÚ.
# make install [enter]
make[1]: entering directory `/root/temp/apache_1.3.6'
===> [mktree: creating apache installation tree]
./src/helpers/mkdir.sh /home/httpd/bin
./src/helpers/mkdir.sh /home/httpd/bin
./src/helpers/mkdir.sh /home/httpd/libexec
..........
./src/helpers/install.sh -c -m 644 ./conf/magic /home/httpd/conf/magic.default
./src/helpers/install.sh -c -m 644 ./conf/magic /home/httpd/conf/magic
<=== [config]
make[1]: leaving directory `/root/temp/apache_1.3.6'
+--------------------------------------------------------+
| you now have successfully built and installed the |
| apache 1.3 http server. to verify that apache actually |
| works correctly you now should first check the |
| (initially created or preserved) configuration files |
| |
| /home/httpd/conf/httpd.conf |
| |
| and then you should be able to immediately fire up |
| apache the first time by running: |
| |
| /home/httpd/bin/apachectl start |
| |
| thanks for using apache. the apache group |
| http://www.apache.org/ |
+--------------------------------------------------------+
ÀÌ ¸Þ½ÃÁö¸¦ º¸¾Ò´Ù¸é ¸ðµç ¼³Ä¡°¡ ³¡³ °ÍÀÌ´Ù. ^^
ÀÌÁ¦ apache ¼¹öÀÇ conf ÆÄÀÏÀ» ¼öÁ¤ÇÏ°í ¼¹ö¸¦ ±¸µ¿½ÃŰ¸é ¸ðµç ÀÛ¾÷ÀÌ ³¡³ª°Ô µÈ´Ù.
apache ¼¹öÀÇ ¼³Ä¡ Àå¼Ò·Î °£´Ù. ȯ°æ¼³Á¤¿¡¼ prefix¸¦ /etc/httpd·Î ÇÏ¿´´Ù°í °¡Á¤ÇÑ´Ù.
# cd /etc/httpd [enter]
ÀÌ µð·ºÅ丮 ¾ÈÀÇ conf µð·ºÅ丮¿¡´Â httpd.conf, srm.conf, access.conf ÆÄÀϰú ÀÌ ÆÄÀϵéÀÇ ¿øº»ÆÄÀÏÀÌ ÀÖÀ» °ÍÀÌ´Ù.
apache ¼¹ö´Â ¼¹öÀÇ È¯°æ¼³Á¤À» À¥¼¹öÀÇ Àü¹ÝÀûÀÎ ¼³Á¤À» À§ÇÑ httpd.conf, ÀÚ¿ø¼³Á¤À» À§ÇÑ srm.conf, Á¢±Ù±ÇÇѼ³Á¤À» À§ÇÑ access.conf ¼¼°¡ÁöÀÇ ÆÄÀÏ·Î ³ª´©¾ú´Ù. À̰ÍÀº ncsa httpdÀÇ ¿µÇâ ¶§¹®Àε¥ 1.3.4 ¹öÀüºÎÅÍ ÀÌ ¼¼ °¡Áö ÆÄÀÏÀ» httpd.conf Çϳª¿¡¼ ÅëÇÕ°ü¸®ÇÏ°Ô µÇ¾ú´Ù.
±×·³ vi ÆíÁý±â·Î httpd.conf ÆÄÀÏÀ» ¿¾îº¸ÀÚ.
# cd conf [enter]
# vi httpd.conf [enter]
##
## httpd.conf -- apache http server configuration file
##
#
# based upon the ncsa server configuration files originally by rob mccool.
#
# this is the main apache server configuration file. it contains the
# configuration directives that give the server its instructions.
# see <url:http://www.apache.org/docs/> for detailed information about
# the directives.
#
# do not simply read the instructions in here without understanding
# what they do. they're here only as hints or reminders. if you are unsure
# consult the online docs. you have been warned.
.......
#
# addtype allows you to tweak mime.types without actually editing it, or to
# make certain files to be certain types.
#
# for example, the php3 module (not part of the apache distribution - see
# http://www.php.net) will typically use:
#
#addtype application/x-httpd-php3 .php3
#addtype application/x-httpd-php3-source .phps
......
ÀÌ ÆÄÀÏÀÇ ³»¿ëÁß¿¡ ## section 2: 'main' server configurationÀ» º¸¸é ´ÙÀ½°ú °°Àº ³»¿ëÀÌ ÀÖ´Ù.
#addtype application/x-httpd-php3 .php3
#addtype application/x-httpd-php3-source .phps
ÀÌ ºÎºÐÀÇ ÁÖ¼®('#')À» Á¦°Å Çϰí ÀúÀåÇÑ ÈÄ vi ÆíÁý±â¸¦ ºüÁ®³ª¿Í¼ apache ¼¹ö¸¦ ±¸µ¿½ÃŰ¸é µÈ´Ù.
ÀÌÁ¦ web-db ¿¬µ¿ ¼¹ö°¡ ±¸ÃàµÇ¾ú´Ù. À̸¦ ÀÌ¿ëÇØ¼ ¼îÇθô»çÀÌÆ® °°Àº »ó¾÷»çÀÌÆ®µµ Á¦ÀÛÇÒ ¼ö ÀÖ°í º¸´Ù °·ÂÇÑ È¨ÆäÀÌÁö¸¦ ±¸ÃàÇÒ ¼öµµ ÀÖ´Ù.
4 Å×½ºÆ®
¼¹ö°¡ ¼º°øÀûÀ¸·Î ±¸ÃàµÇ¾ú´ÂÁö¸¦ ¾Ë¼ö ÀÖ´Â °£´ÜÇÑ ¹æ¹ýÀÌ ÀÖ´Ù.
À¥¼¹öÀÇ htdocs µð·ºÅ丮¿¡ php3 ¿Í°°Àº ÀÓÀÇÀÇ µð·ºÅ丮¸¦ ¸¸µçÈÄ¿¡ ´ÙÀ½³»¿ëÀÇ ÆÄÀÏÀ» ÀÛ¼ºÇÑ´Ù.
<? phpinfo() ?>
ÀÌ ÆÄÀÏÀ» test.php3 ¶ó°í ÀúÀåÇÑ ´ÙÀ½, ºê¶ó¿ìÀúÀÇ url ÀԷ¶õ¿¡
http://yourdomain/php3/test.php3
¶ó°í ¾²¸é µÈ´Ù.
php3ÀÇ ¹öÀüÁ¤º¸¸¦ ºñ·ÔÇÏ¿© ½Ã½ºÅÛ Á¤º¸, apache Á¤º¸, mysql Á¤º¸°¡ ¿©·¯°³ÀÇ Å×ÀÌºí¿¡ ÀԷµǾî ÀÖÀ» °ÍÀÌ´Ù.
À̰ÍÀ» È®ÀÎÇÏ¸é ¿©·¯ºÐÀº web-db ¿¬µ¿ ¼¹ö¸¦ ±¸ÃàÇÑ °ÍÀÌ´Ù. ^^
µµ¿ò¹ÞÀº ±Û
cgi & ÀüÀÚ»ó°Å·¡ ±¸Ãà - ÃÖȯÁø
mysql µ¥ÀÌÅͺ£À̽º ¼¹ö - ÇãÁ¤¼ö