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