¡¾·ì϶¹«¸æ¡¿PostgreSQL pg_dump¾ºÕùǰÌá·ì϶£¨CVE-2024-7348£©

°ä²¼¹¦·ò 2024-08-13

Ò»¡¢·ì϶¸ÅÊö

·ìϼûû³Æ

   PostgreSQL pg_dump ¾ºÕùǰÌá·ì϶

CVE   ID

CVE-2024-7348

·ì϶ÀàÐÍ

TOCTOU¾ºÕùǰÌá

·¢ÏÖ¹¦·ò

2024-08-13

·ì϶ÆÀ·Ö

8.8

·ì϶µÈ¼¶

¸ßΣ

¹¥»÷ÏòÁ¿

ÍøÂç

ËùÐèȨÏÞ

µÍ

ÀûÓÃÄѶÈ

µÍ

Óû§½»»¥

ÎÞ

PoC/EXP

δ¹«¿ª

ÔÚÒ°ÀûÓÃ

δ·¢ÏÖ

 

PostgreSQLÊÇÒ»¿îÖ°ÄÜ׳´ó¡¢½Ã½Ý¿É¶¨ÔìµÄ¿ªÔ´¹ØÏµÐÍÊý¾Ý¿âÖÎÀíϵͳ£¨RDBMS£© £¬Ö§³ÖWindows¡¢Linux¡¢UNIX¡¢Mac OS X¡¢BSDµÈ¶àÖÖ²Ù×÷ϵͳ £¬²¢ÒòÆä¸ß¶È¼æÈÝSQL³ß¶ÈºÍ׳´óµÄÀ©´óÖ°ÄÜ £¬±»¿í·ºÊ¹ÓÃ×÷ΪWebÀûÓúͷþÎñµÄºó¶ËÊý¾Ý¿â¡£

2024Äê8ÔÂ14ÈÕ £¬±¦ÔËÀ³¹Ù·½ÍøÕ¾¼¯ÍÅVSRC¼à²âµ½PostgreSQLÖн¨¸´ÁËÒ»¸öTOCTOU¾ºÕùǰÌá·ì϶£¨CVE-2024-7348£© £¬¸Ã·ì϶µÄCVSSÆÀ·ÖΪ8.8¡£

PostgreSQL¶à¸öÊÜÓ°Ïì°æ±¾ÔÚpg_dump ¹¤¾ßÖдæÔÚTOCTOU¾ºÕùǰÌá·ì϶ £¬pg_dumpÊÇPostgreSQLÓÃÓÚ±¸·ÝÊý¾Ý¿âµÄ¹¤¾ß £¬Ëüͨ³£ÓÉÓµÓнϸßȨÏÞ£¨È糬µÈÓû§£©µÄÓû§ÔËÐС£pg_dump ¹¤¾ßÔÚµ¼³öÊý¾Ý¿â¶ÔÏóʱ»á²é³­Êý¾Ý¿âÖеĶÔÏóÀàÐÍ£¨Èç±í¡¢ÊÓͼµÈ£©²¢ÔÚÖ®ºó´¦ÖÃÕâЩ¶ÔÏó £¬ÓÉÓÚpg_dump Ôڲ鳭¶ÔÏóÀàÐͺÍÏÖʵʹÓÃÕâЩ¶ÔÏóÖ®¼ä´æÔڲ鳭¹¦·òʹÓù¦·ò (TOCTOU) ¾ºÕùǰÌá·ì϶ £¬ÍþвÕß¿ÉÀûÓø÷ì϶À´´úÌæÄ³Ð©Êý¾Ý¿â¶ÔÏó £¬´Ó¶øÔÚ pg_dump µÄÖ´Ðйý³ÌÖвåÈëºÍÖ´ÐжñÒâSQL´úÂë/º¯Êý £¬¿ÉÄܵ¼Ö½ÚÔìÊý¾Ý¿â»ò·ÛËéÊý¾ÝÆëÈ«ÐÔ¡£


 

¶þ¡¢Ó°ÏìÁìÓò

PostgreSQL 16 < 16.4

PostgreSQL 15 < 15.8

PostgreSQL 14 < 14.13

PostgreSQL 13 < 13.16

PostgreSQL 12 < 12.20

 

Èý¡¢°²È«´ëÊ©

3.1 Éý¼¶°æ±¾

Ŀǰ¸Ã·ì϶ÒѾ­½¨¸´ £¬ÊÜÓ°ÏìÓû§¿ÉÉý¼¶µ½ÒÔϰ汾£º

PostgreSQL 16 >= 16.4

PostgreSQL 15 >= 15.8

PostgreSQL 14 >= 14.13

PostgreSQL 13 >= 13.16

PostgreSQL 12 >= 12.20

ÏÂÔØÁ´½Ó£º

https://www.postgresql.org/download/

3.2 һʱ´ëÊ©

ÔÝÎÞ¡£

3.3 ͨÓý¨Òé

