Created 02-14-2020 02:33 AM
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.
[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]#
Created 02-14-2020 02:45 AM
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
Created 02-16-2020 11:29 PM
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';
Created 02-16-2020 11:32 PM
That looks good, can you successfully connect when running this command on the CM host:
# mysql -h tdicsadn01.td.com -u rman -p rman2019
Created 02-18-2020 04:00 PM