Installation fails with message: "we failed on something else.." #413

dasj19 · 2015-06-17T11:03:18Z

Hello I have been trying to install kaltura but it fails every time I try to install it on a CentOS 6.6 server

Here are the last lines of the installation script (/opt/kaltura/bin/kaltura-config-all.sh):

Checking MySQL version..
Warning: Using a password on the command line interface can be insecure.
Ver 5.6.25 found compatible
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.

CREATE USER kaltura;
Warning: Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'plugin' in 'mysql.user'

    Archving logs to /opt/kaltura/log/log_17_06_15_12_59.tar.gz...

ERROR: we failed on something else..

The text was updated successfully, but these errors were encountered:

jessp01 · 2015-06-17T11:05:57Z

Hello,

What MySQL version are you using?
Also, if higher than 5.5, can you try to disable strict mode and try
again?
https://support.realtyna.com/index.php?/Knowledgebase/Article/View/535/0/how-can-i-turn-off-mysql-strict-mode

In order to try again, first drop the existing data and 'kaltura' user and
then rerun kaltura-db-config.sh.

Thanks,

May the source be with you,

Jess Portnoy

Join us for the Kaltura Connect Virtual Summits 2015 - Register now!
virtualconnect.kaltura.com

On Wed, 17 Jun 2015, dasj19 wrote:

Hello I have been trying to install kaltura but it fails every time I try to install it on a CentOS 6.6 server

Here are the last lines of the installation script (/opt/kaltura/bin/kaltura-config-all.sh):

Checking MySQL version..
Warning: Using a password on the command line interface can be insecure.
Ver 5.6.25 found compatible
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.

CREATE USER kaltura;
Warning: Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'plugin' in 'mysql.user'
Archving logs to /opt/kaltura/log/log_17_06_15_12_59.tar.gz...
ERROR: we failed on something else..

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

dasj19 · 2015-06-17T11:30:56Z

Hello,

Thanks for very fast reply.

Indeed the MySQL version is 5.6.26. I disabled the strict mode and ran kaltura-db-config.sh and the output is the same as before:

calling upgrade script instead.
Checking MySQL version..
Warning: Using a password on the command line interface can be insecure.
Ver 5.6.25 found compatible
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.

CREATE USER kaltura;
Warning: Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'plugin' in 'mysql.user'

    Archving logs to /opt/kaltura/log/log_17_06_15_13_28.tar.gz...

kaltura-hooks · 2015-06-17T11:33:13Z

Hi @dasj19,

Thank for you reporting an issue and helping improve Kaltura!

To get the fastest response time, and help the maintainers review and test your reported issues or suggestions, please ensure that your issue includes the following (please comment with more info if you have not included all this info in your original issue):

Is the issue you're experiencing consistent and across platforms? or does it only happens on certain conditions?
please provide as much details as possible.
Which Kaltura deployment you're using: Kaltura SaaS, or self-hosted?
If self hosted, are you using the RPM or deb install?
Packages installed.
When using RPM, paste the output for:

    # rpm -qa "kaltura*"

For deb based systems:

    # dpkg -l "kaltura-*"

If running a self hosted ENV - is this a single all in 1 server or a cluster?
If running a self hosted ENV, while making the problematic request, run:

    # tail -f /opt/kaltura/log/*.log /opt/kaltura/log/batch/*.log | grep -A 1 -B 1 --color "ERR:\|PHP\|trace\|CRIT\|\[error\]"

and paste the output.

When relevant, provide any screenshots or screen recordings showing the issue you're experiencing.

For general troubleshooting see:
https://github.com/kaltura/platform-install-packages/blob/Jupiter-10.13.0/doc/kaltura-packages-faq.md#troubleshooting-help

If you only have a general question rather than a bug report, please close this issue and post at:
http://forum.kaltura.org

Thank you in advance,

jessp01 · 2015-06-17T11:34:34Z

Can you run the db-config script with bash -x like so:
bash -x /opt/kaltura/bin/kaltura-db-config.sh
so we can see exactly what commands fails?

Please mask the passwd when pasting the output.

May the source be with you,

Jess Portnoy

Join us for the Kaltura Connect Virtual Summits 2015 - Register now!
virtualconnect.kaltura.com

On Wed, 17 Jun 2015, dasj19 wrote:

Hello,
Indeed the MySQL version is 5.6.26. I disabled the strict mode and ran kaltura-db-config.sh and the output is the same as
before:

calling upgrade script instead.
Checking MySQL version..
Warning: Using a password on the command line interface can be insecure.
Ver 5.6.25 found compatible
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.

CREATE USER kaltura;
Warning: Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'plugin' in 'mysql.user'
Archving logs to /opt/kaltura/log/log_17_06_15_13_28.tar.gz...
—
Reply to this email directly or view it on GitHub.[AFBqvV1kB7_Ce_jxqbHc03xmG5T3-msXks5oUVHygaJpZM4FFP24.gif]

dasj19 · 2015-06-17T11:39:52Z

okay, here is the output (replaced the password with *** characters):

