starting KMC console fails on CE 6.0.1

10 replies [Last post]
Joined: 01/02/2013
Points: 20

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

Joined: 01/02/2013
Points: 20

attaching log in more readable format

AttachmentSize
sql.txt6.24 KB
Joined: 04/09/2012
Points: 193

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

Joined: 01/02/2013
Points: 20

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).

Joined: 04/09/2012
Points: 193
Quote:
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!

Joined: 04/09/2012
Points: 193

To checkout a version of the code from a back date you can do the following:

cd ~/
git clone -b falcon <a href="https://github.com/kaltura/ce-packager.git
cd"
title="https://github.com/kaltura/ce-packager.git
cd"
>https://github.com/kaltura/ce-packager.git
cd</a> ce-packager

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

Joined: 04/09/2012
Points: 193

argh, I cant post that above without it interpreting the hyperlinks and messing up the text.

Joined: 01/02/2013
Points: 20

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...

Joined: 05/13/2009
Points: 164

You should be using the falcon branch, the falcon-working branch is an in progress development branch, please don't use it.

Joined: 01/02/2013
Points: 20

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.

Joined: 01/05/2009
Points: 1697

thanks for updating m.zajakala.