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

Question

xecuting: /usr/java/jdk1.8.0_202-amd64/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/usr/share/java/postgresql-connector-java.jar:/opt/cloudera/cm/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
[ main] DbCommandExecutor ERROR Error when connecting to database.
java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:102)[mysql-connector-j.jar:9.1.0]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)[mysql-connector-j.jar:9.1.0]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:837)[mysql-connector-j.jar:9.1.0]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:420)[mysql-connector-j.jar:9.1.0]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:238)[mysql-connector-j.jar:9.1.0]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:180)[mysql-connector-j.jar:9.1.0]
at java.sql.DriverManager.getConnection(DriverManager.java:664)[:1.8.0_202]
at java.sql.DriverManager.getConnection(DriverManager.java:247)[:1.8.0_202]
at com.cloudera.enterprise.dbutil.DbCommandExecutor.testDbConnection(DbCommandExecutor.java:265)[db-common-7.11.3.6912fbdbe0c739ef46654ed952f5e6cd.jar:]
at com.cloudera.enterprise.dbutil.DbCommandExecutor.main(DbCommandExecutor.java:140)[db-common-7.11.3.6912fbdbe0c739ef46654ed952f5e6cd.jar:]
[ main] DbCommandExecutor ERROR Exiting with exit code 4

Kartik_Agarwal · Accepted Answer

@ecampos

To resolve this issue and to allow CM server to start, modify the db.properties file as below:

Note: Back up the current file at /etc/cloudera-scm-server/db.properties.

--------------- com.cloudera.cmf.db.type = mysql com.cloudera.cmf.orm.hibernate.connection.url=jdbc:mysql://<db_host>/scm?allowPublicKeyRetrieval=true&useSSL=false com.cloudera.cmf.orm.hibernate.connection.username=scm com.cloudera.cmf.orm.hibernate.connection.password=cloudera com.cloudera.cmf.db.setupType=EXTERNAL ---------------

VidyaSargur · Answer

@ecampos, Welcome to our community! To help you get the best possible answer, I have tagged our Cloudera Manager experts @paras @Majeti @_Umesh who may be able to assist you further.

Please feel free to provide any additional information or details about your query. We hope that you will find a satisfactory solution to your question.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.