公告ID(KYSA-202312-0007)
公告ID:KYSA-202312-0007
公告摘要:postgresql-12安全漏洞
等级:重要
发布日期:2024-11-11
详细介绍
注:
1. 本公告所涉及的漏洞修复信息知识产权全部归麒麟软件有限公司所有,此安全漏洞补丁公告仅适用于麒麟软件操作系统通用主线产品,定制、OEM等版本可根据需要联系售后获取支持。任何媒体、网站或个人转载使用时不得进行商业性的原版原式的转载,也不得歪曲和篡改所发布的内容。此声明以及其修改权、更新权及最终解释权均归本网所有。
2. 此安全漏洞补丁公告仅适用于银河麒麟桌面操作系统V10 SP1 2403版本,系统版本查询工具下载链接:
https://security-oss.kylinos.cn/Desktop/libkysdk-sysinfo.zip
1. 漏洞概述
CVE-2023-5869
PostgreSQL是一套自由的对象关系型数据库管理系统。该系统支持大部分SQL标准并且提供了许多其他特性,例如外键、触发器、视图等。PostgreSQL存在安全漏洞,该漏洞源于array modification存在整数溢出漏洞。
CVE-2023-5870
PostgreSQL是一套自由的对象关系型数据库管理系统。该系统支持大部分SQL标准并且提供了许多其他特性,例如外键、触发器、视图等。PostgreSQL存在安全漏洞,该漏洞源于允许角色pg_signal_backend表示超级用户进程。
CVE-2023-5868
PostgreSQL是一套自由的对象关系型数据库管理系统。该系统支持大部分SQL标准并且提供了许多其他特性,例如外键、触发器、视图等。PostgreSQL存在安全漏洞,该漏洞源于aggregate函数存在内存泄漏漏洞。
2. 受影响的操作系统及软件包
·银河麒麟桌面操作系统V10 SP1 2403
x86_64 架构:
libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12
arm64 架构:
libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12
mips64el 架构:
libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12
loongarch64 架构:
libecpg-compat3、libecpg6、libpgtypes3、libpq5、postgresql-12、postgresql-client-12、postgresql-plperl-12、postgresql-plpython3-12、postgresql-pltcl-12
3. 软件包修复版本
·银河麒麟桌面操作系统V10 SP1 2403
12.18-0kylin0.20.04.1k0.3
4. 修复方法
方法一:升级安装
执行更新命令进行升级
$sudo apt update
$sudo apt install postgresql-12
方法二:下载软件包进行升级安装
通过软件包地址下载软件包,使用软件包升级命令根据受影响的软件包列表升级相关的组件包。
$sudo apt-get install /Path1/Package1 /Path2/Package2 /Path3/Package3……
注:Path 指软件包下载到本地的路径,Package指下载的软件包名称,多个软件包则以空格分开。
5. 软件包下载地址
银河麒麟桌面操作系统V10 SP1 2403
x86_64软件包下载地址
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg-compat3_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg6_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpgtypes3_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpq5_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-12_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-client-12_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plperl-12_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plpython3-12_12.18-0kylin0.20.04.1k0.3_amd64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-pltcl-12_12.18-0kylin0.20.04.1k0.3_amd64.deb
arm64软件包下载地址
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg-compat3_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg6_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpgtypes3_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpq5_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-12_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-client-12_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plperl-12_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plpython3-12_12.18-0kylin0.20.04.1k0.3_arm64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-pltcl-12_12.18-0kylin0.20.04.1k0.3_arm64.deb
mips64el软件包下载地址
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg-compat3_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg6_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpgtypes3_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpq5_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-12_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-client-12_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plperl-12_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plpython3-12_12.18-0kylin0.20.04.1k0.3_mips64el.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-pltcl-12_12.18-0kylin0.20.04.1k0.3_mips64el.deb
loongarch64软件包下载地址
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg-compat3_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libecpg6_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpgtypes3_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/libpq5_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-12_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-client-12_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plperl-12_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-plpython3-12_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
https://archive.kylinos.cn/kylin/KYLIN-ALL/pool/universe/p/postgresql-12/postgresql-pltcl-12_12.18-0kylin0.20.04.1k0.3_loongarch64.deb
注:软件包仅适用于银河麒麟桌面操作系统V10 SP1 2403版本。
6. 修复验证
使用软件包查询命令,查看相关的软件包版本大于或等于修复版本则成功修复。
$sudo dpkg -l |grep Package
注:Package为软件包包名。