MiracleLinux 4 : rh-mariadb100-mariadb-10.0.33-3.AXS4 (AXSA:2018-2584:01)

#%NASL_MIN_LEVEL 80900
##
# (C) Tenable, Inc.
#
# The package checks in this plugin were extracted from
# Miracle Linux Security Advisory AXSA:2018-2584:01.
##

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

if (description)
{
  script_id(289545);
  script_version("1.2");
  script_set_attribute(attribute:"plugin_modification_date", value:"2026/02/09");

  script_cve_id(
    "CVE-2016-6664",
    "CVE-2017-3238",
    "CVE-2017-3243",
    "CVE-2017-3244",
    "CVE-2017-3257",
    "CVE-2017-3258",
    "CVE-2017-3265",
    "CVE-2017-3291",
    "CVE-2017-3302",
    "CVE-2017-3308",
    "CVE-2017-3309",
    "CVE-2017-3312",
    "CVE-2017-3313",
    "CVE-2017-3317",
    "CVE-2017-3318",
    "CVE-2017-3453",
    "CVE-2017-3456",
    "CVE-2017-3464",
    "CVE-2017-3636",
    "CVE-2017-3641",
    "CVE-2017-3653",
    "CVE-2017-10268",
    "CVE-2017-10286",
    "CVE-2017-10378",
    "CVE-2017-10379",
    "CVE-2017-10384"
  );

  script_name(english:"MiracleLinux 4 : rh-mariadb100-mariadb-10.0.33-3.AXS4 (AXSA:2018-2584:01)");

  script_set_attribute(attribute:"synopsis", value:
"The remote MiracleLinux host is missing one or more security updates.");
  script_set_attribute(attribute:"description", value:
"The remote MiracleLinux 4 host has packages installed that are affected by multiple vulnerabilities as referenced in the
AXSA:2018-2584:01 advisory.

    * A flaw was found in the way the mysqld_safe script handled creation of error log file. The mysql
    operating system user could use this flaw to escalate their privileges to root. (CVE-2016-5617,
    CVE-2016-6664)
      * Multiple flaws were found in the way the MySQL init script handled initialization of the database data
    directory and permission setting on the error log file. The mysql operating system user could use these
    flaws to escalate their privileges to root. (CVE-2017-3265)
      * It was discovered that the mysqld_safe script honored the ledir option value set in a MySQL
    configuration file. A user able to modify one of the MySQL configuration files could use this flaw to
    escalate their privileges to root. (CVE-2017-3291)
      * Multiple flaws were found in the way the mysqld_safe script handled creation of error log file. The
    mysql operating system user could use these flaws to escalate their privileges to root. (CVE-2017-3312)
      * A flaw was found in the way MySQL client library (libmysqlclient) handled prepared statements when
    server connection was lost. A malicious server or a man-in-the-middle attacker could possibly use this
    flaw to crash an application using libmysqlclient. (CVE-2017-3302)
      * This update fixes several vulnerabilities in the MariaDB database server. Information about these
    flaws can be found on the Oracle Critical Patch Update Advisory pages listed in the References section.
    (CVE-2017-3238, CVE-2017-3243, CVE-2017-3244, CVE-2017-3257, CVE-2017-3258, CVE-2017-3308, CVE-2017-3309,
    CVE-2017-3313, CVE-2017-3317, CVE-2017-3318, CVE-2017-3453, CVE-2017-3456, CVE-2017-3464, CVE-2017-3636,
    CVE-2017-3641, CVE-2017-3653, CVE-2017-10268, CVE-2017-10286, CVE-2017-10378, CVE-2017-10379,
    CVE-2017-10384)
    CVE-2016-5617
    ** REJECT **
    DO NOT USE THIS CANDIDATE NUMBER.  ConsultIDs: CVE-2016-6664.  Reason:
    This candidate is a reservation duplicate of CVE-2016-6664.  Notes:
    All CVE users should reference CVE-2016-6664 instead of this
    candidate.  All references and descriptions in this candidate have
    been removed to prevent accidental usage.
    CVE-2016-6664
    mysqld_safe in Oracle MySQL through 5.5.51, 5.6.x through 5.6.32, and
    5.7.x through 5.7.14; MariaDB; Percona Server before 5.5.51-38.2,
    5.6.x before 5.6.32-78-1, and 5.7.x before 5.7.14-8; and Percona
    XtraDB Cluster before 5.5.41-37.0, 5.6.x before 5.6.32-25.17, and
    5.7.x before 5.7.14-26.17, when using file-based logging, allows local
    users with access to the mysql account to gain root privileges via a
    symlink attack on error logs and possibly other files.
    CVE-2017-10268
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Replication). Supported versions that are
    affected are 5.5.57 and earlier, 5.6.37 and earlier and 5.7.19 and
    earlier. Difficult to exploit vulnerability allows high privileged
    attacker with logon to the infrastructure where MySQL Server executes
    to compromise MySQL Server. Successful attacks of this vulnerability
    can result in unauthorized access to critical data or complete access
    to all MySQL Server accessible data. CVSS 3.0 Base Score 4.1
    (Confidentiality impacts). CVSS Vector:
    (CVSS:3.0/AV:L/AC:H/PR:H/UI:N/S:U/C:H/I:N/A:N).
    CVE-2017-10286
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: InnoDB). Supported versions that are affected
    are 5.6.37 and earlier and 5.7.19 and earlier. Difficult to exploit
    vulnerability allows high privileged attacker with network access via
    multiple protocols to compromise MySQL Server. Successful attacks of
    this vulnerability can result in unauthorized ability to cause a hang
    or frequently repeatable crash (complete DOS) of MySQL Server. CVSS
    3.0 Base Score 4.4 (Availability impacts). CVSS Vector:
    (CVSS:3.0/AV:N/AC:H/PR:H/UI:N/S:U/C:N/I:N/A:H).
    CVE-2017-10378
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Optimizer). Supported versions that are
    affected are 5.5.57 and earlier, 5.6.37 and earlier and 5.7.11 and
    earlier. Easily exploitable vulnerability allows low privileged
    attacker with network access via multiple protocols to compromise
    MySQL Server. Successful attacks of this vulnerability can result in
    unauthorized ability to cause a hang or frequently repeatable crash
    (complete DOS) of MySQL Server. CVSS 3.0 Base Score 6.5 (Availability
    impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H).
    CVE-2017-10379
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Client programs). Supported versions that are affected
    are 5.5.57 and earlier, 5.6.37 and earlier and 5.7.19 and earlier.
    Easily exploitable vulnerability allows low privileged attacker with
    network access via multiple protocols to compromise MySQL Server.
    Successful attacks of this vulnerability can result in unauthorized
    access to critical data or complete access to all MySQL Server
    accessible data. CVSS 3.0 Base Score 6.5 (Confidentiality impacts).
    CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:N/A:N).
    CVE-2017-10384
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DDL). Supported versions that are affected are
    5.5.57 and earlier 5.6.37 and earlier 5.7.19 and earlier. Easily
    exploitable vulnerability allows low privileged attacker with network
    access via multiple protocols to compromise MySQL Server. Successful
    attacks of this vulnerability can result in unauthorized ability to
    cause a hang or frequently repeatable crash (complete DOS) of MySQL
    Server. CVSS 3.0 Base Score 6.5 (Availability impacts). CVSS Vector:
    (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H).
    CVE-2017-3238
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Optimizer). Supported versions that are
    affected are 5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and
    earlier. Easily exploitable vulnerability allows low privileged
    attacker with network access via multiple protocols to compromise
    MySQL Server. Successful attacks of this vulnerability can result in
    unauthorized ability to cause a hang or frequently repeatable crash
    (complete DOS) of MySQL Server. CVSS v3.0 Base Score 6.5 (Availability
    impacts).
    CVE-2017-3243
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Charsets). Supported versions that are affected
    are 5.5.53 and earlier. Difficult to exploit vulnerability allows high
    privileged attacker with network access via multiple protocols to
    compromise MySQL Server. Successful attacks of this vulnerability can
    result in unauthorized ability to cause a hang or frequently
    repeatable crash (complete DOS) of MySQL Server. CVSS v3.0 Base Score
    4.4 (Availability impacts).
    CVE-2017-3244
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DML). Supported versions that are affected are
    5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and earlier. Easily
    exploitable vulnerability allows low privileged attacker with network
    access via multiple protocols to compromise MySQL Server. Successful
    attacks of this vulnerability can result in unauthorized ability to
    cause a hang or frequently repeatable crash (complete DOS) of MySQL
    Server. CVSS v3.0 Base Score 6.5 (Availability impacts).
    CVE-2017-3257
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: InnoDB). Supported versions that are affected
    are 5.6.34 and earlier5.7.16 and earlier. Easily exploitable
    vulnerability allows low privileged attacker with network access via
    multiple protocols to compromise MySQL Server. Successful attacks of
    this vulnerability can result in unauthorized ability to cause a hang
    or frequently repeatable crash (complete DOS) of MySQL Server. CVSS
    v3.0 Base Score 6.5 (Availability impacts).
    CVE-2017-3258
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DDL). Supported versions that are affected are
    5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and earlier. Easily
    exploitable vulnerability allows low privileged attacker with network
    access via multiple protocols to compromise MySQL Server. Successful
    attacks of this vulnerability can result in unauthorized ability to
    cause a hang or frequently repeatable crash (complete DOS) of MySQL
    Server. CVSS v3.0 Base Score 6.5 (Availability impacts).
    CVE-2017-3265
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Packaging). Supported versions that are
    affected are 5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and
    earlier. Difficult to exploit vulnerability allows high privileged
    attacker with logon to the infrastructure where MySQL Server executes
    to compromise MySQL Server. Successful attacks require human
    interaction from a person other than the attacker. Successful attacks
    of this vulnerability can result in unauthorized access to critical
    data or complete access to all MySQL Server accessible data and
    unauthorized ability to cause a hang or frequently repeatable crash
    (complete DOS) of MySQL Server. CVSS v3.0 Base Score 5.6
    (Confidentiality and Availability impacts).
    CVE-2017-3291
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Packaging). Supported versions that are
    affected are 5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and
    earlier. Difficult to exploit vulnerability allows high privileged
    attacker with logon to the infrastructure where MySQL Server executes
    to compromise MySQL Server. Successful attacks require human
    interaction from a person other than the attacker. Successful attacks
    of this vulnerability can result in takeover of MySQL Server. CVSS
    v3.0 Base Score 6.3 (Confidentiality, Integrity and Availability
    impacts).
    CVE-2017-3302
    Crash in libmysqlclient.so in Oracle MySQL before 5.6.21 and 5.7.x
    before 5.7.5 and MariaDB through 5.5.54, 10.0.x through 10.0.29, 10.1.x
    through 10.1.21, and 10.2.x through 10.2.3.
    CVE-2017-3308
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DML). Supported versions that are affected are
    5.5.54 and earlier, 5.6.35 and earlier and 5.7.17 and earlier. Easily
    exploitable vulnerability allows low privileged attacker with
    network access via multiple protocols to compromise MySQL Server.
    While the vulnerability is in MySQL Server, attacks may significantly
    impact additional products. Successful attacks of this vulnerability
    can result in unauthorized ability to cause a hang or frequently
    repeatable crash (complete DOS) of MySQL Server. CVSS 3.0 Base Score
    7.7 (Availability impacts). CVSS Vector:
    (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:C/C:N/I:N/A:H).
    CVE-2017-3309
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Optimizer). Supported versions that are
    affected are 5.5.54 and earlier, 5.6.35 and earlier and 5.7.17 and
    earlier. Easily exploitable vulnerability allows low privileged
    attacker with network access via multiple protocols to compromise
    MySQL Server. While the vulnerability is in MySQL Server, attacks may
    significantly impact additional products. Successful attacks of this
    vulnerability can result in unauthorized ability to cause a hang or
    frequently repeatable crash (complete DOS) of MySQL Server. CVSS 3.0
    Base Score 7.7 (Availability impacts). CVSS Vector:
    (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:C/C:N/I:N/A:H).
    CVE-2017-3312
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Packaging). Supported versions that are
    affected are 5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and
    earlier. Difficult to exploit vulnerability allows low privileged
    attacker with logon to the infrastructure where MySQL Server executes
    to compromise MySQL Server. Successful attacks require human
    interaction from a person other than the attacker. Successful attacks
    of this vulnerability can result in takeover of MySQL Server. CVSS
    v3.0 Base Score 6.7 (Confidentiality, Integrity and Availability
    impacts).
    CVE-2017-3313
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: MyISAM). Supported versions that are affected
    are 5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and earlier.
    Difficult to exploit vulnerability allows low privileged attacker with
    logon to the infrastructure where MySQL Server executes to compromise
    MySQL Server. Successful attacks of this vulnerability can result in
    unauthorized access to critical data or complete access to all MySQL
    Server accessible data. CVSS v3.0 Base Score 4.7 (Confidentiality
    impacts).
    CVE-2017-3317
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Logging). Supported versions that are affected are
    5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and earlier.
    Difficult to exploit vulnerability allows high privileged attacker
    with logon to the infrastructure where MySQL Server executes to
    compromise MySQL Server. Successful attacks require human interaction
    from a person other than the attacker. Successful attacks of this
    vulnerability can result in unauthorized ability to cause a hang or
    frequently repeatable crash (complete DOS) of MySQL Server. CVSS v3.0
    Base Score 4.0 (Availability impacts).
    CVE-2017-3318
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Error Handling). Supported versions that are
    affected are 5.5.53 and earlier, 5.6.34 and earlier and 5.7.16 and
    earlier. Difficult to exploit vulnerability allows high privileged
    attacker with logon to the infrastructure where MySQL Server executes
    to compromise MySQL Server. Successful attacks require human
    interaction from a person other than the attacker. Successful attacks
    of this vulnerability can result in unauthorized access to critical
    data or complete access to all MySQL Server accessible data. CVSS v3.0
    Base Score 4.0 (Confidentiality impacts).
    CVE-2017-3453
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: Optimizer). Supported versions that are
    affected are 5.5.54 and earlier, 5.6.35 and earlier and 5.7.17 and
    earlier. Easily exploitable vulnerability allows low privileged
    attacker with network access via multiple protocols to compromise
    MySQL Server. Successful attacks of this vulnerability can result in
    unauthorized ability to cause a hang or frequently repeatable crash
    (complete DOS) of MySQL Server. CVSS 3.0 Base Score 6.5 (Availability
    impacts). CVSS Vector: (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:N/A:H).
    CVE-2017-3456
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DML). Supported versions that are affected are
    5.5.54 and earlier, 5.6.35 and earlier and 5.7.17 and earlier. Easily
    exploitable vulnerability allows high privileged attacker with
    network access via multiple protocols to compromise MySQL Server.
    Successful attacks of this vulnerability can result in unauthorized
    ability to cause a hang or frequently repeatable crash (complete DOS)
    of MySQL Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS
    Vector: (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H).
    CVE-2017-3464
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DDL). Supported versions that are affected are
    5.5.54 and earlier, 5.6.35 and earlier and 5.7.17 and earlier. Easily
    exploitable vulnerability allows low privileged attacker with
    network access via multiple protocols to compromise MySQL Server.
    Successful attacks of this vulnerability can result in unauthorized
    update, insert or delete access to some of MySQL Server accessible
    data. CVSS 3.0 Base Score 4.3 (Integrity impacts). CVSS Vector:
    (CVSS:3.0/AV:N/AC:L/PR:L/UI:N/S:U/C:N/I:L/A:N).
    CVE-2017-3636
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Client programs). Supported versions that are affected
    are 5.5.56 and earlier and 5.6.36 and earlier. Easily exploitable
    vulnerability allows low privileged attacker with logon to the
    infrastructure where MySQL Server executes to compromise MySQL Server.
    Successful attacks of this vulnerability can result in unauthorized
    update, insert or delete access to some of MySQL Server accessible
    data as well as unauthorized read access to a subset of MySQL Server
    accessible data and unauthorized ability to cause a partial denial of
    service (partial DOS) of MySQL Server. CVSS 3.0 Base Score 5.3
    (Confidentiality, Integrity and Availability impacts). CVSS Vector:
    (CVSS:3.0/AV:L/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:L).
    CVE-2017-3641
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DML). Supported versions that are affected are
    5.5.56 and earlier, 5.6.36 and earlier and 5.7.18 and earlier. Easily
    exploitable vulnerability allows high privileged attacker with network
    access via multiple protocols to compromise MySQL Server. Successful
    attacks of this vulnerability can result in unauthorized ability to
    cause a hang or frequently repeatable crash (complete DOS) of MySQL
    Server. CVSS 3.0 Base Score 4.9 (Availability impacts). CVSS Vector:
    (CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:N/I:N/A:H).
    CVE-2017-3653
    Vulnerability in the MySQL Server component of Oracle MySQL
    (subcomponent: Server: DDL). Supported versions that are affected are
    5.5.56 and earlier, 5.6.36 and earlier and 5.7.18 and earlier.
    Difficult to exploit vulnerability allows low privileged attacker with
    network access via multiple protocols to compromise MySQL Server.
    Successful attacks of this vulnerability can result in unauthorized
    update, insert or delete access to some of MySQL Server accessible
    data. CVSS 3.0 Base Score 3.1 (Integrity impacts). CVSS Vector:
    (CVSS:3.0/AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:L/A:N).

