¡¾Â©¶´Í¨¸æ¡¿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