Need to add an Administrator from mysql command line


#1

Hello,
We are running Kaltura CE 10.16.0 in production. The one and only administrator left his position, and I am now responsible for Kaltura. I need to log on to the admin console to install a commercial certificate (among other things). Nobody in the entire enterprise has an account with administrator privilege with which to log on to the admin console.

As I see it, I can use mysql to directly add a user or I could possibly change the former administrator’s password.

I can log on as root, then…
mysql> use kaltura;
mysql> select screen_name, first_name, last_name, email, partner_id from kuser
mysql> select login_email, first_name , last_name, config_partner_id from user_login_data;

I can see all the users. I understand that partner_id -2 is the Kaltura Administrator, "john@domain.com".

I need to create a new user who has the partner ID “-2”, or Admin Console associated with him.

Since I cannot log on to the Admin Console, can I change the value for sha1_password for the former administrator, or can I create a new user who is associated with partner ID -2 from the mysql prompt?


#2

Hello @mpowell

Following article may help your issue:

Especially the second half of that page will be useful.
Sample password value for the MySQL is described.

Regards


#3

Hi @mpowell,

Indeed, the link @t-saito shared will allow you to reset the Admin Console user’s passwd by making SQL update statements.
If you’re interested in gaining a deeper understanding into the authentication, authorisation and privileges mechanisms, please see my reply here:

Thanks,


#4

Thank you, @tsaito. I did try the solution in the support article.

First (sanitizing e-mail address),

mysql> select * from user_login_data where login_email=‘user@domain.com’\G

Then,

mysql> update user_login_data set sha1_password=‘44e8c1db328d6d2f64de30a8285fb2a1c9337edb’ where login_email=‘user@domain.com’;

mysql> update user_login_data set salt=‘a6a3209b8827759fa4286d87a33f99df’ where login_email=‘user@domain.com’;

Then, I confirmed that the correct values were present.

mysql> select * from user_login_data where login_email=‘user@domain.com’\G
*************************** 1. row ***************************
id: 1
login_email: user@domain.com
first_name: Kaltura
last_name: Administrator
sha1_password: 44e8c1db328d6d2f64de30a8285fb2a1c9337edb
salt: a6a3209b8827759fa4286d87a33f99df
config_partner_id: -2

Finally, I browsed to the Admin Console at…

https://kaltura.domain.com/admin_console/index.php/user/login

The e-mail address with the password “admin123!” (without the quotes) didn’t work - “Invalid credentials provided”.

Could you give me a second set of eyes and see if everything looks OK?

Thank you,
mpowell


#5

Hi, @mpowell

I’m sorry.
I don’t have a solution of “invalid credentials provided” issue.
However, similar issues have been reported in this forum before.
So that, you may be able to get helpful advices from someone, if you post error logs when trying to log-in to your admin console.

For example, you can get error logs by using the following command.

# kaltlog

Regards


#6

Hello, @t-saito,

I ran kaltlog while repeatedly offering the credentials for the Kaltura Administrator. Below is the dump of entries logged during that time. There are additional errors which I can’t expect you to troubleshoot, such as internal server errors that seem to have started when we took the server out from behind an F5 load balancer. Those issues may also be reflected in the log entries below.
Thanks in advance to you and forum members for your help.

thrown in /opt/kaltura/app/vendor/propel/Propel.php on line 529
PHP Fatal error: Uncaught exception ‘PropelException’ with message ‘No connection information in your runtime configuration file for datasource [sphinx_log_read]’ in /opt/kaltura/app/vendor/propel/Propel.php:529
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/myDbHelper.class.php(30): Propel::getConnection(‘sphinx_log_read’)

thrown in /opt/kaltura/app/batch/client/KalturaClientBase.php on line 362
PHP Fatal error: Uncaught exception ‘KalturaClientException’ with message ‘couldn’t connect to host’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:362
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaClient.php(1309): KalturaClientBase->doQueue()

