SUSE update for postgresql15

1) SQL injection

EUVDB-ID: #VU79454

Risk: Medium

CVSSv4.0: 6.9 [CVSS:4.0/AV:N/AC:L/AT:P/PR:N/UI:N/VC:H/VI:H/VA:N/SC:N/SI:N/SA:N/E:U/U:Green]

CVE-ID: CVE-2023-39417

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

Exploit availability: No

Description

The vulnerability allows a remote attacker to execute arbitrary SQL queries in database.

The vulnerability exists due to insufficient sanitization of user-supplied data within the extension script @substitutions@, which uses @extowner@, @extschema@, or @extschema:...@ inside a quoting construct. A remote attacker can send a specially crafted request to the affected application and execute arbitrary SQL commands within the application database.

Mitigation

Update the affected package postgresql15 to the latest version.

Vulnerable software versions

openSUSE Leap: 15.4 - 15.5

postgresql12-docs: before 12.16-150200.8.47.1

postgresql12-server-debuginfo: before 12.16-150200.8.47.1

postgresql12-debugsource: before 12.16-150200.8.47.1

postgresql12-server: before 12.16-150200.8.47.1

postgresql12-server-devel-debuginfo: before 12.16-150200.8.47.1

postgresql12-debuginfo: before 12.16-150200.8.47.1

postgresql12-plpython-debuginfo: before 12.16-150200.8.47.1

postgresql12-contrib: before 12.16-150200.8.47.1

postgresql12-test: before 12.16-150200.8.47.1

postgresql12-server-devel: before 12.16-150200.8.47.1

postgresql12-contrib-debuginfo: before 12.16-150200.8.47.1

postgresql12-pltcl: before 12.16-150200.8.47.1

postgresql12-devel-debuginfo: before 12.16-150200.8.47.1

postgresql12: before 12.16-150200.8.47.1

postgresql12-llvmjit: before 12.16-150200.8.47.1

postgresql12-plpython: before 12.16-150200.8.47.1

postgresql12-llvmjit-debuginfo: before 12.16-150200.8.47.1

postgresql12-plperl: before 12.16-150200.8.47.1

postgresql12-llvmjit-devel: before 12.16-150200.8.47.1

postgresql12-devel: before 12.16-150200.8.47.1

postgresql12-plperl-debuginfo: before 12.16-150200.8.47.1

postgresql12-pltcl-debuginfo: before 12.16-150200.8.47.1

CPE2.3

• cpe:2.3:o:suse:opensuse_leap:15.4:*:*:*:*:*:*:*
• cpe:2.3:o:suse:opensuse_leap:15.5:*:*:*:*:*:*:*
• cpe:2.3:a:suse:postgresql12-docs:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-server-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-debugsource:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-server:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-server-devel-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-plpython-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-contrib:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-test:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-server-devel:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-contrib-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-pltcl:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-devel-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-llvmjit:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-plpython:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-llvmjit-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-plperl:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-llvmjit-devel:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-devel:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-plperl-debuginfo:*:*:*:*:*:suse_linux:*:*
• cpe:2.3:a:suse:postgresql12-pltcl-debuginfo:*:*:*:*:*:suse_linux:*:*

External links

https://www.suse.com/support/update/announcement/2023/suse-su-20233384-1/

Q & A

Can this vulnerability be exploited remotely?

Yes. This vulnerability can be exploited by a remote non-authenticated attacker via the Internet.

Is there known malware, which exploits this vulnerability?

No. We are not aware of malware exploiting this vulnerability.