RockyLinux 9 : mysql (RLSA-2025:16086)

#%NASL_MIN_LEVEL 80900
##
# (C) Tenable, Inc.
#
# The package checks in this plugin were extracted from
# Rocky Linux Security Advisory RLSA-2025:16086.
##

include('compat.inc');

if (description)
{
  script_id(270104);
  script_version("1.1");
  script_set_attribute(attribute:"plugin_modification_date", value:"2025/10/12");

  script_cve_id(
    "CVE-2025-21574",
    "CVE-2025-21575",
    "CVE-2025-21577",
    "CVE-2025-21579",
    "CVE-2025-21580",
    "CVE-2025-21581",
    "CVE-2025-21584",
    "CVE-2025-21585",
    "CVE-2025-30681",
    "CVE-2025-30682",
    "CVE-2025-30683",
    "CVE-2025-30684",
    "CVE-2025-30685",
    "CVE-2025-30687",
    "CVE-2025-30688",
    "CVE-2025-30689",
    "CVE-2025-30693",
    "CVE-2025-30695",
    "CVE-2025-30696",
    "CVE-2025-30699",
    "CVE-2025-30703",
    "CVE-2025-30704",
    "CVE-2025-30705",
    "CVE-2025-30715",
    "CVE-2025-30721",
    "CVE-2025-30722",
    "CVE-2025-50077",
    "CVE-2025-50078",
    "CVE-2025-50079",
    "CVE-2025-50080",
    "CVE-2025-50081",
    "CVE-2025-50082",
    "CVE-2025-50083",
    "CVE-2025-50084",
    "CVE-2025-50085",
    "CVE-2025-50086",
    "CVE-2025-50087",
    "CVE-2025-50088",
    "CVE-2025-50091",
    "CVE-2025-50092",
    "CVE-2025-50093",
    "CVE-2025-50094",
    "CVE-2025-50096",
    "CVE-2025-50097",
    "CVE-2025-50098",
    "CVE-2025-50099",
    "CVE-2025-50100",
    "CVE-2025-50101",
    "CVE-2025-50102",
    "CVE-2025-50104",
    "CVE-2025-53023"
  );
  script_xref(name:"RLSA", value:"2025:16086");

  script_name(english:"RockyLinux 9 : mysql (RLSA-2025:16086)");

  script_set_attribute(attribute:"synopsis", value:
"The remote RockyLinux host is missing one or more security updates.");
  script_set_attribute(attribute:"description", value:
"The remote RockyLinux 9 host has packages installed that are affected by multiple vulnerabilities as referenced in the
RLSA-2025:16086 advisory.

    * mysql: mysqldump unspecified vulnerability (CPU Apr 2025) (CVE-2025-30722)

    * mysql: Optimizer unspecified vulnerability (CPU Apr 2025) (CVE-2025-30688)

    * mysql: Stored Procedure unspecified vulnerability (CPU Apr 2025) (CVE-2025-30699)

    * mysql: UDF unspecified vulnerability (CPU Apr 2025) (CVE-2025-30721)

    * mysql: Optimizer unspecified vulnerability (CPU Apr 2025) (CVE-2025-30682)

    * mysql: Replication unspecified vulnerability (CPU Apr 2025) (CVE-2025-30683)

    * mysql: Components Services unspecified vulnerability (CPU Apr 2025) (CVE-2025-30715)

    * mysql: Parser unspecified vulnerability (CPU Apr 2025) (CVE-2025-21574)

    * mysql: Optimizer unspecified vulnerability (CPU Apr 2025) (CVE-2025-21585)

    * mysql: Replication unspecified vulnerability (CPU Apr 2025) (CVE-2025-30681)

    * mysql: InnoDB unspecified vulnerability (CPU Apr 2025) (CVE-2025-21577)

    * mysql: Optimizer unspecified vulnerability (CPU Apr 2025) (CVE-2025-30687)

    * mysql: DML unspecified vulnerability (CPU Apr 2025) (CVE-2025-21580)

    * mysql: PS unspecified vulnerability (CPU Apr 2025) (CVE-2025-30696)

    * mysql: PS unspecified vulnerability (CPU Apr 2025) (CVE-2025-30705)

    * mysql: Parser unspecified vulnerability (CPU Apr 2025) (CVE-2025-21575)

    * mysql: Options unspecified vulnerability (CPU Apr 2025) (CVE-2025-21579)

    * mysql: Replication unspecified vulnerability (CPU Apr 2025) (CVE-2025-30685)

    * mysql: Components Services unspecified vulnerability (CPU Apr 2025) (CVE-2025-30704)

    * mysql: Optimizer unspecified vulnerability (CPU Apr 2025) (CVE-2025-21581)

    * mysql: Optimizer unspecified vulnerability (CPU Apr 2025) (CVE-2025-30689)

    * mysql: InnoDB unspecified vulnerability (CPU Apr 2025) (CVE-2025-30695)

    * mysql: InnoDB unspecified vulnerability (CPU Apr 2025) (CVE-2025-30703)

    * mysql: InnoDB unspecified vulnerability (CPU Apr 2025) (CVE-2025-30693)

    * mysql: DDL unspecified vulnerability (CPU Apr 2025) (CVE-2025-21584)

    * mysql: Replication unspecified vulnerability (CPU Apr 2025) (CVE-2025-30684)

    * mysql: InnoDB unspecified vulnerability (CPU Jul 2025) (CVE-2025-50092)

    * mysql: mysqldump unspecified vulnerability (CPU Jul 2025) (CVE-2025-50081)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50079)

    * mysql: InnoDB unspecified vulnerability (CPU Jul 2025) (CVE-2025-50077)

    * mysql: DML unspecified vulnerability (CPU Jul 2025) (CVE-2025-50078)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50091)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50101)

    * mysql: DDL unspecified vulnerability (CPU Jul 2025) (CVE-2025-50093)

    * mysql: InnoDB unspecified vulnerability (CPU Jul 2025) (CVE-2025-50099)

    * mysql: InnoDB unspecified vulnerability (CPU Jul 2025) (CVE-2025-50085)

    * mysql: Components Services unspecified vulnerability (CPU Jul 2025) (CVE-2025-50086)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50082)

    * mysql: Encryption unspecified vulnerability (CPU Jul 2025) (CVE-2025-50097)

    * mysql: DDL unspecified vulnerability (CPU Jul 2025) (CVE-2025-50104)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50087)

    * mysql: Replication unspecified vulnerability (CPU Jul 2025) (CVE-2025-53023)

    * mysql: Stored Procedure unspecified vulnerability (CPU Jul 2025) (CVE-2025-50080)

    * mysql: InnoDB unspecified vulnerability (CPU Jul 2025) (CVE-2025-50088)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50083)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50084)

    * mysql: Thread Pooling unspecified vulnerability (CPU Jul 2025) (CVE-2025-50100)

    * mysql: DDL unspecified vulnerability (CPU Jul 2025) (CVE-2025-50094)

    * mysql: Optimizer  unspecified vulnerability (CPU Jul 2025) (CVE-2025-50098)

    * mysql: InnoDB unspecified vulnerability (CPU Jul 2025) (CVE-2025-50096)

    * mysql: Optimizer unspecified vulnerability (CPU Jul 2025) (CVE-2025-50102)

