¡¾·ì϶¹«¸æ¡¿ClickHouse DBMS 3Ô¶à¸ö°²È«·ì϶

°ä²¼¹¦·ò 2022-03-17


0x00 ·ì϶¸ÅÊö

2022Äê3ÔÂ15ÈÕ£¬£¬£¬£¬£¬JFrog °²È«×êÑÐÍŶÓÅû¶ÁËÔÚClickHouse DBMS Öз¢ÏÖµÄ 7 ¸ö RCE ºÍ DoS ·ì϶£¬£¬£¬£¬£¬ÕâЩ·ì϶¿ÉÄܵ¼ÖÂClickHouse ·þÎñÆ÷±ÀÀ£¡¢ÐÅϢй¶ÉõÖÁµ¼ÖÂÔ¶³Ì´úÂëÖ´ÐÐ (RCE)¡£¡£¡£¡£¡£¡£¡£¡£


0x01 ·ì϶ÏêÇé

ClickHouseÊÇÒ»¸ö¿í·ºÊ¹Óõġ¢ÓÃÓÚÔÚÏß·ÖÎö´¦Öà (OLAP)µÄ¿ªÔ´ÁÐʽÊý¾Ý¿âÖÎÀíϵͳ(DBMS)£¬£¬£¬£¬£¬Äܹ»ÊµÊ±ÌìÉú·ÖÎöÊý¾Ý»ã±¨¡£¡£¡£¡£¡£¡£¡£¡£

×êÑÐÈËÔ±±¾´ÎÅû¶µÄ7¸ö·ì϶ÈçÏ£º

l  CVE-2021-43304£º½âÎö¶ñÒâ²éÎÊʱ LZ4 ѹËõ±à½âÂëÆ÷ÖеĶѻº³åÇøÒç³ö£¨RCE£©£¬£¬£¬£¬£¬CVSSÆÀ·ÖΪ8.8¡£¡£¡£¡£¡£¡£¡£¡£

l  CVE-2021-43305£º½âÎö¶ñÒâ²éÎÊʱ LZ4 ѹËõ±à½âÂëÆ÷ÖеĶѻº³åÇøÒç³ö£¨RCE£©£¬£¬£¬£¬£¬CVSSÆÀ·ÖΪ8.8¡£¡£¡£¡£¡£¡£¡£¡£

l  CVE-2021-42387£º½âÎö¶ñÒâ²éÎÊʱÔÚ LZ4 ѹËõ±à½âÂëÆ÷ÖжÁÈ¡µÄ¶ÑÔ½½ç£¨»Ø¾ø·þÎñ»òÐÅϢй¶£©£¬£¬£¬£¬£¬CVSSÆÀ·ÖΪ7.1¡£¡£¡£¡£¡£¡£¡£¡£

l  CVE-2021-42388£º½âÎö¶ñÒâ²éÎÊʱÔÚ LZ4 ѹËõ±à½âÂëÆ÷ÖжÁÈ¡µÄ¶ÑÔ½½ç£¨»Ø¾ø·þÎñ»òÐÅϢй¶£©£¬£¬£¬£¬£¬CVSSÆÀ·ÖΪ7.1¡£¡£¡£¡£¡£¡£¡£¡£

l  CVE-2021-42389£º½âÎö¶ñÒâ²éÎÊʱÔÚ Delta ѹËõ±à½âÂëÆ÷ÖеijýÁã·ì϶£¨»Ø¾ø·þÎñ£©£¬£¬£¬£¬£¬CVSSÆÀ·ÖΪ6.5¡£¡£¡£¡£¡£¡£¡£¡£

l  CVE-2021-42390£º½âÎö¶ñÒâ²éÎÊʱÔÚ DeltaDouble ѹËõ±à½âÂëÆ÷ÖеijýÁã·ì϶£¨»Ø¾ø·þÎñ£©£¬£¬£¬£¬£¬CVSSÆÀ·ÖΪ6.5¡£¡£¡£¡£¡£¡£¡£¡£

l  CVE-2021-42391£º½âÎö¶ñÒâ²éÎÊʱÔÚ Gorilla ѹËõ±à½âÂëÆ÷ÖеijýÁã·ì϶£¨»Ø¾ø·þÎñ£©£¬£¬£¬£¬£¬CVSSÆÀ·ÖΪ6.5¡£¡£¡£¡£¡£¡£¡£¡£

