¡¾Îó²îͨ¸æ¡¿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