PRODUCTS.SQLALCHEMYDA · CVE-2024-24811 · Package
FIX → 2.2
Products.SQLAlchemyDA, a Zope/Plone library for connecting to SQL databases, lets an unauthenticated attacker execute arbitrary SQL statements on the connected database. An attacker can read, change or delete any data the database account can reach.
first public Feb 7, 2024 · 2 sources
Check it with your coding agent
It reads this page and tells you if your code or app is affected.
Applications that use Products.SQLAlchemyDA to connect a Zope or Plone site to a SQL database are exposed, and the advisory says all users are affected. The sources do not describe a configuration that avoids the flaw, and state there is no workaround, so the only remedy is upgrading. Teams that do not use this package can skip it.
Who cares plone, python, sqlalchemy, zope
pip show Products.SQLAlchemyDAProducts.SQLAlchemyDA in requirements.txt, setup.py or pyproject.toml to see the pinned versionSQLAlchemyDA 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.
Are you affected?
Ask from here. InfraStack checks the affected versions against your stack and answers in your inbox.
InfraStack checks the affected versions against your stack and answers in Slack, with the evidence and the fix.
InfraStack checks it against your stack and answers on your report, with the evidence and the fix.
Upgrade to 2.2
2.2GitHub Advisory Database, CC-BY 4.0 · NVD data is provided by NIST and is public domain. Posts quoted belong to their authors.