error in monit.conf - line 23 #75

nzimas · 2014-03-14T22:26:23Z

At some point, /opt/kaltura/bin/kaltura-config-all.sh fails with the following error:

Starting monit: /opt/kaltura/app/configurations/monit/monit.conf:23: Error: syntax error '@'.

The offending line looks as follows:
allow admin:@MONIT_PASSWD@

I'm running the installation script on a fresh CentOS 6.x 64 bit environment, in accordance with the procedure outlined here:
https://github.com/kaltura/platform-install-packages/blob/master/doc/install-kaltura-redhat-based.md

jessp01 · 2014-03-15T12:34:59Z

Hello,

This was corrected by yours truly yesterday. Can you please try:

yum clean all

yum update "kaltura"

And then run:

kaltura-config-all.sh

once again and let us know as to the results?

Thanks,

nzimas · 2014-03-15T20:56:03Z

Same result.
I even went as far as reinstalling the OS and starting anew.

Shutting down monit: [FAILED]
Starting monit: /opt/kaltura/app/configurations/monit/monit.conf:23: Error: syntax error '@'
[FAILED]
/opt/kaltura/bin/kaltura-front-config.sh failed:( You can re-run it when the issue is fixed.
[root@streamer ~]#

jessp01 · 2014-03-16T08:25:40Z

Can you please attach the output for:

rpm -q kaltura-monit

rpm -q kaltura-base

Thanks,
May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Sat, 15 Mar 2014, nzimas wrote:

Same result.
I even went as far as reinstalling the OS and starting anew.

Shutting down monit: [FAILED]
Starting monit: /opt/kaltura/app/configurations/monit/monit.conf:23: Error: syntax error '@'
[FAILED]
/opt/kaltura/bin/kaltura-front-config.sh failed:( You can re-run it when the issue is fixed.
[root@streamer ~]#

—
Reply to this email directly or view it on
GitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDUzNjE2NCwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--c1ceb8ca7c0ba42c18a45538d2da6559ac23fb6e.gif]

nzimas · 2014-03-16T15:50:12Z

[root@streamer ~]# rpm -q kaltura-monit
kaltura-monit-5.6-14.x86_64
You have new mail in /var/spool/mail/root
[root@streamer ~]# rpm -q kaltura-base
kaltura-base-9.9.0-49.noarch

jessp01 · 2014-03-17T15:52:31Z

Now I see the issue.
OK, fixed.
Can you please confirm?
you do not need to reinstall everything, only run config-all once more.
Thank you,

nzimas · 2014-03-17T16:04:06Z

Same result, even after running
yum clean all
yum update "kaltura-release" (turns out this appears to be the actual name of the repos)

KalturaCommunity-zz · 2014-03-17T16:07:14Z

I did a test install that worked correctly.
Can you do:
$ rpm -q kaltura-monit
And, if not kaltura-monit-5.6-15.x86_64, replace:
installrepo.kaltura.org with 54.211.235.142 in
/etc/yum.repos.d/kaltura.repo,

installrepo.kaltura.org is our CDN and perhaps it is not yet updated.

Thanks@

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Mon, 17 Mar 2014, nzimas wrote:

Same result, even after running
yum clean all
yum update "kaltura-release" (turns out this appears to be the actual name of the repos)

—
Reply to this email directly or view it on
GitHub.[2227038__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDY5MTQ0NiwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--aabc76ac6385bb4f290286dd3deea6ae74ba9a6d.gif]

nzimas · 2014-03-17T18:01:46Z

Thanks for the tip!

I have managed to install Kalura, but not without having to manually add the kaltura user to MySQL.
At this point I am still unable to log in to the admin console, as it keeps throwing a nasty INTERNAL_DATABASE_ERROR

Here is the portion of the log relevant to this issue.

2014-03-17 17:53:45 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: service url: [http://streamer.eurotvguild.com:80]
2014-03-17 17:53:45 [1209773965] [Kaltura_Client_ClientBase->doCurl] DEBUG: curl: http://streamer.eurotvguild.com:80/api_v3/index.php?service=user&action=loginByLoginId&apiVersion=3.1.6&format=2&clientTag=Kaltura-admin&ignoreNull=1&loginId=nzimas%40freebandtech.com&password=%40Adm2008&partnerId=-2&privileges=disableentitlement&kalsig=5da4a8751e0f90bb8f2907d0b3d2619a
2014-03-17 17:53:46 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: server: [streamer.eurotvguild.com], session: [1580791135]
2014-03-17 17:53:46 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: result (serialized): INTERNAL_DATABASE_ERRORInternal database errorKalturaAPIException0.0053939819335938
2014-03-17 17:53:46 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: execution time for [http://streamer.eurotvguild.com:80/api_v3/index.php?service=user&action=loginByLoginId]: [0.0093090534210205]
2014-03-17 17:53:46 [1209773965] [ErrorController->errorAction] ERR: exception 'Kaltura_Client_Exception' with message 'Internal database error' in /opt/kaltura/app/admin_console/lib/Kaltura/Client/ParseUtils.php:67
Stack trace:
#0 /opt/kaltura/app/admin_console/lib/Kaltura/Client/UserService.php(179): Kaltura_Client_ParseUtils::checkIfError(Object(SimpleXMLElement))
#1 /opt/kaltura/app/ui_infra/Infra/AuthAdapter.php(132): Kaltura_Client_UserService->loginByLoginId('nzimas@freeband...', '@adm2008', '-2', NULL, 'disableentitlem...')
#2 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Auth.php(117): Infra_AuthAdapter->authenticate()
#3 /opt/kaltura/app/admin_console/controllers/UserController.php(158): Zend_Auth->authenticate(Object(Kaltura_AdminAuthAdapter))
#4 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Controller/Action.php(513): UserController->loginAction()
#5 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Controller/Dispatcher/Standard.php(289): Zend_Controller_Action->dispatch('loginAction')
#6 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Controller/Front.php(946): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#7 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/Bootstrap.php(77): Zend_Controller_Front->dispatch()
#8 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application.php(358): Zend_Application_Bootstrap_Bootstrap->run()
#9 /opt/kaltura/app/admin_console/web/index.php(38): Zend_Application->run()
#10 {main}

On 17 Mar 2014, at 16:07, KalturaCommunity notifications@github.com wrote:

I did a test install that worked correctly.
Can you do:
$ rpm -q kaltura-monit
And, if not kaltura-monit-5.6-15.x86_64, replace:
installrepo.kaltura.org with 54.211.235.142 in
/etc/yum.repos.d/kaltura.repo,

installrepo.kaltura.org is our CDN and perhaps it is not yet updated.

Thanks@

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Mon, 17 Mar 2014, nzimas wrote:

Same result, even after running
yum clean all
yum update "kaltura-release" (turns out this appears to be the actual name of the repos)

—
Reply to this email directly or view it on
GitHub.[2227038__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDY5MTQ0NiwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--aabc76ac6385bb4f290286dd3deea6ae74ba9a6d.gif]

—
Reply to this email directly or view it on GitHub.

jessp01 · 2014-03-17T18:07:56Z

Hi,

Are you certain you can connect to the DB as the platform tries to?
please run

. /etc/kaltura.d/system.ini

mysql -h$DB1_HOST -u$DB1_USER -p$DB1_PASS kaltura

And make sure you are getting in.

Also, do you have the output from the install? was it able to populate
the DB? should look like:
Populating DB with data.. please wait..
Output for $APP_DIR/deployment/base/scripts/installPlugins.php being logged into $LOG_DIR/installPlugins.log
Output for $APP_DIR/deployment/base/scripts/insertDefaults.php being logged into $LOG_DIR/insertDefaults.log
Output for $APP_DIR/deployment/base/scripts/insertPermissions.php being logged into $LOG_DIR/insertPermissions.log
Output for $APP_DIR/deployment/base/scripts/insertContent.php being logged into $LOG_DIR/insertContent.log

Also check these logs files for errors.

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Mon, 17 Mar 2014, nzimas wrote:

Thanks for the tip!

I have managed to install Kalura, but not without having to manually add the kaltura user to MySQL.
At this point I am still unable to log in to the admin console, as it keeps throwing a nasty INTERNAL_DATABASE_ERROR

Here is the portion of the log relevant to this issue.

2014-03-17 17:53:45 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: service url: [http://streamer.eurotvguild.com:80]
2014-03-17 17:53:45 [1209773965] [Kaltura_Client_ClientBase->doCurl] DEBUG: curl:http://streamer.eurotvguild.com:80/api_v3/index.php?service=user&action=loginByLoginId&apiVersion=3.1.6&format=2&clientTag=Kaltura-admin&ignoreNull=1&loginId=nzi
mas%40freebandtech.com&password=%40Adm2008&partnerId=-2&privileges=disableentitlement&kalsig=5da4a8751e0f90bb8f2907d0b3d2619a
2014-03-17 17:53:46 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: server: [streamer.eurotvguild.com], session: [1580791135]
2014-03-17 17:53:46 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: result (serialized): INTERNAL_DATABASE_ERRORInternal database
errorKalturaAPIException0.0053939819335938
2014-03-17 17:53:46 [1209773965] [Kaltura_Client_ClientBase->doQueue] DEBUG: execution time for
[http://streamer.eurotvguild.com:80/api_v3/index.php?service=user&action=loginByLoginId]: [0.0093090534210205]
2014-03-17 17:53:46 [1209773965] [ErrorController->errorAction] ERR: exception 'Kaltura_Client_Exception' with message 'Internal database error' in
/opt/kaltura/app/admin_console/lib/Kaltura/Client/ParseUtils.php:67
Stack trace:
#0 /opt/kaltura/app/admin_console/lib/Kaltura/Client/UserService.php(179): Kaltura_Client_ParseUtils::checkIfError(Object(SimpleXMLElement))
#1 /opt/kaltura/app/ui_infra/Infra/AuthAdapter.php(132): Kaltura_Client_UserService->loginByLoginId('nzimas@freeband...', '@adm2008', '-2', NULL,
'disableentitlem...')
#2 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Auth.php(117): Infra_AuthAdapter->authenticate()
#3 /opt/kaltura/app/admin_console/controllers/UserController.php(158): Zend_Auth->authenticate(Object(Kaltura_AdminAuthAdapter))
#4 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Controller/Action.php(513): UserController->loginAction()
#5 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Controller/Dispatcher/Standard.php(289): Zend_Controller_Action->dispatch('loginAction')
#6 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Controller/Front.php(946):
Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#7 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application/Bootstrap/Bootstrap.php(77): Zend_Controller_Front->dispatch()
#8 /opt/kaltura/app/vendor/ZendFramework/library/Zend/Application.php(358): Zend_Application_Bootstrap_Bootstrap->run()
#9 /opt/kaltura/app/admin_console/web/index.php(38): Zend_Application->run()
#10 {main}

On 17 Mar 2014, at 16:07, KalturaCommunity notifications@github.com wrote:

I did a test install that worked correctly.
Can you do:
$ rpm -q kaltura-monit
And, if not kaltura-monit-5.6-15.x86_64, replace:
installrepo.kaltura.org with 54.211.235.142 in
/etc/yum.repos.d/kaltura.repo,

installrepo.kaltura.org is our CDN and perhaps it is not yet updated.

Thanks@

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Mon, 17 Mar 2014, nzimas wrote:

Same result, even after running
yum clean all
yum update "kaltura-release" (turns out this appears to be the actual name of the repos)

—
Reply to this email directly or view it on

GitHub.[2227038__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDY5MTQ0NiwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--aabc76ac6385bb4f290286dd3deea6ae74ba9a6d.gif]

—
Reply to this email directly or view it on GitHub.

—
Reply to this email directly or view it on
GitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDY5ODUwNiwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--85938e0df505fd4449ba37218d49044573602667.gif]

nzimas · 2014-03-17T19:53:56Z

I think there is an error in e of the installation scripts.
The kaltura user is on the users database, but it won’t be granted access all the same.
It is assigned to any host (wildcard %) and perhaps that’s where the issue lies.

Suggestions are more than welcome.

The following error is then thrown at some point.

Checking MySQL version..
5.1.73

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...
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.

I have checked the

On 17 Mar 2014, at 16:07, KalturaCommunity notifications@github.com wrote:

54.211.235.142

jessp01 · 2014-03-17T20:04:45Z

Please run kaltura-drop-db.sh and the the kaltura-db-config again with bash -x and attach the output.

May the source be with you,

Jess Portnoy

-------- Original message --------
From: nzimas notifications@github.com
Date:
To: kaltura/platform-install-packages platform-install-packages@noreply.github.com
Cc: Jess Portnoy jess.portnoy@kaltura.com
Subject: Re: [platform-install-packages] error in monit.conf - line 23 (#75)

I think there is an error in e of the installation scripts.
The kaltura user is on the users database, but it won't be granted access all the same.
It is assigned to any host (wildcard %) and perhaps that's where the issue lies.

Suggestions are more than welcome.

The following error is then thrown at some point.

Checking MySQL version..
5.1.73

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...
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.

I have checked the

On 17 Mar 2014, at 16:07, KalturaCommunity notifications@github.com wrote:

54.211.235.142

Reply to this email directly or view it on GitHubhttps://github.com//issues/75#issuecomment-37862175.

nzimas · 2014-03-17T20:16:27Z

How would /opt/kaltura/bin/kaltura-config-all.sh look like with the option you suggest?
Not sure I ran it correctly.

On 17 Mar 2014, at 20:04, Jess Portnoy notifications@github.com wrote:

Please run kaltura-drop-db.sh and the the kaltura-db-config again with bash -x and attach the output.

May the source be with you,

Jess Portnoy

-------- Original message --------
From: nzimas notifications@github.com
Date:
To: kaltura/platform-install-packages platform-install-packages@noreply.github.com
Cc: Jess Portnoy jess.portnoy@kaltura.com
Subject: Re: [platform-install-packages] error in monit.conf - line 23 (#75)

I think there is an error in e of the installation scripts.
The kaltura user is on the users database, but it won't be granted access all the same.
It is assigned to any host (wildcard %) and perhaps that's where the issue lies.

Suggestions are more than welcome.

The following error is then thrown at some point.

Checking MySQL version..
5.1.73

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...
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.

I have checked the

On 17 Mar 2014, at 16:07, KalturaCommunity notifications@github.com wrote:

54.211.235.142

Reply to this email directly or view it on GitHubhttps://github.com/error in monit.conf - line 23 #75#issuecomment-37862175.
—
Reply to this email directly or view it on GitHub.

nzimas · 2014-03-17T22:06:20Z

I’ve executed the script as indicated.

Here’s the relevant bit:

'[' 0 -ne 0 ']'
echo 'use kaltura'
mysql -h127.0.0.1 -P3306 -uroot -pRev2004 mysql
'[' 0 -ne 0 ']'
echo 'Running Batch config...

‘
Running Batch config...

/opt/kaltura/bin/kaltura-batch-config.sh ''
kaltura-batch-9.9.0-10.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

/bin/kaltura-base-config.sh

ERROR 1045 (28000): Access denied for user 'kaltura'@'localhost' (using password: YES)

'[' 11 -ne 0 ']'
echo '/opt/kaltura/bin/kaltura-batch-config.sh failed:( You can re-run it when the issue is fixed.'
/opt/kaltura/bin/kaltura-batch-config.sh failed:( You can re-run it when the issue is fixed.
echo 'Running DWH config...

'
Running DWH config...

/opt/kaltura/bin/kaltura-dwh-config.sh ''
kaltura-dwh-9.2.0-6.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

/bin/kaltura-base-config.sh
'[' 2 -ne 0 ']'
echo '/opt/kaltura/bin/kaltura-dwh-config.sh failed:( You can re-run it when the issue is fixed.'
/opt/kaltura/bin/kaltura-dwh-config.sh failed:( You can re-run it when the issue is fixed.
rm -rf /opt/kaltura/app/cache/api_v3 /opt/kaltura/app/cache/generator /opt/kaltura/app/cache/scripts /opt/kaltura/app/cache/sphinx
rm -f '/opt/kaltura/app/log/kaltura-*.log'

+ echo '

On 17 Mar 2014, at 20:04, Jess Portnoy notifications@github.com wrote:

Please run kaltura-drop-db.sh and the the kaltura-db-config again with bash -x and attach the output.

May the source be with you,

Jess Portnoy

-------- Original message --------
From: nzimas notifications@github.com
Date:
To: kaltura/platform-install-packages platform-install-packages@noreply.github.com
Cc: Jess Portnoy jess.portnoy@kaltura.com
Subject: Re: [platform-install-packages] error in monit.conf - line 23 (#75)

I think there is an error in e of the installation scripts.
The kaltura user is on the users database, but it won't be granted access all the same.
It is assigned to any host (wildcard %) and perhaps that's where the issue lies.

Suggestions are more than welcome.

The following error is then thrown at some point.

Checking MySQL version..
5.1.73

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...
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.

I have checked the

On 17 Mar 2014, at 16:07, KalturaCommunity notifications@github.com wrote:

54.211.235.142

Reply to this email directly or view it on GitHubhttps://github.com/error in monit.conf - line 23 #75#issuecomment-37862175.
—
Reply to this email directly or view it on GitHub.

jessp01 · 2014-03-18T08:20:22Z

There is an attempt to connect to MySQL and this is returned:
ERROR 1045 (28000): Access denied for user 'kaltura'@'localhost' (using
password: YES)

Are you able to use:
mysql> mysql -h$DB1_HOST -u$DB1_USER -p$DB1_PASS

If not, I suggest you:
/opt/kaltura/bin/kaltura-drop-db.sh

And then, run:
bash -x /opt/kaltura/bin/kaltura-db-config.sh
Attach the resulting output, it should end with success and RC 0.

Thank you,

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Mon, 17 Mar 2014, nzimas wrote:

I’ve executed the script as indicated.

Here’s the relevant bit:

'[' 0 -ne 0 ']'

echo 'use kaltura'

mysql -h127.0.0.1 -P3306 -uroot -pRev2004 mysql

'[' 0 -ne 0 ']'

echo 'Running Batch config...

‘
Running Batch config...

/opt/kaltura/bin/kaltura-batch-config.sh ''
kaltura-batch-9.9.0-10.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

/bin/kaltura-base-config.sh

ERROR 1045 (28000): Access denied for user 'kaltura'@'localhost' (using password: YES)

'[' 11 -ne 0 ']'

echo '/opt/kaltura/bin/kaltura-batch-config.sh failed:( You can re-run it when the issue is fixed.'
/opt/kaltura/bin/kaltura-batch-config.sh failed:( You can re-run it when the issue is fixed.

echo 'Running DWH config...

'
Running DWH config...

/opt/kaltura/bin/kaltura-dwh-config.sh ''
kaltura-dwh-9.2.0-6.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

/bin/kaltura-base-config.sh

'[' 2 -ne 0 ']'

echo '/opt/kaltura/bin/kaltura-dwh-config.sh failed:( You can re-run it when the issue is fixed.'
/opt/kaltura/bin/kaltura-dwh-config.sh failed:( You can re-run it when the issue is fixed.

rm -rf /opt/kaltura/app/cache/api_v3 /opt/kaltura/app/cache/generator /opt/kaltura/app/cache/scripts /opt/kaltura/app/cache/sphinx

rm -f '/opt/kaltura/app/log/kaltura-*.log'

+ echo '

On 17 Mar 2014, at 20:04, Jess Portnoy notifications@github.com wrote:

Please run kaltura-drop-db.sh and the the kaltura-db-config again with bash -x and attach the output.

May the source be with you,

Jess Portnoy

-------- Original message --------
From: nzimas notifications@github.com
Date:
To: kaltura/platform-install-packages platform-install-packages@noreply.github.com
Cc: Jess Portnoy jess.portnoy@kaltura.com
Subject: Re: [platform-install-packages] error in monit.conf - line 23 (#75)

I think there is an error in e of the installation scripts.
The kaltura user is on the users database, but it won't be granted access all the same.
It is assigned to any host (wildcard %) and perhaps that's where the issue lies.

Suggestions are more than welcome.

The following error is then thrown at some point.

Checking MySQL version..
5.1.73

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...
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.

I have checked the

On 17 Mar 2014, at 16:07, KalturaCommunity notifications@github.com wrote:

54.211.235.142

Reply to this email directly or view it on GitHubhttps://github.com//issues/75#issuecomment-37862175.
—
Reply to this email directly or view it on GitHub.

—
Reply to this email directly or view it on
GitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDcxMzE4MSwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--105aa40d0e0831569f36105e79c5739805229785.gif]

nzimas · 2014-03-18T12:16:19Z

Still fails to connect after creating te DB and grating the kaltura user privileges.

[root@streamer ~]# bash -x /opt/kaltura/bin/kaltura-db-config.sh localhost root Rev2004 3306

'[' 4 -lt 4 ']'
RC_FILE=/etc/kaltura.d/system.ini
'[' '!' -r /etc/kaltura.d/system.ini ']'
. /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=nzimas@freebandtech.com
++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=6fSMRQN9OmeutWZ
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=6fSMRQN9OmeutWZ
++ SERVICE_URL=http://streamer.eurotvguild.com:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=Rev2004
++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
++ RED5_HOST=streamer.eurotvguild.com
++ dirname /opt/kaltura/bin/kaltura-db-config.sh
DB_ACTIONS_RC=/opt/kaltura/bin/db_actions.rc
'[' '!' -r /opt/kaltura/bin/db_actions.rc ']'
. /opt/kaltura/bin/db_actions.rc
++ DBS='kaltura kaltura_sphinx_log kalturadw kalturadw_ds kalturadw_bisources kalturalog'
++ DB_USERS='kaltura etl'
++ kaltura_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT
++ kaltura_USER=kaltura
++ kaltura_SQL_FILES='/opt/kaltura/app/deployment/base/sql/01.kaltura_ce_tables.sql /opt/kaltura/app/deployment/base/sql/04.stored_procedures.sql'
++ kaltura_sphinx_log_PRIVILEGES=SELECT,INSERT,UPDATE
++ kaltura_sphinx_log_USER=kaltura
++ kaltura_sphinx_log_SQL_FILES=/opt/kaltura/app/deployment/base/sql/01.kaltura_sphinx_ce_tables.sql
++ kalturadw_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_USER=etl
++ kalturadw_ds_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_ds_USER=etl
++ kalturadw_bisources_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_bisources_USER=etl
++ kalturalog_PRIVILEGES='INSERT,UPDATE,DELETE,SELECT,LOCK TABLES'
++ kalturalog_USER=etl
++ dirname /opt/kaltura/bin/kaltura-db-config.sh
KALTURA_FUNCTIONS_RC=/opt/kaltura/bin/kaltura-functions.rc
'[' '!' -r /opt/kaltura/bin/kaltura-functions.rc ']'
. /opt/kaltura/bin/kaltura-functions.rc
++ RC_FILE=/etc/kaltura.d/system.ini
++ '[' -r /etc/kaltura.d/system.ini ']'
++ . /etc/kaltura.d/system.ini
+++ WEB_DIR=/opt/kaltura/web
+++ LOG_DIR=/opt/kaltura/log
+++ APP_DIR=/opt/kaltura/app
+++ BASE_DIR=/opt/kaltura
+++ PHP_BIN=/usr/bin/php
+++ OS_KALTURA_USER=kaltura
+++ MAILTO=nzimas@freebandtech.com
+++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
+++ DB1_HOST=127.0.0.1
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=6fSMRQN9OmeutWZ
+++ DWH_HOST=127.0.0.1
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=6fSMRQN9OmeutWZ
+++ SERVICE_URL=http://streamer.eurotvguild.com:80
+++ SPHINX_HOST=127.0.0.1
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=Rev2004
+++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
+++ RED5_HOST=streamer.eurotvguild.com
++ '[' -r /etc/sysconfig/clock ']'
++ POST_INST_MAIL_SUBJECT='Your new Kaltura server is up! and 6 Quick Tips For Smooth Kaltura Maintenance'
++ POST_INST_MAIL_TMPL=/opt/kaltura/app/configurations/post_inst_mail
trap 'my_trap_handler ${LINENO} ${$?}' ERR
++ basename /opt/kaltura/bin/kaltura-db-config.sh
send_install_becon kaltura-db-config.sh install_start
ROLE=kaltura-db-config.sh
TIMEZONE=install_start
ACTION=
ANALYTICS_SERVER_URI=http://54.204.228.203/report
RC_FILE=/etc/kaltura.d/system.ini
'[' -r /etc/kaltura.d/system.ini ']'
. /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=nzimas@freebandtech.com
++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=6fSMRQN9OmeutWZ
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=6fSMRQN9OmeutWZ
++ SERVICE_URL=http://streamer.eurotvguild.com:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=Rev2004
++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
++ RED5_HOST=streamer.eurotvguild.com
++ blkid
BLKID=
++ awk -F ' ' '{print $1}'
++ md5sum
++ echo -n
MACHINE_ID=d41d8cd98f00b204e9800998ecf8427e
++ date +%s
EPOCH=1395144777
++ md5sum
++ awk -F ' ' '{print $1}'
++ echo : 1395144777
INSTALL_ID=74469ffecce50218dc05f070baee684d
++ uname -r
++ uname -m
curl -i -X POST -H 'Content-Type: application/json' -d '{"event_type": "", "krole": "kaltura-db-config.sh", "email": "nzimas@freebandtech.com", "machineId": "d41d8cd98f00b204e9800998ecf8427e", "installationId": "74469ffecce50218dc05f070baee684d", "timestamp": "1395144777", "kernel_v": "2.6.32-24-pve", "machine_arch": "x86_64","is_ssl": true, "serviceurl": "http://streamer.eurotvguild.com:80", "timezone": "install_start","package_type":"rpm"}' http://54.204.228.203/report
MYSQL_HOST=localhost
MYSQL_SUPER_USER=root
MYSQL_SUPER_USER_PASSWD=Rev2004
MYSQL_PORT=3306
IS_UPGRADE=
'[' '' = upgrade ']'
KALTURA_DB=kaltura
echo 'Checking MySQL version..'
Checking MySQL version..
echo 'select version();'
mysql -hlocalhost -uroot -pRev2004 -P3306 -N
5.1.73
'[' 0 -ne 0 ']'
check_mysql_settings root Rev2004 localhost 3306
DB_USER=root
DB_PASSWD=Rev2004
DB_HOST=localhost
DB_PORT=3306
RC=0
++ echo 'select @@open_files_limit;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N
OPEN_FILES_LIMIT=20000
'[' 20000 -lt 20000 ']'
++ echo 'select @@lower_case_table_names;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N
LOWER_CASE_TABLE_NAMES=1
'[' 1 -ne 1 ']'
++ echo 'select @@max_allowed_packet;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N
MAX_ALLOWED_PACKET=16777216
'[' 16777216 -lt 16777216 ']'
echo -en '\n'
return 0
trap - ERR
'[' -z '' ']'
echo 'use kaltura'
mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura
'[' 1 -eq 0 ']'
trap 'my_trap_handler ${LINENO} ${$?}' ERR
set -e
for DB_USER in '$DB_USERS'
echo 'CREATE USER kaltura;'
CREATE USER kaltura;
echo 'CREATE USER kaltura IDENTIFIED BY '''6fSMRQN9OmeutWZ''' ;'
mysql -hlocalhost -uroot -pRev2004 -P3306
for DB_USER in '$DB_USERS'
echo 'CREATE USER etl;'
CREATE USER etl;
echo 'CREATE USER etl IDENTIFIED BY '''6fSMRQN9OmeutWZ''' ;'
mysql -hlocalhost -uroot -pRev2004 -P3306
for DB in '$DBS'
echo 'CREATE DATABASE kaltura;'
CREATE DATABASE kaltura;
echo 'CREATE DATABASE kaltura;'
mysql -hlocalhost -uroot -pRev2004 -P3306
PRIVS=kaltura_PRIVILEGES
DB_USER=kaltura_USER
echo 'GRANT INSERT,UPDATE,DELETE,SELECT ON kaltura.* TO '''kaltura'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -pRev2004 -P3306
DB_SQL_FILES=kaltura_SQL_FILES
for SQL in '${!DB_SQL_FILES}'
mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura
for SQL in '${!DB_SQL_FILES}'
mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura
for DB in '$DBS'
echo 'CREATE DATABASE kaltura_sphinx_log;'
CREATE DATABASE kaltura_sphinx_log;
echo 'CREATE DATABASE kaltura_sphinx_log;'
mysql -hlocalhost -uroot -pRev2004 -P3306
PRIVS=kaltura_sphinx_log_PRIVILEGES
DB_USER=kaltura_sphinx_log_USER
echo 'GRANT SELECT,INSERT,UPDATE ON kaltura_sphinx_log.* TO '''kaltura'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -pRev2004 -P3306
DB_SQL_FILES=kaltura_sphinx_log_SQL_FILES
for SQL in '${!DB_SQL_FILES}'
mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura_sphinx_log
for DB in '$DBS'
echo 'CREATE DATABASE kalturadw;'
CREATE DATABASE kalturadw;
echo 'CREATE DATABASE kalturadw;'
mysql -hlocalhost -uroot -pRev2004 -P3306
PRIVS=kalturadw_PRIVILEGES
DB_USER=kalturadw_USER
echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -pRev2004 -P3306
DB_SQL_FILES=kalturadw_SQL_FILES
for DB in '$DBS'
echo 'CREATE DATABASE kalturadw_ds;'
CREATE DATABASE kalturadw_ds;
echo 'CREATE DATABASE kalturadw_ds;'
mysql -hlocalhost -uroot -pRev2004 -P3306
PRIVS=kalturadw_ds_PRIVILEGES
DB_USER=kalturadw_ds_USER
echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw_ds.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -pRev2004 -P3306
DB_SQL_FILES=kalturadw_ds_SQL_FILES
for DB in '$DBS'
echo 'CREATE DATABASE kalturadw_bisources;'
CREATE DATABASE kalturadw_bisources;
echo 'CREATE DATABASE kalturadw_bisources;'
mysql -hlocalhost -uroot -pRev2004 -P3306
PRIVS=kalturadw_bisources_PRIVILEGES
DB_USER=kalturadw_bisources_USER
echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw_bisources.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -pRev2004 -P3306
DB_SQL_FILES=kalturadw_bisources_SQL_FILES
for DB in '$DBS'
echo 'CREATE DATABASE kalturalog;'
CREATE DATABASE kalturalog;
echo 'CREATE DATABASE kalturalog;'
mysql -hlocalhost -uroot -pRev2004 -P3306
PRIVS=kalturalog_PRIVILEGES
DB_USER=kalturalog_USER
echo 'GRANT INSERT,UPDATE,DELETE,SELECT,LOCK TABLES ON kalturalog.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -pRev2004 -P3306
DB_SQL_FILES=kalturalog_SQL_FILES
echo 'GRANT SELECT ON kaltura.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -pRev2004 -P3306
set +e
echo 'Checking connectivity to needed daemons...'
Checking connectivity to needed daemons...
check_connectivity kaltura 6fSMRQN9OmeutWZ 127.0.0.1 3306 127.0.0.1 http://streamer.eurotvguild.com:80
DB_USER=kaltura
DB_PASSWD=6fSMRQN9OmeutWZ
DB_HOST=127.0.0.1
DB_PORT=3306
SPHINX_SERVER=127.0.0.1
SERVICE_URL=http://streamer.eurotvguild.com:80
RC=0
MSG='Connectivity test passed:)'
echo 'select version();'
mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306 -N
'[' 1 -ne 0 ']'
MSG='Couldn'''t connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.'
RC=1
echo 'show tables;'
mysql -h127.0.0.1 -P9312
'[' 0 -ne 0 ']'
curl 'http://streamer.eurotvguild.com:80/api_v3/index.php?service=system&action=ping' -k
'[' 0 -ne 0 ']'
echo -en 'Couldn'''t connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.\n'
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.
return 1
echo 'Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.'
Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.
exit 6

On 18 Mar 2014, at 08:20, Jess Portnoy notifications@github.com wrote:

bash -x /opt/kaltura/bin/kaltura-db-config.sh

jessp01 · 2014-03-18T12:28:54Z

Can I have access to your machine?

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Tue, 18 Mar 2014, nzimas wrote:

Still fails to connect after creating te DB and grating the kaltura user privileges.

[root@streamer ~]# bash -x /opt/kaltura/bin/kaltura-db-config.sh localhost root Rev2004 3306

'[' 4 -lt 4 ']'

RC_FILE=/etc/kaltura.d/system.ini

'[' '!' -r /etc/kaltura.d/system.ini ']'

. /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=nzimas@freebandtech.com
++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=6fSMRQN9OmeutWZ
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=6fSMRQN9OmeutWZ
++ SERVICE_URL=http://streamer.eurotvguild.com:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=Rev2004
++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
++ RED5_HOST=streamer.eurotvguild.com
++ dirname /opt/kaltura/bin/kaltura-db-config.sh

DB_ACTIONS_RC=/opt/kaltura/bin/db_actions.rc

'[' '!' -r /opt/kaltura/bin/db_actions.rc ']'

. /opt/kaltura/bin/db_actions.rc
++ DBS='kaltura kaltura_sphinx_log kalturadw kalturadw_ds kalturadw_bisources kalturalog'
++ DB_USERS='kaltura etl'
++ kaltura_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT
++ kaltura_USER=kaltura
++ kaltura_SQL_FILES='/opt/kaltura/app/deployment/base/sql/01.kaltura_ce_tables.sql /opt/kaltura/app/deployment/base/sql/04.stored_procedures.sql'
++ kaltura_sphinx_log_PRIVILEGES=SELECT,INSERT,UPDATE
++ kaltura_sphinx_log_USER=kaltura
++ kaltura_sphinx_log_SQL_FILES=/opt/kaltura/app/deployment/base/sql/01.kaltura_sphinx_ce_tables.sql
++ kalturadw_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_USER=etl
++ kalturadw_ds_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_ds_USER=etl
++ kalturadw_bisources_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_bisources_USER=etl
++ kalturalog_PRIVILEGES='INSERT,UPDATE,DELETE,SELECT,LOCK TABLES'
++ kalturalog_USER=etl
++ dirname /opt/kaltura/bin/kaltura-db-config.sh

KALTURA_FUNCTIONS_RC=/opt/kaltura/bin/kaltura-functions.rc

'[' '!' -r /opt/kaltura/bin/kaltura-functions.rc ']'

. /opt/kaltura/bin/kaltura-functions.rc
++ RC_FILE=/etc/kaltura.d/system.ini
++ '[' -r /etc/kaltura.d/system.ini ']'
++ . /etc/kaltura.d/system.ini
+++ WEB_DIR=/opt/kaltura/web
+++ LOG_DIR=/opt/kaltura/log
+++ APP_DIR=/opt/kaltura/app
+++ BASE_DIR=/opt/kaltura
+++ PHP_BIN=/usr/bin/php
+++ OS_KALTURA_USER=kaltura
+++ MAILTO=nzimas@freebandtech.com
+++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
+++ DB1_HOST=127.0.0.1
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=6fSMRQN9OmeutWZ
+++ DWH_HOST=127.0.0.1
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=6fSMRQN9OmeutWZ
+++ SERVICE_URL=http://streamer.eurotvguild.com:80
+++ SPHINX_HOST=127.0.0.1
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=Rev2004
+++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
+++ RED5_HOST=streamer.eurotvguild.com
++ '[' -r /etc/sysconfig/clock ']'
++ POST_INST_MAIL_SUBJECT='Your new Kaltura server is up! and 6 Quick Tips For Smooth Kaltura Maintenance'
++ POST_INST_MAIL_TMPL=/opt/kaltura/app/configurations/post_inst_mail

trap 'my_trap_handler ${LINENO} ${$?}' ERR
++ basename /opt/kaltura/bin/kaltura-db-config.sh

send_install_becon kaltura-db-config.sh install_start

ROLE=kaltura-db-config.sh

TIMEZONE=install_start

ACTION=

ANALYTICS_SERVER_URI=http://54.204.228.203/report

RC_FILE=/etc/kaltura.d/system.ini

'[' -r /etc/kaltura.d/system.ini ']'

. /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=nzimas@freebandtech.com
++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=6fSMRQN9OmeutWZ
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=6fSMRQN9OmeutWZ
++ SERVICE_URL=http://streamer.eurotvguild.com:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=Rev2004
++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
++ RED5_HOST=streamer.eurotvguild.com
++ blkid

BLKID=
++ awk -F ' ' '{print $1}'
++ md5sum
++ echo -n

MACHINE_ID=d41d8cd98f00b204e9800998ecf8427e
++ date +%s

EPOCH=1395144777
++ md5sum
++ awk -F ' ' '{print $1}'
++ echo : 1395144777

INSTALL_ID=74469ffecce50218dc05f070baee684d
++ uname -r
++ uname -m

curl -i -X POST -H 'Content-Type: application/json' -d '{"event_type": "", "krole": "kaltura-db-config.sh", "email": "nzimas@freebandtech.com", "machineId":
"d41d8cd98f00b204e9800998ecf8427e", "installationId": "74469ffecce50218dc05f070baee684d", "timestamp": "1395144777", "kernel_v": "2.6.32-24-pve", "machine_arch":
"x86_64","is_ssl": true, "serviceurl": "http://streamer.eurotvguild.com:80", "timezone": "install_start","package_type":"rpm"}' http://54.204.228.203/report

MYSQL_HOST=localhost

MYSQL_SUPER_USER=root

MYSQL_SUPER_USER_PASSWD=Rev2004

MYSQL_PORT=3306

IS_UPGRADE=

'[' '' = upgrade ']'

KALTURA_DB=kaltura

echo 'Checking MySQL version..'
Checking MySQL version..

echo 'select version();'

mysql -hlocalhost -uroot -pRev2004 -P3306 -N
5.1.73

'[' 0 -ne 0 ']'

check_mysql_settings root Rev2004 localhost 3306

DB_USER=root

DB_PASSWD=Rev2004

DB_HOST=localhost

DB_PORT=3306

RC=0
++ echo 'select @@open_files_limit;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N

OPEN_FILES_LIMIT=20000

'[' 20000 -lt 20000 ']'
++ echo 'select @@lower_case_table_names;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N

LOWER_CASE_TABLE_NAMES=1

'[' 1 -ne 1 ']'
++ echo 'select @@max_allowed_packet;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N

MAX_ALLOWED_PACKET=16777216

'[' 16777216 -lt 16777216 ']'

echo -en '\n'

return 0

trap - ERR

'[' -z '' ']'

echo 'use kaltura'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura

'[' 1 -eq 0 ']'

trap 'my_trap_handler ${LINENO} ${$?}' ERR

set -e

for DB_USER in '$DB_USERS'

echo 'CREATE USER kaltura;'
CREATE USER kaltura;

echo 'CREATE USER kaltura IDENTIFIED BY '''6fSMRQN9OmeutWZ''' ;'

mysql -hlocalhost -uroot -pRev2004 -P3306

for DB_USER in '$DB_USERS'

echo 'CREATE USER etl;'
CREATE USER etl;

echo 'CREATE USER etl IDENTIFIED BY '''6fSMRQN9OmeutWZ''' ;'

mysql -hlocalhost -uroot -pRev2004 -P3306

for DB in '$DBS'

echo 'CREATE DATABASE kaltura;'
CREATE DATABASE kaltura;

echo 'CREATE DATABASE kaltura;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kaltura_PRIVILEGES

DB_USER=kaltura_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT ON kaltura.* TO '''kaltura'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kaltura_SQL_FILES

for SQL in '${!DB_SQL_FILES}'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura

for SQL in '${!DB_SQL_FILES}'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura

for DB in '$DBS'

echo 'CREATE DATABASE kaltura_sphinx_log;'
CREATE DATABASE kaltura_sphinx_log;

echo 'CREATE DATABASE kaltura_sphinx_log;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kaltura_sphinx_log_PRIVILEGES

DB_USER=kaltura_sphinx_log_USER

echo 'GRANT SELECT,INSERT,UPDATE ON kaltura_sphinx_log.* TO '''kaltura'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kaltura_sphinx_log_SQL_FILES

for SQL in '${!DB_SQL_FILES}'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura_sphinx_log

for DB in '$DBS'

echo 'CREATE DATABASE kalturadw;'
CREATE DATABASE kalturadw;

echo 'CREATE DATABASE kalturadw;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturadw_PRIVILEGES

DB_USER=kalturadw_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturadw_SQL_FILES

for DB in '$DBS'

echo 'CREATE DATABASE kalturadw_ds;'
CREATE DATABASE kalturadw_ds;

echo 'CREATE DATABASE kalturadw_ds;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturadw_ds_PRIVILEGES

DB_USER=kalturadw_ds_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw_ds.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturadw_ds_SQL_FILES

for DB in '$DBS'

echo 'CREATE DATABASE kalturadw_bisources;'
CREATE DATABASE kalturadw_bisources;

echo 'CREATE DATABASE kalturadw_bisources;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturadw_bisources_PRIVILEGES

DB_USER=kalturadw_bisources_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw_bisources.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturadw_bisources_SQL_FILES

for DB in '$DBS'

echo 'CREATE DATABASE kalturalog;'
CREATE DATABASE kalturalog;

echo 'CREATE DATABASE kalturalog;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturalog_PRIVILEGES

DB_USER=kalturalog_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,LOCK TABLES ON kalturalog.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturalog_SQL_FILES

echo 'GRANT SELECT ON kaltura.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

set +e

echo 'Checking connectivity to needed daemons...'
Checking connectivity to needed daemons...

check_connectivity kaltura 6fSMRQN9OmeutWZ 127.0.0.1 3306 127.0.0.1 http://streamer.eurotvguild.com:80

DB_USER=kaltura

DB_PASSWD=6fSMRQN9OmeutWZ

DB_HOST=127.0.0.1

DB_PORT=3306

SPHINX_SERVER=127.0.0.1

SERVICE_URL=http://streamer.eurotvguild.com:80

RC=0

MSG='Connectivity test passed:)'

echo 'select version();'

mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306 -N

'[' 1 -ne 0 ']'

MSG='Couldn'''t connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.'

RC=1

echo 'show tables;'

mysql -h127.0.0.1 -P9312

'[' 0 -ne 0 ']'

curl 'http://streamer.eurotvguild.com:80/api_v3/index.php?service=system&action=ping' -k

'[' 0 -ne 0 ']'

echo -en 'Couldn'''t connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.\n'
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.

return 1

echo 'Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.'
Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.

exit 6

On 18 Mar 2014, at 08:20, Jess Portnoy notifications@github.com wrote:

bash -x /opt/kaltura/bin/kaltura-db-config.sh

—
Reply to this email directly or view it on
GitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDc2NDE4MCwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--d8e5f9385798384a401c1c096eb5b41cf9b11004.gif]

nzimas · 2014-03-18T12:39:10Z

Certainly.
Where can I send you the access details?

jessp01 · 2014-03-18T12:41:51Z

Please reach me on Skype, ID: jessport1
Thanks,

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Tue, 18 Mar 2014, nzimas wrote:

Certainly.
Where can I send you the access details?

On 18 Mar 2014, at 12:28, Jess Portnoy notifications@github.com wrote:

Can I have access to your machine?

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Tue, 18 Mar 2014, nzimas wrote:

Still fails to connect after creating te DB and grating the kaltura user privileges.

[root@streamer ~]# bash -x /opt/kaltura/bin/kaltura-db-config.sh localhost root Rev2004 3306

'[' 4 -lt 4 ']'

RC_FILE=/etc/kaltura.d/system.ini

'[' '!' -r /etc/kaltura.d/system.ini ']'

. /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=nzimas@freebandtech.com
++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=6fSMRQN9OmeutWZ
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=6fSMRQN9OmeutWZ
++ SERVICE_URL=http://streamer.eurotvguild.com:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=Rev2004
++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
++ RED5_HOST=streamer.eurotvguild.com
++ dirname /opt/kaltura/bin/kaltura-db-config.sh

DB_ACTIONS_RC=/opt/kaltura/bin/db_actions.rc

'[' '!' -r /opt/kaltura/bin/db_actions.rc ']'

. /opt/kaltura/bin/db_actions.rc
++ DBS='kaltura kaltura_sphinx_log kalturadw kalturadw_ds kalturadw_bisources kalturalog'
++ DB_USERS='kaltura etl'
++ kaltura_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT
++ kaltura_USER=kaltura
++ kaltura_SQL_FILES='/opt/kaltura/app/deployment/base/sql/01.kaltura_ce_tables.sql /opt/kaltura/app/deployment/base/sql/04.stored_procedures.sql'
++ kaltura_sphinx_log_PRIVILEGES=SELECT,INSERT,UPDATE
++ kaltura_sphinx_log_USER=kaltura
++ kaltura_sphinx_log_SQL_FILES=/opt/kaltura/app/deployment/base/sql/01.kaltura_sphinx_ce_tables.sql
++ kalturadw_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_USER=etl
++ kalturadw_ds_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_ds_USER=etl
++ kalturadw_bisources_PRIVILEGES=INSERT,UPDATE,DELETE,SELECT,EXECUTE
++ kalturadw_bisources_USER=etl
++ kalturalog_PRIVILEGES='INSERT,UPDATE,DELETE,SELECT,LOCK TABLES'
++ kalturalog_USER=etl
++ dirname /opt/kaltura/bin/kaltura-db-config.sh

KALTURA_FUNCTIONS_RC=/opt/kaltura/bin/kaltura-functions.rc

'[' '!' -r /opt/kaltura/bin/kaltura-functions.rc ']'

. /opt/kaltura/bin/kaltura-functions.rc
++ RC_FILE=/etc/kaltura.d/system.ini
++ '[' -r /etc/kaltura.d/system.ini ']'
++ . /etc/kaltura.d/system.ini
+++ WEB_DIR=/opt/kaltura/web
+++ LOG_DIR=/opt/kaltura/log
+++ APP_DIR=/opt/kaltura/app
+++ BASE_DIR=/opt/kaltura
+++ PHP_BIN=/usr/bin/php
+++ OS_KALTURA_USER=kaltura
+++ MAILTO=nzimas@freebandtech.com
+++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
+++ DB1_HOST=127.0.0.1
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=6fSMRQN9OmeutWZ
+++ DWH_HOST=127.0.0.1
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=6fSMRQN9OmeutWZ
+++ SERVICE_URL=http://streamer.eurotvguild.com:80
+++ SPHINX_HOST=127.0.0.1
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=Rev2004
+++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
+++ RED5_HOST=streamer.eurotvguild.com
++ '[' -r /etc/sysconfig/clock ']'
++ POST_INST_MAIL_SUBJECT='Your new Kaltura server is up! and 6 Quick Tips For Smooth Kaltura Maintenance'
++ POST_INST_MAIL_TMPL=/opt/kaltura/app/configurations/post_inst_mail

trap 'my_trap_handler ${LINENO} ${$?}' ERR
++ basename /opt/kaltura/bin/kaltura-db-config.sh

send_install_becon kaltura-db-config.sh install_start

ROLE=kaltura-db-config.sh

TIMEZONE=install_start

ACTION=

ANALYTICS_SERVER_URI=http://54.204.228.203/report

RC_FILE=/etc/kaltura.d/system.ini

'[' -r /etc/kaltura.d/system.ini ']'

. /etc/kaltura.d/system.ini
++ WEB_DIR=/opt/kaltura/web
++ LOG_DIR=/opt/kaltura/log
++ APP_DIR=/opt/kaltura/app
++ BASE_DIR=/opt/kaltura
++ PHP_BIN=/usr/bin/php
++ OS_KALTURA_USER=kaltura
++ MAILTO=nzimas@freebandtech.com
++ ADMIN_CONSOLE_ADMIN_MAIL=nzimas@freebandtech.com
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=6fSMRQN9OmeutWZ
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=6fSMRQN9OmeutWZ
++ SERVICE_URL=http://streamer.eurotvguild.com:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=Rev2004
++ KALTURA_VIRTUAL_HOST_NAME=streamer.eurotvguild.com
++ RED5_HOST=streamer.eurotvguild.com
++ blkid

BLKID=
++ awk -F ' ' '{print $1}'
++ md5sum
++ echo -n

MACHINE_ID=d41d8cd98f00b204e9800998ecf8427e
++ date +%s

EPOCH=1395144777
++ md5sum
++ awk -F ' ' '{print $1}'
++ echo : 1395144777

INSTALL_ID=74469ffecce50218dc05f070baee684d
++ uname -r
++ uname -m

curl -i -X POST -H 'Content-Type: application/json' -d '{"event_type": "", "krole": "kaltura-db-config.sh", "email": "nzimas@freebandtech.com", "machineId":
"d41d8cd98f00b204e9800998ecf8427e", "installationId": "74469ffecce50218dc05f070baee684d", "timestamp": "1395144777", "kernel_v": "2.6.32-24-pve",
"machine_arch":
"x86_64","is_ssl": true, "serviceurl": "http://streamer.eurotvguild.com:80", "timezone": "install_start","package_type":"rpm"}' http://54.204.228.203/report

MYSQL_HOST=localhost

MYSQL_SUPER_USER=root

MYSQL_SUPER_USER_PASSWD=Rev2004

MYSQL_PORT=3306

IS_UPGRADE=

'[' '' = upgrade ']'

KALTURA_DB=kaltura

echo 'Checking MySQL version..'
Checking MySQL version..

echo 'select version();'

mysql -hlocalhost -uroot -pRev2004 -P3306 -N
5.1.73

'[' 0 -ne 0 ']'

check_mysql_settings root Rev2004 localhost 3306

DB_USER=root

DB_PASSWD=Rev2004

DB_HOST=localhost

DB_PORT=3306

RC=0
++ echo 'select @@open_files_limit;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N

OPEN_FILES_LIMIT=20000

'[' 20000 -lt 20000 ']'
++ echo 'select @@lower_case_table_names;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N

LOWER_CASE_TABLE_NAMES=1

'[' 1 -ne 1 ']'
++ echo 'select @@max_allowed_packet;'
++ mysql -uroot -pRev2004 -hlocalhost -P3306 -N

MAX_ALLOWED_PACKET=16777216

'[' 16777216 -lt 16777216 ']'

echo -en '\n'

return 0

trap - ERR

'[' -z '' ']'

echo 'use kaltura'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura

'[' 1 -eq 0 ']'

trap 'my_trap_handler ${LINENO} ${$?}' ERR

set -e

for DB_USER in '$DB_USERS'

echo 'CREATE USER kaltura;'
CREATE USER kaltura;

echo 'CREATE USER kaltura IDENTIFIED BY '''6fSMRQN9OmeutWZ''' ;'

mysql -hlocalhost -uroot -pRev2004 -P3306

for DB_USER in '$DB_USERS'

echo 'CREATE USER etl;'
CREATE USER etl;

echo 'CREATE USER etl IDENTIFIED BY '''6fSMRQN9OmeutWZ''' ;'

mysql -hlocalhost -uroot -pRev2004 -P3306

for DB in '$DBS'

echo 'CREATE DATABASE kaltura;'
CREATE DATABASE kaltura;

echo 'CREATE DATABASE kaltura;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kaltura_PRIVILEGES

DB_USER=kaltura_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT ON kaltura.* TO '''kaltura'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kaltura_SQL_FILES

for SQL in '${!DB_SQL_FILES}'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura

for SQL in '${!DB_SQL_FILES}'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura

for DB in '$DBS'

echo 'CREATE DATABASE kaltura_sphinx_log;'
CREATE DATABASE kaltura_sphinx_log;

echo 'CREATE DATABASE kaltura_sphinx_log;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kaltura_sphinx_log_PRIVILEGES

DB_USER=kaltura_sphinx_log_USER

echo 'GRANT SELECT,INSERT,UPDATE ON kaltura_sphinx_log.* TO '''kaltura'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kaltura_sphinx_log_SQL_FILES

for SQL in '${!DB_SQL_FILES}'

mysql -hlocalhost -uroot -pRev2004 -P3306 kaltura_sphinx_log

for DB in '$DBS'

echo 'CREATE DATABASE kalturadw;'
CREATE DATABASE kalturadw;

echo 'CREATE DATABASE kalturadw;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturadw_PRIVILEGES

DB_USER=kalturadw_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturadw_SQL_FILES

for DB in '$DBS'

echo 'CREATE DATABASE kalturadw_ds;'
CREATE DATABASE kalturadw_ds;

echo 'CREATE DATABASE kalturadw_ds;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturadw_ds_PRIVILEGES

DB_USER=kalturadw_ds_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw_ds.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturadw_ds_SQL_FILES

for DB in '$DBS'

echo 'CREATE DATABASE kalturadw_bisources;'
CREATE DATABASE kalturadw_bisources;

echo 'CREATE DATABASE kalturadw_bisources;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturadw_bisources_PRIVILEGES

DB_USER=kalturadw_bisources_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,EXECUTE ON kalturadw_bisources.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturadw_bisources_SQL_FILES

for DB in '$DBS'

echo 'CREATE DATABASE kalturalog;'
CREATE DATABASE kalturalog;

echo 'CREATE DATABASE kalturalog;'

mysql -hlocalhost -uroot -pRev2004 -P3306

PRIVS=kalturalog_PRIVILEGES

DB_USER=kalturalog_USER

echo 'GRANT INSERT,UPDATE,DELETE,SELECT,LOCK TABLES ON kalturalog.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

DB_SQL_FILES=kalturalog_SQL_FILES

echo 'GRANT SELECT ON kaltura.* TO '''etl'''@'''%''';FLUSH PRIVILEGES;'

mysql -hlocalhost -uroot -pRev2004 -P3306

set +e

echo 'Checking connectivity to needed daemons...'
Checking connectivity to needed daemons...

check_connectivity kaltura 6fSMRQN9OmeutWZ 127.0.0.1 3306 127.0.0.1 http://streamer.eurotvguild.com:80

DB_USER=kaltura

DB_PASSWD=6fSMRQN9OmeutWZ

DB_HOST=127.0.0.1

DB_PORT=3306

SPHINX_SERVER=127.0.0.1

SERVICE_URL=http://streamer.eurotvguild.com:80

RC=0

MSG='Connectivity test passed:)'

echo 'select version();'

mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306 -N

'[' 1 -ne 0 ']'

MSG='Couldn'''t connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.'

RC=1

echo 'show tables;'

mysql -h127.0.0.1 -P9312

'[' 0 -ne 0 ']'

curl 'http://streamer.eurotvguild.com:80/api_v3/index.php?service=system&action=ping' -k

'[' 0 -ne 0 ']'

echo -en 'Couldn'''t connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.\n'
Couldn't connect with mysql -ukaltura -p6fSMRQN9OmeutWZ -h127.0.0.1 -P3306.

return 1

echo 'Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.'
Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.

exit 6

On 18 Mar 2014, at 08:20, Jess Portnoy notifications@github.com wrote:

bash -x /opt/kaltura/bin/kaltura-db-config.sh

?
Reply to this email directly or view it on

GitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDc2NDE4MCwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--d8e5f9385798384a401c1c096eb5b41cf9b11004.gif]

?
Reply to this email directly or view it on GitHub.

—
Reply to this email directly or view it on
GitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDc2NTU1MiwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--b9e2b8afe7e123d3d7d67481ce0c454d60586b60.gif]

nzimas · 2014-03-18T14:16:43Z

The second issue i have reported (unrelated to the main one) has been addressed by running
mysql_secure_installation
once again.

jessp01 · 2014-03-18T14:19:19Z

Thank you.
We will add sample output to what the mysql_secure_installation should
output and how the mysql.user table should look afterwards, hopefully it
will help others.

May the source be with you,

Jess Portnoy

Join us for Kaltura Connect 2014, June 17-18, NYC. Register today!
http://bit.ly/kconnect14-emailsig

On Tue, 18 Mar 2014, nzimas wrote:

The second issue i have reported (unrelated to the main one) has been addressed by running
mysql_secure_installation
once again.

—
Reply to this email directly or view it on
GitHub.[5270205__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcxMDc3MTQwNSwiZGF0YSI6eyJpZCI6Mjc3NTEwNTN9fQ==--1e2ee8e1bfddc2693c9dcac0930c3c272e03debb.gif]

kimsymmons · 2014-05-27T17:50:49Z

Hello,

I am having the same issues here. After running,
bash -x /opt/kaltura/bin/kaltura-db-config.sh

Please see output result below:

echo -en '\033[1;31mERROR: Couldn'''t connect with mysql -ukaltura -pMMsCgORVYWzrUTJ -h127.0.0.1 -P3306.\033[m\n'
ERROR: Couldn't connect with mysql -ukaltura -pMMsCgORVYWzrUTJ -h127.0.0.1 -P3306.
return 1
echo -e '\033[1;31mPlease check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.\033[m'
Please check your setup and then run /opt/kaltura/bin/kaltura-db-config.sh again.
exit 6

@nzimas did you arrive at a solution to this problem?

Any help would be most appreciated. I had also granted complete rights to the Kaltura sql user to no avail.

Many thanks,

Kim

nzimas closed this as completed Mar 18, 2014

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

error in monit.conf - line 23 #75

error in monit.conf - line 23 #75

nzimas commented Mar 14, 2014

jessp01 commented Mar 15, 2014

nzimas commented Mar 15, 2014

jessp01 commented Mar 16, 2014

nzimas commented Mar 16, 2014

jessp01 commented Mar 17, 2014

nzimas commented Mar 17, 2014

KalturaCommunity-zz commented Mar 17, 2014

nzimas commented Mar 17, 2014

jessp01 commented Mar 17, 2014

nzimas commented Mar 17, 2014

jessp01 commented Mar 17, 2014

nzimas commented Mar 17, 2014

nzimas commented Mar 17, 2014

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

jessp01 commented Mar 18, 2014

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

+ echo '

nzimas commented Mar 18, 2014

jessp01 commented Mar 18, 2014

nzimas commented Mar 18, 2014

jessp01 commented Mar 18, 2014

nzimas commented Mar 18, 2014

jessp01 commented Mar 18, 2014

kimsymmons commented May 27, 2014

error in monit.conf - line 23 #75

error in monit.conf - line 23 #75

Comments

nzimas commented Mar 14, 2014

jessp01 commented Mar 15, 2014

yum clean all

yum update "kaltura"

kaltura-config-all.sh

nzimas commented Mar 15, 2014

jessp01 commented Mar 16, 2014

rpm -q kaltura-monit

rpm -q kaltura-base

nzimas commented Mar 16, 2014

jessp01 commented Mar 17, 2014

nzimas commented Mar 17, 2014

KalturaCommunity-zz commented Mar 17, 2014

nzimas commented Mar 17, 2014

jessp01 commented Mar 17, 2014

. /etc/kaltura.d/system.ini

mysql -h$DB1_HOST -u$DB1_USER -p$DB1_PASS kaltura

nzimas commented Mar 17, 2014

jessp01 commented Mar 17, 2014

nzimas commented Mar 17, 2014

nzimas commented Mar 17, 2014

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

+ echo '

jessp01 commented Mar 18, 2014

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

rm /opt/kaltura/app/base-config.lock

/bin/kaltura-base-config.sh

+ echo '

nzimas commented Mar 18, 2014

jessp01 commented Mar 18, 2014

nzimas commented Mar 18, 2014

jessp01 commented Mar 18, 2014

nzimas commented Mar 18, 2014

jessp01 commented Mar 18, 2014

kimsymmons commented May 27, 2014