Kaltura Video Platform - Community Edition v6.0.0 dev

11 replies [Last post]
Joined: 12/24/2012
Points: 12

Hi all,

I have the following error messages after installation.
Here some information about my system:

OS: SuSE 12.2

and here you can find everything

Systeminformation.

I would be very grateful for your help.

Greeting Roy Jones

AttachmentSize
error.txt31.91 KB
Joined: 05/13/2009
Points: 164

it looks like Apache doesn't have access to /opt/kaltura ?

Joined: 01/05/2009
Points: 1697

Just for the test - try running:
sudo chown apache:apache /opt/kaltura
change apache to whatever is the apache user name on your system

Joined: 12/24/2012
Points: 12

Hi
thanks to papyromancer and kalturian for their info.
the right for the Kaltura folder I have now set correctly.

unfortunately incur additional error messages:

at the registration admin-console:

2013-01-02 12:37:39 [0.000297] [127.0.0.1] [1264953147] [API] [kSphinxSearchManager->execSphinx] ERR: No database selected
2013-01-02 12:42:13 [0.001173] [127.0.0.1] [584716661] [API] [kCoreException->__construct] ERR: Code: [SEARCH_ENGINE_QUERY_FAILED,Search engine query failed] Message: [Invalid sphinx query [SELECT entry_distribution_id FROM ka ltura_entry_distribution WHERE entry_distribution_status <> 3 AND sunset <> 0 AND sunset < 1357126933 AND sun_status <> 3 LIMIT 1000 OPTION ranker=none, max_matches=1000, comment='roy-jones[584716661][sphinx]']

at the registration kmc: "Internal database error" and "Internal server error occured"
and in the logfile:

2013-01-02 12:59:47 [0.000256] [127.0.0.1] [298098139] [API] [myReportsMgr :: executeQuery] ERR: Invalid query: MySQL server has gone away
2013-01-02 12:59:47 [0.000867] [127.0.0.1] [298098139] [API] [kCoreException-> __construct] ERR: Code: [INVALID_QUERY] Message: [Invalid query]
Stack trace:
Stack trace:
Stack trace:

I am grateful for any help!

Joined: 12/24/2012
Points: 12

using config file '/ opt / Kaltura / app / configurations / sphinx kaltura.conf /' ...
WARNING: compat_sphinxql_magics = 1 is deprecated, please update your application and config
listening on all interfaces, port = 9312
Precaching index 'kaltura_entry'
Precaching index 'kaltura_category'
Precaching index 'kaltura_kuser'
Precaching index 'kaltura_cue_point'
Precaching index 'kaltura_entry_distribution'
Precaching index 'kaltura_caption_item'
Precaching index 'kaltura_tag'
precached 7 indexes in 0.027 sec

Joined: 01/05/2009
Points: 1697

ps faxu | grep sphinx
if Sphinx is down, run the following:
service sphinx_watch.sh start
If after start Sphinx still doesn't come up, Sphinx's index might be corrupted, try cleaning the Sphinx index:

rm -f /opt/kaltura/log/sphinx/data/*
service sphinx_watch.sh start

If Sphinx is running well, check that your mySQL is running, if it is, check the hostname and credentials in the following config:
/opt/kaltura/app/configurations/db.ini

Joined: 12/24/2012
Points: 12

ps faxu | grep sphinx

root 15511 0.0 0.0 4192 884 pts/3 S+ 16:34 0:00 \_ grep --color=auto sphinx
root 12601 0.0 0.0 4692 1448 pts/3 S 16:30 0:00 /bin/bash /opt/kaltura/app/plugins/sphinx_search/scripts/watch.daemon.sh
root 12678 0.0 0.0 9976 1060 ? S 16:30 0:00 /opt/kaltura/bin/sphinx/searchd --config /opt/kaltura/app/configurations/sphinx/kaltura.conf
root 12679 0.0 0.2 16492 4828 ? Sl 16:30 0:00 \_ /opt/kaltura/bin/sphinx/searchd --config /opt/kaltura/app/configurations/sphinx/kaltura.conf

if Sphinx is down, run the following:
service sphinx_watch.sh start

If after start Sphinx still doesn't come up, Sphinx's index might be corrupted, try cleaning the Sphinx index:
rm -f /opt/kaltura/log/sphinx/data/*
service sphinx_watch.sh start
If Sphinx is running well, check that your mySQL is running, if it is, check the hostname and credentials in the following config:
/opt/kaltura/app/configurations/db.ini

mysql info:

mysql.service - LSB: Start the MySQL database server
Loaded: loaded (/etc/init.d/mysql)
Active: active (running) since Thu, 03 Jan 2013 05:42:03 +0100; 1 day and 10h ago
Process: 5021 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
CGroup: name=systemd:/system/mysql.service
â 6471 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --data...
â 28481 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/mysq..

at the registration admin-console: 2013-01-04 16:37:57 [0.000300] [127.0.0.1] [1214941883] [API] [kSphinxSearchManager->execSphinx] ERR: No database selected

and this error by registration "Template KMC account" on kmc:

2013-01-04 16:41:24 [0.001216] [127.0.0.1] [1086442931] [API] [kCoreException->__construct] ERR: Code: [SEARCH_ENGINE_QUERY_FAILED,Search engine query failed] Message: [Invalid sphinx query [SELECT entry_distribution_id FROM kaltura_entry_distribution WHERE entry_distribution_status <> 3 AND sunset <> 0 AND sunset < 1357314084 AND sun_status <> 3 LIMIT 1000 OPTION ranker=none, max_matches=1000, comment='roy-jones[1086442931][sphinx]']

Joined: 01/05/2009
Points: 1697

Did you check the hostname and credentials on /opt/kaltura/app/configurations/db.ini ?

Also - please verify that SELinux is permissive or disabled.

Joined: 12/24/2012
Points: 12

on my system SuSE 12.2 does not run SELINUX.

STATUS: pam-config-a - selinux
ERROR: pam_apparmor pam_selinux together and are not allowed.

apparmor on my system running.

and this is my db.ini, I can find no errors:

Joined: 12/24/2012
Points: 12

.....
datasources.sphinx.adapter = mysql
datasources.sphinx.connection.dsn = "mysql:host=localhost;port=9312;"

datasources.dwh.adapter = mysql
datasources.dwh.connection.dsn = "mysql:host=127.0.0.1;port=3306;dbname=kalturadw;user=etl;password=etl;"

datasources.log.ident = kaltura
datasources.log.level = 5

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

first reg. on admin console:

roy-jones:/home/roy # tail -f /opt/kaltura/log/*.log | grep "ERR:\|PHP\|Stack trace" --color
2013-01-08 09:45:15 [0.000293] [127.0.0.1] [1815900016] [API] [kSphinxSearchManager->execSphinx] ERR: No database selected

2013-01-08 10:06:57 [0.006899] [127.0.0.1] [119937504] [API] [kCoreException->__construct] ERR: Code: [SEARCH_ENGINE_QUERY_FAILED,Search engine query failed] Message: [Invalid sphinx query [SELECT id FROM kaltura_kuser WHERE partner_id = -2 AND kuser_status <> 2 ORDER BY created_at DESC LIMIT 1000 OPTION ranker=none, max_matches=1000, comment='roy-jones[119937504][sphinx]']
2013-01-08 10:06:57 [1520478566] [Infra_FilterPaginator->callService] ERR: Search engine query failed

ps faxu | grep sphinx
root 688 0.0 0.0 4692 1476 ? Ss 09:42 0:00 /bin/bash /opt/kaltura/app/plugins/sphinx_search/scripts/watch.daemon.sh -u root
root 1289 0.0 0.0 9976 1056 ? S 09:42 0:00 /opt/kaltura/bin/sphinx/searchd --config /opt/kaltura/app/configurations/sphinx/kaltura.conf
root 1290 0.0 0.2 16744 4772 ? Sl 09:42 0:00 \_ /opt/kaltura/bin/sphinx/searchd --config /opt/kaltura/app/configurations/sphinx/kaltura.conf
root 10293 0.0 0.0 4192 884 pts/0 S+ 10:09 0:00 \_ grep --color=auto sphinx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

this error in the admin remove:

apache has all the right

sudo chown-R wwwrun: www / opt / Kaltura /

2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [KalturaInternalToolsPluginSystemHelperAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [VirusScanListAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [VirusScanConfigureAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [VirusScanSetStatusAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [DistributionProfileListAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [DistributionProfileConfigureAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [DistributionProfileUpdateStatusAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [GenericDistributionProvidersListAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [GenericDistributionProviderConfigureAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [GenericDistributionProviderDeleteAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [XsltTesterAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [XsltTesterApiAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [DropFolderListAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [DropFolderConfigureAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [DropFolderSetStatusAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [EventNotificationTemplatesListAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [EventNotificationTemplateConfigureAction] requires permissions [Array
2013-01-08 09:59:30 [1684208342] [InfraBootstrapper->_initNavigation] ERR: Class [EventNotificationTemplateUpdateStatusAction] requires permissions [Array

Joined: 12/24/2012
Points: 12

first reg. on kmc console

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

http://kaltura.dyndns.tv/

Joined: 01/05/2009
Points: 1697

**You should note that Kaltura was never tested on SuSE - Things might be very different permissions wise**

Try changing "mysql:host=localhost;port=9312;" to "mysql:host=127.0.0.1;port=9312;" (127.0.0.1 instead of localhost).