EulerOS 2.0 SP8 : mariadb (EulerOS-SA-2022-1575) - Nessus

High   Plugin ID: 160142

This page contains detailed information about the EulerOS 2.0 SP8 : mariadb (EulerOS-SA-2022-1575) Nessus plugin including available exploits and PoCs found on GitHub, in Metasploit or Exploit-DB for verifying of this vulnerability.

Plugin Overview


ID: 160142
Name: EulerOS 2.0 SP8 : mariadb (EulerOS-SA-2022-1575)
Filename: EulerOS_SA-2022-1575.nasl
Vulnerability Published: 2021-03-19
This Plugin Published: 2022-04-25
Last Modification Time: 2022-04-26
Plugin Version: 1.3
Plugin Type: local
Plugin Family: Huawei Local Security Checks
Dependencies: ssh_get_info.nasl
Required KB Items [?]: Host/cpu, Host/EulerOS/release, Host/EulerOS/rpm-list, Host/EulerOS/sp, Host/local_checks_enabled
Excluded KB Items: Host/EulerOS/uvp_version

Vulnerability Information


Severity: High
Vulnerability Published: 2021-03-19
Patch Published: 2022-04-25
CVE [?]: CVE-2021-27928, CVE-2021-46661, CVE-2021-46666, CVE-2021-46667
CPE [?]: cpe:/o:huawei:euleros:2.0, p-cpe:/a:huawei:euleros:mariadb, p-cpe:/a:huawei:euleros:mariadb-common, p-cpe:/a:huawei:euleros:mariadb-devel

Synopsis

The remote EulerOS host is missing multiple security updates.

Description

According to the versions of the mariadb packages installed, the EulerOS installation on the remote host is affected by the following vulnerabilities :

- A remote code execution issue was discovered in MariaDB 10.2 before 10.2.37, 10.3 before 10.3.28, 10.4 before 10.4.18, and 10.5 before 10.5.9; Percona Server through 2021-03-03; and the wsrep patch through 2021-03-03 for MySQL. An untrusted search path leads to eval injection, in which a database SUPER user can execute OS commands after modifying wsrep_provider and wsrep_notify_cmd. NOTE: this does not affect an Oracle product. (CVE-2021-27928)

- MariaDB through 10.5.9 allows an application crash in find_field_in_tables and find_order_in_list via an unused common table expression (CTE). (CVE-2021-46661)

- MariaDB before 10.6.2 allows an application crash because of mishandling of a pushdown from a HAVING clause to a WHERE clause. (CVE-2021-46666)

- MariaDB before 10.6.5 has a sql_lex.cc integer overflow, leading to an application crash. (CVE-2021-46667)

Note that Tenable Network Security has extracted the preceding description block directly from the EulerOS security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

Solution

Update the affected mariadb packages.

Public Exploits


Target Network Port(s): N/A
Target Asset(s): N/A
Exploit Available: True (Exploit-DB, GitHub)
Exploit Ease: Exploits are available

Here's the list of publicly known exploits and PoCs for verifying the EulerOS 2.0 SP8 : mariadb (EulerOS-SA-2022-1575) vulnerability:

  1. Exploit-DB: exploits/linux/local/49765.txt
    [EDB-49765: MariaDB 10.2 - 'wsrep_provider' OS Command Execution]
  2. GitHub: https://github.com/Al1ex/CVE-2021-4034
    [CVE-2021-27928]
  3. GitHub: https://github.com/Diefunction/CVE-2021-27928
    [CVE-2021-27928: A remote code execution issue was discovered in MariaDB 10.2 before 10.2.37, 10.3 ...]
  4. GitHub: https://github.com/GatoGamer1155/CVE-2021-27928
    [CVE-2021-27928: Pasos a seguir para explotar la vulnerabilidad CVE-2021-27928]
  5. GitHub: https://github.com/H0j3n/EzpzCheatSheet
    [CVE-2021-27928]
  6. GitHub: https://github.com/H0j3n/EzpzShell
    [CVE-2021-27928]
  7. GitHub: https://github.com/seska451/mariadb-cve-2021-27928
    [CVE-2021-27928: POC for exploiting CVE-2021-27928]
  8. GitHub: https://github.com/shamo0/CVE-2021-27928-POC
    [CVE-2021-27928: CVE-2021-27928-POC]
  9. GitHub: https://github.com/Al1ex/CVE-2021-27928
    [CVE-2021-27928: CVE-2021-27928 MariaDB/MySQL-'wsrep provider' 命令注入漏洞]

