Bug 13572

Summary: [CVE 21] postgresql 12.14 CVEs found
Product: [ROSA-based products] ROSA Fresh Reporter: Yury <y.tumanov>
Component: System (kernel, glibc, systemd, bash, PAM...)Assignee: ROSA Linux Bugs <bugs>
Status: VERIFIED FIXED QA Contact: ROSA Linux Bugs <bugs>
Severity: normal    
Priority: Normal CC: a.proklov, e.kosachev, i.gaptrakhmanov, pastordidi, s.matveev, v.potapov, y.tumanov
Version: AllFlags: v.potapov: qa_verified+
y.tumanov: secteam_verified+
a.proklov: published+
Target Milestone: ---   
Hardware: All   
OS: Linux   
URL: CVE-2023-2454, CVE-2023-2455, CVE-2023-39417,
Whiteboard:
Platform: 2021.1 ROSA Vulnerability identifier:
RPM Package: ISO-related:
Bad POT generating: Upstream:
Attachments: pg1.png

Description Yury 2023-08-24 00:22:48 MSK
Please patch CVEs for package postgresql version 12.14
  
INFO (CVEs are): postgresql 12.14
 cves found
CVE-2023-2454
Desc: schema_element defeats protective search_path changes; It was found that certain database calls in PostgreSQL could permit an authed attacker with elevated database-level privileges to execute arbitrary code.
Link: https://nvd.nist.gov/vuln/detail/CVE-2023-2454
Severity: HIGH
CVE-2023-2455
Desc: Row security policies disregard user ID changes after inlining; PostgreSQL could permit incorrect policies to be applied in certain cases where role-specific policies are used and a given query is planned under one role and then executed under other roles. This scenario can happen under security definer functions or when a common user and query is planned initially and then re-used across multiple SET ROLEs. Applying an incorrect policy may permit a user to complete otherwise-forbidden reads and modifications. This affects only databases that have used CREATE POLICY to define a row security policy.
Link: https://nvd.nist.gov/vuln/detail/CVE-2023-2455
Severity: MEDIUM
CVE-2023-39417
Desc: IN THE EXTENSION SCRIPT, a SQL Injection vulnerability was found in PostgreSQL if it uses @extowner@, @extschema@, or @extschema:...@ inside a quoting construct (dollar quoting, '', or ""). If an administrator has installed files of a vulnerable, trusted, non-bundled extension, an attacker with database-level CREATE privilege can execute arbitrary code as the bootstrap superuser.
Link: https://nvd.nist.gov/vuln/detail/CVE-2023-39417
Severity: HIGH
Comment 1 ilfat 2023-08-31 18:00:38 MSK
********** QA ADVISORY **********

CVEs closed by project update:

Updated to 12.16

https://abf.io/build_lists/4676955 i686
https://abf.io/build_lists/4676956 x86_64
https://abf.io/build_lists/4676957 aarch64
https://abf.io/build_lists/4676958 riscv64
https://abf.io/build_lists/4676959 e2kv4
Comment 2 Dmitry Postnikov 2023-09-01 18:20:30 MSK
Created attachment 5941 [details]
pg1.png

Postgresql 12-й, а при установке тащить из Контриба либу lib64pq15_5
По-моему что-то не то тут.
Comment 3 ilfat 2023-09-04 12:05:01 MSK
> Postgresql 12-й, а при установке тащить из Контриба либу lib64pq15_5
> По-моему что-то не то тут.

Исправил:
https://abf.io/import/postgresql/commit/62668a57a4af25f50ea4153d5420292f70d86d8a

https://abf.io/build_lists/4680369 i686
https://abf.io/build_lists/4680370 x86_64
https://abf.io/build_lists/4680371 aarch64
https://abf.io/build_lists/4680372 riscv64
https://abf.io/build_lists/4680373 e2kv4
Comment 4 Dmitry Postnikov 2023-09-04 13:36:18 MSK
****************************
The update sent to testings
Comment 5 Vladimir Potapov 2023-09-05 16:05:35 MSK
postgresql-12.16-1
https://abf.io/build_lists/4680369 i686
https://abf.io/build_lists/4680370 x86_64
https://abf.io/build_lists/4680371 aarch64
https://abf.io/build_lists/4680372 riscv64
https://abf.io/build_lists/4680373 e2kv4
************************* Advisory ***************************
CVEs fix by update
**************************************************************
QA Verified
Comment 6 Yury 2023-10-19 10:51:46 MSK
secteam_verified