PT-2023-22784 · Archery · Archery

Sylwia-Budzynska · Published 2023-04-18 · Updated 2023-05-01 · CVE-2023-30557

Positive Technologies (AI Summary)

CVSS v3.1

6.5

Medium

Base vector

AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N

Name of the Vulnerable Software and Affected Versions Archery (affected versions not specified)

Description The Archery project contains multiple SQL injection vulnerabilities that may allow an attacker to query connected databases. User input from the db name and tb name parameter values in the table info endpoint is passed unsafely to SQL queries. The vulnerable methods include get table meta data, get table desc data, and get table index data in sql/engines/mssql.py and sql/engines/oracle.py, which concatenate user input and pass it to the query method for execution.

Recommendations As a temporary workaround, consider escaping user input or using prepared statements when executing SQL queries in the get table meta data, get table desc data, and get table index data methods. Restrict access to the table info endpoint to minimize the risk of exploitation. Avoid using the db name and tb name parameters in the table info endpoint until the issue is resolved. At the moment, there is no information about a newer version that contains a fix for this vulnerability.

Exploit

SQL injection

Weakness Enumeration

CWE-89

Related Identifiers

CVE-2023-30557

GHSA-9PVW-F8JV-XXJR

Affected Products

Archery

References · 5

• 🔥 https://github.com/hhyo/Archery/security/advisories/GHSA-9pvw-f8jv-xxjr · Exploit
• 🔥 https://github.com/hhyo/Archery/blob/bc86cda4c3b7d59f759d0d23bb63a54f52616752/sql/data_dictionary.py#L47-L86 · Exploit
• 🔥 https://github.com/CVEProject/cvelistV5/tree/main/cves/2023/30xxx/CVE-2023-30557.json · Exploit
• https://osv.dev/vulnerability/CVE-2023-30557 · Vendor Advisory
• https://nvd.nist.gov/vuln/detail/CVE-2023-30557 · Security Note