@zhengzhenyu ,@bzhaoop ,@dillon_chen
issue处理注意事项:
1. 当前issue受影响的分支提交pr时, 须在pr描述中填写当前issue编号进行关联, 否则无法关闭当前issue;
2. 模板内容需要填写完整, 无论是受影响或者不受影响都需要填写完整内容,未引入的分支不需要填写, 否则无法关闭当前issue;
3. 以下为模板中需要填写完整的内容, 请复制到评论区回复, 注: 内容的标题名称(影响性分析说明, openEuler评分, 受影响版本排查(受影响/不受影响), 修复是否涉及abi变化(是/否))不能省略,省略后cve-manager将无法正常解析填写内容.
影响性分析说明:
openEuler评分: (评分和向量)
受影响版本排查(受影响/不受影响):
1.openEuler-20.03-LTS-SP1(10.5):
2.openEuler-20.03-LTS-SP3(10.5):
3.openEuler-22.03-LTS(13.3):
修复是否涉及abi变化(是/否)：
1.openEuler-20.03-LTS-SP1(10.5):
2.openEuler-20.03-LTS-SP3(10.5):
3.openEuler-22.03-LTS(13.3):
issue处理具体操作请参考:
https://gitee.com/openeuler/cve-manager/blob/master/cve-vulner-manager/doc/md/manual.md
pr关联issue具体操作请参考:
https://gitee.com/help/articles/4142
| 参考网址 | 关联pr | 状态 | 补丁链接 |
|---|---|---|---|
| https://ubuntu.com/security/CVE-2022-31197 | |||
| https://nvd.nist.gov/vuln/detail/CVE-2022-31197 | None | None | https://github.com/pgjdbc/pgjdbc/commit/739e599d52ad80f8dcd6efedc6157859b1a9d637 |
| https://security-tracker.debian.org/tracker/CVE-2022-31197 | |||
| https://bugzilla.suse.com/show_bug.cgi?id=CVE-2022-31197 |
说明：补丁链接仅供初步排查参考，实际可用性请人工再次确认，补丁下载验证可使用CVE补丁工具。
若补丁不准确，烦请在此issue下评论 '/report-patch 参考网址 补丁链接1,补丁链接2' 反馈正确信息，便于我们不断优化工具，不胜感激。
如 /report-patch https://security-tracker.debian.org/tracker/CVE-2021-3997 https://github.com/systemd/systemd/commit/5b1cf7a9be37e20133c0208005274ce4a5b5c6a1
一、漏洞信息
漏洞编号：CVE-2022-31197
漏洞归属组件：postgresql
漏洞归属的版本：10.23,10.5,13.12,13.13,13.18,13.19,13.20,13.3,15.10,15.11,15.12,15.4,15.9,42.2.14
CVSS V3.0分值：
BaseScore：8.0 High
Vector：CVSS：3.0/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
漏洞简述：
PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using standard, database independent Java code. The PGJDBC implementation of the
java.sql.ResultRow.refreshRow()method is not performing escaping of column names so a malicious column name that contains a statement terminator, e.g.;, could lead to SQL injection. This could lead to executing additional SQL commands as the application s JDBC user. User applications that do not invoke theResultSet.refreshRow()method are not impacted. User application that do invoke that method are impacted if the underlying database that they are querying via their JDBC application may be under the control of an attacker. The attack requires the attacker to trick the user into executing SQL against a table name who s column names would contain the malicious SQL and subsequently invoke therefreshRow()method on the ResultSet. Note that the application s JDBC user and the schema owner need not be the same. A JDBC application that executes as a privileged user querying database schemas owned by potentially malicious less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to craft a schema that causes the application to execute commands as the privileged user. Patched versions will be released as42.2.26and42.4.1. Users are advised to upgrade. There are no known workarounds for this issue.漏洞公开时间：2022-08-04 03:15:08
漏洞创建时间：2022-08-04 02:05:22
漏洞详情参考链接：
https://nvd.nist.gov/vuln/detail/CVE-2022-31197
更多参考(点击展开)
漏洞分析指导链接：
https://gitee.com/openeuler/cve-manager/blob/master/cve-vulner-manager/doc/md/manual.md
漏洞数据来源:
openBrain开源漏洞感知系统
漏洞补丁信息：
详情(点击展开)
二、漏洞分析结构反馈
影响性分析说明：
openEuler评分：
8.0
Vector：CVSS：3.0/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H
受影响版本排查(受影响/不受影响)：
1.openEuler-20.03-LTS-SP1(10.5):
2.openEuler-20.03-LTS-SP3(10.5):
3.openEuler-22.03-LTS(13.12):
4.openEuler-22.03-LTS-SP1(13.18):
5.master:
6.openEuler-20.03-LTS-SP4(10.23):
7.openEuler-22.03-LTS-Next(13.13):
8.openEuler-22.03-LTS-SP2(13.12):
9.openEuler-22.03-LTS-SP3(13.22):
10.openEuler-24.03-LTS(15.14):
11.openEuler-24.03-LTS-Next(15.14):
12.openEuler-22.03-LTS-SP4(13.22):
13.openEuler-24.03-LTS-SP2(15.14):
修复是否涉及abi变化(是/否)：
1.openEuler-20.03-LTS-SP1(10.5):
2.openEuler-20.03-LTS-SP3(10.5):
3.openEuler-22.03-LTS(13.12):
4.openEuler-22.03-LTS-SP1(13.18):
5.openEuler-24.03-LTS(15.14):
6.openEuler-24.03-LTS-Next(15.14):
7.openEuler-22.03-LTS-SP4(13.22):
8.openEuler-24.03-LTS-SP2(15.14):
原因说明：
1.master:
2.openEuler-20.03-LTS-SP4(10.23):
3.openEuler-22.03-LTS-SP3(13.22):
4.openEuler-22.03-LTS-SP4(13.22):
5.openEuler-24.03-LTS(15.14):
6.openEuler-24.03-LTS-Next(15.14):
7.openEuler-24.03-LTS-SP1(15.14):
8.openEuler-24.03-LTS-SP2(15.14):