search

kaltura / server

The Kaltura Platform Backend. To install Kaltura, visit the install packages repository.
https://github.com/kaltura/platform-install-packages
GNU Affero General Public License v3.0
374 stars 174 forks source link

Can't login to admin console #1843

Closed jeansalim closed 9 years ago

jeansalim commented 9 years ago

I'm having this error when logging in to the Admin Console: An error occurred

(error code: Server:INVALID_KS)

Thes is the kaltlog output: [root@backend web]# kaltlog ==> /opt/kaltura/log/kaltura_apache_errors.log <== [Tue Nov 04 19:22:26 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:28:18 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:33:50 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:38:52 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:53:30 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:56:34 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 20:03:57 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list

2014-11-04 20:06:00 [0.000536] [127.0.0.1] [2101607047] [PS2] [sfView->initialize] INFO: {sfView} initialize view for "kmc/kmc" 2014-11-04 20:06:00 [0.000829] [127.0.0.1] [2101607047] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/modules/kmc/templates/kmcSuccess.php" 2014-11-04 20:06:00 [0.000584] [127.0.0.1] [2101607047] [PS2] [sfPHPView->decorate] INFO: {sfView} decorate content with "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php" 2014-11-04 20:06:00 [0.000094] [127.0.0.1] [2101607047] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"

2014-11-04 20:06:00 [0.000460] [127.0.0.1] [2101607047] [PS2] [sfRenderingFilter->execute] INFO: {sfFilter} render to client

2014-11-04 18:53:22 [1205813164] [addPermissionsAndItems.php] [addItemToPermissions] ALERT: exception 'Exception' with message 'ERROR - Permission name [BATCH_BASE] for partner [0] not found in database - skipping!' in /opt/kaltura/app/infra/log/KalturaLog.php:64 Stack trace:

0 /opt/kaltura/app/alpha/scripts/utils/permissions/addPermissionsAndItems.php(280): KalturaLog::alert('ERROR - Permiss...')

I have been uninstalling and reinstalling kaltura for like 5 times now, I'm removing the DB, removing SQL, removing /opt/kaltura, same issue.

This is the third Kaltura CE server I test, each of the installations bumped into different issues and I spent each time around 3-4 days just to install it.

jessp01 commented 9 years ago

Hello,

Please drop the DB again and this time paste the output of the install scripts. It seems like the phase where the DB should be created and populated fails.

May the source be with you,

Jess Portnoy

-------- Original message -------- From: jeansalim notifications@github.com Date: To: kaltura/server server@noreply.github.com Subject: [server] Can't login to admin console (#1843)

I'm having this error when logging in to the Admin Console: An error occurred

(error code: Server:INVALID_KS)

Thes is the kaltlog output: [root@backend web]# kaltlog ==> /opt/kaltura/log/kaltura_apache_errors.log <== [Tue Nov 04 19:22:26 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:28:18 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:33:50 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:38:52 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:53:30 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 19:56:34 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list [Tue Nov 04 20:03:57 2014] [error] [client 10.100.2.34] File does not exist: /opt/kaltura/app/alpha/web/opt, referer: http://backend.nvod.com/admin_console/index.php/partner/list

2014-11-04 20:06:00 [0.000536] [127.0.0.1] [2101607047] [PS2] [sfView->initialize] INFO: {sfView} initialize view for "kmc/kmc" 2014-11-04 20:06:00 [0.000829] [127.0.0.1] [2101607047] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/modules/kmc/templates/kmcSuccess.php" 2014-11-04 20:06:00 [0.000584] [127.0.0.1] [2101607047] [PS2] [sfPHPView->decorate] INFO: {sfView} decorate content with "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php" 2014-11-04 20:06:00 [0.000094] [127.0.0.1] [2101607047] [PS2] [sfPHPView->renderFile] INFO: {sfView} render "/opt/kaltura/app/alpha/apps/kaltura/templates/kmclayout.php"

