Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to install cloudera-management services

Highlighted

Unable to install cloudera-management services

Hi All,

I'm trying to install cloudera 6.2.0 , however am stuck with below error.

 

Provided username, dbname and password correct, I tried same credentials to connect to DB from backend and it works. 

cm_error.JPG

 

rman.JPG

 

[root@tdicsadn01 cloudera-scm-server]# cat db.properties
# Auto-generated by scm_prepare_database.sh on Fri Feb 14 17:51:09 +08 2020
#
# For information describing how to configure the Cloudera Manager Server
# to connect to databases, see the "Cloudera Manager Installation Guide."
#
com.cloudera.cmf.db.type=mysql
com.cloudera.cmf.db.host=localhost
com.cloudera.cmf.db.name=scm
com.cloudera.cmf.db.user=scm
com.cloudera.cmf.db.setupType=EXTERNAL
com.cloudera.cmf.db.password=scm2019
[root@tdicsadn01 cloudera-scm-server]#

No firewall or Selinux

[root@tdicsadn02 jdk1.8.0_181-cloudera]# getenforce
Disabled
[root@tdicsadn02 jdk1.8.0_181-cloudera]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)
[root@tdicsadn02 jdk1.8.0_181-cloudera]#
4 REPLIES 4

Re: Unable to install cloudera-management services

Expert Contributor

Likely user permissions on MySQL level. If you test mysql command connecting to hostname instead of localhost you likely see the same login recected:

# mysql -h tdicsadn01.td.com -u rman -p rman2019

 If so then please add grants for those two users for '%' or 'tdicsadn01.td.com' in MySQL as shown in Step 2 in corresponding documentation chapter

Highlighted

Re: Unable to install cloudera-management services

Hi @gzigldrum 

I indeed followed documentation and used below commands to grant required access;

 

CREATE DATABASE rman DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON rman.* TO 'rman'@'%' IDENTIFIED BY 'rman2019';
GRANT ALL ON rman.* TO 'rman'@'localhost' IDENTIFIED BY 'rman2019';

Highlighted

Re: Unable to install cloudera-management services

Expert Contributor

That looks good, can you successfully connect when running this command on the CM host:

# mysql -h tdicsadn01.td.com -u rman -p rman2019

 

Highlighted

Re: Unable to install cloudera-management services

Guru
@chhaya_vishwaka,

If "mysql -h tdicsadn01.td.com -u rman -p rman2019" still not working, please share the output of below query from MySQL database:

SELECT * FROM mysql.user WHERE User = 'rman'\G

Need to make sure that there are no other entries might interfere with the permissions.

Cheers
Eric
Don't have an account?
Coming from Hortonworks? Activate your account here