AtifaFahmeen / FXT-Testing

0 stars 0 forks source link

FX SQL Test : ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound #24

Open AtifaFahmeen opened 5 years ago

AtifaFahmeen commented 5 years ago

Project : FX SQL Test

Job : Default

Env : Default

Category : SQL_Injection

Tags : [OWASP A1, [PCI DSS 3.0] 6.5.1, OWASP - OTG-INPVAL-005, FX Top 10 - API Vulnerability, Intrusive]

Severity : Major

Region : US_WEST_2

Result : fail

Status Code : 404

Headers : {X-Content-Type-Options=[nosniff], X-XSS-Protection=[1; mode=block], Cache-Control=[no-cache, no-store, max-age=0, must-revalidate], Pragma=[no-cache], Expires=[0], X-Frame-Options=[DENY], Set-Cookie=[SESSION=ZGZlYWZkYzMtODViNS00OGM5LTk1MzAtNTk5OTM2YWVhNjU2; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Tue, 22 Jan 2019 09:38:40 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-22T09:38:41.759+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/bot-clusters/search" }

Logs :
2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Method [GET] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request [] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response [{ "timestamp" : "2019-01-22T09:38:41.759+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/bot-clusters/search" }] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response-Headers [{X-Content-Type-Options=[nosniff], X-XSS-Protection=[1; mode=block], Cache-Control=[no-cache, no-store, max-age=0, must-revalidate], Pragma=[no-cache], Expires=[0], X-Frame-Options=[DENY], Set-Cookie=[SESSION=ZGZlYWZkYzMtODViNS00OGM5LTk1MzAtNTk5OTM2YWVhNjU2; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Tue, 22 Jan 2019 09:38:40 GMT]}] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : StatusCode [404] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Time [1099] 2019-01-22 09:38:41 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Size [154] 2019-01-22 09:38:41 INFO [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [1099 < 7000 OR 1099 > 10000] result [Passed] 2019-01-22 09:38:41 ERROR [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@StatusCode != 404] resolved-to [404 != 404] result [Failed]

--- FX Bot ---

AtifaFahmeen commented 5 years ago

Project : FX SQL Test

Job : Default

Env : Default

Region : US_WEST_2

Result : fail

Status Code : 404

Headers : {X-Content-Type-Options=[nosniff], X-XSS-Protection=[1; mode=block], Cache-Control=[no-cache, no-store, max-age=0, must-revalidate], Pragma=[no-cache], Expires=[0], X-Frame-Options=[DENY], Set-Cookie=[SESSION=ZWEzNTBlOTktYmE5ZS00MzVjLTlmODQtMWE4NmQ2YTc4YWE2; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:47:28 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-23T05:47:28.852+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/bot-clusters/search" }

Logs :
Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [370 < 7000 OR 370 > 10000] result [Passed]Assertion [@StatusCode != 404] resolved-to [404 != 404] result [Failed] --- FX Bot ---

AtifaFahmeen commented 5 years ago

Project : FX SQL Test

Job : Default

Env : Default

Region : US_WEST_2

Result : pass

Status Code : 404

Headers : {X-Content-Type-Options=[nosniff], X-XSS-Protection=[1; mode=block], Cache-Control=[no-cache, no-store, max-age=0, must-revalidate], Pragma=[no-cache], Expires=[0], X-Frame-Options=[DENY], Set-Cookie=[SESSION=NjNkYjMzZDctMzkzZS00Y2JmLWEyZTAtMmE0NDhjYjFiZWE3; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:55:02 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-23T05:55:02.846+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/bot-clusters/search" }

Logs :
2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Method [GET] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request [] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response [{ "timestamp" : "2019-01-23T05:55:02.846+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/bot-clusters/search" }] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response-Headers [{X-Content-Type-Options=[nosniff], X-XSS-Protection=[1; mode=block], Cache-Control=[no-cache, no-store, max-age=0, must-revalidate], Pragma=[no-cache], Expires=[0], X-Frame-Options=[DENY], Set-Cookie=[SESSION=NjNkYjMzZDctMzkzZS00Y2JmLWEyZTAtMmE0NDhjYjFiZWE3; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:55:02 GMT]}] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : StatusCode [404] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Time [1069] 2019-01-23 05:55:02 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Size [154] 2019-01-23 05:55:02 INFO [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [1069 < 7000 OR 1069 > 10000] result [Passed] 2019-01-23 05:55:02 ERROR [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@StatusCode != 404] resolved-to [404 != 404] result [Failed]

--- FX Bot ---

AtifaFahmeen commented 5 years ago

Project : FX SQL Test

Job : Default

Env : Default

Region : US_WEST_2

Result : pass

Status Code : 500

Headers : {}

Endpoint : http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=

Request :

Response :
I/O error on GET request for "http://localhost:8080/api/v1/api/v1/bot-clusters/search": Read timed out; nested exception is java.net.SocketTimeoutException: Read timed out

Logs :
2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Method [GET] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request [] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response [I/O error on GET request for "http://localhost:8080/api/v1/api/v1/bot-clusters/search": Read timed out; nested exception is java.net.SocketTimeoutException: Read timed out] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response-Headers [{}] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : StatusCode [500] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Time [15012] 2019-01-23 06:51:51 DEBUG [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Size [171] 2019-01-23 06:51:51 INFO [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [15012 < 7000 OR 15012 > 10000] result [Passed] 2019-01-23 06:51:51 INFO [ApiV1BotClustersSearchGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@StatusCode != 404] resolved-to [500 != 404] result [Passed]

--- FX Bot ---

AtifaFahmeen commented 5 years ago

Project : FX SQL Test

Job : Default

Env : Default

Region : US_WEST_2

Result : fail

Status Code : 404

Headers : {X-Content-Type-Options=[nosniff], X-XSS-Protection=[1; mode=block], Cache-Control=[no-cache, no-store, max-age=0, must-revalidate], Pragma=[no-cache], Expires=[0], X-Frame-Options=[DENY], Set-Cookie=[SESSION=OWMzZTAxYzMtMDA2MS00ODI3LTg1YzItMzQ5NTQ4YjYwOWNj; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 09:56:48 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/bot-clusters/search?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-23T09:56:48.901+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/bot-clusters/search" }

Logs :
Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [5283 < 7000 OR 5283 > 10000] result [Passed]Assertion [@StatusCode != 404] resolved-to [404 != 404] result [Failed] --- FX Bot ---