¡¾·ì϶¹«¸æ¡¿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ÈÕ£¬GA»Æ½ð¼×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 GA»Æ½ð¼×¼ò½é

GA»Æ½ð¼×³ÉÁ¢ÓÚ1996Ä꣬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ´´½¨µÄ¡¢Õ¼ÓÐÆëÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢°²È«¸ß¿Æ¼¼ÆóÒµ¡£ÊǹúÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢°²È«²úÆ·¡¢°²È«·þÎñ½â¾ö¹æ»®µÄÁ캽ÆóÒµÖ®Ò»¡£

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

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

5.2 ¹ØÓÚGA»Æ½ð¼×

GA»Æ½ð¼×°²È«Ó¦¼±ÏìÓ¦ÖÐÐÄÒѰ䲼1000¶à¸ö·ì϶¹«¸æÎ¢·çÏÕÔ¤¾¯£¬ÎÒÃǽ«³ÖÐø¸ú×ÙÈ«Çò×îеÄÍøÂ簲ȫÊÂÎñºÍ·ì϶£¬ÎªÆóÒµµÄÐÅÏ¢°²È«±£¼Ý»¤º½¡£

¹Ø×¢ÎÒÃÇ£º

image.png