Описание
PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.
A flaw was found in PyMySQL. When processing untrusted JSON input, keys are not escaped by the escape_dict function due to insufficient input sanitization, allowing an attacker to inject malicious SQL queries.
Отчет
Applications not exposed to untrusted JSON input are not vulnerable to this issue. Additionally, exploitation of this vulnerability depends on the permissions granted to the database user, limiting the security impact. For this reason, this flaw was rated with a Moderate severity.
Меры по смягчению последствий
Make sure the permissions are set correctly for each user, database, table, operation, etc. Do not expose the PyMySQL library to untrusted JSON input.
Затронутые пакеты
| Платформа | Пакет | Состояние | Рекомендация | Релиз |
|---|---|---|---|---|
| Red Hat Enterprise Linux 10 | python-PyMySQL | Not affected | ||
| Red Hat Enterprise Linux 8 | python27:2.7/python-PyMySQL | Will not fix | ||
| Red Hat Enterprise Linux 8 | python36:3.6/python-PyMySQL | Will not fix | ||
| Red Hat Enterprise Linux 8 | python39:3.9/python-PyMySQL | Will not fix | ||
| Red Hat Enterprise Linux 9 | python-PyMySQL | Will not fix | ||
| Red Hat Quay 3 | quay/quay-rhel8 | Affected | ||
| Red Hat Software Collections | rh-python38-python-PyMySQL | Will not fix | ||
| Red Hat Enterprise Linux 8 | python3.11-PyMySQL | Fixed | RHSA-2024:4244 | 02.07.2024 |
| Red Hat Enterprise Linux 8 | python3.12-PyMySQL | Fixed | RHSA-2024:4245 | 02.07.2024 |
| Red Hat Enterprise Linux 9 | python3.12-PyMySQL | Fixed | RHSA-2024:9193 | 12.11.2024 |
Показывать по
Дополнительная информация
Статус:
EPSS
6.3 Medium
CVSS3
Связанные уязвимости
PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.
PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON input because keys are not escaped by escape_dict.
PyMySQL through 1.1.0 allows SQL injection if used with untrusted JSON ...
EPSS
6.3 Medium
CVSS3