English
¢¸¢· µÚ·Î
Ãë¾àÁ¡ID 25113
À§Çèµµ 30
Æ÷Æ® 5432
ÇÁ·ÎÅäÄÝ TCP
ºÐ·ù DB
»ó¼¼¼³¸í PostgreSQL ¼­¹öÀÇ ¹öÀü Á¤º¸¿¡ µû¸£¸é ÇØ´ç ¼­¹ö¿¡´Â Bit Substring ¹öÆÛ ¿À¹öÇ÷οì Ãë¾àÁ¡ÀÌ Á¸ÀçÇÑ´Ù. PostgreSQLÀº SQLÀÇ È®Àå ¼­ºê¼Â(subset)À» Áö¿øÇÏ´Â °´Ã¼-°ü°èÇü µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛ(DBMS) ·Î¼­ ¸ðµç ¼Ò½º°¡ °ø°³µÇ¾î ÀÖ´Â ¹«·á ¼ÒÇÁÆ®¿þ¾îÀÌ´Ù.
PostgreSQL 8.0.23, 8.1.11, 8.3.8 ¹öÀü "backend/utils/adt/varbit.c" ÆÄÀÏÀÇ bitsubstrÇÔ¼ö¿¡ »ç¿ëµÇ´Â ¼¼¹ø° ÀÎÀÚ¿¡ À½¼ö°¡ »ç¿ëµÉ °æ¿ì Å©·¡½¬ µÇ¾î ¼­ºñ½º °ÅºÎ »óÅ¿¡ ºüÁú ¼ö ÀÖ´Ù.
¿¹) testdb=# select substring(B'10101010101010101010101010101010101010101010101',33,-15);

* ¾Ë¸²: ÀÌ Á¡°ËÇ׸ñÀº ÀÌ Ãë¾àÁ¡À» Á¡°ËÇϱâ À§ÇØ ÇØ´ç PostgreSQL ¼­¹öÀÇ ¹öÀü Á¤º¸¸¸À» È®ÀÎÇÑ´Ù. µû¶ó¼­ °ÅÁþ ¾ç¼º¹ÝÀÀ(False Positive)À» º¸ÀÏ ¼ö ÀÖ´Ù.

* Âü°í »çÀÌÆ®:
http://archives.postgresql.org/pgsql-hackers/2010-01/msg00634.php
http://downloads.avaya.com/css/P8/documents/100088368
http://downloads.avaya.com/css/P8/documents/100092667

* ¿µÇâÀ» ¹Þ´Â Ç÷§Æû:
PostgreSQL 8.0.23/8.1.11/8.3.8 ¹öÀü
¸ðµç ¿î¿µÃ¼Á¦ ¸ðµç ¹öÀü
ÇØ°áÃ¥ PostgreSQL FTP À¥ ÆäÀÌÁöÀÎ http://wwwmaster.postgresql.org/ftp/ ¿¡¼­ ±¸ÇÒ ¼ö ÀÖ´Â PostgreSQLÀÇ °¡Àå ÃֽŠ¹öÀü(8.0.23/8.1.11/8.3.8 ÀÌÈÄ)À¸·Î ¾÷±×·¹À̵å ÇÏ¿©¾ß ÇÑ´Ù.
°ü·Ã URL CVE-2010-0442 (CVE)
°ü·Ã URL 37973 (SecurityFocus)
°ü·Ã URL (ISS)