¡¾·ì϶¹«¸æ¡¿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ÈÕ£¬£¬£¬£¬£¬£¬8827Ì«Ñô¼¯ÍÅ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 8827Ì«Ñô¼¯Íżò½é
8827Ì«Ñô¼¯ÍųÉÁ¢ÓÚ1996Ä꣬£¬£¬£¬£¬£¬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ´´½¨µÄ¡¢Õ¼ÓÐÆëÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢°²È«¸ß¿Æ¼¼ÆóÒµ¡£¡£¡£¡£¡£¡£¡£ÊǹúÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢°²È«²úÆ·¡¢°²È«·þÎñ½â¾ö¹æ»®µÄÁ캽ÆóÒµÖ®Ò»¡£¡£¡£¡£¡£¡£¡£
¹«Ë¾×ܲ¿Î»ÓÚ±±¾©ÊÐÖйشåÈí¼þÔ°8827Ì«Ñô¼¯ÍÅ´óÏ㬣¬£¬£¬£¬£¬¹«Ë¾Ô±¹¤6000ÓàÈË£¬£¬£¬£¬£¬£¬Ñз¢ÍŶÓ1200ÓàÈË, ¼¼Êõ·þÎñÍŶÓ1300ÓàÈË¡£¡£¡£¡£¡£¡£¡£ÔÚÈ«¹ú¸÷Ê¡¡¢ÊÓ×¢×ÔÖÎÇøÉèÁ¢·ÖÖ§»ú¹¹ÁùÊ®¶à¸ö£¬£¬£¬£¬£¬£¬Õ¼Óи²¸ÇÈ«¹úµÄÏúÊÛϵͳ¡¢Çþ·ϵͳºÍ¼¼ÊõÖ§³Öϵͳ¡£¡£¡£¡£¡£¡£¡£¹«Ë¾ÓÚ2010Äê6ÔÂ23ÈÕÔÚÀö½ÖÐÓ×°å¹ÒÅÆÉÏÊС£¡£¡£¡£¡£¡£¡££¨¹ÉƱ´úÂ룺002439£©
¶àÄêÀ´£¬£¬£¬£¬£¬£¬8827Ì«Ñô¼¯ÍÅÖÂÁ¦ÓÚÌṩӵÓйú¼Ê¾ºÕùÁ¦µÄ×ÔÖ÷´´Ðµİ²È«²úÆ·ºÍ×î¼Ñʵ¼Ê·þÎñ£¬£¬£¬£¬£¬£¬Ô®ÊÖ¿Í»§È«ÃæÌáÉýÆäIT»ù´¡ÉèÊ©µÄ°²È«ÐԺͳö²úЧÁ¦£¬£¬£¬£¬£¬£¬Îª´òÔìºÍÌáÉý¹ú¼Ê»¯µÄÃñ×åÐÅÏ¢°²È«²úÒµÁì¾üÆ·ÅÆ¶ø²»Ð¸ÖÂÁ¦¡£¡£¡£¡£¡£¡£¡£
5.2 ¹ØÓÚ8827Ì«Ñô¼¯ÍÅ
8827Ì«Ñô¼¯ÍŰ²È«Ó¦¼±ÏìÓ¦ÖÐÐÄÒѰ䲼1000¶à¸ö·ì϶¹«¸æÎ¢·çÏÕÔ¤¾¯£¬£¬£¬£¬£¬£¬ÎÒÃǽ«³ÖÐø¸ú×ÙÈ«Çò×îеÄÍøÂ簲ȫÊÂÎñºÍ·ì϶£¬£¬£¬£¬£¬£¬ÎªÆóÒµµÄÐÅÏ¢°²È«±£¼Ý»¤º½¡£¡£¡£¡£¡£¡£¡£
¹Ø×¢ÎÒÃÇ£º



¾©¹«Íø°²±¸11010802024551ºÅ