¡¾Â©¶´Í¨¸æ¡¿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¶à¸ö©¶´Í¨¸æºÍ·çÏÕÔ¤¾¯£¬ÎÒÃǽ«Á¬Ðø¸ú×ÙÈ«Çò×îеÄÍøÂçÄþ¾²Ê¼þºÍ©¶´£¬ÎªÆóÒµµÄÐÅÏ¢Äþ¾²±£¼Ý»¤º½¡£

¹Ø×¢ÎÒÃÇ£º

image.png