¡¾Îó²îͨ¸æ¡¿PostgreSQL JDBC Driver SQL×¢ÈëÎó²î£¨CVE-2022-31197£©
Ðû²¼Ê±¼ä 2022-08-240x00 Îó²î¸ÅÊö
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 ¸½Â¼
ÈËÉú¾ÍÊDz©¼ò½é
ÈËÉú¾ÍÊDz©½¨ÉèÓÚ1996Ä꣬£¬£¬£¬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ½¨ÉèµÄ¡¢ÓµÓÐÍêÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢Çå¾²¸ß¿Æ¼¼ÆóÒµ¡£¡£¡£ÊǺ£ÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢Çå¾²²úÆ·¡¢Ç徲ЧÀͽâ¾ö¼Æ»®µÄÁ캽ÆóÒµÖ®Ò»¡£¡£¡£
¹«Ë¾×ܲ¿Î»ÓÚ±±¾©ÊÐÖйشåÈí¼þÔ°ÈËÉú¾ÍÊDz©´óÏ㬣¬£¬£¬¹«Ë¾Ô±¹¤½ü4000ÈË£¬£¬£¬£¬Ñз¢ÍŶÓ1200ÓàÈË, ÊÖÒÕЧÀÍÍŶÓ1300ÓàÈË¡£¡£¡£ÔÚÌìϸ÷Ê¡¡¢ÊС¢×ÔÖÎÇøÉèÁ¢·ÖÖ§»ú¹¹ÁùÊ®¶à¸ö£¬£¬£¬£¬ÓµÓÐÁýÕÖÌìϵÄÏúÊÛϵͳ¡¢ÇþµÀϵͳºÍÊÖÒÕÖ§³Öϵͳ¡£¡£¡£¹«Ë¾ÓÚ2010Äê6ÔÂ23ÈÕÔÚÉîÛÚÖÐС°å¹ÒÅÆÉÏÊС£¡£¡££¨¹ÉƱ´úÂ룺002439£©
¶àÄêÀ´£¬£¬£¬£¬ÈËÉú¾ÍÊDz©ÖÂÁ¦ÓÚÌṩ¾ßÓйú¼Ê¾ºÕùÁ¦µÄ×ÔÖ÷Á¢ÒìµÄÇå¾²²úÆ·ºÍ×î¼Ñʵ¼ùЧÀÍ£¬£¬£¬£¬×ÊÖú¿Í»§ÖÜÈ«ÌáÉýÆäIT»ù´¡ÉèÊ©µÄÇå¾²ÐÔºÍÉú²úЧÄÜ£¬£¬£¬£¬Îª´òÔìºÍÌáÉý¹ú¼Ê»¯µÄÃñ×åÐÅÏ¢Çå¾²¹¤ÒµÁì¾üÆ·ÅÆ¶ø²»Ð¸Æð¾¢¡£¡£¡£
¹ØÓÚÈËÉú¾ÍÊDz©
ÈËÉú¾ÍÊDz©Çå¾²Ó¦¼±ÏìÓ¦ÖÐÐÄÖ÷ÒªÕë¶ÔÖ÷ÒªÇå¾²Îó²îµÄÔ¤¾¯¡¢¸ú×ٺͷÖÏíÈ«Çò×îеÄÍþвÇ鱨ºÍÇå¾²±¨¸æ¡£¡£¡£
¹Ø×¢ÒÔϹ«Öںţ¬£¬£¬£¬»ñȡȫÇò×îÐÂÇå¾²×ÊѶ£º



¾©¹«Íø°²±¸11010802024551ºÅ