Skip to content
Noroxi
CVE-2019-7164· NVD / CVE Program· CNA mitre

SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.

Noroxi assessment

Priority: Plan (action score 40/100)

  • The sources we track (CISA KEV, Exploit-DB, Metasploit, Nuclei, GitHub) show no public exploit code or exploitation in the wild.
  • Probability of exploitation in the next 30 days: 3.5% (FIRST EPSS); higher than 88.9% of all records.
  • Anyone who can reach it over the internet can trigger it. No account or password is required. No user action is required. No special conditions are required; it is repeatable.
  • Fixed version: python-psycopg2-doc (AlmaLinux:8) 2.7.5-7.module_el8.6.0+2781+fed64c13; python2-attrs (AlmaLinux:8) 17.4.0-10.module_el8.6.0+2781+fed64c13; python2-chardet (AlmaLinux:8) 3.0.4-10.module_el8.6.0+2781+fed64c13.

Add it to your regular patch cycle. Upgrade to python-psycopg2-doc (AlmaLinux:8) 2.7.5-7.module_el8.6.0+2781+fed64c13; python2-attrs (AlmaLinux:8) 17.4.0-10.module_el8.6.0+2781+fed64c13; python2-chardet (AlmaLinux:8) 3.0.4-10.module_el8.6.0+2781+fed64c13 or later.

Generated automatically from the record's data: CVSS (NVD and CNA), CISA KEV and SSVC, FIRST EPSS, exploit sources, fixed versions. How we calculate it

CriticalCVSS 9.8 · v3.1—No exploit Fix available
Published
Feb 19, 2019
Updated
Jun 16, 2026
EPSS
3.5% · 89th percentile

Report tools

JSON

Action score

40

Plan

Add it to your regular patch cycle.

CVSS
39 / 40 · 9.8 / 10
CISA KEV
0 / 30 · Not listed
EPSS
1 / 30 · 3.5%

Get told when this record changes

  • Not in KEV: no record of exploitation in the wild
  • No public exploit code on record
  • A fix has been released

If any of these changes, we'll tell you in the daily email digest.

Follow CVE-2019-7164

When you'll hear from us

  • when it enters CISA KEV
  • when exploit code appears or is weaponized
  • when the record is updated (including a fixed version)
  • when EPSS rises 20 points in a week

One daily email digest (06:00 UTC); connect a webhook for KEV listings and weaponized exploits instantly.

Your free account also gets you

Running WordPress? Scan your site free with WP Lens

  • Stack alerts: add the products and versions you run, get the new CVEs that affect them
  • Port scanning: 5 full scans a day (members only)
  • Uptime monitoring: 1 site, instant email when it goes down
  • Verify your domain: subdomains and takeover risk scanned every week
  • 10 scans an hour on the security tools (3 a day without an account), an API key and MCP
All free tools

Sign up with email · Have an account? Sign in

Free account, no card. Unfollow any time.

Don't want an account? Get "Exploited this week" by email every MondayDon't want an account? RSS feed for sqlalchemy records

Running WordPress? Scan your site free with WP Lens

Is your version affected? Check it

Noroxi analysis

What does it mean in your environment?

The assessment above is generated automatically from the record's data; it doesn't know your environment. Our team verifies on your systems whether this vulnerability is actually exploitable and which mitigation is enough.

We use this product, ask for help

Affected systems

Is your version affected?

Pick the product and type the version you run. It's compared with this record's version ranges in your browser; the version isn't sent anywhere.

VendorProduct
sqlalchemysqlalchemy
debiandebian linux
opensusebackports sle
opensuseleap
redhatenterprise linux
redhatenterprise linux eus
redhatenterprise linux server aus
redhatenterprise linux server tus
oraclecommunications operations monitor

Affected versions

NVD version ranges (for catalog products). Add the product to your stack with a version and matching uses these.

  • debian debian linux8.0
  • debian debian linux9.0
  • opensuse backports sle15.0
  • opensuse leap15.0
  • opensuse leap15.1
  • oracle communications operations monitor4.2
  • oracle communications operations monitor4.3
  • redhat enterprise linux8.0
  • redhat enterprise linux eus8.1
  • redhat enterprise linux eus8.2
  • redhat enterprise linux eus8.4
  • redhat enterprise linux server aus8.2
  • redhat enterprise linux server aus8.4
  • redhat enterprise linux server tus8.2
  • redhat enterprise linux server tus8.4
  • sqlalchemy sqlalchemyup to 1.2.17 inclusive
  • sqlalchemy sqlalchemy1.3.0

