¡¾Îó²îͨ¸æ¡¿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ÈÕ£¬£¬ £¬£¬£¬¿­Ê±K66VSRC¼à²âµ½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 ¿­Ê±K66¼ò½é

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

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

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

5.2 ¹ØÓÚ¿­Ê±K66

¿­Ê±K66Çå¾²Ó¦¼±ÏìÓ¦ÖÐÐÄÒÑÐû²¼1000¶à¸öÎó²îͨ¸æºÍΣº¦Ô¤¾¯£¬£¬ £¬£¬£¬ÎÒÃǽ«Ò»Á¬¸ú×ÙÈ«Çò×îеÄÍøÂçÇå¾²ÊÂÎñºÍÎó²î£¬£¬ £¬£¬£¬ÎªÆóÒµµÄÐÅÏ¢Çå¾²±£¼Ý»¤º½¡£¡£¡£¡£

¹Ø×¢ÎÒÃÇ£º

image.png