1334 ¹ø ±ÛÀÇ ´äÀå±Û: Re: proftp 1.25 + mod_sql ·Î ·Î±ä»óÅ üũ °¡´É ÇÒ±î |
±Û¾´ÀÌ: »êÀÌ
[ȨÆäÀÌÁö]
|
±Û¾´³¯: 2003³â 02¿ù 20ÀÏ 23:51:52 ¸ñ(Àú³á) |
Á¶È¸: 2195 |
[mod_sql]´ÔÀÌ ³²±â½Å ±Û:
>proftp 1.25 + mod_sql ·Î ·Î±ä»óÅ üũ °¡´É ÇÒ±î¿ä??
>
>cwd Çʵ带 üũÇؼ ·Î±ä »óÅÂ
>·Î±×¾Æ¿ô»óÅÂÀ» ¾Ë·Á°í ÇÕ´Ï´Ù
>°¡´ÉÇÒ±î¿ä mod_sqlÀ» »ç¿ëÇؼ
>ÇöÀç »ç¿ëÀÚ ÀÎÁõÀ» ÇÏ°í ÀÖ½À´Ï´Ù.
>
>
>SQLLog PASS,CWD updatedir
>SQLNamedQuery updatedir UPDATE \"cwd=\'%d\' where userid=\'%u\'\"
userinfo
>SQLLog quit updatedir
>SQLNamedQuery updatedir UPDATE \"cwd=\'logout\' where userid=\'%u\'\"
userinfo
>
========================================
mod_sql ¸ðµâÀ» »ç¿ëÇغ¸Áú ¾Ê¾Æ¼ µüºÎ·¯Áö°Ô ´äº¯Àº ¾î·Æ±º¿ä.
Àá±ñ SQL °ü·Ã Áö½ÃÀÚ¸¦ »ìÆ캸¾Ò´Âµ¥ ftpwho ¿Í °°Àº ±â´ÉÀº
¾ÆÁ÷ ¾ø´Â°Í °°±º¿ä.
ps -ef, ftpwho, ftpcount ¿Í °°Àº ¸í·É¾î¸¦
»ç¿ëÇؼ ¾Ë¾Æº¸´Â ¹æ¹ý¹Û¿¡ ¾ø´Â°Í °°±º¿ä.
....
http://proftpd.oops.org/reference.php?mode=detail&id=200&key=SQLLog&
class=s
¿¡ ±× ´äÀÌ ÀÖ±º¿ä(¿µ¹®).
¼¼¼ÇÀÌ Á¾·áµÉ¶§ QUIT º¸´Ù´Â EXIT ¸í·É¾î ¼ÂÀ» »ç¿ëÇ϶ó°í
Çϳ׿ä.
±×·¸´Ù¸é,
SQLLog EXIT updatedir
ÀÌ·¸°Ô °íÃĺ¸¼¼¿ä.
ftpwho ¿Í ºñ½ÁÇÏ°Ô:
mysql -u username -p dbname -e
"SELECT userid FROM userinfo WHERE cmd != 'logout'"
¸¸¾à cmd Ä÷³ÀÌ ¼¼¼Ç¿¡ °ü·ÃµÈ Ä÷³À̶ó¸é
·Î±×Àο¡ ¼º°øÇßÀ» °æ¿ì 1 ·Î ¼³Á¤ÇÏ°í ¼¼¼ÇÀÌ Á¾·áµÉ¶§ 0À¸·Î
¼³Á¤ÇÏ¸é ±ò²ûÇÏ°Ú±º¿ä.
±× ÀÌÀ¯´Â Äõ¸®¸¦ Àü¼ÛÇÒ¶§ cmd != 'logout' ÀÌ°Í º¸´Ù´Â
'cmd = 0' ÀÌ ´õ ³´Àº ¼º´ÉÀ̱⠶§¹®ÀÔ´Ï´Ù.
|
ÀÌÀü±Û : proftp 1.25 + mod_sql ·Î ·Î±ä»óÅ üũ °¡´É ÇÒ±î
´ÙÀ½±Û : nfs¿¡ ´ëÇØ ÇÑ ¸»²û
|
from 61.254.75.40
JS(Redhands)Board 0.4 +@
|