Package-level exposure

OSV and GitHub Advisory data: ecosystem, package and range. SBOM matching uses this table.

EcosystemPackageAffected rangeFix
AlmaLinux:8python-psycopg2-docbefore 2.7.5-7.module_el8.6.0+2781+fed64c132.7.5-7.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-attrsbefore 17.4.0-10.module_el8.6.0+2781+fed64c1317.4.0-10.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-chardetbefore 3.0.4-10.module_el8.6.0+2781+fed64c133.0.4-10.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-coveragebefore 4.5.1-4.module_el8.6.0+2781+fed64c134.5.1-4.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-Cythonbefore 0.28.1-7.module_el8.6.0+2781+fed64c130.28.1-7.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-docutilsbefore 0.14-12.module_el8.6.0+2781+fed64c130.14-12.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-funcsigsbefore 1.0.2-13.module_el8.6.0+2781+fed64c131.0.2-13.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-idnabefore 2.5-7.module_el8.6.0+2781+fed64c132.5-7.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-ipaddressbefore 1.0.18-6.module_el8.6.0+2781+fed64c131.0.18-6.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-markupsafebefore 0.23-19.module_el8.6.0+2781+fed64c130.23-19.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-mockbefore 2.0.0-13.module_el8.6.0+2781+fed64c132.0.0-13.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-pluggybefore 0.6.0-8.module_el8.6.0+2781+fed64c130.6.0-8.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-psycopg2before 2.7.5-7.module_el8.6.0+2781+fed64c132.7.5-7.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-psycopg2-debugbefore 2.7.5-7.module_el8.6.0+2781+fed64c132.7.5-7.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-psycopg2-testsbefore 2.7.5-7.module_el8.6.0+2781+fed64c132.7.5-7.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-pybefore 1.5.3-6.module_el8.6.0+2781+fed64c131.5.3-6.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-PyMySQLbefore 0.8.0-10.module_el8.6.0+2781+fed64c130.8.0-10.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-pysocksbefore 1.6.8-6.module_el8.6.0+2781+fed64c131.6.8-6.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-pytestbefore 3.4.2-13.module_el8.6.0+2781+fed64c133.4.2-13.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-pytest-mockbefore 1.9.0-4.module_el8.6.0+2781+fed64c131.9.0-4.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-pytzbefore 2017.2-12.module_el8.6.0+2781+fed64c132017.2-12.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-pyyamlbefore 3.12-16.module_el8.6.0+2781+fed64c133.12-16.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-rpm-macrosbefore 3-38.module_el8.6.0+2781+fed64c133-38.module_el8.6.0+2781+fed64c13
AlmaLinux:8python2-setuptools_scmbefore 1.15.7-6.module_el8.6.0+2781+fed64c131.15.7-6.module_el8.6.0+2781+fed64c13

+96

Same product

sqlalchemy: all records

Other highest-scoring records for the same primary product.

  • CVE-2019-7548SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.
    32Monitor
  • CVE-2012-0805Multiple SQL injection vulnerabilities in SQLAlchemy before 0.7.0b4, as used in Keystone, allow remote attackers to execute arbitrary SQL co
    31Monitor

Remediation

Which version to upgrade to

Fix versions compiled from the vendor, package registries and Microsoft. Verify the vendor's note before upgrading.