×êÑÐÈËÔ±°µÊ¾£¬£¬£¬£¬£¬ÀûÓÃÕâЩ·ì϶±ØÒªÉí·ÝÑéÖ¤£¬£¬£¬£¬£¬µ«Äܹ»ÓÉÈκÎÓµÓжÁȡȨÏÞµÄÓû§´¥·¢¡£¡£¡£¡£¡£¡£¡£¡£

 

Ó°ÏìÁìÓò

ClickHouse°æ±¾ < v21.10.2.15-stable

 

0x02 ´ëÖý¨Òé

ĿǰÕâЩ·ì϶ÒѾ­½¨¸´£¬£¬£¬£¬£¬ÊÜÓ°ÏìÓû§Äܹ»Éý¼¶¸üе½ClickHouse v21.10.2.15-stable°æ±¾»ò¸ü¸ß°æ±¾¡£¡£¡£¡£¡£¡£¡£¡£

ÏÂÔØÁ´½Ó£º

https://github.com/ClickHouse/ClickHouse/releases/tag/v21.10.2.15-stable

»º½â´ëÊ©£º

ÈôÊÇÎÞ·¨Éý¼¶£¬£¬£¬£¬£¬ÇëÔÚ·þÎñÆ÷ÖÐÔö³¤·À»ðǽ¹æ¶¨£¬£¬£¬£¬£¬ÏÞ¶ÈÖ»ÔÊÐíÌØ¶¨¿Í»§¶Ë½Ó¼ûweb¶Ë¿Ú£¨8123£©ºÍTCP·þÎñÆ÷¶Ë¿Ú£¨9000£©¡£¡£¡£¡£¡£¡£¡£¡£

 

0x03 ²Î¿¼Á´½Ó

https://jfrog.com/blog/7-rce-and-dos-vulnerabilities-found-in-clickhouse-dbms/

https://github.com/ClickHouse/ClickHouse

https://thehackernews.com/2022/03/multiple-flaws-uncovered-in-clickhouse.html

 

0x04 ¸üа汾

°æ±¾

ÈÕÆÚ

Åú¸ÄÄÚÈÝ

V1.0

2022-03-17

³õ´Î°ä²¼

 

0x05 ¸½Â¼

8827Ì«Ñô¼¯Íżò½é

8827Ì«Ñô¼¯ÍŹ«Ë¾³ÉÁ¢ÓÚ1996Ä꣬£¬£¬£¬£¬²¢ÓÚ2010Äê6ÔÂ23ÈÕÔÚÉî½»ËùÖÐÓ×°åÕýʽ¹ÒÅÆÉÏÊУ¬£¬£¬£¬£¬ÊǹúÄÚ¼«¾ßʵÁ¦µÄ¡¢Õ¼ÓÐÆëÈ«×ÔÖ÷֪ʶ²úȨµÄÍøÂ簲ȫ²úÆ·¡¢¿ÉÐŰ²È«ÖÎÀíÆ½Ì¨¡¢°²È«·þÎñÓë½â¾ö¹æ»®µÄ×ÛºÏÌṩÉÌ¡£¡£¡£¡£¡£¡£¡£¡£

¹«Ë¾×ܲ¿Î»ÓÚ±±¾©ÊÐÖйشåÈí¼þÔ°£¬£¬£¬£¬£¬ÔÚÈ«¹ú¸÷Ê¡¡¢ÊÓ×¢×ÔÖÎÇøÉèÓзÖÖ§»ú¹¹£¬£¬£¬£¬£¬Õ¼Óи²¸ÇÈ«¹úµÄÇþ·ϵͳºÍ¼¼ÊõÖ§³ÖÖÐÐÄ£¬£¬£¬£¬£¬²¢ÔÚ±±¾©¡¢ÉϺ£¡¢³É¶¼¡¢ÕÑͨ¡¢³¤É³¡¢¾£ÃÅµÈ¶àµØÉèÓÐÑз¢ÖÐÐÄ¡£¡£¡£¡£¡£¡£¡£¡£

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

 

¹ØÓÚ8827Ì«Ñô¼¯ÍÅ

8827Ì«Ñô¼¯ÍŰ²È«Ó¦¼±ÏìÓ¦ÖÐÐÄÖØÒªÕë¶Ô³ÁÒª°²È«·ì϶µÄÔ¤¾¯¡¢¸ú×ٺͷÖÏíÈ«Çò×îеÄÍþвµý±¨ºÍ°²È«»ã±¨¡£¡£¡£¡£¡£¡£¡£¡£

¹Ø×¢ÒÔϹ«¼ÒºÅ£¬£¬£¬£¬£¬»ñȡȫÇò×îа²È«×ÊѶ£º

image.png