¡¾Â©¶´Í¨¸æ¡¿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ÈÕ£¬¶«Éƽ̨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 ¶«Éƽ̨¼ò½é
¶«Éƽ̨½¨Á¢ÓÚ1996Ä꣬ÊÇÓÉÁôÃÀ²©Ê¿ÑÏÍû¼ÑŮʿ´´½¨µÄ¡¢ÓµÓÐÍêÈ«×ÔÖ÷֪ʶ²úȨµÄÐÅÏ¢Äþ¾²¸ß¿Æ¼¼ÆóÒµ¡£ÊǹúÄÚ×î¾ßʵÁ¦µÄÐÅÏ¢Äþ¾²²úÎï¡¢Äþ¾²·þÎñ½â¾ö·½°¸µÄÁ캽ÆóÒµÖ®Ò»¡£
¹«Ë¾×ܲ¿Î»ÓÚ±±¾©ÊÐÖйشåÈí¼þÔ°¶«Éƽ̨´óÏ㬹«Ë¾Ô±¹¤6000ÓàÈË£¬Ñз¢ÍŶÓ1200ÓàÈË, ¼¼Êõ·þÎñÍŶÓ1300ÓàÈË¡£ÔÚÈ«¹ú¸÷Ê¡¡¢ÊС¢×ÔÖÎÇøÉèÁ¢·ÖÖ§»ú¹¹ÁùÊ®¶à¸ö£¬ÓµÓÐÁýÕÖÈ«¹úµÄÏúÊÛÌåϵ¡¢ÇþµÀÌåϵºÍ¼¼ÊõÖ§³ÖÌåϵ¡£¹«Ë¾ÓÚ2010Äê6ÔÂ23ÈÕÔÚÉîÛÚÖÐС°å¹ÒÅÆÉÏÊС££¨¹ÉƱ´úÂ룺002439£©
¶àÄêÀ´£¬¶«Éƽ̨ÖÂÁ¦ÓÚÌṩ¾ßÓйú¼Ê¾ºÕùÁ¦µÄ×ÔÖ÷´´ÐµÄÄþ¾²²úÎïºÍ×î¼Ñʵ¼ù·þÎñ£¬×ÊÖú¿Í»§È«ÃæÌáÉýÆäIT»ù´¡ÉèÊ©µÄÄþ¾²ÐÔºÍÉú²úЧÄÜ£¬Îª´òÔìºÍÌáÉý¹ú¼Ê»¯µÄÃñ×åÐÅÏ¢Äþ¾²¹¤ÒµÁì¾üÆ·ÅÆ¶ø²»Ð¸Å¬Á¦¡£
5.2 ¹ØÓÚ¶«Éƽ̨
¶«Éƽ̨Äþ¾²Ó¦¼±ÏìÓ¦ÖÐÐÄÒÑÐû²¼1000¶à¸ö©¶´Í¨¸æºÍ·çÏÕÔ¤¾¯£¬ÎÒÃǽ«Á¬Ðø¸ú×ÙÈ«Çò×îеÄÍøÂçÄþ¾²Ê¼þºÍ©¶´£¬ÎªÆóÒµµÄÐÅÏ¢Äþ¾²±£¼Ý»¤º½¡£
¹Ø×¢ÎÒÃÇ£º