Could not find value for key log4j.appender.A

2437 ワード
ClouderaManager ClouderaManager テキストリンク 
+ exec /usr/java/jdk1.8.0_232-cloudera/bin/java -Djava.net.preferIPv4Stack=true -Djava.security.egd=file:///dev/urandom -cp '/run/cloudera-scm-agent/process/35-OOZIE.OOZIE_SERVER-test-db-connection:/usr/share/java/mysql-connector-java.jar:/opt/cloudera/cm/lib/postgresql-42.1.4.jre7.jar:/usr/share/java/oracle-connector-java.jar:/opt/cloudera/cm/lib/*' com.cloudera.enterprise.dbutil.DbCommandExecutor db.properties
log4j:ERROR Could not find value for key log4j.appender.A
log4j:ERROR Could not instantiate appender named "A".

2019-11-27 23:29:17,062 ERROR CommandPusher:com.cloudera.cmf.model.DbCommand: Command 55(OozieTestDatabaseConnection) has completed. finalstate:FINISHED, success:false, msg:Logon denied for user/password. Able to find the database server and database, but the login request was rejected.
2019-11-27 23:29:19,157 INFO scm-web-446:com.cloudera.enterprise.JavaMelodyFacade: Entering HTTP Operation: Method:POST, Path:/dbTestConn/checkConnectionResult
2019-11-27 23:29:19,172 INFO scm-web-446:com.cloudera.enterprise.JavaMelodyFacade: Exiting HTTP Operation: Method:POST, Path:/dbTestConn/checkConnectionResult, Status:200
2019-11-27 23:29:19,237 INFO CommandPusher:com.cloudera.cmf.service.AbstractOneOffHostCommand: Unsuccessful 'HueTestDatabaseConnection'
2019-11-27 23:29:19,238 INFO CommandPusher:com.cloudera.cmf.service.AbstractDbConnectionTestCommand: Command exited with code: 1
2019-11-27 23:29:19,238 INFO CommandPusher:com.cloudera.cmf.service.AbstractDbConnectionTestCommand:     return self._cursor()

Cloudera ManagerでCDPインストールしたら、上記エラーが出ました。
対策：
https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_ig_mysql.html
MySQLのJava Connectorが古すぎるから。

sudo yum install mysql-connector-java* -y
cd ~/
mkdir tools/
cd tools/
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gz
tar zxvf mysql-connector-java-5.1.46.tar.gz
sudo mkdir -p /usr/share/java/
cd mysql-connector-java-5.1.46
sudo cp mysql-connector-java-5.1.46-bin.jar /usr/share/java/mysql-connector-java.jar