Configure Cloudera Manager with external database: AWS RDS MySQL failed

zhuw.bigdata — Tue, 21 Mar 2017 17:49:00 GMT

Since AWS RDS MySQL instance doesn’t grant the initial DB user the real ‘root’ privileges, I need specific instructions on AWS RDS setup.

I can’t run the following command to create a temp user. (https://www.cloudera.com/documentation/enterprise/latest/topics/cm_ig_installing_configuring_dbs.html#cmig_topic_5_1😞

mysql> grant all on *.* to 'temp'@'%' identified by 'temp' with grant option;

I had to modify with the following:

mysql> grant all on `%`.* to 'temp'@'%' identified by 'temp' with grant option;

[ec2-user@ip-x ~]$ sudo /usr/share/cmf/schema/scm_prepare_database.sh mysql -h $myDB-endpoints -utemp -ptemp --scm-host ip-x.us-west-1.compute.internal scm scm scm

JAVA_HOME=/usr/java/jdk1.8.0_121

Verifying that we can write to /etc/cloudera-scm-server

Creating SCM configuration file in /etc/cloudera-scm-server

Executing: /usr/java/jdk1.8.0_121/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.

[ main] DbCommandExecutor INFO Unable to login using supplied username/password.

[ main] DbCommandExecutor ERROR Error when connecting to database.

java.sql.SQLException: Access denied for user 'scm'@'myIP' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)[mysql-connector-java.jar:5.1.41]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)[mysql-connector-java.jar:5.1.41]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)[mysql-connector-java.jar:5.1.41]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)[mysql-connector-java.jar:5.1.41]

at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)[mysql-connector-java.jar:5.1.41]

Re: Configure Cloudera Manager with external database: AWS RDS MySQL failed

zhuw.bigdata — Thu, 23 Mar 2017 15:41:36 GMT

Resolved by using `%`.* in the grant statement which removes mysql database. AWS RDS will not let us touch this database on PAAS offering.

question Configure Cloudera Manager with external database: AWS RDS MySQL failed in Support Questions

Configure Cloudera Manager with external database: AWS RDS MySQL failed

Re: Configure Cloudera Manager with external database: AWS RDS MySQL failed