packaging: align mysql connector with Marvin - #13840

Description

This is a small follow-up for #13482.

In #13482 the Marvin dependency was changed to mysql-connector-python >= 8.4.0. The older 8.0.31 connector was installed on the Marvin node and caused smoke test failures when testing against OL10, Debian 12 and SUSE15 management environments.

However, the RPM specs were not updated at the same time. Current situation is:

• Marvin %post still explicitly installs 8.0.31 before it installs Marvin, while Marvin asks for 8.4.0 or newer;
• management package installs 8.3.0 on the newer Python path;
• this path is selected from Python 3.7, while connector 8.4.0 requires Python 3.8 or newer.

Management and Marvin are normally installed on different machines, so this is not a clash between two packages on the same server. Still, each RPM package should install a connector version which matches the component inside that package.

This PR changes both EL and SUSE RPM specs:

• management installs exact 8.4.0 on Python 3.8 or newer;
• old Python path keeps 8.0.31;
• Python version check is corrected from 3.7 to 3.8;
• Marvin %post installs exact 8.4.0 before installing Marvin.

I checked the current 4.23 RC branches and main, and the same old blocks are still present there. This PR targets 4.22, so it can be merged forward after that.

Types of changes

• Breaking change (fix or feature that would cause existing functionality to change)
• New feature (non-breaking change which adds functionality)
• Bug fix (non-breaking change which fixes an issue)
• Enhancement (improves an existing feature and functionality)
• Cleanup (Code refactoring and cleanup, that may add test cases)
• Build/CI
• Test (unit or integration test code)

Feature/Enhancement Scale or Bug Severity

Feature/Enhancement Scale

• Major
• Minor

Bug Severity

• BLOCKER
• Critical
• Major
• Minor
• Trivial

How Has This Been Tested?

Tests done locally:

• both changed specs parsed with native rpmspec -P on Oracle Linux 8.10;
• official 8.4.0 wheel SHA-256 was verified;
• 8.0.31 was installed and imported on Python 3.6, with clean pip check;
• 8.4.0 was installed and imported on Python 3.12, its Requires-Python: >=3.8 metadata was verified, with clean pip check;
• both management and Marvin installation commands were tested starting from installed 9.4.0, and both correctly finished with exact 8.4.0;
• EL and SUSE connector blocks were checked to stay identical.

The upstream multi-distribution package build was also requested on this PR.