Kaltura CE 11.11.0 released

Hello all,

The latest version is now available.

Core changelog:

  • SUP-5851 - Categories/Media gallery locked
  • SUP-7437 - API Errors When Pulling Custom Reports
  • PLAT-3842 - Two userEntry objects can be created for the same user and entry
  • PLAT-5222 - Can’t list by AUTOMATIC type
  • PLAT-5197 - The Duration of the DVR windows Don’t match the parameters of Entry

Install scripts changelog:

  • When writing to /opt/kaltura/app/configurations/sphinx/populate/hostname.ini use hostname as ‘sphinxServer’ (Reported by Waldemar Żurowsk)

To upgrade, please follow:
RPM based:

Deb based:

Or, if running a cluster:

As always, your feedback is welcomed,

centos 7 kaltura ce all in one - please help me :wink:

messages on console
"
/opt/kaltura/bin/kaltura-batch-config.sh
kaltura-batch-11.11.0-1.noarch
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

ERROR 1045 (28000): Access denied for user ‘kaltura’@‘localhost’ (using password: YES)

kaltura-batch-config.sh FAILED with: 19108 on line 66
"
first line in kaltura_populate.log

“[2016-04-04 08:52:13]failed to connect [1] [0.0040531158447266] mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
PHP Fatal error: Uncaught exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;] user[kaltura] password[lMIZqUCWFCMfMzn] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘sphinx_log_read’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/myDbHelper.class.php(30): Propel::getConnection(‘sphinx_log_read’)
#2 /opt/kaltura/app/plugins/sphinx_search/scripts/populateFromLog.php(63): myDbHelper::getConnection(‘sphinx_log_read’)
#3 {main}
thrown in /opt/kaltura/app/vendor/propel/Propel.php on line 649
[2016-04-04 08:52:13]failed to connect [1] [0.0020971298217773] mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
PHP Fatal error: Uncaught exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;] user[kaltura] password[lMIZqUCWFCMfMzn] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘sphinx_log_read’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/myDbHelper.class.php(30): Propel::getConnection(‘sphinx_log_read’)
#2 /opt/kaltura/app/plugins/sphinx_search/scripts/populateFromLog.php(63): myDbHelper::getConnection(‘sphinx_log_read’)
#3 {main}
thrown in /opt/kaltura/app/vendor/propel/Propel.php on line 649
[2016-04-04 08:53:24]conn took - 0.0015518665313721 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2016-04-04 08:53:24]total conn took 0.0052258968353271 mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2016-04-04 08:53:24]conn took - 0.00069594383239746 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2016-04-04 08:53:24]total conn took 0.00079894065856934 mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;

Hello,

As the message indicates, the code cannot connect to your MySQL.
Start by ensuring it is running with:
# service mariadb status
if it is not, check the logs using:
# journalctl _SYSTEMD_UNIT=mariadb.service
if it is running, check whether:
# telnet $DB1_HOST 3306
is able to connect or not, if it is not connecting, check FW rules, if it is, check whether:
# mysql -uroot -p$SUPER_USER_PASSWD
works, if it does not, you need to understand why.
If it does, then run:
# select user,host from mysql.user;

and post it here.

[root@kaltura ~]# mysql -uroot -p$SUPER_USER_PASSWD
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 307
Server version: 5.5.47-MariaDB MariaDB Server

Copyright © 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>

It is new instalation
I make all step by step (https://github.com/kaltura/platform-install-packages/blob/master/doc/install-kaltura-redhat-based.md )

"
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_04_04_13_25.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
Uwaga: przekazano żądanie do “systemctl enable httpd.service”.
Uwaga: przekazano żądanie do “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-17.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 ]
Running Batch config…

kaltura-batch-11.11.0-1.noarch
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

ERROR 1045 (28000): Access denied for user ‘kaltura’@‘localhost’ (using password: YES)

kaltura-batch-config.sh FAILED with: 7343 on line 66

Archving logs to /opt/kaltura/log/log_04_04_16_13_26.tar.gz…
ERROR: /opt/kaltura/bin/kaltura-batch-config.sh failed:( You can re-run it when the issue is fixed.
[root@kaltura ~]#

"

Looking at your output, I do not see the DB population part was done.
This is most probably because it already ran in the past, failed and now exists in a non functional state.
Start with:
#/opt/kaltura/bin/kaltura-drop-db.sh
and then rerun the configure script and make sure the DB population phase passes successfully, if it fails, you need to check why by looking at the logs.

I have centos 7 new instalation ( updated ) and make kaltura-config-all.sh
enter link description here
in kaltlog

"
[2016-04-05 14:13:52]failed to connect [1] [0.003000020980835] mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
PHP Fatal error: Uncaught exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;] user[kaltura] password[vbj3k3Ciw4hDk5Q] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘sphinx_log_read’)
"
and on console

"Configuring your Kaltura DB…