Tenable has extracted the preceding description block directly from the MiracleLinux security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version
number.");
  script_set_attribute(attribute:"see_also", value:"https://tsn.miraclelinux.com/en/node/9027");
  script_set_attribute(attribute:"solution", value:
"Update the affected packages.");
  script_set_cvss_base_vector("CVSS2#AV:L/AC:M/Au:N/C:C/I:C/A:C");
  script_set_cvss_temporal_vector("CVSS2#E:H/RL:OF/RC:C");
  script_set_cvss3_base_vector("CVSS:3.0/AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H");
  script_set_cvss3_temporal_vector("CVSS:3.0/E:H/RL:O/RC:C");
  script_set_attribute(attribute:"cvss_score_source", value:"CVE-2016-6664");

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

  script_set_attribute(attribute:"vuln_publication_date", value:"2016/10/18");
  script_set_attribute(attribute:"patch_publication_date", value:"2018/03/01");
  script_set_attribute(attribute:"plugin_publication_date", value:"2026/01/16");

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-bench");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-common");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-config");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-devel");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-errmsg");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-oqgraph-engine");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-server");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:miracle:linux:rh-mariadb100-mariadb-test");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:miracle:linux:4");
  script_set_attribute(attribute:"generated_plugin", value:"current");
  script_end_attributes();

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

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

  script_dependencies("ssh_get_info.nasl");
  script_require_keys("Host/local_checks_enabled", "Host/MiracleLinux/release", "Host/MiracleLinux/rpm-list", "Host/cpu");

  exit(0);
}