==> /opt/kaltura/log/batch/jobsuspender-0-2018-07-11.err.log <==
PHP Fatal error: Uncaught exception ‘KalturaClientException’ with message ‘couldn’t connect to host’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:362
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaClient.php(1144): KalturaClientBase->doQueue()

==> /opt/kaltura/log/batch/partnerloadcleanup-0-2018-07-11.err.log <==
PHP Fatal error: Uncaught exception ‘KalturaClientException’ with message ‘couldn’t connect to host’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:362
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaClient.php(1127): KalturaClientBase->doQueue()

thrown in /opt/kaltura/app/batch/client/KalturaClientBase.php on line 768
PHP Fatal error: Uncaught exception ‘KalturaException’ with message ‘Internal server error occurred’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:768
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaPlugins/KalturaContentDistributionClientPlugin.php(2785): KalturaClientBase->throwExceptionIfError(Array)

thrown in /opt/kaltura/app/batch/client/KalturaClientBase.php on line 768
PHP Fatal error: Uncaught exception ‘KalturaException’ with message ‘Internal server error occurred’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:768
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaPlugins/KalturaContentDistributionClientPlugin.php(2785): KalturaClientBase->throwExceptionIfError(Array)

thrown in /opt/kaltura/app/batch/client/KalturaClientBase.php on line 768
PHP Fatal error: Uncaught exception ‘KalturaException’ with message ‘Internal server error occurred’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:768
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaPlugins/KalturaContentDistributionClientPlugin.php(2785): KalturaClientBase->throwExceptionIfError(Array)

thrown in /opt/kaltura/app/batch/client/KalturaClientBase.php on line 768
PHP Fatal error: Uncaught exception ‘KalturaException’ with message ‘Internal server error occurred’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:768
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaClient.php(4176): KalturaClientBase->throwExceptionIfError(Array)

thrown in /opt/kaltura/app/batch/client/KalturaClientBase.php on line 768
PHP Fatal error: Uncaught exception ‘KalturaException’ with message ‘Internal server error occurred’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:768
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaClient.php(4176): KalturaClientBase->throwExceptionIfError(Array)

thrown in /opt/kaltura/app/batch/client/KalturaClientBase.php on line 768
PHP Fatal error: Uncaught exception ‘KalturaException’ with message ‘Internal server error occurred’ in /opt/kaltura/app/batch/client/KalturaClientBase.php:768
Stack trace:
#0 /opt/kaltura/app/batch/client/KalturaClient.php(4176): KalturaClientBase->throwExceptionIfError(Array)

