Ä¿ÇǴнº, ½Ã½ºÅÛ ¿£Áö´Ï¾îÀÇ ½°ÅÍ Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
* HanIRCÀÇ #coffeenix ¹æ
[ Àåºñ ¹× ȸ¼± ÈÄ¿ø ]
HOME > ³×Æ®¿öÅ©(network) µµ¿ò¸»
°Ë»ö : »çÀÌÆ® WHOIS À¥¼­¹ö Á¾·ù

TCP/IP, ÇÁ·ÎÅäÄÝ, Æ÷Æ® (11, ±Û 2, ÀÚ·á 25)
ÀÎÅÍ³Ý Á¢¼Ó (1, ±Û 3)
À¥ ¼­¹ö(web, httpd, apache) (48, ±Û 42, ÀÚ·á 31)
¸ÞÀÏ ¼­¹ö(mail) (31, ±Û 42, ÀÚ·á 23)
³×ÀÓ¼­¹ö(name server, dns, bind) (15, ±Û 18, ÀÚ·á 4)
FTP ¼­¹ö / rsync / ¹Ì·¯¸µ / CVSup (12, ±Û 13, ÀÚ·á 9)
¸Á°ü¸® / SNMP / QoS (13, ÀÚ·á 16)
»ï¹Ù (samba) (4, ±Û 1, ÀÚ·á 5)
ÇÁ¶ô½Ã ¼­¹ö(ÇÁ·Ï½Ã, proxy server) (6, ±Û 3, ÀÚ·á 2)
³×Æ®¿öÅ© Åø (15, ±Û 1, ÀÚ·á 11)
Ŭ·¯½ºÅ͸µ(cluster) (6, ÀÚ·á 1)
Àåºñ / ¶ó¿ìÅÍ / ½ºÀ§Äª (8, ±Û 3, ÀÚ·á 8)
IRC (Internet Relay Chat) / ¸Þ½ÅÀú (6)
ssh / telnet (10, ±Û 3, ÀÚ·á 2)
NFS / SHFS (5, ÀÚ·á 2)
VPN ¼­¹ö, FreeS/WAN (4)
DHCP (1, ÀÚ·á 1)
LDAP (3, ÀÚ·á 1)
SAN / NAS / ½ºÅ丮Áö (4, ±Û 2, ÀÚ·á 6)
À½¾Ç¹æ¼Û / icecast (3, ±Û 1)

  ÇØ´ç IP°¡ ¾î´À ±¹°¡IP´ë¿ªÀÎÁö ¾Æ´Â ¹æ¹ý (¿µ¾î) ÀÛ¼ºÀÏ : 2005/07/04 22:29
 
  • ±Û¾´ÀÌ : ÁÁÀºÁøÈ£ ( http://coffeenix.net/ )
  • Á¶È¸¼ö : 12606
          [ ÀÌÀüÈ­¸é / ¼öÁ¤ ]   ºñ¹Ð¹øÈ£ :     Àμâ¿ë È­¸é
      http://www.maxmind.com/app/geoip_country ¿¡¼­ cvsÆÄÀÏ·Î µÈ ±¹°¡º° IP´ë¿ªÀ»
    DB¿¡ insertÇÑ ÈÄ °£´ÜÈ÷ select¸¦ ÅëÇØ IP°¡ ¾î´À ±¹°¡¿¡ ¼ÓÇÏ´ÂÁö ¾Ë ¼ö ÀÖ´Ù.
    ¹°·Ð global±â¾÷ÀÇ °æ¿ì ½ÇÁ¦ ¼­¹ö³ª PC°¡ ±¹³»¿¡ À־ ¿Ü±¹ IP·Î ³ª¿Ã ¼ö ÀÖ´Ù.

    by ÁÁÀºÁøÈ£


    * Âü°í ÀÚ·á
      GeoIP È°¿ë(¾ÆÆÄÄ¡ À¥·Î±×¿¡ ±¹°¡ÄÚµå ³²±â±â ¿Ü) (±Û ÁÁÀºÁøÈ£, 2008.3)
      http://coffeenix.net/board_view.php?bd_code=1638

    ---------------------------------------------------------------------
    * °ü·Ã ¸µÅ© : http://www.delau.net/php/geoip.html
    * ¾Æ·¡±Û Ãâó : http://www.maxmind.com/app/csv
    ---------------------------------------------------------------------
    GeoIP Country CSV Text Files

    MaxMind GeoIP databases are available in a Comma Separated Value (CSV) format, in addition to the binary format. These CSV files generally contain IP Address range and geographical data for all publicly assigned IPv4 addresses.

    Due to the large size of geolocation databases, we generally recommend using our binary format with one of our APIs, since they are highly optimized for speed and disk space. On the other hand, if you have a requirement to import the data into a SQL database, the CSV format is recommended. We have listed some guidelines for importing and querying the data with a SQL database.

    CSV Format

    The CSV File contains four fields:

        * Beginning IP Number*
        * Ending IP Number*
        * ISO 3166 Country Code
        * Country Name

    This is an sample of how the CSV file is structured:

    "begin_num","end_num","country","name"
    "1029177344","1029439487","AU","Australia"
    "1029439488","1029570559","HK","Hong Kong"
    "1029570560","1029572607","ID","Indonesia"

    * Beginning IP Number and Ending IP Number are calculated as follows:

    ipnum = 16777216*w + 65536*x + 256*y + z   (1)

    where

    IP Address = w.x.y.z

    The reverse of this formula is

    w = int ( ipnum / 16777216 ) % 256;
    x = int ( ipnum / 65536    ) % 256;
    y = int ( ipnum / 256      ) % 256;
    z = int ( ipnum            ) % 256;

    Where % is the mod operator.

    Here is sample Perl code to convert the IP number to
    a IP address:

    sub numToStr {
      my ($ipnum) = @_;
      my $z = $ipnum % 256;
      $ipnum >>= 8;
      my $y = $ipnum % 256;
      $ipnum >>= 8;
      my $x = $ipnum % 256;
      $ipnum >>= 8;
      my $w = $ipnum % 256;
      return "$w.$x.$y.$z";
    }


    It is useful to have the IP Number if you are performing IP Address lookups using a database. For example the following queries will find the country based on IP Address 24.24.24.24:

    SQL Query

    SELECT ip_country FROM geoip WHERE 404232216 BETWEEN begin_ip_num AND end_ip_num

    MySQL Query

    SELECT ip_country FROM geoip WHERE 404232216 >= begin_ip_num AND
    ¡¡¡¡¡¡404232216 <= end_ip_num

    Here we used the formula (1) to compute the IP Number based on 24.24.24.24

    404232216 = 16777216*24 + 65536*24 + 256*24 + 24

    For more information on importing GeoIP CSV files into MySQL, see HOW-TO Import the MaxMind GeoIP Free Country CSV file into MySQL and save diskspace.

    http://www.delau.net/php/geoip.html
      Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
    [03/24] Youtube òÁ&#2
    [03/20] Re: ¿Â¶óÀΰÔÀÓÀÇ Á¾ÁÖ±¹ ´ëÇѹα¹
    [03/20] ½ÇÁ¦&#4
    [03/18] ±¹°¡&#5
    [10/20] Cross Compiler ±ò
    [07/14] SSL ¬¡¬°
    [04/26] Re: µµ½ºÈ­¸é ¿ø°ÝÁ¶Á¾ ¿©ºÎ
    [04/25] µµ½ºÈ­¸é ¿ø°ÝÁ¶Á¾ ¿©ºÎ
    [10/30] Cshell¿¡¼­ ³­¼ö ¼³Á¤
    [10/23] °øÇ×öµµÁÖ½Äȸ»ç SE ±¸ÀÎ Ëì
    [01/26] Re: wgetÀ¸·Î ´Ù¸¥¼­¹ö¿¡ÀÖ´Â µð·ºÅ丮¸¦ °¡Á®¿À·Á°íÇÕ´Ï´Ù.
    [01/25] wgetÀ¸·Î ´Ù¸¥¼­¹ö¿¡ÀÖ´Â µð·ºÅ丮¸¦ °¡Á®¿À·Á°íÇÕ´Ï´Ù.
    [01/11] ƯÁ¤ ¾Èµå·ÎÀ̵å WebView ¹öÀü¿¡¼­ SSL ¹®Á¦ (WebView ¹ö±×)
    [08/01] DNS forwarder (Àü´ÞÀÚ) ¼­¹ö¸¦ ÅëÇؼ­ Äõ¸®ÇÏ¸é ¿ª¹æÇâÀ» ¹Þ¾Æ¿ÀÁú ¸øÇÕ´Ï´Ù.
    [05/16] (ÁÖ)ÈÄÀÌÁî ½Ã½ºÅÛ¿£Áö´Ï¾î (°æ·ÂÀÚ) ¸ðÁý
      New!   ÃÖ±Ù¿¡ µî·ÏÇÑ ÆäÀÌÁö
      KiCad EDA Suite project (Free/Libre/Open-Source EDA Suite) (CAD)
      ¿ÀÇÂij½ºÄÉÀ̵å ijµå (OpenCASCADE CAD)
      QCad for Windows --- GNU GPL (Free Software)
      The Hello World Collection
      IPMI¸¦ È°¿ëÇÑ ¸®´ª½º ¼­¹ö°ü¸®
      DNS ¼³Á¤ °Ë»ç
      nagiosgraph ¼³Ä¡ ¹æ¹ý
      Slony-I ¼³Ä¡ ¹æ¹ý (postgresql replication tool)
      Qmail±â¹ÝÀÇ Anti spam ½Ã½ºÅÛ ±¸ÃàÇϱâ
      clusterssh

    [ ÇÔ²²ÇÏ´Â »çÀÌÆ® ]




    ¿î¿µÁø : ÁÁÀºÁøÈ£(truefeel), ¾ß¼ö(yasu), ¹ü³ÃÀÌ, sCag
    2003³â 8¿ù 4ÀÏ~