2014-11-04 20:06:00 [0.000460] [127.0.0.1] [2101607047] [PS2] [sfRenderingFilter->execute] INFO: {sfFilter} render to client

2014-11-04 18:53:22 [1205813164] [addPermissionsAndItems.php] [addItemToPermissions] ALERT: exception 'Exception' with message 'ERROR - Permission name [BATCH_BASE] for partner [0] not found in database - skipping!' in /opt/kaltura/app/infra/log/KalturaLog.php:64 Stack trace:

0 /opt/kaltura/app/alpha/scripts/utils/permissions/addPermissionsAndItems.php(280): KalturaLog::alert('ERROR - Permiss...')

I have been uninstalling and reinstalling kaltura for like 5 times now, I'm removing the DB, removing SQL, removing /opt/kaltura, same issue.

This is the third Kaltura CE server I test, each of the installations bumped into different issues and I spent each time around 3-4 days just to install it.

Reply to this email directly or view it on GitHubhttps://github.com/kaltura/server/issues/1843.

jeansalim commented 9 years ago

I will post it after installing again, but I'm sure I didn't have any error during db creation any of the times I have installed.

KalturaCommunity-zz commented 9 years ago

Please do. Also, would it be possible to access your env?

May the source be with you,

Jess Portnoy

-------- Original message -------- From: jeansalim notifications@github.com Date: To: kaltura/server server@noreply.github.com Subject: Re: [server] Can't login to admin console (#1843)

I will post it after installing again, but I'm sure I didn't have any error during db creation any of the times I have installed.

Reply to this email directly or view it on GitHubhttps://github.com/kaltura/server/issues/1843#issuecomment-61695887.

jeansalim commented 9 years ago

Thanks for your help.

I kaltura installed again on a fresh centos 6.5 installation. Complete format and I followed "Install Kaltura on a single server (RPM)" tutorial

Now I can't access the admin console with a PHP page displaying, I'll paste it in the buttom. Below is the installation log: [root@backend /]# /opt/kaltura/bin/kaltura-config-all.sh Running base config...

kaltura-base-9.19.5-1.noarch Welcome to Kaltura Server 9.19.5 post install setup. To improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded and more stable platform and services. This information helps us understand what problems users encounter when using Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ . By allowing Kaltura to collect data about your installation, we may be able provide more effective assistance in the event that you encounter an installation issue. To allow Kaltura to track and analyze QA and support information, please enter your email. Type NO to disallow:

To keep up with the bi-weekly Kaltura releases, and stay up to date with the latest news, security and bug updates, and connect with the global Kaltura community - sign up for our regular Kaltura Community updates. Please enter your email to sign up, or enter NO to pass.

Registering for the newsletter... this will take a few seconds.

In order to finalize the system configuration, please input the following:

CDN hostname [backend.nvod.com]:

Apache virtual hostname [backend.nvod.com]: Vhost port to listen on [80]: DB hostname [127.0.0.1]: DB port [3306]: MySQL super user [only for install, default root]: root MySQL super user passwd [only for install]: Analytics DB hostname [127.0.0.1]: Analytics DB port [3306]: Sphinx hostname [127.0.0.1]: Media Streaming Server host [backend.nvod.com]: Secondary Sphinx hostname [leave empty if none]:
Service URL [http://backend.nvod.com:80]: Kaltura Admin user (email address): jeansalim@hotmail.com Admin user login password (must be minimum 8 chars and include at least one of each: upper-case, lower-case, number and a special character): Confirm passwd: Your time zone [see http://php.net/date.timezone], or press enter for [Asia/Beirut]: Your Kaltura install name (this name will show as the From field in emails sent by the system) [Kaltura Video Platform]: Your website Contact Us URL [http://corp.kaltura.com/company/contact-us]: Your 'Contact us' phone number [+1 800 871 5224]:

Kaltura install answer file written to /tmp/kaltura_05_11_18_50.ans - Please save it!

This answers file can be used to silently-install re-install this machine or deploy other hosts in your cluster.

Generating client libs... This can take a few minutes to complete, see log at /opt/kaltura/log/generate.php.log.

    Configuration of Kaltura Server 9.19.5 finished successfully!

Running FrontEnd config...

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

kaltura-front-9.19.5-1.noarch It is recommended that you do work using HTTPs. Would you like to continue anyway?[N/y] y Which port will this Vhost listen on? [80]

Please select one of the following options [0]:

  1. All web interfaces
  2. Kaltura Management Console [KMC], Hosted Apps, HTML5 lib and ClipApp
  3. 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_05_11_18_51.ans - Please save it!

This answers file can be used to silently-install re-install this machine or deploy other hosts in your cluster.

Stopping httpd: [ OK ] Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using backend.nvod.com for ServerName [ OK ] Shutting down monit: [FAILED] Starting monit: monit: generated unique Monit id 034dce7e7f2c0bc2a784a55684f9cb27 and stored to '/root/.monit.id' Starting monit daemon with http interface at [*:2812] [ OK ] Running Sphinx config...

kaltura-sphinx-2.2.1-16.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 monit: Starting monit daemon with http interface at [*:2812] [ OK ]

Configuring your Kaltura DB...

Checking MySQL version.. Ver 5.1.73 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:) Cleaning cache.. Populating DB with data.. please wait.. Output for /opt/kaltura/app/deployment/base/scripts/installPlugins.php being logged into /opt/kaltura/log/installPlugins.log Output for /opt/kaltura/app/deployment/base/scripts/insertDefaults.php being logged into /opt/kaltura/log/insertDefaults.log Output for /opt/kaltura/app/deployment/base/scripts/insertPermissions.php being logged into /opt/kaltura/log/insertPermissions.log Output for /opt/kaltura/app/deployment/base/scripts/insertContent.php being logged into /opt/kaltura/log/insertContent.log Generating UI confs.. Shutting down monit: [FAILED] Starting monit: Starting monit daemon with http interface at [*:2812] [ OK ] Running Batch config...

kaltura-batch-9.19.5-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

Reloading httpd: Starting monit: Starting monit daemon with http interface at [*:2812] [ OK ] Running DWH config...

kaltura-dwh-9.4.0-2.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

Deploying analytics warehouse DB, please be patient as this may take a while... Output is logged to /opt/kaltura/dwh/logs/dwh_setup.log.

sending incremental file list MySQLInserter/ MySQLInserter/TOP.png MySQLInserter/mysqlinserter.jar MySQLInserter/plugin.xml

sent 2646992 bytes received 73 bytes 5294130.00 bytes/sec total size is 2646419 speedup is 1.00 sending incremental file list MappingFieldRunner/ MappingFieldRunner/MAP.png MappingFieldRunner/mappingfieldrunner.jar MappingFieldRunner/plugin.xml

sent 90941 bytes received 73 bytes 182028.00 bytes/sec total size is 90670 speedup is 1.00 sending incremental file list GetFTPFileNames/ GetFTPFileNames/FTP.png GetFTPFileNames/getftpfilenames.jar GetFTPFileNames/plugin.xml

sent 7310038 bytes received 73 bytes 14620222.00 bytes/sec total size is 7308893 speedup is 1.00 sending incremental file list FetchFTPFile/ FetchFTPFile/FTP.png FetchFTPFile/fetchftpfile.jar FetchFTPFile/plugin.xml

sent 5784074 bytes received 73 bytes 11568294.00 bytes/sec total size is 5783119 speedup is 1.00 sending incremental file list DimLookup/ DimLookup/CMB.png DimLookup/lookup.jar DimLookup/plugin.xml

sent 3688658 bytes received 73 bytes 7377462.00 bytes/sec total size is 3687964 speedup is 1.00 sending incremental file list UserAgentUtils.jar ksDecrypt.jar

sent 34936 bytes received 50 bytes 69972.00 bytes/sec total size is 34770 speedup is 0.99 current version 5999 DWH configured.

Setup completed successfully!

To access your Kaltura tools visit: http://backend.nvod.com:80