Checking MySQL version…
Ver 5.5.47-MariaDB 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 make an API request to http://kaltura.silesiakite.pl/api_v3/index.php?service=system&action=ping.
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.
"
in kaltura_populate.log
[2016-04-05 14:13:52]failed to connect [1] [0.002439022064209] mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
PHP Fatal error: Uncaught exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;] user[kaltura] password[vbj3k3Ciw4hDk5Q] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘sphinx_log_read’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/myDbHelper.class.php(30): Propel::getConnection(‘sphinx_log_read’)
#2 /opt/kaltura/app/plugins/sphinx_search/scripts/populateFromLog.php(63): myDbHelper::getConnection(‘sphinx_log_read’)
#3 {main}
thrown in /opt/kaltura/app/vendor/propel/Propel.php on line 649
[2016-04-05 14:13:52]failed to connect [1] [0.003000020980835] mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
PHP Fatal error: Uncaught exception ‘PropelException’ with message ‘Unable to open PDO connection dsn[mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;] user[kaltura] password[vbj3k3Ciw4hDk5Q] [wrapped: SQLSTATE[28000] [1045] Access denied for user ‘kaltura’@‘localhost’ (using password: YES)]’ in /opt/kaltura/app/vendor/propel/Propel.php:649
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(532): Propel::initConnection(Array, ‘sphinx_log_read’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/myDbHelper.class.php(30): Propel::getConnection(‘sphinx_log_read’)
#2 /opt/kaltura/app/plugins/sphinx_search/scripts/populateFromLog.php(63): myDbHelper::getConnection(‘sphinx_log_read’)
#3 {main}
thrown in /opt/kaltura/app/vendor/propel/Propel.php on line 649
[2016-04-05 14:16:03]conn took - 0.0024940967559814 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2016-04-05 14:16:03]total conn took 0.0085580348968506 mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2016-04-05 14:16:03]conn took - 0.00053095817565918 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2016-04-05 14:16:03]total conn took 0.00061583518981934 mysql:host=127.0.0.1;port=3306;dbname=kaltura_sphinx_log;
[2016-04-05 14:16:03]/* kaltura.silesiakite.pl[1648010405][sphinx_log] / SELECT sphinx_log_server.ID, sphinx_log_server.SERVER, sphinx_log_server.DC, sphinx_log_server.LAST_LOG_ID, sphinx_log_server.CREATED_AT, sphinx_log_server.UPDATED_AT FROM sphinx_log_server WHERE sphinx_log_server.SERVER=‘127.0.0.1’
[2016-04-05 14:16:03]Sql took - 0.0006260871887207 seconds
[2016-04-05 14:16:04]/
kaltura.silesiakite.pl[1648010405][sphinx_log] / SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log ORDER BY sphinx_log.ID ASC LIMIT 1000
[2016-04-05 14:16:04]Sql took - 0.00043392181396484 seconds
[2016-04-05 14:16:05]/
kaltura.silesiakite.pl[1648010405][sphinx_log] / SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log ORDER BY sphinx_log.ID ASC LIMIT 1000
[2016-04-05 14:16:05]Sql took - 0.00041103363037109 seconds
[2016-04-05 14:16:06]/
kaltura.silesiakite.pl[1648010405][sphinx_log] / SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log ORDER BY sphinx_log.ID ASC LIMIT 1000
[2016-04-05 14:16:06]Sql took - 0.00040578842163086 seconds
[2016-04-05 14:16:07]/
kaltura.silesiakite.pl[1648010405][sphinx_log] / SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log ORDER BY sphinx_log.ID ASC LIMIT 1000
[2016-04-05 14:16:07]Sql took - 0.00052690505981445 seconds
[2016-04-05 14:16:08]/
kaltura.silesiakite.pl[1648010405][sphinx_log] */ SELECT sphinx_log.ID, sphinx_log.EXECUTED_SERVER_ID, sphinx_log.OBJECT_TYPE, sphinx_log.OBJECT_ID, sphinx_log.ENTRY_ID, sphinx_log.PARTNER_ID, sphinx_log.DC, sphinx_log.SQL, sphinx_log.CREATED_AT FROM sphinx_log ORDER BY sphinx_log.ID ASC LIMIT 1000
[2016-04-05 14:16:08]Sql took - 0.00049901008605957 seconds

"
in file kaltura_sphinx_searchd.log

[Tue Apr 5 14:13:48.854 2016] [ 7828] Child process 7829 has been forked
[Tue Apr 5 14:13:48.855 2016] [ 7829] listening on all interfaces, port=9312
[Tue Apr 5 14:13:48.856 2016] [ 7829] WARNING: index ‘kaltura_base’: no fields configured (use rt_field directive) - NOT SERVING
[Tue Apr 5 14:13:48.856 2016] [ 7829] WARNING: index ‘kaltura_kuser_base’: no fields configured (use rt_field directive) - NOT SERVING
[Tue Apr 5 14:13:48.882 2016] [ 7829] accepting connections

"

Hi,

As the output clearly shows:

ERROR: Couldn't make an API request to http://kaltura.silesiakite.pl/api_v3/index.php?service=system&action=ping.

Until this is fixed, there is not point in continuing. Is kaltura.silesiakite.pl resolvable both from the Kaltura server and from where you intend to run the browser?

If not, it needs to be, if it is resolvable, what’s the output for:
# apachectl -t -DDUMP_VHOSTS
?

Ok thank you for help (my error in firewall NAT configuration external and internal ip)

This topic was automatically closed after 8 days. New replies are no longer allowed.