Before running any exploit against any system, make sure you are authorized by the owner of the target system(s) to perform such activity. In any other case, this would be considered as an illegal activity.

WARNING: Beware of using unverified exploits from sources such as GitHub or Exploit-DB. These exploits and PoCs could contain malware. For more information, see how to use exploits safely.

Risk Information


CVSS Score Source [?]: CVE-2021-27928
CVSS V2 Vector: AV:N/AC:L/Au:S/C:C/I:C/A:C/E:POC/RL:OF/RC:C
CVSS Base Score:9.0 (High)
Impact Subscore:10.0
Exploitability Subscore:8.0
CVSS Temporal Score:7.0 (High)
CVSS Environmental Score:NA (None)
Modified Impact Subscore:NA
Overall CVSS Score:7.0 (High)
CVSS V3 Vector: CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:H/E:P/RL:O/RC:C
CVSS Base Score:7.2 (High)
Impact Subscore:5.9
Exploitability Subscore:1.2
CVSS Temporal Score:6.5 (Medium)
CVSS Environmental Score:NA (None)
Modified Impact Subscore:NA
Overall CVSS Score:6.5 (Medium)

Go back to menu.

Plugin Source


This is the EulerOS_SA-2022-1575.nasl nessus plugin source code. This script is Copyright (C) 2022 and is owned by Tenable, Inc. or an Affiliate thereof.

#%NASL_MIN_LEVEL 70300
##
# (C) Tenable, Inc.
##

include('deprecated_nasl_level.inc');
include('compat.inc');

if (description)
{
  script_id(160142);
  script_version("1.3");
  script_set_attribute(attribute:"plugin_modification_date", value:"2022/04/26");

  script_cve_id(
    "CVE-2021-27928",
    "CVE-2021-46661",
    "CVE-2021-46666",
    "CVE-2021-46667"
  );

  script_name(english:"EulerOS 2.0 SP8 : mariadb (EulerOS-SA-2022-1575)");

  script_set_attribute(attribute:"synopsis", value:
"The remote EulerOS host is missing multiple security updates.");
  script_set_attribute(attribute:"description", value:
"According to the versions of the mariadb packages installed, the EulerOS installation on the remote host is affected by
the following vulnerabilities :

  - A remote code execution issue was discovered in MariaDB 10.2 before 10.2.37, 10.3 before 10.3.28, 10.4
    before 10.4.18, and 10.5 before 10.5.9; Percona Server through 2021-03-03; and the wsrep patch through
    2021-03-03 for MySQL. An untrusted search path leads to eval injection, in which a database SUPER user can
    execute OS commands after modifying wsrep_provider and wsrep_notify_cmd. NOTE: this does not affect an
    Oracle product. (CVE-2021-27928)

  - MariaDB through 10.5.9 allows an application crash in find_field_in_tables and find_order_in_list via an
    unused common table expression (CTE). (CVE-2021-46661)

  - MariaDB before 10.6.2 allows an application crash because of mishandling of a pushdown from a HAVING
    clause to a WHERE clause. (CVE-2021-46666)

  - MariaDB before 10.6.5 has a sql_lex.cc integer overflow, leading to an application crash. (CVE-2021-46667)

Note that Tenable Network Security has extracted the preceding description block directly from the EulerOS security
advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional
issues.");
  # https://developer.huaweicloud.com/ict/en/site-euleros/euleros/security-advisories/EulerOS-SA-2022-1575
  script_set_attribute(attribute:"see_also", value:"http://www.nessus.org/u?83f553b3");
  script_set_attribute(attribute:"solution", value:
"Update the affected mariadb packages.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:L/Au:S/C:C/I:C/A:C");
  script_set_cvss_temporal_vector("CVSS2#E:POC/RL:OF/RC:C");
  script_set_cvss3_base_vector("CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:H/I:H/A:H");
  script_set_cvss3_temporal_vector("CVSS:3.0/E:P/RL:O/RC:C");
  script_set_attribute(attribute:"cvss_score_source", value:"CVE-2021-27928");

  script_set_attribute(attribute:"exploitability_ease", value:"Exploits are available");
  script_set_attribute(attribute:"exploit_available", value:"true");

  script_set_attribute(attribute:"vuln_publication_date", value:"2021/03/19");
  script_set_attribute(attribute:"patch_publication_date", value:"2022/04/25");
  script_set_attribute(attribute:"plugin_publication_date", value:"2022/04/25");

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:huawei:euleros:mariadb");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:huawei:euleros:mariadb-common");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:huawei:euleros:mariadb-devel");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:huawei:euleros:2.0");
  script_end_attributes();

  script_category(ACT_GATHER_INFO);
  script_family(english:"Huawei Local Security Checks");

  script_copyright(english:"This script is Copyright (C) 2022 and is owned by Tenable, Inc. or an Affiliate thereof.");

  script_dependencies("ssh_get_info.nasl");
  script_require_keys("Host/local_checks_enabled", "Host/cpu", "Host/EulerOS/release", "Host/EulerOS/rpm-list", "Host/EulerOS/sp");
  script_exclude_keys("Host/EulerOS/uvp_version");

  exit(0);
}

