ID OPENVAS:1361412562310812311 Type openvas Reporter Copyright (C) 2017 Greenbone Networks GmbH Modified 2020-01-28T00:00:00
Description
This host is running PostgreSQL and is
prone to a security bypass vulnerability.
###############################################################################
# OpenVAS Vulnerability Test
#
# PostgreSQL Security Bypass Vulnerability-Dec17 (Windows)
#
# Authors:
# Shakeel <bshakeel@secpod.com>
#
# Copyright:
# Copyright (C) 2017 Greenbone Networks GmbH, http://www.greenbone.net
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License version 2
# (or any later version), as published by the Free Software Foundation.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
###############################################################################
CPE = "cpe:/a:postgresql:postgresql";
if(description)
{
script_oid("1.3.6.1.4.1.25623.1.0.812311");
script_version("2020-01-28T13:26:39+0000");
script_cve_id("CVE-2017-15099");
script_bugtraq_id(101781);
script_tag(name:"cvss_base", value:"4.0");
script_tag(name:"cvss_base_vector", value:"AV:N/AC:L/Au:S/C:P/I:N/A:N");
script_tag(name:"last_modification", value:"2020-01-28 13:26:39 +0000 (Tue, 28 Jan 2020)");
script_tag(name:"creation_date", value:"2017-12-04 17:20:41 +0530 (Mon, 04 Dec 2017)");
script_tag(name:"qod_type", value:"remote_banner");
script_name("PostgreSQL Security Bypass Vulnerability-Dec17 (Windows)");
script_tag(name:"summary", value:"This host is running PostgreSQL and is
prone to a security bypass vulnerability.");
script_tag(name:"vuldetect", value:"Checks if a vulnerable version is present on the target host.");
script_tag(name:"insight", value:"The flaw exists as commands 'INSERT .. ON CONFLICT DO UPDATE'
disclose table contents that the invoker lacks privilege to read.");
script_tag(name:"impact", value:"Successful exploitation will allow remote
authenticated users to bypass access controls on the target system.");
script_tag(name:"affected", value:"PostgreSQL version 9.5.x before 9.5.10, 9.6.x
before 9.6.6 and 10.x before 10.1.");
script_tag(name:"solution", value:"Upgrade to PostgreSQL version 10.1 or 9.6.6
or 9.5.10 or later.");
script_tag(name:"solution_type", value:"VendorFix");
script_xref(name:"URL", value:"https://www.postgresql.org/about/news/1801");
script_copyright("Copyright (C) 2017 Greenbone Networks GmbH");
script_category(ACT_GATHER_INFO);
script_family("Databases");
script_dependencies("postgresql_detect.nasl", "secpod_postgresql_detect_lin.nasl", "secpod_postgresql_detect_win.nasl", "os_detection.nasl");
script_mandatory_keys("postgresql/detected", "Host/runs_windows");
exit(0);
}
include("version_func.inc");
include("host_details.inc");
if(isnull(port = get_app_port(cpe:CPE)))
exit(0);
if(!infos = get_app_version_and_location(cpe:CPE, port:port, exit_no_version:TRUE))
exit(0);
vers = infos["version"];
loc = infos["location"];
if(vers =~ "^9\.5") {
if(version_is_less(version:vers, test_version:"9.5.10")) {
fix = "9.5.10";
}
}
else if(vers =~ "^9\.6") {
if(version_is_less(version:vers, test_version:"9.6.6")) {
fix = "9.6.6";
}
}
else if(vers =~ "^10\.") {
if(version_is_less(version:vers, test_version:"10.1")) {
fix = "10.1";
}
}
if(fix) {
report = report_fixed_ver(installed_version:vers, fixed_version:fix, install_path:loc);
security_message(port:port, data: report);
exit(0);
}
exit(99);
{"id": "OPENVAS:1361412562310812311", "type": "openvas", "bulletinFamily": "scanner", "title": "PostgreSQL Security Bypass Vulnerability-Dec17 (Windows)", "description": "This host is running PostgreSQL and is\n prone to a security bypass vulnerability.", "published": "2017-12-04T00:00:00", "modified": "2020-01-28T00:00:00", "cvss": {"score": 4.0, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:N"}, "href": "http://plugins.openvas.org/nasl.php?oid=1361412562310812311", "reporter": "Copyright (C) 2017 Greenbone Networks GmbH", "references": ["https://www.postgresql.org/about/news/1801"], "cvelist": ["CVE-2017-15099"], "lastseen": "2020-01-29T20:25:15", "viewCount": 1, "enchantments": {"dependencies": {"references": [{"type": "cve", "idList": ["CVE-2017-15099"]}, {"type": "postgresql", "idList": ["POSTGRESQL:CVE-2017-15099"]}, {"type": "openvas", "idList": ["OPENVAS:1361412562310812312", "OPENVAS:1361412562310851709", "OPENVAS:1361412562310704028", "OPENVAS:1361412562310843363"]}, {"type": "ubuntu", "idList": ["USN-3479-1"]}, {"type": "freebsd", "idList": ["1F02AF5D-C566-11E7-A12D-6CC21735F730"]}, {"type": "debian", "idList": ["DEBIAN:DSA-4028-1:3DEDD"]}, {"type": "archlinux", "idList": ["ASA-201711-17", "ASA-201711-18"]}, {"type": "nessus", "idList": ["UBUNTU_USN-3479-1.NASL", "SUSE_SU-2017-3391-1.NASL", "ALA_ALAS-2017-930.NASL", "DEBIAN_DSA-4028.NASL", "PHOTONOS_PHSA-2017-0048.NASL", "OPENSUSE-2018-204.NASL", "POSTGRESQL_20171109.NASL", "FREEBSD_PKG_1F02AF5DC56611E7A12D6CC21735F730.NASL", "OPENSUSE-2017-1411.NASL"]}, {"type": "kaspersky", "idList": ["KLA11147"]}, {"type": "amazon", "idList": ["ALAS-2017-930"]}, {"type": "suse", "idList": ["OPENSUSE-SU-2018:0529-1"]}, {"type": "redhat", "idList": ["RHSA-2018:2511", "RHSA-2018:2566"]}], "modified": "2020-01-29T20:25:15", "rev": 2}, "score": {"value": 6.5, "vector": "NONE", "modified": "2020-01-29T20:25:15", "rev": 2}, "vulnersScore": 6.5}, "pluginID": "1361412562310812311", "sourceData": "###############################################################################\n# OpenVAS Vulnerability Test\n#\n# PostgreSQL Security Bypass Vulnerability-Dec17 (Windows)\n#\n# Authors:\n# Shakeel <bshakeel@secpod.com>\n#\n# Copyright:\n# Copyright (C) 2017 Greenbone Networks GmbH, http://www.greenbone.net\n#\n# This program is free software; you can redistribute it and/or modify\n# it under the terms of the GNU General Public License version 2\n# (or any later version), as published by the Free Software Foundation.\n#\n# This program is distributed in the hope that it will be useful,\n# but WITHOUT ANY WARRANTY; without even the implied warranty of\n# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\n# GNU General Public License for more details.\n#\n# You should have received a copy of the GNU General Public License\n# along with this program; if not, write to the Free Software\n# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.\n###############################################################################\n\nCPE = \"cpe:/a:postgresql:postgresql\";\n\nif(description)\n{\n script_oid(\"1.3.6.1.4.1.25623.1.0.812311\");\n script_version(\"2020-01-28T13:26:39+0000\");\n script_cve_id(\"CVE-2017-15099\");\n script_bugtraq_id(101781);\n script_tag(name:\"cvss_base\", value:\"4.0\");\n script_tag(name:\"cvss_base_vector\", value:\"AV:N/AC:L/Au:S/C:P/I:N/A:N\");\n script_tag(name:\"last_modification\", value:\"2020-01-28 13:26:39 +0000 (Tue, 28 Jan 2020)\");\n script_tag(name:\"creation_date\", value:\"2017-12-04 17:20:41 +0530 (Mon, 04 Dec 2017)\");\n script_tag(name:\"qod_type\", value:\"remote_banner\");\n script_name(\"PostgreSQL Security Bypass Vulnerability-Dec17 (Windows)\");\n\n script_tag(name:\"summary\", value:\"This host is running PostgreSQL and is\n prone to a security bypass vulnerability.\");\n\n script_tag(name:\"vuldetect\", value:\"Checks if a vulnerable version is present on the target host.\");\n\n script_tag(name:\"insight\", value:\"The flaw exists as commands 'INSERT .. ON CONFLICT DO UPDATE'\n disclose table contents that the invoker lacks privilege to read.\");\n\n script_tag(name:\"impact\", value:\"Successful exploitation will allow remote\n authenticated users to bypass access controls on the target system.\");\n\n script_tag(name:\"affected\", value:\"PostgreSQL version 9.5.x before 9.5.10, 9.6.x\n before 9.6.6 and 10.x before 10.1.\");\n\n script_tag(name:\"solution\", value:\"Upgrade to PostgreSQL version 10.1 or 9.6.6\n or 9.5.10 or later.\");\n\n script_tag(name:\"solution_type\", value:\"VendorFix\");\n\n script_xref(name:\"URL\", value:\"https://www.postgresql.org/about/news/1801\");\n\n script_copyright(\"Copyright (C) 2017 Greenbone Networks GmbH\");\n script_category(ACT_GATHER_INFO);\n script_family(\"Databases\");\n script_dependencies(\"postgresql_detect.nasl\", \"secpod_postgresql_detect_lin.nasl\", \"secpod_postgresql_detect_win.nasl\", \"os_detection.nasl\");\n script_mandatory_keys(\"postgresql/detected\", \"Host/runs_windows\");\n\n exit(0);\n}\n\ninclude(\"version_func.inc\");\ninclude(\"host_details.inc\");\n\nif(isnull(port = get_app_port(cpe:CPE)))\n exit(0);\n\nif(!infos = get_app_version_and_location(cpe:CPE, port:port, exit_no_version:TRUE))\n exit(0);\n\nvers = infos[\"version\"];\nloc = infos[\"location\"];\n\nif(vers =~ \"^9\\.5\") {\n if(version_is_less(version:vers, test_version:\"9.5.10\")) {\n fix = \"9.5.10\";\n }\n}\n\nelse if(vers =~ \"^9\\.6\") {\n if(version_is_less(version:vers, test_version:\"9.6.6\")) {\n fix = \"9.6.6\";\n }\n}\n\nelse if(vers =~ \"^10\\.\") {\n if(version_is_less(version:vers, test_version:\"10.1\")) {\n fix = \"10.1\";\n }\n}\n\n\nif(fix) {\n report = report_fixed_ver(installed_version:vers, fixed_version:fix, install_path:loc);\n security_message(port:port, data: report);\n exit(0);\n}\n\nexit(99);\n", "naslFamily": "Databases"}
{"cve": [{"lastseen": "2020-10-03T13:07:36", "description": "INSERT ... ON CONFLICT DO UPDATE commands in PostgreSQL 10.x before 10.1, 9.6.x before 9.6.6, and 9.5.x before 9.5.10 disclose table contents that the invoker lacks privilege to read. These exploits affect only tables where the attacker lacks full read access but has both INSERT and UPDATE privileges. Exploits bypass row level security policies and lack of SELECT privilege.", "edition": 3, "cvss3": {"exploitabilityScore": 2.8, "cvssV3": {"baseSeverity": "MEDIUM", "confidentialityImpact": "HIGH", "attackComplexity": "LOW", "scope": "UNCHANGED", "attackVector": "NETWORK", "availabilityImpact": "NONE", "integrityImpact": "NONE", "baseScore": 6.5, "privilegesRequired": "LOW", "vectorString": "CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N", "userInteraction": "NONE", "version": "3.0"}, "impactScore": 3.6}, "published": "2017-11-22T18:29:00", "title": "CVE-2017-15099", "type": "cve", "cwe": ["CWE-200"], "bulletinFamily": "NVD", "cvss2": {"severity": "MEDIUM", "exploitabilityScore": 8.0, "obtainAllPrivilege": false, "userInteractionRequired": false, "obtainOtherPrivilege": false, "cvssV2": {"accessComplexity": "LOW", "confidentialityImpact": "PARTIAL", "availabilityImpact": "NONE", "integrityImpact": "NONE", "baseScore": 4.0, "vectorString": "AV:N/AC:L/Au:S/C:P/I:N/A:N", "version": "2.0", "accessVector": "NETWORK", "authentication": "SINGLE"}, "impactScore": 2.9, "obtainUserPrivilege": false}, "cvelist": ["CVE-2017-15099"], "modified": "2018-08-28T10:29:00", "cpe": ["cpe:/a:postgresql:postgresql:9.5.8", "cpe:/a:postgresql:postgresql:9.5", "cpe:/a:postgresql:postgresql:9.6.3", "cpe:/a:postgresql:postgresql:9.5.5", "cpe:/a:postgresql:postgresql:9.5.3", "cpe:/a:postgresql:postgresql:9.5.2", "cpe:/a:postgresql:postgresql:9.5.6", "cpe:/a:postgresql:postgresql:9.6.2", "cpe:/a:postgresql:postgresql:9.6", "cpe:/a:postgresql:postgresql:9.5.9", "cpe:/a:postgresql:postgresql:9.5.1", "cpe:/a:postgresql:postgresql:9.5.4", "cpe:/a:postgresql:postgresql:9.6.5", "cpe:/a:postgresql:postgresql:9.6.4", "cpe:/a:postgresql:postgresql:10.0", "cpe:/a:postgresql:postgresql:9.6.1", "cpe:/a:postgresql:postgresql:9.5.7", "cpe:/o:debian:debian_linux:9.0"], "id": "CVE-2017-15099", "href": "https://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2017-15099", "cvss": {"score": 4.0, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:N"}, "cpe23": ["cpe:2.3:o:debian:debian_linux:9.0:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.6.3:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.6.1:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.6:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.5:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.6.5:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.8:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.6.4:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.7:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.4:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:10.0:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.3:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.6.2:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.9:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.2:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.5.1:*:*:*:*:*:*:*", "cpe:2.3:a:postgresql:postgresql:9.6:*:*:*:*:*:*:*"]}], "postgresql": [{"lastseen": "2020-12-24T14:27:30", "bulletinFamily": "software", "cvelist": ["CVE-2017-15099"], "description": "INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges", "edition": 4, "modified": "2017-11-22T18:29:00", "published": "2017-11-22T18:29:00", "href": "https://www.postgresql.org/support/security/", "id": "POSTGRESQL:CVE-2017-15099", "type": "postgresql", "title": "Vulnerability in core server (CVE-2017-15099)", "cvss": {"score": 4.0, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:N"}}], "openvas": [{"lastseen": "2020-01-29T20:25:15", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099"], "description": "This host is running PostgreSQL and is\n prone to a security bypass vulnerability.", "modified": "2020-01-28T00:00:00", "published": "2017-12-04T00:00:00", "id": "OPENVAS:1361412562310812312", "href": "http://plugins.openvas.org/nasl.php?oid=1361412562310812312", "type": "openvas", "title": "PostgreSQL Security Bypass Vulnerability-Dec17 (Linux)", "sourceData": "###############################################################################\n# OpenVAS Vulnerability Test\n#\n# PostgreSQL Security Bypass Vulnerability-Dec17 (Linux)\n#\n# Authors:\n# Shakeel <bshakeel@secpod.com>\n#\n# Copyright:\n# Copyright (C) 2017 Greenbone Networks GmbH, http://www.greenbone.net\n#\n# This program is free software; you can redistribute it and/or modify\n# it under the terms of the GNU General Public License version 2\n# (or any later version), as published by the Free Software Foundation.\n#\n# This program is distributed in the hope that it will be useful,\n# but WITHOUT ANY WARRANTY; without even the implied warranty of\n# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\n# GNU General Public License for more details.\n#\n# You should have received a copy of the GNU General Public License\n# along with this program; if not, write to the Free Software\n# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.\n###############################################################################\n\nCPE = \"cpe:/a:postgresql:postgresql\";\n\nif(description)\n{\n script_oid(\"1.3.6.1.4.1.25623.1.0.812312\");\n script_version(\"2020-01-28T13:26:39+0000\");\n script_cve_id(\"CVE-2017-15099\");\n script_bugtraq_id(101781);\n script_tag(name:\"cvss_base\", value:\"4.0\");\n script_tag(name:\"cvss_base_vector\", value:\"AV:N/AC:L/Au:S/C:P/I:N/A:N\");\n script_tag(name:\"last_modification\", value:\"2020-01-28 13:26:39 +0000 (Tue, 28 Jan 2020)\");\n script_tag(name:\"creation_date\", value:\"2017-12-04 16:46:13 +0530 (Mon, 04 Dec 2017)\");\n script_tag(name:\"qod_type\", value:\"remote_banner_unreliable\");\n script_name(\"PostgreSQL Security Bypass Vulnerability-Dec17 (Linux)\");\n\n script_tag(name:\"summary\", value:\"This host is running PostgreSQL and is\n prone to a security bypass vulnerability.\");\n\n script_tag(name:\"vuldetect\", value:\"Checks if a vulnerable version is present on the target host.\");\n\n script_tag(name:\"insight\", value:\"The flaw exists as commands 'INSERT .. ON CONFLICT DO UPDATE'\n disclose table contents that the invoker lacks privilege to read.\");\n\n script_tag(name:\"impact\", value:\"Successful exploitation will allow remote\n authenticated users to bypass access controls on the target system.\");\n\n script_tag(name:\"affected\", value:\"PostgreSQL version 9.5.x before 9.5.10, 9.6.x\n before 9.6.6 and 10.x before 10.1.\");\n\n script_tag(name:\"solution\", value:\"Upgrade to PostgreSQL version 10.1 or 9.6.6\n or 9.5.10 or later.\");\n\n script_tag(name:\"solution_type\", value:\"VendorFix\");\n\n script_xref(name:\"URL\", value:\"https://www.postgresql.org/about/news/1801\");\n\n script_copyright(\"Copyright (C) 2017 Greenbone Networks GmbH\");\n script_category(ACT_GATHER_INFO);\n script_family(\"Databases\");\n script_dependencies(\"postgresql_detect.nasl\", \"secpod_postgresql_detect_lin.nasl\", \"secpod_postgresql_detect_win.nasl\", \"os_detection.nasl\");\n script_mandatory_keys(\"postgresql/detected\", \"Host/runs_unixoide\");\n\n exit(0);\n}\n\ninclude(\"version_func.inc\");\ninclude(\"host_details.inc\");\n\nif(isnull(port = get_app_port(cpe:CPE)))\n exit(0);\n\nif(!infos = get_app_version_and_location(cpe:CPE, port:port, exit_no_version:TRUE))\n exit(0);\n\nvers = infos[\"version\"];\nloc = infos[\"location\"];\n\nif(vers =~ \"^9\\.5\") {\n if(version_is_less(version:vers, test_version:\"9.5.10\")) {\n fix = \"9.5.10\";\n }\n}\n\nelse if(vers =~ \"^9\\.6\") {\n if(version_is_less(version:vers, test_version:\"9.6.6\")) {\n fix = \"9.6.6\";\n }\n}\n\nelse if(vers =~ \"^10\\.\") {\n if(version_is_less(version:vers, test_version:\"10.1\")) {\n fix = \"10.1\";\n }\n}\n\n\nif(fix) {\n report = report_fixed_ver(installed_version:vers, fixed_version:fix, install_path:loc);\n security_message(port:port, data: report);\n exit(0);\n}\n\nexit(99);\n", "cvss": {"score": 4.0, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:N"}}, {"lastseen": "2019-05-29T18:34:53", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "description": "Several vulnerabilities have been found in the PostgreSQL database system:\n\nCVE-2017-15098\nDenial of service and potential memory disclosure in the\njson_populate_recordset() and jsonb_populate_recordset() functions\n\nCVE-2017-15099Insufficient permissions checks in INSERT ... ON CONFLICT DO UPDATE\n\nstatements.", "modified": "2019-03-18T00:00:00", "published": "2017-11-09T00:00:00", "id": "OPENVAS:1361412562310704028", "href": "http://plugins.openvas.org/nasl.php?oid=1361412562310704028", "type": "openvas", "title": "Debian Security Advisory DSA 4028-1 (postgresql-9.6 - security update)", "sourceData": "###############################################################################\n# OpenVAS Vulnerability Test\n# $Id: deb_4028.nasl 14284 2019-03-18 15:02:15Z cfischer $\n#\n# Auto-generated from advisory DSA 4028-1 using nvtgen 1.0\n# Script version: 1.0\n#\n# Author:\n# Greenbone Networks\n#\n# Copyright:\n# Copyright (c) 2017 Greenbone Networks GmbH http://greenbone.net\n# Text descriptions are largely excerpted from the referenced\n# advisory, and are Copyright (c) the respective author(s)\n#\n# This program is free software; you can redistribute it and/or modify\n# it under the terms of the GNU General Public License as published by\n# the Free Software Foundation; either version 2 of the License, or\n# (at your option) any later version.\n#\n# This program is distributed in the hope that it will be useful,\n# but WITHOUT ANY WARRANTY; without even the implied warranty of\n# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\n# GNU General Public License for more details.\n#\n# You should have received a copy of the GNU General Public License\n# along with this program; if not, write to the Free Software\n# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.\n###############################################################################\n\nif(description)\n{\n script_oid(\"1.3.6.1.4.1.25623.1.0.704028\");\n script_version(\"$Revision: 14284 $\");\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\");\n script_name(\"Debian Security Advisory DSA 4028-1 (postgresql-9.6 - security update)\");\n script_tag(name:\"last_modification\", value:\"$Date: 2019-03-18 16:02:15 +0100 (Mon, 18 Mar 2019) $\");\n script_tag(name:\"creation_date\", value:\"2017-11-09 00:00:00 +0100 (Thu, 09 Nov 2017)\");\n script_tag(name:\"cvss_base\", value:\"5.5\");\n script_tag(name:\"cvss_base_vector\", value:\"AV:N/AC:L/Au:S/C:P/I:N/A:P\");\n script_tag(name:\"solution_type\", value:\"VendorFix\");\n script_tag(name:\"qod_type\", value:\"package\");\n\n script_xref(name:\"URL\", value:\"https://www.debian.org/security/2017/dsa-4028.html\");\n\n script_category(ACT_GATHER_INFO);\n\n script_copyright(\"Copyright (c) 2017 Greenbone Networks GmbH http://greenbone.net\");\n script_family(\"Debian Local Security Checks\");\n script_dependencies(\"gather-package-list.nasl\");\n script_mandatory_keys(\"ssh/login/debian_linux\", \"ssh/login/packages\", re:\"ssh/login/release=DEB9\");\n script_tag(name:\"affected\", value:\"postgresql-9.6 on Debian Linux\");\n script_tag(name:\"solution\", value:\"For the stable distribution (stretch), these problems have been fixed in\nversion 9.6.6-0+deb9u1.\n\nWe recommend that you upgrade your postgresql-9.6 packages.\");\n script_tag(name:\"summary\", value:\"Several vulnerabilities have been found in the PostgreSQL database system:\n\nCVE-2017-15098\nDenial of service and potential memory disclosure in the\njson_populate_recordset() and jsonb_populate_recordset() functions\n\nCVE-2017-15099Insufficient permissions checks in INSERT ... ON CONFLICT DO UPDATE\n\nstatements.\");\n script_tag(name:\"vuldetect\", value:\"This check tests the installed software version using the apt package manager.\");\n\n exit(0);\n}\n\ninclude(\"revisions-lib.inc\");\ninclude(\"pkg-lib-deb.inc\");\n\nres = \"\";\nreport = \"\";\nif((res = isdpkgvuln(pkg:\"libecpg-compat3\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"libecpg-dev\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"libecpg6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"libpgtypes3\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"libpq-dev\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"libpq5\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-9.6-dbg\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-client-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-contrib-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-doc-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-plperl-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-plpython-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-plpython3-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-pltcl-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\nif((res = isdpkgvuln(pkg:\"postgresql-server-dev-9.6\", ver:\"9.6.6-0+deb9u1\", rls:\"DEB9\")) != NULL) {\n report += res;\n}\n\nif(report != \"\") {\n security_message(data:report);\n} else if(__pkg_match) {\n exit(99);\n}", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2019-05-29T18:34:50", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "description": "The remote host is missing an update for the ", "modified": "2019-03-13T00:00:00", "published": "2017-11-15T00:00:00", "id": "OPENVAS:1361412562310843363", "href": "http://plugins.openvas.org/nasl.php?oid=1361412562310843363", "type": "openvas", "title": "Ubuntu Update for postgresql-9.6 USN-3479-1", "sourceData": "###############################################################################\n# OpenVAS Vulnerability Test\n# $Id: gb_ubuntu_USN_3479_1.nasl 14140 2019-03-13 12:26:09Z cfischer $\n#\n# Ubuntu Update for postgresql-9.6 USN-3479-1\n#\n# Authors:\n# System Generated Check\n#\n# Copyright:\n# Copyright (C) 2017 Greenbone Networks GmbH, http://www.greenbone.net\n#\n# This program is free software; you can redistribute it and/or modify\n# it under the terms of the GNU General Public License version 2\n# (or any later version), as published by the Free Software Foundation.\n#\n# This program is distributed in the hope that it will be useful,\n# but WITHOUT ANY WARRANTY; without even the implied warranty of\n# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\n# GNU General Public License for more details.\n#\n# You should have received a copy of the GNU General Public License\n# along with this program; if not, write to the Free Software\n# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.\n###############################################################################\n\nif(description)\n{\n script_oid(\"1.3.6.1.4.1.25623.1.0.843363\");\n script_version(\"$Revision: 14140 $\");\n script_tag(name:\"last_modification\", value:\"$Date: 2019-03-13 13:26:09 +0100 (Wed, 13 Mar 2019) $\");\n script_tag(name:\"creation_date\", value:\"2017-11-15 07:29:47 +0100 (Wed, 15 Nov 2017)\");\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\");\n script_tag(name:\"cvss_base\", value:\"5.5\");\n script_tag(name:\"cvss_base_vector\", value:\"AV:N/AC:L/Au:S/C:P/I:N/A:P\");\n script_tag(name:\"qod_type\", value:\"package\");\n script_name(\"Ubuntu Update for postgresql-9.6 USN-3479-1\");\n script_tag(name:\"summary\", value:\"The remote host is missing an update for the 'postgresql-9.6'\n package(s) announced via the referenced advisory.\");\n script_tag(name:\"vuldetect\", value:\"Checks if a vulnerable version is present on the target host.\");\n script_tag(name:\"insight\", value:\"David Rowley discovered that PostgreSQL\nincorrectly handled memory when processing certain JSON functions. A remote\nattacker could possibly use this issue to obtain sensitive information.\n(CVE-2017-15098)\n\nDean Rasheed discovered that PostgreSQL incorrectly enforced SELECT\nprivileges when processing INSERT ... ON CONFLICT DO UPDATE commands. A\nremote attacker could possibly use this issue to obtain sensitive\ninformation. This issue only affected Ubuntu 16.04 LTS, Ubuntu 17.04 and\nUbuntu 17.10.\");\n script_tag(name:\"affected\", value:\"postgresql-9.6 on Ubuntu 17.10,\n Ubuntu 17.04,\n Ubuntu 16.04 LTS,\n Ubuntu 14.04 LTS\");\n script_tag(name:\"solution\", value:\"Please Install the Updated Packages.\");\n\n script_xref(name:\"USN\", value:\"3479-1\");\n script_xref(name:\"URL\", value:\"https://usn.ubuntu.com/usn/usn-3479-1/\");\n script_tag(name:\"solution_type\", value:\"VendorFix\");\n script_category(ACT_GATHER_INFO);\n script_copyright(\"Copyright (C) 2017 Greenbone Networks GmbH\");\n script_family(\"Ubuntu Local Security Checks\");\n script_dependencies(\"gather-package-list.nasl\");\n script_mandatory_keys(\"ssh/login/ubuntu_linux\", \"ssh/login/packages\", re:\"ssh/login/release=UBUNTU(14\\.04 LTS|17\\.10|17\\.04|16\\.04 LTS)\");\n\n exit(0);\n}\n\ninclude(\"revisions-lib.inc\");\ninclude(\"pkg-lib-deb.inc\");\n\nrelease = dpkg_get_ssh_release();\nif(!release)\n exit(0);\n\nres = \"\";\n\nif(release == \"UBUNTU14.04 LTS\")\n{\n\n if ((res = isdpkgvuln(pkg:\"postgresql-9.3\", ver:\"9.3.20-0ubuntu0.14.04\", rls:\"UBUNTU14.04 LTS\")) != NULL)\n {\n security_message(data:res);\n exit(0);\n }\n\n if (__pkg_match) exit(99);\n exit(0);\n}\n\n\nif(release == \"UBUNTU17.10\")\n{\n\n if ((res = isdpkgvuln(pkg:\"postgresql-9.6\", ver:\"9.6.6-0ubuntu0.17.10\", rls:\"UBUNTU17.10\")) != NULL)\n {\n security_message(data:res);\n exit(0);\n }\n\n if (__pkg_match) exit(99);\n exit(0);\n}\n\n\nif(release == \"UBUNTU17.04\")\n{\n\n if ((res = isdpkgvuln(pkg:\"postgresql-9.6\", ver:\"9.6.6-0ubuntu0.17.04\", rls:\"UBUNTU17.04\")) != NULL)\n {\n security_message(data:res);\n exit(0);\n }\n\n if (__pkg_match) exit(99);\n exit(0);\n}\n\n\nif(release == \"UBUNTU16.04 LTS\")\n{\n\n if ((res = isdpkgvuln(pkg:\"postgresql-9.5\", ver:\"9.5.10-0ubuntu0.16.04\", rls:\"UBUNTU16.04 LTS\")) != NULL)\n {\n security_message(data:res);\n exit(0);\n }\n\n if (__pkg_match) exit(99);\n exit(0);\n}\n", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2020-01-31T17:33:47", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-7547", "CVE-2017-15099", "CVE-2017-7546", "CVE-2018-1053", "CVE-2017-15098", "CVE-2017-7548"], "description": "The remote host is missing an update for the ", "modified": "2020-01-31T00:00:00", "published": "2018-02-23T00:00:00", "id": "OPENVAS:1361412562310851709", "href": "http://plugins.openvas.org/nasl.php?oid=1361412562310851709", "type": "openvas", "title": "openSUSE: Security Advisory for postgresql95 (openSUSE-SU-2018:0529-1)", "sourceData": "# Copyright (C) 2018 Greenbone Networks GmbH\n# Text descriptions are largely excerpted from the referenced\n# advisory, and are Copyright (C) of their respective author(s)\n#\n# SPDX-License-Identifier: GPL-2.0-or-later\n#\n# This program is free software; you can redistribute it and/or\n# modify it under the terms of the GNU General Public License\n# as published by the Free Software Foundation; either version 2\n# of the License, or (at your option) any later version.\n#\n# This program is distributed in the hope that it will be useful,\n# but WITHOUT ANY WARRANTY; without even the implied warranty of\n# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the\n# GNU General Public License for more details.\n#\n# You should have received a copy of the GNU General Public License\n# along with this program; if not, write to the Free Software\n# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.\n\nif(description)\n{\n script_oid(\"1.3.6.1.4.1.25623.1.0.851709\");\n script_version(\"2020-01-31T08:23:39+0000\");\n script_tag(name:\"last_modification\", value:\"2020-01-31 08:23:39 +0000 (Fri, 31 Jan 2020)\");\n script_tag(name:\"creation_date\", value:\"2018-02-23 09:06:11 +0100 (Fri, 23 Feb 2018)\");\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\", \"CVE-2017-7546\", \"CVE-2017-7547\",\n \"CVE-2017-7548\", \"CVE-2018-1053\");\n script_tag(name:\"cvss_base\", value:\"7.5\");\n script_tag(name:\"cvss_base_vector\", value:\"AV:N/AC:L/Au:N/C:P/I:P/A:P\");\n script_tag(name:\"qod_type\", value:\"package\");\n script_name(\"openSUSE: Security Advisory for postgresql95 (openSUSE-SU-2018:0529-1)\");\n\n script_tag(name:\"summary\", value:\"The remote host is missing an update for the 'postgresql95'\n package(s) announced via the referenced advisory.\");\n\n script_tag(name:\"vuldetect\", value:\"Checks if a vulnerable package version is present on the target host.\");\n\n script_tag(name:\"insight\", value:\"This update for postgresql95 fixes the following issues:\n\n Update to PostgreSQL 9.5.11:\n\n Security issues fixed:\n\n * CVE-2018-1053, boo#1077983: Ensure that all temporary files made by\n pg_upgrade are non-world-readable.\n\n * boo#1079757: Rename pg_rewind's copy_file_range function to avoid\n conflict with new Linux system call of that name.\n\n In version 9.5.10:\n\n * CVE-2017-15098, boo#1067844: Memory disclosure in JSON functions.\n\n * CVE-2017-15099, boo#1067841: INSERT ... ON CONFLICT DO UPDATE fails to\n enforce SELECT privileges.\n\n In version 9.5.9:\n\n * Show foreign tables in information_schema.table_privileges view.\n\n * Clean up handling of a fatal exit (e.g., due to receipt of SIGTERM)\n that occurs while trying to execute a ROLLBACK of a failed transaction.\n\n * Remove assertion that could trigger during a fatal exit.\n\n * Correctly identify columns that are of a range type or domain type\n over a composite type or domain type being searched for.\n\n * Fix crash in pg_restore when using parallel mode and using a list file\n to select a subset of items to restore.\n\n * Change ecpg's parser to allow RETURNING clauses without attached C\n variables.\n\n In version 9.5.8\n\n * CVE-2017-7547, boo#1051685: Further restrict visibility of\n pg_user_mappings.umoptions, to protect passwords stored as user\n mapping options.\n\n * CVE-2017-7546, boo#1051684: Disallow empty passwords in all\n password-based authentication methods.\n\n * CVE-2017-7548, boo#1053259: lo_put() function ignores ACLs.\");\n\n script_tag(name:\"affected\", value:\"postgresql95 on openSUSE Leap 42.3\");\n\n script_tag(name:\"solution\", value:\"Please install the updated package(s).\");\n\n script_xref(name:\"openSUSE-SU\", value:\"2018:0529-1\");\n script_xref(name:\"URL\", value:\"https://lists.opensuse.org/opensuse-security-announce/2018-02/msg00042.html\");\n script_tag(name:\"solution_type\", value:\"VendorFix\");\n script_category(ACT_GATHER_INFO);\n script_copyright(\"Copyright (C) 2018 Greenbone Networks GmbH\");\n script_family(\"SuSE Local Security Checks\");\n script_dependencies(\"gather-package-list.nasl\");\n script_mandatory_keys(\"ssh/login/suse\", \"ssh/login/rpms\", re:\"ssh/login/release=openSUSELeap42\\.3\");\n exit(0);\n}\n\ninclude(\"revisions-lib.inc\");\ninclude(\"pkg-lib-rpm.inc\");\n\nrelease = rpm_get_ssh_release();\nif(!release)\n exit(0);\n\nres = \"\";\nreport = \"\";\n\nif(release == \"openSUSELeap42.3\") {\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95\", rpm:\"postgresql95~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-contrib\", rpm:\"postgresql95-contrib~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-contrib-debuginfo\", rpm:\"postgresql95-contrib-debuginfo~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-debuginfo\", rpm:\"postgresql95-debuginfo~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-debugsource\", rpm:\"postgresql95-debugsource~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-devel\", rpm:\"postgresql95-devel~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-devel-debuginfo\", rpm:\"postgresql95-devel-debuginfo~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-libs-debugsource\", rpm:\"postgresql95-libs-debugsource~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-plperl\", rpm:\"postgresql95-plperl~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-plperl-debuginfo\", rpm:\"postgresql95-plperl-debuginfo~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-plpython\", rpm:\"postgresql95-plpython~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-plpython-debuginfo\", rpm:\"postgresql95-plpython-debuginfo~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-pltcl\", rpm:\"postgresql95-pltcl~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-pltcl-debuginfo\", rpm:\"postgresql95-pltcl-debuginfo~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-server\", rpm:\"postgresql95-server~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-server-debuginfo\", rpm:\"postgresql95-server-debuginfo~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-test\", rpm:\"postgresql95-test~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(!isnull(res = isrpmvuln(pkg:\"postgresql95-docs\", rpm:\"postgresql95-docs~9.5.11~2.3.1\", rls:\"openSUSELeap42.3\"))) {\n report += res;\n }\n\n if(report != \"\") {\n security_message(data:report);\n } else if(__pkg_match) {\n exit(99);\n }\n exit(0);\n}\n\nexit(0);\n", "cvss": {"score": 7.5, "vector": "AV:N/AC:L/Au:N/C:P/I:P/A:P"}}], "ubuntu": [{"lastseen": "2020-07-02T11:45:19", "bulletinFamily": "unix", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "description": "David Rowley discovered that PostgreSQL incorrectly handled memory when \nprocessing certain JSON functions. A remote attacker could possibly use \nthis issue to obtain sensitive information. (CVE-2017-15098)\n\nDean Rasheed discovered that PostgreSQL incorrectly enforced SELECT \nprivileges when processing INSERT ... ON CONFLICT DO UPDATE commands. A \nremote attacker could possibly use this issue to obtain sensitive \ninformation. This issue only affected Ubuntu 16.04 LTS, Ubuntu 17.04 and \nUbuntu 17.10.", "edition": 5, "modified": "2017-11-14T00:00:00", "published": "2017-11-14T00:00:00", "id": "USN-3479-1", "href": "https://ubuntu.com/security/notices/USN-3479-1", "title": "PostgreSQL vulnerabilities", "type": "ubuntu", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}], "freebsd": [{"lastseen": "2019-05-29T18:32:06", "bulletinFamily": "unix", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "description": "\nThe PostgreSQL project reports:\n\n\nCVE-2017-15098: Memory disclosure in JSON functions\nCVE-2017-15099: INSERT ... ON CONFLICT DO UPDATE fails to\n\t enforce SELECT privileges\n\n\n", "edition": 5, "modified": "2017-10-10T00:00:00", "published": "2017-10-10T00:00:00", "id": "1F02AF5D-C566-11E7-A12D-6CC21735F730", "href": "https://vuxml.freebsd.org/freebsd/1f02af5d-c566-11e7-a12d-6cc21735f730.html", "title": "PostgreSQL vulnerabilities", "type": "freebsd", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}], "debian": [{"lastseen": "2020-09-01T01:01:27", "bulletinFamily": "unix", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "description": "- -------------------------------------------------------------------------\nDebian Security Advisory DSA-4028-1 security@debian.org\nhttps://www.debian.org/security/ Moritz Muehlenhoff\nNovember 09, 2017 https://www.debian.org/security/faq\n- -------------------------------------------------------------------------\n\nPackage : postgresql-9.6\nCVE ID : CVE-2017-15098 CVE-2017-15099\n\nSeveral vulnerabilities have been found in the PostgreSQL database system:\n\nCVE-2017-15098\n\n Denial of service and potential memory disclosure in the\n json_populate_recordset() and jsonb_populate_recordset() functions\n\nCVE-2017-15099\n\n Insufficient permissions checks in "INSERT ... ON CONFLICT DO UPDATE"\n statements.\n\nFor the stable distribution (stretch), these problems have been fixed in\nversion 9.6.6-0+deb9u1.\n\nWe recommend that you upgrade your postgresql-9.6 packages.\n\nFurther information about Debian Security Advisories, how to apply\nthese updates to your system and frequently asked questions can be\nfound at: https://www.debian.org/security/\n\nMailing list: debian-security-announce@lists.debian.org\n", "edition": 12, "modified": "2017-11-09T21:40:20", "published": "2017-11-09T21:40:20", "id": "DEBIAN:DSA-4028-1:3DEDD", "href": "https://lists.debian.org/debian-security-announce/debian-security-announce-2017/msg00291.html", "title": "[SECURITY] [DSA 4028-1] postgresql-9.6 security update", "type": "debian", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}], "archlinux": [{"lastseen": "2020-09-22T18:36:42", "bulletinFamily": "unix", "cvelist": ["CVE-2017-15098", "CVE-2017-15099"], "description": "Arch Linux Security Advisory ASA-201711-17\n==========================================\n\nSeverity: Medium\nDate : 2017-11-10\nCVE-ID : CVE-2017-15098 CVE-2017-15099\nPackage : postgresql\nType : multiple issues\nRemote : Yes\nLink : https://security.archlinux.org/AVG-485\n\nSummary\n=======\n\nThe package postgresql before version 10.1-1 is vulnerable to multiple\nissues including access restriction bypass and information disclosure.\n\nResolution\n==========\n\nUpgrade to 10.1-1.\n\n# pacman -Syu \"postgresql>=10.1-1\"\n\nThe problems have been fixed upstream in version 10.1.\n\nWorkaround\n==========\n\nNone.\n\nDescription\n===========\n\n- CVE-2017-15098 (information disclosure)\n\nA denial of service and potential memory disclosure vulnerability has\nbeen discovered in PostgreSQL in the json_populate_recordset() and\njsonb_populate_recordset() functions.\n\n- CVE-2017-15099 (access restriction bypass)\n\nAn access restriction bypass vulnerability has been discovered in\nPostgreSQL, the \"INSERT ... ON CONFLICT DO UPDATE\" would not check to\nsee if the executing user had permission to perform a \"SELECT\" on the\nindex performing the conflicting check. Additionally, in a table with\nrow-level security enabled, the \"INSERT ... ON CONFLICT DO UPDATE\"\nwould not check the SELECT policies for that table before performing\nthe update.\nThe fix ensures that \"INSERT ... ON CONFLICT DO UPDATE\" checks against\ntable permissions and RLS policies before executing.\n\nImpact\n======\n\nA remote attacker is able to bypass access restrictions via certain\nqueries or possibly leak sensitive information from the running\nprocess.\n\nReferences\n==========\n\nhttps://www.postgresql.org/about/news/1801/\nhttps://security.archlinux.org/CVE-2017-15098\nhttps://security.archlinux.org/CVE-2017-15099", "modified": "2017-11-10T00:00:00", "published": "2017-11-10T00:00:00", "id": "ASA-201711-17", "href": "https://security.archlinux.org/ASA-201711-17", "type": "archlinux", "title": "[ASA-201711-17] postgresql: multiple issues", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2020-09-22T18:36:42", "bulletinFamily": "unix", "cvelist": ["CVE-2017-15098", "CVE-2017-15099"], "description": "Arch Linux Security Advisory ASA-201711-18\n==========================================\n\nSeverity: Medium\nDate : 2017-11-10\nCVE-ID : CVE-2017-15098 CVE-2017-15099\nPackage : postgresql-old-upgrade\nType : multiple issues\nRemote : Yes\nLink : https://security.archlinux.org/AVG-486\n\nSummary\n=======\n\nThe package postgresql-old-upgrade before version 9.6.6-1 is vulnerable\nto multiple issues including access restriction bypass and information\ndisclosure.\n\nResolution\n==========\n\nUpgrade to 9.6.6-1.\n\n# pacman -Syu \"postgresql-old-upgrade>=9.6.6-1\"\n\nThe problems have been fixed upstream in version 9.6.6.\n\nWorkaround\n==========\n\nNone.\n\nDescription\n===========\n\n- CVE-2017-15098 (information disclosure)\n\nA denial of service and potential memory disclosure vulnerability has\nbeen discovered in PostgreSQL in the json_populate_recordset() and\njsonb_populate_recordset() functions.\n\n- CVE-2017-15099 (access restriction bypass)\n\nAn access restriction bypass vulnerability has been discovered in\nPostgreSQL, the \"INSERT ... ON CONFLICT DO UPDATE\" would not check to\nsee if the executing user had permission to perform a \"SELECT\" on the\nindex performing the conflicting check. Additionally, in a table with\nrow-level security enabled, the \"INSERT ... ON CONFLICT DO UPDATE\"\nwould not check the SELECT policies for that table before performing\nthe update.\nThe fix ensures that \"INSERT ... ON CONFLICT DO UPDATE\" checks against\ntable permissions and RLS policies before executing.\n\nImpact\n======\n\nA remote attacker is able to bypass access restrictions via certain\nqueries or possibly leak sensitive information from the running\nprocess.\n\nReferences\n==========\n\nhttps://www.postgresql.org/about/news/1801/\nhttps://security.archlinux.org/CVE-2017-15098\nhttps://security.archlinux.org/CVE-2017-15099", "modified": "2017-11-10T00:00:00", "published": "2017-11-10T00:00:00", "id": "ASA-201711-18", "href": "https://security.archlinux.org/ASA-201711-18", "type": "archlinux", "title": "[ASA-201711-18] postgresql-old-upgrade: multiple issues", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}], "nessus": [{"lastseen": "2020-06-05T11:13:57", "description": "This update for postgresql96 fixes the following issues :\n\nSecurity issues fixed :\n\n - CVE-2017-15098: Fix crash due to rowtype mismatch in\n json(b)_populate_recordset() (bsc#1067844).\n\n - CVE-2017-15099: Ensure that INSERT ... ON CONFLICT DO\n UPDATE checks table permissions and RLS policies in all\n cases (bsc#1067841).\n\nBug fixes :\n\n - Update to version 9.6.6 :\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-6.html\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-5.html\n\nThis update was imported from the SUSE:SLE-12:Update update project.", "edition": 21, "cvss3": {"score": 8.1, "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H"}, "published": "2017-12-26T00:00:00", "title": "openSUSE Security Update : postgresql96 (openSUSE-2017-1411)", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "modified": "2017-12-26T00:00:00", "cpe": ["p-cpe:/a:novell:opensuse:libecpg6-32bit", "p-cpe:/a:novell:opensuse:postgresql96-plpython-debuginfo", "p-cpe:/a:novell:opensuse:postgresql96-contrib-debuginfo", "p-cpe:/a:novell:opensuse:libpq5-debuginfo", "p-cpe:/a:novell:opensuse:postgresql96-contrib", "p-cpe:/a:novell:opensuse:postgresql96-server", "p-cpe:/a:novell:opensuse:postgresql96-devel", "p-cpe:/a:novell:opensuse:postgresql96-debugsource", "p-cpe:/a:novell:opensuse:postgresql96-plperl", "p-cpe:/a:novell:opensuse:postgresql96-pltcl", "p-cpe:/a:novell:opensuse:postgresql96-pltcl-debuginfo", "p-cpe:/a:novell:opensuse:postgresql96-libs-debugsource", "p-cpe:/a:novell:opensuse:libecpg6-debuginfo-32bit", "p-cpe:/a:novell:opensuse:postgresql96-debuginfo", "p-cpe:/a:novell:opensuse:libecpg6", "p-cpe:/a:novell:opensuse:libpq5-32bit", "p-cpe:/a:novell:opensuse:libpq5", "p-cpe:/a:novell:opensuse:postgresql96-plperl-debuginfo", "p-cpe:/a:novell:opensuse:postgresql96-plpython", "cpe:/o:novell:opensuse:42.3", "cpe:/o:novell:opensuse:42.2", "p-cpe:/a:novell:opensuse:postgresql96-devel-debuginfo", "p-cpe:/a:novell:opensuse:postgresql96-server-debuginfo", "p-cpe:/a:novell:opensuse:postgresql96-test", "p-cpe:/a:novell:opensuse:libpq5-debuginfo-32bit", "p-cpe:/a:novell:opensuse:libecpg6-debuginfo", "p-cpe:/a:novell:opensuse:postgresql96"], "id": "OPENSUSE-2017-1411.NASL", "href": "https://www.tenable.com/plugins/nessus/105454", "sourceData": "#%NASL_MIN_LEVEL 80502\n#\n# (C) Tenable Network Security, Inc.\n#\n# The descriptive text and package checks in this plugin were\n# extracted from openSUSE Security Update openSUSE-2017-1411.\n#\n# The text description of this plugin is (C) SUSE LLC.\n#\n\ninclude(\"compat.inc\");\n\nif (description)\n{\n script_id(105454);\n script_version(\"3.8\");\n script_set_attribute(attribute:\"plugin_modification_date\", value:\"2020/06/04\");\n\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\");\n\n script_name(english:\"openSUSE Security Update : postgresql96 (openSUSE-2017-1411)\");\n script_summary(english:\"Check for the openSUSE-2017-1411 patch\");\n\n script_set_attribute(\n attribute:\"synopsis\", \n value:\"The remote openSUSE host is missing a security update.\"\n );\n script_set_attribute(\n attribute:\"description\", \n value:\n\"This update for postgresql96 fixes the following issues :\n\nSecurity issues fixed :\n\n - CVE-2017-15098: Fix crash due to rowtype mismatch in\n json(b)_populate_recordset() (bsc#1067844).\n\n - CVE-2017-15099: Ensure that INSERT ... ON CONFLICT DO\n UPDATE checks table permissions and RLS policies in all\n cases (bsc#1067841).\n\nBug fixes :\n\n - Update to version 9.6.6 :\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-6.html\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-5.html\n\nThis update was imported from the SUSE:SLE-12:Update update project.\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1067841\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1067844\"\n );\n # https://www.postgresql.org/docs/9.6/static/release-9-6-5.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.6/release-9-6-5.html\"\n );\n # https://www.postgresql.org/docs/9.6/static/release-9-6-6.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.6/release-9-6-6.html\"\n );\n script_set_attribute(\n attribute:\"solution\", \n value:\"Update the affected postgresql96 packages.\"\n );\n script_set_cvss_base_vector(\"CVSS2#AV:N/AC:L/Au:S/C:P/I:N/A:P\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libecpg6\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libecpg6-32bit\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libecpg6-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libecpg6-debuginfo-32bit\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libpq5\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libpq5-32bit\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libpq5-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:libpq5-debuginfo-32bit\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-contrib\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-contrib-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-debugsource\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-devel\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-devel-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-libs-debugsource\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-plperl\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-plperl-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-plpython\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-plpython-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-pltcl\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-pltcl-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-server-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql96-test\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:novell:opensuse:42.2\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:novell:opensuse:42.3\");\n\n script_set_attribute(attribute:\"vuln_publication_date\", value:\"2017/11/22\");\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/12/22\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2017/12/26\");\n script_set_attribute(attribute:\"generated_plugin\", value:\"current\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_copyright(english:\"This script is Copyright (C) 2017-2020 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n script_family(english:\"SuSE Local Security Checks\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/local_checks_enabled\", \"Host/SuSE/release\", \"Host/SuSE/rpm-list\", \"Host/cpu\");\n\n exit(0);\n}\n\n\ninclude(\"audit.inc\");\ninclude(\"global_settings.inc\");\ninclude(\"rpm.inc\");\n\nif (!get_kb_item(\"Host/local_checks_enabled\")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\nrelease = get_kb_item(\"Host/SuSE/release\");\nif (isnull(release) || release =~ \"^(SLED|SLES)\") audit(AUDIT_OS_NOT, \"openSUSE\");\nif (release !~ \"^(SUSE42\\.2|SUSE42\\.3)$\") audit(AUDIT_OS_RELEASE_NOT, \"openSUSE\", \"42.2 / 42.3\", release);\nif (!get_kb_item(\"Host/SuSE/rpm-list\")) audit(AUDIT_PACKAGE_LIST_MISSING);\n\nourarch = get_kb_item(\"Host/cpu\");\nif (!ourarch) audit(AUDIT_UNKNOWN_ARCH);\nif (ourarch !~ \"^(i586|i686|x86_64)$\") audit(AUDIT_ARCH_NOT, \"i586 / i686 / x86_64\", ourarch);\n\nflag = 0;\n\nif ( rpm_check(release:\"SUSE42.2\", reference:\"libecpg6-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"libecpg6-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"libpq5-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"libpq5-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-contrib-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-contrib-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-debugsource-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-devel-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-devel-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-libs-debugsource-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-plperl-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-plperl-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-plpython-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-plpython-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-pltcl-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-pltcl-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-server-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-server-debuginfo-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", reference:\"postgresql96-test-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", cpu:\"x86_64\", reference:\"libecpg6-32bit-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", cpu:\"x86_64\", reference:\"libecpg6-debuginfo-32bit-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", cpu:\"x86_64\", reference:\"libpq5-32bit-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.2\", cpu:\"x86_64\", reference:\"libpq5-debuginfo-32bit-9.6.6-8.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"libecpg6-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"libecpg6-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"libpq5-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"libpq5-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-contrib-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-contrib-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-debugsource-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-devel-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-devel-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-libs-debugsource-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-plperl-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-plperl-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-plpython-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-plpython-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-pltcl-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-pltcl-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-server-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-server-debuginfo-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql96-test-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", cpu:\"x86_64\", reference:\"libecpg6-32bit-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", cpu:\"x86_64\", reference:\"libecpg6-debuginfo-32bit-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", cpu:\"x86_64\", reference:\"libpq5-32bit-9.6.6-9.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", cpu:\"x86_64\", reference:\"libpq5-debuginfo-32bit-9.6.6-9.1\") ) flag++;\n\nif (flag)\n{\n if (report_verbosity > 0) security_warning(port:0, extra:rpm_report_get());\n else security_warning(0);\n exit(0);\n}\nelse\n{\n tested = pkg_tests_get();\n if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);\n else audit(AUDIT_PACKAGE_NOT_INSTALLED, \"libecpg6-32bit / libecpg6 / libecpg6-debuginfo-32bit / etc\");\n}\n", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2021-01-01T06:46:07", "description": "David Rowley discovered that PostgreSQL incorrectly handled memory\nwhen processing certain JSON functions. A remote attacker could\npossibly use this issue to obtain sensitive information.\n(CVE-2017-15098)\n\nDean Rasheed discovered that PostgreSQL incorrectly enforced SELECT\nprivileges when processing INSERT ... ON CONFLICT DO UPDATE commands.\nA remote attacker could possibly use this issue to obtain sensitive\ninformation. This issue only affected Ubuntu 16.04 LTS, Ubuntu 17.04\nand Ubuntu 17.10.\n\nNote that Tenable Network Security has extracted the preceding\ndescription block directly from the Ubuntu security advisory. Tenable\nhas attempted to automatically clean and format it as much as possible\nwithout introducing additional issues.", "edition": 31, "cvss3": {"score": 8.1, "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H"}, "published": "2017-11-15T00:00:00", "title": "Ubuntu 14.04 LTS / 16.04 LTS / 17.04 / 17.10 : postgresql-9.3, postgresql-9.5, postgresql-9.6 vulnerabilities (USN-3479-1)", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "modified": "2021-01-02T00:00:00", "cpe": ["p-cpe:/a:canonical:ubuntu_linux:postgresql-9.6", "p-cpe:/a:canonical:ubuntu_linux:postgresql-9.3", "cpe:/o:canonical:ubuntu_linux:17.10", "cpe:/o:canonical:ubuntu_linux:17.04", "cpe:/o:canonical:ubuntu_linux:16.04", "p-cpe:/a:canonical:ubuntu_linux:postgresql-9.5", "cpe:/o:canonical:ubuntu_linux:14.04"], "id": "UBUNTU_USN-3479-1.NASL", "href": "https://www.tenable.com/plugins/nessus/104569", "sourceData": "#\n# (C) Tenable Network Security, Inc.\n#\n# The descriptive text and package checks in this plugin were\n# extracted from Ubuntu Security Notice USN-3479-1. The text \n# itself is copyright (C) Canonical, Inc. See \n# <http://www.ubuntu.com/usn/>. Ubuntu(R) is a registered \n# trademark of Canonical, Inc.\n#\n\ninclude(\"compat.inc\");\n\nif (description)\n{\n script_id(104569);\n script_version(\"3.12\");\n script_cvs_date(\"Date: 2019/09/18 12:31:47\");\n\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\");\n script_xref(name:\"USN\", value:\"3479-1\");\n\n script_name(english:\"Ubuntu 14.04 LTS / 16.04 LTS / 17.04 / 17.10 : postgresql-9.3, postgresql-9.5, postgresql-9.6 vulnerabilities (USN-3479-1)\");\n script_summary(english:\"Checks dpkg output for updated packages.\");\n\n script_set_attribute(\n attribute:\"synopsis\", \n value:\n\"The remote Ubuntu host is missing one or more security-related\npatches.\"\n );\n script_set_attribute(\n attribute:\"description\", \n value:\n\"David Rowley discovered that PostgreSQL incorrectly handled memory\nwhen processing certain JSON functions. A remote attacker could\npossibly use this issue to obtain sensitive information.\n(CVE-2017-15098)\n\nDean Rasheed discovered that PostgreSQL incorrectly enforced SELECT\nprivileges when processing INSERT ... ON CONFLICT DO UPDATE commands.\nA remote attacker could possibly use this issue to obtain sensitive\ninformation. This issue only affected Ubuntu 16.04 LTS, Ubuntu 17.04\nand Ubuntu 17.10.\n\nNote that Tenable Network Security has extracted the preceding\ndescription block directly from the Ubuntu security advisory. Tenable\nhas attempted to automatically clean and format it as much as possible\nwithout introducing additional issues.\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://usn.ubuntu.com/3479-1/\"\n );\n script_set_attribute(\n attribute:\"solution\", \n value:\n\"Update the affected postgresql-9.3, postgresql-9.5 and / or\npostgresql-9.6 packages.\"\n );\n script_set_cvss_base_vector(\"CVSS2#AV:N/AC:L/Au:S/C:P/I:N/A:P\");\n script_set_cvss_temporal_vector(\"CVSS2#E:U/RL:OF/RC:C\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H\");\n script_set_cvss3_temporal_vector(\"CVSS:3.0/E:U/RL:O/RC:C\");\n script_set_attribute(attribute:\"exploitability_ease\", value:\"No known exploits are available\");\n script_set_attribute(attribute:\"exploit_available\", value:\"false\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:canonical:ubuntu_linux:postgresql-9.3\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:canonical:ubuntu_linux:postgresql-9.5\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:canonical:ubuntu_linux:postgresql-9.6\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:canonical:ubuntu_linux:14.04\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:canonical:ubuntu_linux:16.04\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:canonical:ubuntu_linux:17.04\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:canonical:ubuntu_linux:17.10\");\n\n script_set_attribute(attribute:\"vuln_publication_date\", value:\"2017/11/22\");\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/11/14\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2017/11/15\");\n script_set_attribute(attribute:\"generated_plugin\", value:\"current\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_copyright(english:\"Ubuntu Security Notice (C) 2017-2019 Canonical, Inc. / NASL script (C) 2017-2019 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n script_family(english:\"Ubuntu Local Security Checks\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/cpu\", \"Host/Ubuntu\", \"Host/Ubuntu/release\", \"Host/Debian/dpkg-l\");\n\n exit(0);\n}\n\n\ninclude(\"audit.inc\");\ninclude(\"ubuntu.inc\");\ninclude(\"misc_func.inc\");\n\nif ( ! get_kb_item(\"Host/local_checks_enabled\") ) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\nrelease = get_kb_item(\"Host/Ubuntu/release\");\nif ( isnull(release) ) audit(AUDIT_OS_NOT, \"Ubuntu\");\nrelease = chomp(release);\nif (! preg(pattern:\"^(14\\.04|16\\.04|17\\.04|17\\.10)$\", string:release)) audit(AUDIT_OS_NOT, \"Ubuntu 14.04 / 16.04 / 17.04 / 17.10\", \"Ubuntu \" + release);\nif ( ! get_kb_item(\"Host/Debian/dpkg-l\") ) audit(AUDIT_PACKAGE_LIST_MISSING);\n\ncpu = get_kb_item(\"Host/cpu\");\nif (isnull(cpu)) audit(AUDIT_UNKNOWN_ARCH);\nif (\"x86_64\" >!< cpu && cpu !~ \"^i[3-6]86$\") audit(AUDIT_LOCAL_CHECKS_NOT_IMPLEMENTED, \"Ubuntu\", cpu);\n\nflag = 0;\n\nif (ubuntu_check(osver:\"14.04\", pkgname:\"postgresql-9.3\", pkgver:\"9.3.20-0ubuntu0.14.04\")) flag++;\nif (ubuntu_check(osver:\"16.04\", pkgname:\"postgresql-9.5\", pkgver:\"9.5.10-0ubuntu0.16.04\")) flag++;\nif (ubuntu_check(osver:\"17.04\", pkgname:\"postgresql-9.6\", pkgver:\"9.6.6-0ubuntu0.17.04\")) flag++;\nif (ubuntu_check(osver:\"17.10\", pkgname:\"postgresql-9.6\", pkgver:\"9.6.6-0ubuntu0.17.10\")) flag++;\n\nif (flag)\n{\n security_report_v4(\n port : 0,\n severity : SECURITY_WARNING,\n extra : ubuntu_report_get()\n );\n exit(0);\n}\nelse\n{\n tested = ubuntu_pkg_tests_get();\n if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);\n else audit(AUDIT_PACKAGE_NOT_INSTALLED, \"postgresql-9.3 / postgresql-9.5 / postgresql-9.6\");\n}\n", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2021-01-06T10:47:55", "description": "The PostgreSQL project reports :\n\n- CVE-2017-15098: Memory disclosure in JSON functions\n\n- CVE-2017-15099: INSERT ... ON CONFLICT DO UPDATE fails to enforce\nSELECT privileges", "edition": 30, "cvss3": {"score": 8.1, "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H"}, "published": "2017-11-10T00:00:00", "title": "FreeBSD : PostgreSQL vulnerabilities (1f02af5d-c566-11e7-a12d-6cc21735f730)", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "modified": "2017-11-10T00:00:00", "cpe": ["p-cpe:/a:freebsd:freebsd:postgresql94-server", "cpe:/o:freebsd:freebsd", "p-cpe:/a:freebsd:freebsd:postgresql96-server", "p-cpe:/a:freebsd:freebsd:postgresql93-server", "p-cpe:/a:freebsd:freebsd:postgresql10-server", "p-cpe:/a:freebsd:freebsd:postgresql95-server", "p-cpe:/a:freebsd:freebsd:postgresql92-server"], "id": "FREEBSD_PKG_1F02AF5DC56611E7A12D6CC21735F730.NASL", "href": "https://www.tenable.com/plugins/nessus/104489", "sourceData": "#%NASL_MIN_LEVEL 70300\n#\n# (C) Tenable Network Security, Inc.\n#\n# The descriptive text and package checks in this plugin were \n# extracted from the FreeBSD VuXML database :\n#\n# Copyright 2003-2018 Jacques Vidrine and contributors\n#\n# Redistribution and use in source (VuXML) and 'compiled' forms (SGML,\n# HTML, PDF, PostScript, RTF and so forth) with or without modification,\n# are permitted provided that the following conditions are met:\n# 1. Redistributions of source code (VuXML) must retain the above\n# copyright notice, this list of conditions and the following\n# disclaimer as the first lines of this file unmodified.\n# 2. Redistributions in compiled form (transformed to other DTDs,\n# published online in any format, converted to PDF, PostScript,\n# RTF and other formats) must reproduce the above copyright\n# notice, this list of conditions and the following disclaimer\n# in the documentation and/or other materials provided with the\n# distribution.\n# \n# THIS DOCUMENTATION IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS \"AS IS\"\n# AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,\n# THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR\n# PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS\n# BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY,\n# OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT\n# OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR\n# BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,\n# WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE\n# OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS DOCUMENTATION,\n# EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.\n#\n\ninclude('deprecated_nasl_level.inc');\ninclude('compat.inc');\n\nif (description)\n{\n script_id(104489);\n script_version(\"3.9\");\n script_set_attribute(attribute:\"plugin_modification_date\", value:\"2021/01/04\");\n\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\");\n\n script_name(english:\"FreeBSD : PostgreSQL vulnerabilities (1f02af5d-c566-11e7-a12d-6cc21735f730)\");\n script_summary(english:\"Checks for updated packages in pkg_info output\");\n\n script_set_attribute(\n attribute:\"synopsis\", \n value:\n\"The remote FreeBSD host is missing one or more security-related\nupdates.\"\n );\n script_set_attribute(\n attribute:\"description\", \n value:\n\"The PostgreSQL project reports :\n\n- CVE-2017-15098: Memory disclosure in JSON functions\n\n- CVE-2017-15099: INSERT ... ON CONFLICT DO UPDATE fails to enforce\nSELECT privileges\"\n );\n # https://vuxml.freebsd.org/freebsd/1f02af5d-c566-11e7-a12d-6cc21735f730.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"http://www.nessus.org/u?8325e978\"\n );\n script_set_attribute(attribute:\"solution\", value:\"Update the affected packages.\");\n script_set_cvss_base_vector(\"CVSS2#AV:N/AC:L/Au:S/C:P/I:N/A:P\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:freebsd:freebsd:postgresql10-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:freebsd:freebsd:postgresql92-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:freebsd:freebsd:postgresql93-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:freebsd:freebsd:postgresql94-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:freebsd:freebsd:postgresql95-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:freebsd:freebsd:postgresql96-server\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:freebsd:freebsd\");\n\n script_set_attribute(attribute:\"vuln_publication_date\", value:\"2017/10/10\");\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/11/09\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2017/11/10\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_copyright(english:\"This script is Copyright (C) 2017-2021 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n script_family(english:\"FreeBSD Local Security Checks\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/local_checks_enabled\", \"Host/FreeBSD/release\", \"Host/FreeBSD/pkg_info\");\n\n exit(0);\n}\n\n\ninclude(\"audit.inc\");\ninclude(\"freebsd_package.inc\");\n\n\nif (!get_kb_item(\"Host/local_checks_enabled\")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\nif (!get_kb_item(\"Host/FreeBSD/release\")) audit(AUDIT_OS_NOT, \"FreeBSD\");\nif (!get_kb_item(\"Host/FreeBSD/pkg_info\")) audit(AUDIT_PACKAGE_LIST_MISSING);\n\n\nflag = 0;\n\nif (pkg_test(save_report:TRUE, pkg:\"postgresql92-server>=9.2.0<9.2.24\")) flag++;\nif (pkg_test(save_report:TRUE, pkg:\"postgresql93-server>=9.3.0<9.3.20\")) flag++;\nif (pkg_test(save_report:TRUE, pkg:\"postgresql94-server>=9.4.0<9.4.15\")) flag++;\nif (pkg_test(save_report:TRUE, pkg:\"postgresql95-server>=9.5.0<9.5.10\")) flag++;\nif (pkg_test(save_report:TRUE, pkg:\"postgresql96-server>=9.6.0<9.6.6\")) flag++;\nif (pkg_test(save_report:TRUE, pkg:\"postgresql10-server>=10.0<10.1\")) flag++;\n\nif (flag)\n{\n if (report_verbosity > 0) security_warning(port:0, extra:pkg_report_get());\n else security_warning(0);\n exit(0);\n}\nelse audit(AUDIT_HOST_NOT, \"affected\");\n", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2021-01-06T09:51:03", "description": "Several vulnerabilities have been found in the PostgreSQL database\nsystem :\n\n - CVE-2017-15098\n Denial of service and potential memory disclosure in the\n json_populate_recordset() and jsonb_populate_recordset()\n functions\n\n - CVE-2017-15099\n Insufficient permissions checks in 'INSERT ... ON\n CONFLICT DO UPDATE' statements.", "edition": 31, "cvss3": {"score": 8.1, "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H"}, "published": "2017-11-10T00:00:00", "title": "Debian DSA-4028-1 : postgresql-9.6 - security update", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "modified": "2017-11-10T00:00:00", "cpe": ["p-cpe:/a:debian:debian_linux:postgresql-9.6", "cpe:/o:debian:debian_linux:9.0"], "id": "DEBIAN_DSA-4028.NASL", "href": "https://www.tenable.com/plugins/nessus/104484", "sourceData": "#%NASL_MIN_LEVEL 70300\n#\n# (C) Tenable Network Security, Inc.\n#\n# The descriptive text and package checks in this plugin were \n# extracted from Debian Security Advisory DSA-4028. The text \n# itself is copyright (C) Software in the Public Interest, Inc.\n#\n\ninclude('deprecated_nasl_level.inc');\ninclude('compat.inc');\n\nif (description)\n{\n script_id(104484);\n script_version(\"3.9\");\n script_set_attribute(attribute:\"plugin_modification_date\", value:\"2021/01/04\");\n\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\");\n script_xref(name:\"DSA\", value:\"4028\");\n\n script_name(english:\"Debian DSA-4028-1 : postgresql-9.6 - security update\");\n script_summary(english:\"Checks dpkg output for the updated package\");\n\n script_set_attribute(\n attribute:\"synopsis\", \n value:\"The remote Debian host is missing a security-related update.\"\n );\n script_set_attribute(\n attribute:\"description\", \n value:\n\"Several vulnerabilities have been found in the PostgreSQL database\nsystem :\n\n - CVE-2017-15098\n Denial of service and potential memory disclosure in the\n json_populate_recordset() and jsonb_populate_recordset()\n functions\n\n - CVE-2017-15099\n Insufficient permissions checks in 'INSERT ... ON\n CONFLICT DO UPDATE' statements.\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://security-tracker.debian.org/tracker/CVE-2017-15098\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://security-tracker.debian.org/tracker/CVE-2017-15099\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://packages.debian.org/source/stretch/postgresql-9.6\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.debian.org/security/2017/dsa-4028\"\n );\n script_set_attribute(\n attribute:\"solution\", \n value:\n\"Upgrade the postgresql-9.6 packages.\n\nFor the stable distribution (stretch), these problems have been fixed\nin version 9.6.6-0+deb9u1.\"\n );\n script_set_cvss_base_vector(\"CVSS2#AV:N/AC:L/Au:S/C:P/I:N/A:P\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:debian:debian_linux:postgresql-9.6\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:debian:debian_linux:9.0\");\n\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/11/09\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2017/11/10\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_copyright(english:\"This script is Copyright (C) 2017-2021 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n script_family(english:\"Debian Local Security Checks\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/local_checks_enabled\", \"Host/Debian/release\", \"Host/Debian/dpkg-l\");\n\n exit(0);\n}\n\n\ninclude(\"audit.inc\");\ninclude(\"debian_package.inc\");\n\n\nif (!get_kb_item(\"Host/local_checks_enabled\")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\nif (!get_kb_item(\"Host/Debian/release\")) audit(AUDIT_OS_NOT, \"Debian\");\nif (!get_kb_item(\"Host/Debian/dpkg-l\")) audit(AUDIT_PACKAGE_LIST_MISSING);\n\n\nflag = 0;\nif (deb_check(release:\"9.0\", prefix:\"libecpg-compat3\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"libecpg-dev\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"libecpg6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"libpgtypes3\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"libpq-dev\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"libpq5\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-9.6-dbg\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-client-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-contrib-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-doc-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-plperl-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-plpython-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-plpython3-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-pltcl-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\nif (deb_check(release:\"9.0\", prefix:\"postgresql-server-dev-9.6\", reference:\"9.6.6-0+deb9u1\")) flag++;\n\nif (flag)\n{\n if (report_verbosity > 0) security_warning(port:0, extra:deb_report_get());\n else security_warning(0);\n exit(0);\n}\nelse audit(AUDIT_HOST_NOT, \"affected\");\n", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2021-01-07T14:27:34", "description": "This update for postgresql96 fixes the following issues: Security\nissues fixed :\n\n - CVE-2017-15098: Fix crash due to rowtype mismatch in\n json{b}_populate_recordset() (bsc#1067844).\n\n - CVE-2017-15099: Ensure that INSERT ... ON CONFLICT DO\n UPDATE checks table permissions and RLS policies in all\n cases (bsc#1067841). Bug fixes :\n\n - Update to version 9.6.6 :\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-6.html\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-5.html\n\nNote that Tenable Network Security has extracted the preceding\ndescription block directly from the SUSE security advisory. Tenable\nhas attempted to automatically clean and format it as much as possible\nwithout introducing additional issues.", "edition": 30, "cvss3": {"score": 8.1, "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H"}, "published": "2017-12-26T00:00:00", "title": "SUSE SLED12 / SLES12 Security Update : postgresql96 (SUSE-SU-2017:3391-1)", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-15099", "CVE-2017-15098"], "modified": "2017-12-26T00:00:00", "cpe": ["p-cpe:/a:novell:suse_linux:postgresql96-server-debuginfo", "cpe:/o:novell:suse_linux:12", "p-cpe:/a:novell:suse_linux:postgresql96-debugsource", "p-cpe:/a:novell:suse_linux:libpq5", "p-cpe:/a:novell:suse_linux:postgresql96-debuginfo", "p-cpe:/a:novell:suse_linux:postgresql96-libs-debugsource", "p-cpe:/a:novell:suse_linux:libecpg6", "p-cpe:/a:novell:suse_linux:libecpg6-debuginfo", "p-cpe:/a:novell:suse_linux:postgresql96-contrib-debuginfo", "p-cpe:/a:novell:suse_linux:postgresql96", "p-cpe:/a:novell:suse_linux:libpq5-debuginfo", "p-cpe:/a:novell:suse_linux:postgresql96-server", "p-cpe:/a:novell:suse_linux:postgresql96-contrib"], "id": "SUSE_SU-2017-3391-1.NASL", "href": "https://www.tenable.com/plugins/nessus/105458", "sourceData": "#%NASL_MIN_LEVEL 70300\n#\n# (C) Tenable Network Security, Inc.\n#\n# The descriptive text and package checks in this plugin were\n# extracted from SUSE update advisory SUSE-SU-2017:3391-1.\n# The text itself is copyright (C) SUSE.\n#\n\ninclude('deprecated_nasl_level.inc');\ninclude('compat.inc');\n\nif (description)\n{\n script_id(105458);\n script_version(\"3.11\");\n script_set_attribute(attribute:\"plugin_modification_date\", value:\"2021/01/06\");\n\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\");\n\n script_name(english:\"SUSE SLED12 / SLES12 Security Update : postgresql96 (SUSE-SU-2017:3391-1)\");\n script_summary(english:\"Checks rpm output for the updated packages.\");\n\n script_set_attribute(\n attribute:\"synopsis\", \n value:\"The remote SUSE host is missing one or more security updates.\"\n );\n script_set_attribute(\n attribute:\"description\", \n value:\n\"This update for postgresql96 fixes the following issues: Security\nissues fixed :\n\n - CVE-2017-15098: Fix crash due to rowtype mismatch in\n json{b}_populate_recordset() (bsc#1067844).\n\n - CVE-2017-15099: Ensure that INSERT ... ON CONFLICT DO\n UPDATE checks table permissions and RLS policies in all\n cases (bsc#1067841). Bug fixes :\n\n - Update to version 9.6.6 :\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-6.html\n\n - https://www.postgresql.org/docs/9.6/static/release-9-6-5.html\n\nNote that Tenable Network Security has extracted the preceding\ndescription block directly from the SUSE security advisory. Tenable\nhas attempted to automatically clean and format it as much as possible\nwithout introducing additional issues.\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.suse.com/show_bug.cgi?id=1067841\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.suse.com/show_bug.cgi?id=1067844\"\n );\n # https://www.postgresql.org/docs/9.6/static/release-9-6-5.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.6/release-9-6-5.html\"\n );\n # https://www.postgresql.org/docs/9.6/static/release-9-6-6.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.6/release-9-6-6.html\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.suse.com/security/cve/CVE-2017-15098/\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.suse.com/security/cve/CVE-2017-15099/\"\n );\n # https://www.suse.com/support/update/announcement/2017/suse-su-20173391-1/\n script_set_attribute(\n attribute:\"see_also\",\n value:\"http://www.nessus.org/u?08b8f651\"\n );\n script_set_attribute(\n attribute:\"solution\", \n value:\n\"To install this SUSE Security Update use YaST online_update.\nAlternatively you can run the command listed for your product :\n\nSUSE Linux Enterprise Software Development Kit 12-SP3:zypper in -t\npatch SUSE-SLE-SDK-12-SP3-2017-2127=1\n\nSUSE Linux Enterprise Software Development Kit 12-SP2:zypper in -t\npatch SUSE-SLE-SDK-12-SP2-2017-2127=1\n\nSUSE Linux Enterprise Server for Raspberry Pi 12-SP2:zypper in -t\npatch SUSE-SLE-RPI-12-SP2-2017-2127=1\n\nSUSE Linux Enterprise Server 12-SP3:zypper in -t patch\nSUSE-SLE-SERVER-12-SP3-2017-2127=1\n\nSUSE Linux Enterprise Server 12-SP2:zypper in -t patch\nSUSE-SLE-SERVER-12-SP2-2017-2127=1\n\nSUSE Linux Enterprise Desktop 12-SP3:zypper in -t patch\nSUSE-SLE-DESKTOP-12-SP3-2017-2127=1\n\nSUSE Linux Enterprise Desktop 12-SP2:zypper in -t patch\nSUSE-SLE-DESKTOP-12-SP2-2017-2127=1\n\nTo bring your system up-to-date, use 'zypper patch'.\"\n );\n script_set_cvss_base_vector(\"CVSS2#AV:N/AC:L/Au:S/C:P/I:N/A:P\");\n script_set_cvss_temporal_vector(\"CVSS2#E:U/RL:OF/RC:C\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H\");\n script_set_cvss3_temporal_vector(\"CVSS:3.0/E:U/RL:O/RC:C\");\n script_set_attribute(attribute:\"exploitability_ease\", value:\"No known exploits are available\");\n script_set_attribute(attribute:\"exploit_available\", value:\"false\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:libecpg6\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:libecpg6-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:libpq5\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:libpq5-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96-contrib\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96-contrib-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96-debugsource\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96-libs-debugsource\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:suse_linux:postgresql96-server-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:novell:suse_linux:12\");\n\n script_set_attribute(attribute:\"vuln_publication_date\", value:\"2017/11/22\");\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/12/21\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2017/12/26\");\n script_set_attribute(attribute:\"generated_plugin\", value:\"current\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_copyright(english:\"This script is Copyright (C) 2017-2021 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n script_family(english:\"SuSE Local Security Checks\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/local_checks_enabled\", \"Host/cpu\", \"Host/SuSE/release\", \"Host/SuSE/rpm-list\");\n\n exit(0);\n}\n\n\ninclude(\"audit.inc\");\ninclude(\"global_settings.inc\");\ninclude(\"rpm.inc\");\n\n\nif (!get_kb_item(\"Host/local_checks_enabled\")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\nrelease = get_kb_item(\"Host/SuSE/release\");\nif (isnull(release) || release !~ \"^(SLED|SLES)\") audit(AUDIT_OS_NOT, \"SUSE\");\nos_ver = pregmatch(pattern: \"^(SLE(S|D)\\d+)\", string:release);\nif (isnull(os_ver)) audit(AUDIT_UNKNOWN_APP_VER, \"SUSE\");\nos_ver = os_ver[1];\nif (! preg(pattern:\"^(SLED12|SLES12)$\", string:os_ver)) audit(AUDIT_OS_NOT, \"SUSE SLED12 / SLES12\", \"SUSE \" + os_ver);\n\nif (!get_kb_item(\"Host/SuSE/rpm-list\")) audit(AUDIT_PACKAGE_LIST_MISSING);\n\ncpu = get_kb_item(\"Host/cpu\");\nif (isnull(cpu)) audit(AUDIT_UNKNOWN_ARCH);\nif (cpu !~ \"^i[3-6]86$\" && \"x86_64\" >!< cpu && \"s390x\" >!< cpu) audit(AUDIT_LOCAL_CHECKS_NOT_IMPLEMENTED, \"SUSE \" + os_ver, cpu);\n\nsp = get_kb_item(\"Host/SuSE/patchlevel\");\nif (isnull(sp)) sp = \"0\";\nif (os_ver == \"SLES12\" && (! preg(pattern:\"^(2|3)$\", string:sp))) audit(AUDIT_OS_NOT, \"SLES12 SP2/3\", os_ver + \" SP\" + sp);\nif (os_ver == \"SLED12\" && (! preg(pattern:\"^(2|3)$\", string:sp))) audit(AUDIT_OS_NOT, \"SLED12 SP2/3\", os_ver + \" SP\" + sp);\n\n\nflag = 0;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"libecpg6-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"libecpg6-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"libpq5-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"libpq5-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-contrib-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-contrib-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-debugsource-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-libs-debugsource-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-server-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"postgresql96-server-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"libpq5-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"3\", reference:\"libpq5-debuginfo-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"libecpg6-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"libecpg6-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"libpq5-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"libpq5-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-contrib-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-contrib-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-debugsource-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-libs-debugsource-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-server-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"postgresql96-server-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"libpq5-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLES12\", sp:\"2\", reference:\"libpq5-debuginfo-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"libecpg6-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"libecpg6-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"libpq5-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"libpq5-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"libpq5-debuginfo-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"libpq5-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"postgresql96-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"postgresql96-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"postgresql96-debugsource-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"3\", cpu:\"x86_64\", reference:\"postgresql96-libs-debugsource-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"libecpg6-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"libecpg6-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"libpq5-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"libpq5-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"libpq5-debuginfo-32bit-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"libpq5-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"postgresql96-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"postgresql96-debuginfo-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"postgresql96-debugsource-9.6.6-3.10.1\")) flag++;\nif (rpm_check(release:\"SLED12\", sp:\"2\", cpu:\"x86_64\", reference:\"postgresql96-libs-debugsource-9.6.6-3.10.1\")) flag++;\n\n\nif (flag)\n{\n if (report_verbosity > 0) security_warning(port:0, extra:rpm_report_get());\n else security_warning(0);\n exit(0);\n}\nelse\n{\n tested = pkg_tests_get();\n if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);\n else audit(AUDIT_PACKAGE_NOT_INSTALLED, \"postgresql96\");\n}\n", "cvss": {"score": 5.5, "vector": "AV:N/AC:L/Au:S/C:P/I:N/A:P"}}, {"lastseen": "2021-01-01T01:19:43", "description": "Privilege escalation flaws were found in the initialization scripts of\nPostgreSQL. A remote attacker with access to the postgres user account\ncould use these flaws to obtain root access on the server\nmachine.(CVE-2017-12172)\n\nINSERT ... ON CONFLICT DO UPDATE commands in PostgreSQL disclose table\ncontents that the invoker lacks privilege to read. These exploits\naffect only tables where the attacker lacks full read access but has\nboth INSERT and UPDATE privileges. Exploits bypass row level security\npolicies and lack of SELECT privilege.(CVE-2017-15099)\n\nInvalid json_populate_recordset or jsonb_populate_recordset function\ncalls in PostgreSQL can crash the server or disclose a few bytes of\nserver memory.(CVE-2017-15098)", "edition": 30, "cvss3": {"score": 8.1, "vector": "AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H"}, "published": "2017-12-07T00:00:00", "title": "Amazon Linux AMI : postgresql95 / postgresql96 (ALAS-2017-930)", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-12172", "CVE-2017-15099", "CVE-2017-15098"], "modified": "2021-01-02T00:00:00", "cpe": ["p-cpe:/a:amazon:linux:postgresql96-docs", "p-cpe:/a:amazon:linux:postgresql95-plpython27", "p-cpe:/a:amazon:linux:postgresql96-test", "p-cpe:/a:amazon:linux:postgresql95-docs", "p-cpe:/a:amazon:linux:postgresql96-contrib", "p-cpe:/a:amazon:linux:postgresql95-server", "p-cpe:/a:amazon:linux:postgresql95-contrib", "p-cpe:/a:amazon:linux:postgresql95-plperl", "p-cpe:/a:amazon:linux:postgresql95-test", "p-cpe:/a:amazon:linux:postgresql96-server", "p-cpe:/a:amazon:linux:postgresql96-devel", "p-cpe:/a:amazon:linux:postgresql95-plpython26", "p-cpe:/a:amazon:linux:postgresql96-plpython26", "p-cpe:/a:amazon:linux:postgresql96-libs", "p-cpe:/a:amazon:linux:postgresql95", "p-cpe:/a:amazon:linux:postgresql95-devel", "p-cpe:/a:amazon:linux:postgresql96-static", "p-cpe:/a:amazon:linux:postgresql95-static", "p-cpe:/a:amazon:linux:postgresql95-debuginfo", "p-cpe:/a:amazon:linux:postgresql96-plperl", "p-cpe:/a:amazon:linux:postgresql96", "p-cpe:/a:amazon:linux:postgresql96-debuginfo", "cpe:/o:amazon:linux", "p-cpe:/a:amazon:linux:postgresql96-plpython27", "p-cpe:/a:amazon:linux:postgresql95-libs"], "id": "ALA_ALAS-2017-930.NASL", "href": "https://www.tenable.com/plugins/nessus/105054", "sourceData": "#\n# (C) Tenable Network Security, Inc.\n#\n# The descriptive text and package checks in this plugin were\n# extracted from Amazon Linux AMI Security Advisory ALAS-2017-930.\n#\n\ninclude(\"compat.inc\");\n\nif (description)\n{\n script_id(105054);\n script_version(\"3.8\");\n script_cvs_date(\"Date: 2018/04/18 15:09:36\");\n\n script_cve_id(\"CVE-2017-12172\", \"CVE-2017-15098\", \"CVE-2017-15099\");\n script_xref(name:\"ALAS\", value:\"2017-930\");\n\n script_name(english:\"Amazon Linux AMI : postgresql95 / postgresql96 (ALAS-2017-930)\");\n script_summary(english:\"Checks rpm output for the updated packages\");\n\n script_set_attribute(\n attribute:\"synopsis\", \n value:\"The remote Amazon Linux AMI host is missing a security update.\"\n );\n script_set_attribute(\n attribute:\"description\", \n value:\n\"Privilege escalation flaws were found in the initialization scripts of\nPostgreSQL. A remote attacker with access to the postgres user account\ncould use these flaws to obtain root access on the server\nmachine.(CVE-2017-12172)\n\nINSERT ... ON CONFLICT DO UPDATE commands in PostgreSQL disclose table\ncontents that the invoker lacks privilege to read. These exploits\naffect only tables where the attacker lacks full read access but has\nboth INSERT and UPDATE privileges. Exploits bypass row level security\npolicies and lack of SELECT privilege.(CVE-2017-15099)\n\nInvalid json_populate_recordset or jsonb_populate_recordset function\ncalls in PostgreSQL can crash the server or disclose a few bytes of\nserver memory.(CVE-2017-15098)\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://alas.aws.amazon.com/ALAS-2017-930.html\"\n );\n script_set_attribute(\n attribute:\"solution\", \n value:\n\"Run 'yum update postgresql95' to update your system.\n\nRun 'yum update postgresql96' to update your system.\"\n );\n script_set_cvss_base_vector(\"CVSS2#AV:L/AC:L/Au:N/C:C/I:C/A:C\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:H\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-contrib\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-devel\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-docs\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-libs\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-plperl\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-plpython26\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-plpython27\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-static\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql95-test\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-contrib\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-devel\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-docs\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-libs\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-plperl\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-plpython26\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-plpython27\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-static\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:amazon:linux:postgresql96-test\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:amazon:linux\");\n\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/12/05\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2017/12/07\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_copyright(english:\"This script is Copyright (C) 2017-2018 Tenable Network Security, Inc.\");\n script_family(english:\"Amazon Linux Local Security Checks\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/local_checks_enabled\", \"Host/AmazonLinux/release\", \"Host/AmazonLinux/rpm-list\");\n\n exit(0);\n}\n\n\ninclude(\"audit.inc\");\ninclude(\"global_settings.inc\");\ninclude(\"rpm.inc\");\n\n\nif (!get_kb_item(\"Host/local_checks_enabled\")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\n\nrelease = get_kb_item(\"Host/AmazonLinux/release\");\nif (isnull(release) || !strlen(release)) audit(AUDIT_OS_NOT, \"Amazon Linux\");\nos_ver = pregmatch(pattern: \"^AL(A|\\d)\", string:release);\nif (isnull(os_ver)) audit(AUDIT_UNKNOWN_APP_VER, \"Amazon Linux\");\nos_ver = os_ver[1];\nif (os_ver != \"A\")\n{\n if (os_ver == 'A') os_ver = 'AMI';\n audit(AUDIT_OS_NOT, \"Amazon Linux AMI\", \"Amazon Linux \" + os_ver);\n}\n\nif (!get_kb_item(\"Host/AmazonLinux/rpm-list\")) audit(AUDIT_PACKAGE_LIST_MISSING);\n\n\nflag = 0;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-contrib-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-debuginfo-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-devel-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-docs-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-libs-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-plperl-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-plpython26-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-plpython27-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-server-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-static-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql95-test-9.5.10-1.77.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-contrib-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-debuginfo-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-devel-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-docs-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-libs-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-plperl-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-plpython26-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-plpython27-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-server-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-static-9.6.6-1.79.amzn1\")) flag++;\nif (rpm_check(release:\"ALA\", reference:\"postgresql96-test-9.6.6-1.79.amzn1\")) flag++;\n\nif (flag)\n{\n if (report_verbosity > 0) security_hole(port:0, extra:rpm_report_get());\n else security_hole(0);\n exit(0);\n}\nelse\n{\n tested = pkg_tests_get();\n if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);\n else audit(AUDIT_PACKAGE_NOT_INSTALLED, \"postgresql95 / postgresql95-contrib / postgresql95-debuginfo / etc\");\n}\n", "cvss": {"score": 7.2, "vector": "AV:L/AC:L/Au:N/C:C/I:C/A:C"}}, {"lastseen": "2021-01-01T04:55:06", "description": "The version of PostgreSQL installed on the remote host is 9.2.x prior\nto 9.2.24, 9.3.x prior to 9.3.20, 9.4.x prior to 9.4.15, 9.5.x prior\nto 9.5.10, 9.6.x prior to 9.6.6, or 10.x prior to 10.1. It is,\ntherefore, affected by multiple vulnerabilities including a denial of\nservice attack.", "edition": 33, "cvss3": {"score": 6.7, "vector": "AV:L/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:H"}, "published": "2017-11-15T00:00:00", "title": "PostgreSQL 9.2.x < 9.2.24 / 9.3.x < 9.3.20 / 9.4.x < 9.4.15 / 9.5.x < 9.5.10 / 9.6.x < 9.6.6 / 10.x < 10.1 Multiple Vulnerabilities", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-12172", "CVE-2017-15099", "CVE-2017-15098"], "modified": "2021-01-02T00:00:00", "cpe": ["cpe:/a:postgresql:postgresql"], "id": "POSTGRESQL_20171109.NASL", "href": "https://www.tenable.com/plugins/nessus/104574", "sourceData": "#\n# (C) Tenable Network Security, Inc\n#\n\ninclude(\"compat.inc\");\n\nif (description)\n{\n script_id(104574);\n script_version(\"1.13\");\n script_cvs_date(\"Date: 2019/11/12\");\n\n script_cve_id(\"CVE-2017-12172\", \"CVE-2017-15098\", \"CVE-2017-15099\");\n\n script_name(english:\"PostgreSQL 9.2.x < 9.2.24 / 9.3.x < 9.3.20 / 9.4.x < 9.4.15 / 9.5.x < 9.5.10 / 9.6.x < 9.6.6 / 10.x < 10.1 Multiple Vulnerabilities\");\n script_summary(english:\"Checks the version of PostgreSQL.\");\n\n script_set_attribute(attribute:\"synopsis\", value:\n\"The remote database server is affected by multiple vulnerabilities.\");\n script_set_attribute(attribute:\"description\", value:\n\"The version of PostgreSQL installed on the remote host is 9.2.x prior\nto 9.2.24, 9.3.x prior to 9.3.20, 9.4.x prior to 9.4.15, 9.5.x prior\nto 9.5.10, 9.6.x prior to 9.6.6, or 10.x prior to 10.1. It is,\ntherefore, affected by multiple vulnerabilities including a denial of\nservice attack.\");\n script_set_attribute(attribute:\"see_also\", value:\"https://www.postgresql.org/about/news/1801/\");\n script_set_attribute(attribute:\"see_also\", value:\"https://www.postgresql.org/docs/current/release-9-2-24.html\");\n script_set_attribute(attribute:\"see_also\", value:\"https://www.postgresql.org/docs/current/release-9-3-20.html\");\n script_set_attribute(attribute:\"see_also\", value:\"https://www.postgresql.org/docs/current/release-9-4-15.html\");\n script_set_attribute(attribute:\"see_also\", value:\"https://www.postgresql.org/docs/current/release-9-5-10.html\");\n script_set_attribute(attribute:\"see_also\", value:\"https://www.postgresql.org/docs/current/release-9-6-6.html\");\n script_set_attribute(attribute:\"see_also\", value:\"https://www.postgresql.org/docs/current/release-10-1.html\");\n script_set_attribute(attribute:\"solution\", value:\n\"Upgrade to PostgreSQL version 9.2.24 / 9.3.20 / 9.4.15 / 9.5.10 /\n9.6.6 / 10.1 or later.\");\n script_set_cvss_base_vector(\"CVSS2#AV:L/AC:L/Au:N/C:C/I:C/A:C\");\n script_set_cvss_temporal_vector(\"CVSS2#E:U/RL:OF/RC:C\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:L/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:H\");\n script_set_cvss3_temporal_vector(\"CVSS:3.0/E:U/RL:O/RC:C\");\n script_set_attribute(attribute:\"cvss_score_source\", value:\"CVE-2017-12172\");\n\n script_set_attribute(attribute:\"exploitability_ease\", value:\"No known exploits are available\");\n script_set_attribute(attribute:\"exploit_available\", value:\"false\");\n\n script_set_attribute(attribute:\"vuln_publication_date\", value:\"2017/11/09\");\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/11/09\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2017/11/15\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/a:postgresql:postgresql\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_family(english:\"Databases\");\n\n script_copyright(english:\"This script is Copyright (C) 2017-2019 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n\n script_dependencies(\"postgresql_version.nbin\");\n script_require_ports(\"Services/postgresql\", 5432);\n\n exit(0);\n}\n\ninclude(\"vcf.inc\");\ninclude(\"vcf_extras.inc\");\ninclude(\"backport.inc\");\n\nport = get_service(svc:\"postgresql\", default:5432, exit_on_fail:TRUE);\nkb_backported = NULL;\n\nversion = get_kb_item_or_exit('database/'+port+'/postgresql/version');\nsource = get_kb_item_or_exit('database/'+port+'/postgresql/source');\nkb_base = \"database/\"+port+\"/postgresql/\";\n\nget_backport_banner(banner:source);\nif (backported)\n{\n if (report_paranoia < 2) audit(AUDIT_BACKPORT_SERVICE, port, 'PostgreSQL server');\n kb_backported = kb_base +\"backported\";\n}\n\napp_info = vcf::get_app_info(app:\"PostgreSQL\", port:port, kb_ver:kb_base+\"version\", kb_backport:kb_backported, service:TRUE); \n\n# 9.2.24 / 9.3.20 / 9.4.15 / 9.5.10 / 9.6.6 / 10.1\nconstraints = [\n { \"min_version\" : \"9.2\", \"fixed_version\" : \"9.2.24\" },\n { \"min_version\" : \"9.3\", \"fixed_version\" : \"9.3.20\" },\n { \"min_version\" : \"9.4\", \"fixed_version\" : \"9.4.15\" },\n { \"min_version\" : \"9.5\", \"fixed_version\" : \"9.5.10\" },\n { \"min_version\" : \"9.6\", \"fixed_version\" : \"9.6.6\" },\n { \"min_version\" : \"10.0\", \"fixed_version\" : \"10.1\" }\n];\n\nvcf::postgresql::check_version_and_report(app_info:app_info, constraints:constraints, severity:SECURITY_HOLE);\n", "cvss": {"score": 7.2, "vector": "AV:L/AC:L/Au:N/C:C/I:C/A:C"}}, {"lastseen": "2019-02-21T01:41:53", "description": "An update of [curl,glibc,postgresql] packages of photonOS has been released.", "edition": 6, "published": "2018-08-17T00:00:00", "title": "Photon OS 1.0: Curl / Glibc PHSA-2017-0048 (deprecated)", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-12172", "CVE-2017-15099", "CVE-2015-5180", "CVE-2017-15098", "CVE-2017-1000257"], "modified": "2019-02-07T00:00:00", "cpe": ["p-cpe:/a:vmware:photonos:curl", "p-cpe:/a:vmware:photonos:glibc", "cpe:/o:vmware:photonos:1.0"], "id": "PHOTONOS_PHSA-2017-0048.NASL", "href": "https://www.tenable.com/plugins/index.php?view=single&id=111897", "sourceData": "#\n# (C) Tenable Network Security, Inc.\n#\n# @DEPRECATED@\n#\n# Disabled on 2/7/2019\n#\n\n# The descriptive text and package checks in this plugin were\n# extracted from VMware Security Advisory PHSA-2017-0048. The text\n# itself is copyright (C) VMware, Inc.\n\ninclude(\"compat.inc\");\n\nif (description)\n{\n script_id(111897);\n script_version(\"1.2\");\n script_cvs_date(\"Date: 2019/02/07 18:59:50\");\n\n script_cve_id(\n \"CVE-2015-5180\",\n \"CVE-2017-12172\",\n \"CVE-2017-15098\",\n \"CVE-2017-15099\",\n \"CVE-2017-1000257\"\n );\n\n script_name(english:\"Photon OS 1.0: Curl / Glibc PHSA-2017-0048 (deprecated)\");\n script_summary(english:\"Checks the rpm output for the updated packages.\");\n\n script_set_attribute(attribute:\"synopsis\", value:\n\"This plugin has been deprecated.\");\n script_set_attribute(attribute:\"description\", value:\n\"An update of [curl,glibc,postgresql] packages of photonOS has been\nreleased.\");\n # https://github.com/vmware/photon/wiki/Security-Updates-88\n script_set_attribute(attribute:\"see_also\", value:\"http://www.nessus.org/u?9bcff977\");\n script_set_attribute(attribute:\"solution\", value:\"n/a.\");\n script_set_cvss_base_vector(\"CVSS2#AV:L/AC:L/Au:N/C:C/I:C/A:C\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:L/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:H\");\n script_set_attribute(attribute:\"cvss_score_source\", value:\"CVE-2017-12172\");\n\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2017/11/30\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2018/08/17\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:vmware:photonos:curl\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:vmware:photonos:glibc\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:vmware:photonos:1.0\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_family(english:\"PhotonOS Local Security Checks\");\n\n script_copyright(english:\"This script is Copyright (C) 2018-2019 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/local_checks_enabled\", \"Host/PhotonOS/release\", \"Host/PhotonOS/rpm-list\");\n\n exit(0);\n}\n\nexit(0, \"This plugin has been deprecated.\");\n\ninclude(\"audit.inc\");\ninclude(\"global_settings.inc\");\ninclude(\"rpm.inc\");\n\nif (!get_kb_item(\"Host/local_checks_enabled\")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\n\nrelease = get_kb_item(\"Host/PhotonOS/release\");\nif (isnull(release) || release !~ \"^VMware Photon\") audit(AUDIT_OS_NOT, \"PhotonOS\");\nif (release !~ \"^VMware Photon (?:Linux|OS) 1\\.0(\\D|$)\") audit(AUDIT_OS_NOT, \"PhotonOS 1.0\");\n\nif (!get_kb_item(\"Host/PhotonOS/rpm-list\")) audit(AUDIT_PACKAGE_LIST_MISSING);\n\ncpu = get_kb_item(\"Host/cpu\");\nif (isnull(cpu)) audit(AUDIT_UNKNOWN_ARCH);\nif (\"x86_64\" >!< cpu && cpu !~ \"^i[3-6]86$\") audit(AUDIT_LOCAL_CHECKS_NOT_IMPLEMENTED, \"PhotonOS\", cpu);\n\nflag = 0;\n\npkgs = [\n \"curl-7.54.0-5.ph1\",\n \"curl-debuginfo-7.54.0-5.ph1\",\n \"glibc-2.22-16.ph1\",\n \"glibc-devel-2.22-16.ph1\",\n \"glibc-lang-2.22-16.ph1\"\n];\n\nforeach (pkg in pkgs)\n if (rpm_check(release:\"PhotonOS-1.0\", reference:pkg)) flag++;\n\nif (flag)\n{\n security_report_v4(\n port : 0,\n severity : SECURITY_HOLE,\n extra : rpm_report_get()\n );\n exit(0);\n}\nelse\n{\n tested = pkg_tests_get();\n if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);\n else audit(AUDIT_PACKAGE_NOT_INSTALLED, \"curl / glibc\");\n}\n", "cvss": {"score": 7.2, "vector": "AV:LOCAL/AC:LOW/Au:NONE/C:COMPLETE/I:COMPLETE/A:COMPLETE/"}}, {"lastseen": "2020-09-14T16:42:06", "description": "This update for postgresql95 fixes the following issues :\n\nUpate to PostgreSQL 9.5.11 :\n\nSecurity issues fixed :\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-11.html \n\n - CVE-2018-1053, boo#1077983: Ensure that all temporary\n files made by pg_upgrade are non-world-readable. \n\n - boo#1079757: Rename pg_rewind's copy_file_range function\n to avoid conflict with new Linux system call of that\n name.\n\nIn version 9.5.10 :\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-10.html\n\n - CVE-2017-15098, boo#1067844: Memory disclosure in JSON\n functions.\n\n - CVE-2017-15099, boo#1067841: INSERT ... ON CONFLICT DO\n UPDATE fails to enforce SELECT privileges.\n\nIn version 9.5.9 :\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-9.html\n\n - Show foreign tables in\n information_schema.table_privileges view.\n\n - Clean up handling of a fatal exit (e.g., due to receipt\n of SIGTERM) that occurs while trying to execute a\n ROLLBACK of a failed transaction.\n\n - Remove assertion that could trigger during a fatal exit.\n\n - Correctly identify columns that are of a range type or\n domain type over a composite type or domain type being\n searched for.\n\n - Fix crash in pg_restore when using parallel mode and\n using a list file to select a subset of items to\n restore.\n\n - Change ecpg's parser to allow RETURNING clauses without\n attached C variables.\n\nIn version 9.5.8\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-8.html\n\n - CVE-2017-7547, boo#1051685: Further restrict visibility\n of pg_user_mappings.umoptions, to protect passwords\n stored as user mapping options.\n\n - CVE-2017-7546, boo#1051684: Disallow empty passwords in\n all password-based authentication methods.\n\n - CVE-2017-7548, boo#1053259: lo_put() function ignores\n ACLs.", "edition": 17, "cvss3": {"score": 9.8, "vector": "AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"}, "published": "2018-02-23T00:00:00", "title": "openSUSE Security Update : postgresql95 (openSUSE-2018-204)", "type": "nessus", "bulletinFamily": "scanner", "cvelist": ["CVE-2017-7547", "CVE-2017-15099", "CVE-2017-7546", "CVE-2018-1053", "CVE-2017-15098", "CVE-2017-7548"], "modified": "2018-02-23T00:00:00", "cpe": ["p-cpe:/a:novell:opensuse:postgresql95-plpython-debuginfo", "p-cpe:/a:novell:opensuse:postgresql95-devel-debuginfo", "p-cpe:/a:novell:opensuse:postgresql95", "p-cpe:/a:novell:opensuse:postgresql95-debugsource", "p-cpe:/a:novell:opensuse:postgresql95-pltcl-debuginfo", "p-cpe:/a:novell:opensuse:postgresql95-plpython", "p-cpe:/a:novell:opensuse:postgresql95-libs-debugsource", "p-cpe:/a:novell:opensuse:postgresql95-contrib", "cpe:/o:novell:opensuse:42.3", "p-cpe:/a:novell:opensuse:postgresql95-debuginfo", "p-cpe:/a:novell:opensuse:postgresql95-server-debuginfo", "p-cpe:/a:novell:opensuse:postgresql95-devel", "p-cpe:/a:novell:opensuse:postgresql95-server", "p-cpe:/a:novell:opensuse:postgresql95-test", "p-cpe:/a:novell:opensuse:postgresql95-plperl-debuginfo", "p-cpe:/a:novell:opensuse:postgresql95-plperl", "p-cpe:/a:novell:opensuse:postgresql95-pltcl", "p-cpe:/a:novell:opensuse:postgresql95-contrib-debuginfo"], "id": "OPENSUSE-2018-204.NASL", "href": "https://www.tenable.com/plugins/nessus/106965", "sourceData": "#%NASL_MIN_LEVEL 80502\n#\n# (C) Tenable Network Security, Inc.\n#\n# The descriptive text and package checks in this plugin were\n# extracted from openSUSE Security Update openSUSE-2018-204.\n#\n# The text description of this plugin is (C) SUSE LLC.\n#\n\ninclude(\"compat.inc\");\n\nif (description)\n{\n script_id(106965);\n script_version(\"3.3\");\n script_set_attribute(attribute:\"plugin_modification_date\", value:\"2020/06/04\");\n\n script_cve_id(\"CVE-2017-15098\", \"CVE-2017-15099\", \"CVE-2017-7546\", \"CVE-2017-7547\", \"CVE-2017-7548\", \"CVE-2018-1053\");\n\n script_name(english:\"openSUSE Security Update : postgresql95 (openSUSE-2018-204)\");\n script_summary(english:\"Check for the openSUSE-2018-204 patch\");\n\n script_set_attribute(\n attribute:\"synopsis\", \n value:\"The remote openSUSE host is missing a security update.\"\n );\n script_set_attribute(\n attribute:\"description\", \n value:\n\"This update for postgresql95 fixes the following issues :\n\nUpate to PostgreSQL 9.5.11 :\n\nSecurity issues fixed :\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-11.html \n\n - CVE-2018-1053, boo#1077983: Ensure that all temporary\n files made by pg_upgrade are non-world-readable. \n\n - boo#1079757: Rename pg_rewind's copy_file_range function\n to avoid conflict with new Linux system call of that\n name.\n\nIn version 9.5.10 :\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-10.html\n\n - CVE-2017-15098, boo#1067844: Memory disclosure in JSON\n functions.\n\n - CVE-2017-15099, boo#1067841: INSERT ... ON CONFLICT DO\n UPDATE fails to enforce SELECT privileges.\n\nIn version 9.5.9 :\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-9.html\n\n - Show foreign tables in\n information_schema.table_privileges view.\n\n - Clean up handling of a fatal exit (e.g., due to receipt\n of SIGTERM) that occurs while trying to execute a\n ROLLBACK of a failed transaction.\n\n - Remove assertion that could trigger during a fatal exit.\n\n - Correctly identify columns that are of a range type or\n domain type over a composite type or domain type being\n searched for.\n\n - Fix crash in pg_restore when using parallel mode and\n using a list file to select a subset of items to\n restore.\n\n - Change ecpg's parser to allow RETURNING clauses without\n attached C variables.\n\nIn version 9.5.8\n\n - https://www.postgresql.org/docs/9.5/static/release-9-5-8.html\n\n - CVE-2017-7547, boo#1051685: Further restrict visibility\n of pg_user_mappings.umoptions, to protect passwords\n stored as user mapping options.\n\n - CVE-2017-7546, boo#1051684: Disallow empty passwords in\n all password-based authentication methods.\n\n - CVE-2017-7548, boo#1053259: lo_put() function ignores\n ACLs.\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1051684\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1051685\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1053259\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1067841\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1067844\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1077983\"\n );\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://bugzilla.opensuse.org/show_bug.cgi?id=1079757\"\n );\n # https://www.postgresql.org/docs/9.5/static/release-9-5-10.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.5/release-9-5-10.html\"\n );\n # https://www.postgresql.org/docs/9.5/static/release-9-5-11.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.5/release-9-5-11.html\"\n );\n # https://www.postgresql.org/docs/9.5/static/release-9-5-8.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.5/release-9-5-8.html\"\n );\n # https://www.postgresql.org/docs/9.5/static/release-9-5-9.html\n script_set_attribute(\n attribute:\"see_also\",\n value:\"https://www.postgresql.org/docs/9.5/release-9-5-9.html\"\n );\n script_set_attribute(\n attribute:\"solution\", \n value:\"Update the affected postgresql95 packages.\"\n );\n script_set_cvss_base_vector(\"CVSS2#AV:N/AC:L/Au:N/C:P/I:P/A:P\");\n script_set_cvss3_base_vector(\"CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H\");\n\n script_set_attribute(attribute:\"plugin_type\", value:\"local\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-contrib\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-contrib-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-debugsource\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-devel\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-devel-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-libs-debugsource\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-plperl\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-plperl-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-plpython\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-plpython-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-pltcl\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-pltcl-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-server\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-server-debuginfo\");\n script_set_attribute(attribute:\"cpe\", value:\"p-cpe:/a:novell:opensuse:postgresql95-test\");\n script_set_attribute(attribute:\"cpe\", value:\"cpe:/o:novell:opensuse:42.3\");\n\n script_set_attribute(attribute:\"patch_publication_date\", value:\"2018/02/22\");\n script_set_attribute(attribute:\"plugin_publication_date\", value:\"2018/02/23\");\n script_end_attributes();\n\n script_category(ACT_GATHER_INFO);\n script_copyright(english:\"This script is Copyright (C) 2018-2020 and is owned by Tenable, Inc. or an Affiliate thereof.\");\n script_family(english:\"SuSE Local Security Checks\");\n\n script_dependencies(\"ssh_get_info.nasl\");\n script_require_keys(\"Host/local_checks_enabled\", \"Host/SuSE/release\", \"Host/SuSE/rpm-list\", \"Host/cpu\");\n\n exit(0);\n}\n\n\ninclude(\"audit.inc\");\ninclude(\"global_settings.inc\");\ninclude(\"rpm.inc\");\n\nif (!get_kb_item(\"Host/local_checks_enabled\")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);\nrelease = get_kb_item(\"Host/SuSE/release\");\nif (isnull(release) || release =~ \"^(SLED|SLES)\") audit(AUDIT_OS_NOT, \"openSUSE\");\nif (release !~ \"^(SUSE42\\.3)$\") audit(AUDIT_OS_RELEASE_NOT, \"openSUSE\", \"42.3\", release);\nif (!get_kb_item(\"Host/SuSE/rpm-list\")) audit(AUDIT_PACKAGE_LIST_MISSING);\n\nourarch = get_kb_item(\"Host/cpu\");\nif (!ourarch) audit(AUDIT_UNKNOWN_ARCH);\nif (ourarch !~ \"^(i586|i686|x86_64)$\") audit(AUDIT_ARCH_NOT, \"i586 / i686 / x86_64\", ourarch);\n\nflag = 0;\n\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-contrib-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-contrib-debuginfo-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-debuginfo-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-debugsource-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-devel-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-devel-debuginfo-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-libs-debugsource-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-plperl-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-plperl-debuginfo-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-plpython-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-plpython-debuginfo-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-pltcl-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-pltcl-debuginfo-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-server-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-server-debuginfo-9.5.11-2.3.1\") ) flag++;\nif ( rpm_check(release:\"SUSE42.3\", reference:\"postgresql95-test-9.5.11-2.3.1\") ) flag++;\n\nif (flag)\n{\n if (report_verbosity > 0) security_hole(port:0, extra:rpm_report_get());\n else security_hole(0);\n exit(0);\n}\nelse\n{\n tested = pkg_tests_get();\n if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);\n else audit(AUDIT_PACKAGE_NOT_INSTALLED, \"postgresql95-devel / postgresql95-devel-debuginfo / etc\");\n}\n", "cvss": {"score": 7.5, "vector": "AV:N/AC:L/Au:N/C:P/I:P/A:P"}}], "kaspersky": [{"lastseen": "2020-09-02T11:53:20", "bulletinFamily": "info", "cvelist": ["CVE-2017-12172", "CVE-2017-15099", "CVE-2017-15098"], "description": "### *Detect date*:\n11/09/2017\n\n### *Severity*:\nHigh\n\n### *Description*:\nMultiple serious vulnerabilities have been found in PostgreSQL. Vulnerabilities in core server and contrib module components can be exploit remotely to gain privileges.\n\n### *Affected products*:\nPostgreSQL 9.2 earlier than 9.2.24 \nPostgreSQL 9.3 earlier than 9.3.20 \nPostgreSQL 9.5 earlier than 9.5.10 \nPostgreSQL 9.6 earlier than 9.6.6 \nPostgreSQL 10 earlier than 10.1\n\n### *Solution*:\nUpdate to the latest version \n[Download PostgreSQL](<https://www.postgresql.org/download/>)\n\n### *Original advisories*:\n[Security Information](<https://www.postgresql.org/support/security/>) \n\n\n### *Impacts*:\nPE \n\n### *Related products*:\n[PostgreSQL](<https://threats.kaspersky.com/en/product/PostgreSQL/>)\n\n### *CVE-IDS*:\n[CVE-2017-12172](<https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-12172>)7.2High \n[CVE-2017-15098](<https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-15098>)5.5High \n[CVE-2017-15099](<https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-15099>)4.0Warning", "edition": 42, "modified": "2020-05-22T00:00:00", "published": "2017-11-09T00:00:00", "id": "KLA11147", "href": "https://threats.kaspersky.com/en/vulnerability/KLA11147", "title": "\r KLA11147Multiple vulnerabilities in PostgreSQL ", "type": "kaspersky", "cvss": {"score": 7.2, "vector": "AV:L/AC:L/Au:N/C:C/I:C/A:C"}}], "amazon": [{"lastseen": "2020-11-10T12:36:22", "bulletinFamily": "unix", "cvelist": ["CVE-2017-12172", "CVE-2017-15099", "CVE-2017-15098"], "description": "**Issue Overview:**\n\nPrivilege escalation flaws were found in the initialization scripts of PostgreSQL. A remote attacker with access to the postgres user account could use these flaws to obtain root access on the server machine.([CVE-2017-12172 __](<https://access.redhat.com/security/cve/CVE-2017-12172>))\n\nINSERT ... ON CONFLICT DO UPDATE commands in PostgreSQL disclose table contents that the invoker lacks privilege to read. These exploits affect only tables where the attacker lacks full read access but has both INSERT and UPDATE privileges. Exploits bypass row level security policies and lack of SELECT privilege.([CVE-2017-15099 __](<https://access.redhat.com/security/cve/CVE-2017-15099>))\n\nInvalid json_populate_recordset or jsonb_populate_recordset function calls in PostgreSQL can crash the server or disclose a few bytes of server memory.([CVE-2017-15098 __](<https://access.redhat.com/security/cve/CVE-2017-15098>))\n\n \n**Affected Packages:** \n\n\npostgresql95, postgresql96\n\n \n**Issue Correction:** \nRun _yum update postgresql95_ to update your system. \nRun _yum update postgresql96_ to update your system. \n\n\n \n\n\n**New Packages:**\n \n \n i686: \n postgresql95-plperl-9.5.10-1.77.amzn1.i686 \n postgresql95-libs-9.5.10-1.77.amzn1.i686 \n postgresql95-debuginfo-9.5.10-1.77.amzn1.i686 \n postgresql95-devel-9.5.10-1.77.amzn1.i686 \n postgresql95-test-9.5.10-1.77.amzn1.i686 \n postgresql95-contrib-9.5.10-1.77.amzn1.i686 \n postgresql95-docs-9.5.10-1.77.amzn1.i686 \n postgresql95-9.5.10-1.77.amzn1.i686 \n postgresql95-plpython26-9.5.10-1.77.amzn1.i686 \n postgresql95-static-9.5.10-1.77.amzn1.i686 \n postgresql95-server-9.5.10-1.77.amzn1.i686 \n postgresql95-plpython27-9.5.10-1.77.amzn1.i686 \n postgresql96-plperl-9.6.6-1.79.amzn1.i686 \n postgresql96-plpython26-9.6.6-1.79.amzn1.i686 \n postgresql96-plpython27-9.6.6-1.79.amzn1.i686 \n postgresql96-devel-9.6.6-1.79.amzn1.i686 \n postgresql96-contrib-9.6.6-1.79.amzn1.i686 \n postgresql96-static-9.6.6-1.79.amzn1.i686 \n postgresql96-docs-9.6.6-1.79.amzn1.i686 \n postgresql96-libs-9.6.6-1.79.amzn1.i686 \n postgresql96-debuginfo-9.6.6-1.79.amzn1.i686 \n postgresql96-test-9.6.6-1.79.amzn1.i686 \n postgresql96-9.6.6-1.79.amzn1.i686 \n postgresql96-server-9.6.6-1.79.amzn1.i686 \n \n src: \n postgresql95-9.5.10-1.77.amzn1.src \n postgresql96-9.6.6-1.79.amzn1.src \n \n x86_64: \n postgresql95-server-9.5.10-1.77.amzn1.x86_64 \n postgresql95-devel-9.5.10-1.77.amzn1.x86_64 \n postgresql95-contrib-9.5.10-1.77.amzn1.x86_64 \n postgresql95-9.5.10-1.77.amzn1.x86_64 \n postgresql95-static-9.5.10-1.77.amzn1.x86_64 \n postgresql95-plpython27-9.5.10-1.77.amzn1.x86_64 \n postgresql95-libs-9.5.10-1.77.amzn1.x86_64 \n postgresql95-docs-9.5.10-1.77.amzn1.x86_64 \n postgresql95-plpython26-9.5.10-1.77.amzn1.x86_64 \n postgresql95-plperl-9.5.10-1.77.amzn1.x86_64 \n postgresql95-debuginfo-9.5.10-1.77.amzn1.x86_64 \n postgresql95-test-9.5.10-1.77.amzn1.x86_64 \n postgresql96-static-9.6.6-1.79.amzn1.x86_64 \n postgresql96-docs-9.6.6-1.79.amzn1.x86_64 \n postgresql96-plperl-9.6.6-1.79.amzn1.x86_64 \n postgresql96-libs-9.6.6-1.79.amzn1.x86_64 \n postgresql96-test-9.6.6-1.79.amzn1.x86_64 \n postgresql96-debuginfo-9.6.6-1.79.amzn1.x86_64 \n postgresql96-9.6.6-1.79.amzn1.x86_64 \n postgresql96-contrib-9.6.6-1.79.amzn1.x86_64 \n postgresql96-server-9.6.6-1.79.amzn1.x86_64 \n postgresql96-plpython26-9.6.6-1.79.amzn1.x86_64 \n postgresql96-devel-9.6.6-1.79.amzn1.x86_64 \n postgresql96-plpython27-9.6.6-1.79.amzn1.x86_64 \n \n \n", "edition": 5, "modified": "2017-12-05T22:18:00", "published": "2017-12-05T22:18:00", "id": "ALAS-2017-930", "href": "https://alas.aws.amazon.com/ALAS-2017-930.html", "title": "Medium: postgresql95, postgresql96", "type": "amazon", "cvss": {"score": 7.2, "vector": "AV:L/AC:L/Au:N/C:C/I:C/A:C"}}], "suse": [{"lastseen": "2018-02-23T03:20:33", "bulletinFamily": "unix", "cvelist": ["CVE-2017-7547", "CVE-2017-15099", "CVE-2017-7546", "CVE-2018-1053", "CVE-2017-15098", "CVE-2017-7548"], "description": "This update for postgresql95 fixes the following issues:\n\n Upate to PostgreSQL 9.5.11:\n\n Security issues fixed:\n\n * <a rel=\"nofollow\" href=\"https://www.postgresql.org/docs/9.5/static/release-9-5-11.html\">https://www.postgresql.org/docs/9.5/static/release-9-5-11.html</a>\n * CVE-2018-1053, boo#1077983: Ensure that all temporary files made by\n pg_upgrade are non-world-readable.\n * boo#1079757: Rename pg_rewind's copy_file_range function to avoid\n conflict with new Linux system call of that name.\n\n In version 9.5.10:\n\n * <a rel=\"nofollow\" href=\"https://www.postgresql.org/docs/9.5/static/release-9-5-10.html\">https://www.postgresql.org/docs/9.5/static/release-9-5-10.html</a>\n * CVE-2017-15098, boo#1067844: Memory disclosure in JSON functions.\n * CVE-2017-15099, boo#1067841: INSERT ... ON CONFLICT DO UPDATE fails to\n enforce SELECT privileges.\n\n In version 9.5.9:\n\n * <a rel=\"nofollow\" href=\"https://www.postgresql.org/docs/9.5/static/release-9-5-9.html\">https://www.postgresql.org/docs/9.5/static/release-9-5-9.html</a>\n * Show foreign tables in information_schema.table_privileges view.\n * Clean up handling of a fatal exit (e.g., due to receipt of SIGTERM)\n that occurs while trying to execute a ROLLBACK of a failed transaction.\n * Remove assertion that could trigger during a fatal exit.\n * Correctly identify columns that are of a range type or domain type\n over a composite type or domain type being searched for.\n * Fix crash in pg_restore when using parallel mode and using a list file\n to select a subset of items to restore.\n * Change ecpg's parser to allow RETURNING clauses without attached C\n variables.\n\n In version 9.5.8\n\n * <a rel=\"nofollow\" href=\"https://www.postgresql.org/docs/9.5/static/release-9-5-8.html\">https://www.postgresql.org/docs/9.5/static/release-9-5-8.html</a>\n * CVE-2017-7547, boo#1051685: Further restrict visibility of\n pg_user_mappings.umoptions, to protect passwords stored as user\n mapping options.\n * CVE-2017-7546, boo#1051684: Disallow empty passwords in all\n password-based authentication methods.\n * CVE-2017-7548, boo#1053259: lo_put() function ignores ACLs.\n\n", "edition": 1, "modified": "2018-02-23T00:08:24", "published": "2018-02-23T00:08:24", "href": "http://lists.opensuse.org/opensuse-security-announce/2018-02/msg00042.html", "id": "OPENSUSE-SU-2018:0529-1", "type": "suse", "title": "Security update for postgresql95 (important)", "cvss": {"score": 7.5, "vector": "AV:NETWORK/AC:LOW/Au:NONE/C:PARTIAL/I:PARTIAL/A:PARTIAL/"}}], "redhat": [{"lastseen": "2019-08-13T18:45:26", "bulletinFamily": "unix", "cvelist": ["CVE-2017-15098", "CVE-2017-15099", "CVE-2018-1053", "CVE-2018-1058", "CVE-2018-10915", "CVE-2018-10925"], "description": "PostgreSQL is an advanced object-relational database management system (DBMS).\n\nThe following packages have been upgraded to a later upstream version: rh-postgresql95-postgresql (9.5.14). (BZ#1612671)\n\nSecurity Fix(es):\n\n* postgresql: Certain host connection parameters defeat client-side security defenses (CVE-2018-10915)\n\n* postgresql: Missing authorization and memory disclosure in INSERT ... ON CONFLICT DO UPDATE statements (CVE-2018-10925)\n\n* postgresql: Memory disclosure in JSON functions (CVE-2017-15098)\n\n* postgresql: pg_upgrade creates file of sensitive metadata under prevailing umask (CVE-2018-1053)\n\n* postgresql: Uncontrolled search path element in pg_dump and other client applications (CVE-2018-1058)\n\n* postgresql: INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges (CVE-2017-15099)\n\nFor more details about the security issue(s), including the impact, a CVSS score, and other related information, refer to the CVE page(s) listed in the References section.\n\nRed Hat would like to thank the PostgreSQL project for reporting CVE-2018-10915, CVE-2018-10925, CVE-2017-15098, CVE-2018-1053, and CVE-2017-15099. Upstream acknowledges Andrew Krasichkov as the original reporter of CVE-2018-10915; David Rowley as the original reporter of CVE-2017-15098; Tom Lane as the original reporter of CVE-2018-1053; and Dean Rasheed as the original reporter of CVE-2017-15099.", "modified": "2018-08-20T14:29:58", "published": "2018-08-20T14:27:16", "id": "RHSA-2018:2511", "href": "https://access.redhat.com/errata/RHSA-2018:2511", "type": "redhat", "title": "(RHSA-2018:2511) Important: rh-postgresql95-postgresql security update", "cvss": {"score": 6.5, "vector": "AV:N/AC:L/Au:S/C:P/I:P/A:P"}}, {"lastseen": "2019-08-13T18:45:53", "bulletinFamily": "unix", "cvelist": ["CVE-2017-15098", "CVE-2017-15099", "CVE-2018-1053", "CVE-2018-1058", "CVE-2018-10915", "CVE-2018-10925", "CVE-2018-1115"], "description": "PostgreSQL is an advanced object-relational database management system (DBMS).\n\nThe following packages have been upgraded to a later upstream version: rh-postgresql96-postgresql (9.6.10). (BZ#1614340)\n\nSecurity Fix(es):\n\n* postgresql: Certain host connection parameters defeat client-side security defenses (CVE-2018-10915)\n\n* postgresql: Missing authorization and memory disclosure in INSERT ... ON CONFLICT DO UPDATE statements (CVE-2018-10925)\n\n* postgresql: Memory disclosure in JSON functions (CVE-2017-15098)\n\n* postgresql: pg_upgrade creates file of sensitive metadata under prevailing umask (CVE-2018-1053)\n\n* postgresql: Uncontrolled search path element in pg_dump and other client applications (CVE-2018-1058)\n\n* postgresql: INSERT ... ON CONFLICT DO UPDATE fails to enforce SELECT privileges (CVE-2017-15099)\n\n* postgresql: Too-permissive access control list on function pg_logfile_rotate() (CVE-2018-1115)\n\nFor more details about the security issue(s), including the impact, a CVSS score, and other related information, refer to the CVE page(s) listed in the References section.\n\nRed Hat would like to thank the PostgreSQL project for reporting CVE-2018-10915, CVE-2018-10925, CVE-2017-15098, CVE-2018-1053, CVE-2017-15099, and CVE-2018-1115. Upstream acknowledges Andrew Krasichkov as the original reporter of CVE-2018-10915; David Rowley as the original reporter of CVE-2017-15098; Tom Lane as the original reporter of CVE-2018-1053; Dean Rasheed as the original reporter of CVE-2017-15099; and Stephen Frost as the original reporter of CVE-2018-1115.", "modified": "2018-08-27T12:06:23", "published": "2018-08-27T11:54:53", "id": "RHSA-2018:2566", "href": "https://access.redhat.com/errata/RHSA-2018:2566", "type": "redhat", "title": "(RHSA-2018:2566) Important: rh-postgresql96-postgresql security update", "cvss": {"score": 6.5, "vector": "AV:N/AC:L/Au:S/C:P/I:P/A:P"}}]}