search

AtifaFahmeen / FXT-Testing

0 stars 0 forks source link

FX SQL Test : ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound #60

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=ZmMyN2E5OWQtNTI3Zi00Y2UxLWIxOTctMWNjMDY1NTg4OWRj; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Tue, 22 Jan 2019 09:39:40 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/accounts?page=

Request :

Response :
{ "timestamp" : "2019-01-22T09:39:40.857+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/accounts" }

Logs :
2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/accounts?page=] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Method [GET] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request [] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Response [{ "timestamp" : "2019-01-22T09:39:40.857+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/accounts" }] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : 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=ZmMyN2E5OWQtNTI3Zi00Y2UxLWIxOTctMWNjMDY1NTg4OWRj; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Tue, 22 Jan 2019 09:39:40 GMT]}] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : StatusCode [404] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Time [1358] 2019-01-22 09:39:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Size [143] 2019-01-22 09:39:40 INFO [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [1358 < 7000 OR 1358 > 10000] result [Passed] 2019-01-22 09:39:40 ERROR [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : 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=YzVlODMyNGEtMGIyMi00MDE5LTlmOTEtNTE2Zjg3NTkxYTgx; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:48:13 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/accounts?page=

Request :

Response :
{ "timestamp" : "2019-01-23T05:48:13.503+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/accounts" }

Logs :
2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/accounts?page=] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Method [GET] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request [] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Response [{ "timestamp" : "2019-01-23T05:48:13.503+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/accounts" }] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : 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=YzVlODMyNGEtMGIyMi00MDE5LTlmOTEtNTE2Zjg3NTkxYTgx; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:48:13 GMT]}] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : StatusCode [404] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Time [525] 2019-01-23 05:48:13 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Size [143] 2019-01-23 05:48:13 INFO [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [525 < 7000 OR 525 > 10000] result [Passed] 2019-01-23 05:48:13 ERROR [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : 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=YTUxYzUzOGEtN2M4My00OWQ1LWJkNzAtOGIxZjI2NTVkZDYx; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 05:56:47 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/accounts?page=

Request :

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

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

Request :

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

Logs :
2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/accounts?page=] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Method [GET] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request [] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Response [I/O error on GET request for "http://localhost:8080/api/v1/api/v1/accounts": Read timed out; nested exception is java.net.SocketTimeoutException: Read timed out] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Response-Headers [{}] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : StatusCode [500] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Time [15011] 2019-01-23 06:53:40 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Size [160] 2019-01-23 06:53:40 INFO [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [15011 < 7000 OR 15011 > 10000] result [Passed] 2019-01-23 06:53:40 INFO [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : 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=MjQ5ZjM2ZDUtNzBkNS00MjliLThhMmYtNDU4NWYzOTA1MmNi; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 09:57:39 GMT]}

Endpoint : http://localhost:8080/api/v1/api/v1/accounts?page=

Request :

Response :
{ "timestamp" : "2019-01-23T09:57:39.468+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/accounts" }

Logs :
2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : URL [http://localhost:8080/api/v1/api/v1/accounts?page=] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Method [GET] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request [] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Request-Headers [{Content-Type=[application/json], Accept=[application/json], Authorization=[Basic RlhMYWJzLy9hZG1pbkBmeGxhYnMuaW86YWRtaW4xMjMk]}] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Response [{ "timestamp" : "2019-01-23T09:57:39.468+0000", "status" : 404, "error" : "Not Found", "message" : "No message available", "path" : "/api/v1/api/v1/accounts" }] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : 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=MjQ5ZjM2ZDUtNzBkNS00MjliLThhMmYtNDU4NWYzOTA1MmNi; Path=/; HttpOnly], Content-Type=[application/json;charset=UTF-8], Transfer-Encoding=[chunked], Date=[Wed, 23 Jan 2019 09:57:39 GMT]}] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : StatusCode [404] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Time [1091] 2019-01-23 09:57:39 DEBUG [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Size [143] 2019-01-23 09:57:39 INFO [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Assertion [@ResponseTime < 7000 OR @ResponseTime > 10000] resolved-to [1091 < 7000 OR 1091 > 10000] result [Passed] 2019-01-23 09:57:39 ERROR [ApiV1AccountsGetQueryParamPageMysqlSqlInjectionTimebound] : Assertion [@StatusCode != 404] resolved-to [404 != 404] result [Failed]

--- FX Bot ---