{"url":"http://public2.vulnerablecode.io/api/packages/7295?format=json","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":"0.7.0b4","latest_non_vulnerable_version":"1.3.0b3","affected_by_vulnerabilities":[{"url":"http://public2.vulnerablecode.io/api/vulnerabilities/34759?format=json","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=json","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=json","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=json","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=json","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=json","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=json","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=json","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=json","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.6.5"}