++ 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=da****tist.dk
+++ ADMIN_CONSOLE_ADMIN_MAIL=da**tist.dk
+++ DB1_HOST=127.0.0.1
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=cXo572z52QSy1VM
+++ DWH_HOST=127.0.0.1
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=cXo572z52QSy1VM
+++ SERVICE_URL=http://medieadmin.adventist.dk:80
+++ SPHINX_HOST=127.0.0.1
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=**********
+++ KALTURA_VIRTUAL_HOST_NAME=**********
+++ RED5_HOST=medieadmin.adventist.dk
+++ dirname /opt/kaltura/bin/kaltura-db-config.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh
++ '[' -r /opt/kaltura/bin/colors.sh ']'
++ . /opt/kaltura/bin/colors.sh
+++ DULL=0
+++ BRIGHT=1
+++ FG_BLACK=30
+++ FG_RED=31
+++ FG_GREEN=32
+++ FG_YELLOW=33
+++ FG_BLUE=34
+++ FG_VIOLET=35
+++ FG_CYAN=36
+++ FG_WHITE=37
+++ FG_NULL=00
+++ BG_BLACK=40
+++ BG_RED=41
+++ BG_GREEN=42
+++ BG_YELLOW=43
+++ BG_BLUE=44
+++ BG_VIOLET=45
+++ BG_CYAN=46
+++ BG_WHITE=47
+++ BG_NULL=00
+++ ETCOLOR_ERROR='\033[1;31m'
+++ ESC='\033'
+++ NORMAL='\033[m'
+++ RESET='\033[0;37;00m'
+++ BLACK='\033[0;30m'
+++ RED='\033[0;31m'
+++ GREEN='\033[0;32m'
+++ YELLOW='\033[0;33m'
+++ BLUE='\033[0;34m'
+++ VIOLET='\033[0;35m'
+++ CYAN='\033[0;36m'
+++ WHITE='\033[0;37m'
+++ BRIGHT_BLACK='\033[1;30m'
+++ BRIGHT_RED='\033[1;31m'
+++ BRIGHT_GREEN='\033[1;32m'
+++ BRIGHT_YELLOW='\033[1;33m'
+++ BRIGHT_BLUE='\033[1;34m'
+++ BRIGHT_VIOLET='\033[1;35m'
+++ BRIGHT_CYAN='\033[1;36m'
+++ BRIGHT_WHITE='\033[1;37m'
+++ REV_CYAN='\033[0;47;46m'
+++ REV_RED='\033[0;33; 41m'
+++ JESS='Jess likes this one :)'
++ '[' -r /etc/sysconfig/clock ']'
++ . /etc/sysconfig/clock
+++ ZONE=Europe/Berlin
++ '[' -r /opt/kaltura/app/configurations/consent_msgs ']'
++ . /opt/kaltura/app/configurations/consent_msgs
+++ PRE_CONSENT='To improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded and more stable platform and services.
This information helps us understand what problems users encounter when using Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .
By allowing Kaltura to collect data about your installation, we may be able provide more effective assistance in the event that you encounter an installation issue.
To allow Kaltura to track and analyze QA and support information, please enter your email. Type NO to disallow:'
+++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .'
++ CONSENT_FILE=/opt/kaltura/bin/contact.rc
++ SPHINX_DAEMON=kaltura-sphinx
++ BATCH_DAEMON=kaltura-batch
++ MEMCACHE_DAEMON=memcached
+++ lsb_release -i -s
++ DISTRO=CentOS
++ '[' CentOS = Ubuntu -o CentOS = Debian ']'
++ APACHE_DAEMON=httpd
++ MYSQL_DAEMON=mysqld
++ MONIT_DAEMON=kaltura-monit
++ INIT_CONFIG_UTIL=chkconfig
++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch kaltura-monit memcached'
++ PACKAGE_TYPE=rpm
++ QUERY_COMMAND='rpm -q'
++ MAIL_LOG=/var/log/maillog
++ 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
++ ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report
++ NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php
++ NEWSLETTER_MSG='
To keep up with the bi-weekly Kaltura releases, and stay up to date with
the latest news, security and bug updates, and connect with the global
Kaltura community - sign up for our regular Kaltura Community updates.
Please enter your email to sign up, or enter NO to pass.
'
'[' 5 -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=da****tist.dk
++ ADMIN_CONSOLE_ADMIN_MAIL=da**tist.dk
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=cXo572z52QSy1VM
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=cXo572z52QSy1VM
++ SERVICE_URL=http://medieadmin.adventist.dk:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=*********
++ KALTURA_VIRTUAL_HOST_NAME=************
++ RED5_HOST=***************
++ 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,ALTER,CREATE,DROP
++ 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=da****tist.dk
+++ ADMIN_CONSOLE_ADMIN_MAIL=da**tist.dk
+++ DB1_HOST=127.0.0.1
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=cXo572z52QSy1VM
+++ DWH_HOST=127.0.0.1
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=cXo572z52QSy1VM
+++ SERVICE_URL=http://medieadmin.adventist.dk:80
+++ SPHINX_HOST=127.0.0.1
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=******
+++ KALTURA_VIRTUAL_HOST_NAME=*************
+++ RED5_HOST=**************
+++ dirname /opt/kaltura/bin/kaltura-db-config.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh
++ '[' -r /opt/kaltura/bin/colors.sh ']'
++ . /opt/kaltura/bin/colors.sh
+++ DULL=0
+++ BRIGHT=1
+++ FG_BLACK=30
+++ FG_RED=31
+++ FG_GREEN=32
+++ FG_YELLOW=33
+++ FG_BLUE=34
+++ FG_VIOLET=35
+++ FG_CYAN=36
+++ FG_WHITE=37
+++ FG_NULL=00
+++ BG_BLACK=40
+++ BG_RED=41
+++ BG_GREEN=42
+++ BG_YELLOW=43
+++ BG_BLUE=44
+++ BG_VIOLET=45
+++ BG_CYAN=46
+++ BG_WHITE=47
+++ BG_NULL=00
+++ ETCOLOR_ERROR='\033[1;31m'
+++ ESC='\033'
+++ NORMAL='\033[m'
+++ RESET='\033[0;37;00m'
+++ BLACK='\033[0;30m'
+++ RED='\033[0;31m'
+++ GREEN='\033[0;32m'
+++ YELLOW='\033[0;33m'
+++ BLUE='\033[0;34m'
+++ VIOLET='\033[0;35m'
+++ CYAN='\033[0;36m'
+++ WHITE='\033[0;37m'
+++ BRIGHT_BLACK='\033[1;30m'
+++ BRIGHT_RED='\033[1;31m'
+++ BRIGHT_GREEN='\033[1;32m'
+++ BRIGHT_YELLOW='\033[1;33m'
+++ BRIGHT_BLUE='\033[1;34m'
+++ BRIGHT_VIOLET='\033[1;35m'
+++ BRIGHT_CYAN='\033[1;36m'
+++ BRIGHT_WHITE='\033[1;37m'
+++ REV_CYAN='\033[0;47;46m'
+++ REV_RED='\033[0;33; 41m'
+++ JESS='Jess likes this one :)'
++ '[' -r /etc/sysconfig/clock ']'
++ . /etc/sysconfig/clock
+++ ZONE=Europe/Berlin
++ '[' -r /opt/kaltura/app/configurations/consent_msgs ']'
++ . /opt/kaltura/app/configurations/consent_msgs
+++ PRE_CONSENT='To improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded and more stable platform and services.
This information helps us understand what problems users encounter when using Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .
By allowing Kaltura to collect data about your installation, we may be able provide more effective assistance in the event that you encounter an installation issue.
To allow Kaltura to track and analyze QA and support information, please enter your email. Type NO to disallow:'
+++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .'
++ CONSENT_FILE=/opt/kaltura/bin/contact.rc
++ SPHINX_DAEMON=kaltura-sphinx
++ BATCH_DAEMON=kaltura-batch
++ MEMCACHE_DAEMON=memcached
+++ lsb_release -i -s
++ DISTRO=CentOS
++ '[' CentOS = Ubuntu -o CentOS = Debian ']'
++ APACHE_DAEMON=httpd
++ MYSQL_DAEMON=mysqld
++ MONIT_DAEMON=kaltura-monit
++ INIT_CONFIG_UTIL=chkconfig
++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch kaltura-monit memcached'
++ PACKAGE_TYPE=rpm
++ QUERY_COMMAND='rpm -q'
++ MAIL_LOG=/var/log/maillog
++ 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
++ ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report
++ NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php
++ NEWSLETTER_MSG='
To keep up with the bi-weekly Kaltura releases, and stay up to date with
the latest news, security and bug updates, and connect with the global
Kaltura community - sign up for our regular Kaltura Community updates.
Please enter your email to sign up, or enter NO to pass.
'
trap 'my_trap_handler "${LINENO}" ${$?}' ERR
++ basename /opt/kaltura/bin/kaltura-db-config.sh
send_install_becon kaltura-db-config.sh Europe/Berlin install_start 0
trap - ERR
'[' -r /opt/kaltura/bin/contact.rc ']'
. /opt/kaltura/bin/contact.rc
++ USER_CONSENT=0
'[' -z 0 -o 0 = 0 ']'
return 0
MYSQL_HOST=localhost
MYSQL_SUPER_USER=root
MYSQL_SUPER_USER_PASSWD=***************
MYSQL_PORT=3306
IS_UPGRADE=upgrade
'[' upgrade = upgrade ']'
echo 'calling upgrade script instead.'
calling upgrade script instead.
KALTURA_DB=kaltura
echo -e '\033[0;36mChecking MySQL version..\033[m'
Checking MySQL version..
++ echo 'select version();'
++ mysql -hlocalhost -uroot -p********* -P3306 -N
Warning: Using a password on the command line interface can be insecure.
MYVER=5.6.25
++ echo 5.6.25
++ awk -F . '{print $1}'
MYMAJVER=5
++ echo 5.6.25
++ awk -F . '{print $2}'
MYMINORVER=6
'[' 5 -ne 5 ']'
echo -e '\033[0;36mVer 5.6.25 found compatible\033[m'
Ver 5.6.25 found compatible
'[' 0 -ne 0 ']'
check_mysql_settings root ************ localhost 3306
DB_USER=root
DB_PASSWD=**************
DB_HOST=localhost
DB_PORT=3306
RC=0
++ echo 'select @@lower_case_table_names;'
++ mysql -uroot -p********* -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.
LOWER_CASE_TABLE_NAMES=1
'[' 1 -ne 1 ']'
++ echo 'select @@innodb_log_file_size;'
++ mysql -uroot -p*************** -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.
INNODB_LOG_FILE_SIZE=33554432
'[' 33554432 -lt 33554432 ']'
++ echo 'select @@max_allowed_packet;'
++ mysql -uroot -p************** -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.
MAX_ALLOWED_PACKET=16777216
'[' 16777216 -lt 16777216 ']'
echo -en '\033[1;31m\033[m\n'
return 0
trap - ERR
'[' -z '' ']'
echo 'use kaltura'
mysql -hlocalhost -uroot -p*********** -P3306 kaltura
'[' 1 -eq 0 ']'
trap 'my_trap_handler "${LINENO}" ${$?}' ERR
set -e
echo 'CREATE USER kaltura;'
CREATE USER kaltura;
echo 'CREATE USER kaltura IDENTIFIED BY '''cXo572z52QSy1VM''' ;'
mysql -hlocalhost -uroot -p************ -P3306
Warning: Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'plugin' in 'mysql.user'
++ my_trap_handler 128 23107
+++ basename /opt/kaltura/bin/kaltura-db-config.sh
++ MYSELF=kaltura-db-config.sh
++ LASTLINE=128
++ LASTERR=23107
++ '[' rpm = rpm ']'
+++ rpm -q kaltura-postinst
++ POSTINST_VER=kaltura-postinst-1.0.26-3.noarch
++ '[' -d /opt/kaltura/log ']'
+++ date +%d_%m_%y_%H_%M
++ TAR_PATH=/opt/kaltura/log/log_17_06_15_13_35.tar.gz
++ echo -en '\033[1;31m\033[m
```
'



++ echo 'Archving logs to /opt/kaltura/log/log_17_06_15_13_35.tar.gz...'
```
Archving logs to /opt/kaltura/log/log_17_06_15_13_35.tar.gz...
++ mkdir -p /tmp/tmpdir_kaltura
++ cp /opt/kaltura/log/clear_cache.log /opt/kaltura/log/cron.log /opt/kaltura/log/generate.php.log /opt/kaltura/log/kaltura_apache_access.log /opt/kaltura/log/kaltura_apache_errors.log /opt/kaltura/log/kaltura_populate.log /opt/kaltura/log/kaltura_prod.log /tmp/tmpdir_kaltura
++ cd /tmp/tmpdir_kaltura
++ tar zcf /opt/kaltura/log/log_17_06_15_13_35.tar.gz clear_cache.log cron.log generate.php.log kalt_up.log kaltura_admin.log kaltura_apache_access.log kaltura_apache_access_ssl.log kaltura_apache_errors.log kaltura_apache_errors_ssl.log kaltura_api_v3_analytics.log kaltura_api_v3.log kaltura_api_v3_tests.log kaltura_batch.log kaltura_deploy.log kaltura_populate.log kaltura_prod.log kaltura_scripts.log
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ send_install_becon kaltura-db-config.sh Europe/Berlin install_fail 128,kaltura-postinst-1.0.26-3.noarch
++ trap - ERR
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ '[' -z 0 -o 0 = 0 ']'
++ return 0
++ exit 11
You have mail in /var/spool/mail/root

jessp01 · 2015-06-17T11:45:31Z

Seems the failing command is in line 128:
128 echo "CREATE USER kaltura IDENTIFIED BY '$DB1_PASS' ;"

Can you maybe try to change to:
"CREATE USER kaltura@'%' IDENTIFIED BY '$DB1_PASS' ;"

And see if that makes a difference?

To save time, I suggest you first try manually, then remove by
mysql> drop user kaltura;

and re-run the script after editing kaltura-db-config.sh to reflect the
change.
If that is indeed the problem, do the same in line 130 for the etl user
and let me know. If it fixes it, I'll commit a fix to the code.

Thanks,

May the source be with you,

Jess Portnoy

Join us for the Kaltura Connect Virtual Summits 2015 - Register now!
virtualconnect.kaltura.com

On Wed, 17 Jun 2015, dasj19 wrote:

okay, here is the output (replaced the password with *** characters):

++ 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=daniel.serbanescu@adventist.dk +++ ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk +++
DB1_HOST=127.0.0.1 +++ DB1_NAME=kaltura +++ DB1_USER=kaltura +++ DB1_PASS=cXo572z52QSy1VM +++ DWH_HOST=127.0.0.1 +++
DWH_PORT=3306 +++ DWH_USER=etl +++ DWH_PASS=cXo572z52QSy1VM +++ SERVICE_URL=http://medieadmin.adventist.dk:80 +++
SPHINX_HOST=127.0.0.1 +++ DB1_PORT=3306 +++ SUPER_USER=root +++ SUPER_USER_PASSWD=*** +++
KALTURA_VIRTUAL_HOST_NAME=* +++ RED5_HOST=medieadmin.adventist.dk +++ dirname
/opt/kaltura/bin/kaltura-db-config.sh ++ COLORS_RC=/opt/kaltura/bin/colors.sh ++ '[' -r /opt/kaltura/bin/colors.sh ']'
++ . /opt/kaltura/bin/colors.sh +++ DULL=0 +++ BRIGHT=1 +++ FG_BLACK=30 +++ FG_RED=31 +++ FG_GREEN=32 +++ FG_YELLOW=33
+++ FG_BLUE=34 +++ FG_VIOLET=35 +++ FG_CYAN=36 +++ FG_WHITE=37 +++ FG_NULL=00 +++ BG_BLACK=40 +++ BG_RED=41 +++
BG_GREEN=42 +++ BG_YELLOW=43 +++ BG_BLUE=44 +++ BG_VIOLET=45 +++ BG_CYAN=46 +++ BG_WHITE=47 +++ BG_NULL=00 +++
ETCOLOR_ERROR='\033[1;31m' +++ ESC='\033' +++ NORMAL='\033[m' +++ RESET='\033[0;37;00m' +++ BLACK='\033[0;30m' +++
RED='\033[0;31m' +++ GREEN='\033[0;32m' +++ YELLOW='\033[0;33m' +++ BLUE='\033[0;34m' +++ VIOLET='\033[0;35m' +++
CYAN='\033[0;36m' +++ WHITE='\033[0;37m' +++ BRIGHT_BLACK='\033[1;30m' +++ BRIGHT_RED='\033[1;31m' +++
BRIGHT_GREEN='\033[1;32m' +++ BRIGHT_YELLOW='\033[1;33m' +++ BRIGHT_BLUE='\033[1;34m' +++ BRIGHT_VIOLET='\033[1;35m'
+++ BRIGHT_CYAN='\033[1;36m' +++ BRIGHT_WHITE='\033[1;37m' +++ REV_CYAN='\033[0;47;46m' +++ REV_RED='\033[0;33; 41m'
+++ JESS='Jess likes this one :)' ++ '[' -r /etc/sysconfig/clock ']' ++ . /etc/sysconfig/clock +++ ZONE=Europe/Berlin
++ '[' -r /opt/kaltura/app/configurations/consent_msgs ']' ++ . /opt/kaltura/app/configurations/consent_msgs +++
PRE_CONSENT='To improve your Kaltura experience and provide you with the best service, Kaltura would like your consent
to collect necessary data and information regarding your installation and use of Kaltura and analyze it to provide an
upgraded and more stable platform and services. This information helps us understand what problems users encounter
when using Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review
what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ . By allowing Kaltura to
collect data about your installation, we may be able provide more effective assistance in the event that you encounter
an installation issue. To allow Kaltura to track and analyze QA and support information, please enter your email. Type
NO to disallow:' +++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being
collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .' ++ CONSENT_FILE=/opt/kaltura/bin/contact.rc ++
SPHINX_DAEMON=kaltura-sphinx ++ BATCH_DAEMON=kaltura-batch ++ MEMCACHE_DAEMON=memcached +++ lsb_release -i -s ++
DISTRO=CentOS ++ '[' CentOS = Ubuntu -o CentOS = Debian ']' ++ APACHE_DAEMON=httpd ++ MYSQL_DAEMON=mysqld ++
MONIT_DAEMON=kaltura-monit ++ INIT_CONFIG_UTIL=chkconfig ++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch
kaltura-monit memcached' ++ PACKAGE_TYPE=rpm ++ QUERY_COMMAND='rpm -q' ++ MAIL_LOG=/var/log/maillog ++
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 ++
ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report ++
NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php ++ NEWSLETTER_MSG=' To keep up with the
bi-weekly Kaltura releases, and stay up to date with the latest news, security and bug updates, and connect with the
global Kaltura community - sign up for our regular Kaltura Community updates. Please enter your email to sign up, or
enter NO to pass. '

'[' 5 -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=daniel.serbanescu@adventist.dk ++
ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk ++ DB1_HOST=127.0.0.1 ++ DB1_NAME=kaltura ++ DB1_USER=kaltura
++ DB1_PASS=cXo572z52QSy1VM ++ DWH_HOST=127.0.0.1 ++ DWH_PORT=3306 ++ DWH_USER=etl ++ DWH_PASS=cXo572z52QSy1VM ++
SERVICE_URL=http://medieadmin.adventist.dk:80 ++ SPHINX_HOST=127.0.0.1 ++ DB1_PORT=3306 ++ SUPER_USER=root ++
SUPER_USER_PASSWD=*********** ++ KALTURA_VIRTUAL_HOST_NAME=* ++ RED5_HOST=**** ++ 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,ALTER,CREATE,DROP ++
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=daniel.serbanescu@adventist.dk +++ ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk +++
DB1_HOST=127.0.0.1 +++ DB1_NAME=kaltura +++ DB1_USER=kaltura +++ DB1_PASS=cXo572z52QSy1VM +++ DWH_HOST=127.0.0.1 +++
DWH_PORT=3306 +++ DWH_USER=etl +++ DWH_PASS=cXo572z52QSy1VM +++ SERVICE_URL=http://medieadmin.adventist.dk:80 +++
SPHINX_HOST=127.0.0.1 +++ DB1_PORT=3306 +++ SUPER_USER=root +++ SUPER_USER_PASSWD=* +++
KALTURA_VIRTUAL_HOST_NAME=* +++ RED5_HOST=********* +++ dirname /opt/kaltura/bin/kaltura-db-config.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh ++ '[' -r /opt/kaltura/bin/colors.sh ']' ++ . /opt/kaltura/bin/colors.sh +++
DULL=0 +++ BRIGHT=1 +++ FG_BLACK=30 +++ FG_RED=31 +++ FG_GREEN=32 +++ FG_YELLOW=33 +++ FG_BLUE=34 +++ FG_VIOLET=35 +++
FG_CYAN=36 +++ FG_WHITE=37 +++ FG_NULL=00 +++ BG_BLACK=40 +++ BG_RED=41 +++ BG_GREEN=42 +++ BG_YELLOW=43 +++
BG_BLUE=44 +++ BG_VIOLET=45 +++ BG_CYAN=46 +++ BG_WHITE=47 +++ BG_NULL=00 +++ ETCOLOR_ERROR='\033[1;31m' +++
ESC='\033' +++ NORMAL='\033[m' +++ RESET='\033[0;37;00m' +++ BLACK='\033[0;30m' +++ RED='\033[0;31m' +++
GREEN='\033[0;32m' +++ YELLOW='\033[0;33m' +++ BLUE='\033[0;34m' +++ VIOLET='\033[0;35m' +++ CYAN='\033[0;36m' +++
WHITE='\033[0;37m' +++ BRIGHT_BLACK='\033[1;30m' +++ BRIGHT_RED='\033[1;31m' +++ BRIGHT_GREEN='\033[1;32m' +++
BRIGHT_YELLOW='\033[1;33m' +++ BRIGHT_BLUE='\033[1;34m' +++ BRIGHT_VIOLET='\033[1;35m' +++ BRIGHT_CYAN='\033[1;36m'
+++ BRIGHT_WHITE='\033[1;37m' +++ REV_CYAN='\033[0;47;46m' +++ REV_RED='\033[0;33; 41m' +++ JESS='Jess likes this one
:)' ++ '[' -r /etc/sysconfig/clock ']' ++ . /etc/sysconfig/clock +++ ZONE=Europe/Berlin ++ '[' -r
/opt/kaltura/app/configurations/consent_msgs ']' ++ . /opt/kaltura/app/configurations/consent_msgs +++ PRE_CONSENT='To
improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect
necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded
and more stable platform and services. This information helps us understand what problems users encounter when using
Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what
information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ . By allowing Kaltura to
collect data about your installation, we may be able provide more effective assistance in the event that you encounter
an installation issue. To allow Kaltura to track and analyze QA and support information, please enter your email. Type
NO to disallow:' +++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being
collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .' ++ CONSENT_FILE=/opt/kaltura/bin/contact.rc ++
SPHINX_DAEMON=kaltura-sphinx ++ BATCH_DAEMON=kaltura-batch ++ MEMCACHE_DAEMON=memcached +++ lsb_release -i -s ++
DISTRO=CentOS ++ '[' CentOS = Ubuntu -o CentOS = Debian ']' ++ APACHE_DAEMON=httpd ++ MYSQL_DAEMON=mysqld ++
MONIT_DAEMON=kaltura-monit ++ INIT_CONFIG_UTIL=chkconfig ++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch
kaltura-monit memcached' ++ PACKAGE_TYPE=rpm ++ QUERY_COMMAND='rpm -q' ++ MAIL_LOG=/var/log/maillog ++
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 ++
ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report ++
NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php ++ NEWSLETTER_MSG=' To keep up with the
bi-weekly Kaltura releases, and stay up to date with the latest news, security and bug updates, and connect with the
global Kaltura community - sign up for our regular Kaltura Community updates. Please enter your email to sign up, or
enter NO to pass. '

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

send_install_becon kaltura-db-config.sh Europe/Berlin install_start 0

trap - ERR

'[' -r /opt/kaltura/bin/contact.rc ']'

. /opt/kaltura/bin/contact.rc ++ USER_CONSENT=0

'[' -z 0 -o 0 = 0 ']'

return 0

MYSQL_HOST=localhost

MYSQL_SUPER_USER=root

MYSQL_SUPER_USER_PASSWD=***************

MYSQL_PORT=3306

IS_UPGRADE=upgrade

'[' upgrade = upgrade ']'

echo 'calling upgrade script instead.' calling upgrade script instead.

KALTURA_DB=kaltura

echo -e '\033[0;36mChecking MySQL version..\033[m' Checking MySQL version.. ++ echo 'select version();' ++ mysql
-hlocalhost -uroot -p********* -P3306 -N Warning: Using a password on the command line interface can be insecure.

MYVER=5.6.25 ++ echo 5.6.25 ++ awk -F . '{print $1}'

MYMAJVER=5 ++ echo 5.6.25 ++ awk -F . '{print $2}'

MYMINORVER=6

'[' 5 -ne 5 ']'

echo -e '\033[0;36mVer 5.6.25 found compatible\033[m' Ver 5.6.25 found compatible

'[' 0 -ne 0 ']'

check_mysql_settings root ************ localhost 3306

DB_USER=root

DB_PASSWD=**************

DB_HOST=localhost

DB_PORT=3306

RC=0 ++ echo 'select @@lower_case_table_names;' ++ mysql -uroot -p********* -hlocalhost -P3306 -N Warning: Using a
password on the command line interface can be insecure.

LOWER_CASE_TABLE_NAMES=1

'[' 1 -ne 1 ']' ++ echo 'select @@innodb_log_file_size;' ++ mysql -uroot -p*************** -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.

INNODB_LOG_FILE_SIZE=33554432

'[' 33554432 -lt 33554432 ']' ++ echo 'select @@max_allowed_packet;' ++ mysql -uroot -p************** -hlocalhost
-P3306 -N Warning: Using a password on the command line interface can be insecure.

MAX_ALLOWED_PACKET=16777216

'[' 16777216 -lt 16777216 ']'

echo -en '\033[1;31m\033[m\n'

return 0

trap - ERR

'[' -z '' ']'

echo 'use kaltura'

mysql -hlocalhost -uroot -p*********** -P3306 kaltura

'[' 1 -eq 0 ']'

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

set -e

echo 'CREATE USER kaltura;' CREATE USER kaltura;

echo 'CREATE USER kaltura IDENTIFIED BY '''cXo572z52QSy1VM''' ;'

mysql -hlocalhost -uroot -p************ -P3306
Warning: Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'plugin' in 'mysql.user'
++ my_trap_handler 128 23107
+++ basename /opt/kaltura/bin/kaltura-db-config.sh
++ MYSELF=kaltura-db-config.sh
++ LASTLINE=128
++ LASTERR=23107
++ '[' rpm = rpm ']'
+++ rpm -q kaltura-postinst
++ POSTINST_VER=kaltura-postinst-1.0.26-3.noarch
++ '[' -d /opt/kaltura/log ']'
+++ date +%d_%m_%y_%H_%M
++ TAR_PATH=/opt/kaltura/log/log_17_06_15_13_35.tar.gz
++ echo -en '\033[1;31m\033[m

'

++ echo 'Archving logs to /opt/kaltura/log/log_17_06_15_13_35.tar.gz...'
Archving logs to /opt/kaltura/log/log_17_06_15_13_35.tar.gz...
++ mkdir -p /tmp/tmpdir_kaltura
++ cp /opt/kaltura/log/clear_cache.log /opt/kaltura/log/cron.log /opt/kaltura/log/generate.php.log
/opt/kaltura/log/kaltura_apache_access.log /opt/kaltura/log/kaltura_apache_errors.log
/opt/kaltura/log/kaltura_populate.log /opt/kaltura/log/kaltura_prod.log /tmp/tmpdir_kaltura
++ cd /tmp/tmpdir_kaltura
++ tar zcf /opt/kaltura/log/log_17_06_15_13_35.tar.gz clear_cache.log cron.log generate.php.log kalt_up.log
kaltura_admin.log kaltura_apache_access.log kaltura_apache_access_ssl.log kaltura_apache_errors.log
kaltura_apache_errors_ssl.log kaltura_api_v3_analytics.log kaltura_api_v3.log kaltura_api_v3_tests.log
kaltura_batch.log kaltura_deploy.log kaltura_populate.log kaltura_prod.log kaltura_scripts.log
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ send_install_becon kaltura-db-config.sh Europe/Berlin install_fail 128,kaltura-postinst-1.0.26-3.noarch
++ trap - ERR
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ '[' -z 0 -o 0 = 0 ']'
++ return 0
++ exit 11
You have mail in /var/spool/mail/root
—
Reply to this email directly or view it on GitHub.[AFBqvTfiSegbTIVteUoxNjlMsm1A2JJ9ks5oUVQKgaJpZM4FFP24.gif]

dasj19 · 2015-06-17T17:39:39Z

Sorry for the delay, I had to fix some problems with the database.

Now after modifying the SQL strings as described above I get a new SQL error.

ERROR 1071 (42000) at line 2403: Specified key was too long; max key length is 767 bytes

here is the bash +x kaltura-db-config.sh output

[root@vmi13074 ~]# bash -x /opt/kaltura/bin/kaltura-db-config.sh localhost root ***** 3306 upgrade
++ 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=daniel.serbanescu@adventist.dk
+++ ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk
+++ DB1_HOST=127.0.0.1
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=eKep8ZiMdnSz3Di
+++ DWH_HOST=127.0.0.1
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=eKep8ZiMdnSz3Di
+++ SERVICE_URL=http://medieadmin.adventist.dk:80
+++ SPHINX_HOST=127.0.0.1
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=********
+++ KALTURA_VIRTUAL_HOST_NAME=************
+++ RED5_HOST=**************
+++ dirname /opt/kaltura/bin/kaltura-db-config.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh
++ '[' -r /opt/kaltura/bin/colors.sh ']'
++ . /opt/kaltura/bin/colors.sh
+++ DULL=0
+++ BRIGHT=1
+++ FG_BLACK=30
+++ FG_RED=31
+++ FG_GREEN=32
+++ FG_YELLOW=33
+++ FG_BLUE=34
+++ FG_VIOLET=35
+++ FG_CYAN=36
+++ FG_WHITE=37
+++ FG_NULL=00
+++ BG_BLACK=40
+++ BG_RED=41
+++ BG_GREEN=42
+++ BG_YELLOW=43
+++ BG_BLUE=44
+++ BG_VIOLET=45
+++ BG_CYAN=46
+++ BG_WHITE=47
+++ BG_NULL=00
+++ ETCOLOR_ERROR='\033[1;31m'
+++ ESC='\033'
+++ NORMAL='\033[m'
+++ RESET='\033[0;37;00m'
+++ BLACK='\033[0;30m'
+++ RED='\033[0;31m'
+++ GREEN='\033[0;32m'
+++ YELLOW='\033[0;33m'
+++ BLUE='\033[0;34m'
+++ VIOLET='\033[0;35m'
+++ CYAN='\033[0;36m'
+++ WHITE='\033[0;37m'
+++ BRIGHT_BLACK='\033[1;30m'
+++ BRIGHT_RED='\033[1;31m'
+++ BRIGHT_GREEN='\033[1;32m'
+++ BRIGHT_YELLOW='\033[1;33m'
+++ BRIGHT_BLUE='\033[1;34m'
+++ BRIGHT_VIOLET='\033[1;35m'
+++ BRIGHT_CYAN='\033[1;36m'
+++ BRIGHT_WHITE='\033[1;37m'
+++ REV_CYAN='\033[0;47;46m'
+++ REV_RED='\033[0;33; 41m'
+++ JESS='Jess likes this one :)'
++ '[' -r /etc/sysconfig/clock ']'
++ . /etc/sysconfig/clock
+++ ZONE=Europe/Berlin
++ '[' -r /opt/kaltura/app/configurations/consent_msgs ']'
++ . /opt/kaltura/app/configurations/consent_msgs
+++ PRE_CONSENT='To improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded and more stable platform and services.
This information helps us understand what problems users encounter when using Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .
By allowing Kaltura to collect data about your installation, we may be able provide more effective assistance in the event that you encounter an installation issue.
To allow Kaltura to track and analyze QA and support information, please enter your email. Type NO to disallow:'
+++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .'
++ CONSENT_FILE=/opt/kaltura/bin/contact.rc
++ SPHINX_DAEMON=kaltura-sphinx
++ BATCH_DAEMON=kaltura-batch
++ MEMCACHE_DAEMON=memcached
+++ lsb_release -i -s
++ DISTRO=CentOS
++ '[' CentOS = Ubuntu -o CentOS = Debian ']'
++ APACHE_DAEMON=httpd
++ MYSQL_DAEMON=mysqld
++ MONIT_DAEMON=kaltura-monit
++ INIT_CONFIG_UTIL=chkconfig
++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch kaltura-monit memcached'
++ PACKAGE_TYPE=rpm
++ QUERY_COMMAND='rpm -q'
++ MAIL_LOG=/var/log/maillog
++ 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
++ ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report
++ NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php
++ NEWSLETTER_MSG='
To keep up with the bi-weekly Kaltura releases, and stay up to date with
the latest news, security and bug updates, and connect with the global
Kaltura community - sign up for our regular Kaltura Community updates.
Please enter your email to sign up, or enter NO to pass.
'
'[' 5 -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=daniel.serbanescu@adventist.dk
++ ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk
++ DB1_HOST=127.0.0.1
++ DB1_NAME=kaltura
++ DB1_USER=kaltura
++ DB1_PASS=eKep8ZiMdnSz3Di
++ DWH_HOST=127.0.0.1
++ DWH_PORT=3306
++ DWH_USER=etl
++ DWH_PASS=eKep8ZiMdnSz3Di
++ SERVICE_URL=http://medieadmin.adventist.dk:80
++ SPHINX_HOST=127.0.0.1
++ DB1_PORT=3306
++ SUPER_USER=root
++ SUPER_USER_PASSWD=*************
++ KALTURA_VIRTUAL_HOST_NAME=*********
++ RED5_HOST=***************
++ 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,ALTER,CREATE,DROP
++ 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=daniel.serbanescu@adventist.dk
+++ ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk
+++ DB1_HOST=127.0.0.1
+++ DB1_NAME=kaltura
+++ DB1_USER=kaltura
+++ DB1_PASS=eKep8ZiMdnSz3Di
+++ DWH_HOST=127.0.0.1
+++ DWH_PORT=3306
+++ DWH_USER=etl
+++ DWH_PASS=eKep8ZiMdnSz3Di
+++ SERVICE_URL=http://medieadmin.adventist.dk:80
+++ SPHINX_HOST=127.0.0.1
+++ DB1_PORT=3306
+++ SUPER_USER=root
+++ SUPER_USER_PASSWD=**********
+++ KALTURA_VIRTUAL_HOST_NAME=**********
+++ RED5_HOST=*************
+++ dirname /opt/kaltura/bin/kaltura-db-config.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh
++ '[' -r /opt/kaltura/bin/colors.sh ']'
++ . /opt/kaltura/bin/colors.sh
+++ DULL=0
+++ BRIGHT=1
+++ FG_BLACK=30
+++ FG_RED=31
+++ FG_GREEN=32
+++ FG_YELLOW=33
+++ FG_BLUE=34
+++ FG_VIOLET=35
+++ FG_CYAN=36
+++ FG_WHITE=37
+++ FG_NULL=00
+++ BG_BLACK=40
+++ BG_RED=41
+++ BG_GREEN=42
+++ BG_YELLOW=43
+++ BG_BLUE=44
+++ BG_VIOLET=45
+++ BG_CYAN=46
+++ BG_WHITE=47
+++ BG_NULL=00
+++ ETCOLOR_ERROR='\033[1;31m'
+++ ESC='\033'
+++ NORMAL='\033[m'
+++ RESET='\033[0;37;00m'
+++ BLACK='\033[0;30m'
+++ RED='\033[0;31m'
+++ GREEN='\033[0;32m'
+++ YELLOW='\033[0;33m'
+++ BLUE='\033[0;34m'
+++ VIOLET='\033[0;35m'
+++ CYAN='\033[0;36m'
+++ WHITE='\033[0;37m'
+++ BRIGHT_BLACK='\033[1;30m'
+++ BRIGHT_RED='\033[1;31m'
+++ BRIGHT_GREEN='\033[1;32m'
+++ BRIGHT_YELLOW='\033[1;33m'
+++ BRIGHT_BLUE='\033[1;34m'
+++ BRIGHT_VIOLET='\033[1;35m'
+++ BRIGHT_CYAN='\033[1;36m'
+++ BRIGHT_WHITE='\033[1;37m'
+++ REV_CYAN='\033[0;47;46m'
+++ REV_RED='\033[0;33; 41m'
+++ JESS='Jess likes this one :)'
++ '[' -r /etc/sysconfig/clock ']'
++ . /etc/sysconfig/clock
+++ ZONE=Europe/Berlin
++ '[' -r /opt/kaltura/app/configurations/consent_msgs ']'
++ . /opt/kaltura/app/configurations/consent_msgs
+++ PRE_CONSENT='To improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded and more stable platform and services.
This information helps us understand what problems users encounter when using Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .
By allowing Kaltura to collect data about your installation, we may be able provide more effective assistance in the event that you encounter an installation issue.
To allow Kaltura to track and analyze QA and support information, please enter your email. Type NO to disallow:'
+++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .'
++ CONSENT_FILE=/opt/kaltura/bin/contact.rc
++ SPHINX_DAEMON=kaltura-sphinx
++ BATCH_DAEMON=kaltura-batch
++ MEMCACHE_DAEMON=memcached
+++ lsb_release -i -s
++ DISTRO=CentOS
++ '[' CentOS = Ubuntu -o CentOS = Debian ']'
++ APACHE_DAEMON=httpd
++ MYSQL_DAEMON=mysqld
++ MONIT_DAEMON=kaltura-monit
++ INIT_CONFIG_UTIL=chkconfig
++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch kaltura-monit memcached'
++ PACKAGE_TYPE=rpm
++ QUERY_COMMAND='rpm -q'
++ MAIL_LOG=/var/log/maillog
++ 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
++ ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report
++ NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php
++ NEWSLETTER_MSG='
To keep up with the bi-weekly Kaltura releases, and stay up to date with
the latest news, security and bug updates, and connect with the global
Kaltura community - sign up for our regular Kaltura Community updates.
Please enter your email to sign up, or enter NO to pass.
'
trap 'my_trap_handler "${LINENO}" ${$?}' ERR
++ basename /opt/kaltura/bin/kaltura-db-config.sh
send_install_becon kaltura-db-config.sh Europe/Berlin install_start 0
trap - ERR
'[' -r /opt/kaltura/bin/contact.rc ']'
. /opt/kaltura/bin/contact.rc
++ USER_CONSENT=0
'[' -z 0 -o 0 = 0 ']'
return 0
MYSQL_HOST=localhost
MYSQL_SUPER_USER=root
MYSQL_SUPER_USER_PASSWD=*********
MYSQL_PORT=3306
IS_UPGRADE=upgrade
'[' upgrade = upgrade ']'
echo 'calling upgrade script instead.'
calling upgrade script instead.
KALTURA_DB=kaltura
echo -e '\033[0;36mChecking MySQL version..\033[m'
Checking MySQL version..
++ echo 'select version();'
++ mysql -hlocalhost -uroot -p******* -P3306 -N
Warning: Using a password on the command line interface can be insecure.
MYVER=5.6.25
++ echo 5.6.25
++ awk -F . '{print $1}'
MYMAJVER=5
++ echo 5.6.25
++ awk -F . '{print $2}'
MYMINORVER=6
'[' 5 -ne 5 ']'
echo -e '\033[0;36mVer 5.6.25 found compatible\033[m'
Ver 5.6.25 found compatible
'[' 0 -ne 0 ']'
check_mysql_settings root ********* localhost 3306
DB_USER=root
DB_PASSWD=*******
DB_HOST=localhost
DB_PORT=3306
RC=0
++ echo 'select @@lower_case_table_names;'
++ mysql -uroot -p******* -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.
LOWER_CASE_TABLE_NAMES=1
'[' 1 -ne 1 ']'
++ echo 'select @@innodb_log_file_size;'
++ mysql -uroot -p***** -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.
INNODB_LOG_FILE_SIZE=33554432
'[' 33554432 -lt 33554432 ']'
++ echo 'select @@max_allowed_packet;'
++ mysql -uroot -p******* -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.
MAX_ALLOWED_PACKET=16777216
'[' 16777216 -lt 16777216 ']'
echo -en '\033[1;31m\033[m\n'
return 0
trap - ERR
'[' -z '' ']'
echo 'use kaltura'
mysql -hlocalhost -uroot -p***** -P3306 kaltura
'[' 1 -eq 0 ']'
trap 'my_trap_handler "${LINENO}" ${$?}' ERR
set -e
echo 'CREATE USER kaltura@'''%''';'
CREATE USER kaltura@'%';
echo 'CREATE USER kaltura@'''%''' IDENTIFIED BY '''eKep8ZiMdnSz3Di''' ;'
mysql -hlocalhost -uroot -p******** -P3306
Warning: Using a password on the command line interface can be insecure.
echo 'CREATE USER etl@'''%''';'
CREATE USER etl@'%';
echo 'CREATE USER etl@'''%''' IDENTIFIED BY '''eKep8ZiMdnSz3Di''' ;'
mysql -hlocalhost -uroot -p ******** -P3306
Warning: Using a password on the command line interface can be insecure.
for DB in '$DBS'
echo 'CREATE DATABASE kaltura;'
CREATE DATABASE kaltura;
echo 'CREATE DATABASE kaltura;'
mysql -hlocalhost -uroot -p ****** -P3306
Warning: Using a password on the command line interface can be insecure.
PRIVS=kaltura_PRIVILEGES
DB_USER=kaltura_USER
echo 'GRANT INSERT,UPDATE,DELETE,SELECT,ALTER,CREATE,DROP ON kaltura.* TO '''kaltura'''@'''%''';FLUSH PRIVILEGES;'
mysql -hlocalhost -uroot -p************ -P3306
Warning: Using a password on the command line interface can be insecure.
DB_SQL_FILES=kaltura_SQL_FILES
for SQL in '${!DB_SQL_FILES}'
mysql -hlocalhost -uroot -p ********** -P3306 kaltura
Warning: Using a password on the command line interface can be insecure.
ERROR 1071 (42000) at line 2403: Specified key was too long; max key length is 767 bytes
++ my_trap_handler 143 6084
+++ basename /opt/kaltura/bin/kaltura-db-config.sh
++ MYSELF=kaltura-db-config.sh
++ LASTLINE=143
++ LASTERR=6084
++ '[' rpm = rpm ']'
+++ rpm -q kaltura-postinst
++ POSTINST_VER=kaltura-postinst-1.0.26-3.noarch
++ '[' -d /opt/kaltura/log ']'
+++ date +%d_%m_%y_%H_%M
++ TAR_PATH=/opt/kaltura/log/log_17_06_15_19_31.tar.gz
++ echo -en '\033[1;31m\033[m
```
'



++ echo 'Archving logs to /opt/kaltura/log/log_17_06_15_19_31.tar.gz...'
```
Archving logs to /opt/kaltura/log/log_17_06_15_19_31.tar.gz...
++ mkdir -p /tmp/tmpdir_kaltura
++ cp /opt/kaltura/log/clear_cache.log /opt/kaltura/log/cron.log /opt/kaltura/log/generate.php.log /opt/kaltura/log/kaltura_apache_access.log /opt/kaltura/log/kaltura_apache_errors.log /opt/kaltura/log/kaltura_populate.log /tmp/tmpdir_kaltura
++ cd /tmp/tmpdir_kaltura
++ tar zcf /opt/kaltura/log/log_17_06_15_19_31.tar.gz clear_cache.log cron.log generate.php.log kalt_up.log kaltura_admin.log kaltura_apache_access.log kaltura_apache_access_ssl.log kaltura_apache_errors.log kaltura_apache_errors_ssl.log kaltura_api_v3_analytics.log kaltura_api_v3.log kaltura_api_v3_tests.log kaltura_batch.log kaltura_deploy.log kaltura_populate.log kaltura_prod.log kaltura_scripts.log
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ send_install_becon kaltura-db-config.sh Europe/Berlin install_fail 143,kaltura-postinst-1.0.26-3.noarch
++ trap - ERR
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ '[' -z 0 -o 0 = 0 ']'
++ return 0
++ exit 11

KalturaCommunity-zz · 2015-06-17T17:45:21Z

OK, I will commit that fix.
As to the new issue, can you try what is suggested here?
http://mechanics.flite.com/blog/2014/07/29/using-innodb-large-prefix-to-avoid-error-1071/

May the source be with you,

Jess Portnoy

Join us for the Kaltura Connect Virtual Summits 2015 - Register now!
virtualconnect.kaltura.com

On Wed, 17 Jun 2015, dasj19 wrote:

Sorry for the delay, I had to fix some problems with the database.

Now after modifying the SQL strings as described above I get a new SQL error.

here is the bash +x kaltura-db-config.sh output

[root@vmi13074 ~]# bash -x /opt/kaltura/bin/kaltura-db-config.sh localhost root ***** 3306 upgrade
++ 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=daniel.serbanescu@adventist.dk +++ ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk +++
DB1_HOST=127.0.0.1 +++ DB1_NAME=kaltura +++ DB1_USER=kaltura +++ DB1_PASS=eKep8ZiMdnSz3Di +++ DWH_HOST=127.0.0.1 +++
DWH_PORT=3306 +++ DWH_USER=etl +++ DWH_PASS=eKep8ZiMdnSz3Di +++ SERVICE_URL=http://medieadmin.adventist.dk:80 +++
SPHINX_HOST=127.0.0.1 +++ DB1_PORT=3306 +++ SUPER_USER=root +++ SUPER_USER_PASSWD=* +++
KALTURA_VIRTUAL_HOST_NAME=************ +++ RED5_HOST=******* +++ dirname /opt/kaltura/bin/kaltura-db-config.sh
++ COLORS_RC=/opt/kaltura/bin/colors.sh ++ '[' -r /opt/kaltura/bin/colors.sh ']' ++ . /opt/kaltura/bin/colors.sh +++
DULL=0 +++ BRIGHT=1 +++ FG_BLACK=30 +++ FG_RED=31 +++ FG_GREEN=32 +++ FG_YELLOW=33 +++ FG_BLUE=34 +++ FG_VIOLET=35 +++
FG_CYAN=36 +++ FG_WHITE=37 +++ FG_NULL=00 +++ BG_BLACK=40 +++ BG_RED=41 +++ BG_GREEN=42 +++ BG_YELLOW=43 +++
BG_BLUE=44 +++ BG_VIOLET=45 +++ BG_CYAN=46 +++ BG_WHITE=47 +++ BG_NULL=00 +++ ETCOLOR_ERROR='\033[1;31m' +++
ESC='\033' +++ NORMAL='\033[m' +++ RESET='\033[0;37;00m' +++ BLACK='\033[0;30m' +++ RED='\033[0;31m' +++
GREEN='\033[0;32m' +++ YELLOW='\033[0;33m' +++ BLUE='\033[0;34m' +++ VIOLET='\033[0;35m' +++ CYAN='\033[0;36m' +++
WHITE='\033[0;37m' +++ BRIGHT_BLACK='\033[1;30m' +++ BRIGHT_RED='\033[1;31m' +++ BRIGHT_GREEN='\033[1;32m' +++
BRIGHT_YELLOW='\033[1;33m' +++ BRIGHT_BLUE='\033[1;34m' +++ BRIGHT_VIOLET='\033[1;35m' +++ BRIGHT_CYAN='\033[1;36m'
+++ BRIGHT_WHITE='\033[1;37m' +++ REV_CYAN='\033[0;47;46m' +++ REV_RED='\033[0;33; 41m' +++ JESS='Jess likes this one
:)' ++ '[' -r /etc/sysconfig/clock ']' ++ . /etc/sysconfig/clock +++ ZONE=Europe/Berlin ++ '[' -r
/opt/kaltura/app/configurations/consent_msgs ']' ++ . /opt/kaltura/app/configurations/consent_msgs +++ PRE_CONSENT='To
improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect
necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded
and more stable platform and services. This information helps us understand what problems users encounter when using
Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what
information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ . By allowing Kaltura to
collect data about your installation, we may be able provide more effective assistance in the event that you encounter
an installation issue. To allow Kaltura to track and analyze QA and support information, please enter your email. Type
NO to disallow:' +++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being
collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .' ++ CONSENT_FILE=/opt/kaltura/bin/contact.rc ++
SPHINX_DAEMON=kaltura-sphinx ++ BATCH_DAEMON=kaltura-batch ++ MEMCACHE_DAEMON=memcached +++ lsb_release -i -s ++
DISTRO=CentOS ++ '[' CentOS = Ubuntu -o CentOS = Debian ']' ++ APACHE_DAEMON=httpd ++ MYSQL_DAEMON=mysqld ++
MONIT_DAEMON=kaltura-monit ++ INIT_CONFIG_UTIL=chkconfig ++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch
kaltura-monit memcached' ++ PACKAGE_TYPE=rpm ++ QUERY_COMMAND='rpm -q' ++ MAIL_LOG=/var/log/maillog ++
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 ++
ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report ++
NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php ++ NEWSLETTER_MSG=' To keep up with the
bi-weekly Kaltura releases, and stay up to date with the latest news, security and bug updates, and connect with the
global Kaltura community - sign up for our regular Kaltura Community updates. Please enter your email to sign up, or
enter NO to pass. '

'[' 5 -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=daniel.serbanescu@adventist.dk ++
ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk ++ DB1_HOST=127.0.0.1 ++ DB1_NAME=kaltura ++ DB1_USER=kaltura
++ DB1_PASS=eKep8ZiMdnSz3Di ++ DWH_HOST=127.0.0.1 ++ DWH_PORT=3306 ++ DWH_USER=etl ++ DWH_PASS=eKep8ZiMdnSz3Di ++
SERVICE_URL=http://medieadmin.adventist.dk:80 ++ SPHINX_HOST=127.0.0.1 ++ DB1_PORT=3306 ++ SUPER_USER=root ++
SUPER_USER_PASSWD=* ++ KALTURA_VIRTUAL_HOST_NAME=* ++ RED5_HOST=*********** ++ 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,ALTER,CREATE,DROP ++
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=daniel.serbanescu@adventist.dk +++ ADMIN_CONSOLE_ADMIN_MAIL=daniel.serbanescu@adventist.dk +++
DB1_HOST=127.0.0.1 +++ DB1_NAME=kaltura +++ DB1_USER=kaltura +++ DB1_PASS=eKep8ZiMdnSz3Di +++ DWH_HOST=127.0.0.1 +++
DWH_PORT=3306 +++ DWH_USER=etl +++ DWH_PASS=eKep8ZiMdnSz3Di +++ SERVICE_URL=http://medieadmin.adventist.dk:80 +++
SPHINX_HOST=127.0.0.1 +++ DB1_PORT=3306 +++ SUPER_USER=root +++ SUPER_USER_PASSWD=* +++
KALTURA_VIRTUAL_HOST_NAME=* +++ RED5_HOST=************* +++ dirname /opt/kaltura/bin/kaltura-db-config.sh ++
COLORS_RC=/opt/kaltura/bin/colors.sh ++ '[' -r /opt/kaltura/bin/colors.sh ']' ++ . /opt/kaltura/bin/colors.sh +++
DULL=0 +++ BRIGHT=1 +++ FG_BLACK=30 +++ FG_RED=31 +++ FG_GREEN=32 +++ FG_YELLOW=33 +++ FG_BLUE=34 +++ FG_VIOLET=35 +++
FG_CYAN=36 +++ FG_WHITE=37 +++ FG_NULL=00 +++ BG_BLACK=40 +++ BG_RED=41 +++ BG_GREEN=42 +++ BG_YELLOW=43 +++
BG_BLUE=44 +++ BG_VIOLET=45 +++ BG_CYAN=46 +++ BG_WHITE=47 +++ BG_NULL=00 +++ ETCOLOR_ERROR='\033[1;31m' +++
ESC='\033' +++ NORMAL='\033[m' +++ RESET='\033[0;37;00m' +++ BLACK='\033[0;30m' +++ RED='\033[0;31m' +++
GREEN='\033[0;32m' +++ YELLOW='\033[0;33m' +++ BLUE='\033[0;34m' +++ VIOLET='\033[0;35m' +++ CYAN='\033[0;36m' +++
WHITE='\033[0;37m' +++ BRIGHT_BLACK='\033[1;30m' +++ BRIGHT_RED='\033[1;31m' +++ BRIGHT_GREEN='\033[1;32m' +++
BRIGHT_YELLOW='\033[1;33m' +++ BRIGHT_BLUE='\033[1;34m' +++ BRIGHT_VIOLET='\033[1;35m' +++ BRIGHT_CYAN='\033[1;36m'
+++ BRIGHT_WHITE='\033[1;37m' +++ REV_CYAN='\033[0;47;46m' +++ REV_RED='\033[0;33; 41m' +++ JESS='Jess likes this one
:)' ++ '[' -r /etc/sysconfig/clock ']' ++ . /etc/sysconfig/clock +++ ZONE=Europe/Berlin ++ '[' -r
/opt/kaltura/app/configurations/consent_msgs ']' ++ . /opt/kaltura/app/configurations/consent_msgs +++ PRE_CONSENT='To
improve your Kaltura experience and provide you with the best service, Kaltura would like your consent to collect
necessary data and information regarding your installation and use of Kaltura and analyze it to provide an upgraded
and more stable platform and services. This information helps us understand what problems users encounter when using
Kaltura, so we can improve the quality, performance, and security of the platform accordingly. To review what
information is being collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ . By allowing Kaltura to
collect data about your installation, we may be able provide more effective assistance in the event that you encounter
an installation issue. To allow Kaltura to track and analyze QA and support information, please enter your email. Type
NO to disallow:' +++ POST_CONSENT='Thank you for helping making Kaltura better! To review what information is being
collected, please read: http://www.kaltura.org/kaltura-qa-tracking/ .' ++ CONSENT_FILE=/opt/kaltura/bin/contact.rc ++
SPHINX_DAEMON=kaltura-sphinx ++ BATCH_DAEMON=kaltura-batch ++ MEMCACHE_DAEMON=memcached +++ lsb_release -i -s ++
DISTRO=CentOS ++ '[' CentOS = Ubuntu -o CentOS = Debian ']' ++ APACHE_DAEMON=httpd ++ MYSQL_DAEMON=mysqld ++
MONIT_DAEMON=kaltura-monit ++ INIT_CONFIG_UTIL=chkconfig ++ ALL_DAEMONS='httpd kaltura-sphinx kaltura-batch
kaltura-monit memcached' ++ PACKAGE_TYPE=rpm ++ QUERY_COMMAND='rpm -q' ++ MAIL_LOG=/var/log/maillog ++
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 ++
ANALYTICS_SERVER_URI=http://installytics.kaltura.org/report ++
NEWSLETTER_URL=https://agentcontribs.kaltura.org/newsletter_subscribe.php ++ NEWSLETTER_MSG=' To keep up with the
bi-weekly Kaltura releases, and stay up to date with the latest news, security and bug updates, and connect with the
global Kaltura community - sign up for our regular Kaltura Community updates. Please enter your email to sign up, or
enter NO to pass. '

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

send_install_becon kaltura-db-config.sh Europe/Berlin install_start 0

trap - ERR

'[' -r /opt/kaltura/bin/contact.rc ']'

. /opt/kaltura/bin/contact.rc ++ USER_CONSENT=0

'[' -z 0 -o 0 = 0 ']'

return 0

MYSQL_HOST=localhost

MYSQL_SUPER_USER=root

MYSQL_SUPER_USER_PASSWD=*********

MYSQL_PORT=3306

IS_UPGRADE=upgrade

'[' upgrade = upgrade ']'

echo 'calling upgrade script instead.' calling upgrade script instead.

KALTURA_DB=kaltura

echo -e '\033[0;36mChecking MySQL version..\033[m' Checking MySQL version.. ++ echo 'select version();' ++ mysql
-hlocalhost -uroot -p******* -P3306 -N Warning: Using a password on the command line interface can be insecure.

MYVER=5.6.25 ++ echo 5.6.25 ++ awk -F . '{print $1}'

MYMAJVER=5 ++ echo 5.6.25 ++ awk -F . '{print $2}'

MYMINORVER=6

'[' 5 -ne 5 ']'

echo -e '\033[0;36mVer 5.6.25 found compatible\033[m' Ver 5.6.25 found compatible

'[' 0 -ne 0 ']'

check_mysql_settings root ********* localhost 3306

DB_USER=root

DB_PASSWD=*******

DB_HOST=localhost

DB_PORT=3306

RC=0 ++ echo 'select @@lower_case_table_names;' ++ mysql -uroot -p******* -hlocalhost -P3306 -N Warning: Using a
password on the command line interface can be insecure.

LOWER_CASE_TABLE_NAMES=1

'[' 1 -ne 1 ']' ++ echo 'select @@innodb_log_file_size;' ++ mysql -uroot -p***** -hlocalhost -P3306 -N Warning: Using
a password on the command line interface can be insecure.

INNODB_LOG_FILE_SIZE=33554432

'[' 33554432 -lt 33554432 ']' ++ echo 'select @@max_allowed_packet;' ++ mysql -uroot -p******* -hlocalhost -P3306 -N
Warning: Using a password on the command line interface can be insecure.

MAX_ALLOWED_PACKET=16777216

'[' 16777216 -lt 16777216 ']'

echo -en '\033[1;31m\033[m\n'

return 0

trap - ERR

'[' -z '' ']'

echo 'use kaltura'

mysql -hlocalhost -uroot -p***** -P3306 kaltura

'[' 1 -eq 0 ']'

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

set -e

echo 'CREATE USER kaltura@'''%''';' CREATE USER kaltura@'%';

echo 'CREATE USER kaltura@'''%''' IDENTIFIED BY '''eKep8ZiMdnSz3Di''' ;'

mysql -hlocalhost -uroot -p******** -P3306 Warning: Using a password on the command line interface can be insecure.

echo 'CREATE USER etl@'''%''';' CREATE USER etl@'%';

echo 'CREATE USER etl@'''%''' IDENTIFIED BY '''eKep8ZiMdnSz3Di''' ;'

mysql -hlocalhost -uroot -p ******** -P3306 Warning: Using a password on the command line interface can be insecure.

for DB in '$DBS'

echo 'CREATE DATABASE kaltura;' CREATE DATABASE kaltura;

echo 'CREATE DATABASE kaltura;'

mysql -hlocalhost -uroot -p ****** -P3306 Warning: Using a password on the command line interface can be insecure.

PRIVS=kaltura_PRIVILEGES

DB_USER=kaltura_USER

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

mysql -hlocalhost -uroot -p************ -P3306 Warning: Using a password on the command line interface can be
insecure.

DB_SQL_FILES=kaltura_SQL_FILES

for SQL in '${!DB_SQL_FILES}'

mysql -hlocalhost -uroot -p ********** -P3306 kaltura
Warning: Using a password on the command line interface can be insecure.
ERROR 1071 (42000) at line 2403: Specified key was too long; max key length is 767 bytes
++ my_trap_handler 143 6084
+++ basename /opt/kaltura/bin/kaltura-db-config.sh
++ MYSELF=kaltura-db-config.sh
++ LASTLINE=143
++ LASTERR=6084
++ '[' rpm = rpm ']'
+++ rpm -q kaltura-postinst
++ POSTINST_VER=kaltura-postinst-1.0.26-3.noarch
++ '[' -d /opt/kaltura/log ']'
+++ date +%d_%m_%y_%H_%M
++ TAR_PATH=/opt/kaltura/log/log_17_06_15_19_31.tar.gz
++ echo -en '\033[1;31m\033[m

'

++ echo 'Archving logs to /opt/kaltura/log/log_17_06_15_19_31.tar.gz...'
Archving logs to /opt/kaltura/log/log_17_06_15_19_31.tar.gz...
++ mkdir -p /tmp/tmpdir_kaltura
++ cp /opt/kaltura/log/clear_cache.log /opt/kaltura/log/cron.log /opt/kaltura/log/generate.php.log
/opt/kaltura/log/kaltura_apache_access.log /opt/kaltura/log/kaltura_apache_errors.log
/opt/kaltura/log/kaltura_populate.log /tmp/tmpdir_kaltura
++ cd /tmp/tmpdir_kaltura
++ tar zcf /opt/kaltura/log/log_17_06_15_19_31.tar.gz clear_cache.log cron.log generate.php.log kalt_up.log
kaltura_admin.log kaltura_apache_access.log kaltura_apache_access_ssl.log kaltura_apache_errors.log
kaltura_apache_errors_ssl.log kaltura_api_v3_analytics.log kaltura_api_v3.log kaltura_api_v3_tests.log
kaltura_batch.log kaltura_deploy.log kaltura_populate.log kaltura_prod.log kaltura_scripts.log
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ send_install_becon kaltura-db-config.sh Europe/Berlin install_fail 143,kaltura-postinst-1.0.26-3.noarch
++ trap - ERR
++ '[' -r /opt/kaltura/bin/contact.rc ']'
++ . /opt/kaltura/bin/contact.rc
+++ USER_CONSENT=0
++ '[' -z 0 -o 0 = 0 ']'
++ return 0
++ exit 11
—
Reply to this email directly or view it on GitHub.[ACH7XrO4DcG2yeABLsJH-yAvB9VeHdFcks5oUahdgaJpZM4FFP24.gif]

dasj19 · 2015-06-21T14:43:11Z

@jessp01 I am not able to fix the issue as suggeste there because besides the settings made to the table I also need to add ROW_FORMAT=DYNAMIC; to the database tables definition.
I am unable to find where the SQL code for creating the database tables is located.
Any suggestion is greatly appreciated

jessp01 · 2015-06-21T14:45:27Z

Hello,

Please see: /opt/kaltura/app/deployment/base/sql/

dasj19 · 2015-07-02T08:53:24Z

Hello @jessp01 I managed to replace the db engine type in the file 01.kaltura_ce_tables.sql ... I switched from ENGINE=InnoDB to ENGINE=MyISAM and I no longer face SQL problems.
But the installation still fails with the same message.
Here is the last output:

Configuring your Kaltura DB...

Checking MySQL version..
Warning: Using a password on the command line interface can be insecure.
Ver 5.6.25 found compatible
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.

CREATE USER kaltura;
Warning: Using a password on the command line interface can be insecure.
CREATE USER etl;
Warning: Using a password on the command line interface can be insecure.
CREATE DATABASE kaltura;
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
CREATE DATABASE kaltura_sphinx_log;
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
CREATE DATABASE kalturadw;
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
CREATE DATABASE kalturadw_ds;
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
CREATE DATABASE kalturadw_bisources;
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
CREATE DATABASE kalturalog;
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Checking connectivity to needed daemons...
Connectivity test passed:)
Cleaning cache..
Populating DB with data.. please wait..
Output for /opt/kaltura/app/deployment/base/scripts/installPlugins.php being logged into /opt/kaltura/log/installPlugins.log
Output for /opt/kaltura/app/deployment/base/scripts/insertDefaults.php being logged into /opt/kaltura/log/insertDefaults.log

    Archving logs to /opt/kaltura/log/log_02_07_15_10_47.tar.gz...

ERROR: we failed on something else..
You have mail in /var/spool/mail/root

jessp01 · 2015-07-02T08:55:29Z

Hello,

Thank you, this is fixed here:
https://github.com/kaltura/server/blob/Jupiter-10.15.0/deployment/base/sql/01.kaltura_ce_tables.sql#L2458

As for the next issue, what do you see in /opt/kaltura/log/insertDefaults.log?

Thanks,

dasj19 · 2015-07-02T09:01:50Z

thank for fast reply;
Here is the output:
2015-07-01 12:56:39 [BasePeer::doInsert] ERR: exception 'Exception' with message 'SQLSTATE[HY000]: General error: 1364 Field 'format' doesn't have a default value' in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(408): KalturaLog::err('SQLSTATE[HY000]...')
#1 /opt/kaltura/app/vendor/propel/util/BasePeer.php(298): Propel::log('SQLSTATE[HY000]...', 3)
#2 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(132) : eval()'d code(21): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
#3 /opt/kaltura/app/alpha/lib/model/om/BaseassetParams.php(1967): InsertliveParams->doSave(Object(KalturaPDO))
#4 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(218): BaseassetParams->save()
#5 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(69): handleFile('/opt/kaltura/ap...')
#6 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(23): handleDirectory('/opt/kaltura/ap...')
#7 {main}
PHP Fatal error: Uncaught exception 'PropelException' with message 'Unable to execute INSERT statement. [wrapped: SQLSTATE[HY000]: General error: 1364 Field 'format' doesn't have a default value]' in /opt/kaltura/app/vendor/propel/util/BasePeer.php:299
Stack trace:
#0 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(132) : eval()'d code(21): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
#1 /opt/kaltura/app/alpha/lib/model/om/BaseassetParams.php(1967): InsertliveParams->doSave(Object(KalturaPDO))
#2 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(218): BaseassetParams->save()
#3 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(69): handleFile('/opt/kaltura/ap...')
#4 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(23): handleDirectory('/opt/kaltura/ap...')
#5 {main}
thrown in /opt/kaltura/app/vendor/propel/util/BasePeer.php on line 299
2015-07-01 13:02:17 [BasePeer::doInsert] ERR: exception 'Exception' with message 'SQLSTATE[HY000]: General error: 1364 Field 'format' doesn't have a default value' in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(408): KalturaLog::err('SQLSTATE[HY000]...')
#1 /opt/kaltura/app/vendor/propel/util/BasePeer.php(298): Propel::log('SQLSTATE[HY000]...', 3)
#2 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(132) : eval()'d code(21): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
#3 /opt/kaltura/app/alpha/lib/model/om/BaseassetParams.php(1967): InsertliveParams->doSave(Object(KalturaPDO))
#4 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(218): BaseassetParams->save()
#5 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(69): handleFile('/opt/kaltura/ap...')
#6 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(23): handleDirectory('/opt/kaltura/ap...')
#7 {main}
PHP Fatal error: Uncaught exception 'PropelException' with message 'Unable to execute INSERT statement. [wrapped: SQLSTATE[HY000]: General error: 1364 Field 'format' doesn't have a default value]' in /opt/kaltura/app/vendor/propel/util/BasePeer.php:299
Stack trace:
#0 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(132) : eval()'d code(21): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
#1 /opt/kaltura/app/alpha/lib/model/om/BaseassetParams.php(1967): InsertliveParams->doSave(Object(KalturaPDO))
#2 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(218): BaseassetParams->save()
#3 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(69): handleFile('/opt/kaltura/ap...')
#4 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(23): handleDirectory('/opt/kaltura/ap...')
#5 {main}
thrown in /opt/kaltura/app/vendor/propel/util/BasePeer.php on line 299
2015-07-02 10:47:26 [BasePeer::doInsert] ERR: exception 'Exception' with message 'SQLSTATE[HY000]: General error: 1364 Field 'format' doesn't have a default value' in /opt/kaltura/app/infra/log/KalturaLog.php:82
Stack trace:
#0 /opt/kaltura/app/vendor/propel/Propel.php(408): KalturaLog::err('SQLSTATE[HY000]...')
#1 /opt/kaltura/app/vendor/propel/util/BasePeer.php(298): Propel::log('SQLSTATE[HY000]...', 3)
#2 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(132) : eval()'d code(21): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
#3 /opt/kaltura/app/alpha/lib/model/om/BaseassetParams.php(1967): InsertliveParams->doSave(Object(KalturaPDO))
#4 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(218): BaseassetParams->save()
#5 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(69): handleFile('/opt/kaltura/ap...')
#6 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(23): handleDirectory('/opt/kaltura/ap...')
#7 {main}
PHP Fatal error: Uncaught exception 'PropelException' with message 'Unable to execute INSERT statement. [wrapped: SQLSTATE[HY000]: General error: 1364 Field 'format' doesn't have a default value]' in /opt/kaltura/app/vendor/propel/util/BasePeer.php:299
Stack trace:
#0 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(132) : eval()'d code(21): BasePeer::doInsert(Object(Criteria), Object(KalturaPDO))
#1 /opt/kaltura/app/alpha/lib/model/om/BaseassetParams.php(1967): InsertliveParams->doSave(Object(KalturaPDO))
#2 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(218): BaseassetParams->save()
#3 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(69): handleFile('/opt/kaltura/ap...')
#4 /opt/kaltura/app/deployment/base/scripts/insertDefaults.php(23): handleDirectory('/opt/kaltura/ap...')
#5 {main}
thrown in /opt/kaltura/app/vendor/propel/util/BasePeer.php on line 299

jessp01 · 2015-07-02T09:10:53Z

Can you please paste the output for:

rpm -q mysql-server

And tell me where you obtained it from? I will install the same and test

dasj19 · 2015-07-02T09:13:12Z

I do not have a mysql-server package installed but I have mysql-community-server. My system is CentOS 6.6

rpm -q mysql-community-server
mysql-community-server-5.6.25-2.el6.x86_64

yum install mysql-server
returns: Package mysql-server-5.1.73-5.el6_6.x86_64 is obsoleted by mysql-community-server-5.6.25-2.el6.x86_64 which is already installed

jessp01 · 2015-07-02T10:03:36Z

I understand:)
What I am asking is which repo did the mysql-community-server come from..
Can you do:

yum info mysql-community-server

dasj19 · 2015-07-02T10:07:14Z

Here it is:
Name : mysql-community-server
Arch : x86_64
Version : 5.6.25
Release : 2.el6
Size : 236 M
Repo : installed
From repo : mysql56-community
Summary : A very fast and reliable SQL database server
URL : http://www.mysql.com/
License : Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights
: reserved. Under GPLv2 license as shown in the Description field.

jessp01 · 2015-07-02T10:15:08Z

OK, I see. So it came from the MySQL repo as opposed to the CentOS one.
I will install the same version and test it.
Beforehand though, can you try to disable strict mode in your MySQL server? I believe this should solve it.

Here is how:
https://support.realtyna.com/index.php?/Knowledgebase/Article/View/535/0/how-can-i-turn-off-mysql-strict-mode

dasj19 · 2015-07-02T12:54:45Z

Thanks, I turned off the strict mode and it finally installed succesfully, but now I am experiencing issues with the KMC.
I logged into admin console and created a publisher. Now when I log in into KMC with the publisher account I end with a page not found error.
The URL reads: https://hostname/index.php/index.php/kmc/kmc4 (note that is https although I did a non-https install) and the page displays:

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

jessp01 · 2015-07-02T13:44:02Z

Hmm.
What does:
mysql> select * from kaltura.permission WHERE permission.NAME='FEATURE_KMC_ENFORCE_HTTPS'\G

output?

dasj19 · 2015-07-02T16:33:56Z

The output is:
*************************** 1. row ***************************
id: 255
type: 2
name: FEATURE_KMC_ENFORCE_HTTPS
friendly_name: Force KMC HTTPS
description:
partner_id: 0
status: 1
depends_on_permission_names:
tags:
created_at: 2015-07-02 13:11:28
updated_at: 2015-07-02 13:11:28
custom_data: a:1:{s:13:"partner_group";s:0:"";}
*************************** 2. row ***************************
id: 326
type: 2
name: FEATURE_KMC_ENFORCE_HTTPS
friendly_name: NULL
description: NULL
partner_id: 101
status: 2
depends_on_permission_names: NULL
tags: NULL
created_at: 2015-07-02 13:44:37
updated_at: 2015-07-02 13:44:37
custom_data: NULL
2 rows in set (0.00 sec)

jessp01 · 2015-07-02T16:48:44Z

Great, can you please delete both lines?

Thanks,

dasj19 · 2015-07-02T17:11:26Z

Thank you a lot, now KMC seems to work as normal

KalturaCommunity-zz · 2015-07-02T17:13:33Z

Glad to hear. Can you please close the issue?:)

May the source be with you,

Jess Portnoy

On Thu, 2 Jul 2015, dasj19 wrote:

Thank you a lot, KMC seems to work as normal

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

jessp01 pushed a commit that referenced this issue Jun 18, 2015

https://github.com/kaltura/platform-install-packages/issues/413

cf807c9

dasj19 closed this as completed Jul 2, 2015

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Installation fails with message: "we failed on something else.." #413

Installation fails with message: "we failed on something else.." #413

dasj19 commented Jun 17, 2015

jessp01 commented Jun 17, 2015

dasj19 commented Jun 17, 2015

kaltura-hooks commented Jun 17, 2015

jessp01 commented Jun 17, 2015

dasj19 commented Jun 17, 2015

jessp01 commented Jun 17, 2015

dasj19 commented Jun 17, 2015

KalturaCommunity-zz commented Jun 17, 2015

dasj19 commented Jun 21, 2015

jessp01 commented Jun 21, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

KalturaCommunity-zz commented Jul 2, 2015

Installation fails with message: "we failed on something else.." #413

Installation fails with message: "we failed on something else.." #413

Comments

dasj19 commented Jun 17, 2015

jessp01 commented Jun 17, 2015

dasj19 commented Jun 17, 2015

kaltura-hooks commented Jun 17, 2015

jessp01 commented Jun 17, 2015

dasj19 commented Jun 17, 2015

jessp01 commented Jun 17, 2015

dasj19 commented Jun 17, 2015

KalturaCommunity-zz commented Jun 17, 2015

dasj19 commented Jun 21, 2015

jessp01 commented Jun 21, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

rpm -q mysql-server

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

yum info mysql-community-server

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

jessp01 commented Jul 2, 2015

dasj19 commented Jul 2, 2015

KalturaCommunity-zz commented Jul 2, 2015