Copyright © 2012 Kaltura Inc.
All Rights Reserved. Designated trademarks and brands are the property of their respective owners.
Use of this web site constitutes acceptance of the Terms of Use and Privacy Policy.
EduVideo.org
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
| Attachment | Size |
|---|---|
| error.txt | 31.91 KB |
Just for the test - try running:
sudo chown apache:apache /opt/kaltura
change apache to whatever is the apache user name on your system
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!
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
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:
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
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]']
Did you check the hostname and credentials on /opt/kaltura/app/configurations/db.ini ?
Also - please verify that SELinux is permissive or disabled.
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:
.....
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
first reg. on kmc console
Oops! An Error Occurred
The server returned a "500 Internal Server Error".
**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).
it looks like Apache doesn't have access to /opt/kaltura ?