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