Package Instance
Lookup for vulnerable packages by Package URL.
GET /api/packages/7275?format=api
{ "url": "http://public2.vulnerablecode.io/api/packages/7275?format=api", "purl": "pkg:pypi/sqlalchemy@0.5.0rc2", "type": "pypi", "namespace": "", "name": "sqlalchemy", "version": "0.5.0rc2", "qualifiers": {}, "subpath": "", "is_vulnerable": true, "next_non_vulnerable_version": "0.7.0b4", "latest_non_vulnerable_version": "1.3.0b3", "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": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2012-9.yaml", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2012-9.yaml" }, { "reference_url": "https://github.com/sqlalchemy/sqlalchemy", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/sqlalchemy/sqlalchemy" }, { "reference_url": "https://github.com/sqlalchemy/sqlalchemy/commit/51fea2e159ca93daa0bc8066a5c35d8436d99418", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/sqlalchemy/sqlalchemy/commit/51fea2e159ca93daa0bc8066a5c35d8436d99418" }, { "reference_url": "https://web.archive.org/web/20140721183117/http://secunia.com/advisories/48771", "reference_id": "", "reference_type": "", "scores": [], "url": "https://web.archive.org/web/20140721183117/http://secunia.com/advisories/48771" }, { "reference_url": "https://web.archive.org/web/20140802043526/http://secunia.com/advisories/48328", "reference_id": "", "reference_type": "", "scores": [], "url": "https://web.archive.org/web/20140802043526/http://secunia.com/advisories/48328" }, { "reference_url": "https://web.archive.org/web/20140802044957/http://secunia.com/advisories/48327", "reference_id": "", "reference_type": "", "scores": [], "url": "https://web.archive.org/web/20140802044957/http://secunia.com/advisories/48327" }, { "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/" }, { "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2012-0805", "reference_id": "CVE-2012-0805", "reference_type": "", "scores": [], "url": "https://nvd.nist.gov/vuln/detail/CVE-2012-0805" }, { "reference_url": "https://github.com/advisories/GHSA-hfg2-wf6j-x53p", "reference_id": "GHSA-hfg2-wf6j-x53p", "reference_type": "", "scores": [], "url": "https://github.com/advisories/GHSA-hfg2-wf6j-x53p" } ], "fixed_packages": [ { "url": "http://public2.vulnerablecode.io/api/packages/63294?format=api", "purl": "pkg:pypi/sqlalchemy@0.7.0b4", "is_vulnerable": false, "affected_by_vulnerabilities": [], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@0.7.0b4" }, { "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", "GHSA-hfg2-wf6j-x53p", "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/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-124.yaml" }, { "reference_url": "https://github.com/sqlalchemy/sqlalchemy", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/sqlalchemy/sqlalchemy" }, { "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://github.com/sqlalchemy/sqlalchemy/issues/4510", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/sqlalchemy/sqlalchemy/issues/4510" }, { "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://lists.debian.org/debian-lts-announce/2021/11/msg00005.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.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" }, { "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7548", "reference_id": "CVE-2019-7548", "reference_type": "", "scores": [], "url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7548" } ], "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" }, { "url": "http://public2.vulnerablecode.io/api/packages/57824?format=api", "purl": "pkg:pypi/sqlalchemy@1.2.19", "is_vulnerable": false, "affected_by_vulnerabilities": [], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.2.19" } ], "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/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-123.yaml", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2019-123.yaml" }, { "reference_url": "https://github.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/sqlalchemy/sqlalchemy/commit/30307c4616ad67c01ddae2e1e8e34fabf6028414" }, { "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://lists.debian.org/debian-lts-announce/2021/11/msg00005.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://lists.debian.org/debian-lts-announce/2021/11/msg00005.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" }, { "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7164", "reference_id": "CVE-2019-7164", "reference_type": "", "scores": [], "url": "https://nvd.nist.gov/vuln/detail/CVE-2019-7164" } ], "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" }, { "url": "http://public2.vulnerablecode.io/api/packages/57825?format=api", "purl": "pkg:pypi/sqlalchemy@1.3.0b3", "is_vulnerable": false, "affected_by_vulnerabilities": [], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@1.3.0b3" } ], "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.5.0rc2" }