Package Instance
Lookup for vulnerable packages by Package URL.
GET /api/packages/23588?format=api
{ "url": "http://public2.vulnerablecode.io/api/packages/23588?format=api", "purl": "pkg:pypi/sqlparse@0.4.2", "type": "pypi", "namespace": "", "name": "sqlparse", "version": "0.4.2", "qualifiers": {}, "subpath": "", "is_vulnerable": true, "next_non_vulnerable_version": "0.4.4", "latest_non_vulnerable_version": "0.5.4", "affected_by_vulnerabilities": [ { "url": "http://public2.vulnerablecode.io/api/vulnerabilities/36421?format=api", "vulnerability_id": "VCID-tcmp-pret-ekgr", "summary": "sqlparse is a non-validating SQL parser module for Python. In affected versions the SQL parser contains a regular expression that is vulnerable to ReDoS (Regular Expression Denial of Service). This issue was introduced by commit `e75e358`. The vulnerability may lead to Denial of Service (DoS). This issues has been fixed in sqlparse 0.4.4 by commit `c457abd5f`. Users are advised to upgrade. There are no known workarounds for this issue.", "references": [ { "reference_url": "https://github.com/andialbrecht/sqlparse", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/andialbrecht/sqlparse" }, { "reference_url": "https://github.com/andialbrecht/sqlparse/commit/c457abd5f097dd13fb21543381e7cfafe7d31cfb", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/andialbrecht/sqlparse/commit/c457abd5f097dd13fb21543381e7cfafe7d31cfb" }, { "reference_url": "https://github.com/andialbrecht/sqlparse/commit/e75e35869473832a1eb67772b1adfee2db11b85a", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/andialbrecht/sqlparse/commit/e75e35869473832a1eb67772b1adfee2db11b85a" }, { "reference_url": "https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-rrm6-wvj7-cwh2", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-rrm6-wvj7-cwh2" }, { "reference_url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlparse/PYSEC-2023-87.yaml", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlparse/PYSEC-2023-87.yaml" }, { "reference_url": "https://lists.debian.org/debian-lts-announce/2023/05/msg00017.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://lists.debian.org/debian-lts-announce/2023/05/msg00017.html" }, { "reference_url": "https://lists.debian.org/debian-lts-announce/2024/12/msg00022.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://lists.debian.org/debian-lts-announce/2024/12/msg00022.html" }, { "reference_url": "https://owasp.org/www-community/attacks/Regular_expression_Denial_of_Service_-_ReDoS", "reference_id": "", "reference_type": "", "scores": [], "url": "https://owasp.org/www-community/attacks/Regular_expression_Denial_of_Service_-_ReDoS" }, { "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2023-30608", "reference_id": "CVE-2023-30608", "reference_type": "", "scores": [], "url": "https://nvd.nist.gov/vuln/detail/CVE-2023-30608" }, { "reference_url": "https://github.com/advisories/GHSA-rrm6-wvj7-cwh2", "reference_id": "GHSA-rrm6-wvj7-cwh2", "reference_type": "", "scores": [], "url": "https://github.com/advisories/GHSA-rrm6-wvj7-cwh2" } ], "fixed_packages": [ { "url": "http://public2.vulnerablecode.io/api/packages/33300?format=api", "purl": "pkg:pypi/sqlparse@0.4.4", "is_vulnerable": false, "affected_by_vulnerabilities": [], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlparse@0.4.4" } ], "aliases": [ "CVE-2023-30608", "GHSA-rrm6-wvj7-cwh2", "PYSEC-2023-87" ], "risk_score": null, "exploitability": null, "weighted_severity": null, "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-tcmp-pret-ekgr" } ], "fixing_vulnerabilities": [ { "url": "http://public2.vulnerablecode.io/api/vulnerabilities/5241?format=api", "vulnerability_id": "VCID-bh4x-5gt2-myah", "summary": "denial of service", "references": [ { "reference_url": "https://github.com/andialbrecht/sqlparse", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/andialbrecht/sqlparse" }, { "reference_url": "https://github.com/andialbrecht/sqlparse/commit/8238a9e450ed1524e40cb3a8b0b3c00606903aeb", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/andialbrecht/sqlparse/commit/8238a9e450ed1524e40cb3a8b0b3c00606903aeb" }, { "reference_url": "https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-p5w8-wqhj-9hhf", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/andialbrecht/sqlparse/security/advisories/GHSA-p5w8-wqhj-9hhf" }, { "reference_url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlparse/PYSEC-2021-333.yaml", "reference_id": "", "reference_type": "", "scores": [], "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlparse/PYSEC-2021-333.yaml" }, { "reference_url": "https://lists.debian.org/debian-lts-announce/2024/12/msg00022.html", "reference_id": "", "reference_type": "", "scores": [], "url": "https://lists.debian.org/debian-lts-announce/2024/12/msg00022.html" }, { "reference_url": "https://securitylab.github.com/advisories/GHSL-2021-107-andialbrecht-sqlparse", "reference_id": "", "reference_type": "", "scores": [], "url": "https://securitylab.github.com/advisories/GHSL-2021-107-andialbrecht-sqlparse" }, { "reference_url": "https://security.archlinux.org/AVG-2401", "reference_id": "AVG-2401", "reference_type": "", "scores": [ { "value": "High", "scoring_system": "archlinux", "scoring_elements": "" } ], "url": "https://security.archlinux.org/AVG-2401" }, { "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2021-32839", "reference_id": "CVE-2021-32839", "reference_type": "", "scores": [], "url": "https://nvd.nist.gov/vuln/detail/CVE-2021-32839" }, { "reference_url": "https://github.com/advisories/GHSA-p5w8-wqhj-9hhf", "reference_id": "GHSA-p5w8-wqhj-9hhf", "reference_type": "", "scores": [], "url": "https://github.com/advisories/GHSA-p5w8-wqhj-9hhf" } ], "fixed_packages": [ { "url": "http://public2.vulnerablecode.io/api/packages/23588?format=api", "purl": "pkg:pypi/sqlparse@0.4.2", "is_vulnerable": true, "affected_by_vulnerabilities": [ { "vulnerability": "VCID-tcmp-pret-ekgr" } ], "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlparse@0.4.2" } ], "aliases": [ "CVE-2021-32839", "GHSA-p5w8-wqhj-9hhf", "PYSEC-2021-333" ], "risk_score": null, "exploitability": null, "weighted_severity": null, "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-bh4x-5gt2-myah" } ], "risk_score": null, "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlparse@0.4.2" }