¡¾Îó²îͨ¸æ¡¿Apache Submarine SQL×¢ÈëÎó²î£¨CVE-2023-37924£©

Ðû²¼Ê±¼ä 2023-11-23


Ò»¡¢Îó²î¸ÅÊö

CVE   ID

CVE-2023-37924

·¢Ã÷ʱ¼ä

2023-11-23

Àà    ÐÍ

SQL×¢Èë

µÈ    ¼¶

¸ßΣ

¹¥»÷ÏòÁ¿

ÍøÂç

ËùÐèȨÏÞ

ÎÞ

¹¥»÷ÖØÆ¯ºó

µÍ

Óû§½»»¥

ÎÞ

PoC/EXP

δ¹ûÕæ

ÔÚҰʹÓÃ

δ·¢Ã÷

 

Apache SubmarineÊÇÒ»¸öÊÇÔÆÔ­ÉúÆøÐµÑ§Ï°Æ½Ì¨£¬£¬£¬ £¬£¬£¬ÔÊÐí½¨Éè¶Ëµ½¶Ë»úеѧϰÊÂÇéÁ÷³Ì£¬£¬£¬ £¬£¬£¬Í¨¹ýSubmarine¿ÉÒÔÍê³ÉML Ä£×ÓÉúÃüÖÜÆÚµÄÿ¸ö½×¶Î£¬£¬£¬ £¬£¬£¬°üÀ¨Êý¾Ý̽Ë÷¡¢Êý¾Ý¹ÜµÀ½¨É衢ģ×ÓѵÁ·¡¢Ð§ÀÍºÍ¼à¿Ø¡£¡£¡£¡£¡£¡£¡£

11ÔÂ23ÈÕ£¬£¬£¬ £¬£¬£¬¼øºÚµ£±£ÍøVSRC¼à²âµ½Apache SubmarineÖÐÐÞ¸´ÁËÒ»¸öSQL×¢ÈëÎó²î£¨CVE-2023-37924£©¡£¡£¡£¡£¡£¡£¡£

Apache Submarine °æ±¾0.7.0 - 0.8.0֮ǰ±£´æSQL ×¢ÈëÎó²î£¬£¬£¬ £¬£¬£¬ÓÉÓÚMybatisÖÐÄ£ºýÅÌÎʱÜÃâSQL×¢ÈëʱʹÓÃÁË${}£¨Ê¹ÓÃ×Ö·û´®Æ´½Ó£¬£¬£¬ £¬£¬£¬²»Çå¾²£©£¬£¬£¬ £¬£¬£¬µ±Ê¹ÓÃlikeÅÌÎÊʱ¿ÉÄܱ£´æÎó²î£¬£¬£¬ £¬£¬£¬Î´ÊÚȨÍþвÕß¿ÉʹÓøÃÎó²îÖ´ÐжñÒâSQLÓï¾ä£¬£¬£¬ £¬£¬£¬µ¼ÖÂδÊÚȨ»á¼û»òÖ´ÐжñÒâ²Ù×÷¡£¡£¡£¡£¡£¡£¡£

  

¶þ¡¢Ó°Ïì¹æÄ£

0.7.0<=Apache Submarine°æ±¾< 0.8.0

 

Èý¡¢Çå¾²²½·¥

3.1 Éý¼¶°æ±¾

¹Ù·½ÒÑͨ¹ý½«mybatisÖÐlikeÓï¾äµÄÏà¹Ø²¿·ÖÌæ»»Îªconcat('%', #{param}, '%')ÐÞ¸´Á˸ÃÎó²î£¬£¬£¬ £¬£¬£¬ÊÜÓ°ÏìÓû§¿ÉÉý¼¶µ½Apache Submarine°æ±¾0.8.0¡£¡£¡£¡£¡£¡£¡£

ÏÂÔØÁ´½Ó£º

https://submarine.apache.org/zh-cn/docs/download

3.2 ÔÝʱ²½·¥

ÔÝÎÞ¡£¡£¡£¡£¡£¡£¡£

3.3 ͨÓý¨Òé

l  °´ÆÚ¸üÐÂϵͳ²¹¶¡£¬£¬£¬ £¬£¬£¬ïÔ̭ϵͳÎó²î£¬£¬£¬ £¬£¬£¬ÌáÉýЧÀÍÆ÷µÄÇå¾²ÐÔ¡£¡£¡£¡£¡£¡£¡£

l  ÔöǿϵͳºÍÍøÂçµÄ»á¼û¿ØÖÆ£¬£¬£¬ £¬£¬£¬Ð޸ķÀ»ðǽսÂÔ£¬£¬£¬ £¬£¬£¬¹Ø±Õ·ÇÐëÒªµÄÓ¦Óö˿ڻòЧÀÍ£¬£¬£¬ £¬£¬£¬ïÔÌ­½«Î£ÏÕЧÀÍ£¨ÈçSSH¡¢RDPµÈ£©Ì»Â¶µ½¹«Íø£¬£¬£¬ £¬£¬£¬ïÔÌ­¹¥»÷Ãæ¡£¡£¡£¡£¡£¡£¡£

l  ʹÓÃÆóÒµ¼¶Çå¾²²úÆ·£¬£¬£¬ £¬£¬£¬ÌáÉýÆóÒµµÄÍøÂçÇå¾²ÐÔÄÜ¡£¡£¡£¡£¡£¡£¡£

l  ÔöǿϵͳÓû§ºÍȨÏÞÖÎÀí£¬£¬£¬ £¬£¬£¬ÆôÓöàÒòËØÈÏÖ¤»úÖÆºÍ×îСȨÏÞÔ­Ôò£¬£¬£¬ £¬£¬£¬Óû§ºÍÈí¼þȨÏÞÓ¦¼á³ÖÔÚ×îµÍÏÞ¶È¡£¡£¡£¡£¡£¡£¡£

l  ÆôÓÃÇ¿ÃÜÂëÕ½ÂÔ²¢ÉèÖÃΪ°´ÆÚÐ޸ġ£¡£¡£¡£¡£¡£¡£

3.4 ²Î¿¼Á´½Ó

https://lists.apache.org/thread/g99h773vd49n1wyghdq1llv2f83w1b3r

https://github.com/apache/submarine/pull/1037

https://issues.apache.org/jira/browse/SUBMARINE-1361

  

ËÄ¡¢°æ±¾ÐÅÏ¢

°æ±¾

ÈÕÆÚ

±¸×¢

V1.0

2023-11-23

Ê×´ÎÐû²¼

 

 

Îå¡¢¸½Â¼

5.1 ¼øºÚµ£±£Íø¼ò½é

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

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

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

5.2 ¹ØÓÚ¼øºÚµ£±£Íø

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

¹Ø×¢ÎÒÃÇ£º

image.png