This update for python-SQLAlchemy fixes the following issues :

Security issues fixed :

  - CVE-2019-7164: Fixed SQL Injection via the order_by     parameter (bsc#1124593).

  - CVE-2019-7548: Fixed SQL Injection via the group_by     parameter (bsc#1124593).

This update was imported from the SUSE:SLE-15-SP1:Update update project.

According to the version of the python-sqlalchemy package installed, the EulerOS installation on the remote host is affected by the following vulnerability :

  - SQLAlchemy 1.2.17 has SQL Injection when the group_by     parameter can be controlled.(CVE-2019-7548)

Note that Tenable Network Security has extracted the preceding description block directly from the EulerOS security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

The remote Alibaba Cloud Linux 3 host has packages installed that are affected by multiple vulnerabilities as referenced in the ALINUX3-SA-2024:0261 advisory.

    Package updates are available for Alibaba Cloud Linux 3 that fix the following vulnerabilities:

    CVE-2019-11236:
    In the urllib3 library through 1.24.1 for Python, CRLF injection is possible if the attacker controls the     request parameter.

    CVE-2019-11324:
    The urllib3 library before 1.24.2 for Python mishandles certain cases where the desired set of CA     certificates is different from the OS store of CA certificates, which results in SSL connections     succeeding in situations where a verification failure is the correct outcome. This is related to use of     the ssl_context, ca_certs, or ca_certs_dir argument.

    CVE-2019-16056:
    An issue was discovered in Python through 2.7.16, 3.x through 3.5.7, 3.6.x through 3.6.9, and 3.7.x     through 3.7.4. The email module wrongly parses email addresses that contain multiple @ characters. An     application that uses the email module and implements some kind of checks on the From/To headers of a     message could be tricked into accepting an email address that should be denied. An attack may be the same     as in CVE-2019-11340; however, this CVE applies to Python more generally.

    CVE-2019-16935:
    The documentation XML-RPC server in Python through 2.7.16, 3.x through 3.6.9, and 3.7.x through 3.7.4 has     XSS via the server_title field. This occurs in Lib/DocXMLRPCServer.py in Python 2.x, and in     Lib/xmlrpc/server.py in Python 3.x. If set_server_title is called with untrusted input, arbitrary     JavaScript can be delivered to clients that visit the http URL for this server.

    CVE-2019-6446:
    An issue was discovered in NumPy 1.16.0 and earlier. It uses the pickle Python module unsafely, which     allows remote attackers to execute arbitrary code via a crafted serialized object, as demonstrated by a     numpy.load call. NOTE: third parties dispute this issue because it is  a behavior that might have     legitimate applications in (for example)  loading serialized Python object arrays from trusted and     authenticated  sources

    CVE-2019-7164:
    SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.

    CVE-2019-7548:
    SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled.

    CVE-2019-9636:
    Python 2.7.x through 2.7.16 and 3.x through 3.7.2 is affected by: Improper Handling of Unicode Encoding     (with an incorrect netloc) during NFKC normalization. The impact is: Information disclosure (credentials,     cookies, etc. that are cached against a given hostname). The components are: urllib.parse.urlsplit,     urllib.parse.urlparse. The attack vector is: A specially crafted URL could be incorrectly parsed to locate     cookies or authentication data and send that information to a different host than when parsed correctly.
    This is fixed in: v2.7.17, v2.7.17rc1, v2.7.18, v2.7.18rc1; v3.5.10, v3.5.10rc1, v3.5.7, v3.5.8,     v3.5.8rc1, v3.5.8rc2, v3.5.9; v3.6.10, v3.6.10rc1, v3.6.11, v3.6.11rc1, v3.6.12, v3.6.9, v3.6.9rc1;
    v3.7.3, v3.7.3rc1, v3.7.4, v3.7.4rc1, v3.7.4rc2, v3.7.5, v3.7.5rc1, v3.7.6, v3.7.6rc1, v3.7.7, v3.7.7rc1,     v3.7.8, v3.7.8rc1, v3.7.9.

    CVE-2019-9740:
    An issue was discovered in urllib2 in Python 2.x through 2.7.16 and urllib in Python 3.x through 3.7.3.
    CRLF injection is possible if the attacker controls a url parameter, as demonstrated by the first argument     to urllib.request.urlopen with \r\n (specifically in the query string after a ? character) followed by an     HTTP header or a Redis command. This is fixed in: v2.7.17, v2.7.17rc1, v2.7.18, v2.7.18rc1; v3.5.10,     v3.5.10rc1, v3.5.8, v3.5.8rc1, v3.5.8rc2, v3.5.9; v3.6.10, v3.6.10rc1, v3.6.11, v3.6.11rc1, v3.6.12,     v3.6.9, v3.6.9rc1; v3.7.4, v3.7.4rc1, v3.7.4rc2, v3.7.5, v3.7.5rc1, v3.7.6, v3.7.6rc1, v3.7.7, v3.7.7rc1,     v3.7.8, v3.7.8rc1, v3.7.9.

    CVE-2019-9947:
    An issue was discovered in urllib2 in Python 2.x through 2.7.16 and urllib in Python 3.x through 3.7.3.
    CRLF injection is possible if the attacker controls a url parameter, as demonstrated by the first argument     to urllib.request.urlopen with \r\n (specifically in the path component of a URL that lacks a ? character)     followed by an HTTP header or a Redis command. This is similar to the CVE-2019-9740 query string issue.
    This is fixed in: v2.7.17, v2.7.17rc1, v2.7.18, v2.7.18rc1; v3.5.10, v3.5.10rc1, v3.5.8, v3.5.8rc1,     v3.5.8rc2, v3.5.9; v3.6.10, v3.6.10rc1, v3.6.11, v3.6.11rc1, v3.6.12, v3.6.9, v3.6.9rc1; v3.7.4,     v3.7.4rc1, v3.7.4rc2, v3.7.5, v3.7.5rc1, v3.7.6, v3.7.6rc1, v3.7.7, v3.7.7rc1, v3.7.8, v3.7.8rc1, v3.7.9.

    CVE-2019-9948:
    urllib in Python 2.x through 2.7.16 supports the local_file: scheme, which makes it easier for remote     attackers to bypass protection mechanisms that blacklist file: URIs, as demonstrated by triggering a     urllib.urlopen('local_file:///etc/passwd') call.

    CVE-2020-26137:
    urllib3 before 1.25.9 allows CRLF injection if the attacker controls the HTTP request method, as     demonstrated by inserting CR and LF control characters in the first argument of putrequest(). NOTE: this     is similar to CVE-2020-26116.

    CVE-2020-27619:
    In Python 3 through 3.9.0, the Lib/test/multibytecodec_support.py CJK codec tests call eval() on content     retrieved via HTTP.

    CVE-2020-27783:
    A XSS vulnerability was discovered in python-lxml's clean module. The module's parser didn't properly     imitate browsers, which caused different behaviors between the sanitizer and the user's page. A remote     attacker could exploit this flaw to run arbitrary HTML/JS code.

    CVE-2020-28493:
    This affects the package jinja2 from 0.0.0 and before 2.11.3. The ReDoS vulnerability is mainly due to the     `_punctuation_re regex` operator and its use of multiple wildcards. The last wildcard is the most     exploitable as it searches for trailing punctuation. This issue can be mitigated by Markdown to format     user content instead of the urlize filter, or by implementing request timeouts and limiting process     memory.

    CVE-2021-20095:
    A flaw was found in python-babel. A path traversal vulnerability was found in how locale data files are     checked and loaded within python-babel, allowing a local attacker to trick an application that uses     python-babel to load a file outside of the intended locale directory. The highest threat from this     vulnerability is to data confidentiality and integrity as well as service availability.

    CVE-2021-23336:
    The package python/cpython from 0 and before 3.6.13, from 3.7.0 and before 3.7.10, from 3.8.0 and before     3.8.8, from 3.9.0 and before 3.9.2 are vulnerable to Web Cache Poisoning via urllib.parse.parse_qsl and     urllib.parse.parse_qs by using a vector called parameter cloaking. When the attacker can separate query     parameters using a semicolon (;), they can cause a difference in the interpretation of the request between     the proxy (running with default configuration) and the server. This can result in malicious requests being     cached as completely safe ones, as the proxy would usually not see the semicolon as a separator, and     therefore would not include it in a cache key of an unkeyed parameter.

    CVE-2021-28957:
    An XSS vulnerability was discovered in python-lxml's clean module versions before 4.6.3. When disabling     the safe_attrs_only and forms arguments, the Cleaner class does not remove the formaction attribute     allowing for JS to bypass the sanitizer. A remote attacker could exploit this flaw to run arbitrary JS     code on users who interact with incorrectly sanitized HTML. This issue is patched in lxml 4.6.3.

    CVE-2021-3177:
    Python 3.x through 3.9.1 has a buffer overflow in PyCArg_repr in _ctypes/callproc.c, which may lead to     remote code execution in certain Python applications that accept floating-point numbers as untrusted     input, as demonstrated by a 1e300 argument to c_double.from_param. This occurs because sprintf is used     unsafely.

    CVE-2021-3733:
    There's a flaw in urllib's AbstractBasicAuthHandler class. An attacker who controls a malicious HTTP     server that an HTTP client (such as web browser) connects to, could trigger a Regular Expression Denial of     Service (ReDOS) during an authentication request with a specially crafted payload that is sent by the     server to the client. The greatest threat that this flaw poses is to application availability.

    CVE-2021-3737:
    A flaw was found in python. An improperly handled HTTP response in the HTTP client code of python may     allow a remote attacker, who controls the HTTP server, to make the client script enter an infinite loop,     consuming CPU time. The highest threat from this vulnerability is to system availability.

    CVE-2021-4189:
    A flaw was found in Python, specifically in the FTP (File Transfer Protocol) client library in PASV     (passive) mode. The issue is how the FTP client trusts the host from the PASV response by default. This     flaw allows an attacker to set up a malicious FTP server that can trick FTP clients into connecting back     to a given IP address and port. This vulnerability could lead to FTP client scanning ports, which     otherwise would not have been possible.

    CVE-2021-42771:
    Babel.Locale in Babel before 2.9.1 allows attackers to load arbitrary locale .dat files (containing     serialized Python objects) via directory traversal, leading to code execution.

    CVE-2021-43818:
    lxml is a library for processing XML and HTML in the Python language. Prior to version 4.6.5, the HTML     Cleaner in lxml.html lets certain crafted script content pass through, as well as script content in SVG     files embedded using data URIs. Users that employ the HTML cleaner in a security relevant context should     upgrade to lxml 4.6.5 to receive a patch. There are no known workarounds available.

    CVE-2022-0391:
    A flaw was found in Python, specifically within the urllib.parse module. This module helps break Uniform     Resource Locator (URL) strings into components. The issue involves how the urlparse method does not     sanitize input and allows characters like '\r' and '\n' in the URL path. This flaw allows an attacker to     input a crafted URL, leading to injection attacks. This flaw affects Python versions prior to 3.10.0b1,     3.9.5, 3.8.11, 3.7.11 and 3.6.14.

    CVE-2022-45061:
    An issue was discovered in Python before 3.11.1. An unnecessary quadratic algorithm exists in one path     when processing some inputs to the IDNA (RFC 3490) decoder, such that a crafted, unreasonably long name     being presented to the decoder could lead to a CPU denial of service. Hostnames are often supplied by     remote servers that could be controlled by a malicious actor; in such a scenario, they could trigger     excessive CPU consumption on the client attempting to make use of an attacker-supplied supposed hostname.
    For example, the attack payload could be placed in the Location header of an HTTP response with status     code 302. A fix is planned in 3.11.1, 3.10.9, 3.9.16, 3.8.16, and 3.7.16.

Tenable has extracted the preceding description block directly from the Alibaba Cloud Linux security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote CentOS Linux 8 host has packages installed that are affected by multiple vulnerabilities as referenced in the CESA-2019:0984 advisory.

  - python-sqlalchemy: SQL Injection when the order_by parameter can be controlled (CVE-2019-7164)

  - python-sqlalchemy: SQL Injection when the group_by parameter can be controlled (CVE-2019-7548)

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Debian 9 host has packages installed that are affected by multiple vulnerabilities as referenced in the dla-2811 advisory.

  - SQLAlchemy through 1.2.17 and 1.3.x through 1.3.0b2 allows SQL Injection via the order_by parameter.
    (CVE-2019-7164)

  - SQLAlchemy 1.2.17 has SQL Injection when the group_by parameter can be controlled. (CVE-2019-7548)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

Linux/Unix ホストには、ベンダーが提供するパッチが利用できない脆弱性の影響を受ける複数のパッケージがインストールされています。

  - group_by パラメーターを制御できる場合、SQLAlchemy 1.2.17 には SQL インジェクションがあります。(CVE-2019-7548)

Nessus は、ベンダーによって報告されたパッケージの存在に依存していることに注意してください。

Python SQLツールキットおよびオブジェクト関係マッパーであるSQLALchemyに2つの脆弱性が見つかりました。

CVE-2019-7164

SQLAlchemyでは、order_byパラメーターを介してSQLインジェクションが可能です。

CVE-2019-7548

SQLAlchemyには、group_byパラメーターを制御できるときのSQLインジェクションがあります。

SQLAlchemyプロジェクトは、これらのセキュリティ修正が、あまり使用されないテキスト強制機能を故障させることを警告しています。

Debian 8「Jessie」では、これらの問題はバージョン0.9.8+dfsg-0.1+deb8u1で修正されました。

お使いのsqlalchemyパッケージをアップグレードすることを推奨します。

注: Tenable Network Securityは、前述の記述ブロックをDLAセキュリティアドバイザリから直接抽出しています。Tenableでは、新たな問題を持ち込まずに、できる限り自動的に整理して書式設定するようにしています。

python27:2.7モジュールの更新プログラムがRed Hat Enterprise Linux 8で利用可能になりました。Red Hat製品セキュリティは、この更新がセキュリティに及ぼす影響の重要度を重要と評価しています。詳細な重要度評価を示すCVSS（共通脆弱性評価システム）ベーススコアは、「参照」セクションのCVEリンクから脆弱性ごとに入手できます。Pythonはインタープリター型、インタラクティブ、オブジェクト指向のプログラミング言語であり、モジュール、クラス、例外、高レベル動的データタイプ、動的タイプ指定をサポートしています。SQLAlchemyはObject Relational Mapper（ORM）で、SQLデータベースに対し、柔軟で高レベルのインターフェイスを提供します。セキュリティ修正プログラム：* python：urlsplitの不適切なNFKC正規化による情報漏えい（CVE-2019-9636）* python-sqlalchemy：order_byパラメーターを制御できるときのSQLインジェクション（CVE-2019-7164）* python-sqlalchemy：group_byパラメーターを制御できるときのSQLインジェクション（CVE-2019-7548）影響、CVSSスコア、謝辞、その他の関連情報を含むセキュリティ問題の詳細については、「参照」セクションに記載されているCVEのページを参照してください。

出典：Red Hat Security Advisory 2019：0981：python27:2.7モジュールの更新プログラムが、Red Hat Enterprise Linux 8で利用可能になりました。Red Hat製品セキュリティは、この更新がセキュリティに及ぼす影響を重要度高と評価しています。詳細な重要度評価を示すCVSS（共通脆弱性評価システム）ベーススコアは、「参照」セクションのCVEリンクから脆弱性ごとに入手できます。Pythonはインタープリター型、インタラクティブ、オブジェクト指向のプログラミング言語であり、モジュール、クラス、例外、高レベル動的データタイプ、動的タイプ指定をサポートしています。SQLAlchemyはObject Relational Mapper（ORM）で、SQLデータベースに対し、柔軟で高レベルのインターフェイスを提供します。セキュリティ修正プログラム：* python：urlsplitの不適切なNFKC正規化による情報漏えい（CVE-2019-9636）* python-sqlalchemy：order_byパラメーターを制御できるときのSQLインジェクション（CVE-2019-7164）* python-sqlalchemy：group_byパラメーターを制御できるときのSQLインジェクション（CVE-2019-7548）影響、CVSSスコア、謝辞、その他の関連情報を含むセキュリティ問題の詳細については、「参照」セクションに記載されているCVEのページを参照してください。

出典：Red Hat Security Advisory 2019：0984：python36:3.6モジュールの更新プログラムが、Red Hat Enterprise Linux 8で利用可能になりました。Red Hat製品セキュリティは、この更新がセキュリティに及ぼす影響を重要度中と評価しています。詳細な重要度評価を示すCVSS（共通脆弱性評価システム）ベーススコアは、「参照」セクションのCVEリンクから脆弱性ごとに入手できます。Pythonはインタープリター型、インタラクティブ、オブジェクト指向のプログラミング言語であり、モジュール、クラス、例外、非常に高レベルの動的データタイプ、動的タイプ指定を含みます。Pythonは、多数のシステムコールやライブラリ、さまざまなウィンドウシステムのインターフェイスをサポートしています。SQLAlchemyはObject Relational Mapper（ORM）で、SQLデータベースに対し、柔軟で高レベルのインターフェイスを提供します。セキュリティ修正プログラム：* python-sqlalchemy：order_byパラメーターを制御できるときのSQLインジェクション（CVE-2019-7164）* python-sqlalchemy：group_byパラメーターを制御できるときのSQLインジェクション（CVE-2019-7548）影響、CVSSスコア、謝辞、その他の関連情報を含むセキュリティ問題の詳細については、「参照」セクションに記載されているCVEのページを参照してください。

python-SQLAlchemy用のこの更新プログラムでは、以下の問題が修正されています：

キャッシュサイドチャネル攻撃の軽減：

  - CVE-2019-7164：order_byパラメーターを介してSQLインジェクションを修正しました（bsc#1124593）。

  - CVE-2019-7548：group_byパラメーターを介してSQLインジェクションを修正しました（bsc#1124593）。

この更新はSUSEからインポートされました：SLE-15：更新プロジェクトを更新します。

python-SQLAlchemy用のこの更新プログラムでは、以下の問題が修正されています：

キャッシュサイドチャネル攻撃の軽減：

  - CVE-2019-7164：order_byパラメーターを介してSQLインジェクションを修正しました（bsc#1124593）。

  - CVE-2019-7548：group_byパラメーターを介してSQLインジェクションを修正しました（bsc#1124593）。

この更新はSUSEからインポートされました：SLE-15-SP1：更新プロジェクトを更新します。

ID	名称	产品	系列	发布时间	最近更新时间	严重程度
128519	openSUSE Security Update : python-SQLAlchemy (openSUSE-2019-2064)	Nessus	SuSE Local Security Checks	2019/9/5	2024/4/29	critical
140841	EulerOS 2.0 SP3 : python-sqlalchemy (EulerOS-SA-2020-2074)	Nessus	Huawei Local Security Checks	2020/9/28	2024/2/19	high
142065	EulerOS 2.0 SP5 : python-sqlalchemy (EulerOS-SA-2020-2297)	Nessus	Huawei Local Security Checks	2020/10/30	2024/2/13	high
236272	Alibaba Cloud Linux 3 : 0261: Moderate: python27:2.7 (ALINUX3-SA-2024:0261)	Nessus	Alibaba Cloud Linux Local Security Checks	2025/5/14	2025/5/15	critical
145649	CentOS 8 : python36:3.6 (CESA-2019:0984)	Nessus	CentOS Local Security Checks	2021/1/29	2024/1/25	critical
154950	Debian DLA-2811-1 : sqlalchemy - LTS security update	Nessus	Debian Local Security Checks	2021/11/7	2023/11/27	critical
223097	Linux Distros のパッチ未適用の脆弱性: CVE-2019-7548	Nessus	Misc.	2025/3/4	2025/9/15	high
122930	DebianDLA-1718-1: sqlalchemyのセキュリティ更新プログラム	Nessus	Debian Local Security Checks	2019/3/19	2024/6/13	critical
124668	RHEL 8：python27:2.7（RHSA-2019:0981）	Nessus	Red Hat Local Security Checks	2019/5/7	2024/11/6	critical
127571	Oracle Linux 8：python27:2.7（ELSA-2019-0981）	Nessus	Oracle Linux Local Security Checks	2019/8/12	2024/11/1	critical
127573	Oracle Linux 8：python36:3.6（ELSA-2019-0984）	Nessus	Oracle Linux Local Security Checks	2019/8/12	2024/11/1	critical
128455	openSUSEセキュリティ更新プログラム：python-SQLAlchemy（openSUSE-2019-2039）	Nessus	SuSE Local Security Checks	2019/9/3	2024/4/30	critical
128519	openSUSEセキュリティ更新プログラム：python-SQLAlchemy（openSUSE-2019-2064）	Nessus	SuSE Local Security Checks	2019/9/5	2024/4/29	critical

检测

插件搜索

critical

high

high

critical

critical

critical

high

critical

critical

critical

critical

critical

critical