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';
[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
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
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...
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.