include("rpm.inc");

if (!get_kb_item("Host/local_checks_enabled")) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);

var release = get_kb_item("Host/EulerOS/release");
if (isnull(release) || release !~ "^EulerOS") audit(AUDIT_OS_NOT, "EulerOS");
var uvp = get_kb_item("Host/EulerOS/uvp_version");
if (release !~ "^EulerOS release 2\.0(\D|$)") audit(AUDIT_OS_NOT, "EulerOS 2.0 SP8");

var sp = get_kb_item("Host/EulerOS/sp");
if (isnull(sp) || sp !~ "^(8)$") audit(AUDIT_OS_NOT, "EulerOS 2.0 SP8");

if (!empty_or_null(uvp)) audit(AUDIT_OS_NOT, "EulerOS 2.0 SP8", "EulerOS UVP " + uvp);

if (!get_kb_item("Host/EulerOS/rpm-list")) audit(AUDIT_PACKAGE_LIST_MISSING);

var cpu = get_kb_item("Host/cpu");
if (isnull(cpu)) audit(AUDIT_UNKNOWN_ARCH);
if ("x86_64" >!< cpu && cpu !~ "^i[3-6]86$" && "aarch64" >!< cpu) audit(AUDIT_LOCAL_CHECKS_NOT_IMPLEMENTED, "EulerOS", cpu);
if ("aarch64" >!< cpu) audit(AUDIT_ARCH_NOT, "aarch64", cpu);

var flag = 0;

var pkgs = [
  "mariadb-10.3.9-2.h3.eulerosv2r8",
  "mariadb-common-10.3.9-2.h3.eulerosv2r8",
  "mariadb-devel-10.3.9-2.h3.eulerosv2r8"
];

foreach (var pkg in pkgs)
  if (rpm_check(release:"EulerOS-2.0", sp:"8", reference:pkg)) flag++;

if (flag)
{
  security_report_v4(
    port       : 0,
    severity   : SECURITY_HOLE,
    extra      : rpm_report_get()
  );
  exit(0);
}
else
{
  var tested = pkg_tests_get();
  if (tested) audit(AUDIT_PACKAGE_NOT_AFFECTED, tested);
  else audit(AUDIT_PACKAGE_NOT_INSTALLED, "mariadb");
}

The latest version of this script can be found in these locations depending on your platform:

  • Linux / Unix:
    /opt/nessus/lib/nessus/plugins/EulerOS_SA-2022-1575.nasl
  • Windows:
    C:\ProgramData\Tenable\Nessus\nessus\plugins\EulerOS_SA-2022-1575.nasl
  • Mac OS X:
    /Library/Nessus/run/lib/nessus/plugins/EulerOS_SA-2022-1575.nasl

Go back to menu.

How to Run


