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
After installation on RHEL 6.3 from github sources (branch: falcon-working, cloned Jan 3rd 2013) after navigating to:
/index.php/kmc/kmc2
I get "500 Internal Server Error". It is caused by failed SQL query:
2013-01-04 12:55:41 [0.013416] [192.168.140.3] [273675362] [PS2] [sfContext->initialize] INFO: {sfContext} initialization
2013-01-04 12:55:41 [0.000423] [192.168.140.3] [273675362] [PS2] [sfController->initialize] INFO: {sfController} initialization
2013-01-04 12:55:41 [0.000898] [192.168.140.3] [273675362] [PS2] [sfRouting->parse] INFO: {sfRouting} match route [kmc] "/kmc"
2013-01-04 12:55:41 [0.000188] [192.168.140.3] [273675362] [PS2] [sfWebRequest->loadParameters] INFO: {sfRequest} request parameters array ( 'module' => 'kmc', 'action' => 'kmc',)
2013-01-04 12:55:41 [0.000237] [192.168.140.3] [273675362] [PS2] [sfFrontWebController->dispatch] INFO: {sfController} dispatch request
2013-01-04 12:55:41 [0.001042] [192.168.140.3] [273675362] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfRenderingFilter"
2013-01-04 12:55:41 [0.000153] [192.168.140.3] [273675362] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "myHealthCheckAndSecurityFilter"
2013-01-04 12:55:41 [0.000448] [192.168.140.3] [273675362] [PS2] [myHealthCheckAndSecurityFilter->basicSecureRequest] WARN: basicSecureRequest: took [0.00026321411132812] seconds
2013-01-04 12:55:41 [0.000162] [192.168.140.3] [273675362] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfCommonFilter"
2013-01-04 12:55:41 [0.000144] [192.168.140.3] [273675362] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfFlashFilter"
2013-01-04 12:55:41 [0.000154] [192.168.140.3] [273675362] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfExecutionFilter"
2013-01-04 12:55:41 [0.000524] [192.168.140.3] [273675362] [PS2] [sfView->initialize] INFO: {sfView} initialize view for "kmc/kmc"
2013-01-04 12:55:41 [0.000584] [192.168.140.3] [273675362] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/modules/kmc/templates/kmcSuccess.php"
2013-01-04 12:55:41 [0.001274] [192.168.140.3] [273675362] [PS2] [sfPHPView->decorate] INFO: {sfView} decorate content with "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2013-01-04 12:55:41 [0.000174] [192.168.140.3] [273675362] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"
2013-01-04 12:55:41 [0.000611] [192.168.140.3] [273675362] [PS2] [sfRenderingFilter->execute] INFO: {sfFilter} render to client
2013-01-04 12:55:41 [0.000220] [192.168.140.3] [273675362] [PS2] [sfWebResponse->sendHttpHeaders] INFO: {sfResponse} send status "HTTP/1.0 200 OK"
2013-01-04 12:55:41 [0.000147] [192.168.140.3] [273675362] [PS2] [sfWebResponse->sendHttpHeaders] INFO: {sfResponse} send header "Content-Type": "text/html; charset=utf-8"
2013-01-04 12:55:41 [0.000136] [192.168.140.3] [273675362] [PS2] [sfResponse->sendContent] INFO: {sfResponse} send content (3419 o)
2013-01-04 12:55:42 [0.010282] [192.168.140.3] [1232164530] [PS2] [sfContext->initialize] INFO: {sfContext} initialization
2013-01-04 12:55:42 [0.000376] [192.168.140.3] [1232164530] [PS2] [sfController->initialize] INFO: {sfController} initialization
2013-01-04 12:55:42 [0.000359] [192.168.140.3] [1232164530] [PS2] [sfRouting->parse] INFO: {sfRouting} match route [default] "/:module/:action/*"
2013-01-04 12:55:42 [0.000167] [192.168.140.3] [1232164530] [PS2] [sfWebRequest->loadParameters] INFO: {sfRequest} request parameters array ( 'module' => 'kmc', 'action' => 'kmc2',)
2013-01-04 12:55:42 [0.000215] [192.168.140.3] [1232164530] [PS2] [sfFrontWebController->dispatch] INFO: {sfController} dispatch request
2013-01-04 12:55:42 [0.000951] [192.168.140.3] [1232164530] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfRenderingFilter"
2013-01-04 12:55:42 [0.000157] [192.168.140.3] [1232164530] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "myHealthCheckAndSecurityFilter"
2013-01-04 12:55:42 [0.000419] [192.168.140.3] [1232164530] [PS2] [myHealthCheckAndSecurityFilter->basicSecureRequest] WARN: basicSecureRequest: took [0.00022602081298828] seconds
2013-01-04 12:55:42 [0.000214] [192.168.140.3] [1232164530] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfCommonFilter"
2013-01-04 12:55:42 [0.000149] [192.168.140.3] [1232164530] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfFlashFilter"
2013-01-04 12:55:42 [0.000153] [192.168.140.3] [1232164530] [PS2] [sfFilterChain->execute] INFO: {sfFilter} executing filter "sfExecutionFilter"
2013-01-04 12:55:42 [0.003112] [192.168.140.3] [1232164530] [PS2] [KalturaPDO->__construct] DEBUG: conn took - 0.0004889965057373 seconds to mysql:host=127.0.0.1;port=3306;dbname=kaltura;user=root;password=;
2013-01-04 12:55:42 [0.000499] [192.168.140.3] [1232164530] [PS2] [Propel::initConnection] NOTICE: total conn took 0.00097393989562988 mysql:host=127.0.0.1;port=3306;dbname=kaltura;user=root;password=;
2013-01-04 12:55:42 [0.001795] [192.168.140.3] [1232164530] [PS2] [KalturaStatement->execute] DEBUG: /* kaltura.evionet.pl[1232164530][propel] */ SELECT ui_conf.ID, ui_conf.OBJ_TYPE, ui_conf.PARTNER_ID, ui_conf.SUBP_ID, ui_conf.CONF_FILE_PATH, ui_conf.NAME, ui_conf.WIDTH, ui_conf.HEIGHT, ui_conf.HTML_PARAMS, ui_conf.SWF_URL, ui_conf.CREATED_AT, ui_conf.UPDATED_AT, ui_conf.CONF_VARS, ui_conf.USE_CDN, ui_conf.TAGS, ui_conf.CUSTOM_DATA, ui_conf.STATUS, ui_conf.DESCRIPTION, ui_conf.DISPLAY_IN_SEARCH, ui_conf.CREATION_MODE, ui_conf.VERSION, ui_conf.HTML5_URL FROM `ui_conf` WHERE (ui_conf.PARTNER_ID IS NULL OR ((ui_conf.DISPLAY_IN_SEARCH>='2' AND ui_conf.PARTNER_ID='0') AND ui_conf.SWF_URL LIKE '%/kdp3/%kdp3.swf')) AND ui_conf.OBJ_TYPE IN ('1','8') AND (ui_conf.STATUS='2' AND ui_conf.STATUS<>'3') AND (ui_conf.TAGS LIKE '%playlist%' AND ui_conf.TAGS NOT LIKE '%jwplaylist%') AND ui_conf.ID NOT IN ('48120','48121','48130','48131','48132','48133','48134','48135') ORDER BY (ui_conf.PARTNER_ID=) ASC,ui_conf.CREATED_AT DESC
2013-01-04 12:55:42 [0.000744] [192.168.140.3] [1232164530] [PS2] [BasePeer::doSelect] ERR: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ASC,ui_conf.CREATED_AT DESC' at line 1
2013-01-04 12:55:42 [0.000507] [192.168.140.3] [1232164530] [PS2] [sfException->__construct] ERR: {sfException}
Suspicious part of SQL query is: ORDER BY (ui_conf.PARTNER_ID=). Installation went without problems.
I do realize that using latest sources to build the deployment may be prone to such errors, but this leads to the following questions:
1) is there any supported stable branch / tag that could be used for evaluation? I could make do even with specific commit number, just any snapshot in development history that I could use to get the product running...
2) what is the meaning of the version number 6.0.1 used when packaging sources? Is there any "newer" version? Which should I use? I missed that info in installation tutorials.
I understand that CE is open source and community driven edition of Kaltura product and comes without tech support, but honestly - just having one stable tag in git repository that can be used out-of-the-box would make a huge difference for evaluators. So far this has been a little discouraging....
Appreciate any ideas / help.
Thanks
Mat
Didn't review logs but after install according to instructions (and after each reboot) I had to manually start some servers:
sudo pkill searchd >> then quickly
sudo /opt/kaltura/bin/sphinx/searchd -c /opt/kaltura/app/configurations/sphinx/kaltura.conf
sudo /opt/kaltura/app/scripts/serviceBatchMgr.sh start
sudo /etc/init.d/memcached start
Seems that memcached did not start automatically (I saw warnings in log files) - but other services were already running.
[mzajakala@kaltura ~]$ sudo pkill searchd [mzajakala@kaltura ~]$ sudo /opt/kaltura/bin/sphinx/searchd -c /opt/kaltura/app/configurations/sphinx/kaltura.conf Sphinx 2.0.4-release (r3135) Copyright (c) 2001-2012, Andrew Aksyonoff Copyright (c) 2008-2012, Sphinx Technologies Inc (<a href="http://sphinxsearch.com" title="http://sphinxsearch.com">http://sphinxsearch.com</a>) using config file '/opt/kaltura/app/configurations/sphinx/kaltura.conf'... WARNING: compat_sphinxql_magics=1 is deprecated; please update your application and config FATAL: failed to lock pid file '/opt/kaltura/sphinx/searchd.pid': Resource temporarily unavailable (searchd already running?) [mzajakala@kaltura ~]$ [mzajakala@kaltura ~]$ sudo /opt/kaltura/app/scripts/serviceBatchMgr.sh start Starting:[FAILED] Service KGenericBatchMgr.class already running [mzajakala@kaltura ~]$ [mzajakala@kaltura ~]$ sudo /etc/init.d/memcached start Starting memcached: [ OK ]
Anyway - going to /index.php/kmc/kmc2 still causes error (SQL query syntax).
Starting KMC from admin console -> publisher -> manager allows me to use KMC for that publisher (but then KMC base address in browser is /index.php/kmc/kmc4 - I don't know the difference between kmc2 and kmc4).
I understand that CE is open source and community driven edition of Kaltura product and comes without tech support, but honestly - just having one stable tag in git repository that can be used out-of-the-box would make a huge difference for evaluators. So far this has been a little discouraging....
Halleluiah Brother!
This is crazy!
To checkout a version of the code from a back date you can do the following:
cd git-repositories
git clone -b falcon <a href="https://github.com/kaltura/KalturaServer.git
git" title="https://github.com/kaltura/KalturaServer.git
git">https://github.com/kaltura/KalturaServer.git
git</a> clone <a href="https://github.com/kaltura/ce-binaries.git
git" title="https://github.com/kaltura/ce-binaries.git
git">https://github.com/kaltura/ce-binaries.git
git</a> clone <a href="https://github.com/kaltura/ce-branding.git
git" title="https://github.com/kaltura/ce-branding.git
git">https://github.com/kaltura/ce-branding.git
git</a> clone <a href="https://github.com/kaltura/ce-configurations.git
git" title="https://github.com/kaltura/ce-configurations.git
git">https://github.com/kaltura/ce-configurations.git
git</a> clone <a href="https://github.com/kaltura/ce-dwh.git
git" title="https://github.com/kaltura/ce-dwh.git
git">https://github.com/kaltura/ce-dwh.git
git</a> clone <a href="https://github.com/kaltura/ce-uiconfs.git
cd" title="https://github.com/kaltura/ce-uiconfs.git
cd">https://github.com/kaltura/ce-uiconfs.git
cd</a> KalturaServer
git checkout `git rev-list -n 1 --before="2012-12-19" falcon`
cd ../ce-binaries
git checkout `git rev-list -n 1 --before="2012-12-19" master`
cd ../ce-branding
git checkout `git rev-list -n 1 --before="2012-12-19" master`
cd ../ce-configurations
git checkout `git rev-list -n 1 --before="2012-12-19" master`
cd ../ce-dwh
git checkout `git rev-list -n 1 --before="2012-12-19" master`
cd ../ce-uiconfs
git checkout `git rev-list -n 1 --before="2012-12-19" master`
cd ../..
git checkout `git rev-list -n 1 --before="2012-12-19" falcon`
cd packaging
php package.php /home/<your_home_directory>/kaltura-installer false CE v6.0.1 dev
cd ~/kaltura-installer
sudo php install.php
argh, I cant post that above without it interpreting the hyperlinks and messing up the text.
That's ok, I get what you mean... Just wondering if you were able to get KMC to run successfully on snapshot "before-2012-12-19". I am currently on "falcon-working" branch - which does not contain commits after 2012-12-19 (messing up SQL), but still have problems with KMC described above...
You should be using the falcon branch, the falcon-working branch is an in progress development branch, please don't use it.
I switched to falcon branch and after latest fixes I managed to get the KMC running. Installation process also goes smoothly now.
Thanks for help.
thanks for updating m.zajakala.
attaching log in more readable format