To begin, access the Admin Console using the Admin email and password you've entered while installing. When logged in to the KAC, create a new publisher account to being using Kaltura. Visit http://www.kaltura.org to join the community and get help!

Visit http://knowledge.kaltura.com to read documentation and learn more.

Thank you for running Kaltura! To keep Kaltura viable, stable and tested, please join the community and help by contributing sanity tests that verify overall platform stability: http://bit.ly/kaltura-ci , and by contributing to the project roadmap by solving simple tasks and challenges: http://bit.ly/kaltura-tasks.

Error when opening admin console: <?php

// Define path to application directory defined('APPLICATION_PATH') || define('APPLICATION_PATH', realpath(dirname(FILE) . '/../'));

defined('UI_INFRA_PATH') || define('UI_INFRA_PATH', realpath(dirname(FILE) . '/../../ui_infra'));

// Define application environment defined('APPLICATION_ENV') || define('APPLICATION_ENV', (getenv('APPLICATION_ENV') ? getenv('APPLICATION_ENV') : 'development'));

// Ensure library/ is on include_path set_include_path(implode(PATH_SEPARATOR, array( realpath(APPLICATION_PATH . '/../vendor/ZendFramework/library'), get_include_path(), )));

/* Zend_Application / require_once 'Zend/Application.php';

$configPath = realpath(APPLICATION_PATH . '/../configurations/admin.ini'); if(!file_exists($configPath)) { $configTemplatePath = realpath(APPLICATION_PATH . '/../configurations/admin.template.ini'); $msg = "Please rename template file [$configTemplatePath] to admin.ini and replace the tokens"; error_log($msg); die($msg); }

// Create application, bootstrap, and run $application = new Zend_Application( APPLICATION_ENV, $configPath ); $application->bootstrap() ->run(

jeansalim commented 9 years ago

Hi Jess,

It was from the browser cache. Now it's working.

jeansalim commented 9 years ago

But I can't access the KMC, it seems it's redirecting me to port 443 while I have a non-ssl port 80 configration.

Here's the error: Not Found

The requested URL /index.php/kmc/kmc4 was not found on this server.

Apache/2.2.15 (CentOS) Server at backend.nvod.com Port 443

KalturaCommunity-zz commented 9 years ago

Hello,

Indeed, the install seem to have passed perfectly fine here. Can you please check: mysql> select * from permission WHERE permission.NAME='FEATURE_KMC_ENFORCE_HTTPS';

Thanks,

May the source be with you,

Jess Portnoy

Watch the video recordings from Kaltura Connect 2014, and pre-register for 2015 - http://connect.kaltura.com/

On Wed, 5 Nov 2014, jeansalim wrote:

But I can't access the KMC, it seems it's redirecting me to port 443 while I have a non-ssl port 80 configration.

Here's the error: Not Found

The requested URL /index.php/kmc/kmc4 was not found on this server.

Apache/2.2.15 (CentOS) Server at backend.nvod.com Port 443

— Reply to this email directly or view it on GitHub.[ACH7XhKoVJMsuy2_c59Yey_zOJdgpAXZks5nKlXdgaJpZM4C254P.gif]

jeansalim commented 9 years ago

mysql> select * from permission WHERE permission.NAME='FEATURE_KMC_ENFORCE_HTTPS'; +-----+------+---------------------------+-----------------+-------------+------------+--------+-----------------------------+------+---------------------+---------------------+------------------------------------+ | id | type | name | friendly_name | description | partner_id | status | depends_on_permission_names | tags | created_at | updated_at | custom_data | +-----+------+---------------------------+-----------------+-------------+------------+--------+-----------------------------+------+---------------------+---------------------+------------------------------------+ | 242 | 2 | FEATURE_KMC_ENFORCE_HTTPS | Force KMC HTTPS | | 0 | 1 | | | 2014-11-05 18:54:07 | 2014-11-05 18:54:07 | a:1:{s:13:"partner_group";s:0:"";} | +-----+------+---------------------------+-----------------+-------------+------------+--------+-----------------------------+------+---------------------+---------------------+------------------------------------+ 1 row in set (0.00 sec)

KalturaCommunity-zz commented 9 years ago

Can you please update the status to 3 and recheck? Thanks,

May the source be with you,

Jess Portnoy

Watch the video recordings from Kaltura Connect 2014, and pre-register for 2015 - http://connect.kaltura.com/

On Wed, 5 Nov 2014, jeansalim wrote:

mysql> select * from permission WHERE permission.NAME='FEATURE_KMC_ENFORCE_HTTPS'; +-----+------+---------------------------+-----------------+-------------+------------+--------+-----------------------------+--- ---+---------------------+---------------------+------------------------------------+ | id | type | name | friendly_name | description | partner_id | status | depends_on_permission_names | tags | created_at | updated_at | custom_data | +-----+------+---------------------------+-----------------+-------------+------------+--------+-----------------------------+--- ---+---------------------+---------------------+------------------------------------+ | 242 | 2 | FEATURE_KMC_ENFORCE_HTTPS | Force KMC HTTPS | | 0 | 1 | | | 2014-11-05 18:54:07 | 2014-11-05 18:54:07 | a:1:{s:13:"partner_group";s:0:"";} | +-----+------+---------------------------+-----------------+-------------+------------+--------+-----------------------------+--- ---+---------------------+---------------------+------------------------------------+ 1 row in set (0.00 sec)

— Reply to this email directly or view it on GitHub.[ACH7XnIbqkp7qAViS6GHPSpDRKrAJnF6ks5nKl4agaJpZM4C254P.gif]

jeansalim commented 9 years ago

It worked, thanks a lot.

I still have an issue I faced before with this Kaltura version when editing the players list, it's related to uiconf

Player 23448177 not loaded. The player definition file is corrupted. Please review and revise the player UIconf, or contact support for assistance.

jessp01 commented 9 years ago

Hello,

Would accessing you ENV be possible? Thanks

May the source be with you,

Jess Portnoy

-------- Original message -------- From: jeansalim notifications@github.com Date: To: kaltura/server server@noreply.github.com Cc: Jess Portnoy jess.portnoy@kaltura.com Subject: Re: [server] Can't login to admin console (#1843)

It worked, thanks a lot.

I still have an issue I faced before with this Kaltura version when editing the players list, it's related to uiconf

Player 23448177 not loaded. The player definition file is corrupted. Please review and revise the player UIconf, or contact support for assistance.

Reply to this email directly or view it on GitHubhttps://github.com/kaltura/server/issues/1843#issuecomment-61854586.

jeansalim commented 9 years ago

Yes, of course

jessp01 commented 9 years ago

Can you please send me the creds to jess.portnoy@kaltura.com? Please create a dedicated user for this and make it a sudoer, I would rather not have your root passwd.

Thanks,

jeansalim commented 9 years ago

It's ok. I created new players and it worked

KalturaCommunity-zz commented 9 years ago

This is good news. Can we close the issue then?

May the source be with you,

Jess Portnoy

Watch the video recordings from Kaltura Connect 2014, and pre-register for 2015 - http://connect.kaltura.com/

On Thu, 6 Nov 2014, jeansalim wrote:

It's ok. I created new players and it worked

— Reply to this email directly or view it on GitHub.[ACH7Xq2s7z1w5apKE-z9LanxMQsLKc14ks5nK5pLgaJpZM4C254P.gif]

jeansalim commented 9 years ago

Thanks a lot for your help

KalturaCommunity-zz commented 9 years ago

Most welcome.

May the source be with you,

Jess Portnoy

Watch the video recordings from Kaltura Connect 2014, and pre-register for 2015 - http://connect.kaltura.com/

On Thu, 6 Nov 2014, jeansalim wrote:

Thanks a lot for your help

— Reply to this email directly or view it on GitHub.[ACH7XjdkkDoKOHMoochcQmeB6k6VooCbks5nK5yogaJpZM4C254P.gif]