Tenable has extracted the preceding description block directly from the RockyLinux 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://errata.rockylinux.org/RLSA-2025:16086");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359885");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359888");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359892");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359894");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359895");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359899");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359900");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359902");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359903");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359918");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359920");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359924");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359928");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359930");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359932");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359934");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359938");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359940");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359943");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359944");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359945");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359947");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359950");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359963");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359964");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2359972");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380264");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380273");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380274");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380278");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380280");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380283");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380284");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380290");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380291");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380295");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380298");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380306");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380308");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380309");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380310");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380311");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380312");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380313");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380320");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380321");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380322");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380326");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380327");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380334");
  script_set_attribute(attribute:"see_also", value:"https://bugzilla.redhat.com/show_bug.cgi?id=2380335");
  script_set_attribute(attribute:"solution", value:
"Update the affected packages.");
  script_set_cvss_base_vector("CVSS2#AV:N/AC:H/Au:S/C:C/I:C/A:N");
  script_set_cvss_temporal_vector("CVSS2#E:U/RL:OF/RC:C");
  script_set_cvss3_base_vector("CVSS:3.0/AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:N");
  script_set_cvss3_temporal_vector("CVSS:3.0/E:U/RL:O/RC:C");
  script_set_attribute(attribute:"cvss_score_source", value:"CVE-2025-30722");

  script_set_attribute(attribute:"exploitability_ease", value:"No known exploits are available");
  script_set_attribute(attribute:"exploit_available", value:"false");

  script_set_attribute(attribute:"vuln_publication_date", value:"2025/04/15");
  script_set_attribute(attribute:"patch_publication_date", value:"2025/10/10");
  script_set_attribute(attribute:"plugin_publication_date", value:"2025/10/12");

  script_set_attribute(attribute:"plugin_type", value:"local");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-common");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-debuginfo");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-debugsource");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-devel");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-devel-debuginfo");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-errmsg");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-libs");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-libs-debuginfo");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-server");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-server-debuginfo");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-test");
  script_set_attribute(attribute:"cpe", value:"p-cpe:/a:rocky:linux:mysql-test-debuginfo");
  script_set_attribute(attribute:"cpe", value:"cpe:/o:rocky:linux:9");
  script_set_attribute(attribute:"generated_plugin", value:"current");
  script_end_attributes();

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

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

  script_dependencies("ssh_get_info.nasl");
  script_require_keys("Host/local_checks_enabled", "Host/RockyLinux/release", "Host/RockyLinux/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) || 'Rocky Linux' >!< os_product) audit(AUDIT_OS_NOT, 'Rocky Linux');
var os_version = get_kb_item('installed_os/local/SSH/0/version');
if (isnull(os_version)) audit(AUDIT_UNKNOWN_APP_VER, 'Rocky Linux');
if (! preg(pattern:"^9([^0-9]|$)", string:os_version)) audit(AUDIT_OS_NOT, 'RockyLinux 9.x', 'Rocky Linux ' + os_version);

if (!get_kb_item('Host/RockyLinux/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, 'Rocky Linux', cpu);

var constraints = [
  {
    'release': '9',
    'pkgs': [
      {'reference':'mysql-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-common-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-common-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-common-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-common-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debuginfo-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debuginfo-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debuginfo-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debuginfo-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debugsource-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debugsource-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debugsource-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-debugsource-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-debuginfo-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-debuginfo-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-debuginfo-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-devel-debuginfo-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-errmsg-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-errmsg-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-errmsg-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-errmsg-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-debuginfo-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-debuginfo-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-debuginfo-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-libs-debuginfo-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-debuginfo-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-debuginfo-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-debuginfo-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-server-debuginfo-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-debuginfo-8.0.43-1.el9_6', 'cpu':'aarch64', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-debuginfo-8.0.43-1.el9_6', 'cpu':'ppc64le', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-debuginfo-8.0.43-1.el9_6', 'cpu':'s390x', 'el_string':'el9_6', 'rpm_spec_vers_cmp':TRUE, 'epoch':'0'},
      {'reference':'mysql-test-debuginfo-8.0.43-1.el9_6', 'cpu':'x86_64', 'el_string':'el9_6', '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, 'mysql / mysql-common / mysql-debuginfo / mysql-debugsource / etc');
}