Kaltura v9.18 MySQL v5.6 admin password reset


#1

We have Kaltura v9.18 MySQL v5.6

/opt/kaltura/bin/kaltura-db-config.sh mysql rootuser passwd 3306

Checking MySQL version
Your version of MySQL is not compatible with Kaltura at the moment.
Please install and configure MySQL 5.1 according to the instructions on the Kaltura install manual before proceeding with the Kaltura installation.

How I can bypass “Checking MySQL version”?

SANITY
[Check memcached daemon is started by Monit] [PASSED, RC: 0] - [8.345505537]
[check_daemon_init_status] [FAILED, RC: 1] - [.005924325]
[kaltura-html5lib ver in KMC config.ini] [PASSED, RC: 0] - [.076917386]
[kaltura-kdp3 ver in KMC config.ini] [PASSED, RC: 0] - [.037080452]
[kaltura-kmc ver in KMC config.ini] [PASSED, RC: 0] - [.053796015]

PHP Warning: file_get_contents(http://mydomain/kmc): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
in /client/kaltura/bin/get_kmc_swfs.php on line 9
[Get KMC SWFs] [FAILED, RC: 255] - [.072296999]
curl: no URL specified!
curl: try ‘curl --help’ or ‘curl --manual’ for more information
[check_testme_page] [FAILED, RC: 1] - [.012491243]
[check_kmc_index_page] [FAILED, RC: 1] - [.007552282]
curl: no URL specified!
curl: try ‘curl --help’ or ‘curl --manual’ for more information
[check_admin_console_index_page] [FAILED, RC: 1] - [.012661152]
[Create Partner] [FAILED, RC: 255] - [.120467503]
Partner creation failed. I will skip all tests that require it.
[Red5 file upload] [SKIPPED as OflaDemo isn’t configured]

I appreciate any advice. Thank you. Dmitri


#2

Hi @astrava,

v9.18 will not work with MySQL 5.6, I’m afraid.
If you want to use 5.6, you’ll need to upgrade to a higher version.
MySQL 5.6 support was added in 11.1.0. The DB population will not work correctly when strict mode is enabled so, to work with 5.6, one needs to disable it. There were several other changes that had to be done, both to the SQL code under deployment/base/sql and the installation scripts.