CVE-2024-24811 Products.SQLAlchemyDA vulnerable to unauthenticated arbitrary SQL query execution
CriticalCVSS 9.8
EPSS 0.89%
- Published
- Updated
- Exploit status
- No public exploit known
- CISA SSVC
- No known exploitation · automatable: yes · technical impact: total
Description
SQLAlchemyDA is a generic database adapter for ZSQL methods. A vulnerability found in versions prior to 2.2 allows unauthenticated execution of arbitrary SQL statements on the database to which the SQLAlchemyDA instance is connected. All users are affected. The problem has been patched in version 2.2. There is no workaround for the problem.
Upgrade path
4 packages: 3 fixed.
| Package | Affected | Fixed in | Status |
|---|---|---|---|
| pypi products-sqlalchemyda(PyPI) | < 2.2; = 0.4.0; = 0.4.1; = 0.5.0 +17 more | 2.2 | Fixed |
| pypi products.sqlalchemyda(PyPI) | < 2.2 | 2.2 | Fixed |
| zope sqlalchemyda | < 2.2 | 2.2 | Fixed |
| zopefoundation Products.SQLAlchemyDA | = < 2.2 | No fix listed | Versions listed |
Affected products
| Product | Affected versions | Fixed in |
|---|---|---|
| pypi products-sqlalchemyda(PyPI) | < 2.2 | 2.2 |
| pypi products-sqlalchemyda(PyPI) | = 0.4.0 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.4.1 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.5.0 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.5.1 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.0b | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.0b2 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.0b3 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.0b4 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.0b5 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.0b6 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.0b7 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.1b1 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.2b1 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 0.6.2b2 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 1.0.0 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 1.0.1 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 1.0.2 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 1.1.0 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 2.0 | No fix listed |
| pypi products-sqlalchemyda(PyPI) | = 2.1 | No fix listed |
| zopefoundation Products.SQLAlchemyDA | = < 2.2 | No fix listed |
| zope sqlalchemyda | < 2.2 | 2.2 |
| pypi products.sqlalchemyda(PyPI) | < 2.2 | 2.2 |
References
- https://github.com/zopefoundation/Products.SQLAlchemyDA/security/advisories/GHSA-r3jc-3qmm-w3pw vendor-advisory
- nvd.nist.gov third-party-advisory vendor-advisory
- https://github.com/zopefoundation/Products.SQLAlchemyDA/commit/e682b99f8406f20bc3f0f2c77153ed7345fd215a patch
- github.com product
- pypi.org product
- github.com vendor-advisory
- github.com