WordPress Core SQL×¢ÈëÎó²î(CVE-2022¨C21661)ÆÊÎö

Ðû²¼Ê±¼ä 2022-01-25

Îó²î¸ÅÊö


WordPressÊÇÏÖÔÚÈ«ÇòÊ¢ÐеÄÈý´óÄÚÈÝÖÎÀíϵͳ֮һ£¬£¬£¬Æä½¹µãÄ£¿£¿£¿£¿£¿£¿é£¨Core£©·ºÆðÎó²îµÄÇéÐÎÏà¶Ô½ÏÉÙ¡£¡£¡£¡£¡£¡£½üÆÚ£¬£¬£¬WordPress½¹µãÄ£¿£¿£¿£¿£¿£¿é±»Åû¶±£´æÒ»´¦SQL×¢ÈëÎó²î(CVE-2022¨C21661)¡£¡£¡£¡£¡£¡£Õë¶Ô¸Ã¸ßΣÎó²î£¬£¬£¬bevictorΰµÂADLabÑо¿Ô±µÚһʱ¼ä¾ÙÐÐÁËÏêϸÆÊÎöºÍÑéÖ¤¡£¡£¡£¡£¡£¡£


ÊÜÓ°Ïì°æ±¾


ÊÜÓ°Ïì°æ±¾£ºWordPress < 5.8.3


Îó²îÆÊÎö


ͨ¹ý½ÏÁ¿githubÉϵÄÔ´´úÂ룬£¬£¬¿ÉÒÔ·¢Ã÷Îó²îµÄλÖÃÊÇclean_queryº¯Êý¡£¡£¡£¡£¡£¡£ÔÚ5.8.2¼°Ö®Ç°µÄÀϰ汾ÖУ¬£¬£¬¸Ãº¯ÊýµÄÒªº¦´úÂëÈçÏ¡£¡£¡£¡£¡£¡£


´úÂëÈçÏÂ.png


ÔÚclean_queryº¯ÊýÖУ¬£¬£¬µ±×ª´ï½øÀ´µÄ$queryÖª×ãÒÔÏÂÁ½¸öÌõ¼þ£º

$query['taxonomy']Ϊ¿Õ£»£»

$query['filed']µÄÖµ¼´ÊÇterm_taxonomy_id¡£¡£¡£¡£¡£¡£


WordPressµÄÖ´ÐÐ¾Í»á½øÈë580ÐУ¬£¬£¬Å²ÓÃtransform_queryº¯Êý¡£¡£¡£¡£¡£¡£¸ú½ø¸Ãº¯Êý£¬£¬£¬Öª×ã602ÐУ¬£¬£¬²»×öÈκβ½·¥Ö±½Óreturn£¬£¬£¬¼á³ÖÁËtermsµÄÖµ²»Êܸı䡣¡£¡£¡£¡£¡£


´úÂëÈçÏÂ.png


È«¾ÖËÑË÷clean_query£¬£¬£¬Æä±»get_sql_for_clauseº¯ÊýŲÓᣡ£¡£¡£¡£¡£ÔĶÁ¸ÃÒªÁìµÄ´úÂë¿ÉÖª£¬£¬£¬ËüµÄ¹¦Ð§ÊÇΪsqlÅÌÎÊÖеÄÌõ¼þ½¨Éè×Ӿ䡣¡£¡£¡£¡£¡£ÏêϸÀ´Ëµ£¬£¬£¬ËüµÄÊÂÇéÊÇ´¦Öóͷ£ÎüÊÕµ½µÄÊý¾Ý£¬£¬£¬½«ÕâЩÊý¾Ý×éºÏ³ÉSQL ÅÌÎÊÖеÄÌõ¼þ£¬£¬£¬È»ºó½«Æä·µ»Ø¸ø¸¸º¯Êý¡£¡£¡£¡£¡£¡£ÒÔÊÇ£¬£¬£¬ÈôÊÇ¿ÉÒÔ¿ØÖÆclean_queryµÄ·µ»ØÊý¾Ý£¬£¬£¬¾Í¿ÉÒÔ¿ØÖÆSQLÅÌÎʾÙÐÐ×¢Èë¡£¡£¡£¡£¡£¡£


