Kaltura 16.5 Install Failed on RHEL 8.5

Background: we are currently using Kaltura 16.5.0 on RHEL 7 and testing the feasibility of upgrading to RHEL 8. According to the documentation, RHEL 8 is supported.

However, during the installation, I faced an error.

Connectivity test passed:)
ERROR: Couldn't connect to Sphinx with mysql -h127.0.0.1 -P9312.
Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.

Do you wish to remove the Kaltura DBs? [n/Y]
Hit 'n' to keep it for debugging purposes.

ERROR: we failed on something else..
[root@rhel85 installation]#

When I checked the version of the MySQL client installed, it is version 8.

[root@rhel85 installation]# mysql --version
mysql  Ver 8.0.26 for Linux on x86_64 (Source distribution)

And it seems the MySQL client failed to connect to Sphinx during the Kaltura initialisation script, like what other has discovered.

When I tried to follow the walkthrough like this one, and disable the MySQL8 module that came with RHEL8, before the installation of the Kaltura server, the installation failed before the kaltura-sphinx package has a dependencies of libmysqlclient.so.21, which in turn is provided by mysql-libs-8.0.26-1.

[root@rhel85 ~]# dnf repoquery --deplist kaltura-sphinx
Updating Subscription Management repositories.
Last metadata expiration check: 0:00:48 ago on Fri 14 Jan 2022 12:30:44 AM +08.
package: kaltura-sphinx-2.2.1-23.x86_64
  dependency: libmysqlclient.so.21()(64bit)
   provider: mysql-libs-8.0.26-1.module+el8.4.0+12359+b8928c02.x86_64
  dependency: libmysqlclient.so.21(libmysqlclient_21.0)(64bit)
   provider: mysql-libs-8.0.26-1.module+el8.4.0+12359+b8928c02.x86_64

So can someone tell me what should I do to allow me to install Kaltura 16.5, or later, to be installed on RHEL8, with the correct MySQL client installed properly?

Many thanks.