Reply
Explorer
Posts: 7
Registered: ‎12-30-2015

Could not start cloudera-scm-server after fresh installation

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

 

Cloudera Employee
Posts: 10
Registered: ‎12-30-2015

Re: Could not start cloudera-scm-server after fresh installation

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...

 

Highlighted
Explorer
Posts: 7
Registered: ‎12-30-2015

Re: Could not start cloudera-scm-server after fresh installation

[ Edited ]

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.

Announcements