ÔÚget_sql_for_clauseÖпÉÒÔÕÒµ½$terms±äÁ¿±»Æ´½Óµ½sqlÓï¾äÖС£¡£¡£¡£¡£¡£


´úÂëÈçÏÂ.png


´Óget_sql_for_clauseÒªÁì¼ÌÐø»ØËÝ£¬£¬£¬Å²ÓÃÕ»ÈçÏ£º


´úÂëÈçÏÂ.png


ÔÚget_posts()ÖпÉÒÔÕÒµ½¶ÔWQ_Tax_Query->get_sql()µÄŲÓᣡ£¡£¡£¡£¡£


´úÂëÈçÏÂ.png


ͨ¹ý»ØËÝŲÓÃÕ»¿ÉÖª£¬£¬£¬Í¨¹ý¿ØÖÆWP_Query->__construct()ÖеÄÊôÐÔ£¬£¬£¬¾Í¿ÉÒÔÔì³Ésql×¢Èë¡£¡£¡£¡£¡£¡£


Îó²î¸´ÏÖ


̫ͨ¹ýÎöWordPressµÄÔ´Âë·¢Ã÷£¬£¬£¬WordPress½¹µã´úÂëÖв»±£´æ¿ÉÒÔ´¥·¢¸ÃÎó²îµÄŲÓõ㡣¡£¡£¡£¡£¡£ÎªÁËÑéÖ¤¸ÃÎó²î£¬£¬£¬ÕâÀïʹÓÃÁËEle Custom Skin²å¼þ×öÎó²î¸´ÏÖ£¬£¬£¬ÕâÒ²ÊÇZDI¸ø³öµÄ±£´æ±¬·¢Îó²îŲÓõIJå¼þÑùÀý¡£¡£¡£¡£¡£¡£


EleCustom Skin²å¼þ×°ÖÃÁ¿ÔÚ10ÍòÒÔÉÏ£¬£¬£¬ÇÒÆä±£´æµÄÎó²îŲÓÃÊÇÎÞÐèµÇ¼µÄ¡£¡£¡£¡£¡£¡£¸Ã²å¼þ±£´æÒªÁìget_document_data()£¬£¬£¬Æä½¹µã´úÂëÈçÏ£º


´úÂëÈçÏÂ.png

´úÂëÈçÏÂ.png 

È«¾ÖËÑË÷get_document_data£¬£¬£¬¸ÃÒªÁì±»×¢²áµÄactionÃû×ÖÈçÏ¡£¡£¡£¡£¡£¡£


´úÂëÈçÏÂ.png


Òò´Ë£¬£¬£¬¸ÃÎó²îÔÚÕâ¸ö²å¼þÊDZ£´æ´¥·¢Â·¾¶µÄ¡£¡£¡£¡£¡£¡£¿£¿£¿£¿£¿£¿ªÆôdebug¹¦Ð§ºó£¬£¬£¬½á¹¹±¨Îļ´¿ÉÀÖ³É×¢Èë³öÊý¾Ý¿âuser¡£¡£¡£¡£¡£¡£


´úÂëÈçÏÂ.png


Ê¢Ðвå¼þÆÊÎö


ΪÁËÆÊÎö¸ÃÎó²îµÄÏÖʵӰÏ죬£¬£¬ADLabÑо¿Ô±»¹¶ÔWordPressǰ100¸öÊ¢Ðвå¼þ¾ÙÐÐÁËÆÊÎö£¬£¬£¬·¢Ã÷ÆäÖÐ2¸ö²å¼þÒ²±£´æ¸ÃÎó²î¡£¡£¡£¡£¡£¡£


¿ªÆôdebug£¬£¬£¬½á¹¹±¨Îļ´¿ÉÀÖ³É×¢Èë³öÊý¾Ý¿âuser¡£¡£¡£¡£¡£¡£


ÐÞ¸´¼Æ»®


ÏÖÔÚWordPressÒÑÐû²¼Éý¼¶²¹¶¡ÒÔÐÞ¸´Îó²î£¬£¬£¬²¹¶¡»ñÈ¡Á´½ÓÈçÏ£º


https://github.com/WordPress/wordpress-develop/security/advisories/GHSA-6676-cqfm-gw84


²Î¿¼Á´½Ó£º

https://www.zerodayinitiative.com/blog/2022/1/18/cve-2021-21661-exposing-database-info-via-wordpress-sql-injection