Product / packageFixed versionSource
almalinux:python-psycopg2-doc2.7.5-7.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-attrs17.4.0-10.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-chardet3.0.4-10.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-coverage4.5.1-4.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-Cython0.28.1-7.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-docutils0.14-12.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-funcsigs1.0.2-13.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-idna2.5-7.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-ipaddress1.0.18-6.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-markupsafe0.23-19.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-mock2.0.0-13.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
almalinux:python2-PyMySQL0.8.0-10.module_el8.6.0+2781+fed64c13 · AlmaLinux:8Package registry (OSV)
debian:sqlalchemy1.2.18+ds1-2 · Debian:12Package registry (OSV)
opensuse:python-SQLAlchemy1.2.7-lp150.2.3.1 · openSUSE:Leap 15.0Package registry (OSV)
PyPI:sqlalchemy1.3.0b3Package registry (OSV)
red hat:babel0:2.5.1-9.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:Cython0:0.28.1-7.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:numpy1:1.14.2-10.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:pytest0:3.4.2-13.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:python-attrs0:17.4.0-10.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:python-backports0:1.0-15.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:python-backports-ssl_match_hostname0:3.5.0.1-11.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:python-chardet0:3.0.4-10.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:python-coverage0:4.5.1-4.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:python-dns0:1.15.0-9.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:python-PyMySQL0:0.8.0-10.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
red hat:PyYAML0:3.12-16.module+el8.0.0+2961+596d0223 · Red Hat:enterprise_linux:8::appstreamPackage registry (OSV)
rocky linux:babel0:2.5.1-9.module+el8.4.0+403+9ae17a31 · Rocky Linux:8Package registry (OSV)
rocky linux:Cython0:0.28.1-7.module+el8.5.0+706+735ec4b3 · Rocky Linux:8Package registry (OSV)
rocky linux:pytest0:3.4.2-13.module+el8.5.0+706+735ec4b3 · Rocky Linux:8Package registry (OSV)

+21

Exploit status

No known public exploit

No public exploit has been observed yet. That doesn't mean you're safe, only that the bar is a little higher.

Research context

For pentesters and researchers: attack profile, score disagreement, timeline, patch commits, credits, variant and chain candidates, bug bounty scope. All derived from existing data; no exploit code.

Timeline

From publication to today: proof of concept, Metasploit module, CISA KEV and fix record. Dates are as reported by the sources.

No dated events beyond publication.

EPSS, last 120 days

FIRST EPSS daily score; only changes of 0.01 or more are recorded (step chart).

Patch and commit links

Commit, PR and diff links among the references. A starting point for patch-diffing and variant hunting; fixes, not exploits.

No commit or PR link among the references.

Credits

All researchers

Finders, reporters and analysts named in the CNA record. Click a name for that researcher’s other records.

No credits in the CNA record.

Variant candidates

Same product, same weakness class, within 18 months. If the patch missed the root cause, the sibling bug is here.

No nightly-computed relations.

Chain candidates

An authentication bypass and a privilege-requiring bug in the same product, published close together: combined they may become an unauthenticated path.

—

Bug bounty scope

No known public program.

Source: bounty-targets-data (public HackerOne, Bugcrowd, Intigriti, YesWeHack listings).

Technical details

Attack conditions

  • Anyone who can reach it over the internet can trigger it.
  • No account or password is required.
  • No user action is required.
  • No special conditions are required; it is repeatable.

If successful

Confidentiality
high · data can be read
Integrity
high · data or configuration can be modified
Availability
high · the service can be disrupted
Attack vector
Network
Attack complexity
Low
Privileges required
None
User interaction
None
Scope
Unchanged
Confidentiality impact
High
Integrity impact
High
Availability impact
High

Weakness class (CWE)

CWE-89 · Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

CVSS vector

CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H

nvd-primary

Root cause

The query text is built by concatenating user input. The database cannot tell where the data ends and the command begins.

The bug in code

The whole CWE-89 class

A representative example of this vulnerability class. Not the vendor's source code; it shows the faulty pattern and its fix.

Vulnerable

ts
const owner = req.query.owner;const rows = await db.query(  "SELECT * FROM files WHERE owner = '" + owner + "'");

Fixed

ts
const owner = req.query.owner;const rows = await db.query(  "SELECT * FROM files WHERE owner = $1",  [owner]);

Attack context

MITRE CAPEC attack patterns and ATT&CK techniques for this weakness class (CWE). A starting point for detection rules and threat hunting.

ATT&CK techniques

—

Change log

  1. Fix✗ → ✓

For records you follow, these changes also arrive as notifications. →

References

Show all references (7 more)

Vendor advisories and official records. Exploit/PoC links are deliberately left out.

All records