Created 12-30-2015 03:46 AM
I installed cloudera manager 5.4.8 and agent with yum and using mysql as database
Following are the steps
sudo yum -y install mysql-server
sudo service mysqld stop
sudo /sbin/chkconfig mysqld on
sudo service mysqld start
sudo mysqladmin -u root password password
sudo yum -y install mysql-connector-java
sudo yum -y install oracle-j2sdk1.7
sudo wget http://archive.cloudera.com/cm5/redhat/6/x86_64/cm/cloudera-manager.repo -P /etc/yum.repos.d
// Modify /etc/yum.repos.d/cloudera-manager.repo to install version 5.4.8
sudo yum clean all
sudo yum install cloudera-manager-agent cloudera-manager-server
sudo /usr/share/cmf/schema/scm_prepare_database.sh mysql cmf cmf cmf
I have configured following database in mysql
create database cmf;
create database metastore;
create database rman;
grant all on cmf. * to 'cmf'@'localhost' identified by 'cmf';
grant all on metastore. * to 'hive'@'localhost' identified by 'hive';
grant all on metastore. * to 'hive'@'%' identified by 'hive';
grant all on rman. * to 'rman'@'localhost' identified by 'rman';
flush privileges;
[root@cluster cloudera-scm-server]# /etc/init.d/cloudera-scm-server start
Starting cloudera-scm-server: [FAILED]
There is no log file at /var/log/cloudera-scm-server but only following file exist
/var/log/cloudera-scm-server/cloudera-scm-server.out
This file has only one line
[root@cluster cloudera-scm-server]# cat /var/log/cloudera-scm-server/cloudera-scm-server.out
could not open session
I do not file any other error.
Can someone help here where should i troubleshoot?
OS : centos 6.7
BTW i am trying to install cloudera on base centos 6.7 image with docker.
Not sure if in case this error has to do anything due to docker
Created 12-30-2015 08:19 AM
Did you have any issues running the scm_prepare_database.sh script? What configuration did you use for /etc/my.cnf? We have an example configuration for MySQL at: http://www.cloudera.com/content/www/en-us/documentation/enterprise/latest/topics/cm_ig_mysql.html#cm...
Created on 12-30-2015 08:54 AM - edited 12-30-2015 08:55 AM
scm_prepare_database.sh script went fine.
Following is the output. [user1@cluster ~]$ sudo /usr/share/cmf/schema/scm_prepare_database.sh mysql cmf cmf cmf JAVA_HOME=/usr/java/jdk1.7.0_67-cloudera Verifying that we can write to /etc/cloudera-scm-server Creating SCM configuration file in /etc/cloudera-scm-server Executing: /usr/java/jdk1.7.0_67-cloudera/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/usr/share/cmf/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db. 2015-12-30 16:35:23,255 [main] INFO com.cloudera.enterprise.dbutil.DbCommandExecutor - Successfully connected to database. All done, your SCM database is configured correctly!
I have used /etc/my.conf similar to one provided in the link.
I have more strong feeling about docker causing an issue. Although I have not tried to reproduce problem on standalone centos vm.