Reply
Highlighted
New Contributor
Posts: 2
Registered: ‎06-19-2018

sles12 can not offline install cloudera manager

[ Edited ]

system:SLES12 SP3  

software:

  1. maraidb-sles12 10.3.7 
  2. cloudera-manager-sles12-cm5.15.0_x86_64.tar.gz or  cloudera-manager-sles12-cm5.14.2_x86_64.tar.gz 
  3. jdk1.8.0_161

I'm trying to install Cloudera Manager for a production deployment on SLES12 SP3.  I'm following the instructions here: https://www.cloudera.com/documentation/enterprise/latest/topics/install_cm_cdh.html

 

# /opt/cm-5.XX/etc/init.d/cloudera-scm-server start

error

 

log:

mysql DDL file Cause an errors
/opt/cm-5.14.2/share/cmf/schema/mysql/05003_cmf_schema.mysql.ddl

vim /opt/cm-5.14.2/log/cloudera-scm-server/cloudera-scm-server.log
2018-06-19 17:18:24,992 FATAL main:org.hsqldb.cmdline.SqlFile: SQL Error at 'UTF-8' line 57:
"alter table ROLE_CONFIG_GROUPS
    drop column REVISION_ID"
Key column 'REVISION_ID' doesn't exist in table
2018-06-19 17:18:24,992 FATAL main:org.hsqldb.cmdline.SqlFile: Rolling back SQL transaction.
2018-06-19 17:18:24,993 ERROR main:com.cloudera.enterprise.dbutil.SqlFileRunner: Exception while executing ddl scripts.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Key column 'REVISION_ID' doesn't exist in table


Can't DROP FOREIGN KEY `FK_SERVICE_CONFIG_REVISION`; check that it exists
2018-06-19 17:27:22,760 ERROR main:com.cloudera.enterprise.dbutil.SqlFileRunner: Exception while executing ddl scripts.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Can't DROP FOREIGN KEY `FK_SERVICE_CONFIG_REVISION`; check th
at it exists


There are many more error 

 

New Contributor
Posts: 2
Registered: ‎06-19-2018

Re: sles12 can not offline install cloudera manager

i change database, used postgers. it successd, maybe it is a bug
Announcements