¡¾·ì϶¹«¸æ¡¿Gentoo Soko SQL×¢Èë·ì϶£¨CVE-2023-28424£©
°ä²¼¹¦·ò 2023-06-29Ò»¡¢·ì϶¸ÅÊö
CVE ID | CVE-2023-28424 | ·¢ÏÖ¹¦·ò | 2023-06-29 |
Àà ÐÍ | SQL×¢Èë | µÈ ¼¶ | ÑϳÁ |
¹¥»÷ÏòÁ¿ | ÍøÂç | ËùÐèȨÏÞ | ÎÞ |
¹¥»÷¸´ÔÓ¶È | µÍ | Óû§½»»¥ | ÎÞ |
PoC/EXP | ÔÚÒ°ÀûÓà | δ·¢ÏÖ |
Soko ÊÇÒ»¸öΪpackages.gentoo.orgÌṩ֧³ÖµÄGoÈí¼þÄ£¿£¿£¿£¿£¿£¿é£¬£¬£¬£¬£¬£¬£¬£¬ÎªÓû§ÌṩÁËÒ»ÖÖµ¥Ò»µÄ²½ÖèÀ´ËÑË÷¿ÉÓÃÓÚGentoo Linux ¿¯ÐаæµÄ·ÖÆçPortageÈí¼þ°ü¡£¡£¡£¡£¡£
6ÔÂ29ÈÕ£¬£¬£¬£¬£¬£¬£¬£¬8827Ì«Ñô¼¯ÍÅVSRC¼à²âµ½ SokoÖн¨¸´Á˶à¸öSQL×¢Èë·ì϶£¨Í³³ÆÎªCVE-2023-28424£©£¬£¬£¬£¬£¬£¬£¬£¬ÆäCVSSv3ÆÀ·ÖΪ9.1£¬£¬£¬£¬£¬£¬£¬£¬ÏêÇéÈçÏ£º
Gentoo Soko SQL×¢Èë·ì϶
Soko°æ±¾1.0.2 ֮ǰ£¬£¬£¬£¬£¬£¬£¬£¬ÔÚpkg/app/handler/packages/search.goÖÐʵÏÖµÄÁ½¸ö°üËÑË÷´¦Ö÷¨Ê½searchºÍSearchFeedÈÝÒ×Êܵ½Í¨¹ýq²ÎÊýÖ´ÐеÄSQL×¢Èë¹¥»÷£¬£¬£¬£¬£¬£¬£¬£¬¿ÉÄܵ¼ÖÂδ¾Éí·ÝÑéÖ¤µÄÍþвÕßÔÚhttps://packages.gentoo.org/ÉÏÖ´ÐÐËÁÒâ SQL ²éÎÊ£¬£¬£¬£¬£¬£¬£¬£¬³É¹¦ÀûÓø÷ì϶¿ÉÄܵ¼ÖÂÃô¸ÐÐÅϢй¶»òÔÚPostgreSQL ÈÝÆ÷µÄ¸ßµÍÎÄÖÐÖ´ÐдúÂë¡£¡£¡£¡£¡£
GraphiQL½âÎöÆ÷ PackageSearch SQL ×¢Èë·ì϶
Soko°æ±¾1.0.3֮ǰ£¬£¬£¬£¬£¬£¬£¬£¬ÔÚpkg/api/graphql/resolvers/resolver.goÖÐʵÏÖµÄGraphiQL½âÎöÆ÷PackageSearchÈÝÒ×Êܵ½Í¨¹ýsearchTerm²ÎÊýÖ´ÐеÄSQL×¢Èë¹¥»÷£¬£¬£¬£¬£¬£¬£¬£¬¿ÉÄܵ¼ÖÂδ¾Éí·ÝÑéÖ¤µÄÍþвÕßÔÚhttps://packages.gentoo.org/ÉÏÖ´ÐÐËÁÒâ SQL ²éÎÊ£¬£¬£¬£¬£¬£¬£¬£¬³É¹¦ÀûÓø÷ì϶¿ÉÄܵ¼ÖÂÃô¸ÐÐÅϢй¶»òÔÚPostgreSQL ÈÝÆ÷µÄ¸ßµÍÎÄÖÐÖ´ÐдúÂë¡£¡£¡£¡£¡£
¶þ¡¢Ó°ÏìÁìÓò
Gentoo Soko°æ±¾£º< 1.0.3
Èý¡¢°²È«´ëÊ©
3.1 Éý¼¶°æ±¾
ĿǰÕâЩ·ì϶ÒѾ½¨¸´£¬£¬£¬£¬£¬£¬£¬£¬ÊÜÓ°ÏìSokoÓû§¿ÉÉý¼¶µ½Soko°æ±¾£º>=1.0.3¡£¡£¡£¡£¡£
ÏÂÔØÁ´½Ó£º
https://github.com/gentoo/soko/tags
3.2 һʱ´ëÊ©
ÔÝÎÞ¡£¡£¡£¡£¡£
3.3 ͨÓý¨Òé
l ¶¨ÆÚ¸üÐÂϵͳ²¹¶¡£¡£¡£¡£¡£¬£¬£¬£¬£¬£¬£¬£¬Ï÷¼õϵͳ·ì϶£¬£¬£¬£¬£¬£¬£¬£¬ÌáÉý·þÎñÆ÷µÄ°²È«ÐÔ¡£¡£¡£¡£¡£
l ¼ÓǿϵͳºÍÍøÂçµÄ½Ó¼û½ÚÔ죬£¬£¬£¬£¬£¬£¬£¬Åú¸Ä·À»ðǽսÊõ£¬£¬£¬£¬£¬£¬£¬£¬¹Ø¹Ø·Ç±ØÒªµÄÀûÓö˿ڻò·þÎñ£¬£¬£¬£¬£¬£¬£¬£¬Ï÷¼õ½«Î£ÏÕ·þÎñ£¨ÈçSSH¡¢RDPµÈ£©Â¶³öµ½¹«Íø£¬£¬£¬£¬£¬£¬£¬£¬Ï÷¼õ¹¥»÷Ãæ¡£¡£¡£¡£¡£
l ʹÓÃÆóÒµ¼¶°²È«²úÆ·£¬£¬£¬£¬£¬£¬£¬£¬ÌáÉýÆóÒµµÄÍøÂ簲ȫ»úÄÜ¡£¡£¡£¡£¡£
l ¼ÓǿϵͳÓû§ºÍȨÏÞÖÎÀí£¬£¬£¬£¬£¬£¬£¬£¬ÆôÓöà³É·ÖÈÏÖ¤»úÔìºÍ×îÓ×ȨÏÞ×¼Ôò£¬£¬£¬£¬£¬£¬£¬£¬Óû§ºÍÈí¼þȨÏÞӦά³ÖÔÚ×îµÍÏÞ¶È¡£¡£¡£¡£¡£
l ÆôÓÃÇ¿ÃÜÂëÕ½Êõ²¢ÉèÖÃΪ¶¨ÆÚÅú¸Ä¡£¡£¡£¡£¡£
3.4 ²Î¿¼Á´½Ó
https://github.com/gentoo/soko/security/advisories/GHSA-gc2x-86p3-mxg2
https://github.com/gentoo/soko/security/advisories/GHSA-45jr-w89p-c843
https://www.sonarsource.com/blog/why-orms-and-prepared-statements-cant-always-win/
ËÄ¡¢°æ±¾ÐÅÏ¢
°æ±¾ | ÈÕÆÚ | ±¸×¢ |
V1.0 | 2023-06-29 | ³õ´Î°ä²¼ |
Îå¡¢¸½Â¼
5.1 8827Ì«Ñô¼¯Íżò½é
8827Ì«Ñô¼¯ÍųÉÁ¢ÓÚ1996Ä꣬£¬£¬£¬£¬£¬£¬£¬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ´´½¨µÄ¡¢Õ¼ÓÐÆëÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢°²È«¸ß¿Æ¼¼ÆóÒµ¡£¡£¡£¡£¡£ÊǹúÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢°²È«²úÆ·¡¢°²È«·þÎñ½â¾ö¹æ»®µÄÁ캽ÆóÒµÖ®Ò»¡£¡£¡£¡£¡£
¹«Ë¾×ܲ¿Î»ÓÚ±±¾©ÊÐÖйشåÈí¼þÔ°8827Ì«Ñô¼¯ÍÅ´óÏ㬣¬£¬£¬£¬£¬£¬£¬¹«Ë¾Ô±¹¤6000ÓàÈË£¬£¬£¬£¬£¬£¬£¬£¬Ñз¢ÍŶÓ1200ÓàÈË, ¼¼Êõ·þÎñÍŶÓ1300ÓàÈË¡£¡£¡£¡£¡£ÔÚÈ«¹ú¸÷Ê¡¡¢ÊÓ×¢×ÔÖÎÇøÉèÁ¢·ÖÖ§»ú¹¹ÁùÊ®¶à¸ö£¬£¬£¬£¬£¬£¬£¬£¬Õ¼Óи²¸ÇÈ«¹úµÄÏúÊÛϵͳ¡¢Çþ·ϵͳºÍ¼¼ÊõÖ§³Öϵͳ¡£¡£¡£¡£¡£¹«Ë¾ÓÚ2010Äê6ÔÂ23ÈÕÔÚÀö½ÖÐÓ×°å¹ÒÅÆÉÏÊС£¡£¡£¡£¡££¨¹ÉƱ´úÂ룺002439£©
¶àÄêÀ´£¬£¬£¬£¬£¬£¬£¬£¬8827Ì«Ñô¼¯ÍÅÖÂÁ¦ÓÚÌṩӵÓйú¼Ê¾ºÕùÁ¦µÄ×ÔÖ÷´´Ðµİ²È«²úÆ·ºÍ×î¼Ñʵ¼Ê·þÎñ£¬£¬£¬£¬£¬£¬£¬£¬Ô®ÊÖ¿Í»§È«ÃæÌáÉýÆäIT»ù´¡ÉèÊ©µÄ°²È«ÐԺͳö²úЧÁ¦£¬£¬£¬£¬£¬£¬£¬£¬Îª´òÔìºÍÌáÉý¹ú¼Ê»¯µÄÃñ×åÐÅÏ¢°²È«²úÒµÁì¾üÆ·ÅÆ¶ø²»Ð¸ÖÂÁ¦¡£¡£¡£¡£¡£
5.2 ¹ØÓÚ8827Ì«Ñô¼¯ÍÅ
8827Ì«Ñô¼¯ÍŰ²È«Ó¦¼±ÏìÓ¦ÖÐÐÄÒѰ䲼1000¶à¸ö·ì϶¹«¸æÎ¢·çÏÕÔ¤¾¯£¬£¬£¬£¬£¬£¬£¬£¬ÎÒÃǽ«³ÖÐø¸ú×ÙÈ«Çò×îеÄÍøÂ簲ȫÊÂÎñºÍ·ì϶£¬£¬£¬£¬£¬£¬£¬£¬ÎªÆóÒµµÄÐÅÏ¢°²È«±£¼Ý»¤º½¡£¡£¡£¡£¡£
¹Ø×¢ÎÒÃÇ£º



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