include('rpm2.inc');

if (!get_kb_item('Host/local_checks_enabled')) audit(AUDIT_LOCAL_CHECKS_NOT_ENABLED);
var os_product = get_kb_item('installed_os/local/SSH/0/product');
if (isnull(os_product) || 'MIRACLE LINUX' >!< os_product) audit(AUDIT_OS_NOT, 'MIRACLE LINUX');
var os_version = get_kb_item('installed_os/local/SSH/0/version');
if (isnull(os_version)) audit(AUDIT_UNKNOWN_APP_VER, 'MIRACLE LINUX');
if (! preg(pattern:"^4([^0-9]|$)", string:os_version)) audit(AUDIT_OS_NOT, 'MiracleLinux 4.x', 'MIRACLE LINUX ' + os_version);

if (!get_kb_item('Host/MiracleLinux/rpm-list')) audit(AUDIT_PACKAGE_LIST_MISSING);

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

var constraints = [
  {
    'release': '4',
    'pkgs': [
      {'reference':'rh-mariadb100-mariadb-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-bench-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-common-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-config-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-devel-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-errmsg-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-oqgraph-engine-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-server-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'rh-mariadb100-mariadb-test-10.0.33-3.AXS4', 'cpu':'x86_64', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'}
    ]
  }
];

var os_release = get_one_kb_item('installed_os/local/SSH/0/release');
var os_sp = get_one_kb_item('Host/*/minor_release');

