question Re: Creating SCM configuration file in /etc/cloudera-scm-server in Support Questions

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

ecampos — Tue, 05 Nov 2024 18:26:52 GMT

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

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

VidyaSargur — Wed, 06 Nov 2024 10:03:37 GMT

@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.

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

vamsi_redd — Wed, 06 Nov 2024 10:30:51 GMT

It seems public key retreival is false. Please make it true using below in the db.properties

com.cloudera.cmf.db.type = mysql com.cloudera.cmf.orm.hibernate.connection.url=jdbc:mysql:///scm?allowPublicKeyRetrieval=true

com.cloudera.cmf.orm.hibernate.connection.username= com.cloudera.cmf.orm.hibernate.connection.password=

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

Kartik_Agarwal — Thu, 07 Nov 2024 16:47:51 GMT

@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
---------------

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

ecampos — Fri, 08 Nov 2024 23:08:40 GMT

my db.properties file :

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=Temporal_235

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

ecampos — Fri, 08 Nov 2024 23:11:04 GMT

I don't know if I should change or put the line that they indicate

com.cloudera.cmf.orm.hibernate.connection.url=jdbc:mysql://<db_host>/scm?allowPublicKeyRetrieval=true&useSSL=false

like:

com.cloudera.cmf.orm.hibernate.connection.url=jdbc:mysql://localhost/scm?allowPublicKeyRetrieval=true&useSSL=false

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

Kartik_Agarwal — Mon, 11 Nov 2024 10:21:45 GMT

@ecampos Yes try the same with localhost or IP.