AtifaFahmeen / FXT-Testing

0 stars 0 forks source link

FX SQL Test : ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound #154

Closed AtifaFahmeen closed 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=YjQyYWQ0YjUtNzQ2ZS00ZTAxLWI4YjEtOTAzNTMwZTU4YWQy; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:49:32 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/orgs/by-user?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-23T05:49:32.180+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/orgs/by-user" }

Logs :
2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/orgs/by-user?pageSize=] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Method [GET] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request [] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response [{ "timestamp" : "2019-01-23T05:49:32.180+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/orgs/by-user" }] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : 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=YjQyYWQ0YjUtNzQ2ZS00ZTAxLWI4YjEtOTAzNTMwZTU4YWQy; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:49:32 GMT]}] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : StatusCode [404] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Time [1839] 2019-01-23 05:49:32 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Size [147] 2019-01-23 05:49:32 INFO [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [1839 < 7000 OR 1839 > 10000] result [Passed] 2019-01-23 05:49:32 ERROR [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : 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=ZmQ1YzkxYjYtNmY4ZC00MjlmLTg4ZTAtZTYwZWQwZTZjYjIz; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:56:05 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/orgs/by-user?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-23T05:56:06.845+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/orgs/by-user" }

Logs :
2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/orgs/by-user?pageSize=] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Method [GET] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request [] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Response [{ "timestamp" : "2019-01-23T05:56:06.845+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/orgs/by-user" }] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : 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=ZmQ1YzkxYjYtNmY4ZC00MjlmLTg4ZTAtZTYwZWQwZTZjYjIz; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:56:05 GMT]}] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : StatusCode [404] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Time [358] 2019-01-23 05:56:06 DEBUG [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Size [147] 2019-01-23 05:56:06 INFO [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [358 < 7000 OR 358 > 10000] result [Passed] 2019-01-23 05:56:06 ERROR [ApiV1OrgsByUserGetQueryParamPagesizeMysqlSqlInjectionTimebound] : 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=OTFhZDk1MjgtMjU2MC00OTY0LTg1OTgtNTNkOGMxZGM4N2Y1; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 06:55:04 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/orgs/by-user?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-23T06:55:04.370+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/orgs/by-user" }

Logs :
Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [7292 < 7000 OR 7292 > 10000] result [Failed]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=N2U1ZTZlZTAtNTRlNi00OTNiLWExNzktMDEwMTQ0Njk2ZjQ0; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 09:59:06 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/orgs/by-user?pageSize=

Request :

Response :
{ "timestamp" : "2019-01-23T09:59:06.561+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/orgs/by-user" }

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