SQLite Ô¶³Ì´úÂëÖ´Ðзì϶£¨CVE-2019-5018£©

°ä²¼¹¦·ò 2019-05-11

01²¼¾°ÃèÊö



SQLite 3.28.0½¨¸´ÁËÓÉ˼¿ÆTalos·¢ÏÖ²¢»ã±¨µÄÔ¶³Ì´úÂëÖ´Ðзì϶£¨CVE-2019-5018£©¡£


02Ó°ÏìÁìÓò



CVE ID  £º   CVE-2019-5018    
·ì϶µÈ¼¶£º   ¸ßΣ
Ó°ÏìÁìÓò£º   SQLite 3.26.0¡¢3.27.0
CVSSÆÀ·Ö£º   8.1


03·ì϶ÏêÇé



SQLite 3.26.0µÄ´°¿Úº¯ÊýÖдæÔڿɱ»ÀûÓõÄuse-after-free·ì϶£¬¹¥»÷Õß¿Éͨ¹ý·¢ËͶñÒâSQLºÅÁîÀ´´¥·¢´Ë·ì϶£¬µ¼ÖÂÔ¶³Ì´úÂëÖ´ÐС£


¾ßÌåϸ½ÚΪ£¬SQLiteÔÚ¶ÔÔ̺¬´°¿Úº¯ÊýµÄSELECTÓï¾ä½øÐнâÎöºó£¬Ê¹ÓÃsqlite3WindowRewriteº¯Êý¶Ô¸ÃSELECTÓï¾ä½øÐÐת»»¡£


GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


Ôڴ˺¯ÊýÖУ¬ÈôÊǸÃSELECTÓï¾äÔ̺¬¾ÛºÏº¯Êý£¨COUNT£¬MAX£¬MIN£¬AVG£¬SUM£©£¬Ôò³ÁдSELECT¶ÔÏó±£ÁôµÄ±í°×ʽÁÐ±í£¨ÏÂͼÖеÚ[0]ÐУ©¡£

GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


Ö÷´°¿Ú¶ÔÏópMWinÈ¡×ÔSELECT¶ÔÏ󣬲¢ÔÚ³ÁдÆÚ¼ä±»Ê¹ÓÃ[1]¡£±éÀúSELECT¶ÔÏóµÄ±í°×ʽÁбí£¬³Áд´°¿Úº¯ÊýÒÔ±ãÓÚ´¦Öá£


GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


°ÑÎÈÖ÷´°¿Ú¶ÔÏóÔÚWindowRewrite¶ÔÏóÖÐʹÓá£ÔÚÑ­»·´¦ÖÃÿһ¸ö±í°×ʽʱ£¬½«xExprCallbackº¯Êý×÷Ϊ»Øµ÷º¯Êý¡£µ±´¦ÖþۺϺ¯Êý£¨TK AGG FUNCTION£©ºó£¬±í°×ʽ±»É¾³ý[2]¡£


GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


ÈôÊDZ»É¾³ýµÄ±í°×ʽ±»ÏóÕ÷Ϊ´°¿Úº¯Êý£¬ÔòÒ²»áɾ³ý¹ØÁªµÄWindow¶ÔÏó¡£


GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


²¢É¾³ý¸ÃWindow¶ÔÏó¹ØÁªµÄ·ÖÇø¡£

GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


»ØÊ׳õʼµÄsqlite3WindowRewriteº¯Êý£¬·¢Ïָú¯ÊýÔÚ³Áд±í°×ʽÁбí[4]Ö®ºóͨ¹ýexprListAppendList³ÁÓÃÕâ¸ö±»É¾³ýµÄ·ÖÇø[5]£¬´Ó¶øµ¼ÖÂuse-after-freeºÍ»Ø¾ø·þÎñ¡£ÈôÊǹ¥»÷ÕßÄܹ»½ÚÔìfreeºóµÄÄڴ棬Ôò¿ÉÄÜ·ÛËé¸üÎÞÊý¾Ý£¬´Ó¶øµ¼Ö´úÂëÖ´ÐС£


GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


Äܹ»Ê¹ÓÃDebug°æ±¾µÄsqlite3ÏÈÇå¿Õ±»freeµÄ»º³åÇøµÄÄÚÈÝ£¬ÒÔ¸üºÃµØ½øÐÐÑÝʾ[5]¡£


GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


ͨ¹ýgdb sqlite3ÔËÐÐPoC£¬¿É¹Û²ìµ½0xfafafafafafafafa×ó½ü²úÉú±ÀÀ££¬ÕâÒâζ×ŶÔÒÑ¿ªÊ͵Ļº³åÇøµÄÔٴνӼû£º

GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


ʹÓÃsqlite3 shell ÔËÐÐPoC£º

GA»Æ½ð¼×¡¤(ÖйúÇø)¹Ù·½ÍøÕ¾


04½¨¸´½¨Òé



´Ë·ì϶ÒÑÔÚSQLite 3.28.0Öн¨¸´¡£


05²Î¿¼Á´½Ó



https://blog.talosintelligence.com/2019/05/vulnerability-spotlight-remote-code.html
https://www.sqlite.org/src/info/884b4b7e502b4e99