Copyright © 2011 Kaltura Inc.
All Rights Reserved. Designated trademarks and brands are the property of their respective owners.
Use of this web site constitutes acceptance of the Terms of Use and Privacy Policy.
EduVideo.org
Install looping
Fri, 07/30/2010 - 03:58
Knowing my other problem will probably never get addressed, I just decided to say hell with it and start a brand new install. Now keep in mind that this is a server that already has a working installation.
I have tried to set up in a new location. I go to the installation, run through each steps, finish, and right back to install page. I can go to "api/testme" just fine. This is installed in the root of a virtual host, not a subdirectory to an existing site.
FYI, I still can not install via phpcli. Phpcli is installed, does work. However there I run into the problem where the install process assumes I am running Lampp, which I am not, and only looks for php in that /opt/lampp/* directory. I have added php to path, tested with success. Yet not surprisingly "php install.php" from root does NOT work. If I go into the "install" directory and run "php install.php" I get the error that it can not find the executable. However I can start the install with v2.0 via phpcli, to which it fails consistently telling me that I need "lower_case_table_names=1". which is in my.cnf.
Sat, 07/31/2010 - 06:16
#2
Hi,
from your messages I don't understand if you got it working or not...
the v2 of Kaltura CE only installs from CLI and you shouldn't be able to browse to it before finishing the installation.
what I do understand is when you run the CLI installation of v2 you are stopped in prerequisites step because you
are missing a required configuration in my.cnf
please make sure:
1. the lower_case_table_names=1 setting exists in the my.cnf file and does not have any typos.
2. the lower_case_table_names=1 exists under the [mysqld] section
3. you restarted mysql after changing this setting.
you can verify it is OK by connecting to mysql and running the following query:
select @@lower_case_table_names;
Gonen.
Thu, 10/20/2011 - 03:56
#3
@Gonen.Radai
Thank you very much :)
Fri, 08/13/2010 - 17:00
#4
Hello,
I have the same problem here. Here is my.cnf: http://pastebin.com/F6a8wRFV
I have restarted mysqld (even rebooted) with no luck...
When I try to check for the lower_case_table_names, I get this output:
mysql> select @@lower_case_table_names;
ERROR 1193 (HY000): Unknown system variable 'lower_case_table_names'
What I did wrong?
Thanks!
Mon, 09/20/2010 - 04:59
#5
Hi pylanglois
The Kaltura installer is a bit misleading there - it says it failed to find the config setting in the config file, but actually it queries MySQL directly for the value.
I think most seasoned Debian / Ubuntu admins would have set the value in /etc/mysql/conf.d/kaltura.cnf, then wonder if the Kaltura installer doesn't know to check the included files in that directory.
A more accurate error message would probably say "mySQL setting [lower_case_table_names] could not be retrieved" rather than "mySQL setting [lower_case_table_names] was not found in the my.cnf file". That avoids any potential for confusion over whether the installer or the DB config is at fault.
Anyway - looks like you're installing on Debian 5.0? That version of Debian ships with MySQL 5.0 by default. I saw the same issue, with MySQL reporting that lower_case_table_names was an 'unknown system variable', despite being set in the config file. And Kaltura's INSTALLATION.txt does specify it requires MySQL 5.1, not 5.0.
I worked around this same issue by grabbing MySQL 5.1 from DotDeb. What I did was -
1. Follow the instructions at http://www.dotdeb.org/instructions/ to add DotDeb as a package source.
2. Run 'apt-get install mysql-server-5.1'
3. Re-run the Kaltura installer.
Hope that helps! Can you post back and confirm if this fixes your issue?
Mon, 09/20/2010 - 12:44
#6
Thanks for the advice. Finally, I have installed Kaltura using xampp and it works great. Since we are in the testing phase, this setup is good enough. But I will need to deploy it in production this autumn so I will keep you informed of how I did it.
Fri, 10/08/2010 - 22:11
#7
If you are having the lower_case_table_names problems with Cent OS (in my case, Cent OS 5.4):
## Check the version of Cent OS thus:
uname -a
uname -a
## and...
cat /etc/redhat-release
1. Realize that the Cent OS way (as of 8 Oct 2010) is to use the most stable mySQL version available. In this case, the version is mysqld version 5.0.
2. You have to upgrade on assumed risk (which really isn't that much of a risk IMO)
3. The best instructions for upgrading:
## Remi Dependency on CentOS and Red Hat (RHEL)
rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
## Check for versions in the Yum remi list
yum --enablerepo=remi list mysql
## If mysql 5.1 is there:
yum --enablerepo=remi install mysql mysql-server
service mysqld start
chkconfig --levels 235 mysqld on
## Run this script to secure your mysql installation and set your passwd
/usr/bin/mysql_secure_installation
After upgrading to mysql 5.1, make sure you edit your /etc/my.cnf file to add the lower_case_table_names = 1 under the [mysqld] section.
Hope this helps!
Joe
Joe Hyde
http://www.hydeinteractive.com/
I should mention that if I go to "http://MYKALTURADOMAIN.COM/index.php/kmc/kmc" I can log in, and run through the site fine. However, this does not necessary fix the install loop. Especially since going to the root of the URL brings up the Install which I assume could be run and completely overwriting any settings.