l  ¶¨ÆÚ¸üÐÂϵͳ²¹¶¡ £¬Ï÷¼õϵͳ·ì϶ £¬ÌáÉý·þÎñÆ÷µÄ°²È«ÐÔ¡£

l  ¼ÓǿϵͳºÍÍøÂçµÄ½Ó¼û½ÚÔì £¬Åú¸Ä·À»ðǽսÊõ £¬¹Ø¹Ø·Ç±ØÒªµÄÀûÓö˿ڻò·þÎñ £¬Ï÷¼õ½«Î£ÏÕ·þÎñ£¨ÈçSSH¡¢RDPµÈ£©Â¶³öµ½¹«Íø £¬Ï÷¼õ¹¥»÷Ãæ¡£

l  ʹÓÃÆóÒµ¼¶°²È«²úÆ· £¬ÌáÉýÆóÒµµÄÍøÂ簲ȫ»úÄÜ¡£

l  ¼ÓǿϵͳÓû§ºÍȨÏÞÖÎÀí £¬ÆôÓöà³É·ÖÈÏÖ¤»úÔìºÍ×îÓ×ȨÏÞ×¼Ôò £¬Óû§ºÍÈí¼þȨÏÞӦά³ÖÔÚ×îµÍÏÞ¶È¡£

l  ÆôÓÃÇ¿ÃÜÂëÕ½Êõ²¢ÉèÖÃΪ¶¨ÆÚÅú¸Ä¡£

3.4 ²Î¿¼Á´½Ó

https://www.postgresql.org/support/security/CVE-2024-7348/

https://www.postgresql.org/about/news/postgresql-164-158-1413-1316-1220-and-17-beta-3-released-2910/

 

ËÄ¡¢°æ±¾ÐÅÏ¢

°æ±¾

ÈÕÆÚ

±¸×¢

V1.0

2024-08-13

³õ´Î°ä²¼

 

  

Îå¡¢¸½Â¼

5.1 ±¦ÔËÀ³¹Ù·½ÍøÕ¾¼ò½é

±¦ÔËÀ³¹Ù·½ÍøÕ¾³ÉÁ¢ÓÚ1996Äê £¬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ´´½¨µÄ¡¢Õ¼ÓÐÆëÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢°²È«¸ß¿Æ¼¼ÆóÒµ¡£ÊǹúÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢°²È«²úÆ·¡¢°²È«·þÎñ½â¾ö¹æ»®µÄÁ캽ÆóÒµÖ®Ò»¡£

¹«Ë¾×ܲ¿Î»ÓÚ±±¾©ÊÐÖйشåÈí¼þÔ°±¦ÔËÀ³¹Ù·½ÍøÕ¾´óÏà £¬¹«Ë¾Ô±¹¤6000ÓàÈË £¬Ñз¢ÍŶÓ1200ÓàÈË, ¼¼Êõ·þÎñÍŶÓ1300ÓàÈË¡£ÔÚÈ«¹ú¸÷Ê¡¡¢ÊÓ×¢×ÔÖÎÇøÉèÁ¢·ÖÖ§»ú¹¹ÁùÊ®¶à¸ö £¬Õ¼Óи²¸ÇÈ«¹úµÄÏúÊÛϵͳ¡¢Çþ·ϵͳºÍ¼¼ÊõÖ§³Öϵͳ¡£¹«Ë¾ÓÚ2010Äê6ÔÂ23ÈÕÔÚÀö½­ÖÐÓ×°å¹ÒÅÆÉÏÊС££¨¹ÉƱ´úÂ룺002439£©

¶àÄêÀ´ £¬±¦ÔËÀ³¹Ù·½ÍøÕ¾ÖÂÁ¦ÓÚÌṩӵÓйú¼Ê¾ºÕùÁ¦µÄ×ÔÖ÷´´Ðµİ²È«²úÆ·ºÍ×î¼Ñʵ¼Ê·þÎñ £¬Ô®ÊÖ¿Í»§È«ÃæÌáÉýÆäIT»ù´¡ÉèÊ©µÄ°²È«ÐԺͳö²úЧÁ¦ £¬Îª´òÔìºÍÌáÉý¹ú¼Ê»¯µÄÃñ×åÐÅÏ¢°²È«²úÒµÁì¾üÆ·ÅÆ¶ø²»Ð¸ÖÂÁ¦¡£

5.2 ¹ØÓÚ±¦ÔËÀ³¹Ù·½ÍøÕ¾

±¦ÔËÀ³¹Ù·½ÍøÕ¾°²È«Ó¦¼±ÏìÓ¦ÖÐÐÄÒѰ䲼1000¶à¸ö·ì϶¹«¸æÎ¢·çÏÕÔ¤¾¯ £¬ÎÒÃǽ«³ÖÐø¸ú×ÙÈ«Çò×îеÄÍøÂ簲ȫÊÂÎñºÍ·ì϶ £¬ÎªÆóÒµµÄÐÅÏ¢°²È«±£¼Ý»¤º½¡£

¹Ø×¢ÎÒÃÇ£º

image.png