Here is how to run the EulerOS 2.0 SP8 : mariadb (EulerOS-SA-2022-1575) as a standalone plugin via the Nessus web user interface (https://localhost:8834/):

  1. Click to start a New Scan.
  2. Select Advanced Scan.
  3. Navigate to the Plugins tab.
  4. On the top right corner click to Disable All plugins.
  5. On the left side table select Huawei Local Security Checks plugin family.
  6. On the right side table select EulerOS 2.0 SP8 : mariadb (EulerOS-SA-2022-1575) plugin ID 160142.
  7. Specify the target on the Settings tab and click to Save the scan.
  8. Run the scan.

Here are a few examples of how to run the plugin in the command line. Note that the examples below demonstrate the usage on the Linux / Unix platform.

Basic usage:

/opt/nessus/bin/nasl EulerOS_SA-2022-1575.nasl -t <IP/HOST>

Run the plugin with audit trail message on the console:

/opt/nessus/bin/nasl -a EulerOS_SA-2022-1575.nasl -t <IP/HOST>

Run the plugin with trace script execution written to the console (useful for debugging):

/opt/nessus/bin/nasl -T - EulerOS_SA-2022-1575.nasl -t <IP/HOST>

Run the plugin with using a state file for the target and updating it (useful for running multiple plugins on the target):

/opt/nessus/bin/nasl -K /tmp/state EulerOS_SA-2022-1575.nasl -t <IP/HOST>

Go back to menu.

References


See also: Similar and related Nessus plugins:
  • 157723 - AlmaLinux 8 : mariadb:10.3 and mariadb-devel:10.3 (ALSA-2021:1242)
  • 148863 - CentOS 8 : mariadb:10.3 and mariadb-devel:10.3 (CESA-2021:1242)
  • 148053 - Debian DLA-2605-1 : mariadb-10.1 security update
  • 157000 - GLSA-202105-28 : MariaDB: Multiple vulnerabilities
  • 148829 - MariaDB 10.2.0 < 10.2.37 A Vulnerability
  • 148828 - MariaDB 10.3.0 < 10.3.28 A Vulnerability
  • 148827 - MariaDB 10.4.0 < 10.4.18 A Vulnerability
  • 148826 - MariaDB 10.5.0 < 10.5.9 A Vulnerability
  • 152218 - openSUSE 15 Security Update : mariadb (openSUSE-SU-2021:2605-1)
  • 152250 - openSUSE 15 Security Update : mariadb (openSUSE-SU-2021:2616-1)
  • 152249 - openSUSE 15 Security Update : mariadb (openSUSE-SU-2021:2617-1)
  • 148997 - Oracle Linux 8 : mariadb:10.3 / and / mariadb-devel:10.3 (ELSA-2021-1242)
  • 150287 - Photon OS 1.0: Mariadb PHSA-2021-1.0-0398
  • 150423 - Photon OS 2.0: Mariadb PHSA-2021-2.0-0351
  • 150435 - Photon OS 3.0: Mariadb PHSA-2021-3.0-0249
  • 148246 - RHEL 7 : mariadb (RHSA-2021:1039)
  • 148771 - RHEL 8 : mariadb:10.3 and mariadb-devel:10.3 (RHSA-2021:1240)
  • 148770 - RHEL 8 : mariadb:10.3 and mariadb-devel:10.3 (RHSA-2021:1241)
  • 148768 - RHEL 8 : mariadb:10.3 and mariadb-devel:10.3 (RHSA-2021:1242)
  • 152222 - SUSE SLES15 Security Update : mariadb (SUSE-SU-2021:2605-1)
  • 152242 - SUSE SLES15 Security Update : mariadb (SUSE-SU-2021:2616-1)
  • 152252 - SUSE SLES15 Security Update : mariadb (SUSE-SU-2021:2617-1)
  • 152241 - SUSE SLES12 Security Update : mariadb (SUSE-SU-2021:2634-1)

Version


This page has been produced using Nessus Professional 10.1.2 (#68) LINUX, Plugin set 202205072148.
Plugin file EulerOS_SA-2022-1575.nasl version 1.3. For more plugins, visit the Nessus Plugin Library.

Go back to menu.