¡¾Â©¶´Í¨¸æ¡¿pgjdbc SQL ×¢È멶´£¨CVE-2024-1597£©
Ðû²¼Ê±¼ä 2024-02-21Ò»¡¢Â©¶´¸ÅÊö
©¶´Ãû³Æ | PgJDBC SQL ×¢È멶´ | ||
CVE ID | CVE-2024-1597 | ||
©¶´ÀàÐÍ | SQL×¢Èë | ·¢ÏÖʱ¼ä | 2024-02-21 |
©¶´ÆÀ·Ö | 10.0 | ©¶´Æ·¼¶ | ÑÏÖØ |
¹¥»÷ÏòÁ¿ | ÍøÂç | ËùÐèȨÏÞ | ÎÞ |
ÀûÓÃÄÑ¶È | µÍ | Óû§½»»¥ | ÎÞ |
PoC/EXP | ÒѹûÈ» | ÔÚÒ°ÀûÓà | δ֪ |
PostgreSQL JDBC Driver£¨¼ò³Æ PgJDBC£©ÔÊÐíJava ·¨Ê½Ê¹Óó߶ȵġ¢¶ÀÁ¢ÓÚÊý¾Ý¿âµÄ Java ´úÂëÁ¬½Óµ½ PostgreSQL Êý¾Ý¿â¡£
2024Äê2ÔÂ21ÈÕ£¬¶¶È¦Îª¶Ä¶øÉúVSRC¼à²âµ½PgJDBCÖдæÔÚÒ»¸öSQL×¢È멶´£¨CVE-2024-1597£©£¬¸Ã©¶´µÄCVSSv3ÆÀ·ÖΪ10.0¡£
PgJDBCÊÜÓ°Ïì°æ±¾ÖУ¬µ±Ê¹Óüòµ¥²éѯģʽ£¨PreferQueryMode=SIMPLE£¬·ÇĬÈÏģʽ£©Ê±´æÔÚSQL×¢È멶´£¬µ±SQL°ó¶¨Õ¼Î»·û´øÓУ¨-£©Ç°×ºÊ±£¬¸ºÖµµÄÖ±½ÓÌæ»»¿ÉÄܵ¼ÖÂÉú³ÉµÄ±êÖ¾±»ÊÓΪÐÐ×¢ÊÍ£¨È磺SELECT -?, ?£©£¬Èç¹ûµÚÒ»¸öÊýֵռλ·ûµÄ²ÎÊýֵΪ¸ºÖµ£¨Èç -1£¬-123µÈ£©ÇÒµÚ¶þ¸ö×Ö·û´®ÖµÕ¼Î»·ûµÄ²ÎÊýÖдøÓл»ÐзûµÄ¶ñÒâÎı¾¿ÉÄܵ¼ÖÂÃüÁîÖ´ÐС£ÍþвÕß¿ÉÀûÓø鶴ִÐÐSQL×¢Èë¹¥»÷£¬ÀÖ³ÉÀûÓø鶴¿ÉÄܵ¼Ö»ñÈ¡Ãô¸ÐÐÅÏ¢»òÖ´ÐÐδÊÚȨ²Ù×÷µÈ¡£
¶þ¡¢Ó°Ï췶Χ
42.7.0<=PgJDBC°æ±¾< 42.7.2
42.6.0<=PgJDBC°æ±¾< 42.6.1
42.5.0<=PgJDBC°æ±¾< 42.5.5
42.4.0<=PgJDBC°æ±¾< 42.4.4
42.3.0<=PgJDBC°æ±¾< 42.3.9
PgJDBC°æ±¾< 42.2.8
Èý¡¢Äþ¾²´ëÊ©
3.1 Éý¼¶°æ±¾
Ä¿Ç°¹Ù·½ÒѾÐû²¼Á˸鶴µÄ²¹¶¡£¬ÊÜÓ°ÏìÓû§¿ÉÓ¦Óò¹¶¡»ò´ýÐÞ¸´°æ±¾Ðû²¼Ê±Éý¼¶µ½PgJDBC°æ±¾42.7.2¡¢42.6.1¡¢42.5.5¡¢42.4.4¡¢42.3.9 ºÍ 42.2.8¡£
ÏÂÔØÁ´½Ó£º
https://jdbc.postgresql.org/download/
3.2 ÁÙʱ´ëÊ©
ÔÝÎÞ¡£
3.3 ͨÓý¨Òé
l ¶¨ÆÚ¸üÐÂϵͳ²¹¶¡£¬¼õÉÙϵͳ©¶´£¬ÌáÉý·þÎñÆ÷µÄÄþ¾²ÐÔ¡£
l ¼ÓǿϵͳºÍÍøÂçµÄ·ÃÎÊ¿ØÖÆ£¬Ð޸ķÀ»ðǽ¼Æı£¬¹Ø±Õ·ÇÐëÒªµÄÓ¦Óö˿ڻò·þÎñ£¬¼õÉÙ½«Î£ÏÕ·þÎñ£¨ÈçSSH¡¢RDPµÈ£©Ì»Â¶µ½¹«Íø£¬¼õÉÙ¹¥»÷Ãæ¡£
l ʹÓÃÆóÒµ¼¶Äþ¾²²úÎÌáÉýÆóÒµµÄÍøÂçÄþ¾²ÐÔÄÜ¡£
l ¼ÓǿϵͳÓû§ºÍȨÏÞ¹ÜÀí£¬ÆôÓöàÒòËØÈÏÖ¤»úÖƺÍ×îСȨÏÞÔÔò£¬Óû§ºÍÈí¼þȨÏÞÓ¦±£³ÖÔÚ×îµÍÏ޶ȡ£
l ÆôÓÃÇ¿ÃÜÂë¼Æı²¢ÉèÖÃΪ¶¨ÆÚÐ޸ġ£
3.4 ²Î¿¼Á´½Ó
https://github.com/pgjdbc/pgjdbc/commit/93b0fcb2711d9c1e3a2a03134369738a02a58b40
https://github.com/pgjdbc/pgjdbc/security/advisories/GHSA-24rp-q3w6-vc56
https://nvd.nist.gov/vuln/detail/CVE-2024-1597
ËÄ¡¢°æ±¾ÐÅÏ¢
°æ±¾ | ÈÕÆÚ | ±¸×¢ |
V1.0 | 2024-02-21 | Ê×´ÎÐû²¼ |
Îå¡¢¸½Â¼
5.1 ¶¶È¦Îª¶Ä¶øÉú¼ò½é
¶¶È¦Îª¶Ä¶øÉú½¨Á¢ÓÚ1996Ä꣬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ´´½¨µÄ¡¢ÓµÓÐÍêÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢Äþ¾²¸ß¿Æ¼¼ÆóÒµ¡£ÊǹúÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢Äþ¾²²úÎï¡¢Äþ¾²·þÎñ½â¾ö·½°¸µÄÁ캽ÆóÒµÖ®Ò»¡£
¹«Ë¾×ܲ¿Î»ÓÚ±±¾©ÊÐÖйشåÈí¼þÔ°¶¶È¦Îª¶Ä¶øÉú´óÏ㬹«Ë¾Ô±¹¤6000ÓàÈË£¬Ñз¢ÍŶÓ1200ÓàÈË, ¼¼Êõ·þÎñÍŶÓ1300ÓàÈË¡£ÔÚÈ«¹ú¸÷Ê¡¡¢ÊС¢×ÔÖÎÇøÉèÁ¢·ÖÖ§»ú¹¹ÁùÊ®¶à¸ö£¬ÓµÓÐÁýÕÖÈ«¹úµÄÏúÊÛÌåϵ¡¢ÇþµÀÌåϵºÍ¼¼ÊõÖ§³ÖÌåϵ¡£¹«Ë¾ÓÚ2010Äê6ÔÂ23ÈÕÔÚÉîÛÚÖÐС°å¹ÒÅÆÉÏÊС££¨¹ÉƱ´úÂ룺002439£©
¶àÄêÀ´£¬¶¶È¦Îª¶Ä¶øÉúÖÂÁ¦ÓÚÌṩ¾ßÓйú¼Ê¾ºÕùÁ¦µÄ×ÔÖ÷´´ÐµÄÄþ¾²²úÎïºÍ×î¼Ñʵ¼ù·þÎñ£¬×ÊÖú¿Í»§È«ÃæÌáÉýÆäIT»ù´¡ÉèÊ©µÄÄþ¾²ÐÔºÍÉú²úЧÄÜ£¬Îª´òÔìºÍÌáÉý¹ú¼Ê»¯µÄÃñ×åÐÅÏ¢Äþ¾²¹¤ÒµÁì¾üÆ·Åƶø²»Ð¸Å¬Á¦¡£
5.2 ¹ØÓÚ¶¶È¦Îª¶Ä¶øÉú
¶¶È¦Îª¶Ä¶øÉúÄþ¾²Ó¦¼±ÏìÓ¦ÖÐÐÄÒÑÐû²¼1000¶à¸ö©¶´Í¨¸æºÍ·çÏÕÔ¤¾¯£¬ÎÒÃǽ«Á¬Ðø¸ú×ÙÈ«Çò×îеÄÍøÂçÄþ¾²Ê¼þºÍ©¶´£¬ÎªÆóÒµµÄÐÅÏ¢Äþ¾²±£¼Ý»¤º½¡£
¹Ø×¢ÎÒÃÇ£º