#VU20503 SQL injection in SQLAlchemy - CVE-2019-7548

Vulnerability identifier: #VU20503

Vulnerability risk: High

CVSSv4.0: 8.1 [CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N/E:U/U:Amber]

CVE-ID: CVE-2019-7548

CWE-ID: CWE-89

Exploitation vector: Network

Exploit availability: No

Vulnerable software:
SQLAlchemy
Universal components / Libraries / Software for developers

Vendor: SQLAlchemy

Description

The vulnerability allows a remote attacker to execute arbitrary SQL queries in database.

The vulnerability exists due to insufficient sanitization of user-supplied data passed via the "group_by" parameter. A remote attacker can send a specially crafted request to the affected application and execute arbitrary SQL commands within the application database.

Successful exploitation of this vulnerability may allow a remote attacker to read, delete, modify data in database and gain complete control over the affected application.

Mitigation
Install update from vendor's website.

Vulnerable software versions

SQLAlchemy: 1.2.17

---

External links
https://github.com/no-security/sqlalchemy_test
https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518

---

Q & A

Can this vulnerability be exploited remotely?

Yes. This vulnerability can be exploited by a remote non-authenticated attacker via the Internet.

Is there known malware, which exploits this vulnerability?

No. We are not aware of malware exploiting this vulnerability.