¡¾Îó²îͨ¸æ¡¿PostgreSQL JDBC Driver SQL×¢ÈëÎó²î£¨CVE-2022-31197£©

Ðû²¼Ê±¼ä 2022-08-24

0x00 Îó²î¸ÅÊö

CVE   ID

CVE-2022-31197

·¢Ã÷ʱ¼ä

2022-08-23

Àà    ÐÍ

SQL×¢Èë

µÈ    ¼¶

ÖÐΣ

Ô¶³ÌʹÓÃ

ÊÇ

Ó°Ïì¹æÄ£


¹¥»÷ÖØÆ¯ºó

¸ß

Óû§½»»¥

ÊÇ

PoC/EXP


ÔÚҰʹÓÃ


 

0x01 Îó²îÏêÇé

PostgreSQL JDBC Driver£¨¼ò³Æ PGJDBC£©ÊÇÒ»¸öÓà Pure Java£¨Type 4£©±àдµÄ¿ªÔ´JDBCÇý¶¯³ÌÐò£¬£¬£¬£¬£¬£¬£¬ÔÊÐíJava ³ÌÐòʹÓñê×¼µÄ¡¢×ÔÁ¦ÓÚÊý¾Ý¿âµÄJava´úÂëÅþÁ¬µ½ PostgreSQL Êý¾Ý¿â¡£¡£¡£

8ÔÂ3ÈÕ£¬£¬£¬£¬£¬£¬£¬PGJDBC±»Åû¶±£´æÒ»¸öSQL×¢ÈëÎó²î£¨CVE-2022-31197£©£¬£¬£¬£¬£¬£¬£¬ÆäCVSSÆÀ·ÖΪ5.9¡£¡£¡£

ÓÉÓÚjava.sql.ResultRow.refreshRow()ÒªÁìµÄPGJDBCʵÏÖûÓжÔÁÐÃû¾ÙÐÐתÒ壬£¬£¬£¬£¬£¬£¬Òò´Ëµ±¶ñÒâÁÐÃûÖаüÀ¨Óï¾äÖÕÖ¹·û£¬£¬£¬£¬£¬£¬£¬Èç¡°;¡±Ê±ÔÚijЩÇéÐÎÏ¿ÉÄܵ¼ÖÂSQL ×¢È룬£¬£¬£¬£¬£¬£¬ÀÖ³ÉʹÓôËÎó²î½«Äܹ»ÒÔÓ¦ÓóÌÐòµÄJDBCÓû§Éí·ÝÖ´ÐÐSQL ÏÂÁî¡£¡£¡£

 

Ó°Ïì¹æÄ£

PostgreSQL JDBC Driver < 42.2.26

42.3.0 <= PostgreSQL JDBC Driver < 42.4.1

×¢£º²»Å²ÓÃResultSet.refreshRow()ÒªÁìµÄÓû§Ó¦ÓóÌÐò²»ÊÜÓ°Ïì¡£¡£¡£


0x02 Çå¾²½¨Òé

ÏÖÔÚ´ËÎó²îÒѾ­ÐÞ¸´£¬£¬£¬£¬£¬£¬£¬ÊÜÓ°ÏìÓû§¿ÉÉý¼¶µ½PostgreSQL JDBC Driver °æ±¾42.2.26¡¢42.4.1»ò¸ü¸ß°æ±¾¡£¡£¡£

ÏÂÔØÁ´½Ó£º

https://jdbc.postgresql.org/download.html

 

0x03 ²Î¿¼Á´½Ó

https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-r38f-c4h4-hqq2

https://nvd.nist.gov/vuln/detail/CVE-2022-31197

 

0x04 °æ±¾ÐÅÏ¢

°æ±¾

ÈÕÆÚ

ÐÞ¸ÄÄÚÈÝ

V1.0

2022-08-24

Ê×´ÎÐû²¼

 

0x05 ¸½Â¼

¼øºÚµ£±£Íø¼ò½é

¼øºÚµ£±£Íø½¨ÉèÓÚ1996Ä꣬£¬£¬£¬£¬£¬£¬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ½¨ÉèµÄ¡¢ÓµÓÐÍêÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢Çå¾²¸ß¿Æ¼¼ÆóÒµ¡£¡£¡£ÊǺ£ÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢Çå¾²²úÆ·¡¢Ç徲ЧÀͽâ¾ö¼Æ»®µÄÁ캽ÆóÒµÖ®Ò»¡£¡£¡£

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

¶àÄêÀ´£¬£¬£¬£¬£¬£¬£¬¼øºÚµ£±£ÍøÖÂÁ¦ÓÚÌṩ¾ßÓйú¼Ê¾ºÕùÁ¦µÄ×ÔÖ÷Á¢ÒìµÄÇå¾²²úÆ·ºÍ×î¼Ñʵ¼ùЧÀÍ£¬£¬£¬£¬£¬£¬£¬×ÊÖú¿Í»§ÖÜÈ«ÌáÉýÆäIT»ù´¡ÉèÊ©µÄÇå¾²ÐÔºÍÉú²úЧÄÜ£¬£¬£¬£¬£¬£¬£¬Îª´òÔìºÍÌáÉý¹ú¼Ê»¯µÄÃñ×åÐÅÏ¢Çå¾²¹¤ÒµÁì¾üÆ·ÅÆ¶ø²»Ð¸Æð¾¢¡£¡£¡£

 

¹ØÓÚ¼øºÚµ£±£Íø

¼øºÚµ£±£ÍøÇå¾²Ó¦¼±ÏìÓ¦ÖÐÐÄÖ÷ÒªÕë¶ÔÖ÷ÒªÇå¾²Îó²îµÄÔ¤¾¯¡¢¸ú×ٺͷÖÏíÈ«Çò×îеÄÍþвÇ鱨ºÍÇå¾²±¨¸æ¡£¡£¡£

¹Ø×¢ÒÔϹ«Öںţ¬£¬£¬£¬£¬£¬£¬»ñȡȫÇò×îÐÂÇå¾²×ÊѶ£º

image.png