Level - Medium
Author: Justin Giboney
Description:
Visit http://giboney2.byu.edu:5000. Read the instructions. Get the flag. You have to be on campus to get to the server (or VPN).
Flag - byuctf{y0u_g0t_my_d1n0s4ur}
One possible way to do this is to submit the following queries:
-
None : No query submitted.
-
safe : select * from customers where FirstName = 'nancy'
-
safe : select * from customers where FirstName = 'nancy'
-
safe : select * from customers where FirstName = 'nancy'
-
safe : select * from customers where FirstName = 'nancy'
-
Bad query. Try again.no such column: LirstName : select * from customers where LirstName = 'edwards'
-
Bad query. Try again.no such column: LirstName : select * from customers where LirstName = 'edwards'
-
Bad query. Try again.no such column: LirstName : select * from customers where LirstName = 'edwards'
-
safe : select * from customers where LastName = 'edwards'
-
safe : select * from customers where LastName = 'edwards'
-
safe : select * from customers where LastName = 'edwards'
-
safe : select * from customers where LastName = 'edwards'
-
safe : select * from employees where firstname = 'Jack'
-
safe : select * from employees where firstname = 'Jack'
-
safe : select * from employees where firstname = 'Jack'
-
malicious : select * from employees
-
malicious : select * from employees where firstname = 'Nancy'
-
malicious : select * from employees where LastName = 'Edwards'
-
malicious : select '1958-12-08'
-
malicious : select * from employees