2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] DEBUG: Loading plugin[eventNotification]
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [KalturaInternalToolsPluginSystemHelperAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [KalturaI…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanSetStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileUpdateStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProvidersListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProviderConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProviderDeleteAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [XsltTesterAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [XsltTest…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [XsltTesterApiAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [XsltTest…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderSetStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplatesListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2018-07-12 10:41:49 [1798419163] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateUpdateStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

2018-07-12 10:41:49 [0.000125] [127.0.0.1] [1413671025] [API] [DbManager::getSphinxConnection] DEBUG: getSphinxConnection: Failed to connect to any Sphinx config
2018-07-12 10:41:49 [0.000166] [127.0.0.1] [1413671025] [API] [KalturaFrontController->getExceptionObject] CRIT: exception ‘Exception’ with message ‘Failed to connect to any Sphinx config’ in /opt/kaltura/app/alpha/apps/kaltura/lib/db/DbManager.php:221
Stack trace:
#0 /opt/kaltura/app/plugins/sphinx_search/lib/kSphinxSearchManager.php(441): DbManager::getSphinxConnection(false)

2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] DEBUG: Loading plugin[eventNotification]
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [KalturaInternalToolsPluginSystemHelperAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [KalturaI…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanSetStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileUpdateStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProvidersListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProviderConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProviderDeleteAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [XsltTesterAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [XsltTest…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [XsltTesterApiAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [XsltTest…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderSetStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplatesListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2018-07-12 10:41:52 [2047329440] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateUpdateStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

2018-07-12 10:41:52 [0.000108] [127.0.0.1] [854551477] [API] [DbManager::getSphinxConnection] DEBUG: getSphinxConnection: Failed to connect to any Sphinx config
2018-07-12 10:41:52 [0.000170] [127.0.0.1] [854551477] [API] [KalturaFrontController->getExceptionObject] CRIT: exception ‘Exception’ with message ‘Failed to connect to any Sphinx config’ in /opt/kaltura/app/alpha/apps/kaltura/lib/db/DbManager.php:221
Stack trace:
#0 /opt/kaltura/app/plugins/sphinx_search/lib/kSphinxSearchManager.php(441): DbManager::getSphinxConnection(false)

2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] DEBUG: Loading plugin[eventNotification]
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [KalturaInternalToolsPluginSystemHelperAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [KalturaI…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [VirusScanSetStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [VirusSca…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DistributionProfileUpdateStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [Distribu…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProvidersListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProviderConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [GenericDistributionProviderDeleteAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [GenericD…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [XsltTesterAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [XsltTest…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [XsltTesterApiAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [XsltTest…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [DropFolderSetStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [DropFold…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplatesListAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateConfigureAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

#6 {main}
2018-07-12 10:41:54 [986324980] [InfraBootstrapper->_initNavigation] ERR: exception ‘Exception’ with message 'Class [EventNotificationTemplateUpdateStatusAction] requires permissions [Array
(

]’ in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/ui_infra/InfraBootstrapper.php(113): KalturaLog::err(‘Class [EventNot…’)

2018-07-12 10:41:54 [0.000116] [127.0.0.1] [222240750] [API] [DbManager::getSphinxConnection] DEBUG: getSphinxConnection: Failed to connect to any Sphinx config
2018-07-12 10:41:54 [0.000168] [127.0.0.1] [222240750] [API] [KalturaFrontController->getExceptionObject] CRIT: exception ‘Exception’ with message ‘Failed to connect to any Sphinx config’ in /opt/kaltura/app/alpha/apps/kaltura/lib/db/DbManager.php:221
Stack trace:
#0 /opt/kaltura/app/plugins/sphinx_search/lib/kSphinxSearchManager.php(441): DbManager::getSphinxConnection(false)
^C


#7

Hi @mpowell,

From the log entries you’ve posted, it’s clear that the code fails to establish a connection to both MySQL and Sphinx.
Please check the directives in /opt/kaltura/app/configurations/db.ini and ensure the DSN is correctly set for all of them [there are multiple directives as the server is capable of working against multiple MySQL DBs in a master-slave[s] set-up and then there are separate directives for Sphinx and the DWH DB].

Also, ensure that both MySQL and Sphinx are running and that you can connect to them using an interactively shell.
If you need to edit /opt/kaltura/app/configurations/db.ini, be sure to reload Apache after doing so.


#8

Thank you, @jess. I just checked MySQL and Sphinx. mysqld is running. However, Sphinx dies right after starting.

[root@kaltura2 bin]# /etc/init.d/kaltura-sphinx status
searchd is stopped
[root@kaltura2 bin]# /etc/init.d/kaltura-sphinx start
Starting searchd: Sphinx 2.2.1-id64-dev (r4097)
Copyright © 2001-2013, Andrew Aksyonoff
Copyright © 2008-2013, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file ‘/opt/kaltura/app/configurations/sphinx/kaltura.conf’…
listening on all interfaces, port=9312
WARNING: index ‘kaltura_base’: no fields configured (use rt_field directive) - NOT SERVING
WARNING: index ‘kaltura_kuser_base’: no fields configured (use rt_field directive) - NOT SERVING
precaching index ‘kaltura_entry’
precaching index ‘kaltura_category’
precaching index ‘kaltura_kuser’
precaching index ‘kaltura_category_kuser’
precaching index ‘kaltura_cue_point’
precaching index ‘kaltura_entry_distribution’
precaching index ‘kaltura_caption_item’
precaching index ‘kaltura_tag’
precaching index ‘kaltura_metadata’
precached 9 indexes in 0.097 sec

[root@kaltura2 bin]# /etc/init.d/kaltura-sphinx status
searchd is stopped


#9

Check the logs for errors: /opt/kaltura/log/sphinx/kaltura_sphinx_*log
Depending on the root cause, you may want to attempt to reindex the Sphinx DBs. That can be accomplished by executing:

# /opt/kaltura/bin/kaltura-sphinx-reindex.sh

#10

Hello, @jess. Something that has been getting logged since last November is a failure to open a binlog file.

/opt/kaltura/log/sphinx/kaltura_sphinx_searchd.log:[Wed Nov 1 16:51:13.308 2017] [ 1644] WARNING: binlog: replay error at pos=47302678)
/opt/kaltura/log/sphinx/kaltura_sphinx_searchd.log:[Tue Nov 14 08:56:09.523 2017] [ 1642] FATAL: binlog: log open error: failed to open /opt/kaltura/log/sphinx/data/binlog.001: No such
file or directory

There are occasional binlog replay errors:

/opt/kaltura/log/sphinx/kaltura_sphinx_searchd.log:[Wed Jan 3 11:51:40.959 2018] [ 1687] WARNING: binlog: replay error at pos=15584534)
/opt/kaltura/log/sphinx/kaltura_sphinx_searchd.log:[Mon Jan 22 22:53:33.162 2018] [ 1668] WARNING: binlog: replay error at pos=5237622)

However, 99.9% of the errors have to do with binlog.001 or binlog.003.

/opt/kaltura/log/sphinx/kaltura_sphinx_searchd.log:[Thu Jul 12 15:56:39.369 2018] [20691] FATAL: binlog: log open error: failed to open /opt/kaltura/log/sphinx/data/binlog.001: No such file or directory
/opt/kaltura/log/sphinx/kaltura_sphinx_searchd.log:[Thu Jul 12 15:57:49.759 2018] [20774] FATAL: binlog: log open error: failed to open /opt/kaltura/log/sphinx/data/binlog.001: No such file or directory

Only binlog-002 exists.

[root@kaltura2 bin]# ls -lrt /opt/kaltura/log/sphinx/data
total 6124
-rw------- 1 kaltura kaltura 6264845 Jun 21 13:15 binlog.002
-rw------- 1 kaltura kaltura 12 Jun 23 07:31 binlog.meta
-rw------- 1 kaltura kaltura 0 Jul 12 16:00 binlog.lock
[root@kaltura2 bin]# file /opt/kaltura/log/sphinx/data/binlog.002
/opt/kaltura/log/sphinx/data/binlog.002: data


#11

Run:

#  /opt/kaltura/bin/kaltura-sphinx-reindex.sh

Should sort things out.


#12

Thank you so much, @jess. I’ve been at this job for a month now, and am still learning. It seems the above problem has existed for a long time. I guess I’d better get to work and learn more about Kaltura. For now, Sphinx is running and no more errors are being logged in /kaltura_sphinx_searchd.log.

[root@kaltura2 bin]# /etc/init.d/kaltura-sphinx status
searchd (pid 20303 20302) is running…


#13

Hi @mpowell,

You’re welcome. Are you now able to login?


#14

@jess,
Wow! I just tried it and can log in as Kaltura Administrator! I’ll bet this fixes the internal server errors that professors were seeing when trying to publish their lectures.
Thanks again,
M


#15

Hi @mpowell,

Glad to hear it:)
And yes, if Sphinx being down was not the ONLY root cause, it certainly was the first obstacle. Sphinx is a critical component and w/o it, the Kaltura Server will severely malfunction.
Should you come across additional issues, feel free to post them and I’ll gladly help you further.

Cheers,