Installation of kaltura-server 18.18.0 on Rockylinux 8 failed Couldn't connect to Sphinx with mysql -h127.0.0.1 -P9312

Hello @jess
After reading all problems asked in the forum
i was able to install kaltura-server 18.18.0 on RockyLinux
i was blocked at the begining because of mysql8 which is come as defaut mysql in rocky
And kaltura-server 18.18.0 come with default mysql-client 8 .
I decided to create a Docker with perconna 5.5 which help me to arrive at below step and blocked with this problem

Checking connectivity to needed daemons…
Connectivity test passed:)
ERROR: Couldn’t connect to Sphinx with mysql -h127.0.0.1 -P9312.
ERROR: Couldn’t make an API request to http://kaltura.adisys.cd/api_v3/index.php?service=system&action=ping.
Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.


VOD packager hostname [XXXXXXXXXXXXXXXXX]:
VOD packager port to listen on [88]:
Admin user login password (must be minimum 8 chars and include at least one of each: upper-case, lower-case, number and a special character):
Confirm passwd:
Your time zone [see PHP: Runtime Configuration - Manual], or press enter for [unknown]: Africa/Kinshasa
Your Kaltura install name (this name will show as the From field in emails sent by the system) [Kaltura Video Platform]:
Your website Contact Us URL [New Request Contact Us | Kaltura]: XXXXXX
Your ‘Contact us’ phone number [+1 800 871 5224]:XXXXXXXX
Checking MySQL version…
mysql: [Warning] Using a password on the command line interface can be insecure.
Ver 5.6.51-91.0 found compatible

========================================================================================================================
Kaltura install answer file written to /tmp/kaltura_09_08_21_03.ans - Please save it!
This answers file can be used to silently-install re-install this machine or deploy other hosts in your cluster.

Configuration of 18.18.0 finished successfully!
Running FrontEnd config…

base-config completed successfully, if you ever want to re-configure your system (e.g. change DB hostname) run the following script:

rm /opt/kaltura/app/base-config.lock

/opt/kaltura/bin/kaltura-base-config.sh

kaltura-front-18.18.0-1.noarch
Is your Apache working with SSL?[Y/n]
n
Which port will this Vhost listen on? [80]

Please select one of the following options [0]:
0. All web interfaces

  1. Kaltura Management Console [KMC], Hosted Apps, HTML5 lib and ClipApp
  2. KAC - Kaltura Admin Console
    0
    Enabling Apache config - apps.conf
    Enabling Apache config - var.conf
    Enabling Apache config - admin.conf

========================================================================================================================
Kaltura install answer file written to /tmp/kaltura_09_08_21_03.ans - Please save it!
This answers file can be used to silently-install re-install this machine or deploy other hosts in your cluster.

Redirecting to /bin/systemctl restart httpd.service
Note: Forwarding request to ‘systemctl enable httpd.service’.
Note: Forwarding request to ‘systemctl enable memcached.service’.
Redirecting to /bin/systemctl restart memcached.service
Restarting kaltura-monit (via systemctl): [ OK ]
Running Sphinx config…

kaltura-sphinx-2.2.1-23.x86_64
base-config completed successfully, if you ever want to re-configure your system (e.g. change DB hostname) run the following script:

rm /opt/kaltura/app/base-config.lock

/opt/kaltura/bin/kaltura-base-config.sh

Starting kaltura-monit (via systemctl): [ OK ]
kaltura-elasticsearch-1.0.0-7.noarch
Warning: failed loading ‘/etc/yum.repos.d/mysql-community.repo’, skipping.
Waiting for process with pid 37847 to finish.
Last metadata expiration check: 0:00:02 ago on Wed 09 Aug 2023 09:04:06 PM WAT.
Package java-1.8.0-openjdk-headless-1:1.8.0.382.b05-2.el8.x86_64 is already installed.
Dependencies resolved.
Nothing to do.
Complete!
Restarting elasticsearch (via systemctl): [ OK ]
We’ve waited a minute and the ES daemon is still unreachable, we’re giving up:(
Redirecting to /bin/systemctl reload httpd.service

Configuring your Kaltura DB…

Checking MySQL version…
mysql: [Warning] Using a password on the command line interface can be insecure.
Ver 5.6.51-91.0 found compatible

CREATE USER kaltura;

CREATE USER etl;

CREATE DATABASE kaltura;

CREATE DATABASE kaltura_sphinx_log;

CREATE DATABASE kalturadw;

CREATE DATABASE kalturadw_ds;

CREATE DATABASE kalturadw_bisources;

CREATE DATABASE kalturalog;

Checking connectivity to needed daemons…
Connectivity test passed:)
ERROR: Couldn’t connect to Sphinx with mysql -h127.0.0.1 -P9312.
ERROR: Couldn’t make an API request to http://kaltura.adisys.cd/api_v3/index.php?service=system&action=ping.
Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.

After reading i noticed that mysql-client 8 which come as default dependiecie of kaltura-sever can not be connected tp Sphinx server. after 10 days of research i am blocked

Hello,

Start by having a look at (/opt/kaltura/app/configurations) db.ini and checking that names and ports match against your DB instance.

Regards,

David