MySQL PowerPack Release Notes version 104

Version 104 of the "MySQL" PowerPack adds support for Python 3.11 execution environments and introduces discovery for MySQL servers over IPv6. It also updates logging standards and enables authentication in MySQL version 8.0 and later. In addition, it addresses several issues from previous versions.

  • Minimum Required Skylar One (SL1) Version: 12.3.1

  • Minimum Required MySQL Version: 5.6.0

Before You Install or Upgrade

Ensure that you are running version 12.3.1 or later of Skylar One before installing the "MySQL" PowerPack.

For details on upgrading Skylar One, see the relevant Skylar One Platform Release Notes.

Installation and Upgrade Process

By default, installing a new version of a PowerPack overwrites all content in that PowerPack that has already been installed on the target system. You can use the Enable Selective PowerPack Field Protection setting in the Behavior Settings page (System > Settings > Behavior) to prevent the new version of the PowerPack from overwriting local changes for some commonly customized fields.

For details on upgrading Skylar One, see the relevant Skylar One Platform Release Notes.

To download and install the PowerPack:

  1. Search for and download the PowerPack from the PowerPacks page at the ScienceLogic Support Center (Skylar One > PowerPacks, login required).
  2. In Skylar One, go to the PowerPacks page (System > Manage > PowerPacks).
  3. Click the actions icon and choose Import PowerPack. The Import PowerPack dialog box appears.
  4. Click [Browse] and navigate to the PowerPack file from step 1.
  5. Select the PowerPack file and click Import. The PowerPack Installer modal displays a list of the PowerPack contents.
  6. Click Install. The PowerPack is added to the PowerPacks page.

If you exit the PowerPack Installer modal without installing the imported PowerPack, the imported PowerPack will not appear on the PowerPacks page. However, the imported PowerPack will appear in the Imported PowerPacks modal. This modal appears when you click the Actions menu and select Install PowerPack.

Features

This release includes the following features:

  • Dynamic Applications to discover, model, monitor performance metrics, and collect configuration data for MySQL servers and instances
  • Execution environments to process data and commands for MySQL

Enhancements and Issues Addressed

The following enhancements and addressed issues are included in this release:

  • Updated the PowerPack to support Python 3.11 execution environments.
  • Added support for discovering MySQL servers over IPv6.
  • Updated the PowerPack to use the silo_logs library for standard, Python-based log output.
  • Replaced the MySQLdb library with PyMySQL to enable authentication in MySQL version 8.0 and later.
  • Addressed an issue in which MySQL component devices became unavailable due to the "MySQL: Instance Discovery" Dynamic Application stopping when an instance was unresponsive. (Case: 00463285)
  • Resolved an issue that previously prevented using the PowerPack in STIG ISO deployments.
  • Updated most collection objects for the "MySQL: Instance Configuration" Dynamic Application to retrieve instance defaults instead of session defaults.
  • Addressed an issue that caused the "MySQL: Discovery" Dynamic Application to log numerous "Connection refused" error messages in debug mode while scanning ports during discovery.

Known Issues

The following known issues affect version 104 of the "MySQL" PowerPack:

  • When the server log level variable (log_error verbosity on MySQL, log_warnings on MariaDB) is set to information on a monitored device, a "Got Packets out of order" message may appear in some entries every 15 minutes.

  • Version 104 of the "MySQL" PowerPack does not support error logs from MySQL on a Docker container.

  • The MySQL PowerPack only parses errors (and not warnings) from the files set by the variable log_error. If it is set, it does not parse from stderr.

  • Users need to have permission to read the MySQL error log file on Linux servers. To enable this, execute the following command:

    sudo usermod -a -G mysql <ssh user>

  • The MySQL PowerPack is not supported on Military Unique Deployment (MUD) systems.

  • The caching_sha2_password plugin is not supported in MySQL 8. Users should use mysql_native_password.