Package Instance
Lookup for vulnerable packages by Package URL.
GET /api/packages/7295?format=api
{ "url": "http://public2.vulnerablecode.io/api/packages/7295?format=api", "purl": "pkg:pypi/sqlalchemy@0.6.5", "type": "pypi", "namespace": "", "name": "sqlalchemy", "version": "0.6.5", "qualifiers": {}, "subpath": "", "is_vulnerable": true, "next_non_vulnerable_version": "1.2.18", "latest_non_vulnerable_version": "1.2.18", "affected_by_vulnerabilities": [ { "url": "http://public2.vulnerablecode.io/api/vulnerabilities/34759?format=api", "vulnerability_id": "VCID-3q38-re5x-rbaj", "summary": "Multiple SQL injection vulnerabilities in SQLAlchemy before 0.7.0b4, as used in Keystone, allow remote attackers to execute arbitrary SQL commands via the (1) limit or (2) offset keyword to the select function, or unspecified vectors to the (3) select.limit or (4) select.offset function.", "references": [ { "reference_url": "http://rhn.redhat.com/errata/RHSA-2012-0369.html", "reference_id": "", "reference_type": "", "scores": [], "url": "http://rhn.redhat.com/errata/RHSA-2012-0369.html" }, { "reference_url": "https://bugs.launchpad.net/keystone/+bug/918608", "reference_id": "", "reference_type": "", "scores": [], "url": "https://bugs.launchpad.net/keystone/+bug/918608" }, { "reference_url": "http://secunia.com/advisories/48327", "reference_id": "", "reference_type": "", "scores": [], "url": "http://secunia.com/advisories/48327" }, { "reference_url": "http://secunia.com/advisories/48328", "reference_id": "", "reference_type": "", "scores": [], "url": "http://secunia.com/advisories/48328" }, { "reference_url": "http://secunia.com/advisories/48771", "reference_id": "", "reference_type": "", "scores": [], "url": "http://secunia.com/advisories/48771" }, { "reference_url": "https://exchange.xforce.ibmcloud.com/vulnerabilities/73756", "reference_id": "", "reference_type": "", "scores": [], "url": "https://exchange.xforce.ibmcloud.com/vulnerabilities/73756" }, { "reference_url": "http://www.debian.org/security/2012/dsa-2449", "reference_id": "", "reference_type": "", "scores": [], "url": "http://www.debian.org/security/2012/dsa-2449" }, { "reference_url": "http://www.mandriva.com/security/advisories?name=MDVSA-2012:059", "reference_id": "", "reference_type": "", "scores": [], "url": "http://www.mandriva.com/security/advisories?name=MDVSA-2012:059" }, { "reference_url": "http://www.sqlalchemy.org/changelog/CHANGES_0_7_0", "reference_id": "", "reference_type": "", "scores": [], "url": "http://www.sqlalchemy.org/changelog/CHANGES_0_7_0" }, { "reference_url": "http://www.sqlalchemy.org/trac/changeset/852b6a1a87e7/", "reference_id": "", "reference_type": "", "scores": [], "url": "http://www.sqlalchemy.org/trac/changeset/852b6a1a87e7/" } ], "fixed_packages": [ { "url": "http://public2.vulnerablecode.io/api/packages/7300?format=api", "purl": "pkg:pypi/sqlalchemy@0.7.0", "is_vulnerable": true, "affected_by_vulnerabilities": [ { "vulnerability": "VCID-kbkh-bf1z-3kb4" }, { "vulnerability": "VCID-tt22-7cuc-gkfc" } ], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@0.7.0" } ], "aliases": [ "CVE-2012-0805", "PYSEC-2012-9" ], "risk_score": null, "exploitability": null, "weighted_severity": null, "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-3q38-re5x-rbaj" }, { "url": "http://public2.vulnerablecode.io/api/vulnerabilities/35320?format=api", "vulnerability_id": "VCID-kbkh-bf1z-3kb4", "summary": "SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.", "references": [ { "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html", "reference_id": "", "reference_type": "", "scores": [], "url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html" }, { "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html", "reference_id": "", "reference_type": "", "scores": [], "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html" }, { "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html", "reference_id": "", "reference_type": "", "scores": [], "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html" }, { "reference_url": "https://access.redhat.com/errata/RHSA-2019:0981", "reference_id": "", "reference_type": "", "scores": [], "url": "https://access.redhat.com/errata/RHSA-2019:0981" }, { "reference_url": "https://access.redhat.com/errata/RHSA-2019:0984", "reference_id": "", "reference_type": "", "scores": [], "url": "https://access.redhat.com/errata/RHSA-2019:0984" }, { "reference_url": "https://github.com/advisories/GHSA-38fc-9xqv-7f7q", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/advisories/GHSA-38fc-9xqv-7f7q" }, { "reference_url": "https://github.com/no-security/sqlalchemy_test", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/no-security/sqlalchemy_test" }, { "reference_url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518" }, { "reference_url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html" }, { "reference_url": "https://www.oracle.com/security-alerts/cpujan2021.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://www.oracle.com/security-alerts/cpujan2021.html" } ], "fixed_packages": [ { "url": "http://public2.vulnerablecode.io/api/packages/12995?format=api", "purl": "pkg:pypi/sqlalchemy@1.2.18", "is_vulnerable": false, "affected_by_vulnerabilities": [], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.2.18" } ], "aliases": [ "CVE-2019-7548", "GHSA-38fc-9xqv-7f7q", "PYSEC-2019-124" ], "risk_score": null, "exploitability": null, "weighted_severity": null, "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-kbkh-bf1z-3kb4" }, { "url": "http://public2.vulnerablecode.io/api/vulnerabilities/35324?format=api", "vulnerability_id": "VCID-tt22-7cuc-gkfc", "summary": "SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.", "references": [ { "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html", "reference_id": "", "reference_type": "", "scores": [], "url": "http://lists.opensuse.org/opensuse-security-announce/2019-08/msg00087.html" }, { "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html", "reference_id": "", "reference_type": "", "scores": [], "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00010.html" }, { "reference_url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html", "reference_id": "", "reference_type": "", "scores": [], "url": "http://lists.opensuse.org/opensuse-security-announce/2019-09/msg00016.html" }, { "reference_url": "https://access.redhat.com/errata/RHSA-2019:0981", "reference_id": "", "reference_type": "", "scores": [], "url": "https://access.redhat.com/errata/RHSA-2019:0981" }, { "reference_url": "https://access.redhat.com/errata/RHSA-2019:0984", "reference_id": "", "reference_type": "", "scores": [], "url": "https://access.redhat.com/errata/RHSA-2019:0984" }, { "reference_url": "https://github.com/advisories/GHSA-887w-45rq-vxgf", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/advisories/GHSA-887w-45rq-vxgf" }, { "reference_url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/sqlalchemy/sqlalchemy/issues/4481" }, { "reference_url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://lists.debian.org/debian-lts-announce/2019/03/msg00020.html" }, { "reference_url": "https://www.oracle.com/security-alerts/cpujan2021.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://www.oracle.com/security-alerts/cpujan2021.html" } ], "fixed_packages": [ { "url": "http://public2.vulnerablecode.io/api/packages/12995?format=api", "purl": "pkg:pypi/sqlalchemy@1.2.18", "is_vulnerable": false, "affected_by_vulnerabilities": [], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.2.18" } ], "aliases": [ "CVE-2019-7164", "GHSA-887w-45rq-vxgf", "PYSEC-2019-123" ], "risk_score": null, "exploitability": null, "weighted_severity": null, "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-tt22-7cuc-gkfc" } ], "fixing_vulnerabilities": [], "risk_score": null, "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@0.6.5" }