var flag = 0;
var reference;
var sp;
var _cpu;
var el_string;
var rpm_spec_vers_cmp;
var epoch;
var allowmaj;
var exists_check;
var cves;
foreach var constraint ( constraints ) {
  # Check that the target release is equal to the affected release
  if (!empty_or_null(constraint['release'])){
    if (constraint['release'] != os_release) continue;
  }
  if (!empty_or_null(constraint['sp'])){
    if (constraint['sp'] != os_sp) continue;
  }
  foreach var pkg ( constraint['pkgs'] ) {
    reference = NULL;
    sp = NULL;
    _cpu = NULL;
    el_string = NULL;
    rpm_spec_vers_cmp = NULL;
    epoch = NULL;
    allowmaj = NULL;
    exists_check = NULL;
    cves = NULL;
    if (!empty_or_null(pkg['reference'])) reference = pkg['reference'];
    if (!empty_or_null(pkg['sp'])) sp = pkg['sp'];
    if (!empty_or_null(pkg['cpu'])) _cpu = pkg['cpu'];
    if (!empty_or_null(pkg['el_string'])) el_string = pkg['el_string'];
    if (!empty_or_null(pkg['rpm_spec_vers_cmp'])) rpm_spec_vers_cmp = pkg['rpm_spec_vers_cmp'];
    if (!empty_or_null(pkg['epoch'])) epoch = pkg['epoch'];
    if (!empty_or_null(pkg['allowmaj'])) allowmaj = pkg['allowmaj'];
    if (!empty_or_null(pkg['exists_check'])) exists_check = pkg['exists_check'];
    if (!empty_or_null(pkg['cves'])) cves = pkg['cves'];
    if (reference &&
        ## (no known rpm to check OR known rpm_exists)
        (!exists_check || rpm_exists(rpm:exists_check)) &&
        rpm_check(sp:sp, cpu:_cpu, reference:reference, epoch:epoch, el_string:el_string, rpm_spec_vers_cmp:rpm_spec_vers_cmp, allowmaj:allowmaj, cves:cves)) flag++;
  }
}
if (flag)
{
  security_report_v4(
      port       : 0,
      severity   : SECURITY_WARNING,
      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, 'rh-mariadb100-mariadb / rh-mariadb100-mariadb-bench / etc');
}